Search Results send_sync

Overview

XDP_PROC_CTL is a core runtime control package within the Oracle EBS e-Commerce Gateway / Application Integration (XDP) infrastructure. In the 12.1.1 and 12.2.2 releases, the XDP schema family supports the processing of inbound and outbound transactions between Oracle E-Business Suite and external trading partners, and XDP_PROC_CTL provides the procedural backbone that drives provisioning, process execution, and low-level communication with external systems. The package is declared with AUTHID CURRENT_USER, meaning all SQL privileges are evaluated against the invoking schema rather than the package owner, which is characteristic of public utility packages that must be callable from concurrent managers and custom code running under different schemas.

A significant portion of the package is devoted to managing a generic front-end (FE) or adapter session. It maintains package-global state describing the front-end name, ID, type, adapter type, generic software flag, and dirty-bit status, along with configurable timeouts for acknowledgments, messages, commands, and connections. A set of typed records and tables (CONNECT_CMD and CONNECT_CMD_LIST) stores the ordered command/response pairs used to establish and validate a connection to an external system. A comprehensive hierarchy of named exceptions — covering parameter validation, procedure execution, pipe operations, and network element (NE) conditions such as session loss, timeout, warning, and failure — provides structured error propagation throughout the module.

Key Procedures and Functions

The documented procedures and functions cluster into three areas.

• Parameter handling: CHECK_FOR_OLD_PARAM, CHECK_PARAM_NAME, FIND_PARAMETERS, GET_PARAMETER_VALUE, FIND_REPLACE_PARAMS, GET_PARAM_VALUE, CHECK_CONNECT_PARAM_NAME, and FIND_CONNECT_PARAMETERS locate, validate, and substitute parameter values — including the special reset_buffer style replacement logic — within provisioning and connection templates.
• Process generation and debugging: GENERATE_PROC builds executable provisioning procedures, while SHOW_PROC_ERRORS surfaces compilation failures, typically by mining USER_ERRORS.
• Communication and messaging: SEND, SEND_HTTP, SEND_SYNC, NOTIFY_ERROR, RESPONSE_CONTAINS, GET_RESPONSE, GET_UNIQUE_CHANNEL_NAME, LOG_COMMAND_AUDIT_TRAIL, SEND_ACK, and WAIT_FOR_MESSAGE implement the send/receive handshake, acknowledgment timing, audit logging, and DBMS_PIPE-based channel coordination with external adapters.

Tables Accessed

The package reads and writes a defined set of XDP configuration and audit tables through APPS synonyms. XDP_CHANNEL_S supplies channel sequencing data. XDP_FA_PARAMETERS holds parameter definitions and values used by the FIND_PARAMETERS and GET_PARAMETER_VALUE routines. XDP_FE_ATTRIBUTE_DEF stores front-end attributes referenced by the NE_CMD_TIMEOUT, NE_CMD_RETRY_COUNT, NE_CONNECT_RETRY_COUNT, and related attribute-name constants. XDP_FE_CMD_AUD_TRAILS and XDP_FE_CMD_AUD_TRAILS_S receive command-level audit records via LOG_COMMAND_AUDIT_TRAIL. XDP_FE_SW_GEN_LOOKUP provides lookup values for generic software identification. Infrastructure references include DBMS_LOB and DBMS_PIPE (messaging), DBMS_SQL (dynamic execution of generated procedures), PLITBLM (index-by table handling), UTL_HTTP (web service calls in SEND_HTTP), USER_ERRORS (compilation diagnostics), and DUAL.

Usage Notes

XDP_PROC_CTL is not typically invoked directly by end users. It is called by Application Integration / e-Commerce Gateway concurrent programs and by Oracle Forms at runtime when processing inbound or outbound transactions, and it is referenced by at least one other package in the XDP family. Customizations that extend the integration framework — for example, adding new adapter types or provisioning procedures — should follow the parameter and connect-command conventions enforced by this package. Because it runs AUTHID CURRENT_USER, any custom caller must itself hold privileges on the referenced XDP tables and on the DBMS_* and UTL_HTTP packages.