Skip to content

SAIF.Business.View.Policy stored procedures

This page catalogs database procedures, packages, and functions invoked by this library.

[!IMPORTANT] 13 found / 1 unresolvable-dynamic-name / 0 not-found. All 13 concrete procedure/package targets were successfully retrieved via the Legends CLI — 8 Oracle objects (schema WCIS_DBA) and 5 SQL Server BDS objects (eisD0P11.dbo) — and each has at least one live .NET call site in SAIF.Business.View.Policy. The 14th catalog entry, ASSOCIATION_TYPE_CODE.SOURCE_PROCEDURE_NAME, is not a procedure name at all — it is a reference-data column whose value supplies a procedure name at runtime, so static retrieval is impossible by construction. None of the 14 entries is missing, orphaned, or dead code.

Procedure catalog

Package / Procedure Schema Type Status Purpose Calling business objects
pk72846_view_policy WCIS_DBA Oracle package (34 members) found Affiliated policy, agency, address, detail, parent-policy, gaps, period, and team-assignment retrieval for policy view objects clsPolicyData, clsPolicyPeriodCollection, clsAgency, clsPolicyAddress, clsAffiliatedPolicyCollection, clsTeamAssignmentCollection, clsMCOCollection, clsPolicyMCOCollection
pk73094_policy_data WCIS_DBA Oracle package found Primary policy-header retrieval, including derived cancel status, for policy view data objects clsPolicyData
Pk82033_ThirdParty WCIS_DBA Oracle package (92 members; 1 invoked) found Third-party waiver-count lookup for policy records clsPolicyData
coveragelimits_pkg WCIS_DBA Oracle package (5 members; 1 invoked) found Employer liability coverage-limit retrieval for a policy period clsPolicyPeriod
sp72268_get_cancel_status WCIS_DBA Oracle function found Derives a display cancel status for a policy from status group, demand, audit, and legal-action state clsPolicyData
sp73089_get_policy_bound_flag WCIS_DBA Oracle function found Coverage-bound flag lookup for a policy period, delegated to the shared bound-check procedure clsPolicyData
SP72347_INFO_PAGE_PRINTED_YN WCIS_DBA Oracle function found Information-page-printed flag lookup for a policy period, delegated to the shared info-page-printed procedure clsPolicyData
sp73341_external_client_lookup WCIS_DBA Oracle function found External client email lookup for team-assignment contacts, sourced from system_user_contractor clsTeamAssignment
cp_policy_in_group eisD0P11.dbo SQL Server stored procedure (BDS) found Group/chapter membership validation for policy-security checks clsPolicySecurity
cp_claimprofile_get_group_policy_list eisD0P11.dbo SQL Server stored procedure (BDS) found Group/chapter policy-list retrieval for policy-security filtering, as of a report date clsPolicySecurity
cp_claimprofile_get_sc_book eisD0P11.dbo SQL Server stored procedure (BDS) found Safety-consultant policy-book retrieval clsPolicySecurity
cp_get_agent_online_policy_list eisD0P11.dbo SQL Server stored procedure (BDS) found Agent or agency online policy-list retrieval, active and recently closed clsPolicySecurity
cp_external_client_lookup eisD0P11.dbo SQL Server stored procedure (BDS) found External client email-address lookup for non-SAIF team members clsTeamAssignment
ASSOCIATION_TYPE_CODE.SOURCE_PROCEDURE_NAME n/a (name supplied by data) Runtime-resolved procedure name unresolvable-dynamic-name Executes whichever procedure name is stored in the ASSOCIATION_TYPE_CODE reference-data column, to return association rows for a policy clsAssociationTypeCode

Special case: pk72846_view_policy member — getmco

[!NOTE] getmco member not present in retrieved source. The pk72846_view_policy package is found and successfully retrieved via Legends CLI. However, the specific member getmco could not be located in the retrieved package source despite a case-insensitive search of the full artifact. This does not change the package's found status: both clsMCOCollection.vb:231 and clsPolicyMCOCollection.vb:231 contain live, reachable call sites to this member and are not dead code. No signature, parameters, or behavior are documented for getmco beyond this caveat and the two caller citations.

Sources

  • SAIF.Business.View.Policy/Associations/clsAssociationTypeCode.vb
  • SAIF.Business.View.Policy/clsAffiliatedPolicyCollection.vb
  • SAIF.Business.View.Policy/clsAgency.vb
  • SAIF.Business.View.Policy/clsPolicyAddress.vb
  • SAIF.Business.View.Policy/clsPolicyData.vb
  • SAIF.Business.View.Policy/clsPolicyPeriod.vb
  • SAIF.Business.View.Policy/clsPolicyPeriodCollection.vb
  • SAIF.Business.View.Policy/clsPolicySecurity.vb
  • SAIF.Business.View.Policy/clsTeamAssignment.vb
  • SAIF.Business.View.Policy/clsTeamAssignmentCollection.vb
  • SAIF.Business.View.Policy/clsMCOCollection.vb
  • SAIF.Business.View.Policy/clsPolicyMCOCollection.vb