Search Results dpp_pl_notify_line_tbl_type

Overview

DPP_PRICING_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM (E-Business Suite Technical Reference Manual) as a Private API (PVT). It belongs to the Advanced Pricing and Oracle Trade Management (DPP) product family, which governs pricing, promotions, and outbound/inbound price list collaboration with suppliers and trading partners. The package encapsulates the notification logic used by the DPP BPEL integration layer to publish pricing-related documents — price lists and promotions — between an EBS instance and external collaboration partners.

In the Oracle EBS architecture, private packages such as DPP_PRICING_PVT are not intended as public APIs. Instead, they are consumed by sibling packages in the DPP schema, notably DPP_BPEL_GETIPL, DPP_BPEL_GETOUTBOUNDPL, and DPP_BPEL_GETPROMOS, all of which invoke DPP_PRICING_PVT for notification of pricing artifacts. The package also participates in the FND_API framework, inheriting the standard EBS API patterns for message handling and return status conventions. It additionally references the security view QP_SECU_LIST_HEADERS_V to enforce price list security at the time notifications are constructed.

Key Procedures and Functions

The ETRM metadata documents three public procedures within DPP_PRICING_PVT:

• NOTIFY_OUTBOUNDPRICELISTS — Constructs and dispatches notifications for outbound price lists published to trading partners, enabling buyers and suppliers to receive pricing updates when a price list is created, revised, or released.
• NOTIFY_INBOUNDPRICELISTS — Handles notifications for inbound price lists received from partners, supporting the receiving side of the pricing collaboration flow within the DPP integration framework.
• NOTIFY_PROMOTIONS — Generates notifications for promotion records, broadcasting offer or promotion data to collaborating partners through the BPEL process.

Each procedure serves as an orchestration point rather than an atomic business transaction; the actual BPEL invocation is handled by the calling packages. Parameter lists are not documented in the available metadata and should not be assumed.

Tables Accessed

The package reads from a defined set of tables via APPS synonyms, supporting the assembly of notification payloads:

• AP_SUPPLIERS, AP_SUPPLIER_SITES_ALL — Supplier and supplier site information used to identify trading partners and destination addresses for notifications.
• MTL_SYSTEM_ITEMS_KFV, MTL_ITEM_CATEGORIES — Item and category data defining the products included in outbound or inbound price lists.
• OZF_OFFERS, OZF_ACTIVITY_PRODUCTS, AMS_ACT_PRODUCTS — Promotions, offers, and activity-products for the promotion notification flow.
• PLITBLM — A pricing relation/index table used to resolve pricing structures.
• QP_SECU_LIST_HEADERS_V — A view enforcing price list security, ensuring only authorized price lists are included in notifications.

Usage Notes

DPP_PRICING_PVT is invoked indirectly through the DPP BPEL integration packages. It is not typically called from Oracle Forms or exposed as a concurrent program entry point. Customizations should not call this private package directly; any extension of pricing collaboration notification logic should be routed through the documented public interfaces of DPP_BPEL_GETIPL, DPP_BPEL_GETOUTBOUNDPL, or DPP_BPEL_GETPROMOS. Because it is a PVT-class object, Oracle does not guarantee upward compatibility across patch levels, and any direct dependency introduces upgrade risk. In 12.1.1 and 12.2.2 the package status is VALID, confirming it is compiled and active in both releases.