SQL-034: Billing plan type retrieval¶
Calls the Oracle stored procedure pk72971_epay_policy.get_policy_billing_plan_type to retrieve the billing plan type for a policy. The procedure body resides in the Oracle database and was not retrieved in the analysis pass.**
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-034 |
| Operation type | Read |
| Execution method | Stored procedure |
| Database | Oracle |
| Schema | [unknown]** |
| Command type | StoredProcedure |
| Business object | clsUserType |
| Criteria property | Local SQL |
| Lifecycle method | IsBillingPlanEstablished |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:in_policy_num |
Input | Decimal | 10 | Policy number to retrieve billing plan type for. |
:return_value |
ReturnValue | String | N/A | Return value from the procedure.** |
Tables¶
This statement calls Oracle package pk72971_epay_policy. The package body resides in the Oracle database and is not available in the repository source; table-level access within the package cannot be determined from this library.**
Sample SQL¶
-- Stored procedure call
pk72971_epay_policy.get_policy_billing_plan_type(:in_policy_num, :return_value)
-- Procedure body resides in Oracle database
Operations and processes¶
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¶
Business\SAIF.Business.External.Users\clsUserType.vb