Search Results create_task_links




Overview
Explore in AI Chat

Overview

APPS.AHL_VWP_TASKS_LINKS_PVT is a private PL/SQL package belonging to the Oracle E-Business Suite Enterprise Asset Management (EAM) family, specifically the Asset Lifecycle / Visit Workbench (VWP) module. The "PVT" suffix denotes a private API classification, indicating the package is intended for internal use by Oracle's own product code rather than as a public integration surface. Its role is to manage the link relationships between visit tasks, establishing the parent/child hierarchy that defines how individual tasks within a maintenance visit are sequenced and organized.

The package defines the record type TASK_LINK_REC, which models a single task link row, and the associated collection type TASK_LINK_TBL (indexed by BINARY_INTEGER). The record structure carries the standard WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER), the primary identifier TASK_LINK_ID, foreign keys VISIT_TASK_ID and PARENT_TASK_ID, a scheduling attribute START_FROM_HOUR, descriptive fields (VISIT_TASK_NUMBER, VISIT_TASK_NAME, HIERARCHY_INDICATOR, ATTRIBUTE_CATEGORY), fifteen flexible attribute slots, and a DML_OPERATION flag used to drive insert/update/delete processing. The header identifies the file AHLVTLNS.pls, sourced at version 120.0.12020000.2.

Key Procedures and Functions

  • PROCESS_TASK_LINKS — Accepts a table of TASK_LINK_REC for bulk processing of task link records. The procedure is the principal entry point for persisting changes to the link hierarchy and follows standard Oracle API conventions with initialization message list, commit, validation level, default, and module type parameters, together with the standard return status, message count, and message data outputs. Its IN OUT collection parameter carries the set of rows to be processed.
  • CREATE_TASK_LINKS — Accepts a single TASK_LINK_REC, passed IN OUT, to create an individual task link. Per the source comments, this procedure (along with VALIDATE_VWP_LINKS) was added to the specification under ER-12424063 so that it can be called from another file.
  • VALIDATE_VWP_LINKS — Performs validation of visit workbench link data, returning the standard x_return_status, x_msg_count, and x_msg_data outputs. It is designed to be invoked independently by callers that need to confirm link correctness before or apart from the persistence step.

Tables Accessed

  • AHL_TASK_LINKS / AHL_TASK_LINKS_S — The base and translation (or secondary) tables holding task link definitions, including the parent/child associations and the START_FROM_HOUR sequencing attribute. These are the primary write targets.
  • AHL_STAGE_LINKS — The staging table into which link rows may be loaded prior to validation and promotion into the base tables.
  • AHL_VISIT_TASKS_B — The visit task base table, referenced to validate the VISIT_TASK_ID and PARENT_TASK_ID foreign keys and to confirm the task exists within the visit.
  • PLITBLM — The standard EBS table used to store and retrieve API message text produced during validation and processing.

Usage Notes

Because this is a private package, direct invocation from custom code is not supported; Oracle does not guarantee the stability of the TASK_LINK_REC structure or the procedure signatures between patch levels. In normal product operation the procedures are called by the Visit Workbench forms and by other Oracle-owned packages, and the metadata records that this package is referenced by two other packages. Callers that invoke PROCESS_TASK_LINKS should expect an API-style contract: the caller controls commit behavior through p_commit, and the DML_OPERATION flag on each record determines whether a row is inserted, updated, or deleted. Integrators needing equivalent functionality should use the supported public APIs for visit and task maintenance rather than calling AHL_VWP_TASKS_LINKS_PVT directly.