Search Results price_request

Overview

APPS.PV_PRICE_PVT is a private PL/SQL API package within the Oracle EBS Partner Management (Channel Revenue Management / Price Protection) module. The "PV" prefix denotes the Partner Management application family, and the "_PVT" suffix classifies the package as a private API — meaning it is intended for internal consumption by other Oracle EBS components rather than as a published interface for customer extensions. The package is authored with AUTHID CURRENT_USER, so all SQL statements execute under the privileges of the calling session, relying on APPS synonyms for object resolution.

The package fulfills a single business function: the retrieval of pricing information for a given partner account, party, or contact within the context of a partner program enrollment request. This supports downstream pricing logic used in partner-facing transactions such as channel rebates, price protection claims, and distributor pricing validation.

Key Procedures and Functions

The ETRM metadata documents one public procedure on this package:

• PRICE_REQUEST — The sole documented entry point. It accepts an API version number, standard FND_API message-list and commit-control parameters, identifiers for the partner account, partner party, and contact party, a transaction currency, and a JTF_NUMBER_TABLE of enrollment request IDs. It returns the standard FND_API output trio (x_return_status, x_msg_count, x_msg_data). The procedure is responsible for resolving pricing for the specified partner/currency/enrollment context and returning results through the API message buffer. The exact return payload is not exposed in the public signature, indicating internal use through FND_API conventions.

No other procedures or functions are documented in the 12.2.2 ETRM metadata for this package. The header source (120.1, dated 2005) confirms the package has remained stable across releases.

Tables Accessed

The package references the following tables through APPS synonyms:

• HZ_PARTY_SITES and HZ_PARTY_SITE_USES — Retrieve party site records and their usage classifications for the partner or contact, supporting location-based pricing determinations.
• MTL_SYSTEM_ITEMS_B — Provides item master information for products subject to the price request.
• PV_PARTNER_PROGRAM_B — Identifies the partner program under which pricing rules apply.
• PV_PG_ENRL_REQUESTS — The enrollment request records passed via the JTF_NUMBER_TABLE parameter; these drive which pricing tiers and program rules govern the response.
• DUAL and PLITBLM — Utility references for single-row selects and PL/SQL table (index-by table) handling of the enrollment ID collection.

Usage Notes

Because PV_PRICE_PVT is marked as a private API (classification "PVT") and is referenced by zero other packages in the ETRM catalog, it is not a general-purpose integration point. It is typically invoked indirectly: Oracle forms, concurrent programs, or internal Partner Management workflows call it to resolve pricing during partner program enrollment or claim processing. Customers and integrators should not call PRICE_REQUEST directly, as the API may change without notice and lacks the stability guarantees of a public API. For custom requirements involving partner pricing, Oracle recommends use of the corresponding public APIs or the Partner Management business flows rather than this private package. The FND_API standard parameters (p_init_msg_list, p_commit, x_return_status, x_msg_count, x_msg_data) mean the caller must check x_return_status against FND_API.G_RET_STS_SUCCESS and inspect the message list, as is standard for all EBS PL/SQL APIs.