Search Results eam_jobclose_priv




Overview
Explore in AI Chat

Overview

EAM_JOBCLOSE_PRIV is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It encapsulates the core business logic used by Oracle Enterprise Asset Management (EAM) to close work orders and work order operations, and to synchronize the resulting status changes with the Oracle Workflow notification infrastructure. The package is classified as OTHER in the ETRM registry, indicating that it is an internal implementation package rather than a public, customer-facing API. It does not expose a documented public interface and is intended to be invoked only by other Oracle EAM components.

In the EAM process flow, a work order progresses through defined statuses such as Released, Unreleased, On Hold, and Complete. When maintenance work is finished, the work order must be closed so that the associated costs, material transactions, and resource charges are finalized and no further transactions can be posted against it. EAM_JOBCLOSE_PRIV implements the validation and update logic that supports this closure, including the propagation of status changes to Oracle Workflow so that event subscriptions and notifications are triggered correctly.

Key Procedures and Functions

The ETRM metadata documents three program units within this package:

  • EAM_CLOSE_MGR — Serves as the manager-level entry point for the closure process. It orchestrates the overall close operation, performing the validations and coordinating the updates required before a work order can be finalized.
  • EAM_CLOSE_WO — Performs the work-order-level closure logic. It carries out the actual processing needed to move a work order into the closed state, operating on the underlying work order and discrete job records.
  • RAISE_WORKFLOW_STATUS_CHANGED — Raises the workflow status-changed event. It builds the workflow event payload and invokes the Workflow engine so that subscribers are notified when a work order's status transitions.

No parameter lists are documented in the ETRM metadata, and none should be assumed. The procedures are internal and are called by other compiled EAM packages.

Tables Accessed

The package reads and writes the following tables via APPS synonyms:

  • EAM_WORK_ORDER_DETAILS — Stores the EAM work order header and detail information that is evaluated and updated during closure.
  • EAM_WORKFLOW_EVENT_S — Holds the workflow event records generated when a status change is raised.
  • WIP_DISCRETE_JOBS — The discrete job record associated with the work order, used to drive the close operation in the manufacturing module.
  • WIP_DJ_CLOSE_TEMP — A temporary staging table used during discrete job closure processing.
  • WIP_ENTITIES — The common WIP entity table that links work orders, jobs, and their statuses.
  • WF_PARAMETER_LIST_T — The Workflow parameter list type used to pass event attributes when raising the status-changed event.
  • DUAL and PLITBLM — Utility objects used for single-row queries and PL/SQL index-by table handling.

Usage Notes

EAM_JOBCLOSE_PRIV is not intended for direct invocation by customers or customizations. It is referenced by the public EAM_WORKORDERTRANSACTIONS_PUB package and by EAM_WO_CHANGE_STATUS_PVT, which are the components typically called from the EAM Work Order form, concurrent programs, or custom code. Status changes initiated through the EAM user interface or through the work order transactions public API ultimately flow into this private package for closure execution and workflow event propagation.

Because the package is private, its signature may change between releases, and Oracle does not guarantee backward compatibility. Developers extending EAM should use the documented public APIs instead. This object is documented in both Oracle EBS 12.1.1 and 12.2.2, and its dependency on STANDARD and the SYS schema confirms it relies on core PL/SQL runtime services.