Results for “qp_qualifier_rules_s”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

QP_DEFAULT_QUALIFIER_RULES is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. Within the Oracle Advanced Pricing (QP) module, it supports the defaulting and resolution of qualifier rules that determine which modifiers, price lists, and adjustments apply to a given transaction line. Qualifiers act as the conditional filters—such as customer, customer class, order type, item, or shipping destination—that restrict a pricing modifier to specific business contexts.

The package is classified under the ETRM as an OTHER API type rather than a public or private API, reflecting its role as an internal helper package. It is not referenced by any other database object, indicating that it is invoked directly by Oracle Advanced Pricing's own internal processing rather than being exposed as a callable interface for external consumers. The package status is VALID, confirming that it compiles cleanly against its declared dependencies in the 12.1.1 and 12.2.2 releases.

The documented dependency list shows reliance on core EBS infrastructure and pricing components, including FND_API, FND_MESSAGE, OE_DEBUG_PUB, OE_MSG_PUB, QP_GLOBALS, QP_QUALIFIER_RULES_PUB, QP_QUALIFIER_RULES_UTIL, and QP_VALIDATE. These dependencies indicate that the package uses the standard FND API error-handling conventions, Order Management message and debug utilities, and the shared qualifier rule utilities and validation logic that form part of the pricing engine.

Key Procedures and Functions

The documented metadata identifies a single procedure or function within the package: ATTRIBUTES. Consistent with the ETRM record, the definitive purpose of this routine centers on the processing of qualifier rule attributes—resolving the attribute values that drive qualifier matching for default and seeded qualifier rules used by the pricing engine.

Because the ETRM excerpt does not publish a parameter list for ATTRIBUTES, no parameter signature is asserted here. The routine is understood to operate in conjunction with the qualifier rules utility package and the public qualifier rules API to supply attribute-level information needed when identifying applicable qualifiers. Where the package logic requires validation of qualifier data or message handling, it delegates to QP_VALIDATE and FND_MESSAGE respectively, in line with the dependencies documented above.

Tables Accessed

The ETRM metadata records two tables referenced through APPS synonyms: QP_QUALIFIER_RULES_S and DUAL.

• QP_QUALIFIER_RULES_S — the primary qualifier rules table in Oracle Advanced Pricing. This is the base table for storing qualifier rule definitions, including seeded and user-defined qualifier conditions. The package reads from this table to retrieve qualifier rule records for attribute defaulting and resolution. The "_S" suffix denotes that this object participates in the Oracle EBS multi-language schema pattern, with a corresponding "_TL" table holding translated columns.
• DUAL — the standard SYS-owned single-row utility table, used for simple value selection and PL/SQL expression evaluation in the package body.

No additional tables are documented in the ETRM record, suggesting that the package's direct persistence operations are focused on the qualifier rules table and that broader rule processing is handled by the dependent utility and public API packages.

Usage Notes

QP_DEFAULT_QUALIFIER_RULES is an internal Oracle Advanced Pricing package and is not referenced by any other database object. It is therefore not intended as an extension point or public API for customer customization. Invocation occurs within the standard pricing engine flow, typically during qualifier resolution when the application must establish which qualifier rules apply to a pricing request.

Custom development should avoid calling this package directly. Developers working with qualifier rules should instead use the documented public interfaces, principally QP_QUALIFIER_RULES_PUB, which provides the supported entry points for creating, updating, and resolving qualifier rules. Direct invocation of QP_DEFAULT_QUALIFIER_RULES bypasses the dependency contracts orchestrated by the public API and risks breaking on patch application or upgrade between 12.1.1 and 12.2.2.

For diagnostics, the package's reliance on OE_DEBUG_PUB and OE_MSG_PUB means that debugging output and error messages can be surfaced through the standard Order Management debug and message frameworks. Support analysis of qualifier defaulting issues should begin with QP_QUALIFIER_RULES_S data validation, followed by tracing through the public qualifier rules API to determine whether this internal defaulting package is reached during the failing transaction.