Search Results po_req_exists

Overview

APPS.EAM_WO_CHANGE_STATUS_PVT is a private (PVT) PL/SQL package within the Oracle Enterprise Asset Management (eAM) module of Oracle E-Business Suite 12.1.1 / 12.2.2. Its purpose is to centralize the business logic that governs work order status transitions in Enterprise Asset Management. Work orders progress through a lifecycle that includes Unreleased, Released, On Hold, Complete, and Closed states, and each transition carries validation and side-effect requirements. This package encapsulates those requirements so that the public API layer, principally EAM_PROCESS_WO_PVT, does not need to re-implement status change logic directly.

The PVT suffix indicates that this is an internal package intended for use by other eAM packages rather than by external callers directly. It is a core component of the work order processing stack and is closely coupled with EAM_PROCESS_WO_PVT and EAM_ERROR_MESSAGE_PVT.

Key Procedures and Functions

• CHANGE_STATUS — The principal routine of the package. It performs the actual transition of an eAM work order from one status to another, applying validation rules and coordinating the side effects that accompany a status change, such as updates to work order details and route records.
• CREATE_OSP_REQ_AT_REL — Invoked during work order release to create outside processing (OSP) requisitions. When a work order contains operations designated for external suppliers, this routine generates the corresponding purchasing requisition so that the OSP procurement cycle can begin.
• PO_REQ_EXISTS — A helper routine that checks whether a purchase requisition already exists for the work order in question, thereby preventing duplicate requisition creation during release processing.

Tables Accessed

The package reads and writes a broad set of eAM, inventory, and purchasing tables:

• EAM_WORK_ORDER_DETAILS, EAM_WORK_ORDER_ROUTE, EAM_WORK_ORDER_ROUTE_S — store work order header detail, operations, and their status history; these are updated or read during status transition and release.
• EAM_WO_RELATIONSHIPS — holds relationships between work orders, relevant when a status change affects dependent orders.
• MTL_EAM_NETWORK_ASSETS, CSI_ITEM_INSTANCES — identify the asset or item instance against which the work order is executed.
• MTL_SYSTEM_ITEMS_B, MTL_PARAMETERS, HR_ORGANIZATION_INFORMATION — provide item definitions and organization context used to resolve the operating unit and inventory organization.
• ORG_ACCT_PERIODS — validates that the accounting period is open before allowing status changes that generate accounting activity.
• PO_REQUISITIONS_INTERFACE_ALL, PO_HEADERS_ALL, PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS_ALL, PO_RELEASES_ALL — support OSP requisition creation, distribution, and the PO_REQ_EXISTS check.

Usage Notes

The package is a dependency of APPS.EAM_PROCESS_WO_PVT and is referenced by that package. Callers searching for eam_process_wo_pvt will find EAM_WO_CHANGE_STATUS_PVT listed as a dependency in the ETRM dependency graph, which is why the two objects are frequently examined together. The package is not intended for direct invocation from forms or custom code; instead, status changes and releases are driven through EAM_PROCESS_WO_PVT, which in turn delegates to this private package. It is typically executed in the context of the eAM Work Order form, the Work Order Interface processing, or concurrent programs that release or update work orders in batch. Because it is a PVT package, Oracle does not guarantee its signature across releases, and customizations should target the public API layer rather than call this package directly.