Skip to content

sp72347_info_page_printed_yn

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 the information page for a policy period has printed; also drives masking inside the policy-period query.

Procedures / Methods

sp72347_info_page_printed_yn

Field Value
Returns VARCHAR2 — Y or N
Called by clsPolicyData.IsInformationPagePrinted
SQL document SQL-017

Description: Returns whether the information page for a policy period has been printed.

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-020 Information-page-printed status is a thin Y/N wrapper over an external boolean check n/a Returns Y when sp72253_info_page_printed(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 information-page-printed flag Returns whether the information page for a policy period has printed clsPolicyData.IsInformationPagePrinted

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.sp72347_info_page_printed_yn
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

  • Business/SAIF.Business.View.Policy/clsPolicyData.vb
  • Oracle data dictionary source for WCIS_DBA.sp72347_info_page_printed_yn