Search Results arp_ctlgd_pkg




Overview
Explore in AI Chat

Overview

ARP_CTLGD_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Receivables. Its name reflects its role: it manages control and general-ledger distribution records associated with customer transactions — the rows that populate RA_CUST_TRX_LINE_GL_DIST and related control tables. In the ETRM 12.2.2 metadata, the object is classified as OTHER, indicating it is an internal support package rather than a published public API. Functionally, the package encapsulates insert, update, delete, and locking logic for transaction line distributions, including multi-ledger and reporting-currency handling. It is an integral part of the Receivables transaction accounting engine and is referenced by 14 other database objects, confirming its role as a shared low-level utility rather than an end-user entry point.

Key Procedures and Functions

ETRM documents 28 procedures and functions. The bulk follow a consistent internal naming convention that separates a dispatcher routine from its per-key implementations:

No parameter lists are published in the metadata; callers should not assume signatures and must rely on the delivering patch level of the package.

Tables Accessed

The package reads and writes the core Receivables distribution schema:

Package-level dependencies include ARP_STANDARD, ARP_UTIL, ARP_GLOBAL, ARP_TRX_UTIL, ARPCURR, AR_MRC_ENGINE, APP_EXCEPTION, GL_CA_UTILITY_PKG, and FND_MESSAGE, which provide error handling, global constants, and multi-org/multiple-reporting-currency support.

Usage Notes

Because ARP_CTLGD_PKG is not exposed through a public API and is not referenced by any database object outside its own dependency chain, it is normally invoked indirectly: through Receivables transaction forms, through AutoAccounting and accounting-generation concurrent programs, and through higher-level PL/SQL utilities such as ARP_TRX_UTIL. Custom extensions should not call its procedures directly, as signatures and internal assumptions may change between patch levels without notice. Where custom code must manipulate distribution rows, the supported approach is to use documented Receivables public APIs and scripts. Diagnostic use of the package is limited to tracing its calls during accounting generation when reconciling distribution amounts, accounting dates, or reporting-currency values in RA_CUST_TRX_LINE_GL_DIST.