pk82033_thirdparty¶

Overview¶

Field	Value
Schema	`WCIS_DBA`
Type	Package
Database	Oracle
Calling libraries	`SAIF.Business.View.Policy`
Calling classes	`clsPolicyData`

Purpose¶

pk82033_thirdparty is a broad third-party maintenance package. Within this library, the retrieved source is used only for get_policy_waiver_count, which counts waiver-detail rows for one policy.

Procedures / Methods¶

get_policy_waiver_count¶

Field	Value
Returns	`NUMBER`
Called by	`clsPolicyData` ad hoc waiver-count retrieval
Description	Returns the number of `WAIVER_DETAIL` rows for the supplied policy number.

Parameters¶

Parameter	Direction	Type	Default	Description
`PolicyNum`	IN	`POLICY.POLICY_NUM%TYPE`	—	Policy number whose waiver rows should be counted.

Business Rules¶

The retrieved database source embeds the following server-side rules.

Rule ID	Summary
BR-VP-028	`get_policy_waiver_count` returns `COUNT(*)` from `WAIVER_DETAIL` for the supplied policy number.

BR-VP-028 Policy waiver count equals the number of waiver-detail rows for the policy¶

Field	Value
Statement	The waiver-count helper returns the number of `WAIVER_DETAIL` rows whose `POLICY_NUM` equals the input policy number.
Trigger	`get_policy_waiver_count` executes.
Enforcement	The function runs `SELECT COUNT(*) INTO v_count FROM WAIVER_DETAIL WHERE POLICY_NUM = PolicyNum` and returns `v_count`.
Outcome	Callers receive a simple numeric waiver count for the policy.
Source	Oracle retrieval JSON: `C:\Users\chrfre\AppData\Local\Temp\oracle-sources\pk82033_thirdparty.json`

Operations¶

The retrieved database source implements the following internal operations.

Operation	Description	Trigger
Count policy waiver rows	Return the number of `WAIVER_DETAIL` rows for the supplied policy number.	Caller invokes `get_policy_waiver_count`.

Count policy waiver rows¶

Field	Value
Description	Return the number of `WAIVER_DETAIL` rows for the supplied policy number.
Trigger	Caller invokes `get_policy_waiver_count`.
Source	Oracle retrieval JSON: `C:\Users\chrfre\AppData\Local\Temp\oracle-sources\pk82033_thirdparty.json`

Calling code references¶

Class	Method	Source File
`clsPolicyData`	`ad hoc method (`get_policy_waiver_count`)`	`SAIF.Business.View.Policy\clsPolicyData.vb`

Source Code¶

Representative package specification excerpt

) RETURN NUMBER;


FUNCTION get_policy_waiver_count
(
    PolicyNum IN POLICY.POLICY_NUM%TYPE
)
RETURN NUMBER;

Representative package body excerpt for waiver-count helper

** FUNCTION TO RETRIEVE POLICY WAIVER COUNT
** DATE: 26-JULY-06 07:27:00
*********************************************/
FUNCTION get_policy_waiver_count
(
    PolicyNum IN POLICY.POLICY_NUM%TYPE
)
RETURN NUMBER
AS
v_count NUMBER := 0;
BEGIN
     SELECT COUNT(*)
       INTO v_count
       FROM WAIVER_DETAIL
      WHERE POLICY_NUM = PolicyNum;

    RETURN v_count;
END get_policy_waiver_count;

Sources¶

Oracle retrieval JSON: C:\Users\chrfre\AppData\Local\Temp\oracle-sources\pk82033_thirdparty.json
Calling code: SAIF.Business.View.Policy\clsPolicyData.vb