Search Results get_order_param_list

Overview

XDP_INTERFACES is a public PL/SQL package in the APPS schema that serves as the primary programmatic entry point into the Oracle E-Business Suite Supply Chain Fulfillment Management (SFM) engine, part of the order fulfillment and "Drop Ship"/fulfillment orchestration layer. The package is declared AUTHID CURRENT_USER, meaning its database objects are resolved using the privileges of the invoking schema rather than the package owner. Its central purpose is to accept an order header, an order-level parameter list, and an order line list, and to hand those structures to the fulfillment engine for provisioning, scheduling, and status tracking. The package also exposes a family of getter routines that allow callers to read back order-level and line-level parameters and fulfillment status, plus cancel and DRC (distributed order) processing operations.

Key Procedures and Functions

The documented procedures and functions (21 in total) fall into several functional groups:

• Submission and processing: PROCESS_ORDER submits a single order (with header, order-level parameters, and line list) into SFM for fulfillment. PROCESS_DRC_ORDER handles Distributed Order/DRC-style orders, where line-level provisioning applies across a distributed order structure. CANCEL_ORDER cancels an existing order in the fulfillment engine.
• Status retrieval: GET_ORDER_STATUS, GET_LINE_STATUS, and GET_ORD_FULFILLMENT_STATUS return the current fulfillment state of an order or a specific line. GET_ORDER_DETAILS returns the order structure and related attributes.
• Parameter access: GET_ORDER_PARAM_VALUE and GET_LINE_PARAM_VALUE return the value of a specific order-level or line-level parameter; GET_ORDER_PARAM_LIST returns the full parameter list for an order. These are the routines a caller uses to read back the "get_line_param_value" style lookups after an order has been submitted.
• Status mutation: SET_ORD_FULFILLMENT_STATUS and SET_LINE_FULFILLMENT_STATUS set the fulfillment status at order and line level respectively, and GET_LINE_FULFILLMENT_STATUS reads the line-level fulfillment state.

Tables Accessed

The package reads and writes the SFM fulfillment tables through APPS synonyms. XDP_ORDER_HEADERS and XDP_ORDER_HEADERS_S hold the order header records; XDP_ORDER_LINE_ITEMS, XDP_ORDER_LINEITEM_DETS, and XDP_ORDER_RELATIONSHIPS hold line items, their detail attributes, and relationships between orders/lines. XDP_ORDER_PARAMETERS stores the order and line parameter values that GET_ORDER_PARAM_VALUE and GET_LINE_PARAM_VALUE retrieve. XDP_FULFILL_WORKLIST, XDP_WORKITEMS, XDP_FA_RUNTIME_LIST, and XDP_ADAPTER_JOB_QUEUE drive the fulfillment worklist, work item queue, and runtime execution scheduling. XNP_MSGS and DBMS_AQ support asynchronous messaging and advanced queueing. HZ_CUST_ACCOUNTS supplies customer/account data, MTL_PARAMETERS supplies inventory parameters, and FND_LOOKUP_VALUES provides lookup code validation and decoding.

Usage Notes

XDP_INTERFACES is a private/technical API, invoked by other SFM packages (it is referenced by four other packages) rather than called directly by end users in standard Oracle Forms. It is most commonly invoked from PL/SQL in custom integrations, concurrent programs that batch-submit orders, and the SFM order capture flows. Because the package is AUTHID CURRENT_USER and the procedures are declared private, callers should invoke it under a schema granted EXECUTE on XDP_INTERFACES and appropriate privileges on the underlying XDP and HZ tables. Parameter values supplied in the ORDER_PARAMETER_LIST and line parameter structures are persisted to XDP_ORDER_PARAMETERS and are subsequently readable via GET_ORDER_PARAM_VALUE and GET_LINE_PARAM_VALUE, which is the mechanism behind line-level parameter lookups such as "get_line_param_value."