Search Results xdp_order_line_items_s

Overview

XDP_DRC_UTIL_PVT is a private (PVT) PL/SQL package body in the APPS schema that supports Oracle E-Business Suite's Telecommunications Service Management / Order Capture (XDP) fulfillment and provisioning framework. The name reflects its role as a utility layer for "DRC" (Distributed Request Coordination / direct order processing) order handling within the XDP engine. Rather than exposing a public API, the package body provides internal helper logic consumed by the XDP runtime, worklist, and fulfillment processing components. Its responsibilities include reading order header, order line, and line-item detail data, coordinating with the XDP engine and fulfillment action tables, and raising standardized errors through XDP_ERRORS_PKG and FND_MESSAGE. Because the object is a package body only, the corresponding specification (if separate) governs the callable interface; the body encapsulates the procedural implementation. The documented ETRM metadata confirms that XDP_DRC_UTIL_PVT is valid, owned by APPS, and referenced by zero other database objects, indicating it is a leaf-level implementation unit invoked at runtime rather than a shared dependency.

Key Procedures and Functions

The ETRM metadata documents a single callable unit:

• PROCESS_DRC_ORDER — The sole documented procedure, responsible for processing a DRC order through the XDP fulfillment pipeline. Its exact parameter list is not published in the metadata and should not be assumed; functionally it drives order-level processing by reading header, line, and line-item detail records, coordinating fulfillment actions, and invoking engine and worklist utilities. Error conditions are surfaced via XDP_ERRORS_PKG.

Additional internal (undocumented) helpers may exist within the body, but only PROCESS_DRC_ORDER is captured in the ETRM record.

Tables Accessed

The package body references the following APPS synonym tables, each serving a distinct purpose in order fulfillment:

• XDP_ORDER_HEADERS / XDP_ORDER_HEADERS_S — Order header records and their status shadow table; the "_S" suffix typically denotes status or supplemental tracking, relevant because the originating search term referenced XDP_ORDER_HEADERS_S.
• XDP_ORDER_LINE_ITEMS / XDP_ORDER_LINE_ITEMS_S — Order line items and their status counterparts.
• XDP_ORDER_LINEITEM_DETS — Detailed line-item attributes used during processing.
• XDP_FULFILL_ACTIONS, XDP_FULFILL_WORKLIST, XDP_WORKITEMS — Fulfillment action definitions, worklist entries, and work item tracking.
• XDP_FA_FULFILLMENT_PROC, XDP_FA_RUNTIME_LIST, XDP_WI_FA_MAPPING — Fulfillment process and runtime mapping tables linking work items to actions.
• XDP_ADAPTER_REG, XDP_FE_SW_GEN_LOOKUP — Adapter registration and front-end switch/generation lookup values.
• DBMS_LOCK, DUAL — Concurrency control and singleton SQL operations.

Usage Notes

XDP_DRC_UTIL_PVT is not referenced by any other database object and is classified as a private API, so it is not intended for direct invocation from custom code. In practice it is called internally by the XDP engine (XDP_ENGINE, XDP_ENG_UTIL) and related fulfillment components during order capture and provisioning flows, typically triggered from Order Capture forms, fulfillment concurrent programs, or engine runtime processing. Because it depends on FND_GLOBAL and FND_MESSAGE, it inherits session and language context from the invoking EBS session. Customizations should avoid calling this package directly; instead, integrators should use the public XDP APIs and engine interfaces, allowing PROCESS_DRC_ORDER and its supporting logic to execute through supported channels.