Skip to content

sp73089_get_policy_bound_flag

Overview

Field Value
Schema WCIS_DBA
Type Standalone function
Database Oracle
Status ✅ found — retrieved via Legends CLI
Query executed legends oracle query --name sp73089_get_policy_bound_flag
Calling libraries SAIF.Business.View.Policy
Calling classes clsPolicyData

Purpose

sp73089_get_policy_bound_flag returns a Y/N flag indicating whether coverage is bound for a policy period, called by the Business Online ViewPolicy Summary page per an in-source comment (JERTOD, 02/06/2007).

Procedures / Methods

sp73089_get_policy_bound_flag

Field Value
Returns VARCHAR2 (function return value)
Called by clsPolicyData bound-flag retrieval (clsPolicyData.vb:1756-1765, SQL at 2326)

Description: Delegates the coverage-bound decision to the shared bound-check procedure, sp72325_chk_if_policy_bound (out of catalog scope, not retrieved separately) (see rule PR-BVP-012 in Business Rules below).

Parameters

Parameter Direction Type Default Description
in_policy_num IN NUMBER — Policy number
in_policy_period_eff_date IN DATE — Period effective date
(return) RETURN VARCHAR2 — Y / N

Business Rules

Rules extracted from this function's logic:

Rule ID Rule Condition Action
PR-BVP-012 Coverage-bound indicator is delegated to the shared bound check sp72325_chk_if_policy_bound(in_policy_num, in_policy_period_eff_date) is true Return 'Y'; otherwise 'N'. Caller sets CoverageBoundFlag = True only on 'Y' (clsPolicyData.vb:1756-1765)

These rules are documented in business-rules.md.

Operations

Operations and processes implemented in this function:

Operation Description Trigger
Check coverage bound Returns Y/N indicating whether coverage is bound for a policy period clsPolicyData bound-flag retrieval (clsPolicyData.vb:1756-1765, SQL at 2326)

These operations are also listed in operations-processes.md with source reference back to this document.

Source Code

PL/SQL function (specification and body) 
-- Called by Business Online - ViewPolicy Summary page
-- JERTOD 02/06/2007
FUNCTION sp73089_get_policy_bound_flag (in_policy_num             IN NUMBER,
                                        in_policy_period_eff_date IN DATE)
   RETURN VARCHAR2
IS
BEGIN
   IF sp72325_chk_if_policy_bound (in_policy_num, in_policy_period_eff_date)
   THEN
      RETURN 'Y';
   ELSE
      RETURN 'N';
   END IF;
END;
Call site (`clsPolicyData.vb:2326`): 
Select sp73089_get_policy_bound_flag(:in_policy_num, :in_policy_period_eff_date) from dual

Sources

  • Oracle DBA_SOURCE: WCIS_DBA.sp73089_get_policy_bound_flag
  • Legends CLI query executed 2026-08-31: legends oracle query --name sp73089_get_policy_bound_flag
  • Calling code: SAIF.Business.View.Policy/clsPolicyData.vb:1756-1765, 2326