Search Results qp_modifier_upgrade_util_pvt




Overview
Explore in AI Chat

Overview

QP_MODIFIER_UPGRADE_UTIL_PVT is a private (PVT) PL/SQL utility package in the APPS schema of Oracle E-Business Suite, residing within the Oracle Advanced Pricing (QP) module. Its principal business function is to support the data migration and upgrade of pricing modifier definitions — price lists, discount lists, surcharge lists, and related modifier constructs — from legacy or earlier EBS releases into the current 12.1.1 and 12.2.2 data model. Modifiers in Oracle Advanced Pricing are stored as list headers and list lines, and historically required normalization across qualification, pricing attribute, and related-modifier child entities. This package encapsulates the low-level insert logic required to construct those normalized records correctly, ensuring that dependent rows (qualifiers, pricing attributes, breaks, related modifiers, and line distributions) are created alongside their parent list definitions. Because it is a PVT package, it is not intended as a public API; it serves as a shared internal utility invoked by higher-level upgrade drivers such as QP_MODIFIER_UPGRADE_PVT and QP_UPDATE_UTIL. Its status is VALID, confirming it is compiled and operational in the documented environment.

Key Procedures and Functions

The ETRM metadata documents seven procedures, all oriented toward record creation during upgrade processing:

  • CREATE_LIST_HEADER — Creates the parent modifier/list header record, establishing the top-level price list or modifier identity.
  • CREATE_LIST_LINE — Creates an individual list line belonging to a list header, representing the priced or adjusted item/line entry.
  • CREATE_QUALIFIER — Creates qualification records that define the conditions under which a modifier applies.
  • CREATE_PRICING_ATTRIBUTE — Creates pricing attribute records that capture the attribute values used in pricing and modifier evaluation.
  • CREATE_PRICING_ATTRIBUTE_BREAK — Creates pricing attribute break records supporting tiered or break-based pricing structures.
  • CREATE_RELATED_MODIFIER — Creates relationships between modifiers, allowing one modifier to reference or depend on another.
  • INSERT_LINE_DISTRIBUTION — Inserts line distribution records, which allocate modifier amounts across accounting or organizational dimensions.

No parameter signatures are documented in the available metadata; the procedures function as discrete record-construction steps in the broader upgrade sequence.

Tables Accessed

The package reads and writes the following tables via APPS synonyms. Header data is written to QP_LIST_HEADERS_B, QP_LIST_HEADERS_B_S, and QP_LIST_HEADERS_TL. List line and distribution data are written to QP_LIST_LINES, QP_LIST_LINES_S, and QP_UPG_LINES_DISTRIBUTION. Qualification data is written to QP_QUALIFIERS, QP_QUALIFIERS_S, and QP_QUALIFIER_GROUP_NO_S. Pricing attribute data is written to QP_PRICING_ATTRIBUTES and QP_PRICING_ATTRIBUTES_S. Related modifier data is written to QP_RLTD_MODIFIERS, QP_RLTD_MODIFIERS_S, and QP_RLTD_MODIFIER_GRP_NO_S. FND_LANGUAGES is referenced to support multilingual (TL) header descriptions. The _B, _S, and _TL suffix conventions reflect EBS standards for base, sequence/intersection, and translation tables, and the package respects those patterns when populating records.

Usage Notes

This package is invoked indirectly during Advanced Pricing upgrades rather than called directly from forms or concurrent programs. The ETRM metadata identifies six referencing packages, including QP_AGRUPGRADE, QP_LIST_UPGRADE_UTIL_PVT, QP_MODIFIER_UPGRADE_PVT, QP_PRICE_FORMULA_UPG_UTIL_PVT, QP_QUALIFICATION_IND_UPG_UTIL, and QP_UPDATE_UTIL. These are the upgrade drivers orchestrating the migration of pricing entities. Custom code should not reference QP_MODIFIER_UPGRADE_UTIL_PVT directly, as private packages are subject to change without public API guarantees. Administrators reviewing upgrade logs or troubleshooting modifier migration failures should trace through the calling packages to locate invocation context.