Search Results qp_util_pub




Overview
Explore in AI Chat

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.

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.