Search Results work_isolation




Overview
Explore in AI Chat

Overview

APPS.EAM_PROCESS_ISOLATION_PVT is the private implementation body of the isolation processing API within Oracle Enterprise Asset Management (EAM). It belongs to the safety and isolation feature set of EAM and supports the business requirement of placing equipment assets into a controlled isolation state — for example, locking out or tagging out an asset prior to maintenance — and subsequently releasing that isolation. The package name reflects the term work isolation, which is the mechanism that prevents equipment from being returned to service until all required safety conditions and approvals have been satisfied.

The _PVT classification indicates this is a private or internal package. It is not intended to be called directly by customer code; instead, it exposes the business logic that public EAM safety APIs and concurrent processes invoke. The header identifies the source file as EAMVISOB.pls (version 120.8) and sets package constants including G_PKG_NAME, G_FILE_NAME, and G_DEBUG_FILENAME, the last pointing to EAM_SAFETY_DEBUG.log. Debug output is controlled through EAM_PROCESS_WO_PVT.get_debug, and messages are accumulated using types from EAM_ERROR_MESSAGE_PVT.

Key Procedures and Functions

  • VALIDATE_TRANSACTION_TYPE — Validates whether a given transaction type (entity) is permitted for the requested operation. The documented sample shows it checks that the entity ISOLATION is valid only for the create and update operations, returning FND_API.G_RET_STS_SUCCESS or FND_API.G_RET_STS_ERROR accordingly.
  • PROCESS_ISOLATION — The primary driver for isolation processing logic, orchestrating validation and persistence of isolation records.
  • WORK_ISOLATION — Implements the work isolation action itself, corresponding to the search term "work_isolation." This is the core routine that applies or manages the isolation state of an asset.
  • ESTABLISHMENT — Handles establishment-related processing, ensuring isolation actions are associated with the correct EAM establishment context.
  • RAISE_WORKFLOW_EVENTS — Raises the Oracle Workflow business events associated with isolation activities, enabling notification and approval workflows to proceed.

Tables Accessed

The package reads and writes through APPS synonyms. CSI_ITEM_INSTANCES provides the installed asset instance being isolated. EAM_ESTABLISHMENT_DETAILS and EAM_ESTABLISHMENT_DETAILS_S supply establishment configuration. EAM_ISOLATIONS_S is the primary transactional table storing isolation records. EAM_SAFETY_WORKFLOWS, EAM_SAFETYWORKFLOW_EVENT_S, and WF_PARAMETER_LIST_T support workflow event generation and parameter passing. WIP_EAM_PARAMETERS and MTL_PARAMETERS provide EAM and inventory operating parameters, while DUAL and PLITBLM are used for trivial selection and PL/SQL table handling.

Usage Notes

EAM_PROCESS_ISOLATION_PVT is invoked indirectly. EAM safety forms and the public isolation APIs call into this package during asset isolation and de-isolation transactions, and concurrent programs processing safety workflows may also reach it. Because it is a private package, customizations should call the supported public wrapper rather than this body directly. The package is referenced by three other packages, confirming its role as a shared internal service layer. Debug tracing can be enabled via the EAM process debug flag, with output written to the EAM safety debug log for troubleshooting.