Search Results pa_relationship_pub




Overview
Explore in AI Chat

Overview

PA_RELATIONSHIP_PUB is the public PL/SQL API package in Oracle Projects (PA) responsible for creating, maintaining, and deleting the structural and logical linkages that exist between project entities. These linkages include relationships between project elements, cross-project dependencies, subproject associations, and program group membership. The package is declared with AUTHID CURRENT_USER, meaning all unqualified object references resolve against the schema of the calling session rather than against APPS, and it is classified as a public (PUB) API for external consumption. Its source header (PAXRELPS.pls 120.2) places it in the standard Oracle Projects API family, and it shares the common FND_API messaging and concurrency conventions used throughout EBS, including API version, initialization of the message list, commit control, validation-only mode, and caller-supplied validation level.

Key Procedures and Functions

The documented interface exposes ten public procedures spanning four functional areas:

  • CREATE_RELATIONSHIP — Establishes a relationship between a "from" project element and a "to" project element, accepting either identifiers or names for the project, structure, structure version, and task on each side.
  • DELETE_RELATIONSHIP — Removes an existing relationship record between two project elements.
  • CREATE_DEPENDENCY — Creates a dependency between project elements, typically used to model scheduling or precedence between tasks.
  • UPDATE_DEPENDENCY — Modifies attributes of an existing dependency.
  • DELETE_DEPENDENCY — Removes an existing dependency.
  • CREATE_SUBPROJECT_ASSOCIATION — Associates a project with a subproject within the project hierarchy.
  • UPDATE_SUBPROJECT_ASSOCIATION — Modifies attributes of an existing subproject association.
  • DELETE_SUBPROJECT_ASSOCIATION — Removes a subproject association.
  • UPDATE_PROGRAM_GROUPS — The procedure matched by the user's search term; it updates the program group membership associated with a project relationship, allowing a program group designation to be set or changed through the API rather than through direct table maintenance.

The package is referenced by seven other packages, indicating it is a shared service layer for project relationship maintenance.

Tables Accessed

The package operates against the following APPS synonyms:

Usage Notes

PA_RELATIONSHIP_PUB is invoked whenever project relationship data must be modified through a supported interface. Typical callers include the Oracle Projects forms that maintain project-to-project relationships and subproject associations, program management components that assign program groups, and other Oracle Projects packages — seven packages in the ETRM metadata reference it directly. Custom integrations should call the API rather than performing DML against PA_OBJECT_RELATIONSHIPS, because the API performs element version validation, writes the project events log for propagation, and honors the standard validation level and validate-only semantics. Callers should pass p_validate_only in TRUE during dry runs, and should control transaction scope explicitly through p_commit, since the package does not commit by default. The p_calling_module and p_debug_mode parameters support diagnostic tracing when a custom module is the originating caller.