Results for “iex_payments_batch_pub”

38 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IEX_PAYMENTS_BATCH_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It forms part of the Advanced Collections (IEX) module, which supports collections strategy, delinquency monitoring, promise tracking, and payment processing. The package provides a public API surface for batch-level payment handling within the Collections application. Its classification as a "PUB" package indicates that it is intended to be callable by other application modules, extensions, and custom code, rather than serving purely as internal implementation.

The core business function of IEX_PAYMENTS_BATCH_PUB is to process collections-related payment activity in a controlled, concurrent-friendly manner. In the 12.2.2 documented schema, the package exposes two public entry points, IEX_PAYMENTS_CONCUR and PROCESS_PAYMENTS, and depends on the standard FND_API framework, indicating that it follows Oracle's established API conventions for error handling and message propagation. The presence of a package body and documented SQL statements confirms that it performs substantive database work rather than acting as a thin wrapper.

Key Procedures and Functions

The ETRM metadata documents two procedures within this package:

  • PROCESS_PAYMENTS — The primary business logic entry point. It drives the processing of payments relevant to the Collections domain, applying the package's validation and data-manipulation rules against the underlying transaction and payment records. As a public API, it is designed to be invoked programmatically rather than through direct table manipulation.
  • IEX_PAYMENTS_CONCUR — A concurrent-program-oriented wrapper. By naming convention within EBS, a suffix of CONCUR typically denotes an entry point intended for invocation by a concurrent program submission, allowing the same underlying payment-processing logic to run as a scheduled or on-demand batch job.

No parameter lists, return types, or function signatures are published in the ETRM excerpt; consumers should not assume argument structures beyond those confirmed in the source package specification.

Tables Accessed

Despite the reference to SQL statements in the dependency documentation, no physical table names are explicitly listed in the ETRM excerpt for IEX_PAYMENTS_BATCH_PUB. The package operates through APPS synonyms and the FND_API layer, and it participates in the broader Collections data model associated with delinquency and promise-to-pay processing. Its documented dependencies and the packages that reference it confirm that it manipulates collections payment data and feeds results back to related public APIs rather than exposing its own standalone data store.

Usage Notes

IEX_PAYMENTS_BATCH_PUB is referenced by IEX_DELINQUENCY_PUB and IEX_PROMISES_BATCH_PUB, as well as recursively by itself. This dependency pattern indicates that delinquency processing and promise tracking in Advanced Collections rely on this package to handle or validate payment records. Because it is a public package built on FND_API, it is appropriate to call from custom concurrent programs, workflow activities, and extension code that needs to process collections payments. The IEX_PAYMENTS_CONCUR procedure should be the preferred entry point when invoking the logic from a concurrent program definition. Developers should note that the metadata does not document parameter contracts; parameter details must be obtained from the package specification in the target instance before integration.