Search Results eam_workorder_util_pkg




Overview
Explore in AI Chat

Overview

APPS.EAM_WORKORDER_UTIL_PKG is a valid PL/SQL package body in the Oracle E-Business Suite Enterprise Asset Management (EAM) module. It provides the shared utility layer that supports work order creation, modification, release, and cancellation processing within EAM. The package encapsulates common logic that multiple EAM work order entry points depend upon, allowing the Work Order form, concurrent processing, and workflow-driven operations to reuse consistent validation, adjustment, and setup rules. Its API classification is OTHER, meaning it is not registered as a formal public API but is nevertheless referenced by a substantial number of dependent objects — the ETRM metadata records that it is referenced by 27 other packages, indicating a high degree of reuse across the EAM codebase. The package body is owned by APPS and reports VALID status in both Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented package exposes 23 procedures and functions. The principal work order processing routines include COPY_TO_BOM and RETRIEVE_ASSET_BOM, which support transfer of asset bill of material structure between assets and work orders; ADJUST_WORKORDER, ADJUST_OPERATIONS, and ADJUST_RESOURCES, which handle adjustments to the work order header, its operations, and the resources assigned to those operations; and CREATE_DEFAULT_OPERATION, which generates a default operation for a work order.

Tables Accessed

The package reads and writes a broad set of EAM, manufacturing, purchasing, and foundation tables through APPS synonyms. Work order and workflow state resides in EAM_WORK_ORDER_DETAILS and EAM_WO_WORKFLOWS. Item, unit of measure, and conversion data are taken from MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_KFV, MTL_UNITS_OF_MEASURE, and MTL_UOM_CONVERSIONS, with material transaction staging in MTL_MATERIAL_TRANSACTIONS_TEMP. Purchasing and requisition references include PO_DISTRIBUTIONS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_LINE_TYPES, PO_REQUISITIONS_INTERFACE_ALL, PO_REQUISITION_HEADERS_ALL, and PO_REQUISITION_LINES_ALL. Foundation and security data come from FND_RESPONSIBILITY, FND_USER, FND_FORM_FUNCTIONS, FND_MENU_ENTRIES, PER_ADDRESSES, PER_ALL_PEOPLE_F, and AME_CALLING_APPS for approval routing.

Usage Notes

EAM_WORKORDER_UTIL_PKG is invoked internally by EAM work order forms, workflow background processes, and the WIP and BOM integration packages that depend on it. It is not referenced by any database object, confirming it acts exclusively as a utility provider rather than a triggered component. Customizations should treat it as an internal package: extensions should call the documented procedures rather than modify the body, since its dependencies span work order, cost, purchasing, and approval subsystems and changes may affect the 27 dependent packages.