Skip to content

pk72195_renewal.sp72190_calc_weighted_freq

Overview

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

Purpose

Remote passthrough to POLDB for renewal weighted-frequency calculation

Procedures / Methods

sp72190_calc_weighted_freq

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

Description: Remote passthrough to POLDB for renewal weighted-frequency calculation

Parameters

Parameter Direction Type Default Description
in_policy_num IN NUMBER — Policy number whose weighted claim frequency is being calculated.
in_renewal_date IN DATE — Renewal or policy-period effective date passed to the renewal calculation.
in_process_mode IN VARCHAR2 — Processing-mode code that selects the procedure behavior; clsPolicyPeriod passes ONLIN.

Business Rules

Rule ID Rule Condition Action
PROC-RULE-002 Weighted claim frequency is not computed locally Always Delegate to WCIS_DBA.PK72195_RENEWAL.SP72190_CALC_WEIGHTED_FREQ@POLDB and return its value - the rule lives in the remote POLDB database and is not documentable from this repository

Operations

Operation Description Trigger
Calculate weighted claim frequency Remote passthrough to POLDB for renewal weighted-frequency calculation clsPolicyPeriod.GetWeightedFrequency (SQL-081) with in_process_mode = 'ONLIN'

Source Code

PL/SQL source 
FUNCTION sp72190_calc_weighted_freq (
      in_policy_num IN NUMBER,
      in_renewal_date IN DATE,
      in_process_mode IN VARCHAR2
      )
      RETURN NUMBER
   IS


   BEGIN

   RETURN WCIS_DBA.PK72195_RENEWAL.SP72190_CALC_WEIGHTED_FREQ@POLDB(in_policy_num,in_renewal_date,in_process_mode);


   END sp72190_calc_weighted_freq;

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: pk72195_renewal.sp72190_calc_weighted_freq
  • Business\SAIF.Business.Policy.Core\clsPolicyPeriod.vb