Search Results ahl_task_links_s




Overview
Explore in AI Chat

Overview

The APPS.AHL_VWP_TASKS_LINKS_PVT package body is a private (PVT) PL/SQL API within the Oracle Enterprise Asset Management (eAM) and Asset Lifecycle Management (ALM) product family. It belongs to the AHL schema component set that supports Visit Workbench (VWP) functionality, which governs how visit plans, stages, tasks, and their interdependencies are scheduled and executed in Oracle EBS 12.1.1 and 12.2.2.

The package encapsulates the business logic required to create, validate, and process task links — the dependency relationships that determine the sequencing of tasks within a visit. These links enforce scheduling precedence rules, ensuring that successor tasks cannot begin until their predecessor tasks reach the required completion state. Because the object is classified as PVT, it is not part of the public API surface; it is intended for internal consumption by other AHL packages and is documented as not being referenced by any database object outside the calling package hierarchy, though it is referenced by two other packages.

Key Procedures and Functions

The ETRM metadata documents three procedures and functions within this package body:

  • PROCESS_TASK_LINKS — The controlling procedure that orchestrates the creation and management of task link records. It coordinates the overall processing workflow, invoking validation and creation logic as required to persist link definitions consistently.
  • CREATE_TASK_LINKS — Responsible for the physical insertion of task link rows into the underlying link table. It handles the DML operations required to record predecessor and successor relationships between tasks in a visit.
  • VALIDATE_VWP_LINKS — Performs validation of proposed or existing visit workbench links, confirming that the relationships conform to scheduling and business rules before they are committed. Validation typically guards against invalid cycles or incompatible task combinations.

No parameter signatures are documented in the ETRM metadata, and none should be assumed.

Tables Accessed

The package operates against the following tables, referenced through APPS synonyms:

  • AHL_TASK_LINKS — The primary transactional table storing task-to-task dependency links; this is the principal write target of CREATE_TASK_LINKS.
  • AHL_TASK_LINKS_S — The sequence (primary key) definition table associated with AHL_TASK_LINKS, used to generate unique identifiers for new link records. This table is the likely basis for the user's search term ahl_task_links_s.
  • AHL_STAGE_LINKS — Stores link relationships at the stage level, providing the hierarchical context within which task links are evaluated.
  • AHL_VISIT_TASKS_B — The base table for visit tasks, read to confirm the tasks being linked exist and are valid within the visit.
  • PLITBLM — A standard Oracle tool used for bulk DML and array processing; its presence indicates the package performs set-based inserts or updates against the link tables.

Additional dependencies include AHL_VISITS_VL, AHL_VISIT_TASKS_VL, AHL_VWP_STAGES_B, and the private packages AHL_LTP_REQST_MATRL_PVT, AHL_VWP_RULES_PVT, and AHL_VWP_TIMES_PVT, along with the standard FND_API, FND_GLOBAL, FND_MESSAGE, and FND_MSG_PUB utilities used for API error handling and message stacking.

Usage Notes

As a private package, AHL_VWP_TASKS_LINKS_PVT is not invoked directly by forms or concurrent programs. It is called internally by other AHL packages during visit workbench processing, particularly when visit plans are generated or modified. The use of FND_API and FND_MSG_PUB indicates that callers expect standard API return statuses and message handling, allowing errors to be propagated to the calling user interface or concurrent manager. Customizations should not call this package directly; instead, the public AHL visit and task APIs should be used, with this package remaining an internal implementation detail subject to change between releases.