Search Results delete_task_version_in_bulk

Overview

PA_TASK_PUB1 is a public PL/SQL API package in the Oracle EBS Projects (PA) module, owned by the APPS schema with a status of VALID. It provides the canonical programmatic interface for creating, maintaining, and restructuring project tasks and task versions within Oracle Project Management and Oracle Project Foundation. Tasks are the lowest-level work breakdown elements beneath project structures; PA_TASK_PUB1 centralizes the business logic that governs their lifecycle, including task creation, versioning, copying, movement, hierarchy adjustment (indent/outdent), weighting, and association management. Because it is a public (PUB) package, it is designed to be called from other Oracle EBS application code, standard forms, concurrent programs, and customer extensions rather than executed directly by end users. Its design follows the standard Oracle API pattern, delegating detailed processing to the companion private package PA_TASK_PVT1 while consuming shared utilities such as FND_API, PA_INTERFACE_UTILS_PUB, and the generated table types (PA_NUM_TBL_TYPE, PA_VARCHAR2_100_TBL_TYPE, PA_DATE_TBL_TYPE, and others) that support bulk operations.

Key Procedures and Functions

The package exposes 35 documented procedures and functions. CREATE_TASK and UPDATE_TASK handle the insertion and modification of a single task; CREATE_TASK_VERSION and UPDATE_TASK_VERSION manage task version records, while DELETE_TASK_VERSION removes them. CREATE_SCHEDULE_VERSION and UPDATE_SCHEDULE_VERSION operate on task scheduling records. COPY_TASK replicates a task, and MOVE_TASK_VERSION relocates a task version within the structure. INDENT_TASK_VERSION and OUTDENT_TASK_VERSION adjust hierarchy levels, with bulk counterparts INDENT_TASK_VERSION_BULK and OUTDENT_TASK_VERSION_BULK. DELETE_TASK_VERSION_IN_BULK supports mass deletion. CALC_TASK_WEIGHTS computes task weighting, and UPDATE_TASK_WEIGHTING applies weighting changes. CREATE_TASKS provides multi-row task creation. UPDATE_TASK_ASSOCIATION, DELETE_TASK_ASSOCIATIONS, and DELETE_ASSOCIATION govern relationships between tasks and other project entities.

Tables Accessed

The package reads and writes core Projects tables through APPS synonyms. PA_PROJ_ELEMENTS and PA_PROJ_ELEMENT_VERSIONS store the base and versioned task records. PA_PROJ_ELEM_VER_SCHEDULE and PA_PROJ_ELEM_VER_STRUCTURE hold scheduling and hierarchical structure data. PA_PROJ_STRUCTURE_TYPES defines the structure classifications that tasks belong to, while PA_OBJECT_RELATIONSHIPS and PA_CI_ACTIONS support object linking and change-initiation logic. Financial and progress data are touched through PA_BUDGET_VERSIONS, PA_PERCENT_COMPLETES, PA_CONTROL_ITEMS, PA_PROJ_PROGRESS_ATTR, and PA_PROGRESS_ROLLUP. PA_PROJECTS_ALL provides project context, HR_ALL_ORGANIZATION_UNITS supplies organization validation, and FND_NEW_MESSAGES supports message resolution.

Usage Notes

PA_TASK_PUB1 is typically invoked from standard Project Management forms, concurrent programs, and custom extensions that must respect Oracle's validation and versioning rules rather than writing directly to PA_PROJ_ELEMENTS. It is referenced by sixteen other packages, including PA_PROJECT_CORE, PA_PROJECT_STRUCTURE_PUB1, PA_PROJECT_STRUCTURE_PVT1, PA_TASK_UTILS, PA_TASK_ASSIGNMENTS_PUB, PA_STATUS_PUB, PA_PROGRESS_PUB, PA_RELATIONSHIP_PVT, and the PJI rollup routines PJI_FM_XBS_ACCUM_MAINT and PJI_PJP_SUM_ROLLUP. This dependency profile confirms that task maintenance is a foundational operation consumed across project costing, progress, and reporting flows. Developers should call the public API within a properly initialized FND_API environment so that standard error handling and message stacking apply. Because behavior is version-sensitive, implementations should be validated against the specific EBS release (12.1.1 or 12.2.2) in use.