Search Results check_wo_negative_dates

Overview

APPS.EAM_WO_NETWORK_DEFAULT_PVT is a private PL/SQL package within the Oracle Enterprise Asset Management (EAM) module. It encapsulates the scheduling and structural logic used to maintain work order networks — the parent/child relationships and interdependencies that link multiple work orders into a coordinated maintenance project. In Oracle EBS 12.1.1 and 12.2.2, this package is a core supporting component of the EAM work order processing stack, invoked indirectly by the public work order processing APIs rather than called directly by end users.

The package operates on the schedule network by resolving date constraints, adjusting and resizing work orders, creating and deleting dependencies, and snapping work orders to valid scheduling windows. It ensures that schedule changes propagate correctly through the dependency graph while respecting the earliest/latest date boundaries defined for each work order and its resources. Its classification as a PVT (private) package indicates that its procedures are intended for internal consumption by other EAM packages, not as a public integration API.

Key Procedures and Functions

The documented interface exposes sixteen procedures and functions covering network manipulation and date validation:

• ADD_WO_TO_NETWORK — Adds a work order into an existing scheduling network.
• ADJUST_PARENT — Recalculates and adjusts a parent work order's schedule in response to changes in its children.
• RESIZE_WO — Alters the duration/span of a work order within the network.
• DELETE_DEPENDENCY and ADD_DEPENDENCY — Remove or establish dependency links between work orders.
• DELINK_CHILD_FROM_PARENT — Breaks the parent/child association for a work order.
• CHECK_WO_DATES, CHECK_RESOURCE_DATES, and CHECK_WO_NEGATIVE_DATES — Validate work order and resource scheduling dates, including detection of invalid negative date spans.
• SNAP_RIGHT, SNAP_LEFT, SNAP_RIGHT_WINDOW, and SNAP_LEFT_WINDOW — Shift work orders to valid scheduling positions to the right or left.
• FIND_RIGHT_SNAP_WINDOW and FIND_LEFT_SNAP_WINDOW — Identify the valid windows in which snapping can occur.
• SHRINK_PARENT — Compresses a parent work order's duration to fit adjusted child schedules.

These routines collectively implement the constraint-satisfaction behaviour required to keep a multi-work-order network internally consistent.

Tables Accessed

The package reads and writes the EAM work order relationship tables EAM_WO_RELATIONSHIPS and EAM_WO_RELATIONSHIPS_S to persist dependency definitions. It accesses the WIP execution tables — WIP_DISCRETE_JOBS, WIP_ENTITIES, WIP_OPERATIONS, and WIP_SCHED_RELATIONSHIPS — to retrieve work order headers, operations, and scheduling relationships. Resource-level scheduling is handled through WIP_OPERATION_RESOURCES, WIP_OPERATION_RESOURCE_USAGE, WIP_OP_RESOURCE_INSTANCES, and WIP_SUB_OPERATION_RESOURCES. DUAL and PLITBLM support internal PL/SQL computations and bulk operations.

Usage Notes

EAM_WO_NETWORK_DEFAULT_PVT is not exposed to end users. It is referenced by four higher-level components: EAM_PROCESS_WO_PUB, EAM_PROCESS_WO_PVT, EAM_WORKORDERS_JSP, and WIP_EAM_PROCESS_WO_PUB. These callers invoke the package when work orders are created, rescheduled, or reorganized in the EAM Work Order form or via the public processing APIs. Because the package depends on FND_API, FND_GLOBAL, and EAM_ERROR_MESSAGE_PVT, it participates in the standard EBS API error-handling and logging framework. Customisations should not call this package directly; integrators should use the public EAM_PROCESS_WO_PUB or WIP_EAM_PROCESS_WO_PUB interfaces instead. In both 12.1.1 and 12.2.2 the object is documented as VALID in the APPS schema, and its behaviour is consistent across these releases.