---
title: PK72970_EPAY stored procedure documentation
summary: Analysis of Oracle package PK72970_EPAY including business rules and operations. Status not-found; calling code may be dead code.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
source_schema: PK72970
source_name: PK72970_EPAY
source_type: PACKAGE
oracle_status: not-found
library: SAIF.Business.Payment.EFT
sqlserver_status: "not-found"
reference_type: package
---

# PK72970_EPAY

> [!WARNING]
> **Procedure not found in Oracle.** This package was referenced in application code but its source could not be retrieved from `DBA_SOURCE` during Phase 1b analysis. The referencing code path is flagged as **possibly dead code**.

**SQL Server also checked (2026-08-17).** This reference was additionally queried against all known SQL Server BDS databases via `legends sqlserver query`; no matching source was returned there either. The reference remains unresolved in both Oracle and SQL Server.

## Overview

| Field | Value |
| --- | --- |
| **Schema** | PK72970 |
| **Type** | Package (expected) |
| **Database** | Oracle* |
| **Status** | ⚠️ Not found in Oracle — possibly dead code** |
| **Calling libraries** | `SAIF.Business.Payment.EFT` |
| **Calling classes** | `clsEFTAuthorization` |

## Possibly dead code references

The following .NET code path references this procedure. Since the Oracle source could not be found, this call may be dead code:

| Class | Method | Procedure call | Source file |
| --- | --- | --- | --- |
| `clsEFTAuthorization` | `BeforeRetrieve` (CustomerID branch) | `PK72970_EPAY.retrieve_EFTAuth_ByCustomerID(:in_customer_type, :in_customer_id, :in_customer_second_id, OUT recordset)` | `Business\SAIF.Business.Payment.EFT\clsEFTAuthorization.vb` |

## Purpose

This package is expected to retrieve EFT authorization records by customer type code, customer ID, and customer secondary ID, returning results via a REF CURSOR output parameter.* The procedure is invoked from Variant C of `clsEFTAuthorization.RetrieveSQL` when neither `PaymentAuthorizationSeqNum` nor `AutoPayConfirmationNum` is populated.*

## Procedures / Methods

### retrieve_EFTAuth_ByCustomerID

| Field | Value |
| --- | --- |
| **Returns** | REF CURSOR (`recordset` output parameter)** |
| **Called by** | `clsEFTAuthorization.BeforeRetrieve` (CustomerID branch) |
| **Status** | Not confirmed — Oracle source unavailable** |

**Description:** Expected to query `PAYMENT_AUTHORIZATION` (or `PAYMENT_OWNER.PAYMENT_AUTHORIZATION`) filtered by customer type code, customer ID, and customer secondary ID, returning authorization records via a cursor.** Details cannot be confirmed without Oracle source access.

#### Parameters

| Parameter | Direction | Type | Description |
| --- | --- | --- | --- |
| `:in_customer_type` | IN | String (5) | Customer type code filter.** |
| `:in_customer_id` | IN | String (20) | Customer ID filter.** |
| `:in_customer_second_id` | IN | String (20) | Customer secondary ID filter.** |
| `recordset` | OUT | REF CURSOR | Result set of matching EFT authorization records.** |

## Related documentation
- [Procedure catalog](index.md)
- [SQL-045: clsEFTAuthorization retrieve (3 variants)](../sql/SQL-045-saif-business-payment-eft.md)
- [Business rules](../business-rules.md)
- [Operations and processes](../operations-processes.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` query returned no results for `PK72970.PK72970_EPAY`
- Referencing code: `Business\SAIF.Business.Payment.EFT\clsEFTAuthorization.vb`