SQL-135: clsFinancialTransDtlCollection

This statement supports clsFinancialTransDtlCollection by executing a Other operation through inline.

Classification

Field	Value
SQL ID	SQL-135
Operation type	Other
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsFinancialTransDtlCollection
Criteria property	RetrieveSQL
Lifecycle method	BeforeRetrieve

Parameters

Parameter	Direction	Type	Max length	Description
:claimFinancialTransSeqNum	Input	Unknown	—	Passed from clsFinancialTransDtlCollection via BeforeRetrieve.
:financialTransTypeCode	Input	Unknown	—	Passed from clsFinancialTransDtlCollection via BeforeRetrieve.
:claimID	Input	Unknown	—	Passed from clsFinancialTransDtlCollection via BeforeRetrieve.
:inIssueDate	Input	Unknown	—	Passed from clsFinancialTransDtlCollection via BeforeRetrieve.
recordset	Output	REF CURSOR	—	Passed from clsFinancialTransDtlCollection via BeforeRetrieve.

Tables

Table	Access	Columns used
CL_FINANCIAL_TRANS_DTL	Other	Not enumerated directly in the stage findings.**

Sample SQL

-- When retrieving by claim or by claim plus issue date
EXEC pk82343_financial_trans.CL_FINANCIAL_TRANS_DTL_SEL_CLM(claimID => :claimID, inIssueDate => :inIssueDate, recordset => :recordset);

-- When retrieving by financial transaction sequence and type
EXEC pk82343_financial_trans.CL_FINANCIAL_TRANS_DTL_SELECT(claimFinancialTransSeqNum => :claimFinancialTransSeqNum, financialTransTypeCode => :financialTransTypeCode, recordset => :recordset);

Operations and processes

• clsFinancialTransDtlCollection BeforeRetrieve

Note: Statements marked with ** could not be confirmed; treat them as unknown until verified.

Sources

• Business/SAIF.Business.Claim.Payment/FinancialTransaction/clsFinancialTransDtlCollection.vb