SQL-009 pk80001_legalNet.getHeader

StoredProc (CommandType.StoredProcedure + AddCursorParm, SqlHelper.ResultSetQuery) for clsLegalData.

Classification

Field	Value
SQL ID	SQL-009
Operation type	Read
Execution method	StoredProc (CommandType.StoredProcedure + AddCursorParm, SqlHelper.ResultSetQuery)
Database	Oracle
Schema	N/A
Command type	StoredProcedure
Business object	clsLegalData
Criteria property	RetrieveSQL (plain property, not IBusinessCriteria)
Lifecycle method	New(inDatabase, inSecurityPrincipal) constructor path that instantiates clsLegalData during case selection

Parameters

Parameter	Direction	Type	Max length	Description
aLegalCaseNum	Input	Numeric (Decimal)	N/A	Legal case sequence number whose header data is requested
recordset	Output (REF CURSOR)	Oracle SYS_REFCURSOR (AddCursorParm)	N/A	Result cursor returning CaseNum, AttyName, CaseStatus, HearingDate

Tables

Table	Access	Columns used
(procedure body opaque)	Stored procedure	N/A

Sample SQL

-- CommandType.StoredProcedure; procedure body resides in the Oracle database.
-- Executed via SqlHelper.ResultSetQuery; returns a REF CURSOR bound as "recordset".
CALL pk80001_legalNet.getHeader(
  aLegalCaseNum => :aLegalCaseNum,
  recordset     => :recordset)  -- OUT SYS_REFCURSOR
-- Cursor columns consumed by clsLegalData: CaseNum, AttyName, CaseStatus, HearingDate

Operations and processes

• Legal case header display (LegalManagerBase.CreateCase / SetCurrentCase construct clsLegalData)

Sources

• SAIF.Application.Claim.Legal\clsLegalData.vb