Search Results menu_has_function

Overview

The APPS.EAM_WORKORDER_UTIL_PKG package is a core Enterprise Asset Management (EAM) utility library in Oracle E-Business Suite, shipped in both 12.1.1 and 12.2.2. It supplies shared programmatic logic used throughout the EAM work order module to build, adjust, schedule, and release asset work orders and their associated operations, resources, and material requirements. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the owner, and is referenced by 27 other packages, confirming its role as a low-level dependency for higher-level EAM work order APIs and forms.

Beyond work order manipulation, the package also provides supporting infrastructure: responsibility and IP lookup helpers, workflow retrieval, menu/function security checks, path logging, and diagnostic message display. This breadth reflects its classification as OTHER — an internal utility rather than a public business API, though several procedures are commonly invoked from custom code. The user search term adjust_resources maps directly to a documented procedure in this package.

Key Procedures and Functions

• ADJUST_RESOURCES — Adjusts the resource assignments on an EAM work order, applying changes to resource requirements in line with the work order definition.
• ADJUST_OPERATIONS — Modifies the operation routing on an EAM work order.
• ADJUST_WORKORDER — Entry point for applying general adjustments to an existing work order.
• RETRIEVE_ASSET_BOM — Returns asset bill-of-material components into a t_bom_table collection; the context parameter distinguishes stocked versus non-stocked inventory, and an error code signals full success, partial success (some components exist), or failure.
• COPY_TO_BOM — Copies retrieved asset BOM data into the work order BOM structure.
• CREATE_DEFAULT_OPERATION — Creates a default operation on a work order when none is defined.
• CANCEL and UNRELEASE — Cancel a work order or reverse a release action.
• DEPENDENCY_VIOLATED — Validates whether a dependency rule has been breached.
• CHECK_RELEASED_ONHOLD_ALLOWED and CK_MATERIAL_ALLOC_ON_HOLD — Constraint checks governing release/hold behavior and material allocation on hold.
• CHECK_OPEN_TXNS — Verifies open transactions before an action proceeds.
• RESOURCE_SCHEDULABLE — Determines whether a resource can be scheduled.
• MENU_HAS_FUNCTION — Security helper testing whether a menu exposes a given function.
• GET_IP_RESP_ID and GET_EAM_RESP_ID — Retrieve the Inventory/Integrated Planning and EAM responsibility identifiers respectively.
• GET_WORKFLOW_DETAILS and GET_REBUILD_DESCRIPTION — Return workflow approver/status information and rebuilt descriptive text.
• SHOW_MESG and LOG_PATH — Message display and debug path logging utilities.

Tables Accessed

The package works primarily against EAM tables: EAM_WORK_ORDER_DETAILS (work order header/detail data), EAM_WO_WORKFLOWS (approval workflow state), and MTL_MATERIAL_TRANSACTIONS_TEMP (pending material movements). Master data is read from MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_KFV, MTL_SYSTEM_ITEMS, MTL_UNITS_OF_MEASURE, and MTL_UOM_CONVERSIONS to resolve item and unit-of-measure details. Responsibility and security validation draws on FND_RESPONSIBILITY, FND_MENU_ENTRIES, FND_FORM_FUNCTIONS, and FND_USER. Workflow approver information is sourced from AME_CALLING_APPS, PER_ALL_PEOPLE_F, and PER_ADDRESSES.

Usage Notes

EAM_WORKORDER_UTIL_PKG is invoked by the EAM Work Order form, by concurrent programs that process or adjust work orders, and by the 27 dependent packages that call it internally. ADJUST_RESOURCES in particular is reached when a user modifies resource assignments on an existing work order in the Maintenance Work Order form, but custom integrations performing programmatic resource adjustments may also call it. Because the package is not a formally published API, direct custom invocation should follow the same validation sequencing the standard forms apply. Developers should rely on the collection types (t_bom_table, t_component_table, t_optime_table, t_workflow_table) for structured data exchange and must interpret RETRIEVE_ASSET_BOM error codes carefully: 0 indicates success, 1 partial success, and 2 failure.