SQL-013 Calculate aggravation-rights dates
Calls the Oracle stored procedure that calculates a claim's aggravation-rights dates via a REF CURSOR result.
Classification
| Field |
Value |
| SQL ID |
SQL-013 |
| Operation type |
Read |
| Execution method |
Stored procedure |
| Database |
Oracle |
| Schema |
[unqualified]** |
| Command type |
StoredProcedure |
| Business object |
clsAggRightDates |
| Criteria property |
(procedure — no SQL property) |
| Lifecycle method |
BeforeRetrieve |
Parameters
| Parameter |
Direction |
Type |
Max length |
Description |
inClaimID |
Input |
Decimal |
N/A |
Claim identifier passed to the aggravation-rights procedure |
recordset |
Output (Cursor) |
REF CURSOR |
N/A |
Result cursor (AddCursorParm) |
Tables
| Table |
Access |
Columns used |
|
|
|
Sample SQL
-- Stored procedure call — sp82046_CalcAggRightDates
CALL sp82046_CalcAggRightDates(:inClaimID, :recordset)
Procedure body resides in the Oracle database and could not be retrieved in this environment.
Operations and processes
Business rules
Sources
- SAIF.Business.Claim/clsAggRightDates.vb