APIs Defined in ECX_DOCUMENT
get_delivery_attribs
PL/SQL Syntax
procedure get_devlivery_attribs
(transaction_type in varchar2,
transaction_subtype in varchar2,
party_id in varchar2,
party_site_id in varchar2,
party_type in/out varchar2,
standard_type out varchar2,
standard_code out varchar2,
ext_type out varchar2,
ext_subtype out varchar2,
source_code out varchar2,
destination_code out varchar2,
destination_type out varchar2,
destination_address out varchar2,
username out varchar2,
password out varchar2,
map_code out varchar2,
queue_name out varchar2,
tp_header_id out pls_integer,
retcode out pls_integer,
retmsg out vachar2);
Description
Gets setup data using the internal transaction type, subtype, party id, party_type, and party site id. The data is required to process an outbound transaction.
Arguments (input)
| transaction_type
| Internal transaction type passed to the procedure. The internal transaction type is entered using the Define Transactions window.
|
| transaction_subtype
| Internal transaction subtype passed to the procedure. The internal transaction subtype is entered using the Define Transactions window.
|
| party_id
| Trading partner ID passed to the procedure. Party site ID will be used if Party ID is null. The trading partner ID is entered using the Define Trading Partners window.
|
| party_site_id
| Trading partner site ID passed to the procedure. The trading partner site ID is entered using the Define Trading Partners window.
|
| party_type
| Party type associated with the trading partner and trading partner site passed to the procedure. Party type is entered using the Define Trading Partners window.
|
Arguments (output)
| party_type
| Party type associated with the trading partner and trading partner site passed to the procedure. Party type is entered using the Define Trading Partners window.
|
| standard_type
| The XML standard type associated with the transaction passed to the procedure. Standard type is entered using the Define XML Standards window.
|
| standard_code
| The standard code (for example, OAG) associated with the transaction passed to the procedure. Standard code is entered using the Define XML Standards window.
|
| ext_type
| External transaction type associated with the internal transaction type passed to the procedure. External transaction type is entered using the Define Transactions window.
|
| ext_subtype
| External transaction subtype associated with the internal transaction subtype passed to the procedure. External transaction subtype is entered using the Define Transactions window.
|
| source_code
| Source location code associated with the trading partner and trading partner site passed to the procedure. Source location code is entered using the Define Trading Partners window.
|
| destination_code
| Destination location code associated with the trading partner and trading partner site passed to the procedure. Destination location code is entered using the Define Trading Partners window.
|
| destination_type
| Destination location type associated with the trading partner and trading partner site passed to the procedure. Destination location type is entered using the Define Trading Partners window.
|
| destination_address
| Destination address associated with the trading partner and trading partner site passed to the procedure. Destination address is entered using the Define Trading Partners window.
|
| username
| Username associated with the trading partner and trading partner site passed to the procedure. Username is entered using the Define Trading Partners window.
|
| password
| Password associated with the username for the trading partner and trading partner site passed to the procedure. The password is returned in encrypted format. Password is entered using the Define Trading Partners window.
|
| map_code
| Message map associated with the trading partner and transaction passed to the procedure. The map code is entered using the Define Trading Partners window.
|
| queue_name
| Queue name associated with the transaction passed to the procedure. The queue name is entered using the Define Transactions window.
|
| tp_header_id
| System-generated identifier for the trading partner passed to the procedure, entered using the Define Trading Partners window
|
| retcode
| Return code for the procedure
|
| retmsg
| Return message for the procedure
|