SQL-005: Read via pk83407_payment_hist_trans.getPayRemarks¶

This SQL document describes how clsFinancialTransaction uses the stored procedure pk83407_payment_hist_trans.getPayRemarks to support claim-domain read behavior.

Classification¶

Field	Value
SQL ID	SQL-005
Operation type	Read
Execution method	StoredProc
Database	Oracle
Schema	N/A
Command type	StoredProcedure
Business object	`clsFinancialTransaction`
Criteria property	`GetPayRemarks`
Lifecycle method	`Cls Financial Transaction read`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:inClaimFinancialTransSeqNum`	Input	N/A	N/A	Financial transaction sequence number used to retrieve payment remarks.
`:inTransTypeCode`	Input	N/A	N/A	Transaction type code used to retrieve payment remarks.
`:retval`	Output	REF CURSOR / return value	N/A	Procedure result payload returned by the Oracle package.

Tables¶

Table	Access	Columns used
Stored procedure-owned tables not available	Stored procedure	Oracle source was not available during Stage 1b retry.

Sample SQL¶

BEGIN pk83407_payment_hist_trans.getPayRemarks(:inClaimFinancialTransSeqNum, :inTransTypeCode, :retval); END;
-- Oracle source not found; calling code is possibly dead code.

Operations and processes¶

Financial transaction retrieval

Sources¶

Business\SAIF.Business.View.Claim\clsFinancialTransaction.vb