Search Results pa_assignment_progress_pub




Overview
Explore in AI Chat

Overview

PA_ASSIGNMENT_PROGRESS_PUB is a public PL/SQL package in the APPS schema that forms part of the Oracle E-Business Suite Project Management (PA) progress management API family. Its business purpose is to maintain progress information at the resource assignment level within a project. Oracle Projects tracks physical progress using several methods, including percent-complete, effort-based, and quantity-based calculations. While other progress APIs operate at the project, task, or resource level, PA_ASSIGNMENT_PROGRESS_PUB addresses the assignment layer — the specific association between a resource and a project or task defined in PA_RESOURCE_ASSIGNMENTS.

The package carries the PUB suffix, which follows Oracle's standard naming convention for public APIs. This indicates the package is intended for invocation by external callers, including Oracle Projects forms, concurrent programs, and customer extensions, rather than being restricted to internal use. The ETRM record documents the package as VALID with a single documented entry point, UPDATE_ASSIGNMENT_PROGRESS, and shows that it is referenced by PA_PROGRESS_PUB, the higher-level progress public API, confirming that assignment-level updates form a supporting layer beneath broader progress processing.

Key Procedures and Functions

The package exposes one documented procedure:

  • UPDATE_ASSIGNMENT_PROGRESS — This procedure updates progress information associated with a resource assignment. Its role is to record or recalculate the progress achieved against the assignment record, supporting the percent-complete and rollup mechanisms used by Oracle Projects. Detailed parameter lists are not documented in the ETRM excerpt and should be obtained from the package specification in the database. Callers should not assume parameter signatures; the authoritative definition resides in the APPS.PA_ASSIGNMENT_PROGRESS_PUB package specification.

Because no additional public subprograms are documented, the package should be treated as a focused, single-purpose API rather than a general progress utility. Broader progress processing is handled by PA_PROGRESS_PUB, which itself references this package.

Tables Accessed

The documented dependencies show that the package references the following tables through APPS synonyms:

The package also depends on FND_API and PA_INTERFACE_UTILS_PUB, which are standard Oracle Applications utilities used for API error handling and interface processing.

Usage Notes

PA_ASSIGNMENT_PROGRESS_PUB is typically invoked when resource assignment progress must be updated outside of standard form processing — for example, from custom PL/SQL extensions, concurrent programs, or interface routines that load progress data. Because it is a public API, it may also be called internally by PA_PROGRESS_PUB during broader progress update flows.

Developers should note that the package follows Oracle's API conventions, leveraging FND_API for message handling, meaning callers should expect standard API return statuses and error handling behavior. Any implementation should obtain the exact parameter list from the package specification in the target environment, as the ETRM metadata does not document parameters. This package is available in both Oracle EBS 12.1.1 and 12.2.2, and behavior is expected to be consistent across these releases given the unchanged dependency footprint.