Search Results hr_currency_pkg




Overview
Explore in AI Chat

Overview

HR_CURRENCY_PKG is a PL/SQL package body owned by the APPS schema within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It provides the currency conversion and exchange rate resolution logic used throughout the Oracle HRMS and Payroll modules. Its central role is to translate monetary amounts between currencies by resolving the appropriate daily conversion rate from the General Ledger rate tables, respecting the conversion type and the date on which the conversion is effective. In payroll processing, currency conversion is essential because assignments, element entries, and balances may be denominated in differing currencies, and consolidated reporting must present values in a common currency. The package also supports the fiscal conversion requirements of HRMS by wrapping the GL_CURRENCY_API facilities and exposing them through HR-specific entry points. The ETRM metadata classifies this package under API classification OTHER, indicating that it is an internal/infrastructure utility package rather than a public, externally supported business API. The package body carries a VALID status in the documented environment.

Key Procedures and Functions

The package body exposes twelve documented program units, which fall into three logical groups.

  • Rate type resolution: CHECK_RATE_TYPE and GET_RATE_TYPE validate and retrieve the conversion rate type applicable to a given conversion, returning the rate type identifier or confirming that a supplied rate type is valid for use.
  • Rate retrieval: GET_RATE and GET_RATE_SQL obtain the actual daily conversion rate between two currencies for a given rate type and date. The _SQL variants return the SQL text used to perform the lookup, enabling callers to embed the conversion directly in their own SQL statements rather than issuing a separate PL/SQL call.
  • Amount conversion: CONVERT_AMOUNT and CONVERT_AMOUNT_SQL apply the resolved rate to convert a numeric amount from a source currency to a target currency, again with SQL-emitting counterparts. IS_NCU_CURRENCY and IS_NCU_CURRENCY_SQL determine whether a currency is the national currency unit (NCU) of the operating context.
  • Euro/fixed-currency (EFC) facilities: EFC_CONVERT_NUMBER_AMOUNT, EFC_CONVERT_VARCHAR2_AMOUNT, EFC_GET_DERIVED_FACTOR, and EFC_IS_NCU_CURRENCY provide conversion support for the euro and other fixed-rate currency scenarios, including derived conversion factors and VARCHAR2-formatted amount conversion.

This arrangement of mirrored _SQL helpers is a common EBS pattern that allows conversion logic to be reused consistently in both procedural and set-based SQL contexts.

Tables Accessed

The package body references the following objects via APPS synonyms:

  • FND_CURRENCIES — the currency definition table, supplying currency codes, precision, and currency attributes used to validate and convert amounts.
  • GL_DAILY_CONVERSION_TYPES — the definition of valid conversion rate types (for example, Corporate, Spot, User-defined), used by CHECK_RATE_TYPE and GET_RATE_TYPE.
  • GL_DAILY_RATES — the daily exchange rate store, the primary source of the conversion rate retrieved for a currency pair, rate type, and effective date.
  • PAY_USER_COLUMN_INSTANCES_F — the Payroll user-defined column instance table, consulted in the payroll context for amount handling.

Dependency metadata additionally lists GL_CURRENCY_API, HR_CURRENCY_PKG itself (recursive reference), HR_UTILITY, and the SYS/STANDARD and DBMS_UTILITY built-ins as underlying dependencies. No database object is documented as referencing HR_CURRENCY_PKG, but the metadata records that it is referenced by 24 other packages, confirming its role as a shared conversion utility across HRMS and Payroll functionality.

Usage Notes

HR_CURRENCY_PKG is typically invoked indirectly. Payroll and HRMS forms and concurrent programs call the delegating packages that in turn invoke HR_CURRENCY_PKG when a currency conversion is required, such as during payroll run processing, balance translation, or multi-currency reporting. Custom code should prefer the documented conversion entry points, particularly the _SQL variants when conversion is needed inside a query, to ensure consistency with standard EBS rate resolution. Because the package reads rate data from the GL tables, conversions depend on the maintenance of daily rates and conversion types in General Ledger; missing or expired rates will cause conversion failures downstream. As an internal package classified OTHER, it is not part of the supported public API surface and may change between releases, so customizations should avoid direct dependency where a supported alternative exists.