Search Results eam_process_wo_pub
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
- EAM_WORK_ORDER_DETAILS — Provides the core EAM work order definitions that are validated.
- EAM_WO_RELATIONSHIPS — Defines predecessor-successor links between work orders, used in structure validation.
- EAM_WO_STATUSES_V — Supplies valid status values referenced during status validation.
- WIP_DISCRETE_JOBS, WIP_ENTITIES, WIP_SCHED_RELATIONSHIPS, WIP_SCHEDULING_EXCEPTIONS — Represent the underlying WIP work order and scheduling data that EAM work orders relate to, used to reconcile EAM network state with WIP scheduling.
- PLITBLM — A standard Oracle PL/SQL table type used for internal collections.
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.
-
PACKAGE: APPS.EAM_WO_NETWORK_VALIDATE_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:EAM_WO_NETWORK_VALIDATE_PVT, status:VALID,
-
PACKAGE: APPS.EAM_WO_UTILITY_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_WO_UTILITY_PVT, status:VALID,
-
PACKAGE: APPS.EAM_WO_UTILITY_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:EAM_WO_UTILITY_PVT, status:VALID,
-
PACKAGE: APPS.EAM_WO_COMP_UTILITY_PVT
12.1.1
-
PACKAGE: APPS.EAM_WO_COMP_UTILITY_PVT
12.2.2
-
PACKAGE BODY: APPS.EAM_PROCESS_WO_PUB
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_PROCESS_WO_PUB, status:VALID,
-
PACKAGE: APPS.EAM_WO_NETWORK_VALIDATE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_WO_NETWORK_VALIDATE_PVT, status:VALID,
-
PACKAGE: APPS.EAM_PROCESS_PERMIT_PUB
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_PROCESS_PERMIT_PUB, 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,
-
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_SCHED_BOTTOM_UP_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:EAM_SCHED_BOTTOM_UP_PVT, status:VALID,
-
PACKAGE: APPS.EAM_PROCESS_WO_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:EAM_PROCESS_WO_PVT, status:VALID,
-
PACKAGE: APPS.EAM_MAT_REQ_VALIDATE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_MAT_REQ_VALIDATE_PVT, status:VALID,
-
PACKAGE: APPS.EAM_OP_COMP_UTILITY_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:EAM_OP_COMP_UTILITY_PVT, status:VALID,
-
PACKAGE: APPS.EAM_WO_QUA_UTILITY_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_WO_QUA_UTILITY_PVT, status:VALID,
-
PACKAGE: APPS.EAM_SUB_RESOURCE_DEFAULT_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:EAM_SUB_RESOURCE_DEFAULT_PVT, status:VALID,
-
PACKAGE: APPS.EAM_PROCESS_WO_PUB_W
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_PROCESS_WO_PUB_W, status:VALID,
-
PACKAGE: APPS.EAM_MAT_REQ_DEFAULT_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:EAM_MAT_REQ_DEFAULT_PVT, status:VALID,
-
PACKAGE: APPS.EAM_REQUEST_UTILITY_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_REQUEST_UTILITY_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_WORKFLOW_DETAILS_PUB
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_WORKFLOW_DETAILS_PUB, status:VALID,
-
PACKAGE: APPS.EAM_MAT_REQ_VALIDATE_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:EAM_MAT_REQ_VALIDATE_PVT, status:VALID,
-
PACKAGE: APPS.EAM_WO_VALIDATE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_WO_VALIDATE_PVT, status:VALID,
-
PACKAGE: APPS.EAM_RES_INST_VALIDATE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_RES_INST_VALIDATE_PVT, status:VALID,
-
PACKAGE: APPS.EAM_EXPLODE_ACTIVITY_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_EXPLODE_ACTIVITY_PVT, status:VALID,
-
PACKAGE: APPS.EAM_DIRECT_ITEMS_UTILITY_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:EAM_DIRECT_ITEMS_UTILITY_PVT, status:VALID,
-
PACKAGE: APPS.EAM_EXPLODE_ACTIVITY_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:EAM_EXPLODE_ACTIVITY_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_OP_NETWORK_DEFAULT_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_OP_NETWORK_DEFAULT_PVT, status:VALID,
-
PACKAGE: APPS.EAM_WO_SCHEDULE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_WO_SCHEDULE_PVT, status:VALID,
-
PACKAGE: APPS.EAM_RES_UTILITY_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:EAM_RES_UTILITY_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_RES_DEFAULT_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_RES_DEFAULT_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_RES_INST_DEFAULT_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_RES_INST_DEFAULT_PVT, status:VALID,
-
PACKAGE: APPS.EAM_REQUIREMENTS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:EAM_REQUIREMENTS_PKG, status:VALID,
-
PACKAGE: APPS.EAM_REQUIREMENTS_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_REQUIREMENTS_PKG, status:VALID,
-
SYNONYM: APPS.WIP_EAM_DI_SEQ_ID_S
12.2.2
owner:APPS, object_type:SYNONYM, object_name:WIP_EAM_DI_SEQ_ID_S, status:VALID,
-
PACKAGE: APPS.EAM_OPERATIONS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:EAM_OPERATIONS_PKG, status:VALID,
-
PACKAGE: APPS.MRP_RESCHEDULE_CMRO_WO_PS
12.2.2
owner:APPS, object_type:PACKAGE, object_name:MRP_RESCHEDULE_CMRO_WO_PS, status:VALID,
-
PACKAGE: APPS.MRP_RELEASE_EAM_WO
12.2.2
owner:APPS, object_type:PACKAGE, object_name:MRP_RELEASE_EAM_WO, status:VALID,
-
PACKAGE BODY: APPS.EAM_RES_USAGE_VALIDATE_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_RES_USAGE_VALIDATE_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_DIRECT_ITEMS_DEFAULT_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_DIRECT_ITEMS_DEFAULT_PVT, status:VALID,
-
PACKAGE BODY: APPS.EAM_OP_COMP_VALIDATE_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:EAM_OP_COMP_VALIDATE_PVT, status:VALID,
-
PACKAGE: APPS.EAM_WORKORDER_WORKFLOW_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_WORKORDER_WORKFLOW_PVT, status:VALID,
-
PACKAGE: APPS.EAM_SCHED_BOTTOM_UP_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_SCHED_BOTTOM_UP_PVT, status:VALID,
-
PACKAGE: APPS.EAM_WO_COMP_DEFAULT_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_WO_COMP_DEFAULT_PVT, status:VALID,
-
PACKAGE: APPS.EAM_REQUEST_DEFAULT_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:EAM_REQUEST_DEFAULT_PVT, status:VALID,
-
PACKAGE: APPS.EAM_WO_COMP_DEFAULT_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:EAM_WO_COMP_DEFAULT_PVT, status:VALID,
-
PACKAGE: APPS.EAM_REQUEST_DEFAULT_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_REQUEST_DEFAULT_PVT, status:VALID,
-
PACKAGE: APPS.EAM_LINEAR_LOCATIONS_PUB
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_LINEAR_LOCATIONS_PUB, status:VALID,
-
PACKAGE: APPS.EAM_OP_COMP_DEFAULT_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:EAM_OP_COMP_DEFAULT_PVT, status:VALID,
-
PACKAGE: APPS.EAM_OP_NETWORK_VALIDATE_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:EAM_OP_NETWORK_VALIDATE_PVT, status:VALID,
-
PACKAGE: APPS.EAM_WO_COMP_VALIDATE_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:EAM_WO_COMP_VALIDATE_PVT, status:VALID,