Results for “qp_currency_pvt”

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

Overview

QP_CURRENCY_PVT is a private PL/SQL package in the Oracle E-Business Suite Advanced Pricing (QP) module. It is owned by the APPS schema and classified as a PVT (private) API, meaning it is intended for internal consumption by other Oracle Pricing packages rather than direct invocation by external or customer-written code. The package encapsulates the low-level processing logic used to validate, lock, and retrieve currency-related data referenced by Oracle Pricing entities such as price lists, modifiers, and qualifiers. Because pricing agreements in EBS are frequently expressed in multiple currencies, this package provides the shared currency-handling foundation that the public QP_Currency_PUB API and related pricing components rely upon.

Key Procedures and Functions

The ETRM metadata documents three procedures within QP_CURRENCY_PVT:

• PROCESS_CURRENCY — The primary worker routine. It accepts control and API-context arguments (including API version, initialization flag, commit flag, and validation level) along with currency list and currency detail record structures, plus their "old" counterparts. It processes a currency list header and its associated detail lines, performing the insert, update, or delete operations required to persist the desired currency configuration. Return status, message count, and message data are returned through standard FND_API OUT parameters, and the resulting records/tables are returned to the caller.
• LOCK_CURRENCY — A concurrency-control routine. It acquires a lock on the currency record being modified so that overlapping transactions cannot simultaneously alter the same currency definition. It follows the standard API signature pattern with version, initialization, and return-status parameters.
• GET_CURRENCY — A retrieval routine that reads currency definition data and returns it to the calling package, typically to support validation, display, or downstream processing within the pricing engine.

Tables Accessed

The documented table reference for this package is PLITBLM, a multi-currency transaction table used within the pricing and order-capture flow to store currency-related amounts by transaction line. Access through an APPS synonym indicates the package operates on the shared currency data structures used to convert and store pricing information in transaction currency. This aligns with the package's role: it maintains the currency list and currency detail records that support multi-currency pricing calculations.

Usage Notes

QP_CURRENCY_PVT is invoked by other PL/SQL packages rather than directly from forms or concurrent programs. The ETRM metadata notes that it is referenced by three other packages, which are its principal callers. The public entry points for currency manipulation exposed to Oracle Pricing setup and transaction screens reside in QP_Currency_PUB; QP_Currency_PVT is called beneath that layer. Developers writing custom pricing extensions should generally call the public API and not this private package, since private signatures are subject to change between releases and are not part of the supported integration surface. The package is not directly related to the "virtual currency business activity license" search query; that phrase refers to a regulatory licensing regime in certain jurisdictions. In an EBS context, currency is strictly a monetary reference (ISO currency codes and conversion attributes), and there is no native support for cryptocurrency or virtual currency licensing within standard Pricing functionality. Any such requirement would necessarily be implemented through custom development layered on top of the supported pricing APIs rather than through QP_CURRENCY_PVT.