Results for “g_miss_pricing_attr_rec”

18 results




Overview
Explore in AI Chat

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

Overview

QP_PRICE_LIST_PUB is the public PL/SQL API for the Oracle Advanced Pricing (QP) module responsible for setting up and maintaining price lists. The package header declares a single business entity, QP_PRICE_LIST, exposed with the display name "Price List Setup." Its central purpose is to provide a programmatic, validated entry point for creating and processing price list headers and their associated list lines without requiring direct DML against the underlying Pricing tables. The header comment (revision 120.5, dated 2006/02/22) confirms the package has been stable across releases, and it is the supported interface used by Oracle Pricing forms, concurrent programs, and customer extensions alike in EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents three public entities. Each is designed to be called with the standard Oracle API pattern of a record-based payload, an x_return_status out parameter, and x_msg_count / x_msg_data messaging parameters; parameter lists are not reproduced here because they are not part of the documented facts.

  • PROCESS_PRICE_LIST — The primary maintenance procedure. It inserts, updates, or deletes a price list header together with its list lines, driven by the Price_List_Rec_Type record and the associated line table type. It performs validation, applies the standard WHO columns, and commits only through the caller's transaction control.
  • LOCK_PRICE_LIST — Acquires a logical lock on a specified price list so that concurrent processes cannot modify the same header simultaneously. This is typically invoked at the start of a processing cycle and is the standard technique for serializing pricing setup changes.
  • GET_PRICE_LIST — Retrieves the attributes of an existing price list into the Price_List_Rec_Type structure, allowing callers to read the current state of a header before deciding whether to update, copy, or lock it.

Tables Accessed

The package reads and writes three documented objects, all accessed through APPS synonyms:

  • QP_LIST_HEADERS_B — The base table storing price list headers (name, currency, dates, list type, and the DFF attribute1–15 columns exposed in the record type). PROCESS_PRICE_LIST performs the insert/update/delete here; GET_PRICE_LIST reads from it.
  • QP_LIST_LINES — Stores the individual price list lines (items, pricing attributes, adjustments). It is maintained in coordination with the header whenever PROCESS_PRICE_LIST is called with line data.
  • PLITBLM — The PL/SQL index-by table definition used to pass bulk arrays of list lines into PROCESS_PRICE_LIST. It is the transport structure for multi-line price list operations and is not a physical table.

Usage Notes

QP_PRICE_LIST_PUB is classified as a PUB API and is referenced by 33 other packages, making it a high-impact dependency in the Advanced Pricing code base. It is typically invoked from the Pricing price list setup forms, from price list copy or import concurrent programs, and from custom integrations that load price lists from external systems. Because it enforces the same validation as the forms, it is strongly preferred over direct inserts into QP_LIST_HEADERS_B and QP_LIST_LINES. Callers must initialize the Price_List_Rec_Type with FND_API.G_MISS_CHAR, G_MISS_NUM, and G_MISS_DATE sentinels so the API can distinguish supplied values from omitted ones, check x_return_status for FND_API.G_RET_STS_ERROR or G_RET_STS_UNEXP_ERROR after every call, and use FND_MSG_PUB to extract error text. LOCK_PRICE_LIST should be called before PROCESS_PRICE_LIST in any multi-step or concurrent scenario. In 12.2.2 the same interfaces remain valid; only the underlying table partitioning changed, so existing customizations require no code changes.