Search Results process_task_links




Overview
Explore in AI Chat

Overview

APPS.AHL_VWP_TASKS_LINKS_PVT is a private (PVT) PL/SQL API package within the Oracle E-Business Suite Enterprise Asset Management / Asset Lifecycle family, specifically the AHL (Asset Lifecycle / Visit Workbench) schema. Its business purpose is to support the maintenance and integrity of task link relationships used by the Visit Workbench (VWP) and related visit task scheduling functionality. Task links represent hierarchical and chronological relationships between visit tasks, including parent-child task structures and start-from-hour offsets that determine when dependent tasks are executed within a visit.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoker rather than the definer. It includes the source header marker "$Header: AHLVTLNS.pls 115.5 2003/08/21 ... noship $", indicating the file has a long-standing lineage in the AHL module. It belongs to the PVT API classification, denoting it is an internal implementation package not intended as a published public interface.

Because it is private, its procedures are typically invoked by AHL public APIs or by Visit Workbench application logic rather than directly by external customizations. The package processes sets of task link records in bulk, applying create, update, or delete semantics based on a DML operation indicator carried in each record.

Key Procedures and Functions

ETRM metadata documents three procedures for this package:

  • PROCESS_TASK_LINKS — The primary entry point, and the procedure surfaced by the user's search for "process_task_links". It accepts a standard Oracle EBS API parameter block (API version, initialization of message list, commit flag, validation level, default flag, module type) plus the standard OUT parameters for return status, message count, and message data. It also accepts an IN OUT task link table parameter (p_x_task_link_tbl) of type TASK_LINK_TBL. This procedure drives the processing of one or more task link records in a single call.
  • CREATE_TASK_LINKS — Creates task link rows based on the supplied task link records. It is called internally by PROCESS_TASK_LINKS when records carry an insert indication.
  • VALIDATE_VWP_LINKS — Performs validation of the visit workbench link data prior to persistence, ensuring referential and business rule consistency for VWP task link structures.

The package also declares the PL/SQL record type TASK_LINK_REC and the collection type TASK_LINK_TBL, which carry task link identifiers, object version numbers, WHO columns, visit task and parent task identifiers, start-from-hour, denormalized task number and name, a hierarchy indicator, fifteen descriptive flexfield attributes, and a single-character DML_OPERATION field used to classify each row as an insert, update, or delete.

Tables Accessed

The package operates against the following documented tables via APPS synonyms:

  • AHL_TASK_LINKS and AHL_TASK_LINKS_S — The base and incremental (secondary/interim) tables holding task link definitions. These are the primary targets for insert, update, and delete operations issued by CREATE_TASK_LINKS and PROCESS_TASK_LINKS.
  • AHL_STAGE_LINKS — A staging table used to hold intermediate link data, typically during bulk load or interface processing before validation and promotion into the base tables.
  • AHL_VISIT_TASKS_B — The base table for visit tasks. It is referenced to resolve and validate the VISIT_TASK_ID and PARENT_TASK_ID foreign key relationships and to retrieve task number and name values.
  • PLITBLM — A standard Oracle EBS message table used by FND_MSG_PUB to store and retrieve API error and warning messages, consistent with the message list initialization and retrieval pattern used by PROCESS_TASK_LINKS.

Usage Notes

Because AHL_VWP_TASKS_LINKS_PVT is classified as a private package, it is not intended for direct invocation by external applications. It is ordinarily called by public AHL APIs, by Visit Workbench forms or OAF pages that manage visit task hierarchies, or by concurrent programs that load and reconcile task link data. The presence of AHL_STAGE_LINKS among the referenced tables suggests it also participates in staged or interface-based loading of task links before validation and commit.

The standard API parameter conventions—p_init_msg_list, p_commit, and p_validation_level—mean the package supports both transactional and message-accumulating execution. A caller can request full validation before persistence and can defer or force commit behavior. When adapting custom code against this package, callers should treat it as an internal component and prefer the documented public AHL APIs; if invoking it directly, they must populate the TASK_LINK_TBL collection with correctly set DML_OPERATION values and be prepared to interpret x_return_status, x_msg_count, and x_msg_data on return.