Search Results qp_qualifiers_s




Overview
Explore in AI Chat

Overview

QP_LIST_UPGRADE_UTIL_PVT is a private utility package body in the APPS schema that supports the upgrade and migration of Oracle Advanced Pricing list and modifier data within Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its principal business purpose is to convert legacy pricing constructs — older discount, surcharge, and price list definitions, along with their associated qualifiers, pricing attributes, and flex structures — into the current list architecture used by Oracle Advanced Pricing. The package operates as an internal helper called by the public upgrade entry points (notably QP_MODIFIER_UPGRADE_UTIL_PVT and related upgrade drivers) rather than as a directly invoked end-user API. Because the object is classified PVT, it is not intended for customer extension or direct invocation and receives no external callers; the ETRM metadata confirms it is referenced by zero database objects.

Key Procedures and Functions

The package body exposes five documented procedures that collectively orchestrate the conversion effort:

  • UPGRADE_FLEX_STRUCTURES — Rebuilds and aligns descriptive flexfield and pricing attribute structures required by upgraded list and qualifier records so that attribute context and segment definitions match the target release.
  • CREATE_PARALLEL_LINES — Creates list line records in a parallel-enabled manner, allowing large volumes of pricing lines to be migrated concurrently for performance.
  • CREATE_PARALLEL_SLABS — Generates slab (tiered or graduated) pricing definitions in parallel, supporting tiered price list and modifier line structures.
  • CREATE_PRICE_LIST — Builds the header-level price list record, establishing the container into which migrated lines and qualifiers are populated.
  • CREATE_LIST_LINES — Populates the detail line records beneath a created list, writing the migrated pricing and modifier line data.

Tables Accessed

All tables are referenced through APPS synonyms. Core Advanced Pricing tables include QP_LIST_HEADERS_B and QP_LIST_HEADERS_TL (list header and translated header data), QP_LIST_LINES (list detail lines), QP_QUALIFIERS and QP_QUALIFIERS_S (qualifier definitions and their primary-key sequence, directly relevant to the searched object qp_qualifiers_s), QP_PRICING_ATTRIBUTES and QP_PRICING_ATTRIBUTES_S (pricing attribute definitions and sequence), QP_DISCOUNT_MAPPING (mapping between legacy discount structures and current modifiers), and QP_UPG_LINES_DISTRIBUTION (tracking distribution of upgraded lines). Legacy Order Management sources SO_PRICE_LISTS_B, SO_PRICE_LISTS_TL, and SO_PRICE_LIST_LINES_115 provide the pre-upgrade price list data. FND_LANGUAGES supplies language context for translated records, DUAL supports procedural select statements, and PLITBLM is the standard PL/SQL index-by table of VARCHAR2 used for bulk collections.

Usage Notes

QP_LIST_UPGRADE_UTIL_PVT is invoked indirectly during Advanced Pricing upgrade and migration routines, typically from concurrent programs and upgrade driver scripts that run when moving from earlier pricing models to the current list/modifier architecture. It is not exposed through an application form and should not be called from custom code, since it is a private (PVT) implementation whose signatures and behavior may change between patches. Its heavy reliance on parallel line and slab creation indicates it is designed for bulk processing of large list volumes. Because it is referenced by no other database object and depends on QP_UTIL, QP_MODIFIER_UPGRADE_UTIL_PVT, and STANDARD, it functions strictly as an internal layer within the pricing upgrade stack. The reference to QP_QUALIFIERS_S confirms that qualifier sequence generation is central to the qualifier upgrade path.