SAIF.Application.Claim.Legal stored procedures

This page catalogs Oracle package members invoked by this library from the WCIS_DBA.pk80001_legalnet package. Real Oracle PL/SQL source was retrieved for the package via the Legends CLI (legends oracle query --name pk80001_legalnet, schema WCIS_DBA) on 2026-08-31: both package specification and body were returned (98 enumerated members, 148,911 characters total). insertLetterRequest is a confirmed member with extracted signature and verified call sites. getHeader references by the calling code but is not present in the retrieved package artifact — this is documented as a member-level absence (not-found-by-cli status) within an otherwise-found package. get_atty_mngr_email is unchanged as per task scope.

Procedure catalog

Package / Procedure	Schema	Type	Purpose	Calling business objects
insertLetterRequest	WCIS_DBA	PROCEDURE	CommandType.StoredProcedure via IPortalRequest / IDataRequest supporting LegalManagerBase; creates a LETTER_REQUEST row and returns its newly generated sequence number. Letter type codes: RREQ (recon request), DEFLT (Defense Eval Form).	clsRequestManager, clsScheduleManager
getHeader	WCIS_DBA	PROCEDURE (inferred from caller)	CommandType.StoredProcedure + AddCursorParm via SqlHelper.ResultSetQuery supporting clsLegalData; retrieves legal-case header information — case number, attorney name, case status, hearing date. Member not present in retrieved package.	clsLegalData
get_atty_mngr_email	WCIS_DBA	FUNCTION	Scalar query against Oracle DUAL that calls pk80001_LEGALNET.get_atty_mngr_email to resolve the DEF notification recipient for clsScheduleManager	clsScheduleManager

Related documentation

• Index
• Overview
• Operations and processes
• Business rules
• Database tables
• SQL catalog
• API reference

Sources

• SAIF.Application.Claim.Legal\LegalManagerBase.vb (insertLetterRequest wrapper and call site via clsRequestManager.vb:261)
• SAIF.Application.Claim.Legal\clsLegalData.vb (getHeader call site, constructor, result-set reader)
• SAIF.Application.Claim.Legal\LegalNet\clsScheduleManager.vb (insertLetterRequest call site for DEFLT letter type)
• SAIF.Application.Claim.Legal\clsRequestManager.vb (insertLetterRequest call site for RREQ letter type)
• Oracle Legends CLI query: legends oracle query --name pk80001_legalnet (2026-08-31T21:20:00Z)