Search Results dpp_execution_detail_id_seq

Overview

DPP_BUSINESSEVENTS_PVT is a private PL/SQL package body owned by the APPS schema that implements the business event and workflow-notification layer of the Oracle E-Business Suite Distributed Procurement/Projects (DPP) module. Its principal role is to translate transactional state changes on DPP execution detail, transaction header, transaction line, and customer claim records into Oracle Workflow business events (WF_EVENT), and to dispatch the corresponding notifications to the responsible users. The package is classified as a PVT API, meaning it is intended for internal consumption by other DPP packages and concurrent programs rather than as a public integration interface. It is referenced by three other packaged objects, confirming its position as a shared, low-level event-raising utility within the DPP stack.

Key Procedures and Functions

• RAISE_BUSINESS_EVENT — Generic event-raising routine. It assembles a workflow event payload from DPP transaction data and publishes the event through WF_EVENT, using WF_PARAMETER_LIST_T to construct the parameter list and DBMS_XMLQUERY/XMLTYPE to serialize the event body.
• RAISE_EFFECTIVE_DATE_EVENT — Publishes an event specifically for effective-date milestones, most likely tied to supplier trade profiles (OZF_SUPP_TRD_PROFILES_ALL) or customer claim effective dating.
• SEND_EFFECTIVE_DATE_NOTIF — Delivers the notification associated with an effective-date event to the relevant user, resolving the recipient from FND_USER and the notification configuration held in OZF_SYS_PARAMETERS.
• SEND_CANCEL_NOTIFICATIONS — Issues cancellation notifications when a DPP transaction, transaction line, or customer claim is cancelled, so downstream parties are informed that the previously published event has been superseded.
• RAISE_BUSINESS_EVT_FOR_PROCESS — Wrapper that raises a business event on behalf of an entire processing run, iterating over the relevant transaction structures and invoking the generic event raiser as required.

Tables Accessed

The package reads and writes the core DPP transactional tables through APPS synonyms. DPP_EXECUTION_DETAILS holds the individual execution records, and the sequence DPP_EXECUTION_DETAIL_ID_SEQ — the object most often searched for alongside this package — supplies the primary key for those rows. DPP_TRANSACTION_HEADERS_ALL and DPP_TRANSACTION_LINES_ALL provide the header and line context used to build event payloads, while DPP_TRANSACTION_LINES_GT is a global temporary table used for intermediate result sets during processing. DPP_CUSTOMER_CLAIMS_ALL supplies claim data for cancellation and effective-date events. FND_USER resolves recipients, OZF_SUPP_TRD_PROFILES_ALL and OZF_SYS_PARAMETERS provide supplier trade profile and system-level configuration, and WF_PARAMETER_LIST_T, DBMS_XMLQUERY, XMLTYPE, DUAL, and PLITBLM support event parameter assembly and XML generation. Utility and messaging support comes from DPP_UTILITY_PVT, FND_API, FND_MESSAGE, FND_MSG_PUB, and FND_GLOBAL.

Usage Notes

Because this is a PVT package, it is not called directly from Oracle Forms or from customer extensions. Invocation occurs from DPP public APIs, concurrent programs, and other DPP packages that detect a state change requiring an event. The dependency list confirms that no database object references DPP_BUSINESSEVENTS_PVT, reinforcing that it sits only on the calling side of the dependency graph. All calls should be treated as internal; customizations that need equivalent functionality should raise events through the supported public DPP API surface. Note also the discrepancy between the documented sequence name DPP_EXECUTION_DETAILS_SEQ in the ETRM excerpt and the synonym DPP_EXECUTION_DETAIL_ID_SEQ actually referenced by the package body — the latter is the object bound in the compiled unit in the target 12.1.1/12.2.2 environment.