Skip to content

sp73089_get_policy_bound_flag

Overview

Field Value
Schema (unqualified; standalone)
Type Standalone function (wrapper for sp72325_chk_if_policy_bound)
Database Oracle
Calling libraries SAIF.Business.Policy.Core
Calling classes clsPolicyPeriod

Purpose

Character wrapper over the boolean sp72325_chk_if_policy_bound

Procedures / Methods

sp73089_get_policy_bound_flag

Field Value
Returns See PL/SQL source below.
Called by clsPolicyPeriod

Description: Character wrapper over the boolean sp72325_chk_if_policy_bound

Parameters

Parameter Direction Type Default Description
in_policy_num IN NUMBER — Policy number whose coverage-bound status is being checked.
in_policy_period_eff_date IN DATE — Policy-period effective date passed to the bound-coverage wrapper check.

Business Rules

Rule ID Rule Condition Action
PROC-RULE-037 Coverage-bound status is expressed as a 'Y'/'N' character rather than a boolean sp72325_chk_if_policy_bound(policy, eff_date) is TRUE Return 'Y', else 'N'

Operations

Operation Description Trigger
Report coverage-bound status Character wrapper over the boolean sp72325_chk_if_policy_bound clsPolicyPeriod.IsCoverageBound (SQL-082), supporting BR-016

Source Code

PL/SQL 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

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

  • Oracle DBA_SOURCE: sp73089_get_policy_bound_flag
  • Business\SAIF.Business.Policy.Core\clsPolicyPeriod.vb