Skip to content

DB-CLL-015 — Update an appeal extension record

Classification

Field Value
SQL ID DB-CLL-015
Operation type U
Execution method StoredProc
Database Oracle (Case Management)
Schema [unqualified]**
Command type Stored procedure call
Business object clsAppealExtension
Criteria property UpdateSQL
Lifecycle method BeforeUpdate

Parameters

Name Direction Type Default Description
AppealID Input NUMBER N/A Owning appeal identifier
ExtensionDate Input DATE N/A Updated extension date
ReasonCode Input VARCHAR2 N/A Reason code for the extension
UpdateUser Input VARCHAR2 N/A User performing the update
UpdateDate Input DATE N/A Update timestamp

Tables

Table Access Columns/Notes
APPEAL_EXTENSION UPDATE 5 columns

Sample SQL

EXEC pk80001_legalnet.updateAppealExtension(:AppealID, :ExtensionDate, :ReasonCode,
  :UpdateUser, :UpdateDate);

Operations and processes

Business rules

Sources

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