Search Results eam_wo_network_validate_pvt




Overview
Explore in AI Chat

Overview

EAM_WO_NETWORK_VALIDATE_PVT is a private PL/SQL package in the APPS schema that provides validation logic for Enterprise Asset Management (EAM) work order networks. In Oracle EBS 12.1.1 and 12.2.2, EAM work orders can be structured as networks of related operations or child work orders, forming parent-child hierarchies and predecessor-successor relationships. This package enforces the structural, status, and constraint rules that govern those networks before changes are committed. It is classified as a PVT (private) API, meaning it is intended for internal consumption by other EAM packages rather than direct calls from external or customer code. The user search term "eam_process_wo_pub" is directly relevant: APPS.EAM_PROCESS_WO_PUB is the public work order processing API, and EAM_WO_NETWORK_VALIDATE_PVT is both referenced by and references that package, positioning this package as a validation subordinate within the EAM work order processing call stack.

Key Procedures and Functions

  • VALIDATE_STRUCTURE — Validates the structural integrity of a work order network, ensuring that parent-child and relationship definitions are consistent and that the network topology complies with EAM rules.
  • CHECK_CONSTRAINED_CHILDREN — Verifies constraints applied to child work orders within a network, ensuring children meet the conditions imposed by their parent or the network configuration.
  • VALIDATE_STATUS — Confirms that the status of a work order is valid for the operation being performed, preventing actions against work orders in inappropriate statuses.
  • VALIDATE_NETWORK_STATUS — Validates the aggregate status of the entire network, ensuring all members are in compatible states for the requested processing activity.

The package also depends on FND_API for standard Oracle Application Object Library error-handling and message conventions.

Tables Accessed

Usage Notes

This package is invoked indirectly whenever EAM work order networks are created or modified. Its documented callers include EAM_PROCESS_WO_PUB, EAM_PROCESS_WO_PVT, EAM_WO_IMPORT_DS_PVT, EAM_WO_NETWORK_DEFAULT_PVT, and WIP_EAM_PROCESS_WO_PUB, and it references EAM_PROCESS_WO_PUB. Validation is therefore triggered through EAM work order processing APIs, work order import, and network defaulting routines rather than from user-facing forms directly. Because it is a PVT package, customizations should target the public API EAM_PROCESS_WO_PUB; invoking EAM_WO_NETWORK_VALIDATE_PVT directly is unsupported and risks breaking internal validation contracts. It should be considered an internal dependency across both 12.1.1 and 12.2.2, and any diagnostic activity should trace the public processing API call stack to observe its behavior.