Skip to content

SP72658_GET_GOV_CLASS

Overview

Field Value
Schema (unqualified; standalone)
Type Standalone function (wrapper for pk62030_rating.SP62022_Get_Gov_Class)
Database Oracle
Calling libraries SAIF.Business.Policy.Core
Calling classes clsPolicyPeriod

Purpose

Calls the rating package and returns only the governing class, discarding the minimum premium

Procedures / Methods

SP72658_GET_GOV_CLASS

Field Value
Returns See PL/SQL source below.
Called by clsPolicyPeriod

Description: Calls the rating package and returns only the governing class, discarding the minimum premium

Parameters

Parameter Direction Type Default Description
in_policy_num IN NUMBER — Policy number whose governing class is being returned.
in_pol_per_eff_date IN DATE — Policy-period effective date used to select the governing class row.

Business Rules

Rule ID Rule Condition Action
PROC-RULE-025 The WCIS governing class is delegated to the rating package; the minimum premium it also returns is discarded Always Call pk62030_rating.SP62022_Get_Gov_Class(policy, eff_date, v_dummy_1, v_gov_class) and return only v_gov_class

Operations

Operation Description Trigger
Retrieve the WCIS governing class Calls the rating package and returns only the governing class, discarding the minimum premium clsPolicyPeriod.GetGoverningClass (SQL-079)

Source Code

PL/SQL source 
FUNCTION SP72658_GET_GOV_CLASS
/****************************************************************
*Procedure Title  : Get Governing Class
*Name             : SP72658_GET_GOV_CLASS
*Called by        : Premium Audit (PowerBuilder)
*****************************************************************
* Description:  Enables PowerBuilder to call a stored procedure
*               in the Oracle package to get the governing class
*               for a policy period.
* Maintenance Log:
*   Name            CSR        Date     Description
* Lance Petersen            07/08/2002  Initial Release
*
* carade                    12/07/2009  Trackit project 1626 (variable minimum)
* Renamed sp62022 and removed minimum premium as an out variable.

******************************************************************/
  (in_policy_num        IN      NUMBER,
   in_pol_per_eff_date  IN      DATE)

RETURN VARCHAR2
IS

  v_dummy_1 NUMBER;
  v_dummy_2 NUMBER;
  v_gov_class VARCHAR(6);

BEGIN

   pk62030_rating.SP62022_Get_Gov_Class
             (in_policy_num,
              in_pol_per_eff_date,
              v_dummy_1,
              v_gov_class);

  RETURN v_gov_class;

END  ;

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

  • Oracle DBA_SOURCE: SP72658_GET_GOV_CLASS
  • Business\SAIF.Business.Policy.Core\clsPolicyPeriod.vb