Search Results update_schedule_version

Overview

PA_TASK_PVT1 is a private PL/SQL package in the Oracle E-Business Suite Projects (PA) module, owned by the APPS schema. It provides the core application programming interface for creating, updating, and versioning tasks and schedules within Oracle Projects. Tasks are the lowest-level work breakdown structure (WBS) elements in a project, and Oracle Projects supports multiple versions of a project structure to enable what-if modeling, baselining, and change control. PA_TASK_PVT1 encapsulates the business logic that governs these operations, shielding callers from the underlying complexity of the project element, version, and structure tables.

The package header (PATSK1VS.pls, version 120.1) documents the primary public procedure, Create_Task, whose parameter list includes standard API control arguments such as p_api_version, p_init_msg_list, p_commit, p_validate_only, p_validation_level, p_calling_module, p_debug_mode, and p_max_msg_count. Business parameters include p_object_type, p_project_id, p_task_number, p_task_name, task descriptive attributes (description, location, country, territory, state, city), and assignment fields such as p_task_manager_id, p_carrying_out_org_id, p_priority_code, p_type_id, p_status_code, p_inc_proj_progress_flag, p_pm_product_code, and p_pm_task_reference.

Key Procedures and Functions

ETRM documents seventeen procedures and functions in this package. The task lifecycle procedures are:

• CREATE_TASK — Creates a new task record against a project, with optional validation-only mode and full attribute support.
• UPDATE_TASK — Modifies attributes of an existing task.
• CREATE_TASK_VERSION — Creates a task within a specific project structure version, the operation referenced in the user's search. It supports version-aware task creation used during baselining and what-if analysis.
• UPDATE_TASK_VERSION — Updates a task version record.
• DELETE_TASK_VERSION — Removes a task version, subject to version and structure rules.
• UPDATE_TASK_VER_DELETE_STATUS — Adjusts the deletion status flag on a task version.
• DELETE_TASK_VER_WO_VAL — Deletes a task version without full validation, typically used in cleanup processing.

Schedule version procedures include:

• CREATE_SCHEDULE_VERSION — Creates a schedule version for project elements.
• UPDATE_SCHEDULE_VERSION — Updates an existing schedule version.

Attribute inheritance and weighting procedures include:

• INHERIT_TASK_TYPE_ATTR — Propagates task type attributes to tasks.
• UPDATE_TASK_WEIGHTING — Updates task weighting values used in progress and revenue calculations.
• RECALC_TASKS_WEIGHTING — Recalculates task weightings across an affected task set.
• UPDATE_WORKING_VER_WEIGHT — Updates weighting on the working version.
• SET_NEW_TASKS_TO_TBD — Initializes newly created tasks to a "To Be Determined" weighting status.
• UPDATE_DATES_TO_ALL_VERSIONS — Propagates task date changes across all project structure versions.

Sequencing and deferral utilities include DISP_SEQ_NUM_LEVEL_DEFER and DEFER_CALC_TASK_WEIGTHAGE, which support deferred sequence numbering and deferred weighting calculations.

Tables Accessed

The package reads and writes the primary task and project element tables. PA_PROJ_ELEMENTS and PA_PROJ_ELEMENT_VERSIONS (with its _S sequence) store task and WBS element definitions and their version-specific records. PA_PROJ_ELEM_VER_SCHEDULE holds version-level scheduling data, while PA_PROJ_ELEM_VER_STRUCTURE and PA_PROJ_ELEM_VER_TMP support structure rollup and interim processing. PA_PROJECTS_ALL provides project header context. PA_ALTERNATE_TASKS, PA_PROJ_ELEM_RELATIONSHIP_T, and PA_PROJ_STRUCTURE_TYPES support alternate structures and structure type definitions. PA_PERCENT_COMPLETES, PA_PROGRESS_ROLLUP, PA_OBJECT_PAGE_LAYOUTS, PA_PAGE_LAYOUTS, and PA_OBJECT_RELATIONSHIPS provide progress calculation and UI layout metadata.

Usage Notes

PA_TASK_PVT1 is a private package and is not intended for direct customer invocation. It is referenced by eight other packages in the Applications schema and is invoked internally by Oracle Projects forms such as the Task form, by concurrent programs that build and version project structures, and by public APIs (for example, PA_TASK_PUB or PA_PROJECT_PUB) that validate and delegate to this layer. Direct calls to Create_Task_Version from custom code are not supported; developers requiring task versioning should use the documented public APIs in PA_TASK_PUB, which route through PA_TASK_PVT1 after applying interface validation and security checks.