Results for “qp_qp_form_pricing_attr”

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

Overview

QP_QP_FORM_PRICING_ATTR is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It is the form-support package for the Oracle Advanced Pricing (QP) pricing attribute maintenance UI. Pricing attributes are the qualifier and product-context values that drive price-list lines, modifier lines, and price-break lines — for example, Item, Item Category, Customer Class, Order Type, and any user-defined pricing contexts. This package provides the non-visual logic that the Oracle Forms pricing-attribute window calls to default values, validate user input, write records, and query translated attribute definitions.

It is classified as a non-public (OTHER) API, meaning Oracle does not publish it as an integration interface. It is used internally by the QP pricing forms and by view definitions in the pricing family (QPFV_* views) that expose pricing attribute columns to other windows. Its metadata status is VALID, and it carries no errors at the documented version.

Key Procedures and Functions

The ETRM metadata documents 35 procedures and functions. The principal entries are:

• DEFAULT_ATTRIBUTES — populates pricing attribute rows with default values when a new line or modifier is created, reducing manual entry for standard contexts.
• CHANGE_ATTRIBUTE — handles the change event when the user selects a different pricing attribute, re-deriving dependent values.
• VALIDATE_AND_WRITE — the central commit routine; validates the attribute set and persists changes to the base tables.
• DELETE_ROW — removes a pricing attribute row from the current detail block.
• PROCESS_ENTITY — applies the form-level entity processing rules to the attribute block.
• LOCK_ROW — issues the row-level lock used during multi-user editing.
• GET_MEANING — resolves a lookup code to its display meaning.
• GET_PRICING_PHASE — returns the pricing phase associated with a context.
• GET_CHARGE_NAME — returns the charge (price element) name for a modifier.
• GET_FORMULA — retrieves the formula attached to a modifier.
• GET_EXPIRATION_DATE, GET_EXP_PERIOD_START_DATE, GET_NUMBER_EXPIRATION_PERIODS, GET_EXPIRATION_PERIOD_UOM — derive expiration dates from period counts and UOM codes for accrual and benefit records.
• GET_REBATE_TXN_TYPE — returns the rebate transaction type for a modifier line.
• GET_BENEFIT_QTY, GET_BENEFIT_UOM_CODE, GET_BENEFIT_LIST_LINE_NO — return benefit quantity, its unit of measure, and the associated list line number.
• GET_ACCRUAL_FLAG, GET_ACCRUAL_CONVERSION_RATE — return accrual indicator and accrual conversion rate values.

Tables Accessed

The package reads and writes through APPS synonyms. QP_LIST_HEADERS_B and QP_LIST_LINES supply price list and modifier header/line context. QP_PRICING_ATTRIBUTES stores the actual attribute/value pairs created and maintained through this form. QP_PRICING_PHASES provides phase definitions used in modifier logic. QP_RLTD_MODIFIERS supports related-modifier relationships. FND_LOOKUP_VALUES supports GET_MEANING for lookup-code translation. The dependency list additionally cites QP_CHARGE_LOOKUP, QP_LOOKUPS, and QP_PRICE_FORMULAS_VL, which back charge, phase, and formula lookup behavior.

Usage Notes

QP_QP_FORM_PRICING_ATTR is invoked from the Oracle Pricing forms when users maintain pricing attributes on price lists, modifiers, and price breaks. It is not a callable public API; customizations that need pricing attribute logic should use the supported Advanced Pricing public APIs instead. The package is referenced by 23 objects, chiefly the QPFV_* views (QPFV_MODIFIER_LINES, QPFV_PRICE_BREAK_LINES, QPFV_QUALIFIERS, QPFV_PRICING_ATTRIBUTES, and others) and by QP_LINES_SUMMARY_V, QP_LIST_SUMMARY_VL, QP_MODIFIER_SUMMARY_V, QP_ARCH_MOD_SUMMARY_V, QP_BLKTPRT_MOD_LINES_V, and QP_BLKTPRT_PRL_LINES_V. On the CRM side it is referenced by AMS_PRODUCT_OFFERS_V, OZF_OFFER_PVT, OZF_OFFER_CLOB_V, OZF_OFFER_MARKET_OPTIONS_PVT, and OZF_PRODUCT_OFFERS_V, reflecting the shared pricing taxonomy between Advanced Pricing and iStore/Offers. Because it is a form-support package, its signature may change across patches; customers should not call it directly.