Search Results raise_outboundevent

Overview

The APPS.DPP_TRANSACTION_PVT package is the private application programming interface component within Oracle E-Business Suite's Distributed Procurement Punchout (DPP) subsystem. Classified under the ETRM as a PVT (private) API, it encapsulates the low-level transaction processing logic that supports supplier punchout and transaction exchange between Oracle EBS and external procurement content providers. In the ETRM 12.2.2 documentation, the package is listed with a status of VALID and is owned by the APPS schema.

Its business purpose is to create, persist, and route punchout-related transactions, including both outbound requests to supplier sites and inbound responses. It performs the core work of writing transaction header and line records, generating sequence-based identifiers, raising outbound business events, and handling inbound approval flows. Because it is a private package, it is intended to be called by other Oracle code rather than directly by end users, and it depends on the FND_API foundation package and the SYS.STANDARD package.

Key Procedures and Functions

• CREATE_TRANSACTION — Creates a DPP transaction, establishing the header and line structures required for a punchout exchange based on the supplied transaction context.
• INSERT_TRANSACTION — Performs the physical insertion of transaction records into the DPP transaction tables, persisting the data assembled by the create logic.
• RAISE_OUTBOUNDEVENT — Publishes the outbound business event associated with a DPP transaction, allowing downstream subscribers in the Oracle EBS event system to react to the transaction.
• INBOUND_TRANSACTION — Processes transactions received from external suppliers, writing them into the interface tables for subsequent validation and import.
• CREATE_WEBADI_TRANSACTION — Creates transactions originating through the Web ADI channel, integrating the Web ADI-based data entry path with the DPP transaction model.
• INBOUND_APPROVAL — Handles the approval processing of inbound transactions, applying the workflow or approval logic required before the transaction is accepted.

Tables Accessed

DPP_TRANSACTION_PVT references a range of DPP and standard Oracle tables through APPS synonyms. The main transactional data is held in DPP_TRANSACTION_HEADERS_ALL and DPP_TRANSACTION_LINES_ALL, which store the header and line detail of each transaction. DPP_TRANSACTION_CLAIMS_ALL holds associated claim information. The package uses several sequences to generate unique identifiers, including DPP_TRANSACTION_HDR_ID_SEQ, DPP_TRANSACTION_LINE_ID_SEQ, DPP_TRANSACTION_NUMBER_SEQ, DPP_TRANS_INT_HDR_ID_SEQ, and DPP_TRANS_INT_LINE_ID_SEQ. Inbound processing writes to the interface tables DPP_TXN_HEADERS_INT_ALL and DPP_TXN_LINES_INT_ALL.

Additionally, the package reads supplier data from AP_SUPPLIERS, AP_SUPPLIER_SITES, and AP_SUPPLIER_SITES_ALL, and references FINANCIALS_SYSTEM_PARAMS_ALL and FND_CURRENCIES for system parameters and currency validation.

Usage Notes

As a private package, DPP_TRANSACTION_PVT is invoked internally by the DPP transaction processing framework rather than directly by users. It is typically called from the standard Oracle EBS punchout flows, including forms-based and Web ADI-based entry paths, and from concurrent or background processes that handle inbound supplier responses. The RAISE_OUTBOUNDEVENT procedure integrates with the Oracle Workflow business event system, so transactions processed here may trigger subscribed event handlers.

Customizations should not call this package directly; the supported integration point is generally the public DPP API layer. The package is not referenced by any other documented packages, confirming its role as a terminal, internal implementation component.