---
title: "sp72347_info_page_printed_yn stored procedure documentation"
summary: "Analysis of the Oracle function called by SAIF.Business.View.Policy, including business rules and operations."
status: draft
owner: "SAIF Doc Gen"
last_reviewed: "2026-07-31"
source_schema: "WCIS_DBA"
source_name: "sp72347_info_page_printed_yn"
source_type: "FUNCTION"
oracle_status: "found"
library: SAIF.Business.View.Policy
reference_type: package
---

# 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](../sql/SQL-017-info-page-printed.md) |

**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](../business-rules.md#stored-procedure-business-rules) | 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](../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](../operations-processes.md).

## Source Code

<details>
<summary>PL/SQL source</summary>

```sql
-- 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 */
```

</details>

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

## Related documentation

- [Procedure catalog](index.md)
- [Business rules](../business-rules.md)
- [Operations and processes](../operations-processes.md)
- [SQL catalog](../sql/index.md)
- [Database tables](../database-tables.md)

## Sources

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