Search Results qp_int_lines




Overview
Explore in AI Chat

Overview

QP_BULK_PREQ_GRP is an Oracle Advanced Pricing group package (API classification: GRP) in the APPS schema that supports high-volume, set-based price request processing within Oracle E-Business Suite Release 12.1.1 and 12.2.2. Rather than invoking pricing engine logic one line at a time, this package coordinates bulk operations that stage order and pricing data into the interface and pricing request tables supplied by Oracle Order Management and Advanced Pricing. It is a principal component of the bulk pricing architecture used when large order imports — typically through Order Import or the Bulk Order interface — require prices and price adjustments to be calculated efficiently for many lines simultaneously.

The package body is documented as VALID and depends on a broad set of Pricing and Order Management APIs, including QP_PREQ_GRP, QP_PREQ_PUB, QP_ATTR_MAPPING_PUB, QP_BUILD_SOURCING_PVT, QP_UTIL, OE_BULK_ORDER_PVT, OE_WSH_BULK_GRP, OE_DEBUG_PUB, and FND_API. It is not referenced by any database object, confirming that it functions as a top-level entry point invoked by external callers rather than as a lower-level dependency of another package.

Key Procedures and Functions

  • BULK_INSERT_LINES — Populates pricing request line data in bulk. This procedure drives the insertion of line-level pricing request records that the pricing engine later consumes, working in conjunction with the QP_INT_LINES, QP_INT_LDETS, and QP_INT_LINE_ATTRS tables to capture line attributes and pricing qualifiers.
  • BULK_INSERT_ADJ — Handles bulk insertion of price adjustment data. It writes adjustment results and related pricing modifiers so that applied discounts, surcharges, and other list-based adjustments are persisted for the processed lines.

Both procedures are designed for array-based (bulk) processing, minimizing context switching between PL/SQL and SQL to improve throughput on large order volumes. No explicit parameter lists are documented in the available metadata.

Tables Accessed

The package reads and writes several interface and pricing definition tables through APPS synonyms:

  • OE_HEADERS_IFACE_ALL, OE_LINES_IFACE_ALL, OE_PRICE_ADJS_IFACE_ALL — Order Management interface tables that store staged order headers, lines, and price adjustment results prior to Order Import validation and insertion into the live order tables.
  • QP_LIST_HEADERS_B, QP_LIST_LINES — Advanced Pricing list and modifier definition tables, consulted to resolve applicable price lists and qualifier setup.
  • PLITBLM — The standard Oracle character-list table type used for passing arrays of identifiers and attribute data into bulk APIs.

Additional intermediate pricing request storage is provided via QP_INT_LINES, QP_INT_LDETS, and QP_INT_LINE_ATTRS, referenced during the pricing request build.

Usage Notes

QP_BULK_PREQ_GRP is normally invoked programmatically rather than through a concurrent program or form of its own. It is called by Order Import and bulk order processing flows sourced from OE_BULK_ORDER_PVT and OE_WSH_BULK_GRP, and it is referenced by three other packages in the ETRM dependency set. Because the package coordinates pricing request population across interface and pricing tables, it is typically executed within the context of a larger bulk pricing run that first stages order data and then submits pricing for engine processing.

Customizations and diagnostics should treat this package as an internal integration point: callers pass collection-based structures, and failures generally surface as exceptions raised through FND_API with debug traced via OE_DEBUG_PUB. The term "qp_int_lines" corresponds to the QP_INT_LINES pricing interface table that this package populates during BULK_INSERT_LINES, making it the object most frequently inspected when troubleshooting missing or incorrect bulk pricing results. Direct modification of the package body is not supported; extensions should be implemented through the underlying public pricing and order APIs.