coveragelimits_pkg

Overview

Field	Value
Schema	WCIS_DBA
Type	Package
Database	Oracle (TNS alias not declared in this library's source)**
Calling libraries	SAIF.Business.View.Policy
Calling classes	clsPolicyPeriod

Purpose

Resolves statutory employer-liability coverage limits for a policy period through a specific-to-default fallback hierarchy.

Procedures / Methods

getSpecificLimitsForPolicyNum

Field	Value
Returns	REF CURSOR — statutory code and up to three limit amounts
Called by	clsPolicyPeriod.RetrieveEmployerLiabLimits
SQL document	SQL-023

Description: Returns the employer-liability coverage limits in force for a policy period, falling back from policy-specific current limits through historical and legacy defaults.

Parameters

Parameter	Direction	Type	Default	Description
aPolicyNum	IN	NUMBER	—	Policy number being read.
PeriodEffDate	IN	DATE	—	Policy period effective date whose limits are requested.
recordset	IN OUT	limit_cursor	—	Result set returned to the caller.

Business Rules

Rules extracted from this package's logic:

Rule ID	Rule	Condition	Action
PROC-RULE-017	Employer-liability limits fall back through a fixed hierarchy from policy-specific current limits to legacy non-WCIS defaults	Five UNION-ed branches gated by date-range and NOT EXISTS checks against policy_period_emp_liab	Returns the first matching branch's rows; multiple branches may fire, in which case all matching rows are returned

These rules are also listed under ## Stored procedure business rules in business-rules.md.

Operations

Operations implemented in this package:

Operation	Description	Trigger
Retrieve employer-liability limits	Returns statutory employer-liability coverage limits for a policy period with a specific-to-default fallback	clsPolicyPeriod.RetrieveEmployerLiabLimits

These operations are also listed under ## Stored procedure operations in operations-processes.md.

Source Code

Note: The full WCIS_DBA.coveragelimits_pkg package body (14,930 characters of PL/SQL) is too large to reproduce in this document. Only the declarations of the methods this library actually calls are shown below. The complete package body is available from the Oracle data dictionary (DBA_SOURCE/ALL_SOURCE) for WCIS_DBA.coveragelimits_pkg.

PL/SQL declarations of the called methods

-- Retrieved from the Oracle data dictionary for WCIS_DBA.coveragelimits_pkg

PROCEDURE getSpecificLimitsForPolicyNum(aPolicyNum IN NUMBER,PeriodEffDate IN DATE,
  recordset IN OUT limit_cursor)

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.

Related documentation

• Procedure catalog
• Business rules
• Operations and processes
• SQL catalog
• Database tables

Sources

• Business/SAIF.Business.View.Policy/clsPolicyPeriod.vb
• Oracle data dictionary source for WCIS_DBA.coveragelimits_pkg