Search Results qp_list_lines_s

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.

SEQUENCE: QP.QP_LIST_LINES_S 12.2.2
owner:QP, object_type:SEQUENCE, object_name:QP_LIST_LINES_S, status:VALID,
SEQUENCE: QP.QP_LIST_LINES_S 12.1.1
owner:QP, object_type:SEQUENCE, object_name:QP_LIST_LINES_S, status:VALID,
SYNONYM: APPS.QP_LIST_LINES_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:QP_LIST_LINES_S, status:VALID,
SYNONYM: APPS.QP_LIST_LINES_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:QP_LIST_LINES_S, status:VALID,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.QP_MODIFIER_UPGRADE_UTIL_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QP_MODIFIER_UPGRADE_UTIL_PVT, status:VALID,
PACKAGE BODY: APPS.OE_DEFAULT_PRICE_LIST_LINE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_DEFAULT_PRICE_LIST_LINE, status:VALID,
PACKAGE BODY: APPS.QP_QP_FORM_PLL_PRICING_ATTR 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QP_QP_FORM_PLL_PRICING_ATTR, status:VALID,
PACKAGE BODY: APPS.QP_MODIFIER_UPGRADE_UTIL_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QP_MODIFIER_UPGRADE_UTIL_PVT, status:VALID,
PACKAGE BODY: APPS.QP_QP_FORM_MODIFIERS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QP_QP_FORM_MODIFIERS, status:VALID,
PACKAGE BODY: APPS.QP_QP_FORM_MODIFIERS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QP_QP_FORM_MODIFIERS, status:VALID,
PACKAGE BODY: APPS.QP_DEFAULT_PRICE_LIST_LINE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QP_DEFAULT_PRICE_LIST_LINE, status:VALID,
PACKAGE BODY: APPS.OE_OE_FORM_PRICE_LLINE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_OE_FORM_PRICE_LLINE, status:VALID,
PACKAGE BODY: APPS.QP_DEFAULT_PRICE_LIST_LINE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QP_DEFAULT_PRICE_LIST_LINE, status:VALID,
PACKAGE BODY: APPS.OE_OE_FORM_PRICE_BREAK 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_OE_FORM_PRICE_BREAK, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.QP_PRICE_FORMULA_UPG_UTIL_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QP_PRICE_FORMULA_UPG_UTIL_PVT, status:VALID,
PACKAGE BODY: APPS.OE_OE_FORM_PRICE_LLINE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_OE_FORM_PRICE_LLINE, status:VALID,
PACKAGE BODY: APPS.OE_OE_FORM_PRICE_BREAK 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_OE_FORM_PRICE_BREAK, status:VALID,
PACKAGE BODY: APPS.QP_DEFAULT_MODIFIERS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QP_DEFAULT_MODIFIERS, status:VALID,
PACKAGE BODY: APPS.OE_DEFAULT_PRICE_LIST_LINE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_DEFAULT_PRICE_LIST_LINE, status:VALID,
PACKAGE BODY: APPS.QP_COPY_MODIFIERS_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QP_COPY_MODIFIERS_PVT, status:VALID,
PACKAGE BODY: APPS.QP_QP_FORM_PLL_PRICING_ATTR 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QP_QP_FORM_PLL_PRICING_ATTR, status:VALID,
PACKAGE BODY: APPS.QP_DEFAULT_MODIFIERS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QP_DEFAULT_MODIFIERS, status:VALID,
PACKAGE BODY: APPS.QP_PRICE_FORMULA_UPG_UTIL_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QP_PRICE_FORMULA_UPG_UTIL_PVT, status:VALID,
PACKAGE BODY: APPS.QP_ADD_ITEM_PRCLIST_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QP_ADD_ITEM_PRCLIST_PVT, status:VALID,
PACKAGE BODY: APPS.QP_ADD_ITEM_PRCLIST_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QP_ADD_ITEM_PRCLIST_PVT, status:VALID,
PACKAGE BODY: APPS.OZF_PRICELIST_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OZF_PRICELIST_PVT, status:VALID,
PACKAGE BODY: APPS.QP_COPY_MODIFIERS_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QP_COPY_MODIFIERS_PVT, status:VALID,
PACKAGE BODY: APPS.OZF_PRICELIST_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OZF_PRICELIST_PVT, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.QP_COPY_PRICELIST_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QP_COPY_PRICELIST_PVT, status:VALID,
PACKAGE BODY: APPS.QP_BULK_VALIDATE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QP_BULK_VALIDATE, status:VALID,
PACKAGE BODY: APPS.QP_BULK_VALIDATE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QP_BULK_VALIDATE, status:VALID,
PACKAGE BODY: APPS.QP_COPY_PRICELIST_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QP_COPY_PRICELIST_PVT, status:VALID,
PACKAGE BODY: APPS.OE_BLANKET_UTIL 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_BLANKET_UTIL, status:VALID,
12.2.2 DBA Data 12.2.2
APPS.OE_DEFAULT_PRICE_LIST_LINE dependencies on QP_LIST_LINES_S 12.1.1
APPS.QP_PRICE_FORMULA_UPG_UTIL_PVT dependencies on QP_LIST_LINES_S 12.1.1
APPS.QP_COPY_MODIFIERS_PVT dependencies on QP_LIST_LINES_S 12.2.2
APPS.QP_BULK_VALIDATE dependencies on QP_LIST_LINES_S 12.1.1
APPS.QP_COPY_PRICELIST_PVT dependencies on QP_LIST_LINES_S 12.1.1
APPS.OE_OE_FORM_PRICE_LLINE dependencies on QP_LIST_LINES_S 12.2.2
APPS.QP_COPY_PRICELIST_PVT dependencies on QP_LIST_LINES_S 12.2.2
APPS.OZF_PRICELIST_PVT dependencies on QP_LIST_LINES_S 12.2.2
APPS.QP_MODIFIER_UPGRADE_UTIL_PVT dependencies on QP_LIST_LINES_S 12.1.1
APPS.QP_QP_FORM_MODIFIERS dependencies on QP_LIST_LINES_S 12.1.1
APPS.QP_DEFAULT_PRICE_LIST_LINE dependencies on QP_LIST_LINES_S 12.2.2