Search Results pa_project_parties_pub




Overview
Explore in AI Chat

Overview

PA_PROJECT_PARTIES_PUB is a public (PUB) PL/SQL API package in the APPS schema that governs the assignment of project parties to Oracle Projects. A "project party" represents a person, organization, or resource associated with a project and carrying a defined project role, such as project manager, team member, customer contact, or stakeholder. This package provides the transactional interface through which project party records are created, modified, and removed, while enforcing the business rules, validation logic, and role-related processing that Oracle Projects requires.

Because the package is classified as PUB, it is intended as a supported integration point: external modules and custom extensions may call it rather than writing directly to the underlying base tables. Internally it depends on FND_API, the Oracle Application Object Library infrastructure used for standard APIs (message handling, savepoints, and consistent error reporting), and on the STANDARD library for common PL/SQL utilities. The package is widely consumed within the Projects family, being referenced by components such as PA_PROJECTS_MAINT_PUB, PA_PROJECTS_MAINT_PVT, PA_PROJECT_CHECK_PVT, PA_PROJECT_CORE, PA_PROJECT_PVT, PA_PROJECT_PUB, PA_CUSTOMERS_CONTACTS_PVT, PA_STAFFED_ASSIGNMENT_PVT, PA_TASK_MANAGER, and GMS_AWARD_PVT, reflecting its role as the shared entry point for project party maintenance.

Key Procedures and Functions

  • CREATE_PROJECT_PARTY — Creates a new party assignment for a project, establishing the association between a resource and a project role.
  • CREATE_PROJECT_PARTY_WRP — A wrapper variant of the create operation, typically used to invoke party creation logic with standardized handling of parameters and return status.
  • UPDATE_PROJECT_PARTY — Modifies an existing project party record, such as changing role assignments or related attributes.
  • DELETE_PROJECT_PARTY — Removes a project party from a project, reversing the assignment.
  • GET_KEY_MEMBER_START_DATE — A function that returns the start date associated with a key member of the project party structure, used to determine effective dating for key project personnel.

These five documented routines constitute the complete public interface. Parameter lists are intentionally omitted here; callers should consult the package specification for exact signatures.

Tables Accessed

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

  • PA_PROJECT_PARTIES — The primary base table holding project party assignments; create, update, and delete operations act on this table.
  • PA_PROJECT_ROLE_TYPES_B — Supplies valid project role definitions used to validate role assignments.
  • PA_RESOURCES and PA_RESOURCE_TYPES — Provide the people, organizations, and resource classifications that can be assigned as parties.
  • PA_TASKS — Supports party associations tied to specific project tasks where applicable.
  • PA_PROGRESS_ROLLUP — Referenced in progress-related processing associated with project staffing.
  • FND_NEW_MESSAGES — Part of the standard error and message handling infrastructure used by the API.

Usage Notes

PA_PROJECT_PARTIES_PUB is normally invoked implicitly rather than directly. Oracle Projects forms for project definition, staffing, and customer/contact maintenance call higher-level packages such as PA_PROJECTS_MAINT_PUB and PA_PROJECT_PVT, which in turn delegate party operations to this package. Concurrent programs that staff projects or synchronize project teams similarly reach it through the same call chain. Custom code should treat PA_PROJECT_PARTIES_PUB as the supported API for project party maintenance, using its create, update, delete, and start-date retrieval routines instead of direct DML against PA_PROJECT_PARTIES, so that validation logic, role checks, and FND_API-based error handling remain intact. Because the package is referenced by eleven or more standard packages, its interface should be treated as a stable contract when building integrations in Oracle EBS 12.1.1 or 12.2.2.