Skip to content

sp72347_info_page_printed_yn

Overview

Field Value
Schema WCIS_DBA
Type Standalone function
Database Oracle
Calling libraries SAIF.Business.View.Policy
Calling classes clsPolicyData

Purpose

sp72347_info_page_printed_yn wraps a Boolean PL/SQL helper and exposes the result as the Y or N character flag expected by the application.

Procedures / Methods

sp72347_info_page_printed_yn

Field Value
Returns CHAR
Called by clsPolicyData ad hoc retrieval and pk72846_view_policy.getpolicyperiod / getpolicyperiods
Description Returns Y when the information page has printed for the supplied policy period; otherwise returns N.

Parameters

Parameter Direction Type Default Description
in_policy_num IN NUMBER — Policy number to evaluate.
in_policy_period_eff_date IN DATE — Policy-period effective date to evaluate.

Business Rules

The retrieved database source embeds the following server-side rules.

Rule ID Summary
BR-VP-033 The wrapper converts sp72253_info_page_printed(...) Boolean output into Y or N.

BR-VP-033 Information-page status is returned as Y or N

Field Value
Statement The function returns Y when sp72253_info_page_printed(in_policy_num, in_policy_period_eff_date) is true and N otherwise.
Trigger SP72347_INFO_PAGE_PRINTED_YN executes.
Enforcement The function checks the wrapped Boolean function in an IF ... THEN RETURN 'Y' ELSE RETURN 'N' END IF block.
Outcome Callers receive a character flag instead of a PL/SQL Boolean.
Source Oracle retrieval JSON: C:\Users\chrfre\AppData\Local\Temp\oracle-sources\sp72347_info_page_printed_yn.json

Operations

The retrieved database source implements the following internal operations.

Operation Description Trigger
Convert information-page Boolean result to a character flag Call the wrapped Boolean function and return Y when true or N when false. Caller invokes SP72347_INFO_PAGE_PRINTED_YN.

Convert information-page Boolean result to a character flag

Field Value
Description Call the wrapped Boolean function and return Y when true or N when false.
Trigger Caller invokes SP72347_INFO_PAGE_PRINTED_YN.
Source Oracle retrieval JSON: C:\Users\chrfre\AppData\Local\Temp\oracle-sources\sp72347_info_page_printed_yn.json

Calling code references

Class Method Source File
clsPolicyData ad hoc method SAIF.Business.View.Policy\clsPolicyData.vb

Source Code

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

Sources

  • Oracle retrieval JSON: C:\Users\chrfre\AppData\Local\Temp\oracle-sources\sp72347_info_page_printed_yn.json
  • Calling code: SAIF.Business.View.Policy\clsPolicyData.vb
  • Calling package: C:\Users\chrfre\AppData\Local\Temp\oracle-sources\pk72846_view_policy.json