Search Results ahl_vwp_unplan_tasks_pvt




Overview
Explore in AI Chat

Overview

The APPS.AHL_VWP_UNPLAN_TASKS_PVT package is a private (PVT-classified) PL/SQL API within the Oracle Enterprise Asset Management (eAM) and Asset Lifecycle Management (ALM) product family of Oracle E-Business Suite. It operates under the AHL application schema, which governs maintenance work management, visit planning, and scheduling activities. Specifically, this package supports the "Visit Workbench" (VWP) functionality, enabling users to unplan maintenance tasks — that is, to reverse the planning state of tasks associated with a maintenance visit or work order so that they return to an unplanned or unscheduled condition.

Because it is a private API, AHL_VWP_UNPLAN_TASKS_PVT is not intended for direct invocation by external applications or end users. It is designed to be called by higher-level public APIs and internal concurrent processes that manage the lifecycle of visit tasks. The package depends on AHL_VWP_RULES_PVT for rule validation logic and on the FND_API framework for standardized error handling and message propagation, which is characteristic of Oracle's API design conventions.

Key Procedures and Functions

The package exposes three documented procedures, each mapping to a distinct lifecycle operation on unplanned tasks:

  • CREATE_UNPLANNED_TASK — Creates a new unplanned task record, establishing the association between a maintenance task and the relevant asset or visit context. This procedure initializes the task in an unplanned state, deferring scheduling decisions until resources and timing are confirmed.
  • UPDATE_UNPLANNED_TASK — Modifies the attributes of an existing unplanned task. This may include changes to task definitions, material requirements, or associated item instance details prior to the task being formally planned and scheduled.
  • DELETE_UNPLANNED_TASK — Removes an unplanned task from the system, typically invoked when a task is cancelled or no longer relevant to the visit scope.

No parameter lists are documented in the available metadata; consumers should reference the package specification directly for exact signatures.

Tables Accessed

The package operates against several core AHL and CSI base tables through APPS synonyms:

  • AHL_VISIT_TASKS_B — The primary table storing visit task definitions; create, update, and delete operations affect this table.
  • AHL_SCHEDULE_MATERIALS — Read and potentially written to reconcile material requirements tied to the task.
  • AHL_MR_HEADERS_B — Maintenance requirement headers that provide context for the task.
  • CSI_ITEM_INSTANCES — Identifies the specific asset instance against which the task is performed.
  • MTL_SYSTEM_ITEMS_B — Supplies item master information for materials associated with the task.

Usage Notes

AHL_VWP_UNPLAN_TASKS_PVT is referenced by AHL_VWP_TASKS_PVT and by itself, indicating an internal call hierarchy rather than external exposure. It is typically invoked indirectly through the Visit Workbench forms and related maintenance scheduling flows when a planner chooses to unplan or remove a task from a visit. Custom code should not call this package directly; developers extending the eAM scheduling functionality should use the public task APIs or integrate at the AHL_VWP_TASKS_PVT layer to preserve Oracle's dependency chain and error-handling standards. As with all PVT packages, it is subject to change across patch levels, so direct dependencies carry upgrade risk.