Search Results eam_common_utilities_pvt




Overview
Explore in AI Chat

Overview

EAM_COMMON_UTILITIES_PVT is an internal (private) PL/SQL package body owned by the APPS schema that provides shared validation, lookup, and value-hydration utilities for the Oracle Enterprise Asset Management (EAM) product family. Its classification as a PVT package indicates it is not a public API: it exists to serve other EAM packages rather than to be called directly by customer extensions. In both EBS 12.1.1 and 12.2.2 the object is shipped with a status of VALID, and it is referenced by 25 other packages, confirming its role as a foundational helper layer beneath the EAM work-order, asset-numbering, and meter-processing APIs.

The package consolidates low-level checks that would otherwise be duplicated across EAM maintenance logic: resolving organization and item identifiers, validating department, location, meter, accounting-class, and descriptive-flexfield values, formatting item and lookup display names, and supplying session context such as the current accounting period and currency. By centralizing these routines, EAM achieves consistent error handling (typically through FND_MESSAGE and FND_MSG_PUB) and consistent use of FND_API conventions across work-order creation, asset definition, and meter reading flows.

Key Procedures and Functions

The ETRM metadata documents 44 procedures and functions. Representative members include:

Parameter signatures are intentionally omitted here; callers should treat this body as private and reference the public EAM APIs instead.

Tables Accessed

Table access spans several EBS schemas through APPS synonyms:

Cross-package dependencies include EAM_ASSET_NUMBER_PVT, EAM_PROCESS_WO_PUB/PVT, EAM_WORKORDER_UTIL_PKG, FND_API, FND_GLOBAL, FND_MESSAGE, FND_MSG_PUB, FND_PROFILE, FND_LOG, FND_FLEX_DESCVAL, and INV_QUANTITY_TREE_PVT.

Usage Notes

EAM_COMMON_UTILITIES_PVT is not referenced by any database object and is not exposed as a customer-facing API. It is invoked indirectly whenever an EAM form, concurrent program, or public API performs work-order processing, meter entry, asset numbering, or maintenance-location assignment. Typical callers are the EAM work-order and asset-management screens and the maintenance-related concurrent programs that submit work orders and meter transactions. Because the package is private, customizations should call the supported public APIs (for example EAM_PROCESS_WO_PUB) rather than referencing this body directly; direct calls risk incompatibility across 12.1.1 and 12.2.2 patch levels.