PK72846_VIEW_POLICY

Overview

Field	Value
Schema	WCIS_DBA
Type	Package (function) (database object type: PACKAGE)
Database	Oracle (WCIS)
Calling libraries	SAIF.Data.NHibernate
Calling classes	PoliciesRepository

Purpose

This package implements: SP73111_GET_WCIS_STD_PREMIUM

Scope: PK72846_VIEW_POLICY is a large package (34 members). Only the 1 member(s) actually called by SAIF.Data.NHibernate (sp73111_get_wcis_std_premium) are reproduced below, extracted from the Legends CLI retrieval's per-member codeItems; the full package specification/body is not reproduced in this document. This is a deliberate scoping decision for readability, not a retrieval gap — the full source is available at the retrieval path in Sources.

Procedures / Methods

sp73111_get_wcis_std_premium member

Field	Value
Returns	scalar/function value*
Called by	SQL-035 (PoliciesRepository.GetPolicyStandardPremium)

No parameters were extracted from the retrieved signature; refer to the Source Code section below*.

Business Rules

Rules extracted from this procedure's logic:

Rule ID	Rule	Condition	Action
PROC-RULE-040	Standard premium from the latest premium-history set	Policy + period effective date	RETURN pk73059_prem_hist_summary.get_standard_premium(get_max_ph_set_id(in_policy_num, in_pol_per_eff_date)) (pk73059 not retrieved**)
PROC-RULE-041	Shared logic with BDS	Any change	Header comment: changes must be coordinated with BDS

These rules are documented in business-rules.md.

Operations

Operations and processes implemented in this procedure:

Operation	Description	Trigger
Get WCIS standard premium	Returns standard premium for a policy period	SQL-035 (PoliciesRepository.GetPolicyStandardPremium)

These operations are also listed in operations-processes.md.

Source Code

sp73111_get_wcis_std_premium (function)

   FUNCTION sp73111_get_wcis_std_premium
/****************************************************************
*Procedure Title  : Get WCIS Standard Premium
*Name             : SP73111_GET_WCIS_STD_PREMIUM
*Called by        : Business Online
*****************************************************************
* Description: This procedure gets the Standardized Standard Premium
*               based on the 9/8/07 New Standard Premium Project.
*
*               THIS LOGIC IS ALSO USED IN BDS.  IF YOU CHANGE THIS
*               YOU MUST CORRODINATE WITH THE BDS TEAM.
*
*               It gets the max premium history set for the policy
*               and policy period passed in.  It uses the Prem_Summary
*               view to define the correct set.
*
* Maintenance Log:
*   Name            CSR        Date     Description
* John Frey                 09/08/2007  Initial Release
******************************************************************/
   (
      in_policy_num         IN   NUMBER,
      in_pol_per_eff_date   IN   DATE
   )
      RETURN NUMBER
   IS
   BEGIN
      RETURN pk73059_prem_hist_summary.get_standard_premium(
                     pk73059_prem_hist_summary.get_max_ph_set_id(in_policy_num,in_pol_per_eff_date));
   END sp73111_get_wcis_std_premium;

/* Formatted on 4/23/2020 4:26:52 PM (QP5 v5.256.13226.35510) */

Related Documentation

• Procedure catalog
• Business rules
• Operations and processes
• SQL catalog

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: WCIS_DBA.PK72846_VIEW_POLICY
• Legends CLI query executed 2026-09-24: legends oracle query --name PK72846_VIEW_POLICY --output analysis/oracle-source/pk72846-view-policy.sql
• Calling code: Data/SAIF.Data.NHibernate/Mappings/Policies/Policies.hbm.xml
• Calling code: Data/SAIF.Data.NHibernate/Repositories/PoliciesRepository.cs