Results for “qp_copy_pricelist_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

QP_COPY_PRICELIST_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Advanced Pricing (QP) module and provides the internal implementation logic for duplicating an existing price list, including its header definition, translated header text, price list lines, pricing attributes, qualifiers, and related modifier relationships. The "PVT" suffix designates the package as a private helper package rather than a public, supported API; it exists to encapsulate the copy mechanics that are exposed to end users through the Oracle Pricing user interface and related concurrent processing. Its status is VALID on both Oracle EBS 12.1.1 and 12.2.2, and its behavior is consistent with the long-standing Advanced Pricing data model built on the QP_LIST_HEADERS and QP_LIST_LINES entity families.

Key Procedures and Functions

The ETRM documentation identifies a single documented program unit within this package:

• COPY_PRICE_LIST — Performs the copy of a source price list into a new price list definition. The procedure is responsible for creating the target list header and propagating the associated detail records so that the copied price list is functionally equivalent to the original. Parameter lists are not documented in the available metadata and should be confirmed against the deployed package specification in the target instance before direct invocation.

Because this is a PVT-class package, other helper logic may exist in the package body and is not enumerated in the ETRM metadata; only COPY_PRICE_LIST is documented.

Tables Accessed

The package operates against the core Advanced Pricing and foundation tables through APPS synonyms:

• QP_LIST_HEADERS_B, QP_LIST_HEADERS_B_S, QP_LIST_HEADERS_TL — base, sequence, and translation tables for the price list header; used to create the new list header and its translated name and description.
• QP_LIST_LINES, QP_LIST_LINES_S — price list line records and their sequence; used to duplicate line-level pricing data.
• QP_PRICING_ATTRIBUTES, QP_PRICING_ATTRIBUTES_S — pricing attribute conditions attached to lines and qualifiers, copied to preserve product and customer qualifying criteria.
• QP_QUALIFIERS, QP_QUALIFIERS_S — qualifier records that define list eligibility rules.
• QP_RLTD_MODIFIERS, QP_RLTD_MODIFIERS_S — relationships between price lists and modifiers, preserved so the copied list retains its associated discount or surcharge logic.
• FND_LANGUAGES — used to resolve the languages into which header translations must be written for QP_LIST_HEADERS_TL.
• DUAL and PLITBLM — utility references supporting PL/SQL execution and bulk collection handling within the package.

Usage Notes

QP_COPY_PRICELIST_PVT is an internal implementation package. It is not a published API and is not referenced by any other documented package, so it is typically invoked indirectly rather than called from customer extensions. In standard Oracle Pricing flows, the copy action is initiated from the Price Lists setup forms or through the related concurrent program that duplicates an existing list, and the form or program layer delegates the actual INSERT/SELECT work to this package. Customers requiring automated price list duplication should generally use the supported Oracle Pricing public APIs and concurrent programs rather than calling COPY_PRICE_LIST directly. When direct invocation is unavoidable, the package specification should be reviewed for the current parameter signature, and the procedure should be executed inside a controlled transaction with validation of the resulting header, lines, attributes, and qualifiers. Because it writes across the QP_LIST_HEADERS, QP_LIST_LINES, QP_PRICING_ATTRIBUTES, QP_QUALIFIERS, and QP_RLTD_MODIFIERS families, any direct call must respect the Advanced Pricing concurrency and validation rules to avoid orphaned or inconsistent list definitions.