Search Results gl_cur_conv_rate_obj_tbl

Overview

APPS.GL_EXCH_RATES_SYNC_PKG is a General Ledger support package in Oracle E-Business Suite 12.1.1 and 12.2.2 that derives and returns currency conversion rates for a requested currency pair, date range, and conversion rate type. Its principal business role is to expose translated exchange rate information to EBS components that require programmatic access to rate data rather than direct table queries. The package resolves direct rates, inverse rates, and cross rates using the pivot currency configuration maintained in the cross rate rules, thereby allowing callers to obtain a conversion rate even when no seeded direct rate exists between the two currencies.

The header comment identifies the source file as glexrasb.pls, version 120.0.12010000.5, dated 2009/02/05. The package body is classified as OTHER within the ETRM repository, meaning it is not registered as a formal public API with a controlled interface, but it is nonetheless callable from PL/SQL. It is owned by APPS and is not referenced by any other documented package, which indicates it functions as a leaf-level utility rather than a shared dependency.

Key Procedures and Functions

The ETRM repository documents one procedure for this package body:

• GET_CUR_CONV_RATES — The sole documented entry point. It accepts input parameters identifying the source (from) currency, the target (to) currency, a from-date and to-date range, and a conversion rate type, and returns a collection of currency conversion rate records through an OUT NOCOPY parameter using the GL_CUR_CONV_RATE_OBJ_TBL object table type. The procedure also follows the standard concurrent program convention of returning errbuf and retcode OUT parameters, which allows it to be submitted as a concurrent request in addition to being called directly.
• Internal cursors and variables — The body declares cursors c_pivot_curr and c_con_curr to retrieve the pivot currency from GL_CROSS_RATE_RULES for the supplied conversion type and to identify the contra currency from GL_DAILY_RATES. Local collections such as l_dir_rates, l_cur_conv_rates, l_cur_conv_inv_rates, l_cr_rates, l_dir_cr_rates, and l_inv_cr_rates separate direct, inverse, and cross rate results before they are combined and returned.

The parameter names in the source reveal the intended lookup pattern: p_from_currency and p_to_currency supply the currency pair, while p_conversion_rate_type selects the rate category. These are documented facts from the package source, not inferred extensions. Callers searching on c_to_currency should note that the package exposes p_to_currency as its target currency parameter, while c_to_currency itself is a common naming convention used in downstream custom code rather than a documented symbol of this package body.

Tables Accessed

The package reads from the following APPS synonyms:

• GL_DAILY_RATES — The primary rate repository, queried for direct and inverse rates between currency pairs, including the contra currency of the conversion type.
• GL_DAILY_CONVERSION_TYPES — Supplies the conversion type definition associated with the requested rate type.
• GL_CROSS_RATE_RULES — Provides the pivot currency and description used to compute cross rates when no direct rate exists.
• GL_CROSS_RATE_RULE_DTLS — Supplies supporting detail rules that govern how cross rates are derived between the specified currencies.
• PLITBLM — A standard EBS PL/SQL table-type helper used in collection handling within the package body.

No INSERT, UPDATE, or DELETE statements are suggested by the metadata; the package behaves as a read-only utility over GL exchange rate configuration and daily rate data.

Usage Notes

Because GET_CUR_CONV_RATES returns errbuf and retcode, the package can be registered as a concurrent program and invoked from the Submit Requests form. It is equally usable from custom PL/SQL that requires programmatic currency conversion rates, such as interface programs, extracts, or reconciliation routines. Typical invocation supplies a from-currency, a to-currency, a date range, and a conversion rate type, then iterates the returned GL_CUR_CONV_RATE_OBJ_TBL collection.

Callers should be aware that the package is classified as OTHER rather than a certified public API, so its signature is not guaranteed to remain stable across patch levels. Where a supported alternative exists, Oracle's published currency conversion APIs should be preferred. In 12.2.2 the behavior is consistent with 12.1.1; the package remains a lightweight, read-only rate resolution helper rather than a maintenance utility, and it does not modify exchange rate data.