Search Results create_list_line

Overview

APPS.QP_MODIFIER_UPGRADE_UTIL_PVT is a private (PVT) PL/SQL utility package body in the Oracle E-Business Suite Advanced Pricing module. Its name and dependent object list indicate that it exists to support the migration and conversion of pricing modifiers (price list headers, list lines, qualifiers, pricing attributes, and related modifier hierarchies) from legacy or pre-upgrade data structures into the normalized Oracle Pricing schema. This is an internal utility rather than a public API: it is classified as PVT, is not referenced by any other database object, and is invoked from upgrade and data-seeding logic that must recreate modifier definitions in the current schema shape.

The user search term "qp_rltd_modifiers_s" corresponds to QP_RLTD_MODIFIERS_S, one of the core tables this package writes. That table stores the "related modifiers" link structure that defines how modifiers attach to one another (for example, a promotion that qualifies against a price list modifier, or a modifier that inherits from another). The presence of this table, along with its group-number sequence shadows, confirms an upgrade/conversion focus: the package rebuilds relationship rows that cannot simply be copied across a structural change.

Key Procedures and Functions

• CREATE_LIST_HEADER — Creates a price list header record, establishing the parent modifier container.
• CREATE_LIST_LINE — Creates an individual price list line under an existing header.
• CREATE_QUALIFIER — Builds qualifier rows that determine when a modifier applies.
• CREATE_PRICING_ATTRIBUTE — Creates pricing attribute definitions associated with a modifier.
• CREATE_PRICING_ATTRIBUTE_BREAK — Creates the attribute "break" records that define ranges or value groupings used in pricing attribute evaluation.
• CREATE_RELATED_MODIFIER — Creates related modifier linkage rows in QP_RLTD_MODIFIERS, which is the primary target of the "qp_rltd_modifiers_s" search term.
• INSERT_LINE_DISTRIBUTION — Inserts line distribution records into QP_UPG_LINES_DISTRIBUTION, supporting the upgrade staging of modifier line accounting/distribution data.

Tables Accessed

The package references the following tables (via APPS synonyms):

• QP_LIST_HEADERS_B, QP_LIST_HEADERS_B_S, QP_LIST_HEADERS_TL — Base table, its sequence shadow, and translation table for price list/qualifier headers.
• QP_LIST_LINES, QP_LIST_LINES_S, SO_PRICE_LIST_LINES_S, SO_PRICE_LISTS_S — Modifier line storage, including legacy SO-prefixed price list structures.
• QP_QUALIFIERS, QP_QUALIFIERS_S, QP_QUALIFIER_GROUP_NO_S — Qualifier definitions and their group-number sequence support.
• QP_PRICING_ATTRIBUTES, QP_PRICING_ATTRIBUTES_S — Pricing attribute definitions used in modifier evaluation.
• QP_RLTD_MODIFIERS, QP_RLTD_MODIFIERS_S, QP_RLTD_MODIFIER_GRP_NO_S — Related modifier linkages, the object of the "qp_rltd_modifiers_s" search.
• QP_UPG_LINES_DISTRIBUTION — Upgrade staging table for modifier line distributions.
• FND_LANGUAGES — Used to drive translation (TL) row creation across installed languages.

Usage Notes

QP_MODIFIER_UPGRADE_UTIL_PVT is invoked during upgrade and conversion processes that repopulate modifier data. It is not a public API and should not be called from custom code directly; developers requiring modifier creation should use supported public APIs such as QP_Modifier_Util or QP_Pricing_Attributes_PUB. The package is referenced by six other packages, reflecting its role as a shared internal utility within the upgrade toolset. Because it writes to base (_B), sequence shadow (_S), and translation (_TL) tables consistently, all three must remain in sync; any manual intervention risks orphaned rows and sequence gaps. It is classified VALID and writes across the full modifier object graph, so it is primarily relevant when troubleshooting ETRM migration or conversion discrepancies involving related modifiers, qualifiers, and pricing attributes.