Search Results edit_task_structure

Overview

PA_TASKS_MAINT_PUB is the public PL/SQL API package within the Oracle E-Business Suite Projects (PA) module responsible for the creation, maintenance, and structural manipulation of project tasks. Tasks form the lowest level of the project work breakdown structure below projects, and this package provides the programmatic interface through which task records are inserted, updated, removed, reorganized, and synchronized with financial structures. The package is classified as a PUB (public) API under the APPS schema, indicating that it is intended for direct invocation by external callers, including Oracle Forms, concurrent programs, and custom extensions.

The header information (PATSKSPS.pls, version 120.2) confirms the package's role as a stable, externally exposed interface. Its procedures accept the standard EBS API parameter conventions — API version, initialization message list, commit control, validate-only mode, validation level, calling module, and debug mode — which align it with the common FND_API error-handling framework. The parameter design also accommodates both task creation and task placement within the hierarchy, since CREATE_TASK supports reference task identifiers and a peer-or-subordinate flag for positional insertion.

Key Procedures and Functions

The package documents nine public procedures:

• CREATE_TASK — Creates a new project task, supporting placement relative to a reference task either as a peer or as a subordinate (child). Its parameter list includes task number, name, long name, description, task manager, carrying-out organization, task type, priority, work type, service type, and various flags such as milestone, critical, chargeable, billable, and receive-project-invoice.
• UPDATE_TASK — Modifies attributes of an existing task record.
• DELETE_TASK — Removes a task from the project structure, subject to validation of dependent data.
• EDIT_TASK_STRUCTURE — Manages structural changes to the task hierarchy, including the establishment and modification of parent-child relationships that define the work breakdown.
• MOVE_TASK — Repositions an existing task within the hierarchy, reassigning its parent or sibling relationships.
• COPY_TASK — Duplicates an existing task, along with its defining attributes, to accelerate structure creation.
• SET_FINANCIAL_FLAG_WRAPPER — Provides a wrapper interface for setting financial indicator flags on tasks.
• POPULATE_TEMP_TABLE — Populates a temporary table used in the validation or preview of task financial structures.
• SYNC_UP_WP_TASKS_WITH_FIN — Synchronizes workplan tasks with their corresponding financial task structures.

Tables Accessed

The package reads and writes the following tables, referenced through APPS synonyms:

• PA_TASKS — The primary task definition table, holding core task attributes such as number, name, description, manager, and flags.
• PA_PROJ_ELEMENTS and PA_PROJ_ELEMENT_VERSIONS — Project element structures that store the versioned task hierarchy records.
• PA_PROJ_ELEM_VER_STRUCTURE — Maintains the parent-child structural relationships between project elements.
• PA_OBJECT_RELATIONSHIPS — Stores relationships linking task objects to related entities.
• PA_PREVIEW_FIN_TASKS_TEMP — A temporary table supporting preview and validation of financial task structures.
• DUAL and PLITBLM — Utility references used for single-row queries and PL/SQL table handling.

Usage Notes

PA_TASKS_MAINT_PUB is typically invoked from Oracle Forms within the Projects module, from concurrent programs, and from custom PL/SQL extensions requiring programmatic task maintenance. Callers should observe the standard API conventions: set p_init_msg_list to initialize the message stack, use p_validate_only to perform validation without committing changes, and set p_commit appropriately to control transaction boundaries. The package is referenced by eight other packages, indicating its role as a foundational dependency for higher-level task and financial synchronization logic.