Search Results publish_inter_proj_dep

Overview

PA_RELATIONSHIP_PVT is a private PL/SQL package in the APPS schema that maintains the structural and dependency relationships between projects, tasks, and project elements within Oracle Projects. It functions as the internal engine behind the public relationship APIs, encapsulating the low-level logic required to create, update, and delete the object relationships stored in PA_OBJECT_RELATIONSHIPS. Because it is classified as a PVT (private) package, it is not intended for direct invocation by external or customer code; it is called by the public packages PA_RELATIONSHIP_PUB, PA_PROJECT_PUB, PA_TASK_PUB1, and the project structure packages. The package is central to operations such as intra-project task dependencies, cross-project (inter-project) dependencies, subproject associations, and the propagation of relationship data during project copy and structure manipulation.

Key Procedures and Functions

• CREATE_RELATIONSHIP / UPDATE_RELATIONSHIP / DELETE_RELATIONSHIP — Manage the base relationship records that link project elements, providing the core create, modify, and remove operations invoked by the public API layer.
• CREATE_DEPENDENCY / UPDATE_DEPENDENCY / DELETE_DEPENDENCY — Maintain scheduling dependencies between tasks and elements, including predecessor/successor logic that supports project scheduling.
• COPY_INTRA_DEPENDENCY — Replicates dependencies that exist within a single project, typically during a project or structure copy.
• COPY_INTER_PROJECT_DEPENDENCY — Copies dependencies that span multiple projects, preserving cross-project scheduling links.
• PUBLISH_INTER_PROJ_DEP — Publishes or activates inter-project dependency information, making cross-project relationships effective.
• CREATE_SUBPROJECT_ASSOCIATION / UPDATE_SUBPROJECT_ASSOCIATION / DELETE_SUBPROJECT_ASSOCIATION — Manage associations between a subproject and its parent, controlling the subproject linkage lifecycle.
• COPY_OG_LNK_FOR_SUBPROJ_ASS — Copies organization linkage data associated with a subproject association.
• MOVE_CI_LNK_FOR_SUBPROJ_STEP1 — Executes the first step of relocating capital-interest linkage data when a subproject relationship is moved.
• UPDATE_PARENT_WBS_FLAG_DIRTY — Marks the parent WBS as dirty so that dependent structure and rollup data are refreshed.

Tables Accessed

The package reads and writes PA_OBJECT_RELATIONSHIPS, the primary repository of relationship records, together with its sequence PA_OBJECT_RELATIONSHIPS_S for key generation. PA_PROJECTS_ALL and PA_PROJ_ELEMENTS supply project and element definitions, while PA_PROJ_ELEMENT_VERSIONS, PA_PROJ_ELEM_VER_SCHEDULE, and PA_PROJ_ELEM_VER_STRUCTURE hold versioned schedule and structure detail used during copy and dependency operations. PA_PROJ_STRUCTURE_TYPES and PA_STRUCTURE_TYPES define the structural classifications referenced during relationship creation. PA_COPY_DEP_TEMP, PA_IMPLEMENTATIONS_ALL, DUAL, and the PL/SQL table type PLITBLM support staging, implementation lookup, and in-memory processing.

Usage Notes

PA_RELATIONSHIP_PVT is invoked indirectly whenever users create or modify dependencies, subproject associations, or project structures through Oracle Projects forms, or when concurrent programs such as project copy and structure maintenance run. It is referenced by seven packages, including PA_RELATIONSHIP_PUB, PA_PROJECT_PUB, PA_PROJ_STRUCTURE_PVT, and PA_TASK_PUB1. Custom code should call the corresponding public (PUB) APIs rather than this private package, because the internal signatures and logic are not guaranteed to remain stable across releases. Direct invocation is reserved for Oracle-internal dependent code.