SQL-053 Delete an active benefit schedule¶

Deletes an active benefit-schedule row, guarded by optimistic concurrency. Uses Oracle DELETE without FROM.

Classification¶

Field	Value
SQL ID	SQL-053
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsActiveBenefitSchedule`
Criteria property	`DeleteSQL`
Lifecycle method	`BeforeDelete`

Parameters¶

Parameter	Direction	Type	Max length	Description
`ClaimID`	Input	Decimal	—	Row key
`BenefitPaymentSeqNum`	Input	Decimal	—	Row key
`UpdateNum`	Input	Decimal	—	Optimistic-concurrency check value

Tables¶

Table	Access	Columns used
CL_BENEFIT_SCHEDULE	DELETE	CLAIM_ID, BENEFIT_PAYMENT_SEQ_NUM, UPDATE_NUM

Sample SQL¶

-- Delete active benefit schedule (Oracle DELETE without FROM)
Delete CL_BENEFIT_SCHEDULE
 Where CLAIM_ID                = :ClaimID
   And BENEFIT_PAYMENT_SEQ_NUM = :BenefitPaymentSeqNum
   And UPDATE_NUM              = :UpdateNum

Operations and processes¶

Benefit-payment stop processing

Business rules¶

BR-012: Optimistic concurrency contention check

Sources¶

SAIF.Business.Claim/clsActiveBenefitSchedule.vb