Skip to content

SP72347_INFO_PAGE_PRINTED_YN

Overview

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

Purpose

SP72347_INFO_PAGE_PRINTED_YN returns a Y/N flag indicating whether the information page has printed for a policy period.

Procedures / Methods

SP72347_INFO_PAGE_PRINTED_YN

Field Value
Returns CHAR (function return value)
Called by clsPolicyData.IsInformationPagePrinted (clsPolicyData.vb:1772-1792, SQL at 2332)

Description: Delegates the information-page-printed decision to sp72253_info_page_printed (out of catalog scope, not retrieved separately) and surfaces unhandled errors as an application error (see rules PR-BVP-013, PR-BVP-014 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 CHAR(1) — Y / N

Business Rules

Rules extracted from this function's logic:

Rule ID Rule Condition Action
PR-BVP-013 Information-page printed indicator is delegated to sp72253_info_page_printed wrapped check returns true Return 'Y'; otherwise 'N'
PR-BVP-014 Unhandled errors are surfaced as an application error EXCEPTION WHEN others RAISE_APPLICATION_ERROR(-20002, 'Error in sp72347: ' \|\| SQLERRM)

These rules are documented in business-rules.md.

Operations

Operations and processes implemented in this function:

Operation Description Trigger
Check information page printed Returns Y/N indicating whether the information page has printed clsPolicyData.IsInformationPagePrinted (clsPolicyData.vb:1772-1792, SQL at 2332)

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

Source Code

PL/SQL function (specification and body) 
FUNCTION SP72347_INFO_PAGE_PRINTED_YN (in_policy_num             IN NUMBER,
                                       in_policy_period_eff_date IN DATE)
   RETURN CHAR
IS
BEGIN
   -- wrapper over sp72253_info_page_printed
   IF sp72253_info_page_printed (in_policy_num, in_policy_period_eff_date)
   THEN
      RETURN 'Y';
   ELSE
      RETURN 'N';
   END IF;
EXCEPTION
   WHEN OTHERS THEN
      RAISE_APPLICATION_ERROR (-20002, 'Error in sp72347: ' || SQLERRM);
END;

Sources

  • Oracle DBA_SOURCE: WCIS_DBA.SP72347_INFO_PAGE_PRINTED_YN
  • Legends CLI query executed 2026-08-31: legends oracle query --name SP72347_INFO_PAGE_PRINTED_YN
  • Calling code: SAIF.Business.View.Policy/clsPolicyData.vb:1772-1792, 2332