SQL-027: clsCreditCardPayment¶

This statement supports clsCreditCardPayment by executing a Update operation through storedproc.

Classification¶

Field	Value
SQL ID	SQL-027
Operation type	Update
Execution method	Stored procedure
Database	Oracle
Schema	[unqualified]**
Command type	StoredProcedure
Business object	`clsCreditCardPayment`
Criteria property	`SQLStatement`
Lifecycle method	`SQLStatement`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:ExpenseId`	Input	Number	N/A	Binds ExpenseId from active calling code or Oracle signature.
`:StatusCode`	Input	String	N/A	Binds StatusCode from active calling code or Oracle signature.
`:UPDATEUSER`	Input	Date	N/A	Binds UPDATEUSER from active calling code or Oracle signature.
`:UPDATEDATE`	Input	Date	N/A	Binds UPDATEDATE from active calling code or Oracle signature.
`:UPDATENUM`	Input	Date	N/A	Binds UPDATENUM from active calling code or Oracle signature.
`:LastUpdateNum`	Input	Date	N/A	Binds LastUpdateNum from active calling code or Oracle signature.

Tables¶

Table	Access	Columns used
`EAIP_EXPENSE*`	Update*	ExpenseId, StatusCode, UPDATEUSER, UPDATEDATE, UPDATENUM, LastUpdateNum*

Sample SQL¶

pk82500_eaip.update_expense_status(:ExpenseId, :StatusCode, :UPDATEUSER, :UPDATEDATE, :UPDATENUM, :LastUpdateNum)

-- Procedure body resides in Oracle.

Operations and processes¶

clsCreditCardPayment update

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Business\SAIF.Business.Claim.EAIP\Period\clsCreditCardPayments.vb