Search Results exchange_rate_types

Overview

APPS.PAY_GCC_CURR_CONV is a server-side PL/SQL package body that supports Oracle E-Business Suite Payroll and HRMS functionality specific to the GCC (Gulf Cooperation Council) region. Its central purpose is to resolve the currency conversion rate type that a given business group should use for a specified effective date and processing context. Rather than hard-coding a rate type such as "Corporate" or "Spot," the package derives the applicable rate type dynamically from user-defined configuration stored against the business group. This design allows different legislative and operational environments to adopt distinct conversion policies while preserving a single, reusable resolution mechanism.

The package is classified as an OTHER API in the ETRM 12.2.2 metadata and exposes a single documented function, GET_CONVERSION_TYPE. It is registered under the APPS schema and is not referenced by any other documented package, indicating that it functions primarily as a utility routine consumed by forms, concurrent programs, or custom extensions rather than as a shared dependency within the standard product code base.

Key Procedures and Functions

• GET_CONVERSION_TYPE — Returns the conversion rate type applicable to a business group for a given effective date and processing type. Its purpose, as documented in the package header commentary, is to determine the rate type from three inputs: the business group, the date for which the rate type is required, and the processing type. Supported processing types are P (Payroll Processing), R (General HRMS reporting), and I (Business Intelligence System). The function returns NULL when no rate type can be found, and it also provides an output value that carries back the conversion date resolved during processing. Internally it uses the HR user-defined table value mechanism to retrieve the user-facing conversion type name configured for the business group under the EXCHANGE_RATE_TYPES table value, then translates that name into the corresponding Oracle General Ledger conversion type.

Tables Accessed

• PAY_USER_COLUMN_INSTANCES_F — The package reads this table through the HR user-defined table value API (hruserdt.get_table_value) to obtain the "Conversion Rate Type" value configured for the business group within the EXCHANGE_RATE_TYPES table value context. This is the source of the user-selected rate type.
• GL_DAILY_CONVERSION_TYPES — The package queries this General Ledger table to map the retrieved user_conversion_type to the internal conversion_type stored in GL. This translation ensures the returned value is compatible with the General Ledger currency conversion engine.

No write operations against documented tables are indicated; the package is read-only with respect to persistent data and derives its result entirely from configuration and setup values.

Usage Notes

PAY_GCC_CURR_CONV is typically invoked by GCC payroll processes, HRMS reporting logic, and business intelligence extracts that must convert amounts using the legislative rate type configured by the business group. Because the function accepts both the effective date and the processing type, callers can obtain different rate types for payroll processing versus reporting or BI consumption within the same business group, which supports the multicurrency requirements of GCC implementations.

Custom code should call GET_CONVERSION_TYPE rather than querying GL_DAILY_CONVERSION_TYPES directly, since the package encapsulates the business group configuration lookup and the user-to-GL conversion type translation. Callers should also be prepared to handle a NULL return, which signals that no rate type has been configured for the business group and date supplied. The package is compatible with both EBS 12.1.1 and 12.2.2, as reflected in its version header.