Search Results get_count

Overview

APPS.EAM_WL_UTIL_PKG is a utility package body belonging to the Oracle Enterprise Asset Management (EAM) module in Oracle E-Business Suite 12.1.1 and 12.2.2. Its name reflects its role in the EAM Work List (WL) subsystem, where it supplies lightweight lookup and validation helpers consumed by EAM work management screens and processes. The package consolidates a set of small, single-purpose functions that resolve descriptive or attribute data from inventory, bills of material, work in process, and installation (CSI) tables into scalar return values. Because these helpers are centralized, EAM work order and work list components avoid duplicating join logic against item master, department, resource, and serial number data.

Per the ETRM metadata, the package is classified as API type OTHER and exposes eleven documented functions. It is referenced by one other package, confirming its role as a shared internal utility rather than a top-level public API. Several of its functions declare private cursors literally named GET_VALUE, which is the term the user searched for; these cursors are local to functions such as GET_CONCATENATED_SEGMENTS and GET_TRANSLATABLE_VALUE and fetch a single row into a local variable before returning it.

Key Procedures and Functions

• GET_ITEM_DESCRIPTION — Returns the item description for a given item and maintenance organization, joining the item master to organization parameters.
• GET_CONCATENATED_SEGMENTS — Returns the concatenated key flexfield segments of an item from the key flexfield view.
• GET_TRANSLATABLE_VALUE — Returns the translated meaning of a lookup code for a given lookup type from the manufacturing lookups table.
• GET_DEPARTMENT_CODE — Returns the department code for a department and organization combination.
• GET_WIP_ENTITY_NAME — Resolves the WIP entity name for use on work list and work order displays.
• GET_WO_STATUS — Returns the work order status associated with a work order entity.
• GET_SERIAL_DESCRIPTION — Returns the serial number description associated with an inventory instance.
• IS_STOCK_ENABLE — Determines whether an item is stock-enabled, supporting material issue and pick logic.
• GET_INSTANCE_COUNT — Returns a count of instances, typically asset or serial instances linked to an entity.
• GET_WIP_JOB_SEQUENCE — Returns the job sequence for a work order, used in job numbering.
• ISESIGNATUREREQUIRED — Indicates whether an electronic signature is required for a given action, supporting EAM e-signature compliance.

Tables Accessed

The package reads from BOM_DEPARTMENTS and BOM_RESOURCES for department and resource data, MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_KFV for item attributes and concatenated segments, and MTL_PARAMETERS to resolve the maintenance organization. Serial and instance data come from MTL_SERIAL_NUMBERS and CSI_ITEM_INSTANCES. Work order data is drawn from WIP_DISCRETE_JOBS, WIP_ENTITIES, WIP_JOB_NUMBER_S, WIP_OPERATION_RESOURCES, and WIP_OP_RESOURCE_INSTANCES. DUAL and PLITBLM are used for scalar evaluation and translation support.

Usage Notes

The package is typically invoked from EAM work management forms, work list regions, and custom PL/SQL that needs compact item, department, or work order lookup values. It may also be called from concurrent programs and other packages (one documented referencing package) that build EAM work order output. Callers should expect single-row retrievals with no exception handling for NOT_FOUND; defensive coding around null returns is advisable.