Search Results is_unique

Overview

BIM_UTL_PKG is a utility package in the Oracle E-Business Suite Marketing (Oracle Trade Management / AMS) module. Its body, delivered as bimutlpb.pls, provides shared helper routines used across Marketing and Trade Management functionality for currency conversion, index management, history logging, and other cross-cutting tasks. The package is classified as an "OTHER" API in the ETRM repository and is owned by the APPS schema. It is a private-support package rather than a public, supported API, so its routines are generally consumed internally by other Marketing packages rather than called directly by customer extensions.

Key Procedures and Functions

The package body exposes four documented program units:

• CONVERT_CURRENCY — A function that converts an amount from a given source currency into the default Marketing currency. The target currency is derived from the AMS_DEFAULT_CURR_CODE profile option, and the conversion type is taken from the AMS_CURR_CONVERSION_TYPE profile. The routine validates that a conversion type has been defined; if the profile is null, it raises the OZF_NO_EXCHANGE_TYPE message and returns zero. Otherwise it delegates the actual conversion to the GL currency API (GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT), passing the from currency, to currency, conversion date, conversion type, amount, and roll-day parameters, and returns the converted amount. This is the routine most relevant to callers searching for currency-related helper logic such as uniqueness or rate handling.
• CREATE_INDEX — Creates a database index as part of the package's index-management utilities, using metadata tracked in the BIM_ALL_INDEXES table.
• DROP_INDEX — Removes a previously created index, complementing CREATE_INDEX and operating on the same index-metadata repository.
• LOG_HISTORY — Writes a record into the BIM_REP_HISTORY table, providing an audit trail of report or processing activity for Marketing objects.

Tables Accessed

The package references the following tables through APPS synonyms:

• BIM_ALL_INDEXES — Stores index definitions maintained by CREATE_INDEX and DROP_INDEX.
• BIM_REP_HISTORY — Target of LOG_HISTORY; holds historical or audit entries.
• FND_APPLICATION and FND_PRODUCT_INSTALLATIONS — Used to resolve application and product installation context.
• FND_ORACLE_USERID — Used for Oracle schema/user identity lookups.
• ALL_INDEXES and ALL_IND_COLUMNS — Data dictionary views consulted to verify the existence and column composition of indexes before create/drop operations.
• DUAL — Used for scalar evaluations and profile lookups.

Usage Notes

BIM_UTL_PKG is invoked internally by Marketing and Trade Management forms, concurrent programs, and related PL/SQL packages; the ETRM metadata records that it is referenced by four other packages. Because it is not a published API, it should be called from custom code only with caution, and any direct dependency should be revalidated on patching or upgrade. The CONVERT_CURRENCY function is the most commonly reused entry point, since it centralizes the profile-driven currency conversion logic used throughout the Marketing schema. The index-management routines (CREATE_INDEX, DROP_INDEX) and LOG_HISTORY support housekeeping and audit functions, and they are typically executed during setup, data migration, or periodic maintenance rather than in end-user transaction flows. In both EBS 12.1.1 and 12.2.2 the package remains under the APPS schema and is not part of the supported public API surface.