Skip to content

SP72347_INFO_PAGE_PRINTED_YN

Overview

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

Purpose

Character wrapper over the boolean sp72253_info_page_printed

Procedures / Methods

SP72347_INFO_PAGE_PRINTED_YN

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

Description: Character wrapper over the boolean sp72253_info_page_printed

Parameters

Parameter Direction Type Default Description
in_policy_num IN NUMBER — Policy number whose information-page print status is being checked.
in_policy_period_eff_date IN DATE — Policy-period effective date whose information-page print status is being checked.

Business Rules

Rule ID Rule Condition Action
PROC-RULE-023 Information-page print status is expressed as a 'Y'/'N' character rather than a boolean sp72253_info_page_printed(policy, eff_date) = TRUE Return 'Y', else 'N'
PROC-RULE-024 Any failure is surfaced to the caller WHEN others `RAISE_APPLICATION_ERROR(-20002, 'Error in sp72347: ' \

Operations

Operation Description Trigger
Report information-page print status Character wrapper over the boolean sp72253_info_page_printed WCISInquiry.IsInformationPagePrinted (SQL-119), used by clsPolicyPeriod.IsIssued (BR-014)

Source Code

PL/SQL source 
FUNCTION SP72347_INFO_PAGE_PRINTED_YN
/****************************************************************
*Procedure Title  : Determine if the information page for a policy
/*                  period has printed.
*                   *** THIS IS A WRAPPER FOR SP72253 ***
*Name             : SP72347_INFO_PAGE_PRINTED_YN
*Called by        : PMS.SQL
*****************************************************************
*PROGRAMMER     ANALYST                 DATE       MOD #
*PETWIR         JOHFRE              10/04/2001
*
*Description:   Determine if the information page for a policy
*               period has printed.
*
* INPUTS:          policy number
*                  policy period effective date
* RETURNS:         char(1) - "Y" = information page has printed
*                            "N" = information page has not printed
*
* Maintenance Log:
*   Name            Date      Description
*
******************************************************************/

    ( in_policy_num                IN      NUMBER
    , in_policy_period_eff_date    IN      DATE)

    RETURN CHAR
IS
/*******************   Local Variables  *************************/

/*******************   Main Program     *************************/
BEGIN

IF sp72253_info_page_printed(in_policy_num, in_policy_period_eff_date) = TRUE THEN
     RETURN 'Y';
ELSE
     RETURN 'N';
END IF;

EXCEPTION
     WHEN others THEN
         RAISE_APPLICATION_ERROR(-20002,'Error in sp72347: '
                                  || SQLERRM);

END;   /*SP72253_INFO_PAGE_PRINTED_YN */

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: SP72347_INFO_PAGE_PRINTED_YN
  • Business\SAIF.Business.Policy.Core\WCISInquiry.vb