Search Results pv_partner_accnt_mgmt_pvt




Overview
Explore in AI Chat

Overview

APPS.PV_PARTNER_ACCNT_MGMT_PVT is a private PL/SQL package in Oracle E-Business Suite that supports partner and customer account management within the Partner Management (PV) module of Oracle Partner Management. Its principal responsibility is to resolve the relationship between a partner party and the corresponding Receivables customer account, and to manage the account site uses and role assignments that link those entities. The package is classified as PVT (private), meaning it is intended for internal consumption by other PL/SQL packages rather than direct invocation by forms, concurrent programs, or external custom code. ETRM documents that it is referenced by two other packages, confirming its role as a shared internal utility layer.

Key Procedures and Functions

ETRM documents four procedures in this package. The naming convention and the R12 change comments embedded in the source indicate the specific business purpose of each.

  • GET_PARTNER_ACCNT_ID — Resolves the Receivables customer account identifier for a given partner party. It accepts a partner party identifier as input and returns a return status plus the customer account identifier, allowing callers to map a partner to its corresponding customer account in HZ_CUST_ACCOUNTS.
  • GET_ACCT_SITE_USES — Retrieves account site use information. The R12 change comments state that an additional out parameter, x_cust_acct_site_id, was added so the value can be passed into subsequent calls to GET_CUST_ACCT_ROLES. The procedure also takes the party site identifier, account site type, customer account identifier, and party identifier as inputs.
  • GET_CUST_ACCT_ROLES — Returns the customer account role assignments associated with a customer account site. This is the procedure most directly associated with the search term "get_cust_acct_roles." It depends on the customer account site identifier produced by GET_ACCT_SITE_USES, reflecting the R12 design where account site context is required to resolve role assignments correctly.
  • CREATE_PARTY_SITE — Creates a party site record, supporting the establishment of addresses and site relationships for a partner or customer party.

The package also declares two record types, Location_Rec_Type and Party_Site_Rec_Type, which use FND_API.G_MISS_* default values to support the standard EBS API convention of distinguishing "missing" values from nulls. No parameter lists are invented here; only the documented signatures and purposes are described.

Tables Accessed

The package accesses a set of APPS synonyms spanning Receivables and the Trading Community Architecture (TCA):

Usage Notes

Because the package is classified PVT, it is not designed for direct invocation. It is typically called from other packages within the Partner Management and Receivables integration layer—ETRM confirms it is referenced by two other packages. The R12 change annotations are significant: they show that the package was refactored to pass x_cust_acct_site_id from GET_ACCT_SITE_USES into GET_CUST_ACCT_ROLES, and that p_cust_account_site_id is no longer null. Any custom code that attempts to call GET_CUST_ACCT_ROLES directly must therefore supply a valid customer account site identifier or invoke GET_ACCT_SITE_USES first. Customers upgrading from pre-R12 releases should account for these signature changes, and because the package is private, it should be treated as subject to change across patch levels.