Search Results pa_progress_report_pvt




Overview
Explore in AI Chat

Overview

PA_PROGRESS_REPORT_PVT is a private PL/SQL package in the APPS schema that implements the core business logic for Oracle Projects progress reports in Oracle E-Business Suite 12.1.1 and 12.2.2. Progress reports capture periodic status narrative, percent-complete assessments, and supporting detail for projects and tasks, and are routed through an approval workflow. This package is classified as a PVT (private) API layer, meaning its procedures are not intended to be called directly by external consumers. Instead, it is referenced by the public wrapper package PA_PROGRESS_REPORT_PUB, which exposes the supported interface and performs standard API housekeeping such as parameter validation and exception translation through FND_API. The package therefore serves as the internal engine behind progress report creation, versioning, submission, approval, and publication, and is also referenced internally by itself for shared utility logic.

Key Procedures and Functions

Sixteen documented procedures and functions comprise the package, covering configuration, report lifecycle, and workflow-driven status transitions.

Tables Accessed

The package reads and writes configuration and transactional data across several Oracle Projects tables. PA_PAGE_LAYOUTS, PA_OBJECT_PAGE_LAYOUTS, PA_PAGE_LAYOUT_REGIONS, and PA_PAGE_TYPE_REGIONS define the page structure and region configuration used when rendering reports. PA_REPORT_TYPES supplies the report type definitions. PA_PROGRESS_REPORT_VERS and PA_PROGRESS_REPORT_VALS hold report header versions and the detailed value lines for each version. PA_PROJECTS_ALL and PA_TASKS provide the project and task context against which reports and percent-complete values are recorded. PA_PROJECT_PARTIES identifies the project team members eligible to author or approve. PA_PROJECT_STATUSES is consulted for project lifecycle validation. PA_WF_PROCESSES and WF_ITEM_ACTIVITY_STATUSES link the package to the Oracle Workflow approval routing. FND_USER is used for user identity resolution. The APPS synonyms map these to the underlying application tables.

Usage Notes

PA_PROGRESS_REPORT_PVT is invoked indirectly rather than directly by end users or custom code. The Oracle Projects progress report forms call PA_PROGRESS_REPORT_PUB, which in turn delegates to this private package, so all standard UI transactions for creating, submitting, approving, and publishing progress reports flow through these procedures. Workflow background processes related to progress report approval also invoke the status-change logic that resides here, using records in PA_WF_PROCESSES and WF_ITEM_ACTIVITY_STATUSES to drive transitions. Concurrent programs that purge or regenerate version data may call DELETE_VERSION_DATA. Because the package depends on FND_API for its error-handling conventions, exceptions raised internally are surfaced to callers in the standardized FND_API format. Customizations should target PA_PROGRESS_REPORT_PUB rather than this PVT layer, since the private package signature may change between releases without public notice. In 12.2.2 the package remains VALID and is referenced by PA_PROGRESS_REPORT_PUB, and it references itself for shared internal logic. The documented dependency set is limited to FND_API and PA_PAGE_LAYOUTS, with type definitions from PA_VARCHAR2_2000_TBL_TYPE and PA_VARCHAR2_30_TBL_TYPE used for list-based parameters.