---
title: "SQL-003: Legacy output-log stored-procedure call"
summary: Stored-procedure invocation used by the shared output-log helper.
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy.Correspondence
reference_type: package
---

# SQL-003: Legacy output-log stored-procedure call

This call requests output-log creation for a correspondence print request. The referenced Oracle object was not found during procedure analysis, so only the call signature can be documented and the path is treated as possibly dead code.*

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-003 |
| **Operation type** | Create |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | [unqualified]** |
| **Command type** | StoredProcedure |
| **Business object** | `clsCorrespondence` |
| **Criteria property** | N/A |
| **Lifecycle method** | `InsertOutputLog` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| :in_policy_num | Input | Decimal (NUMBER) | — | Policy number. |
| :in_policy_period_eff_date | Input | `clsSmartDate` (DATE) | — | Policy-period effective date. |
| :in_endorse_code | Input | String (VARCHAR2) | value length | Correspondence code. |
| :in_endorse_seq_num | Input | Decimal (NUMBER) | — | Correspondence sequence number. |
| :in_program_name | Input | String (VARCHAR2) | value length | Calling program name. |
| :ot_file_name | Output | String (VARCHAR2) | 120 | Generated file name returned to the caller. |
| :ot_copies | Output | Integer (NUMBER) | — | Number of copies returned to the caller. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| N/A | Stored procedure | Procedure body not found; table usage unknown. |

## Sample SQL

```sql
CALL pk77001_output_log.insert_output_log(
  :in_policy_num,
  :in_policy_period_eff_date,
  :in_endorse_code,
  :in_endorse_seq_num,
  :in_program_name,
  :ot_file_name,
  :ot_copies)
-- Procedure body not found in reviewed Oracle source
```

## Operations and processes
- [Insert an output-log entry](../operations/insert-an-output-log-entry.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
- `Business\SAIF.Business.Policy.Correspondence\clsCorrespondence.vb`