Search Results update_qualification_ind

Overview

QP_UPDATE_UTIL is a utility package owned by the APPS schema within Oracle E-Business Suite, classified under the Advanced Pricing (QP) module. Its documented object type is PACKAGE, and its API classification is UTIL, indicating that it provides supporting, low-level operations rather than a public business API for external integration. The package is reported as VALID in the ETRM metadata for releases 12.1.1 and 12.2.2.

The package addresses maintenance and data-manipulation tasks across the pricing entity model. Its three documented procedures — UPDATE_QUALIFICATION_IND, UPDATE_PRICING_ATTRIBUTES, and CREATE_PARALLEL_SLABS — indicate that the utility is concerned with (a) propagating qualifier existence indicators onto pricing entities, (b) refreshing or regenerating pricing attribute records, and (c) generating parallel slab structures used by price list lines. These are structural upkeep operations that support the pricing engine and price list maintenance flows rather than end-user pricing calculations.

Dependency metadata shows the package references only SYS.STANDARD as an external dependency, meaning all table access is performed through APPS synonyms, consistent with the ETRM convention for EBS PL/SQL objects.

Key Procedures and Functions

• UPDATE_QUALIFICATION_IND — Maintains the qualification indicator on pricing records. Because qualifiers in Advanced Pricing can be attached at multiple levels (list header, list line, modifier), the indicator must be kept synchronized whenever qualifiers are added, removed, or re-linked. This procedure performs that synchronization.
• UPDATE_PRICING_ATTRIBUTES — Refreshes or re-derives pricing attribute rows for pricing entities. Pricing attributes define the context (item, customer, order type, and similar) against which qualifiers are evaluated; this procedure ensures the attribute records reflect the current definition of their parent entity.
• CREATE_PARALLEL_SLABS — Creates parallel slab records. Slabs support cumulative, tiered, or graduated pricing within a price list line, and parallel slabs represent multiple slab structures applied concurrently. This procedure generates those slab rows programmatically.

The ETRM metadata documents no parameter lists, and none are asserted here. No functions are documented; the object exposes three procedures.

Tables Accessed

The documented tables accessed via APPS synonyms are consistent with the package's purpose:

• QP_LIST_HEADERS_B — base table for price list headers; the parent entity whose qualification indicator and attributes are maintained.
• QP_LIST_LINES — price list lines, the level at which slabs and pricing attributes are predominantly defined.
• QP_PRICING_ATTRIBUTES — pricing attribute definitions and values; the primary target of UPDATE_PRICING_ATTRIBUTES.
• QP_QUALIFIERS — qualifier definitions; source data for evaluating and setting qualification indicators.
• QP_RLTD_MODIFIERS — relationships between modifiers; these influence qualifier linkage and therefore qualification indicators.
• QP_UPG_LINES_DISTRIBUTION — distribution records associated with upgraded pricing lines, used during upgrade or conversion processing.
• PLITBLM — a QP pricing engine table used in qualifier and attribute evaluation.

Usage Notes

QP_UPDATE_UTIL is classified as a UTIL API and is referenced by zero other packages in the ETRM dependency graph, so it is not a shared library in the normal call chain. It is therefore typically invoked indirectly, from Oracle Advanced Pricing forms or from concurrent programs that perform bulk price list maintenance, upgrade, or data migration. Custom code that must refresh pricing attributes or generate slab structures on a mass basis may call these procedures directly, but such use should be treated as an internal dependency: signatures are not documented in ETRM and are not part of the supported public interface.

Because the procedures modify core pricing tables, invocations should be followed by the standard Advanced Pricing regeneration or concurrent program that rebuilds the pricing engine cache, ensuring the changes are visible to pricing and order capture. Direct SQL updates against these tables should not be substituted for the package's procedures.