Search Results pa_relationship_utils




Overview
Explore in AI Chat

Overview

PA_RELATIONSHIP_UTILS is an Oracle EBS Projects (PA) schema utility package owned by APPS and classified as an OTHER-type API. It provides the low-level validation, lookup, and structural-checking logic that governs relationships between project and task structures. In Oracle Projects, tasks and project elements can be linked through several relationship types: intersubject links, dependencies, and associations. This package centralizes the rules that determine whether such a relationship may legally be created, whether it already exists, and how structural hierarchies (parent/child, predecessors) are resolved.

The package is not a user-facing entry point; it is an internal utility layer consumed by higher-level public and private APIs. As confirmed by the ETRM dependency listing, it is referenced by PA_RELATIONSHIP_PVT, PA_PROJECT_PUB, PA_PROJECT_STRUCTURE_PVT1, PA_PROJ_STRUCTURE_PUB, PA_PROJ_ELEMENTS_UTILS, PA_TASK_PUB1, PA_TASK_PVT1, PA_TASK_UTILS, PA_PROJ_TASK_STRUC_PUB, PA_STRUCT_TASK_ROLLUP_PUB, and numerous project/task progress views. This wide fan-in indicates that PA_RELATIONSHIP_UTILS is a foundational component of the Projects relationship model, exercised whenever project elements or tasks are linked, versioned, or rolled up. Its only external package dependency is on the SYS.STANDARD package.

Key Procedures and Functions

The documentation enumerates 26 procedures and functions. Their names reveal a consistent pattern of query and validation utilities grouped by relationship category.

No parameter lists are documented in the ETRM metadata; each routine should be treated as an internal helper whose signature is defined by the package specification.

Tables Accessed

The package reads from core Projects relationship and structure tables through APPS synonyms:

Usage Notes

PA_RELATIONSHIP_UTILS is typically invoked from higher-level packaged APIs rather than directly from forms or concurrent programs. The public entry points that project managers and developers use — PA_PROJECT_PUB, PA_PROJ_STRUCTURE_PUB, PA_TASK_PUB1, and PA_RELATIONSHIP_PVT — delegate relationship and dependency checks to this package. Its functions are also referenced by database views such as PA_LATEST_PROJ_TASK_PROG_V, PA_PROGRESS_HIST_DET_V, and the structure version views, meaning the routines execute whenever those views are queried.

Because the package is classified as OTHER and depends only on SYS.STANDARD, Oracle does not guarantee a formalized public API contract. Customizations should not call it directly where a documented public API exists; instead, custom code should use the referencing public packages. When extending relationship logic, the appropriate pattern is to place validations in this utility layer so that all consumers inherit consistent behaviour.