Search Results pa_progress_pvt

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.

PACKAGE: APPS.PA_PROGRESS_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PA_PROGRESS_PVT, status:VALID,
PACKAGE: APPS.PA_PROGRESS_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PA_PROGRESS_PVT, status:VALID,
PACKAGE: APPS.PA_SCHEDULE_OBJECTS_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PA_SCHEDULE_OBJECTS_PVT, status:VALID,
PACKAGE: APPS.PA_SCHEDULE_OBJECTS_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PA_SCHEDULE_OBJECTS_PVT, status:VALID,
PACKAGE BODY: APPS.PA_PROGRESS_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PROGRESS_PVT, status:VALID,
PACKAGE BODY: APPS.PA_PROGRESS_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PROGRESS_PVT, status:VALID,
SYNONYM: APPS.PA_PROJ_ROLLUP_TEMP_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PA_PROJ_ROLLUP_TEMP_S, status:VALID,
SYNONYM: APPS.PA_PROJ_ELEMENTS_TMP 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PA_PROJ_ELEMENTS_TMP, status:VALID,
SYNONYM: APPS.PA_PROG_ACT_BY_PERIOD_TEMP 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PA_PROG_ACT_BY_PERIOD_TEMP, status:VALID,
SYNONYM: APPS.PA_PROJ_ROLLUP_TEMP 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PA_PROJ_ROLLUP_TEMP, status:VALID,
SYNONYM: APPS.PA_PROJ_ROLLUP_TEMP 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PA_PROJ_ROLLUP_TEMP, status:VALID,
SYNONYM: APPS.PA_PERCENT_COMPLETES_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PA_PERCENT_COMPLETES_S, status:VALID,
SYNONYM: APPS.PA_PROJ_ROLLUP_TEMP_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PA_PROJ_ROLLUP_TEMP_S, status:VALID,
SYNONYM: APPS.PA_PERCENT_COMPLETES_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PA_PERCENT_COMPLETES_S, status:VALID,
SYNONYM: APPS.PA_PROGRESS_ROLLUP_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PA_PROGRESS_ROLLUP_S, status:VALID,
SYNONYM: APPS.PA_PROGRESS_ROLLUP_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PA_PROGRESS_ROLLUP_S, status:VALID,
SYNONYM: APPS.PJI_FM_XBS_ACCUM_TMP1 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PJI_FM_XBS_ACCUM_TMP1, status:VALID,
SYNONYM: APPS.PA_PROG_ACT_BY_PERIOD_TEMP 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PA_PROG_ACT_BY_PERIOD_TEMP, status:VALID,
PACKAGE: APPS.PA_PROGRESS_ROLLUP_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PA_PROGRESS_ROLLUP_PKG, status:VALID,
PACKAGE: APPS.PA_PROGRESS_ROLLUP_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PA_PROGRESS_ROLLUP_PKG, status:VALID,
PACKAGE: APPS.PA_PROJECT_STRUCTURE_PVT1 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PA_PROJECT_STRUCTURE_PVT1, status:VALID,
PACKAGE: APPS.PA_PROJECT_STRUCTURE_PVT1 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PA_PROJECT_STRUCTURE_PVT1, status:VALID,
SYNONYM: APPS.PA_PROJ_PROGRESS_ATTR 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PA_PROJ_PROGRESS_ATTR, status:VALID,
SYNONYM: APPS.PJI_FM_XBS_ACCUM_TMP1 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PJI_FM_XBS_ACCUM_TMP1, status:VALID,
PACKAGE: APPS.PA_FP_WP_GEN_AMT_UTILS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PA_FP_WP_GEN_AMT_UTILS, status:VALID,
PACKAGE: APPS.PA_FP_MAINTAIN_ACTUAL_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PA_FP_MAINTAIN_ACTUAL_PUB, status:VALID,
PACKAGE: APPS.PA_PROGRESS_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PA_PROGRESS_PUB, status:VALID,
PACKAGE: APPS.PA_FP_WP_GEN_AMT_UTILS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PA_FP_WP_GEN_AMT_UTILS, status:VALID,
SYNONYM: APPS.PA_PROGRESS_ROLLUP 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PA_PROGRESS_ROLLUP, status:VALID,
SYNONYM: APPS.PA_PERCENT_COMPLETES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PA_PERCENT_COMPLETES, status:VALID,
SYNONYM: APPS.PA_PROJ_PROGRESS_ATTR 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PA_PROJ_PROGRESS_ATTR, status:VALID,
PACKAGE: APPS.PA_PROGRESS_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PA_PROGRESS_PUB, status:VALID,
PACKAGE: APPS.PA_FP_MAINTAIN_ACTUAL_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PA_FP_MAINTAIN_ACTUAL_PUB, status:VALID,
PACKAGE BODY: APPS.PA_PROJECT_STRUCTURE_PUB1 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PROJECT_STRUCTURE_PUB1, status:VALID,
SYNONYM: APPS.PJI_FP_XBS_ACCUM_F 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PJI_FP_XBS_ACCUM_F, status:VALID,
SYNONYM: APPS.PJI_FP_XBS_ACCUM_F 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PJI_FP_XBS_ACCUM_F, status:VALID,
PACKAGE BODY: APPS.PA_STATUS_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_STATUS_PUB, status:VALID,
SYNONYM: APPS.PA_PROGRESS_ROLLUP 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PA_PROGRESS_ROLLUP, status:VALID,
SYNONYM: APPS.PA_PERCENT_COMPLETES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PA_PERCENT_COMPLETES, status:VALID,
SYNONYM: APPS.PA_TASK_TYPES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PA_TASK_TYPES, status:VALID,
PACKAGE: APPS.PA_WORKPLAN_ATTR_UTILS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PA_WORKPLAN_ATTR_UTILS, status:VALID,
SYNONYM: APPS.PA_TASK_TYPES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PA_TASK_TYPES, status:VALID,
PACKAGE: APPS.PA_PROJ_TASK_STRUC_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PA_PROJ_TASK_STRUC_PUB, status:VALID,
SYNONYM: APPS.PA_PROJ_ELEMENT_VERSIONS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PA_PROJ_ELEMENT_VERSIONS, status:VALID,
PACKAGE: APPS.PA_PROJ_TASK_STRUC_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PA_PROJ_TASK_STRUC_PUB, status:VALID,
PACKAGE: APPS.PA_PROGRESS_UTILS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:PA_PROGRESS_UTILS, status:VALID,
TYPE: SYSTEM.PA_VARCHAR2_150_TBL_TYPE 12.1.1
owner:SYSTEM, object_type:TYPE, object_name:PA_VARCHAR2_150_TBL_TYPE, status:VALID,
PACKAGE BODY: APPS.PA_PROJECT_STRUCTURE_PUB1 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PROJECT_STRUCTURE_PUB1, status:VALID,
PACKAGE BODY: APPS.PA_STATUS_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_STATUS_PUB, status:VALID,
PACKAGE: APPS.PA_PROGRESS_UTILS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PA_PROGRESS_UTILS, status:VALID,