---
title: "sp73089_get_policy_bound_flag 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: "sp73089_get_policy_bound_flag"
source_type: "Standalone function (wrapper for `sp72325_chk_if_policy_bound`)"
oracle_status: "found"
---

# sp73089_get_policy_bound_flag

## Overview

| Field | Value |
| --- | --- |
| **Schema** | *(unqualified; standalone)* |
| **Type** | Standalone function (wrapper for `sp72325_chk_if_policy_bound`) |
| **Database** | Oracle |
| **Calling libraries** | `SAIF.Business.Policy.Core` |
| **Calling classes** | `clsPolicyPeriod` |

## Purpose

Character wrapper over the boolean `sp72325_chk_if_policy_bound`

## Procedures / Methods

### sp73089_get_policy_bound_flag

| Field | Value |
| --- | --- |
| **Returns** | See PL/SQL source below. |
| **Called by** | `clsPolicyPeriod` |

**Description:** Character wrapper over the boolean `sp72325_chk_if_policy_bound`

#### Parameters

| Parameter | Direction | Type | Default | Description |
| --- | --- | --- | --- | --- |
| `in_policy_num` | IN | `NUMBER` | — | Policy number whose coverage-bound status is being checked. |
| `in_policy_period_eff_date` | IN | `DATE` | — | Policy-period effective date passed to the bound-coverage wrapper check. |

## Business Rules

| Rule ID | Rule | Condition | Action |
| --- | --- | --- | --- |
| PROC-RULE-037 | Coverage-bound status is expressed as a `'Y'`/`'N'` character rather than a boolean | `sp72325_chk_if_policy_bound(policy, eff_date)` is TRUE | Return `'Y'`, else `'N'` |

## Operations

| Operation | Description | Trigger |
| --- | --- | --- |
| Report coverage-bound status | Character wrapper over the boolean `sp72325_chk_if_policy_bound` | `clsPolicyPeriod.IsCoverageBound` (SQL-082), supporting [BR-016](../business-rules.md#br-016-coverage-bound-status-is-sourced-from-wcis-for-modern) |

## Source Code

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

```sql
FUNCTION sp73089_get_policy_bound_flag (
/****************************************************************
*Procedure Title  : This is a wrapper function to return a 'Y'' or 'N' flag
*                   for policies in APP status. The function wraps the boolean
*					function sp72325_chk_if_policy_bound
*Name             : sp73089_get_policy_bound_flag
*Called by        : Business Online - ViewPolicy Summary page
*****************************************************************
*PROGRAMMER     ANALYST                 DATE        MOD #
*JERTOD        						 02/06/2007
*Description:	This procedure will check if the policy has bound
*               coverage.
* Maintenance Log:
*   Release         Name    Date      Description
******************************************************************/
        in_policy_num              IN  NUMBER,
        in_policy_period_eff_date  IN  DATE)

    RETURN VARCHAR2

IS

flag					   varchar2(1);

BEGIN

IF sp72325_chk_if_policy_bound(in_policy_num,in_policy_period_eff_date) THEN
   flag:='Y';
ELSE
	flag:='N';
END IF;

RETURN flag;

END; -- sp73089_get_policy_bound_flag
```

</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: sp73089_get_policy_bound_flag
- `Business\SAIF.Business.Policy.Core\clsPolicyPeriod.vb`