Search Results qp_default_con




Overview
Explore in AI Chat

Overview

QP_DEFAULT_CON is a PL/SQL package body owned by the APPS schema that forms part of the Oracle Advanced Pricing (QP) foundation within Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to resolve and apply default values for pricing attributes and qualifier contexts during the pricing engine's processing cycle. In practice, when a pricing transaction or modifier is evaluated, the pricing engine must determine which attribute values to use for context matching and formula evaluation. QP_DEFAULT_CON provides the defaulting logic that fills in these values when the caller has not supplied them explicitly, ensuring that pricing rules and modifiers resolve against a consistent, fully populated set of attributes.

The package is classified as OTHER rather than as a public or private API, which indicates it is intended as internal pricing infrastructure rather than as a callable interface for external integrations. The ETRM documentation records a single documented procedure, ATTRIBUTES, and the package is referenced by one other package, confirming its role as a supporting utility within the pricing stack rather than a top-level entry point.

Key Procedures and Functions

The ETRM metadata documents one procedure: ATTRIBUTES. This procedure encapsulates the attribute-defaulting logic for the pricing context. When invoked, it evaluates the pricing attributes associated with the current transaction or modifier context and applies the appropriate default values, internally delegating work to QP_ATTRIBUTES_PUB for the core attribute handling routines and to QP_VALIDATE for value validation. Because the metadata does not publish parameter signatures, callers should treat the interface as internal and stable only within the shipped pricing code path. No other public procedures or functions are documented for this package in the 12.2.2 reference set.

Tables Accessed

The documented table references for QP_DEFAULT_CON are limited but meaningful:

  • QP_PRC_CONTEXTS_S — the pricing context definitions table. The package consults this table to determine which context attributes are relevant and to derive the default values that apply to the current pricing scenario.
  • DUAL — used for single-row SQL evaluations, typically for lightweight lookups or to obtain a scalar result without touching a physical table.

In addition to direct table access, the package depends on several APPS packages that carry the substantive business logic: QP_CON_UTIL for context utility operations, QP_ATTRIBUTES_PUB for attribute management, QP_VALIDATE for validation, and QP_GLOBALS for shared pricing constants and session state. Messaging is handled through FND_MESSAGE and OE_MSG_PUB, and error propagation follows the FND_API standard. These dependencies confirm that QP_DEFAULT_CON acts primarily as an orchestration layer over pricing context utilities.

Usage Notes

QP_DEFAULT_CON is not a user-invoked package. It is called internally by the Oracle Pricing engine and by the one package documented as referencing it during transaction pricing, modifier application, and context resolution. It is not referenced by any database object outside the pricing schema set, which reinforces that it should not be extended or called from customizations without careful regression testing. Because defaulting behavior influences which modifiers qualify for a transaction, changes to this package can alter pricing outcomes across Order Management, Advanced Pricing, and related modules. Custom code should interact with supported public APIs such as QP_ATTRIBUTES_PUB rather than with QP_DEFAULT_CON directly. The package should remain VALID in the APPS schema; invalidating it can disrupt pricing calculations until recompilation.