Search Results qp_default_modifier_list




Overview
Explore in AI Chat

Overview

QP_DEFAULT_MODIFIER_LIST is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. The package resides within the Oracle Advanced Pricing (QP) module and is classified under the ETRM API classification of OTHER, indicating that it supports internal defaulting logic rather than serving as a published, customer-facing API. Its purpose is to resolve and return a default modifier list record for use in pricing engine processing, where a modifier list represents the container that holds pricing modifiers such as discounts, surcharges, and promotional offers. The package encapsulates the logic required to determine which modifier list should apply when the calling process has not supplied an explicit list, thereby centralizing default resolution behavior and shielding callers from the underlying query logic.

Key Procedures and Functions

The documented package interface contains a single procedure, Attributes. According to the ETRM metadata and the source header, this procedure accepts an input modifier list record, p_MODIFIER_LIST_rec, typed from QP_Modifiers_PUB.Modifier_List_Rec_Type, and an iteration counter, p_iteration. It returns an output record, x_MODIFIER_LIST_rec, of the same record type, passed by reference. The default input value for p_MODIFIER_LIST_rec is QP_Modifiers_PUB.G_MISS_MODIFIER_LIST_REC, which is the standard "missing record" sentinel used throughout Oracle Pricing APIs to signal that no prior list has been supplied. The presence of the iteration parameter indicates that the procedure supports iterative invocations, allowing the caller to step through candidate default modifier lists rather than resolving a single result in one pass. The procedure does not expose a separate documented function section; the entire package body is anchored by this one procedure.

Tables Accessed

ETRM documents references to two objects through APPS synonyms: QP_LIST_HEADERS_B_S and DUAL. QP_LIST_HEADERS_B_S is the base table (accessed via a synonym and its sequence) that stores list headers, the parent records for modifier lists and price lists in Advanced Pricing. The Attributes procedure reads from this table to identify candidate default modifier lists matching the invocation context. The reference to DUAL reflects internal helper logic used for constant evaluation and seeding of default values within the same procedure. No insert, update, or delete activity against these tables is documented, which is consistent with the package's role as a read-oriented defaulting utility rather than a maintenance API.

Usage Notes

QP_DEFAULT_MODIFIER_LIST is not intended for direct invocation by end users. It is referenced by one other package according to the ETRM dependency data, and the standard QP_Modifiers_PUB published API layer is the most likely consumer. Typical invocation scenarios include the pricing engine, order capture forms that require default modifier list resolution, and concurrent programs that build or validate pricing data. In custom development, the package should be treated as an internal artifact: developers integrating with Advanced Pricing should prefer the published QP_Modifiers_PUB interfaces, which internally may delegate to this package. Because the interface accepts and returns the full Modifier_List_Rec_Type and exposes an iteration counter, callers must respect the G_MISS_MODIFIER_LIST_REC convention and must be prepared to handle iterations that yield no qualifying list. The package is version-stable across 12.1.1 and 12.2.2, and no schema-level changes to this interface are documented between those releases.