---
title: "SP72347_INFO_PAGE_PRINTED_YN stored procedure documentation"
summary: "Analysis of Oracle package/procedure including business rules and operations."
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy.Core
reference_type: package
source_schema: "*(unqualified; standalone)*"
source_name: "SP72347_INFO_PAGE_PRINTED_YN"
source_type: "Standalone function (wrapper for `sp72253_info_page_printed`)"
oracle_status: "found"
---

# 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](../business-rules.md#br-014-a-modern-policy-period-is-considered-issued-when)) |

## Source Code

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

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

## Related Documentation
- [Procedure catalog](index.md)
- [Business rules](../business-rules.md)
- [Operations and processes](../operations-processes.md)
- [SQL catalog](../sql/index.md)

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