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
Sample SQL
EXEC pk80001_legalnet.insertAppealExtension(:AppealID, :ExtensionDate, :ReasonCode,
:CreateUser, :CreateDate);
Operations and processes
Business rules
Sources
SAIF.Business.Claim.Legal\LegalNet\clsAppeal.vb