Search Results call_neconnection_proc




Overview
Explore in AI Chat

Overview

XDP_UTILITIES is a shared technical utility package in the Oracle E-Business Suite APPS schema that supports the Oracle Advanced Supply Chain Planning / Distributed Order Orchestration (DOO) fulfillment execution framework, commonly referred to as SFM (Supply Chain Fulfillment Management). It is declared AUTHID CURRENT_USER, meaning that its SQL statements execute with the privileges of the calling user rather than the definer, which is significant because the package is intended to be invoked from workflow background processes, concurrent programs, and other APPS packages operating on transactional data.

The package provides two broad categories of functionality. First, it brokers calls into user-defined parameter evaluation and mapping procedures registered against work items, fulfillment actions, and routing steps, providing a uniform callback signature so that external evaluation logic can be plugged into the fulfillment engine without modifying core code. Second, it provides dynamic SQL and metaprogramming helpers that let the fulfillment engine generate, compile, and execute PL/SQL procedure bodies at runtime, which is the mechanism underlying the configurable fulfillment processing model.

Key Procedures and Functions

The package exposes 48 documented procedures and functions. The callback or "Call" family provides the invocation layer for user-defined logic:

  • CALLWIPARAMEVALPROC — invokes a named work item parameter evaluation procedure, passing order, line item, and work item instance identifiers and returning the evaluated parameter value, reference value, return code, and error description.
  • CALLFAPARAMEVALPROC — the fulfillment action equivalent, invoking a named FA parameter evaluation routine.
  • CALLFAEVALALLPROC — evaluates all parameters associated with a fulfillment action instance.
  • CALLFEROUTINGPROC, CALLFULFILLMENTPROC, CALLFAMAPPROC, CALLWIMAPPROC — dispatch routines that invoke routing, fulfillment, fulfillment-action mapping, and work item mapping procedures respectively.
  • CALLWIWORKFLOWPROC — invokes workflow-related work item processing logic.
  • CALLDRCTASKRESULTPROC — processes the results returned by a distribution or routing task.
  • CALL_NECONNECTION_PROC — invokes connection handling logic used when interacting with external execution systems.

The metaprogramming and utility functions support dynamic procedure management and diagnostics:

  • CREATE_NEW_PROC_BODY, UPDATE_PROC_BODY, CREATE_PKG_SPEC, CREATE_PKG_BODY — generate and maintain the source text of PL/SQL procedures and packages stored in the XDP_PROC_BODY repository.
  • RUNPROC, DESCRIBEPROC, PRINTPARAMS, DO_COMMIT — execute a dynamically identified procedure, describe its signature, print parameter metadata, and manage transaction commit boundaries.
  • GET_CLOB_VALUE — retrieves the contents of a CLOB, using the package global G_CLOB, typically to read generated procedure source or message payloads.
  • EXECUTE_GETID_QUERY — the object of the current search. It executes a dynamically supplied query whose purpose is to retrieve an identifier value, enabling the fulfillment engine to resolve surrogate keys at runtime without hard-coded SQL. It is part of the same dynamic-SQL toolkit as RUNPROC and is used where a configuration-driven lookup must return a single ID.

Tables Accessed

The package operates against the core fulfillment execution and workflow coordination tables through APPS synonyms. XDP_ORDER_LINE_ITEMS and XDP_ORDER_LINEITEM_DETS hold the order line and detail context passed into the callback procedures. XDP_WORKITEMS, XDP_FA_FULFILLMENT_PROC, XDP_FES, and XDP_FE_GENERIC_CONFIG store fulfillment element definitions, configured processes, and generic configuration used to resolve which procedure to run. XDP_PROC_BODY is the repository read and written by the CREATE_* and UPDATE_* metaprogramming routines, while XDP_FE_CMD_AUD_TRAILS and XDP_FE_SW_GEN_LOOKUP provide audit trail and lookup support. XDP_FULFILL_WORKLIST, XDP_WF_PROCESS_COORD, and XDP_WF_COORDINATION_ID_S manage work list and workflow coordination, and WF_ITEM_ATTRIBUTE_VALUES supplies workflow attribute data. FND_RESPONSIBILITY is queried to resolve the default error notification recipient, and DBMS_SQL is used for the dynamic SQL execution performed by EXECUTE_GETID_QUERY and RUNPROC.

Usage Notes

XDP_UTILITIES is an internal engine package and is not intended to be called directly from application forms. It is invoked primarily from the fulfillment workflow background processes, from concurrent programs that drive order fulfillment processing, and from the 21 other packages that reference it. The dynamic SQL procedures such as EXECUTE_GETID_QUERY and RUNPROC execute SQL and PL/SQL supplied at runtime, so the calling context must sanitize any externally sourced query text. Because the package is AUTHID CURRENT_USER, effective privileges depend on the invoker. Customizations should extend behavior through the documented user-defined parameter evaluation and mapping procedures rather than by modifying this package, since it carries a standard Oracle header and is patched by Oracle during upgrades.