Search Results round_price

Overview

QP_UTIL_PUB is a public utility package in the Oracle Advanced Pricing (QP) module of Oracle E-Business Suite, delivered in the APPS schema and validated for both 12.1.1 and 12.2.2. Its primary business function is to provide shared helper routines that support the broader pricing engine, price list maintenance, modifier evaluation, and limit processing. The package exposes a miscellaneous set of static utilities that other pricing and order capture components call at runtime, avoiding duplication of logic for currency handling, price rounding, price list and agreement lookups, and debug/reprice operations. Because it is classified as a PUB package, QP_UTIL_PUB constitutes a supported public interface that customer extensions and integrations may invoke directly, unlike private (_PVT) implementation packages.

Key Procedures and Functions

The package exposes 25 documented procedures and functions, including both the public and private (PVT) variants.

• TO — a general-purpose conversion helper used across pricing utilities.
• REVERSE_LIMITS — reverses limit balances and limit transactions, typically invoked when an order or transaction is cancelled or returned.
• GET_ORDER_LINES_STATUS and GET_MANUAL_ALL_LINES_STATUS — retrieve pricing status information for order lines.
• VALIDATE_PRICE_LIST_CURR_CODE — validates the currency code associated with a price list.
• GET_PRICE_LIST, GET_PRICE_LISTS, GET_PRICE_LIST_CURRENCY — retrieve price list definitions and their associated currency.
• GET_AGREEMENT — fetches agreement details for pricing context resolution.
• GET_CURRENCY — returns currency information used in price calculations.
• ROUND_PRICE and GET_ROUNDING_FACTOR — apply price rounding rules and return the applicable rounding factor.
• BASIC_PRICING_SETUP — performs base setup validation or initialization for pricing.
• REPRICE_DEBUG_ENGINE_REQUEST, QP_COPY_DEBUG_PVT, and QP_DEBUG_REQ* routines — support the Pricing Debugger by preparing and re-executing debug requests.
• JAVA_ENGINE_INSTALLED — determines whether the Java pricing engine is available in the instance.
• HVOP_PRICING_SETUP, HVOP_PRICING_ON, RESET_HVOP_PRICING_ON — manage High Volume Order Processing (HVOP) pricing mode.
• GET_ATTRIBUTE_TEXT and GET_BLANKET_PRICELIST_MODIFIER — resolve attribute text and blanket price list modifier details.

Tables Accessed

QP_UTIL_PUB references pricing and order management tables through APPS synonyms. Customer and party data is read from HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_RELATE, and HZ_PARTIES to resolve pricing and agreement context. Price lists and modifiers are sourced from QP_LIST_HEADERS_B/_VL, QP_LIST_LINES, QP_PRICING_ATTRIBUTES, QP_ATTRIBUTE_SOURCING, and QP_CURRENCY_DETAILS. Debugger activity is recorded in QP_DEBUG_REQ, QP_DEBUG_REQ_LDETS, QP_DEBUG_REQ_LINES, QP_DEBUG_REQ_LINE_ATTRS, and QP_DEBUG_REQ_RLTD_LINES. Limit processing uses QP_LIMIT_BALANCES, QP_LIMIT_TRANSACTIONS, and QP_LIMITS. Order and agreement references include OE_AGREEMENTS, OE_AGREEMENTS_LOV_V, OE_TRANSACTION_TYPES_ALL, OE_SYS_PARAMETERS, QP_EVENT_PHASES, QP_PRICING_PHASES, and QP_INT_LINES.

Usage Notes

QP_UTIL_PUB is not referenced by any database object, confirming that it is a leaf-level utility package invoked from PL/SQL rather than through triggers or views. It is referenced by 32 other packages and depends on FND_API, FND_FLEX_APIS, FND_MESSAGE, FND_MSG_PUB, FND_GLOBAL, FND_PROFILE, OE_MSG_PUB, OE_DEBUG_PUB, and sibling QP packages such as QP_UTIL, QP_PREQ_PUB, QP_PRICE_LIST_PUB, and QP_MODIFIERS_PUB. It is typically invoked from order capture forms, the pricing engine, concurrent programs performing reprice or debug reruns, and custom PL/SQL extensions that require standardized rounding, currency lookup, price list retrieval, or limit reversal. Because procedures that manipulate limits and debug requests write to base tables, callers should invoke them within the appropriate transaction and commit scope, and should use the publisher interface rather than the private helpers.