Search Results qp_list_headers_pkg




Overview
Explore in AI Chat

Overview

The QP_LIST_HEADERS_PKG package body in the APPS schema provides the foundational data manipulation layer for price list, discount list, and promotion list headers within the Oracle Advanced Pricing (QP) module of Oracle E-Business Suite. In the Oracle Pricing data model, price lists are organized as "list headers" (the parent record that defines list type, currency, and effective dates) with associated list lines beneath them. This package encapsulates the low-level insert, update, delete, lock, and translation operations that maintain the QP_LIST_HEADERS_B base table and its QP_LIST_HEADERS_TL translation table, shielding both Oracle Forms-based maintenance screens and programmatic callers from the underlying multi-table language structure required for multilingual support.

The package is a generated forms-support and utility package rather than a public business API, and is not referenced by any other database object, confirming its role as a self-contained maintenance layer invoked by the Advanced Pricing user interface. It depends on the base table handler QP_LIST_HEADERS_B, the translation handler QP_LIST_HEADERS_TL, the pricing utility package QP_PRICE_LIST_UTIL, and Oracle Application Object Library components (FND_LANGUAGES, FND_MESSAGE, APP_EXCEPTION).

Key Procedures and Functions

  • INSERT_ROW — Inserts a new price list header record into the base table and populates the corresponding translation rows, establishing the header identity used by all downstream list line maintenance.
  • LOCK_ROW — Acquires a row-level lock on an existing list header to enforce optimistic or pessimistic concurrency control, particularly important when multiple users or concurrent processes update pricing data simultaneously.
  • UPDATE_ROW — Modifies the attributes of an existing list header, including descriptive and translatable columns, keeping the base and translation tables synchronized.
  • DELETE_ROW — Removes a list header and its dependent translation and line data, enforcing the referential integrity rules that govern pricing list removal.
  • ADD_LANGUAGE — Inserts translation rows for a specified language, enabling the list header's name and description to be displayed in additional installed languages. This procedure typically leverages the FND_LANGUAGES table to determine valid target languages.

The package contains five documented procedures in total and is classified as OTHER, meaning it is not a formally published public API. Parameter lists are not documented in the ETRM metadata and should be confirmed against the deployed source before direct invocation.

Tables Accessed

  • QP_LIST_HEADERS_B — The base table holding language-independent list header attributes such as list type, currency, start and end dates, and pricing controls. This is the primary read/write target of INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW.
  • QP_LIST_HEADERS_TL — The translation table storing language-specific list name and description values, written by INSERT_ROW, UPDATE_ROW, and ADD_LANGUAGE.
  • FND_LANGUAGES — The Oracle Applications language repository, consulted by ADD_LANGUAGE to validate installed languages for translation insertion.

The package also references QP_PRICE_LIST_UTIL for shared pricing utility logic, and error handling is routed through FND_MESSAGE and APP_EXCEPTION.

Usage Notes

QP_LIST_HEADERS_PKG is most commonly invoked indirectly through the Oracle Advanced Pricing setup forms (such as the Price Lists form) during routine maintenance of list headers. Because the package is not referenced by any other database object and is classified as OTHER rather than as a public API, custom developers should generally prefer the officially supported pricing APIs (for example, the QP_PRICE_LIST_PUB or QP_LIST_HEADERS_PUB public interfaces) for integrations rather than calling these procedures directly. Direct invocation of QP_LIST_HEADERS_PKG carries risk: the package performs its own commit and error-handling logic tuned for interactive form sessions, which may conflict with the transaction boundaries required by batch or concurrent program processing. When troubleshooting multilingual display issues or header creation failures in Advanced Pricing, reviewing this package body against the QP_LIST_HEADERS_B and QP_LIST_HEADERS_TL table states is a useful diagnostic step.