Search Results outdent_task_version_bulk

Overview

APPS.PA_TASK_PUB1 is the public PL/SQL API package for managing project tasks and their associated task versions within Oracle Projects. In Oracle EBS 12.1.1 and 12.2.2, tasks represent the lowest-level work breakdown structure elements beneath a project, and their versioned schedule records drive progress tracking, budgeting, and reporting. The package exposes a set of PL/SQL interfaces — as opposed to a direct-table or forms-only approach — so that tasks and task versions can be created, updated, deleted, re-organized, and copied in a controlled and validated manner. The body header identifies the implementation file as PATSK1PB.pls, with the shipped version dated 2009/02/13, indicating that the core logic predates the 12.2.2 release while remaining in scope for both 12.1.1 and 12.2.2 documentation.

The package is also the primary mechanism for manipulating task version structure. It supports hierarchical re-organization (indentation and outdentation) and version movement, which are central to maintaining a correct project work breakdown over time.

Key Procedures and Functions

The ETRM documentation lists 35 documented procedures and functions. The principal task-level operations include:

• CREATE_TASK / UPDATE_TASK — create and maintain the base task record for a project, including descriptive attributes and assignment data such as task manager and carrying-out organization.
• CREATE_TASK_VERSION / UPDATE_TASK_VERSION / DELETE_TASK_VERSION — manage the versioned representation of a task that participates in a project schedule.
• MOVE_TASK_VERSION — relocate a task version within the project structure, which is directly relevant to the search term "move_task_version". This is the API used when a task's position in the hierarchy must change.
• INDENT_TASK_VERSION / OUTDENT_TASK_VERSION — shift a task version one level deeper or shallower in the task hierarchy.
• INDENT_TASK_VERSION_BULK / OUTDENT_TASK_VERSION_BULK / DELETE_TASK_VERSION_IN_BULK — set-based variants that process multiple task versions in a single invocation, reducing round trips for large structures.
• CREATE_TASK_VERSION / UPDATE_SCHEDULE_VERSION / CREATE_SCHEDULE_VERSION — schedule-version operations that align task versions with project scheduling.
• COPY_TASK — duplicate an existing task, typically to accelerate setup of similar work elements.
• CREATE_TASKS — bulk creation entry point.
• CALC_TASK_WEIGHTS / UPDATE_TASK_WEIGHTING — compute and maintain task weighting used in progress and rollup calculations.
• UPDATE_TASK_ASSOCIATION / DELETE_TASK_ASSOCIATIONS / DELETE_ASSOCIATION — maintain relationships between tasks and related project objects.

Tables Accessed

The package reads and writes the core Projects task and structure tables referenced through APPS synonyms: PA_PROJ_ELEMENTS (task master definitions), PA_PROJ_ELEMENT_VERSIONS (versioned task records), PA_PROJ_ELEM_VER_SCHEDULE and PA_PROJ_ELEM_VER_STRUCTURE (version scheduling and hierarchy), PA_PROJECTS_ALL, PA_PROJ_STRUCTURE_TYPES, PA_PROJ_PROGRESS_ATTR and PA_PERCENT_COMPLETES (progress attributes), PA_PROGRESS_ROLLUP, PA_BUDGET_VERSIONS, PA_CONTROL_ITEMS, PA_CI_ACTIONS, PA_OBJECT_RELATIONSHIPS, and HR_ALL_ORGANIZATION_UNITS (organization validation). FND_NEW_MESSAGES supplies message text for API error handling.

Usage Notes

PA_TASK_PUB1 is invoked from Oracle Projects forms, concurrent programs, and custom integrations that need to manage tasks or task versions programmatically. It is referenced by 16 other packages, confirming its role as a shared internal service. Callers typically follow the standard Oracle API pattern: supply an API version, initialize the message list, request validation or commit behavior, and inspect the returned message list. Because MOVE_TASK_VERSION is itself a public procedure, the object is documented and supported for external invocation. Custom code should use this package rather than direct DML against the underlying PA_PROJ_ELEMENT* tables.