SQL-019 Execute caller-supplied dynamic claim-list SQL¶

Executes an entire SQL statement supplied by the caller to build a claim list; no static SQL exists in this library, and every IBusinessCriteria property throws.

Classification¶

Field	Value
SQL ID	SQL-019
Operation type	Read
Execution method	Inline SQL (caller-supplied)
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsClaimListGenerator`
Criteria property	`(all five properties throw ApplicationException)`
Lifecycle method	`BeforeRetrieve`

Parameters¶

Parameter	Direction	Type	Max length	Description
`ID`	Input	Decimal	N/A	Caller-supplied key bound into the caller-supplied SQL statement

Tables¶

Table	Access	Columns used
(caller-determined)	SELECT	Caller-defined; result columns mapped via ClaimIDSQLItem, ClaimNumberSQLItem, ClaimChkCharValueSQLItem, WorkerIDSQLItem alias properties

Sample SQL¶

-- Caller-supplied SQL statement (illustrative call signature)
-- clsClaimListGenerator.GetClaimListCollection(dpi, inSQLStatement, inID, inRequestID)
-- Criteria.SQLStatement = inSQLStatement
-- Single bind variable: :ID  (value = inID)
-- All five IBusinessCriteria SQL properties throw ApplicationException.

Operations and processes¶

Dynamic claim list generation

Sources¶

SAIF.Business.Claim/clsClaimListGenerator.vb