Search Results arp_global




Overview
Explore in AI Chat

Overview

ARP_GLOBAL is a foundational PL/SQL package body in the Oracle E-Business Suite Receivables (AR) module, owned by the APPS schema. Its central purpose is to initialize and expose session-level Receivables environment settings — commonly termed "global" values — that other Receivables APIs and forms depend upon at the start of a database session or concurrent request. In the context of release 12.1.1 and 12.2.2, the package acts as a bootstrap utility that resolves system parameters, organizational context, and functional currency information, then caches that state for reuse by downstream code.

The ETRM metadata records the object as VALID with an API classification of OTHER, indicating it is an internal, non-public-API utility rather than a published integration interface. Its high dependency count — referenced by 171 other packages — confirms its role as a low-level shared service within the Receivables codebase.

Key Procedures and Functions

Two procedures/functions are documented for this package:

  • INIT_GLOBAL — The principal initialization routine. It establishes or refreshes the package-level global variables that represent the Receivables session context, such as system parameter values and organizational access information. Callers invoke it to ensure the global state is populated before executing business logic that relies on those cached values.
  • TM_INSTALLED — A status-check routine that reports whether the Treasury Management (TM) functionality is installed in the current environment. This allows Receivables logic to branch conditionally when TM-dependent features are or are not present.

No parameter lists are documented in the ETRM metadata; exact signatures should be confirmed against the deployed package specification in the target environment.

Tables Accessed

The package reads the following documented tables (through APPS synonyms):

  • AR_SYSTEM_PARAMETERS — Supplies the Receivables system options that INIT_GLOBAL loads into package globals, including accounting and setup flags.
  • FND_CURRENCIES — Provides functional currency attributes used to interpret monetary values in the session context.
  • MO_GLOB_ORG_ACCESS_TMP — A Multi-Org temporary/global table used to determine organization access, enabling the package to resolve the correct operating unit context.

Additional dependencies recorded for ARP_GLOBAL include ARP_STANDARD, ARP_TRX_GLOBAL, ARP_UTIL, AR_MO_CACHE_UTILS, AR_MO_GLOBAL_CACHE, FND_GLOBAL, MO_GLOBAL, MO_UTILS, GL_SETS_OF_BOOKS, and FND_CONCURRENT_PROGRAMS_VL. These support caching, Multi-Org resolution, and ledger/currency lookups.

Usage Notes

ARP_GLOBAL is an internal utility that is not exposed to end users directly. It is typically invoked at the beginning of a Receivables session or concurrent program to seed global state before transactional processing begins. Because it is not referenced by any database object, it is consumed almost exclusively by other PL/SQL packages — most notably the 171 packages that depend on it — rather than by triggers or views. Forms and concurrent programs operating within Receivables rely on the initialized globals through intermediate APIs such as ARP_STANDARD and ARP_TRX_GLOBAL.

Custom code requiring Receivables session context should generally call the higher-level public APIs rather than INIT_GLOBAL directly; direct invocation is appropriate only when the caller must guarantee that global state is populated in a context where it has not already been set. Because the package is classified as OTHER and marked Oracle-proprietary, signature stability across patches is not guaranteed, and any custom dependency should be validated against each target release.