Results for “process_exchangerate”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ITG_SYNCEXCHINBOUND_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its name—Sync Exchange Inbound—indicates that it handles the inbound synchronization of currency exchange rate data into the ETRM (Enterprise Tax and Regulatory Management, historically associated with the iTAP/Telecom product family) integration layer. The package is declared with AUTHID CURRENT_USER, meaning its executable code runs with the privileges of the calling schema rather than as the definer, a characteristic typical of internal integration utilities that expect the invoker to hold the necessary object grants.

The package header carries ARCS version control metadata referencing itgvseis.pls at version 120.1 (dated 2005/10/06) and CVS revision 1.4 (2002/12/23). This long revision history confirms the package has been a stable component of the currency-rate synchronization infrastructure since early releases and has been carried forward, largely unchanged, into 12.1.1 and 12.2.2. The API classification of "PVT" reinforced by the _PVT suffix signals that this is an internal helper package not intended for direct customer invocation; it is consumed by other EBS programs that feed exchange rate information into the system from external or upstream sources.

Key Procedures and Functions

ETRM documents a single procedure in the package specification:

• Process_ExchangeRate — The sole public entry point. It accepts an exchange rate transaction for processing, including a synchronization indicator, quantity, source and target currencies, conversion factor, set of books, rate type, and both creation and effective dates. It returns standard concurrent-style output parameters for status and message reporting (x_return_status, x_msg_count, x_msg_data). The parameter profile—particularly p_sob, p_ratetype, and the effective/creation dates—demonstrates that the procedure is designed to validate and then persist a daily rate into the GL environment on behalf of an inbound integration.

Tables Accessed

Per the documented ETRM metadata, the package touches three objects through APPS synonyms:

• FND_CURRENCIES — Read to validate that the supplied source and target currency codes are enabled and recognized by the applications, before attempting any rate load.
• GL_DAILY_RATES_INTERFACE — The standard General Ledger open interface table for daily conversion rates. Process_ExchangeRate writes validated rate rows here so that they can subsequently be imported into GL_DAILY_RATES by the standard GL rate interface program.
• DUAL — Used for simple single-row expressions and value lookups within the procedure logic.

Usage Notes

ITG_SYNCEXCHINBOUND_PVT is referenced by one other ETRM package, confirming it functions as a subordinate utility rather than a top-level API. It is typically invoked indirectly—through the upstream synchronization package that detects inbound rate changes and delegates the actual write to Process_ExchangeRate. Because it stages records in GL_DAILY_RATES_INTERFACE rather than writing directly to GL_DAILY_RATES, the standard GL daily rate import concurrent program must still be executed afterward for the rates to become effective. Custom code should not call this package directly; developers should instead use the documented public interfaces and then submit the GL conversion rate import. As a private package, its signature may change without public notice across patch levels, though the 2002-to-2005 revision history suggests it has remained functionally stable through 12.1.1 and 12.2.2.