Search Results create_subproject_association

Overview

PA_RELATIONSHIP_PUB is a public PL/SQL API package in the Oracle E-Business Suite Projects (PA) module. Its business purpose is to create, maintain, and remove relationships between project structures and project elements in Oracle Project Management and Oracle Project Foundation. These relationships include dependency links between tasks or project elements and subproject-to-project associations used in multi-project hierarchies. The package encapsulates the validation and persistence logic required to keep the underlying project relationship and project structure tables consistent with the intent expressed through the public API.

The package is classified as a PUB API, meaning it constitutes a supported interface exposed to external callers. In the ETRM 12.1.1 / 12.2.2 documentation for this object, the body header identifies the package name as G_PKG_NAME := 'PA_RELATIONSHIP_PUB'. The initial comments describe the Create_Relationship procedure and enumerate its parameters, including API version, initialization message list, commit and validation flags, calling module, debug mode, maximum message count, and the from/to project, structure, structure version, task version, and task name identifiers. This pattern confirms that the package follows the standard Oracle EBS API conventions of API version, validation flag, commit flag, and message list handling.

Key Procedures and Functions

The documented procedures and functions for this package total ten and cover the following operations:

• CREATE_RELATIONSHIP — establishes a relationship between two project entities, as described in the body header excerpt with its project, structure, version, and task parameters.
• DELETE_RELATIONSHIP — removes an existing relationship between project entities.
• CREATE_DEPENDENCY — creates a dependency between project elements or tasks.
• UPDATE_DEPENDENCY — modifies an existing dependency.
• DELETE_DEPENDENCY — removes an existing dependency.
• CREATE_SUBPROJECT_ASSOCIATION — establishes an association between a subproject and its parent or related project context.
• UPDATE_SUBPROJECT_ASSOCIATION — modifies the subproject association, including ownership percentages or effective dates where supported.
• DELETE_SUBPROJECT_ASSOCIATION — the procedure most closely matching the search terms used to locate this package; it removes an existing subproject-to-project association.
• UPDATE_PROGRAM_GROUPS — updates program group assignments associated with the project relationship data.

The procedures distinguish between relationship, dependency, and subproject association concepts, each targeting specific records within the shared relationship infrastructure.

Tables Accessed

The package accesses its data through APPS synonyms. The principal table is PA_OBJECT_RELATIONSHIPS, which stores the relationship and dependency records maintained by this API. Subproject association data resides in the same relationship framework, and PA_PROJ_ELEMENT_VERSIONS, PA_PROJ_ELEMENT_VERSIONS_S1, and PA_PROJ_ELEM_VER_STRUCTURE supply the project element version and structure definitions referenced by the from and to identifiers. PA_PROJECTS_ALL provides project validation, and PA_PROJ_STRUCTURE_TYPES supplies structure classification. PA_PROJ_LEVELS_TMP is used during hierarchical processing. The package also writes or reads PA_PJI_PROJ_EVENTS_LOG and PA_PJI_PROJ_EVENTS_LOG_S, the project events log tables used to record changes that drive downstream processing. DUAL is used for single-row lookups. These tables confirm that the API operates within the project structure and relationship data model rather than directly manipulating the core project definition.

Usage Notes

PA_RELATIONSHIP_PUB is invoked by Oracle Projects forms, concurrent programs, and custom extensions that need a supported interface for manipulating relationships, dependencies, and subproject associations. Because it is classified PUB, it is appropriate for external calls that must respect the validation, commit, and message list conventions documented in the body header. The reference to seven dependent packages indicates that the API is consumed by other Oracle Projects components in addition to direct custom use. When integrating with this package for subproject association maintenance, the DELETE_SUBPROJECT_ASSOCIATION procedure provides the supported mechanism for removing an existing association while preserving the integrity of the underlying relationship and event log records.