Skip to content

SAIF.Business.Policy.Audit.Premium stored procedures

This page catalogs Oracle stored procedures and packages invoked by this library.

Procedure catalog

Package / Procedure Schema Type Purpose Calling business objects
pk73211_premium_audit.GetExpiringPolicies WCIS_DBA Package procedure (ref cursor out) Opens a ref cursor of policy periods expiring on a given date, tagged 'EXP', excluding cancelled and pending periods clsAuditSelectionPolicyPeriod, clsAuditSelectionPolicyPeriodCollection
pk73211_premium_audit.GetOffCyclePolicies WCIS_DBA Package procedure (ref cursor out) Unions four candidate populations — new-business P401 endorsements, batch payroll audits, leasing-parent payroll audits and 15-day-delayed mid-term cancellations — into one ref cursor clsAuditSelectionPolicyPeriod, clsAuditSelectionPolicyPeriodCollection
pk73211_premium_audit.GetAuditLocationSeqNum WCIS_DBA Package function Picks the single best visitable location for an audit — AUD, then PAY, then POL, then primary BUS — rejecting expired locations and post-office boxes clsAudit, clsAuditCollection
pk73211_premium_audit.get_ending_er_mod_for_pol_per WCIS_DBA Package function Returns the ERP rating-plan factor in force on the last day of audited coverage, or the neutral 1.0 clsAuditPolicyPeriod
pk73211_premium_audit.get_current_premium WCIS_DBA Package function Nets NEAP base amounts against DCBS difference amounts over the newest premium-history set clsAuditPolicyPeriod
pk73211_premium_audit.get_payroll_classes WCIS_DBA Package procedure (ref cursor out) Opens a ref cursor of distinct four-digit manual class numbers and their rates from the newest premium-history set clsAuditPolicyPeriod
pk73211_premium_audit.insert_pol_per_payroll_audit WCIS_DBA Package function (remote wrapper @POLDB) Remote-only wrapper: forwards policy number, period effective date, last date of coverage, revision flag and due date to the policy database and returns the new payroll sequence number clsAuditPolicyPeriod
pk73211_premium_audit.cancel_pol_per_payroll_audit WCIS_DBA Package function (remote wrapper @POLDB) Remote-only wrapper: forwards the payroll sequence number to the policy database clsAuditPolicyPeriod
pk73211_premium_audit.generate_wcis_audit_documents WCIS_DBA Package procedure (remote wrapper @POLDB) Remote-only wrapper: forwards the audit sequence number and revision indicator to the policy database, which produces the audit endorsement/document set clsAudit
pk72846_view_policy.sp73111_get_wcis_std_premium WCIS_DBA Package function Resolves the newest premium-history set for the policy period and returns its standard premium clsAuditPolicyPeriod
pk73057_billing_master.is_on_arrears_plan WCIS_DBA Package function Walks billing master → billing defaults → payment plan type and reports 'Y' unless the plan generates instalment or pre-pay billing clsAuditPolicyCollection
pk73211_premium_audit.get_auditable_policy_periods (unknown) Package procedure (assumed ref cursor out) Oracle procedure/package referenced by the library; not found in Oracle or SQL Server (re-checked 2026-08-17). clsAuditablePeriodCollection
pk73211_premium_audit.get_claim_for_0_payroll_count (unknown) Package function (assumed) Oracle procedure/package referenced by the library; not found in Oracle or SQL Server (re-checked 2026-08-17). clsAuditPolicyPeriod
sp72658_get_gov_class (unknown; standalone) Standalone function (assumed) Oracle procedure/package referenced by the library; not found in Oracle or SQL Server (re-checked 2026-08-17). clsAuditPolicyPeriod

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.Audit.Premium\clsAuditSelectionPolicyPeriod.vb
  • Business\SAIF.Business.Policy.Audit.Premium\clsAuditSelectionPolicyPeriodCollection.vb
  • Business\SAIF.Business.Policy.Audit.Premium\clsAudit.vb
  • Business\SAIF.Business.Policy.Audit.Premium\clsAuditCollection.vb
  • Business\SAIF.Business.Policy.Audit.Premium\clsAuditPolicyPeriod.vb
  • Business\SAIF.Business.Policy.Audit.Premium\clsAuditPolicyCollection.vb
  • Business\SAIF.Business.Policy.Audit.Premium\clsAuditablePeriodCollection.vb
  • Individual procedure pages listed in the catalog above, each citing its own Oracle/DBA_SOURCE or referencing-code evidence