Results for “pa_project_parties_pvt”

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

Overview

PA_PROJECT_PARTIES_PVT is a private (PVT) PL/SQL package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Oracle Projects (PA) module and provides the internal implementation layer for managing project parties — the roles, resources, and external contacts associated with a project. In Oracle Projects, a "party" represents an entity assigned to or associated with a project, such as a project manager, team member, customer contact, or other stakeholder linked through Oracle Trading Community Architecture (TCA) relationships.

The package is classified as a private API, meaning it is not intended for direct invocation by external or customer-developed code. Instead, it serves as the underlying engine called by the public API layer, most notably PA_PROJECT_PARTIES_PUB. This public/private split follows the standard Oracle EBS API architecture, where _PUB packages expose validated, documented entry points while _PVT packages encapsulate the core business logic, validation, and DML operations. The PVT layer also depends on FND_API, reflecting use of the standard Oracle Application Object Library API utilities (such as the global data structure and error-handling conventions) common to EBS APIs.

Key Procedures and Functions

The ETRM metadata documents three procedures within PA_PROJECT_PARTIES_PVT:

• CREATE_PROJECT_PARTY — Inserts a new party association for a project. It handles the core record creation, including validation of the party, resource, and relationship data required to establish the association.
• UPDATE_PROJECT_PARTY — Modifies attributes of an existing project party record, such as role, dates, or associated resource information.
• DELETE_PROJECT_PARTY — Removes a project party association, supporting the lifecycle management of parties tied to a project.

Specific parameter lists are not reproduced here; the procedures follow the standard EBS API convention of accepting entity identifiers and attribute values, and returning a standard API return status using FND_API error-handling structures.

Tables Accessed

The package operates against the following tables via APPS synonyms:

• PA_PROJECT_PARTIES — The primary table storing project party records; the target of the create, update, and delete operations.
• PA_PROJECT_ASSIGNMENTS — Stores assignment details linking resources to projects, providing context for party role assignments.
• PA_PROJECT_CUSTOMERS — Holds customer associations for a project, relevant when the party is an external customer contact.
• PA_RESOURCES_DENORM — A denormalized resource table used for efficient resource lookups and validation.
• PA_RESOURCE_TXN_ATTRIBUTES — Stores resource transaction attributes supporting resource-related validation and defaults.
• HZ_RELATIONSHIPS — The TCA relationships table, used to validate and resolve party relationship information for external parties.

Usage Notes

PA_PROJECT_PARTIES_PVT is invoked indirectly rather than called directly by end users or typical customizations. According to the dependency metadata, it is referenced by six other packages, including PA_PROJECT_PARTIES_PUB, which is the supported public entry point for project party operations. Other consumers include FPA_SECURITY_PVT, OKE_K_ACCESS_PVT, PA_ASSIGNMENT_APPROVAL_PUB, PA_SCHEDULE_PVT, and PA_STAFFED_ASSIGNMENT_PVT, indicating the package participates in security, assignment approval, scheduling, and staffing workflows.

Because of its private classification, customizations should call PA_PROJECT_PARTIES_PUB instead of this package to ensure validation, error handling, and forward compatibility. The package interacts with Oracle Projects forms, concurrent programs, and dependent APIs that manage project staffing and party relationships. Its reliance on FND_API confirms adherence to standard EBS API error and message conventions.