Skip to content

SQL-118: Call SAIF Plus procedure

Call SAIF Plus procedure in the context of clsPremiumSummaryAdjustment.

Classification

Field Value
SQL ID SQL-118
Operation type Read
Execution method StoredProcedure
Database Oracle
Command type StoredProcedure
Schema Oracle package / procedure
Business object N/A (Application layer)
Criteria property RetrieveSAIFPlusSQL
Lifecycle method Application-layer method: clsPremiumSummaryAdjustment.GetSAIFPlusInfo()

Parameters

Parameter Direction Type Max length Description
:in_policy_num Input Numeric — Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSummaryAdjustment.vb.
:in_policy_period_eff_date Input Date — Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSummaryAdjustment.vb.
:out_pp_eff_date Output Date — Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSummaryAdjustment.vb.
:out_saifplus_eff_date Output Date — Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSummaryAdjustment.vb.
:out_saifplus_desc Output String 100 Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSummaryAdjustment.vb.
:out_saifplus_rate Output Numeric — Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSummaryAdjustment.vb.
:out_saifplus_max Output Numeric — Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSummaryAdjustment.vb.
:out_saifplus_combo_max Output Numeric — Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSummaryAdjustment.vb.

Tables

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

Sample SQL

EXEC sp72652_get_saifplus (
  in_policy_num,
  in_policy_period_eff_date,
  out_pp_eff_date,
  out_saifplus_eff_date,
  out_saifplus_desc,
  out_saifplus_rate,
  out_saifplus_max,
  out_saifplus_combo_max
)

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/clsPremiumSummaryAdjustment.vb