Search Results check_merged_project

Overview

PA_PROJ_STRUCTURE_UTILS is a utility package in the Oracle E-Business Suite Projects (PA) module, owned by the APPS schema and validated against releases 12.1.1 and 12.2.2. It provides low-level helper logic that underpins the project structure and workplan APIs rather than exposing a business-facing interface of its own. The package supports creation, validation, and maintenance of project structures, WBS hierarchies, and task assignments by supplying reusable checks and lookups consumed by the public and private structure packages. Its dependency profile confirms this supporting role: it references FND_API and STANDARD, and is referenced by PA_PROJ_STRUCTURE_PUB, PA_PROJ_STRUCTURE_PVT, PA_PROJ_STRUCTURE_UTILS itself (internal recursion), PA_PROGRESS_PUB, and PA_WORKPLAN_WORKFLOW. In ETRM the object is classified as an OTHER API and exposes nine documented procedures and functions.

Key Procedures and Functions

• CHECK_LOOPED_PROJECT — Detects circular or looping references within a project structure hierarchy, preventing invalid self-referencing relationships before a structure is committed.
• CHECK_MERGED_PROJECT — Validates whether a project has been merged or otherwise consolidated, so downstream structure operations do not act on an ineligible project.
• CHECK_PROJECT_CONTRACT_EXISTS — Confirms the existence of a contract association at the project level, supporting validations required when project structures must be linked to contract data.
• CHECK_TASK_CONTRACT_EXISTS — Performs the equivalent check at the task level, verifying contract associations for individual tasks.
• IS_WF_ENABLED_FOR_STRUCTURE — Determines whether Oracle Workflow is enabled for a given project structure, allowing callers to conditionally invoke workflow-driven processing.
• GET_ALL_WBS_REJNS — Retrieves WBS rejection information, used by structure maintenance and workflow logic to surface rejected work breakdown elements.
• CHECK_STR_TEMP_TAB_POPULATED — Verifies that the project structure temporary table contains rows, guarding processes that depend on staged structure data.
• CHECK_PJI_TEMP_TAB_POPULATED — Performs the analogous check for the PJI (Project/Portfolio Integration) temporary table, safeguarding integration extracts.
• SET_BUDGET_VERSION_ID_GLOBAL — Establishes the budget version identifier in a package global, making it available to subsequent operations within the session.

Tables Accessed

The package works against core Projects structure tables. PA_PROJ_ELEMENTS and PA_STRUCTURE_TYPES (with the related PA_PROJ_STRUCTURE_TYPES) define the elements and structural definitions being validated. PA_TASKS and PA_STRUCTURES_TASKS_TMP hold task and staged structure-task data used by population and existence checks. PA_BUDGET_VERSIONS supports SET_BUDGET_VERSION_ID_GLOBAL, while PA_OBJECT_RELATIONSHIPS underpins relationship and loop validation. PJI_FM_XBS_ACCUM_TMP1, a Project/Portfolio Integration staging table, is referenced by the PJI temporary-table check. All access occurs through APPS synonyms.

Usage Notes

Because this is a utility package, it is not normally invoked directly from Oracle Forms or standalone concurrent programs. It is called by the higher-level Project Structure public and private APIs, by progress and workplan workflow components, and by custom extensions that already depend on the structure APIs. Customizations should prefer the documented public entry points; direct calls to PA_PROJ_STRUCTURE_UTILS are appropriate only when replicating the validation and staging logic already exercised by PA_PROJ_STRUCTURE_PUB or PA_WORKPLAN_WORKFLOW. As an underlying means to internal state, such as budget version globals and temporary tables, it assumes the caller maintains correct session sequencing.