Skip to content

sp73089_get_policy_bound_flag

Overview

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

Purpose

sp73089_get_policy_bound_flag wraps the Boolean sp72325_chk_if_policy_bound function so View Policy can consume a Y or N indicator for application policies.

Procedures / Methods

sp73089_get_policy_bound_flag

Field Value
Returns VARCHAR2
Called by clsPolicyData ad hoc retrieval
Description Returns Y when the supplied application policy period is bound; otherwise returns N.

Parameters

Parameter Direction Type Default Description
in_policy_num IN NUMBER — Policy number to evaluate.
in_policy_period_eff_date IN DATE — Policy-period effective date to evaluate.

Business Rules

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

Rule ID Summary
BR-VP-034 The wrapper converts sp72325_chk_if_policy_bound(...) Boolean output into Y or N.

BR-VP-034 Bound-policy status is returned as Y or N

Field Value
Statement The function returns Y when sp72325_chk_if_policy_bound(in_policy_num, in_policy_period_eff_date) is true and N otherwise.
Trigger sp73089_get_policy_bound_flag executes.
Enforcement The function sets flag := 'Y' or N based on the wrapped Boolean function and returns flag.
Outcome Callers receive a character flag instead of a PL/SQL Boolean.
Source Oracle retrieval JSON: C:\Users\chrfre\AppData\Local\Temp\oracle-sources\sp73089_get_policy_bound_flag.json

Operations

The retrieved database source implements the following internal operations.

Operation Description Trigger
Convert policy-bound Boolean result to a character flag Call the wrapped Boolean function and return Y when the policy is bound or N when it is not. Caller invokes sp73089_get_policy_bound_flag.

Convert policy-bound Boolean result to a character flag

Field Value
Description Call the wrapped Boolean function and return Y when the policy is bound or N when it is not.
Trigger Caller invokes sp73089_get_policy_bound_flag.
Source Oracle retrieval JSON: C:\Users\chrfre\AppData\Local\Temp\oracle-sources\sp73089_get_policy_bound_flag.json

Calling code references

Class Method Source File
clsPolicyData ad hoc method SAIF.Business.View.Policy\clsPolicyData.vb

Source Code

PL/SQL function source 
FUNCTION sp73089_get_policy_bound_flag (
/****************************************************************
*Procedure Title  : This is a wrapper function to return a 'Y'' or 'N' flag
*                   for policies in APP status. The function wraps the boolean
*                   function sp72325_chk_if_policy_bound
*Name             : sp73089_get_policy_bound_flag
*Called by        : Business Online - ViewPolicy Summary page
*****************************************************************
*PROGRAMMER     ANALYST                 DATE        MOD #
*JERTOD                              02/06/2007
*Description:   This procedure will check if the policy has bound
*               coverage.
* Maintenance Log:
*   Release         Name    Date      Description
******************************************************************/
        in_policy_num              IN  NUMBER,
        in_policy_period_eff_date  IN  DATE)

    RETURN VARCHAR2

IS

flag                       varchar2(1);

BEGIN

IF sp72325_chk_if_policy_bound(in_policy_num,in_policy_period_eff_date) THEN
   flag:='Y';
ELSE
    flag:='N';
END IF;

RETURN flag;

END; -- sp73089_get_policy_bound_flag

Sources

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