Skip to content

SAIF.Business.View.Policy stored procedures

This page catalogs every stored procedure, package, and function that SAIF.Business.View.Policy calls. Most policy data reaches this library through these objects rather than through direct table access, so a significant share of the behaviour visible to callers is implemented in PL/SQL.

All nine call targets are located and analysed: eight Oracle objects and one SQL Server procedure (cp_external_client_lookup, confirmed via a SQL Server BDS query after previously being unresolved when only Oracle was checked).

Procedure catalog

Package / Procedure Schema Type Status Methods used Calling classes
pk72846_view_policy WCIS_DBA Package Found getviewdetail, getwrapuplegalname, getparentpolicy, getpolicyaffiliatetype, getgaps, getagency, getpolicyaddress, getpolicyaddressbylocseqnum, getpolicyperiods, getpolicyaffiliatelist, team_assign_query clsPolicyData, clsAgency, clsPolicyAddress, clsPolicyPeriodCollection, clsAffiliatedPolicyCollection, clsTeamAssignmentCollection
pk73094_policy_data WCIS_DBA Package Found getpolicy clsPolicyData
Pk82033_ThirdParty WCIS_DBA Package Found get_policy_waiver_count clsPolicyData
coveragelimits_pkg WCIS_DBA Package Found getSpecificLimitsForPolicyNum clsPolicyPeriod
sp72268_get_cancel_status WCIS_DBA Function (standalone) Found sp72268_get_cancel_status clsPolicyData
sp73089_get_policy_bound_flag WCIS_DBA Function (standalone) Found sp73089_get_policy_bound_flag clsPolicyData
sp72347_info_page_printed_yn WCIS_DBA Function (standalone) Found sp72347_info_page_printed_yn clsPolicyData
sp73341_external_client_lookup WCIS_DBA Function (standalone) Found sp73341_external_client_lookup clsTeamAssignment
cp_external_client_lookup dbo (SQL Server, database eisD0P11) Stored procedure Found cp_external_client_lookup clsTeamAssignment

SQL statements backed by these procedures

SQL ID Statement Procedure
SQL-001 Affiliated policy list retrieval pk72846_view_policy
SQL-002 Agency and producer retrieval pk72846_view_policy
SQL-005 Policy address retrieval by address type pk72846_view_policy
SQL-006 Policy address retrieval by location sequence number pk72846_view_policy
SQL-008 Policy period retrieval pk72846_view_policy
SQL-009 Team assignment retrieval pk72846_view_policy
SQL-013 Policy affiliate-type classification (superseded) pk72846_view_policy
SQL-016 Coverage gap retrieval pk72846_view_policy
SQL-019 Parent policy resolution (superseded) pk72846_view_policy
SQL-021 Wrap-up legal name retrieval pk72846_view_policy
SQL-007 Policy header retrieval pk73094_policy_data
SQL-022 Policy waiver count check Pk82033_ThirdParty
SQL-023 Employer-liability limits retrieval coveragelimits_pkg
SQL-020 Secondary policy status derivation sp72268_get_cancel_status
SQL-014 Coverage-bound flag check sp73089_get_policy_bound_flag
SQL-017 Information-page-printed check sp72347_info_page_printed_yn
SQL-025 System user e-mail lookup sp73341_external_client_lookup
SQL-024 External client e-mail lookup (legacy path, SQL Server) cp_external_client_lookup

Notes

  • Procedure owner names are recorded from the Oracle data dictionary for the eight Oracle objects. They are unrelated to the table schema qualifier, which this library never states in SQL.**
  • cp_external_client_lookup is a SQL Server stored procedure (schema dbo, database eisD0P11), confirmed via legends sqlserver query — unlike the other eight objects in this catalog, which are Oracle objects.
  • sp72268_get_cancel_status and sp72347_info_page_printed_yn are also invoked from inside pk73094_policy_data.getpolicy and pk72846_view_policy.getpolicyperiods respectively, so their behaviour affects rows that this library never requests from them directly.
  • The dynamic call documented as SQL-029 executes a procedure whose name is read from ASSOCIATION_TYPE_CODE.SOURCE_PROCEDURE_NAME at run time. No catalog entry can be created for it because the target varies per row.**

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.View.Policy/clsAffiliatedPolicyCollection.vb
  • Business/SAIF.Business.View.Policy/clsAgency.vb
  • Business/SAIF.Business.View.Policy/clsPolicyAddress.vb
  • Business/SAIF.Business.View.Policy/clsPolicyData.vb
  • Business/SAIF.Business.View.Policy/clsPolicyPeriod.vb
  • Business/SAIF.Business.View.Policy/clsPolicyPeriodCollection.vb
  • Business/SAIF.Business.View.Policy/clsTeamAssignment.vb
  • Business/SAIF.Business.View.Policy/clsTeamAssignmentCollection.vb
  • Oracle data dictionary source for the eight located objects