Search Results get_product_value

Overview

The QP_MODIFIERS_ISETUP_IMP package is an Oracle Advanced Pricing (QP) setup import API within the Oracle E-Business Suite. It provides a programmatic mechanism for importing pricing modifier definitions — the list headers, list lines, qualifiers, and pricing attributes that constitute pricing rules — into the EBS pricing schema from external XML data sources. In Oracle EBS 12.1.1 and 12.2.2, this package supports bulk setup migration and data loading scenarios, allowing pricing administrators and implementation teams to transfer modifier configurations between environments or load externally-prepared pricing data without manual form entry.

The package specification, first created in December 2001 and last updated in 2006, exposes five documented subprograms: four lookup functions and a single import procedure. The naming convention (ISETUP_IMP) indicates its role as an interface setup import utility. The primary driver, IMPORT_MODIFIERS, consumes XML documents describing modifiers, qualifiers, and pricing attributes and persists them into the pricing tables.

Key Procedures and Functions

The package exposes four helper functions and one main import procedure. Their documented purposes are:

• get_product_code — Returns a product code given a product attribute context, attribute name, and attribute value. It supports resolution of product hierarchy or item context during modifier import.
• get_product_value — Returns a product value for a supplied product attribute context, attribute, and attribute value. This is the function most commonly referenced by users searching for get_product_value, as it maps incoming product-attribute data to the value representation expected by the pricing engine.
• get_qualifier_code — Resolves a qualifier code from a qualifier attribute context, attribute, and value, translating external qualifier representations into pricing qualifier codes.
• get_qualifier_value — Returns the qualifier value corresponding to the supplied qualifier attribute context, attribute, and attribute value.
• Import_Modifiers — The principal entry point. It accepts debug and output-directory parameters, a debug filename, four CLOB inputs (modifier list XML, modifier list lines XML, pricing attributes XML, and qualifiers XML), and returns standard OUT parameters: X_return_status, X_msg_count, and X_G_MSG_DATA. It orchestrates parsing of the XML payloads via DBMS_XMLSAVE and writes the resulting modifier data into the pricing tables.

Tables Accessed

The package reads and writes pricing setup and reference tables, including:

• QP_LIST_HEADERS_TL, QP_LIST_HEADER_TEMP, QP_LIST_LINES_TEMP — Modifier list header and line definitions, plus staging tables for the import.
• QP_QUALIFIERS_TEMP, QP_QUALIFIER_RULES — Qualifier definitions and their associated rules.
• QP_PRICING_ATTRIBUTES_TEMP, QP_PRICE_FORMULAS_TL, QP_PRICING_PHASES — Pricing attribute, formula, and phase data.
• MTL_PARAMETERS, MTL_SYSTEM_ITEMS_KFV — Inventory reference data used to validate or resolve item-related product context.
• RA_TERMS_TL — Payment term reference data for term-based modifiers.
• DBMS_XMLSAVE — The Oracle-supplied package used to transform XML CLOB input into relational rows during import.

Usage Notes

This package is typically invoked by Oracle Advanced Pricing setup import concurrent programs, setup migration utilities, and custom PL/SQL loaders that push modifier definitions into EBS via XML. The XML-first interface makes it suitable for automated, repeatable data migration between instances. Debug parameters allow controlled logging to a file for troubleshooting import failures. Because it is a server-side API with no documented form-level binding, custom code should call IMPORT_MODIFIERS with well-formed CLOB documents and always inspect X_return_status and X_msg_count to detect errors. Being an interface package with no documented inbound package dependencies and no documented referencing packages, it should be treated as a controlled setup tool rather than a runtime transactional API.