---
title: "Sp72803_Edit_Prelim_Audit 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: "Sp72803_Edit_Prelim_Audit"
source_type: "Standalone procedure (remote wrapper `wcis_dba.\u2026@PolDB`)"
oracle_status: "found"
---

# Sp72803_Edit_Prelim_Audit

## Overview

| Field | Value |
| --- | --- |
| **Schema** | *(unqualified; standalone)* |
| **Type** | Standalone procedure (remote wrapper `wcis_dba.…@PolDB`) |
| **Database** | Oracle |
| **Calling libraries** | `SAIF.Business.Policy.Core` |
| **Calling classes** | `WCISInquiry` |

## Purpose

Remote edit that sets an `IN OUT` flag indicating whether a preliminary audit is required

## Procedures / Methods

### Sp72803_Edit_Prelim_Audit

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

**Description:** Remote edit that sets an `IN OUT` flag indicating whether a preliminary audit is required

#### Parameters

| Parameter | Direction | Type | Default | Description |
| --- | --- | --- | --- | --- |
| `in_policy_num` | IN | `NUMBER` | — | Policy number passed through to the remote preliminary-audit edit. |
| `in_policy_period_eff_date` | IN | `DATE` | — | Policy-period effective date passed through to the remote preliminary-audit edit. |
| `in_comm_sched_seq_num` | IN | `NUMBER` | — | Commission-schedule sequence number parameter forwarded to the remote procedure; `WCISInquiry` currently passes an empty `clsSmartDecimal`. |
| `in_prem_hist_set_id` | IN | `NUMBER` | — | Premium-history set identifier forwarded to the remote procedure; `WCISInquiry` currently passes an empty `clsSmartDecimal`. |
| `out_flag` | IN OUT | `VARCHAR2` | — | Caller-supplied flag buffer that the remote procedure updates; `WCISInquiry` treats returned value `"1"` as preliminary-audit-required. |

## Business Rules

| Rule ID | Rule | Condition | Action |
| --- | --- | --- | --- |
| PROC-RULE-026 | The preliminary-audit finalization edit is executed on the POLDB database, not locally | Always | Call `wcis_dba.Sp72803_Edit_Prelim_Audit@PolDB(...)` passing `out_flag` through as `IN OUT` |
| PROC-RULE-027 | Any failure is surfaced to the caller | `WHEN OTHERS` | `RAISE_APPLICATION_ERROR(-20002, 'error in sp72803: ' \ |

## Operations

| Operation | Description | Trigger |
| --- | --- | --- |
| Run the preliminary-audit finalization edit | Remote edit that sets an `IN OUT` flag indicating whether a preliminary audit is required | `WCISInquiry.IsPreliminaryAuditRequired` (SQL-120); caller passes empty commission-schedule and premium-history set ids |

## Source Code

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

```sql
PROCEDURE          Sp72803_Edit_Prelim_Audit (in_policy_num IN NUMBER,
                                 in_policy_period_eff_date IN DATE,
                                 in_comm_sched_seq_num IN NUMBER,
                                 in_prem_hist_set_id IN NUMBER,
                                 out_flag IN OUT VARCHAR2)
/****************************************************************
*Procedure Title  : Finalization warning that a policy may require a preliminary audit.
*
*Name             : sp72803_edit_prelim_audit
*Called by        : finalization
*****************************************************************
*PROGRAMMER     ANALYST                 DATE       MOD #
*carade         carade            02/13/2004    6.0 maint
*Description:  Finalization edits
*
* Maintenance Log:
* Release
* Name       Date     Description
*
* melhil 06/27/2017 GW Policy Separation
*     Route call through POLDB database link
***********************************************************************************************/
    IS
 BEGIN
    wcis_dba.Sp72803_Edit_Prelim_Audit@PolDB (
                       in_policy_num
                     , in_policy_period_eff_date
                     , in_comm_sched_seq_num
                     , in_prem_hist_set_id
                     , out_flag);

EXCEPTION
    WHEN OTHERS THEN
        RAISE_APPLICATION_ERROR(-20002,'error in sp72803: '
                                || SQLERRM);
END Sp72803_Edit_Prelim_Audit;
```

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