---
title: "pk73190_quoteprint.Get_Billing_Master_Count 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: "WCIS_DBA"
source_name: "pk73190_quoteprint.Get_Billing_Master_Count"
source_type: "Package function (remote wrapper `@POLDB`)"
oracle_status: "found"
---

# pk73190_quoteprint.Get_Billing_Master_Count

## Overview

| Field | Value |
| --- | --- |
| **Schema** | WCIS_DBA |
| **Type** | Package function (remote wrapper `@POLDB`) |
| **Database** | Oracle |
| **Calling libraries** | `SAIF.Business.Policy.Core` |
| **Calling classes** | `WCISInquiry` |

## Purpose

Remote count wrapper used to decide whether billing data exists for a quote

## Procedures / Methods

### Get_Billing_Master_Count

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

**Description:** Remote count wrapper used to decide whether billing data exists for a quote

#### Parameters

| Parameter | Direction | Type | Default | Description |
| --- | --- | --- | --- | --- |
| `in_policy_num` | IN | `NUMBER` | — | Policy number whose billing-master rows are being counted. |

## Business Rules

No procedure-specific rules were extracted for this object.

## Operations

| Operation | Description | Trigger |
| --- | --- | --- |
| Count billing-master rows for quote print | Remote count wrapper used to decide whether billing data exists for a quote | `WCISInquiry.GetBillingMasterCount` (SQL-107) |

## Source Code

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

```sql
FUNCTION Get_Billing_Master_Count(
  /* ===========================================================================
    Name              : Get_Billing_Master_Count
    Prepared By       : gremil
    Created           : 03/25/2008
    Description       : return count of Billing Master rows

    Modification History
    --------------------------------------------------------------------------
  =========================================================================== */
     in_policy_num               IN   NUMBER)
     RETURN NUMBER
  AS
     v_count   NUMBER;

  BEGIN

     v_count := Pk73190_Quoteprint.Get_Billing_Master_Count@POLDB ( in_policy_num);

     RETURN v_count;

  END Get_Billing_Master_Count;
```

</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: pk73190_quoteprint.Get_Billing_Master_Count
- `Business\SAIF.Business.Policy.Core\WCISInquiry.vb`