Search Results arp_rate_adjustments_pkg




Overview
Explore in AI Chat

Overview

ARP_RATE_ADJUSTMENTS_PKG is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It provides the programmatic interface for creating records in the Receivables rate adjustment infrastructure. Rate adjustments in Oracle Receivables represent exchange rate differences that arise when foreign currency transactions are settled, revalued, or otherwise adjusted, and the resulting gain or loss must be recorded against the appropriate accounting distributions. This package encapsulates the insertion logic for the AR_RATE_ADJUSTMENTS entity, shielding callers from the underlying column mapping and identifier generation rules.

The package is declared with AUTHID CURRENT_USER, meaning that its SQL statements execute with the privileges of the invoking user rather than the definer. This is consistent with the standard Oracle EBS API convention that permits execution under the APPS schema while allowing invoker-rights resolution of synonyms and grants. The documented API classification is OTHER, indicating that it is an internal technical API rather than a formally published business object API exposed for broad customer extension.

Key Procedures and Functions

The package exposes a single documented program unit:

  • INSERT_P — Inserts a single rate adjustment record into the Receivables rate adjustment tables. According to the package specification, it accepts a record typed as ar_rate_adjustments%ROWTYPE as input and returns the newly generated rate adjustment identifier through an OUT parameter of type ar_rate_adjustments.rate_adjustment_id%TYPE. Passing the row as a %ROWTYPE record means the caller must populate the individual attributes of the rate adjustment before invocation. The OUT identifier allows the caller to retain a handle to the created row for subsequent processing, auditing, or downstream references.

No other procedures or functions are declared in the documented specification. The package body is not represented in the available metadata, so no additional private helpers or overloads should be assumed.

Tables Accessed

The documented table references, resolved through APPS synonyms, are as follows:

  • AR_RATE_ADJUSTMENTS — The base transactional table that stores rate adjustment records. INSERT_P writes the supplied row into this table.
  • AR_RATE_ADJUSTMENTS_S — The corresponding sequence or secondary table used to allocate the unique rate adjustment identifier returned by the OUT parameter.
  • AR_SYSTEM_PARAMETERS — The Receivables system options table, typically consulted to validate setup context such as currency rounding rules, accounting flexfield defaults, or other system-level controls that govern how the adjustment is recorded.
  • DUAL — The standard single-row utility table, used for identifier retrieval and simple scalar evaluations.

Usage Notes

Because the package is documented as OTHER and does not carry a published business API designation, it is primarily invoked by internal Oracle Receivables code rather than by customer-written integrations. The metadata records that it is referenced by two other packages, confirming that it functions as a lower-level building block within the Receivables rate adjustment flow.

Typical invocation occurs during settlement, revaluation, or adjustment processing when the application must persist a newly calculated exchange rate difference. Callers construct an ar_rate_adjustments%ROWTYPE record, invoke INSERT_P, and capture the returned identifier. Direct calls from Oracle Forms are unlikely; the procedure is normally reached through the PL/SQL layers that drive the relevant Receivables transactions. Custom code should invoke it only after confirming that no higher-level public API covers the same requirement, and should observe standard EBS commit and error-handling conventions, since the procedure itself does not appear to manage transaction boundaries.