SQL-048 Set an award status to Pending¶

Sets an award's status to Pending; unlike other update statements in this library, no UPDATE_NUM predicate protects this update from concurrent overwrite.*

Classification¶

Field	Value
SQL ID	SQL-048
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsSetAwardPaymentPending`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate`

Parameters¶

Parameter	Direction	Type	Max length	Description
`UpdateUser`	Input	String	30	Auditing user (AWARD_STATUS_CODE = 'P' is literal)
`ClaimID`	Input	Decimal	—	Row key
`AwardNum`	Input	Decimal	—	Row key — no UPDATE_NUM contention predicate in the WHERE clause

Tables¶

Table	Access	Columns used
CL_AWARD	UPDATE	AWARD_STATUS_CODE, UPDATE_NUM, UPDATE_USER_ID, UPDATE_DATE, CLAIM_ID, SAIF_AWARD_NUM

Sample SQL¶

-- Set award status to Pending (no optimistic-concurrency predicate)
Update CL_AWARD
   Set AWARD_STATUS_CODE = 'P',
       UPDATE_NUM        = UPDATE_NUM + 1,
       UPDATE_USER_ID    = :UpdateUser,
       UPDATE_DATE       = SYSDATE
 Where CLAIM_ID       = :ClaimID
   And SAIF_AWARD_NUM = :AwardNum

Operations and processes¶

Set award to Pending

Business rules¶

BR-011: Award must be successfully updated to pending

Sources¶

SAIF.Business.Claim/clsSetAwardPaymentPending.vb