SQL-012: Delete US Bank nonpay notice

Delete a row from US_BANK_NONPAY_NOTICE by primary key.

Classification

Field	Value
SQL ID	SQL-012
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	Unqualified in library SQL
Command type	Text
Business object	clsUSBankNonpayNotice
Criteria property	DeleteSQL
Lifecycle method	BeforeDelete

Parameters

Parameter	Direction	Type	Max length	Description
:USBankNonpayNoticeSeqNum	Input	Decimal	N/A	Primary key for notice deletion.

Tables

Table	Access	Columns used
US_BANK_NONPAY_NOTICE	DELETE	US_BANK_NONPAY_NOTICE_SEQ_NUM

Sample SQL

DELETE US_BANK_NONPAY_NOTICE
WHERE US_BANK_NONPAY_NOTICE.US_BANK_NONPAY_NOTICE_SEQ_NUM = :USBankNonpayNoticeSeqNum

Operations and processes

• Persist and retrieve SAIF-side integration records

Business rules

• BR-008: Notice deletes must affect exactly one row

Sources

• Business\SAIF.Business.EPay.USBank\clsUSBankNonpayNotice.vb