DB-CLL-008 — Update an acknowledgement record for a case
Classification
| Field |
Value |
| SQL ID |
DB-CLL-008 |
| Operation type |
U |
| Execution method |
StoredProc |
| Database |
Oracle (Case Management) |
| Schema |
[unqualified]** |
| Command type |
Stored procedure call |
| Business object |
clsAcknowledge |
| Criteria property |
UpdateSQL |
| Lifecycle method |
BeforeUpdate |
Parameters
| Name |
Direction |
Type |
Default |
Description |
| inType |
Input |
VARCHAR2 |
N/A |
Acknowledgement type code |
| inNum |
Input |
VARCHAR2 |
N/A |
Case/claim identifier |
| InDate |
Input |
DATE |
N/A |
Acknowledgement date |
| CaseId |
Input |
NUMBER |
N/A |
LEGAL_CASE_SEQ_NUM of the related legal case |
Tables
| Table |
Access |
Columns/Notes |
| ACKNOWLEDGE |
UPDATE |
inType, inNum, InDate, CaseId (inferred*) |
Sample SQL
EXEC Pk80001_Legalnet.updateAcknowledged(:inType, :inNum, :InDate, :CaseId);
Operations and processes
Business rules
Sources
SAIF.Business.Claim.Legal\LegalNet\clsAcknowledge.vb