SQL-008 Get policy address by location sequence number¶
Retrieve a policy address by location sequence number.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-008 |
| Operation type | Read |
| Execution method | Stored procedure |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | StoredProcedure |
| Business object | clsPolicyAddress |
| Criteria property | RetrieveAddressByLocationSeqNum |
| Lifecycle method | BeforeRetrieve (location-seq branch) |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:inLocationSeqNum |
Input | Decimal | N/A | Location sequence number |
recordset |
Output (Cursor) | REF CURSOR | N/A | Address row |
Tables¶
N/A — Stored procedure
Sample SQL¶
-- Oracle stored procedure call (CommandType.StoredProcedure)
-- clsPolicyAddress.BeforeRetrieve (LocationSeqNum branch)
CALL pk72846_view_policy.getPolicyAddressByLocSeqNum(
:inLocationSeqNum,
:recordset)
Operations and processes¶
Business rules¶
Sources¶
SAIF.Business.View.Policy/clsPolicyAddress.vb