DB-CLL-012 — Delete an appeal record

Classification

Field	Value
SQL ID	DB-CLL-012
Operation type	D
Execution method	StoredProc
Database	Oracle (Case Management)
Schema	[unqualified]**
Command type	Stored procedure call
Business object	clsAppeal
Criteria property	DeleteSQL
Lifecycle method	BeforeDelete

Parameters

Name	Direction	Type	Default	Description
AppealID	Input	NUMBER	N/A	Appeal identifier to delete
LegalCaseID	Input	NUMBER	N/A	Owning legal case identifier
UpdateUser	Input	VARCHAR2	N/A	User performing the delete

Tables

Table	Access	Columns/Notes
APPEAL	DELETE	AppealID

Sample SQL

EXEC pk80001_legalNet.DeleteAppeal(:AppealID, :LegalCaseID, :UpdateUser);

Operations and processes

• Manage appeals and appeal extensions

Business rules

• BR-CLM-LGL-005

Sources

• SAIF.Business.Claim.Legal\LegalNet\clsAppeal.vb