Search Results eam_process_safety_pub
Overview
APPS.EAM_PROCESS_ISOLATION_PVT is a private PL/SQL package within the Oracle Enterprise Asset Management (eAM) module of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. It supports the isolation and safety clearance workflow that governs when maintenance work may be performed on equipment. In eAM, an isolation is the deliberate de-energization or physical separation of an asset (electrical, mechanical, process, or fluid) so that maintenance personnel can work safely. The package encapsulates the business logic that validates, creates, progresses, and completes isolations, and it raises the workflow events that notify approvers and operational personnel. Its API classification is PVT (private), indicating it is not intended as a public integration surface; it is invoked by the public packages and workflow agents that make up the eAM safety and clearance feature set. The package is recorded as VALID in the APPS schema and is referenced by three other packages and by itself, reflecting internal recursive calls typical of workflow-driven processing loops.
Key Procedures and Functions
The documented package exposes five procedures or functions:
- VALIDATE_TRANSACTION_TYPE — Confirms that the requested isolation/transaction type is valid for the asset and context before any data is written, providing early error detection.
- PROCESS_ISOLATION — The core driver that applies the isolation transaction to an asset instance, including creating or updating isolation records and applying the associated safety state.
- WORK_ISOLATION — Handles the workflow-oriented processing of an isolation, coordinating the progression of an isolation through its lifecycle stages.
- ESTABLISHMENT — Manages establishment-specific data for the isolation, since eAM operating units (establishments) carry their own parameters and defaults.
- RAISE_WORKFLOW_EVENTS — Publishes the Oracle Workflow business events that trigger notifications, approvals, and downstream automation tied to the isolation and safety workflow.
Parameter lists are deliberately not reproduced here; consumers should treat this package as private and use the corresponding public API, EAM_PROCESS_SAFETY_PUB.
Tables Accessed
Access is performed through APPS synonyms in the standard EBS manner:
- CSI_ITEM_INSTANCES — The installed base instance record identifying the specific asset being isolated.
- EAM_ISOLATIONS_S — The primary isolation record describing the isolation being created or updated.
- EAM_ESTABLISHMENT_DETAILS and EAM_ESTABLISHMENT_DETAILS_S — Establishment-level configuration and defaults used during validation and establishment processing.
- EAM_SAFETY_WORKFLOWS and EAM_SAFETYWORKFLOW_EVENT_S — Workflow definitions and event queue records used by RAISE_WORKFLOW_EVENTS.
- WIP_EAM_PARAMETERS and MTL_PARAMETERS — eAM and inventory organization parameters supplying defaults and validation context.
- WF_PARAMETER_LIST_T — The Oracle Workflow parameter list type used to assemble event payloads; DUAL and PLITBLM support scalar and PL/SQL table operations.
Usage Notes
EAM_PROCESS_ISOLATION_PVT is not a public integration API. It is invoked indirectly through eAM isolation and safety screens, through the safety workflow background processes, and from the public package EAM_PROCESS_SAFETY_PUB, with which it has a bidirectional dependency. EAM_ISOLATION_WORKFLOW_PVT and EAM_PROCESS_CLEARANCE_PVT also call into it, meaning isolation status changes and clearance processing rely on its logic. Customizations should call EAM_PROCESS_SAFETY_PUB rather than this private package, since its signature may change between patch levels. Note that the searched term "eam_process_safety_pub" refers to the public counterpart; the dependency metadata confirms that EAM_PROCESS_SAFETY_PUB both references and is referenced by EAM_PROCESS_ISOLATION_PVT, so a failure in the private package will surface as errors in the public safety API.
-
PACKAGE: APPS.EAM_PROCESS_ISOLATION_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_PROCESS_ISOLATION_PVT, status:VALID,
-
PACKAGE: APPS.EAM_PROCESS_CLEARANCE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_PROCESS_CLEARANCE_PVT, status:VALID,
-
PACKAGE: APPS.EAM_PROCESS_PERMIT_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_PROCESS_PERMIT_PVT, status:VALID,
-
PACKAGE: APPS.EAM_SAFETY_ASSOCIATION_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_SAFETY_ASSOCIATION_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_PROCESS_SAFETY_PUB
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_PROCESS_SAFETY_PUB, status:VALID,
-
PACKAGE: APPS.EAM_PROCESS_SAFETY_PUB
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_PROCESS_SAFETY_PUB, status:VALID,
-
PACKAGE: APPS.EAM_ISOLATION_WORKFLOW_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_ISOLATION_WORKFLOW_PVT, status:VALID,
-
PACKAGE: APPS.EAM_ISOLATION_UTILITY_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_ISOLATION_UTILITY_PVT, status:VALID,
-
PACKAGE: APPS.EAM_WORKPERMIT_WORKFLOW_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_WORKPERMIT_WORKFLOW_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_ISOLATION_DEFAULT_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_ISOLATION_DEFAULT_PVT, status:VALID,
-
PACKAGE: APPS.EAM_CLEARANCE_DEFAULT_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_CLEARANCE_DEFAULT_PVT, status:VALID,
-
PACKAGE: APPS.EAM_ISOLATION_DEFAULT_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_ISOLATION_DEFAULT_PVT, status:VALID,
-
PACKAGE: APPS.EAM_PERMIT_DEFAULT_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_PERMIT_DEFAULT_PVT, status:VALID,
-
PACKAGE: APPS.EAM_CLEARANCE_UTILITY_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_CLEARANCE_UTILITY_PVT, status:VALID,
-
PACKAGE: APPS.EAM_PERMIT_UTILITY_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_PERMIT_UTILITY_PVT, status:VALID,
-
PACKAGE: APPS.EAM_PROCESS_SAFETY_PUB_W
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_PROCESS_SAFETY_PUB_W, status:VALID,
-
PACKAGE: APPS.EAM_CLEARANCE_WORKFLOW_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_CLEARANCE_WORKFLOW_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_PERMIT_UTILITY_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_PERMIT_UTILITY_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_PERMIT_DEFAULT_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_PERMIT_DEFAULT_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_CLEARANCE_DEFAULT_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_CLEARANCE_DEFAULT_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_PROCESS_SAFETY_PUB_W
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_PROCESS_SAFETY_PUB_W, status:VALID,
-
PACKAGE: APPS.EAM_SAFETY_UTILITY_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_SAFETY_UTILITY_PVT, status:VALID,
-
PACKAGE: APPS.EAM_ESTABLISHMENT_UTILITY_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_ESTABLISHMENT_UTILITY_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_ESTABLISHMENT_UTILITY_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_ESTABLISHMENT_UTILITY_PVT, status:VALID,
-
PACKAGE: APPS.EAM_PERMIT_VALIDATE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_PERMIT_VALIDATE_PVT, status:VALID,
-
PACKAGE: APPS.EAM_ISOLATION_VALIDATE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_ISOLATION_VALIDATE_PVT, status:VALID,
-
PACKAGE: APPS.EAM_CLEARANCE_VALIDATE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_CLEARANCE_VALIDATE_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_CLEARANCE_UTILITY_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_CLEARANCE_UTILITY_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_SAFETY_UTILITY_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_SAFETY_UTILITY_PVT, status:VALID,
-
PACKAGE: APPS.EAM_CREATEUPDATE_WO_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_CREATEUPDATE_WO_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_CLEARANCE_VALIDATE_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_CLEARANCE_VALIDATE_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_PROCESS_PERMIT_PUB
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_PROCESS_PERMIT_PUB, status:VALID,
-
PACKAGE BODY: APPS.EAM_ISOLATION_UTILITY_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_ISOLATION_UTILITY_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_PERMIT_VALIDATE_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_PERMIT_VALIDATE_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_SAFETY_ASSOCIATION_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_SAFETY_ASSOCIATION_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_ISOLATION_VALIDATE_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_ISOLATION_VALIDATE_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_CREATEUPDATE_WO_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_CREATEUPDATE_WO_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_PROCESS_PERMIT_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_PROCESS_PERMIT_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_WORKPERMIT_WORKFLOW_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_WORKPERMIT_WORKFLOW_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_CLEARANCE_WORKFLOW_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_CLEARANCE_WORKFLOW_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_ISOLATION_WORKFLOW_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_ISOLATION_WORKFLOW_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_PROCESS_ISOLATION_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_PROCESS_ISOLATION_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_PROCESS_CLEARANCE_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_PROCESS_CLEARANCE_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_PROCESS_WO_PUB
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_PROCESS_WO_PUB, status:VALID,
-
12.2.2 DBA Data
12.2.2
-
12.2.2 DBA Data
12.2.2
-
PACKAGE BODY: APPS.EAM_PROCESS_SAFETY_PUB
12.2.2
-
PACKAGE: APPS.EAM_CLEARANCE_UTILITY_PVT
12.2.2
-
PACKAGE: APPS.EAM_PROCESS_WO_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_PROCESS_WO_PVT, status:VALID,
-
APPS.EAM_CLEARANCE_UTILITY_PVT SQL Statements
12.2.2