Search Results change_structure_status

Overview

APPS.PA_WORKPLAN_AMG_PUB is a public PL/SQL API package in Oracle EBS Projects (PA) that governs the lifecycle status of a project workplan structure. In Oracle Projects, a workplan is stored as a hierarchical structure of project elements, each version of which is identified by an element version identifier within a project. The package exposes programmatic control over transitioning that structure between its defined states — working, submitted, and published — and over the act of baselining the structure for comparison and progress tracking. Because workplan publishing is a controlled business event, the API validates caller compatibility, performs responsibility and user security initialization, and returns standard FND_API messaging so that forms or concurrent programs can surface errors consistently.

The source header identifies the package as internal-shipped ("noship") with a version lineage of 115.3, indicating it is maintained by Oracle rather than customer-extensible. The documented API classification is PUB, meaning it is intended as a supported public interface.

Key Procedures and Functions

• CHANGE_STRUCTURE_STATUS — Transitions a workplan structure version to a new status. Documented valid status codes are STRUCTURE_PUBLISHED, STRUCTURE_SUBMITTED, and STRUCTURE_WORKING. The procedure is keyed on a structure version identifier and a project identifier, and it returns the identifier of the resulting published structure version when publishing occurs. It follows the standard EBS API conventions: an API version number checked through FND_API.Compatible_API_Call, an initialization message list flag, a commit flag, and the standard return status, message count, and message data out parameters. Internally it opens a savepoint, resolves the record version number and structure identifier from the element version structure, and initializes caller context via PA_SECURITY.INITIALIZE using the current responsibility, user, and module.
• BASELINE_STRUCTURE — Creates a baseline of the workplan structure, capturing the current state of the structure for subsequent variance and progress reporting against the live plan. Like CHANGE_STRUCTURE_STATUS it operates within a project and structure version context and adheres to the shared API error-handling and messaging model.

Tables Accessed

The primary documented table is PA_PROJ_ELEM_VER_STRUCTURE, accessed through an APPS synonym. This table stores the versioned structure records for project elements and supplies the record version number used for optimistic locking and the internal structure identifier used to locate the correct workplan. All status transitions and baselining operations resolve their target through this table before applying changes. Because the package is a PUB API, additional dependent objects are reached indirectly through the Projects security and interface utility layers rather than through direct DML in the package body.

Usage Notes

PA_WORKPLAN_AMG_PUB is normally invoked from the Oracle Projects workplan user interface — the Project Workplan and related structure pages — when a user submits, publishes, or baselines a workplan, and it may also be called from concurrent programs or custom extensions that automate workplan status management. The package is referenced by one other package within the ETRM inventory, confirming it sits beneath higher-level workplan processing logic. Callers should supply a valid API version number, honor the returned status rather than assuming success, and respect the commit flag when invoking the API from within an existing transaction. Direct table updates to PA_PROJ_ELEM_VER_STRUCTURE should not be substituted for these APIs, as the procedures enforce security initialization and validation that ad hoc DML would bypass.