Skip to content

SAIF.Business.Policy.Core stored procedures

This page catalogs Oracle stored procedures and PL/SQL package members invoked by this library.

Procedure catalog

Package / Procedure Schema Type Purpose Calling business objects
pk72195_renewal.sp72187_get_standard_prem WCIS_DBA Package function Sums premium-summary difference amounts up to the experience-modification priority for one premium-history set clsPolicyPeriod
pk72195_renewal.sp72190_calc_weighted_freq WCIS_DBA Package function (remote wrapper @POLDB) Remote passthrough to POLDB for renewal weighted-frequency calculation clsPolicyPeriod
pk72226_team_assignment.regional_office_yn WCIS_DBA Package function Applies four ordered tests (premium threshold, temp agency, FELA/Maritime jurisdiction, entity 50) to decide regional-office handling WCISInquiry
pk72846_view_policy.sp73111_get_wcis_std_premium WCIS_DBA Package function Resolves the latest premium-history set for the period and returns its standard premium clsPolicyPeriodBase
pk72899_production_error.sp72900_post_production_error WCIS_DBA Package procedure (autonomous transaction) Writes a module/error row in an autonomous transaction so the log survives caller rollback clsWCISInterfacer
pk73057_billing_master.bm_report_schedule_flag_yn WCIS_DBA Package function Walks billing master → billing defaults → payment-plan type to read the payroll-report-schedule flag clsPolicyPeriodBase
pk73057_billing_master.is_on_arrears_plan WCIS_DBA Package function Same join path; classifies the plan as arrears unless it generates instalments or prepayments clsPolicyPeriodBase
pk73059_prem_hist_summary.determine_manual_premium WCIS_DBA Package function (remote wrapper @POLDB) Remote passthrough to POLDB for manual premium WCISInquiry
pk73059_prem_hist_summary.get_6_digit_gov_class WCIS_DBA Package procedure (OUT parameter) Picks the manual class with the greatest summed payroll in the latest premium-history set, excluding clerical/sales/drivers, with two fallback passes clsPolicyPeriod
pk73190_quoteprint.Get_Billing_Master_Count WCIS_DBA Package function (remote wrapper @POLDB) Remote count wrapper used to decide whether billing data exists for a quote WCISInquiry
pk73190_quoteprint.Get_Premium_History_Count WCIS_DBA Package function (remote wrapper @POLDB) Remote count wrapper used to decide whether premium history exists for a quote WCISInquiry
pk73190_quoteprint.Get_Rating_Plan_Count WCIS_DBA Package function (remote wrapper @POLDB) Remote count wrapper used to decide whether rating plans exist for a quote WCISInquiry
SP72347_INFO_PAGE_PRINTED_YN (unqualified; standalone) Standalone function (wrapper for sp72253_info_page_printed) Character wrapper over the boolean sp72253_info_page_printed WCISInquiry
SP72658_GET_GOV_CLASS (unqualified; standalone) Standalone function (wrapper for pk62030_rating.SP62022_Get_Gov_Class) Calls the rating package and returns only the governing class, discarding the minimum premium clsPolicyPeriod
Sp72803_Edit_Prelim_Audit (unqualified; standalone) Standalone procedure (remote wrapper wcis_dba.…@PolDB) Remote edit that sets an IN OUT flag indicating whether a preliminary audit is required WCISInquiry
sp72814_get_cont_cov_date (unqualified; standalone) Standalone function Finds the most recent break in the policy-period chain and in the explicit coverage-gap table, then picks the appropriate resumption date WCISInquiry, clsPolicy
SP73029_GET_NONWCIS_GOV_CLASS (unqualified; standalone) Standalone function Same payroll-contest algorithm as the WCIS version but over legacy class-coverage tables and truncated to four digits clsLegacyPolicyPeriod
sp73089_get_policy_bound_flag (unqualified; standalone) Standalone function (wrapper for sp72325_chk_if_policy_bound) Character wrapper over the boolean sp72325_chk_if_policy_bound clsPolicyPeriod

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.Core\clsPolicy.vb
  • Business\SAIF.Business.Policy.Core\clsPolicyPeriod.vb
  • Business\SAIF.Business.Policy.Core\clsPolicyPeriodBase.vb
  • Business\SAIF.Business.Policy.Core\WCISInquiry.vb
  • Business\SAIF.Business.Policy.Core\clsWCISInterfacer.vb
  • Oracle DBA_SOURCE for the referenced objects