Search Results qp_default_qualifier_rules




Overview
Explore in AI Chat

Overview

QP_DEFAULT_QUALIFIER_RULES is an APPS-owned PL/SQL package within the Oracle Advanced Pricing (QP) module of Oracle E-Business Suite. It participates in the qualifier and qualifier rule framework that governs how pricing modifiers are selectively applied during pricing engine execution. Qualifier rules determine which modifiers — discounts, surcharges, promotions, or price adjustments — qualify for a given transaction context based on attributes such as customer, customer class, order type, item, or pricing attribute values. The package's specific responsibility is the establishment or resolution of default qualifier rule behavior, providing the logic that supplies default values or default rule selections when a pricing request does not explicitly define its own qualifiers.

The object is documented as VALID in the ETRM repository for both Oracle EBS 12.1.1 and 12.2.2 and is classified with an API classification of OTHER. Its position in the dependency hierarchy places it beneath the public qualifier rules API and the private qualifier rules package, indicating that it operates as a supporting or back-end utility rather than a primary public entry point.

Key Procedures and Functions

The ETRM metadata documents a single named program unit within this package: ATTRIBUTES. Based on the naming and the package's role in the qualifier framework, ATTRIBUTES is intended to supply or resolve the attribute-level information associated with default qualifier rules — that is, the set of pricing context attributes against which a qualifier rule is evaluated or from which default qualifier selections are derived. Because the documented metadata does not expose a parameter list for this program unit, no signature is reproduced here. Its purpose should be understood as supporting attribute handling for qualifier rule defaults within the Advanced Pricing engine.

Tables Accessed

Two data sources are documented for this package via APPS synonyms:

  • QP_QUALIFIER_RULES_S — The base qualifier rules table in Advanced Pricing. Records in this table define the rule groupings that link qualifier groups to modifier lists and determine when modifiers become eligible. The package consults this table to resolve default qualifier rule definitions and their associated attribute criteria.
  • DUAL — Used for single-row evaluation and scalar expression computation, typical of PL/SQL utility logic that does not require a persistent table read.

Usage Notes

QP_DEFAULT_QUALIFIER_RULES is not intended for direct invocation by end users. It is referenced by two other APPS packages — QP_DEFAULT_QUALIFIER_RULES itself as a recursive/self reference in the ETRM listing, and QP_QUALIFIER_RULES_PVT — and it in turn references the public API QP_QUALIFIER_RULES_PUB together with FND_API, Oracle's standard API error-handling framework. This layering indicates that the package is called internally during qualifier resolution and setup, most commonly when the pricing engine or the qualifier rules setup forms require a default qualifier rule to be materialized, validated, or retrieved.

Typical invocation paths include the Advanced Pricing qualifier setup user interface and the pricing engine's modifier selection process, where default qualifiers may be applied when transaction data lacks explicit qualifier context. Developers extending Advanced Pricing functionality should treat this package as an internal component, modifying it only through supported public APIs such as QP_QUALIFIER_RULES_PUB, and should not depend on its internal behavior across patches or upgrades.