Search Results arp_receivables_trx_pkg

Overview

ARP_RECEIVABLES_TRX_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Receivables. It encapsulates logic associated with the AR_RECEIVABLES_TRX entity, which defines the receivable transaction types used to classify activities that affect customer balances—such as invoices, credit memos, debit memos, chargebacks, and adjustments. The package is classified as an OTHER API within the ETRM repository, meaning it is not a formally published public interface such as the Receivables open interfaces (for example, AR_INVOICE_API_PUB), but rather an internal code unit referenced by other Receivables components. The package is documented as VALID in both 12.1.1 and 12.2.2, confirming that the object and its dependent package body compile successfully in the APPS schema. Its principal role is to provide a controlled access path to receivable transaction type data, shielding callers from direct SQL against the AR_RECEIVABLES_TRX table.

Key Procedures and Functions

The ETRM metadata documents a single program unit within the package: FETCH_P.

• FETCH_P — A fetch procedure that retrieves receivable transaction type information from AR_RECEIVABLES_TRX. Based on the naming convention and the table it accesses, FETCH_P is designed to return the attributes of one or more transaction types into out parameters or a PL/SQL record accessible to the calling code. Its purpose is to centralize the retrieval of transaction type definitions so that validation and defaulting logic elsewhere in Receivables remains consistent. Because ETRM does not publish the parameter signature for this object, parameter names, types, and modes are not reproduced here; developers who must invoke it should inspect the package specification in the APPS schema directly.

No additional documented procedures or functions are present in the ETRM listing for this package. The package body exists and compiles, but its internal helper routines are not part of the documented surface.

Tables Accessed

The package references one table through APPS synonyms:

• AR_RECEIVABLES_TRX — The base table that stores receivable transaction type definitions, including the transaction type identifier, name, class, sign, and associated accounting rules. FETCH_P reads this table to supply transaction type details to its callers. The metadata records no other table dependencies, indicating that the package is narrowly scoped to transaction type retrieval rather than to broader transaction processing or accounting logic.

Usage Notes

ARP_RECEIVABLES_TRX_PKG is an internal implementation package. The ETRM dependency report shows that it is not referenced by any other documented packages, which indicates that its consumers are most likely Oracle Forms libraries, other internal Receivables packages not captured in this metadata extract, or bespoke extensions. Typical invocation patterns include:

• Autocustom or Forms-based logic in Receivables setup and transaction entry windows that needs to resolve a transaction type before defaulting or validating a transaction.
• Custom PL/SQL that must obtain transaction type attributes without issuing uncontrolled queries against AR_RECEIVABLES_TRX.

Because the object is classified as OTHER and its parameter interface is not published in ETRM, custom code should treat the package as subject to change between releases and should verify the specification against the target instance before use. Where a supported alternative exists, Oracle-published Receivables APIs should be preferred. Organizations running 12.1.1 or 12.2.2 can rely on the package being valid in APPS, but must confirm that any direct calls remain compatible after patching or upgrade, since internal package signatures are not governed by the same backward-compatibility guarantees as public APIs.