Skip to content

SAIF.Business.Policy stored procedures

This page catalogs the 2 distinct Oracle stored procedures/functions invoked by this library. Real Oracle PL/SQL source was retrieved for both packages via the Legends CLI (legends oracle query --name <package_name>, schema WCIS_DBA) on 2026-08-31. Both pk73069_rating_procs.get_minimum_expense_constant and pk73102_policy.does_wcis_own_submission are found: package spec and body were returned for both, and both .NET call sites (PolicyInformation.PolicyMinimumPremium, PolicyInformation.GetPolicyOwnershipSystem) are live, reachable code — neither is possibly dead code.

Procedure catalog

Package / Procedure Schema Type Purpose Calling business objects
pk73069_rating_procs WCIS_DBA Package procedure Calculate the minimum premium / expense constant for a premium-history set PolicyInformation.PolicyMinimumPremium
pk73102_policy WCIS_DBA Package function (not procedure — does_wcis_own_submission is declared FUNCTION … RETURN VARCHAR2) Determine whether WCIS owns submission of a policy PolicyInformation.GetPolicyOwnershipSystem

Sources

  • SAIF.Business.Policy/PolicyInformation.vb:188–222 — PolicyMinimumPremium
  • SAIF.Business.Policy/PolicyInformation.vb:249–274 — GetPolicyOwnershipSystem