SAIF.Business.View.Policy stored procedures¶
This page catalogs the Oracle packages and functions and SQL Server procedures invoked by this library. Database source retrieval has now been completed for the 13 statically named database objects below, so they are documented as found. One additional call remains intentionally unresolved because the procedure name is determined dynamically at runtime.
Procedure catalog¶
| Package / Procedure | Database | Type | Status | Purpose | Calling business objects |
|---|---|---|---|---|---|
pk72846_view_policy |
Oracle | Package | Found | Core view-policy package supplying header/detail, period, agency, address, gap, team, and affiliation retrieval helpers. | clsAgency, clsMCOCollection, clsPolicyMCOCollection, clsAffiliatedPolicyCollection, clsPolicyAddress, clsPolicyPeriodCollection, clsTeamAssignmentCollection, clsPolicyData |
pk73094_policy_data |
Oracle | Package | Found | Retrieves the core policy-header record and preferred account display name. | clsPolicyData |
pk82033_thirdparty |
Oracle | Package | Found | Counts waiver-detail rows for a policy. | clsPolicyData |
coveragelimits_pkg |
Oracle | Package | Found | Retrieves employer-liability coverage limits for current, specific, future, and effective-dated requests. | clsPolicyPeriod |
sp72347_info_page_printed_yn |
Oracle | Function | Found | Returns a Y or N flag indicating whether the information page printed for a policy period. |
clsPolicyData |
sp73341_external_client_lookup |
Oracle | Function | Found | Resolves an external contractor email address from mail ID and last name. | clsTeamAssignment |
sp72268_get_cancel_status |
Oracle | Function | Found | Derives a human-readable cancellation or collection status for a policy. | clsPolicyData |
sp73089_get_policy_bound_flag |
Oracle | Function | Found | Returns whether an application policy period is bound as a Y or N flag. |
clsPolicyData |
(dynamic via SOURCE_PROCEDURE_NAME) |
Oracle | Standalone procedure, name resolved at runtime | Dynamic | Retrieves non-typed policy associations; actual procedure name remains runtime-resolved. | clsAssociationTypeCode |
cp_policy_in_group |
SQL Server | Procedure | Found | Counts whether a policy belongs to a requested group or chapter. | clsPolicySecurity |
cp_claimprofile_get_group_policy_list |
SQL Server | Procedure | Found | Retrieves the group users book of business for a report date. | clsPolicySecurity |
cp_claimprofile_get_sc_book |
SQL Server | Procedure | Found | Retrieves the loss-control consultants active book of business. | clsPolicySecurity |
cp_get_agent_online_policy_list |
SQL Server | Procedure | Found | Retrieves the agent or agency online policy list, including recent closed policies. | clsPolicySecurity |
cp_external_client_lookup |
SQL Server | Procedure | Found | Looks up the latest active non-test external-client registrant row. | clsTeamAssignment |
Related documentation¶
Sources¶
- Oracle and SQL Server retrieval folder:
C:\Users\chrfre\AppData\Local\Temp\oracle-sources\ - Calling code:
SAIF.Business.View.Policy\clsAgency.vb - Calling code:
SAIF.Business.View.Policy\clsPolicyData.vb - Calling code:
SAIF.Business.View.Policy\clsPolicyPeriod.vb - Calling code:
SAIF.Business.View.Policy\clsAffiliatedPolicyCollection.vb - Calling code:
SAIF.Business.View.Policy\clsPolicyAddress.vb - Calling code:
SAIF.Business.View.Policy\clsTeamAssignment.vb - Calling code:
SAIF.Business.View.Policy\clsTeamAssignmentCollection.vb - Calling code:
SAIF.Business.View.Policy\PolicyAssociations.vb - Calling code:
SAIF.Business.View.Policy\clsPolicySecurity.vb