Skip to content

DB-CLL-014 — Insert an appeal extension record

Classification

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

Parameters

Name Direction Type Default Description
AppealID Input NUMBER N/A Owning appeal identifier
ExtensionDate Input DATE N/A New extension date
ReasonCode Input VARCHAR2 N/A Reason code for the extension
CreateUser Input VARCHAR2 N/A User creating the extension row
CreateDate Input DATE N/A Row creation timestamp

Tables

Table Access Columns/Notes
APPEAL_EXTENSION INSERT 5 columns

Sample SQL

EXEC pk80001_legalnet.insertAppealExtension(:AppealID, :ExtensionDate, :ReasonCode,
  :CreateUser, :CreateDate);

Operations and processes

Business rules

Sources

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