Search Results xdp_drc_util_pvt




Overview
Explore in AI Chat

Overview

XDP_DRC_UTIL_PVT is a private PL/SQL package in the APPS schema belonging to the Oracle E-Business Suite Order Capture / Distributed Order Orchestration (DOS) framework, commonly associated with the XDP (eXtended Distributed Processing) module family. In Oracle EBS 12.1.1 and 12.2.2, the XDP schema objects support fulfillment processing, work item orchestration, and integration with external fulfillment and order-management systems. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the defining user, a design typical of private (PVT) packages that operate on behalf of the calling session.

Its primary business function is to process Distributed Order Capture / Distributed Fulfillment (DRC) orders as part of the order fulfillment lifecycle. The package acts as a utility layer that mediates between Oracle Order Management order data and the XDP work item infrastructure, allowing DRC orders to be routed, tracked, and fulfilled through the XDP fulfillment actions and adapter mechanisms.

Key Procedures and Functions

The ETRM documentation for this package lists a single documented procedure:

  • PROCESS_DRC_ORDER — The central routine of the package. Based on the header comment ($Header: XDPDRCPS.pls), it coordinates processing of a DRC order identified by a work item. It accepts an input work item identifier and a task parameter list (XDP_TYPES.ORDER_PARAMETER_LIST), and returns an SDP order identifier, a return code, and an error description.

The output signature returned by the procedure is consistent with the standard Oracle EBS concurrent/PLSQL error-handling convention: x_return_code signals success or failure (typically 0 for success, 1 or 2 for errors), while x_error_description conveys diagnostic text on failure. The x_SDP_ORDER_ID output communicates the identifier of the resulting SDP (Service Delivery Platform) order created or processed as a result of the DRC operation. The procedure uses NOCOPY on its OUT parameters, an optimization appropriate for PL/SQL output parameters passing between subprograms without duplication.

Tables Accessed

The package references the following tables through APPS synonyms, grouped by functional area:

Usage Notes

As a private (_PVT) package, XDP_DRC_UTIL_PVT is not intended to be called directly by end users or custom code. It is invoked internally by the XDP fulfillment framework — typically from concurrent programs, fulfillment engine routines, or other XDP packages — during processing of DRC orders. The ETRM metadata records 0 direct referencing packages, indicating that any callers reside within the XDP runtime or are registered dynamically. Customization or direct invocation is discouraged; the supported extension points remain the public XDP APIs rather than this private utility layer.