Search Results pa_progress_rollup_s

Overview

PA_PROGRESS_ROLLUP_PKG is a PL/SQL package body owned by the APPS schema that supports the progress rollup functionality within Oracle Projects (PA) in Oracle E-Business Suite 12.1.1 and 12.2.2. Progress rollup is the mechanism by which Oracle Projects accumulates and summarizes progress or work-completion information—typically tied to project and task hierarchies—so that summarized results can be reported at higher levels of the work breakdown structure. The package encapsulates the core data manipulation logic required to maintain the underlying progress rollup data, providing a controlled programmatic interface over the PA_PROGRESS_ROLLUP and PA_PROGRESS_ROLLUP_S tables rather than requiring direct table access. It is classified as an OTHER API object in the ETRM repository, indicating it is an internal supporting package rather than a published, externally callable business API. The package body is reported with a status of VALID and is documented as not being referenced by any other database object, although the ETRM metadata also notes that five other packages reference it, underscoring its role as a shared utility used internally across Oracle Projects processes.

The package relies on several dependencies, including FND_MSG_PUB for Oracle Application Object Library message handling, PA_INTERFACE_UTILS_PUB for interface utilities, and the STANDARD and DUAL objects supplied by the database. The presence of FND_MSG_PUB suggests the package participates in the standard EBS error and message stack pattern used for concurrent and API processing.

Key Procedures and Functions

The documented interface consists of three procedures, which together form a complete maintenance interface over the progress rollup data:

• INSERT_ROW — Creates a new progress rollup record, inserting the summarized progress data into the target table. It is the entry point used when populating rollup information for a project or task for the first time.
• UPDATE_ROW — Modifies an existing progress rollup record, allowing previously inserted rollup values to be refreshed or corrected as underlying progress data changes.
• DELETE_ROW — Removes a progress rollup record, used when obsolete or invalidated rollup data must be purged from the table.

These procedures collectively implement the standard insert, update, and delete maintenance pattern common to Oracle Projects internal packages. The metadata does not document parameter signatures, and no parameter lists should be assumed beyond the procedures' evident purpose. The package body also references itself (PA_PROGRESS_ROLLUP_PKG), which is consistent with internal helper or overloading usage within the body.

Tables Accessed

The package operates against the following tables, resolved through APPS synonyms:

• PA_PROGRESS_ROLLUP — The primary table holding progress rollup data. The INSERT_ROW, UPDATE_ROW, and DELETE_ROW procedures read from and write to this table as their principal target.
• PA_PROGRESS_ROLLUP_S — The secondary table referenced by the package. The _S suffix in Oracle Applications conventionally denotes a table used for sequence, shadow, or interim processing purposes. The user's search term "pa_progress_rollup_s" corresponds directly to this reference.
• DUAL — The standard Oracle single-row utility table, referenced for scalar evaluations such as sequence retrieval or default value selection.

Usage Notes

PA_PROGRESS_ROLLUP_PKG is an internal Oracle Projects component and is not intended for direct invocation by external integrations or customer extensions. It is most commonly invoked indirectly by Oracle Projects progress rollup processing, including concurrent programs and internal APIs that compute and persist summarized progress against the project hierarchy in PA_PROGRESS_ROLLUP. Because the ETRM classifies the object as OTHER and its procedures are not published as formal APIs, custom code should avoid calling INSERT_ROW, UPDATE_ROW, or DELETE_ROW directly. Doing so bypasses the validation, message handling, and interface logic implemented in PA_INTERFACE_UTILS_PUB and FND_MSG_PUB that the package depends upon. Customers requiring progress rollup data should instead consume the summarized results from PA_PROGRESS_ROLLUP through supported reporting mechanisms, leaving maintenance of the underlying rows to Oracle Projects' own processing. Any troubleshooting of rollup discrepancies should treat this package as a supporting implementation detail rather than a supported integration surface.