Search Results pa_project_structure_utils




Overview
Explore in AI Chat

Overview

APPS.PA_PROJECT_STRUCTURE_UTILS is a server-side PL/SQL utility package body in the Oracle E-Business Suite Projects (PA) module. It provides the shared, low-level business logic that governs the definition, validation, versioning, publication, and licensing of project structures and their workplan attributes. In EBS terminology, a "project structure" is the configurable work breakdown framework (such as a Work Breakdown Structure, task hierarchy, or financial structure) that organizes project elements into a hierarchical tree. This package encapsulates the rules that determine whether a structure or structure version may be created, renamed, deleted, locked, or published, and it resolves structural metadata such as the structure type associated with a given structure or version.

The package is classified as an OTHER API in the ETRM repository, is owned by APPS, and carries a VALID status. It is a widely consumed internal utility: the documented metadata records that it is referenced by 92 other database objects, indicating that it forms part of the foundational plumbing on which the public project structure APIs (for example PA_PROJECT_STRUCTURE_PUB1) and related packages such as PA_TASK_UTILS, PA_PROJ_ELEMENTS_UTILS, and PA_WORKPLAN_ATTR_UTILS depend. It also calls into those same helper packages, FND_API, FND_MESSAGE, and FND_MSG_PUB, reflecting a design in which this package both enforces constraints and returns structured error information through the standard EBS message stack.

Key Procedures and Functions

The documented interface exposes 83 procedures and functions. The principal groups are as follows.

Tables Accessed

The package reads and writes the core Projects structure tables through APPS synonyms. PA_PROJECTS_ALL, PA_PROJ_ELEMENTS, PA_PROJ_ELEMENT_VERSIONS, and PA_PROJ_ELEM_VER_STRUCTURE supply the project, element, version, and hierarchy data that the validation routines inspect. PA_STRUCTURE_TYPES and PA_PROJ_STRUCTURE_TYPES provide structure type definitions used by the type-resolution and licensing checks. PA_PROJ_ELEM_VER_SCHEDULE and PA_PROJ_WORKPLAN_ATTR support scheduling and workplan attribute handling, while PA_OBJECT_RELATIONSHIPS and PA_PERCENT_COMPLETES link structures to related objects and progress measurement. PA_PROJECT_STATUSES and PA_PROJ_FP_OPTIONS are consulted for status and financial plan options. Audit, event, and infrastructure information is drawn from FND_USER, PA_IMPLEMENTATIONS, PA_PJI_PROJ_EVENTS_LOG, and PA_PJI_PROJ_EVENTS_LOG.

Usage Notes

PA_PROJECT_STRUCTURE_UTILS is not intended for direct end-user invocation. It is called by the Project Workbench and related Projects forms, by concurrent programs that create or publish structure versions, and by public APIs such as PA_PROJECT_STRUCTURE_PUB1 that require pre-validation before committing changes. Because it performs name-uniqueness, locking, publication, and licensing checks, custom code extending project structure functionality should call the supporting validation routines rather than replicating their logic, ensuring consistent enforcement of EBS business rules across releases 12.1.1 and 12.2.2.