Skip to content

SQL-120: Call tier recalculation procedure

Call tier recalculation procedure in the context of clsPremiumSet.

Classification

Field Value
SQL ID SQL-120
Operation type Read
Execution method StoredProcedure
Database Oracle
Command type StoredProcedure
Schema Oracle package / procedure
Business object N/A (Application layer)
Criteria property CALC_MANUAL_ON_SPECIFIED_TIER
Lifecycle method Application-layer method: clsPremiumSet.GetRecalcModifiedPremiumOnSpecifiedTier()

Parameters

Parameter Direction Type Max length Description
:in_policy_num Input Numeric — Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSet.vb.
:in_policy_period_eff_date Input Date — Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSet.vb.
:in_prem_hist_set_id Input Numeric — Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSet.vb.
:in_calculate_tier Input String 1 Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSet.vb.
:out_manual_premium ReturnValue Numeric — Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSet.vb.

Tables

Table Access Columns used
N/A Stored procedure Procedure body resides in Oracle; see pk72195_renewal.

Sample SQL

EXEC pk72195_renewal.calc_manual_on_specified_tier[@POLDB] (
  in_policy_num,
  in_policy_period_eff_date,
  in_prem_hist_set_id,
  in_calculate_tier,
  out_manual_premium
)

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.Policy.Premium/clsPremiumSet.vb