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.**

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