Search Results cs_chmc_pkg




Overview
Explore in AI Chat

Overview

CS_CHMC_PKG is a currency conversion utility package owned by the APPS schema in Oracle E-Business Suite. Its identifying header, $Header: csxchmcs.pls 115.2.1158.2 2003/03/13 02:55:07 aseethep ship $, indicates that the package belongs to the CS (Service) module family and was last shipped in the 11.5.x code line, from which it carries forward unchanged into EBS 12.1.1 and 12.2.2. The "CHMC" designation reflects its role in the Service/TeleService currency-handling layer, where amounts expressed in a foreign currency must be translated into the functional or another target currency for display, validation, or downstream processing. Rather than reimplementing exchange-rate logic, the package exposes a single, tightly scoped entry point so that Service module code and customer extensions obtain consistent conversion results. The package is declared AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the invoking session rather than the definer, so callers must themselves hold the required SELECT privileges on the underlying currency and rate objects.

Key Procedures and Functions

The documented package body exposes exactly one callable program unit:

  • CONVERT_AMOUNT — Converts a monetary amount from a source currency into a target currency as of a specified conversion date. The procedure accepts the from-currency, the amount to be converted, the conversion date, a conversion type (in the Oracle GL sense of a rate type such as Spot, Corporate, or User), and an optional user-defined rate, returning the converted amount through its OUT parameter. It is the sole currency-translation primitive offered by CS_CHMC_PKG and is intended to be the single point of control for rate resolution within the Service currency-handling flow.

No other procedures or functions are documented in the package specification, and the specification closes immediately after CONVERT_AMOUNT with END cs_chmc_pkg;. The parameter names and modes are recorded in the ETRM metadata; their data types follow standard EBS currency-conversion conventions (character currency codes, numeric amount, date, character conversion type, numeric user rate, numeric OUT result).

Tables Accessed

ETRM records no direct table references for CS_CHMC_PKG through APPS synonyms. This is consistent with a thin wrapper: the package specification itself contains no SQL, and the conversion work is delegated internally. At runtime, the body relies on the standard EBS currency infrastructure — the GL daily conversion rate and currency tables (for example GL_DAILY_RATES, GL_DAILY_CONVERSION_TYPES, and FND_CURRENCIES) — together with the Service module's setup tables, which are resolved dynamically rather than through static synonym grants captured by the ETRM extractor. Because there are no documented table dependencies and the package is referenced by zero other packages, its dependency footprint is minimal and its behavior is effectively isolated.

Usage Notes

CS_CHMC_PKG is an internal Service-module utility rather than a public integration API; ETRM classifies it as OTHER, and no other package references it in the documented metadata. It is typically invoked from Service (CS) forms, concurrent programs, or custom PL/SQL that must present or validate amounts in a non-functional currency. Callers pass the source currency, amount, conversion date, rate type, and optionally a user rate, then consume the OUT converted amount. Because the package is AUTHID CURRENT_USER and depends on GL currency objects resolved at runtime, custom code invoking CONVERT_AMOUNT should ensure the executing schema holds the necessary currency and rate privileges, and that a valid rate exists for the requested type and date. The absence of documented dependents also means the package should be treated as implementation detail: it is stable across 12.1.1 and 12.2.2, but support for it is not guaranteed as a customization interface.