Results for “pa_proj_struc_mapping_pub”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_PROJ_STRUC_MAPPING_PUB is a public PL/SQL package in the APPS schema that governs the mapping of project structures to the relationships defined within Oracle Project Management and Oracle Project Foundation. In Oracle EBS 12.1.1 and 12.2.2, project structures (such as Work Breakdown Structures, task structures, and deliverable structures) are linked together through object relationships that enable cross-structure rollups, hierarchies, and associations. This package encapsulates the business logic required to create, update, copy, and delete those structural mappings so that calling programs do not manipulate the underlying relationship and structure tables directly.

The package is classified as a public API (PUB), indicating it is intended for invocation by other Oracle applications, external interfaces, and custom extensions. It relies on the Oracle Application Object Library APIs — FND_API, FND_MSG_PUB, FND_GLOBAL, and FND_PROFILE — for error handling, message stacking, and session context. Debugging is supported through PA_DEBUG, and common project utilities are reused from PA_INTERFACE_UTILS_PUB, PA_RELATIONSHIP_PUB, and PA_UTILS.

Key Procedures and Functions

Five documented procedures constitute the public interface of this package. Their purpose is consistent with the create/read/update/delete pattern typical of Oracle project APIs:

• CREATE_MAPPING — Establishes a new mapping between a project structure element and its associated object relationship, inserting the necessary records into the structure and relationship tables and validating the mapping against existing structure definitions.
• UPDATE_MAPPING — Modifies an existing structure mapping, allowing attributes of the relationship or associated element version to be changed while preserving referential integrity.
• COPY_MAPPING — Duplicates an existing mapping, typically to replicate a structure relationship across projects, versions, or template structures.
• DELETE_MAPPING — Removes a specific mapping, including the corresponding object relationship and element-version structure records, while enforcing dependency checks.
• DELETE_ALL_MAPPING — Removes all mappings associated with a given structure or context, used when a structure is being reorganized or purged.

No parameter lists are published in the available metadata; callers should reference the package specification and Oracle's documented API signatures before invoking these procedures.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• PA_PROJ_ELEMENTS and PA_PROJ_ELEMENT_VERSIONS — Store project structure elements and their versioned definitions; the package validates and updates element records as mappings change.
• PA_PROJ_ELEM_VER_STRUCTURE — Associates element versions with a structure, forming the core of the mapping data.
• PA_OBJECT_RELATIONSHIPS and PA_OBJECT_RELATIONSHIPS_S — Hold the relationship definitions (parent/child, rollup, and similar) between objects; the sequence table supports surrogate key generation.
• PA_PROJ_STRUCTURE_TYPES and PA_STRUCTURE_TYPES — Define the types of structures supported, ensuring mappings conform to valid structure type combinations.
• PLITBLM — A standard Oracle PL/SQL table used for internal processing.

Usage Notes

PA_PROJ_STRUC_MAPPING_PUB is typically invoked from Oracle Projects forms, concurrent programs, and interface routines that maintain project structures. It is referenced by four other packages, indicating it functions as a lower-level service consumed by higher-level project APIs. Custom code should call these procedures rather than performing direct DML against the underlying tables, ensuring that validation, message handling, and relationship integrity are preserved. Because the package uses FND_API conventions, callers should initialize the FND message stack and inspect the returned API status before committing.