SQL-VP-019 Retrieve the wrapup legal name for a policy¶
Used by clsPolicyData.GetWrapupLegalName() to resolve the legal name for a wrapup-type policy
association.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-VP-019 |
| Operation type | Read |
| Execution method | Stored procedure (scalar function via ReturnValue) |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | StoredProcedure |
| Business object | clsPolicyData |
| Criteria property | GetWrapupLegalName() (ad hoc method) |
| Lifecycle method | ad hoc method |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
in_policy_num |
Input | Decimal | N/A | Policy number. |
v_wrapup_legal_name |
ReturnValue | String | N/A | The resolved wrapup legal name. |
Tables¶
| Table | Access | Columns used |
|---|---|---|
| (not directly visible — encapsulated in procedure body) | SELECT | N/A |
Sample SQL¶
BEGIN
:v_wrapup_legal_name := pk72846_view_policy.getwrapuplegalname(
in_policy_num => :in_policy_num
);
END;
Call signature reconstructed from DataRequest.SQLStatement/AddParm calls; the procedure body
resides in the Oracle database and was not retrieved this run.
Note: Statements marked with
*were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with**could not be confirmed; treat as unknown until verified.
Sources¶
SAIF.Business.View.Policy\clsPolicyData.vb