Search Results create_discounts

Overview

The APPS.QP_MODIFIER_UPGRADE_PVT package is an internal, private (PVT) PL/SQL package within the Oracle Advanced Pricing (QP) module of Oracle E-Business Suite. Its documented purpose is to support the migration and upgrade of legacy pricing and modifier data into the Oracle Advanced Pricing data model. In releases 12.1.1 and 12.2.2, organizations that upgrade from earlier Oracle Applications versions, or that convert discounts, price breaks, and qualifiers defined in the older SO_DISCOUNT and SO_PRICE_* tables, rely on this package to translate that legacy information into the modern QP_LIST_HEADERS, QP_LIST_LINES, and QP_QUALIFIERS structures.

The "PVT" suffix designates the package as private to the application programming interface; it is not intended as a public, supported extension point. It is consumed internally by upgrade routines rather than by customer-facing setup or transactional flows. The package is owned by the APPS schema and is reported as VALID in both release levels, indicating that its compiled body is consistent and available. The ETRM metadata records no reverse dependencies from other packages, confirming that it operates at the lower layers of the pricing upgrade stack rather than being invoked by public APIs.

Key Procedures and Functions

Three documented program units are exposed within the package body:

CREATE_PARALLEL_SLABS — Builds slab-based modifier lines, such as price breaks or graduated discount tiers, translating legacy slab definitions into the QP modifier and price break line model. The term "parallel" reflects its role in constructing the sequence of break points associated with a modifier.
CREATE_DISCOUNTS — The principal conversion routine. It reads legacy discount headers and lines and produces the corresponding Oracle Advanced Pricing list headers, list lines, qualifiers, and related modifier records.
GET_CONTEXT_ATTRIBUTES — Resolves context or qualifier attributes used to map legacy discount and qualifier definitions onto the QP pricing attribute and qualifier framework, including descriptive flexfield and value set metadata.

No parameter signatures are reproduced here; only the documented unit names and their functional intent are described.

Tables Accessed

The package reads legacy source tables and writes to current Oracle Advanced Pricing tables through APPS synonyms:

Legacy source tables: SO_DISCOUNTS, SO_DISCOUNT_CUSTOMERS, SO_DISCOUNT_LINES_115, SO_PRICE_LIST_LINES_115, and SO_PRICE_BREAK_LINES supply the historical discount, customer, price list, and price break definitions to be converted.
Target pricing tables: QP_LIST_HEADERS_B, QP_LIST_LINES, QP_QUALIFIERS, QP_RLTD_MODIFIERS, QP_PRICING_ATTRIBUTES, and QP_DISCOUNT_MAPPING receive the migrated modifier and qualifier data.
Supporting and staging tables: QP_UPG_LINES_DISTRIBUTION and SO_ENTITIES support the upgrade bookkeeping and entity resolution, while FND_FLEX_VALUE_SETS and FND_DESCR_FLEX_COLUMN_USAGES provide flexfield and value set context used during qualifier mapping.

Usage Notes

QP_MODIFIER_UPGRADE_PVT is normally invoked indirectly during the Oracle Advanced Pricing upgrade or conversion process, for example when migrating legacy discounts and price breaks to the QP schema. It is not a public API and should not be called directly from custom forms, concurrent programs, or extensions. Because it has no reverse dependencies documented and is classified as PVT, developers should treat it as internal to Oracle and unsupported for direct invocation. Any customization should instead use the sanctioned Advanced Pricing public APIs and documented concurrent programs that in turn drive this private package.