Search Results arp_trx_global




Overview
Explore in AI Chat

Overview

ARP_TRX_GLOBAL is a global PL/SQL package in the APPS schema that supports transaction-level processing within the Oracle Receivables (AR) module of Oracle E-Business Suite. It serves as a shared utility layer and initialization mechanism for Receivables transaction APIs, particularly in conjunction with ARP_TRX_GLOBAL's companion packages ARP_GLOBAL, ARP_FLEX, and ARP_UTIL. The package is classified as OTHER in the ETRM API taxonomy, indicating it is an internal infrastructure component rather than a public, customer-facing API. Its primary role is to establish global context — such as system parameters, currency information, and organizational settings — that downstream transaction processing routines depend upon. In Oracle EBS 12.1.1 and 12.2.2, this package operates as part of the Receivables transaction engine that underpins AutoInvoice, manual transaction entry, and other Receivables transaction flows that must resolve authoritative system parameters before performing validation logic.

Key Procedures and Functions

The documented package body exposes a single procedure:

  • INIT — Initializes global package state for Receivables transaction processing. It is invoked to load and cache the transaction environment so that subsequent calls to transaction-related routines operate against a consistent set of global variables. Because it is the sole documented routine, INIT functions as the entry point that must be executed before dependent transaction logic relies on the package's global values.

No parameter lists are documented for INIT; it should be treated as a setup routine whose behavior is governed by profile and system parameter settings rather than by explicit invocation arguments. ETRM documentation confirms the object is VALID in the APPS schema and that no database object references it, meaning it is called from PL/SQL code rather than through foreign-key or trigger relationships.

Tables Accessed

The package body references two tables via APPS synonyms:

  • AR_SYSTEM_PARAMETERS — The Receivables system options table. INIT reads this table to obtain the operating configuration for the Receivables application, such as accounting and transaction-processing defaults that must be applied consistently throughout the session.
  • FND_CURRENCIES — The Oracle Application Object Library currency definitions table. This is accessed to resolve currency attributes (for example, precision or naming) required for transaction processing and to support multi-currency transaction scenarios.

Usage Notes

ARP_TRX_GLOBAL is invoked internally by Receivables transaction processing code rather than being called directly from forms or concurrent programs. ETRM metadata shows it references ARP_FLEX, ARP_GLOBAL, ARP_UTIL, FND_PROFILE, and the SYS.STANDARD package, confirming its role as a coordination layer between profile options, flexfield utilities, and Receivables transaction logic. It is referenced by 23 other packages, indicating broad internal reliance within the Receivables codebase. Because it is not referenced by any database object, its invocation occurs exclusively from PL/SQL callers. Custom code that replicates Receivables transaction processing should not call this package directly; instead, developers should use the supported Receivables APIs, which will trigger this initialization internally where required. The package is proprietary Oracle code, and its signatures and internal behavior are subject to change across EBS releases; any dependency on it in custom extensions should be treated as unsupported.