Search Results convert_task_prog_to_assgn

Overview

PA_PROGRESS_PVT is a private PL/SQL package in the APPS schema that encapsulates the internal rollup and progress calculation logic for Oracle Projects. Its classification as a PVT (private) API indicates that it is not intended for direct invocation by external or customer-developed code; instead, it is consumed by the public progress APIs and other Projects packages that require the underlying procedural implementation. The package is responsible for computing, storing, and maintaining percent-complete and progress rollup data across project structures, tasks, assignments, and subprojects, including the propagation of actuals into workplan progress records.

The object is recorded as VALID in the EBS 12.1.1 and 12.2.2 environments and depends on FND_API, PA_INTERFACE_UTILS_PUB, PA_SCHEDULE_OBJECTS_PVT, PA_PROJECTS_ALL, and PA_PROJ_ELEMENT_VERSIONS, confirming its role as a lower-level component in the Projects progress framework.

Key Procedures and Functions

The package exposes eleven documented procedures that collectively govern progress rollup behavior:

• ROLLUP_PROGRESS_PVT — Performs the core progress rollup calculation for project elements.
• UPDATE_ROLLUP_PROGRESS_PVT — Updates existing rollup records with recalculated progress values.
• ROLLUP_FUTURE_PROGRESS_PVT — Rolls up progress for future-dated or planned progress entries.
• PROGRAM_ROLLUP_PVT — Handles rollup at the program or top-level project grouping.
• ASGN_DLV_TO_TASK_ROLLUP_PVT — Rolls up assignment and deliverable progress to the associated task.
• CONVERT_TASK_PROG_TO_ASSGN — Converts task-level progress values into assignment-level progress.
• COPY_ACTUALS_FOR_WORKPLAN — Copies actual amounts or quantities to support workplan progress calculations.
• ROLLUP_PROG_FROM_SUBPROJS — Aggregates progress from subordinate subprojects to the parent project.
• UPD_PROG_RECS_STR_DELETE — Updates progress records in response to structure deletions.
• ROLLUP_PVT — Generic rollup driver invoked by related processes.
• DEFER_ROLLUP_PVT — Defers rollup processing, typically when immediate recalculation is not required or when batching is preferred.

Tables Accessed

The package reads and writes through APPS synonyms against the following documented tables:

• PA_PROJECTS_ALL, PA_PROJECT_STATUSES — Source project and status context.
• PA_PROJ_ELEMENTS, PA_PROJ_ELEMENTS_TMP, PA_PROJ_ELEMENT_VERSIONS, PA_PROJ_ELEM_VER_SCHEDULE — Project element hierarchy and versioned schedule data used during rollup.
• PA_PERCENT_COMPLETES, PA_PERCENT_COMPLETES_S — Primary storage for percent-complete records.
• PA_PROGRESS_ROLLUP, PA_PROGRESS_ROLLUP_S — Rollup result storage.
• PA_BUDGET_LINES, PA_BUDGET_VERSIONS — Budget context for progress comparison.
• PA_OBJECT_RELATIONSHIPS — Relationships mapping progress objects to project elements.
• PA_PROG_ACT_BY_PERIOD_TEMP — Temporary staging of progress by period.
• FND_LOOKUP_VALUES — Lookup validation used during processing.

Usage Notes

PA_PROGRESS_PVT is referenced by six packages, including PA_PROGRESS_PUB, PA_STATUS_PUB, PA_PROJECT_STRUCTURE_PUB1, PA_PROJ_TASK_STRUC_PUB, PA_FP_COPY_FROM_PKG, and itself. Custom code should invoke the public wrapper PA_PROGRESS_PUB rather than calling this private package directly. Typical invocation occurs through Oracle Projects forms, concurrent rollup programs, and structure maintenance operations that trigger progress recalculation after task, assignment, or subproject changes.