Search Results self_service

Overview

PA_CUSTOMERS_CONTACTS_PVT is a private PL/SQL API package in the Oracle E-Business Suite Projects (PA) module, owned by the APPS schema and defined with AUTHID CURRENT_USER. It provides the core business logic for maintaining the relationship between projects, customers, and contacts within Oracle Projects. In Oracle EBS 12.1.1 and 12.2.2, project customer and contact information drives billing, invoicing, and project delivery communication, and this package encapsulates the validation and persistence rules that govern those relationships.

The package header carries the version marker $Header: PARPCCVS.pls 120.2 2005/10/27, indicating a long-stable code line. As a private (PVT) package, it is not intended for direct customer invocation; it is called by the public PA customer/contact APIs and by other product code that needs to create, update, or delete project customer and contact records in a controlled manner.

Key Procedures and Functions

The package exposes nine documented procedures. The three primary entry points manage the project-customer link:

• CREATE_PROJECT_CUSTOMER — Creates the association between a project and a customer, including the project relationship code, customer bill split percentage, bill-to and ship-to customer/address identifiers, and invoicing currency, rate type, rate date, and exchange rate. The documented signature shows commit, validate-only, validation-level, calling-module, debug, and message-count parameters, consistent with the standard EBS API parameter convention, plus x_return_status, x_msg_count, and x_msg_data output parameters.
• UPDATE_PROJECT_CUSTOMER — Modifies an existing project-customer relationship and its billing attributes.
• DELETE_PROJECT_CUSTOMER — Removes the project-customer relationship.

Three procedures govern customer contacts:

• CREATE_CUSTOMER_CONTACT — Establishes a contact record for a project or customer.
• UPDATE_CUSTOMER_CONTACT — Modifies an existing contact record.
• DELETE_CUSTOMER_CONTACT — Removes a single contact.

Two procedures and related helpers support validation and bulk removal:

• DELETE_ALL_CONTACTS — Removes all contacts associated with a given project or customer context.
• VALIDATE_CUSTOMER — Performs validation logic on a customer before persistence.
• VALIDATE_CONTACT — Performs validation logic on a contact before persistence.

Tables Accessed

The package operates against four base tables referenced through APPS synonyms:

• PA_PROJECT_CUSTOMERS — Stores the project-to-customer billing relationship, including bill split, relationship code, and invoicing currency and rate attributes.
• PA_PROJECT_CONTACTS — Stores contact assignments for projects.
• PA_PROJECT_PARTIES — Stores the parties associated with a project, underpinning customer and contact linkage.
• HZ_RELATIONSHIPS — The Trading Community Architecture (TCA) relationships table, used to validate and maintain contact-to-customer party relationships.

Usage Notes

Because APPS.PA_CUSTOMERS_CONTACTS_PVT is a private package, it is not registered for direct external calls. It is invoked by the public Oracle Projects customer and contact APIs, by Oracle Projects forms (such as the project customer and contact maintenance windows) via the corresponding public API layer, and by other internal packages — the ETRM metadata records one package referencing it. Custom code should call the public PA customer/contact APIs rather than this private package directly, since the private interface is subject to change without notice across patches. When invoked, callers pass the standard FND_API commit and validation controls; passing p_validate_only as FND_API.G_TRUE allows validation without persistence, and p_calling_module distinguishes self-service from forms or concurrent processing origins.