Skip to content

pk73059_prem_hist_summary.determine_manual_premium

Overview

Field Value
Schema WCIS_DBA
Type Package function (remote wrapper @POLDB)
Database Oracle
Calling libraries SAIF.Business.Policy.Core
Calling classes WCISInquiry

Purpose

Remote passthrough to POLDB for manual premium

Procedures / Methods

determine_manual_premium

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

Description: Remote passthrough to POLDB for manual premium

Parameters

Parameter Direction Type Default Description
in_policy_num IN policy.policy_num%TYPE — Policy number whose manual premium is being determined.
in_policy_period_eff_date IN policy_period.policy_period_eff_date%TYPE — Policy-period effective date that scopes the premium-history lookup.

Business Rules

Rule ID Rule Condition Action
PROC-RULE-017 Manual premium is not computed locally Always Delegate to WCIS_DBA.PK73059_Prem_Hist_Summary.determine_manual_premium@POLDB; the rule lives in the remote POLDB database - not documentable from this repository

Operations

Operation Description Trigger
Determine manual premium Remote passthrough to POLDB for manual premium WCISInquiry.GetManualPremiumAmount (SQL-110); also called internally by regional_office_yn

Source Code

PL/SQL source 
FUNCTION determine_manual_premium(
      in_policy_num               IN policy.policy_num%TYPE
    , in_policy_period_eff_date   IN policy_period.policy_period_eff_date%TYPE)
      RETURN NUMBER
   IS

  BEGIN

     RETURN WCIS_DBA.PK73059_Prem_Hist_Summary.determine_manual_premium@POLDB(in_policy_num, in_policy_period_eff_date);

   END  determine_manual_premium;

   /********************************************************************
   | Procedure Title   : Get standard premium for a premium history set.
   | Name              : get_standard_premium
   | Prepared By       : carade
   | Created           : 12/09/2008
   | Modification History
   | ------------------------------------------------------------------
   |
   | Description :
   | Returns the standard premium from a premium history set for a type 1 or 3 set.
   *******************************************************************/

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: pk73059_prem_hist_summary.determine_manual_premium
  • Business\SAIF.Business.Policy.Core\WCISInquiry.vb