Skip to content

sp73089_get_policy_bound_flag

Overview

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

Purpose

Returns whether a policy in application status has bound coverage for a given period effective date.

Procedures / Methods

sp73089_get_policy_bound_flag

Field Value
Returns VARCHAR2 — Y or N
Called by clsPolicyData.GetCoverageBoundFlag
SQL document SQL-014

Description: Returns whether a policy in application status has bound coverage for a period effective date.

Parameters

Parameter Direction Type Default Description
in_policy_num IN NUMBER — Policy number being read.
in_policy_period_eff_date IN DATE — Policy period effective date being evaluated.

Business Rules

Rules extracted from this function's logic:

Rule ID Rule Condition Action
PROC-RULE-019 Coverage-bound status is a thin Y/N wrapper over an external boolean check n/a Returns Y when sp72325_chk_if_policy_bound(in_policy_num, in_policy_period_eff_date) is true, otherwise N

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

Operations

Operations implemented in this function:

Operation Description Trigger
Determine coverage-bound flag Returns whether a policy in application status has bound coverage clsPolicyData.GetCoverageBoundFlag

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

Source Code

PL/SQL source 
-- Retrieved from the Oracle data dictionary for WCIS_DBA.sp73089_get_policy_bound_flag
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

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/clsPolicyData.vb
  • Oracle data dictionary source for WCIS_DBA.sp73089_get_policy_bound_flag