Search Results qp_secu_list_headers_v

Overview

DPP_PRICING_PVT is a private PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Advanced Pricing and channel/trade management product family, functioning as an internal pricing engine supporting outbound and inbound price list communication and promotion notification. As indicated by the _PVT suffix and the ETRM API classification of "PVT," the package is not intended for direct invocation by external or customer-developed code; it is a private implementation unit whose procedures are exposed to external consumers only indirectly through a public wrapper package. Because the object body references only PL/SQL programmable units, views, and tables through APPS synonyms, it operates entirely within the APPS schema context and is marked VALID in the documented environment. The package derives its business relevance from automating the distribution and receipt of pricing information across trading partners, a core requirement in pricing, order capture, and supplier collaboration flows.

Key Procedures and Functions

The ETRM metadata documents three procedures in this package body. Their names and inferred purposes are as follows:

• NOTIFY_OUTBOUNDPRICELISTS — Initiates notification processing for outbound price lists, driving the communication of pricing information to external parties based on qualifying list header and line data.
• NOTIFY_INBOUNDPRICELISTS — Handles notification processing for inbound price lists, supporting the receipt and recognition of pricing data supplied by suppliers or trading partners.
• NOTIFY_PROMOTIONS — Manages notification logic for promotional offers and activities, leveraging promotion and offer data to inform the appropriate recipients.

Each procedure follows the Oracle EBS API conventions implied by the dependency list: use of FND_API for standard API control structures, FND_MSG_PUB and FND_MESSAGE for message stack management, and FND_LOG for debug and diagnostic logging. No parameter lists are published in the supplied metadata, and none should be assumed.

Tables Accessed

DPP_PRICING_PVT reads from a defined set of pricing, supplier, item, and promotion tables exposed through APPS synonyms:

• QP_LIST_HEADERS_ALL and QP_LIST_LINES_V — price list headers and lines; the governing source of outbound and inbound pricing content. The user's search term, qp_secu_list_headers_v, corresponds to the security-enabled view QP_SECU_LIST_HEADERS_V, which the package also references to apply list-level security filtering.
• QP_MODIFIER_SUMMARY_V and QP_QUALIFIERS_V — modifier and qualifier definitions used to evaluate pricing rules.
• OZF_OFFERS, OZF_OFFERS_V, and OZF_ACTIVITY_PRODUCTS — promotion and offer data driving NOTIFY_PROMOTIONS and activity-product associations.
• AMS_ACT_PRODUCTS — marketing activity product linkages.
• AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL — supplier and supplier site identification for inbound and outbound trading partner targeting.
• MTL_SYSTEM_ITEMS_KFV and MTL_ITEM_CATEGORIES — item and category reference data applied to pricing content.
• HR_OPERATING_UNITS — operating unit context for multi-org data access, supplied through PLITBLM.

Usage Notes

DPP_PRICING_PVT is invoked through its associated public package rather than called directly, and it is referenced by three other database packages within the application. Typical invocation occurs from concurrent programs and pricing workflows that trigger notification of outbound and inbound price lists or promotion dissemination, often in scheduled batch mode. Customer and partner customizations should call the public wrapper API and not this private body, since the internal signatures may change across releases. The package is validated for Oracle EBS 12.1.1 and 12.2.2; in 12.2.x, calls resolve through the APPS editioning synonym, and the same private implementation applies.