Search Results basic_pricing_setup

Overview

QP_UTIL_PUB is the public utility package within the Oracle Advanced Pricing (QP) module of Oracle E-Business Suite. It provides a shared library of low-level pricing services that other pricing, order management, and custom components call to resolve pricing context, validate price lists and currencies, apply rounding, drive the pricing engine, and manage limit balances related to complex pricing agreements. In release 12.1.1 and 12.2.2 the package is owned by APPS and classified as a public (PUB) API, meaning its procedures form a supported interface for external invocation. The package is referenced by 32 other packages, which reflects its role as a foundational dependency across the pricing and order capture stack rather than an end-user facing program.

Although the object title is QP_UTIL_PUB, the package header declares the internal name G_PKG_NAME as 'QP_LIMITS_UTIL_PUB', and the documented body originates from the QPXRTCNS.pls script. The package combines pricing setup queries with limit reversal logic, so it is consulted both during routine price calculation and during return or cancellation processing.

Key Procedures and Functions

The documented interface exposes 25 procedures and functions. Central to basic pricing setup is BASIC_PRICING_SETUP, which initializes the global pricing context that other routines depend upon. That context is held in package globals such as G_MULTI_CURRENCY, G_MULTI_CURRENCY_USAGE, G_ROUNDING_OPTIONS, G_OE_UNIT_PRICE_ROUNDING, G_PRICE_LIST_ID, G_CURRENCY_CODE, G_PRICING_EFF_DATE, and G_ROUNDING_FACTOR.

• REVERSE_LIMITS — Reverses limit balances and transactions when a return or cancellation is processed. It operates on the qp_preq_lines_tbl_type and qp_preq_ldets_tbl_type collections built from the temporary structures QP_NPREQ_LINES_TMP and QP_NPREQ_LDETS_TMP, and returns a status and message to the caller.
• GET_ORDER_LINES_STATUS and GET_MANUAL_ALL_LINES_STATUS — Return line-level status flags (all lines, summary line, changed lines) for a given event code, supporting the pricing engine and returns processing. The request type code parameter allows filtering by PTE/SS request types.
• VALIDATE_PRICE_LIST_CURR_CODE, GET_PRICE_LIST, GET_PRICE_LISTS, and GET_PRICE_LIST_CURRENCY — Validate and retrieve price list definitions and their associated currency codes.
• GET_CURRENCY and GET_ROUNDING_FACTOR — Resolve currency information and the rounding factor applicable to a pricing calculation.
• ROUND_PRICE — Applies the configured rounding option and factor to a computed price.
• GET_AGREEMENT — Retrieves agreement information used in pricing qualification.
• REPRICE_DEBUG_ENGINE_REQUEST — Submits or manages a debug engine request for pricing diagnostics.
• JAVA_ENGINE_INSTALLED — Indicates whether the Java pricing engine is available in the environment.
• HVOP_PRICING_SETUP, HVOP_PRICING_ON, and RESET_HVOP_PRICING_ON — Manage the High Volume Order Processing pricing setup and toggle its activation state.
• GET_ATTRIBUTE_TEXT — Returns descriptive text for a pricing attribute.
• GET_BLANKET_PRICELIST_MODIFIER — Retrieves modifier information associated with a blanket price list.

Tables Accessed

The package reads and writes a defined set of pricing and trading partner tables, accessed through APPS synonyms.

• QP_LIMITS and QP_LIMIT_BALANCES — Hold limit definitions and remaining balances that REVERSE_LIMITS restores during returns and cancellations.
• QP_CURRENCY_DETAILS — Source of currency and rounding configuration consumed by the currency and rounding routines.
• QP_EVENT_PHASES — Defines the pricing event phases used when evaluating order line status.
• QP_ATTRIBUTE_SOURCING — Maps pricing attributes to their sourcing, supporting attribute resolution and GET_ATTRIBUTE_TEXT.
• QP_DEBUG_REQ, QP_DEBUG_REQ_LDETS, QP_DEBUG_REQ_LINES, QP_DEBUG_REQ_LINE_ATTRS, QP_DEBUG_REQ_RLTD_LINES — Store debug engine request headers, lines, attributes, and related lines produced by REPRICE_DEBUG_ENGINE_REQUEST.
• OE_AGREEMENTS and OE_TRANSACTION_TYPES_ALL — Provide agreement data for GET_AGREEMENT and transaction type context for order processing.
• HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_RELATE, HZ_PARTIES — Supply customer party and account relationship data used in pricing qualification.

Usage Notes

QP_UTIL_PUB is typically invoked indirectly. Oracle Pricing and Order Management forms, concurrent programs, and the pricing engine call it during price list resolution, price rounding, and limit tracking. Custom extensions should call BASIC_PRICING_SETUP before relying on the package globals, since those globals persist for the duration of a session and are populated by the setup routine. REVERSE_LIMITS is appropriate within return, cancellation, and amendment flows where limit balances must be restored; it requires an initialized pricing context and valid temporary line collections. Because the package is classified PUB and is referenced by 32 other packages, modifications are governed by Oracle's API compatibility standards, and direct updates to the underlying QP_LIMITS and QP_LIMIT_BALANCES tables should be avoided in favour of the documented procedures.