Results for “okc_currency_api”

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

Overview

The APPS.OKC_CURRENCY_API package body is a public PL/SQL API within the Oracle E-Business Suite Contracts (OKC/ETRM) application. Its primary business function is to centralize currency-related processing for the Oracle Contracts modules, including the determination of functional currency from operating units and sets of books, currency validation, exchange rate retrieval, and monetary amount conversion. By encapsulating these operations in a single API, the package provides a consistent, reusable interface for currency handling across contract authoring, validation, and reporting logic.

The package is defined with a status of VALID in the APPS schema and is classified as an API. It sits between the Contracts foundation layer and Oracle General Ledger currency services, delegating low-level rate and conversion logic to GL_CURRENCY_API while exposing contract-oriented entry points to other ETRM components. It is referenced by 27 other database objects, underscoring its role as a shared utility for currency determination and conversion across the Contracts schema.

Key Procedures and Functions

The package exposes 13 documented procedures and functions:

• GET_OU_CURRENCY — Returns the currency associated with a given operating unit.
• GET_SOB_CURRENCY — Returns the functional currency of a specified set of books.
• GET_OU_SOB — Retrieves the set of books associated with an operating unit.
• GET_OU_SOB_NAME — Returns the name of the set of books for an operating unit.
• IS_USER_RATE_ALLOWED — Indicates whether user-defined exchange rates are permitted in the current context.
• GET_RATE — Retrieves the applicable exchange rate between two currencies for a given date and rate type.
• VALIDATE_CONVERSION_ATTRIBS — Validates the attributes required for a currency conversion to ensure consistency and completeness.
• CONVERT_AMOUNT — Converts a monetary amount from one currency to another using the resolved rate.
• GET_INFO — Returns descriptive currency information.
• GET_CURRENCY_TYPE — Returns the type classification of a given currency.
• GET_EURO_CURRENCY_CODE — Returns the Euro currency code, supporting Euro-related processing.
• IS_EURO_CONVERSION_NEEDED — Determines whether Euro conversion applies to a given currency.

Tables Accessed

The package references several foundation tables, primarily through APPS synonyms. FND_CURRENCIES supplies currency definitions, precision, and descriptive attributes used by the info and currency-type functions. HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION are used to resolve operating unit context and its linkage to a set of books, supporting the operating-unit currency functions. Set of books data is accessed through the OKX_SET_OF_BOOKS_V view and GL_SETS_OF_BOOKS, while conversion and rate logic is delegated to GL_CURRENCY_API and FND_API, with FND_PROFILE supplying profile option values and OKC_CONTEXT providing contract context.

Usage Notes

OKC_CURRENCY_API is typically invoked from Contracts forms, concurrent programs, and custom PL/SQL extensions that require currency resolution or conversion without duplicating General Ledger logic. Callers rely on it to derive the functional currency from an operating unit or set of books, validate conversion prerequisites, obtain exchange rates, and convert amounts during contract creation, pricing, and amendment processing. Because it is referenced by 27 other packages yet references no upstream Contracts object, it serves as a stable, foundational dependency; customizations should call the packaged API rather than querying the underlying FND and GL tables directly to remain upgrade-safe across EBS 12.1.1 and 12.2.2.