Search Results is_stock_enable

Overview

APPS.EAM_WL_UTIL_PKG is a utility package used by Oracle Enterprise Asset Management (eAM) Workbench functionality within Oracle E-Business Suite. The package is declared with AUTHID CURRENT_USER, meaning its unqualified database references resolve according to the privileges of the invoking user rather than the package owner. This characteristic places the package in a class of shared helper utilities intended to be called from eAM worklist and maintenance execution flows, where a consistent set of descriptive lookups is required across items, jobs, resources, serial numbers, and transactional validation.

The package encapsulates common retrieval operations that would otherwise be embedded in multiple forms or concurrent programs. It returns human-readable descriptions and derived values without exposing the caller to the underlying inventory and work-in-process schema. In EBS 12.1.1 and 12.2.2 the object remains available under the APPS schema and is referenced by other packages.

Key Procedures and Functions

The documented interface comprises eleven functions. Descriptions follow:

• get_item_description — returns the description for an item in the context of a given inventory organization. This is the function most often targeted when callers need a display label for an item identifier.
• get_concatenated_segments — returns the concatenated key flexfield segments for an item, providing the formatted item number rather than a surrogate ID.
• get_translatable_value — returns the meaning associated with a lookup code and lookup type, enabling multilingual display of coded values.
• get_department_code — returns the code for a department identified within an organization.
• get_wip_entity_name — returns the name of a work-in-process entity, typically the work order or job name.
• get_wo_status — returns the status of a work order entity for display or validation.
• get_serial_description — returns the description associated with a serial number for a specified item and organization.
• Is_Stock_Enable — determines whether an item is stock-enabled in the given organization, supporting inventory eligibility checks.
• get_instance_count — returns a count of resource instances for an operation sequence and WIP entity, considering organization and resource type.
• get_wip_job_sequence — returns the next job sequence number used in work order numbering.
• isESignatureRequired — indicates whether an electronic signature is required for a named transaction, supporting 21 CFR Part 11 compliance expectations in regulated environments.

Tables Accessed

The package reads from several core EBS tables via APPS synonyms. Item information is drawn from MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_KFV, while MTL_PARAMETERS supplies organization-level inventory controls. Serial data is obtained from MTL_SERIAL_NUMBERS and CSI_ITEM_INSTANCES. Work order and resource data comes from WIP_DISCRETE_JOBS, WIP_ENTITIES, WIP_JOB_NUMBER_S, WIP_OPERATION_RESOURCES, and WIP_OP_RESOURCE_INSTANCES. Department and resource definitions are read from BOM_DEPARTMENTS and BOM_RESOURCES. DUAL is used for scalar evaluations and PLITBLM for translated lookup values.

Usage Notes

EAM_WL_UTIL_PKG is typically invoked from eAM Workbench forms, maintenance work order pages, and custom extensions that require consistent descriptive lookups. Because it is a read-oriented utility package, it is safe to call from SQL or PL/SQL wrappers. Its reliance on AUTHID CURRENT_USER means callers must possess the necessary object privileges under their own schema context. The package is referenced by one other package, indicating reuse within the eAM module. When extending eAM functionality in either release, developers should favor these functions over direct table joins to preserve consistent formatting and organization-awareness.