eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ECX_DOCUMENT dependencies on ECX_TP_DETAILS

Line 99: ecx_tp_details etd

95: from ecx_ext_processes eep,
96: ecx_transactions et,
97: ecx_standards es,
98: ecx_tp_headers eth,
99: ecx_tp_details etd
100: where et.transaction_type = p_transaction_type
101: and et.transaction_subtype = p_transaction_subtype
102: and (p_party_type is null or eth.party_type = p_party_type)
103: and eep.transaction_id = et.transaction_id

Line 393: from ecx_tp_details etd,

389: i_ext_subtype,
390: i_party_type,
391: i_tp_header_id,
392: ecx_utils.g_tp_dtl_id
393: from ecx_tp_details etd,
394: ecx_tp_headers eth,
395: ecx_ext_processes eep,
396: ecx_transactions et,
397: ecx_standards es,

Line 737: p_destination_address ecx_tp_details.protocol_address%TYPE;

733: p_message_standard varchar2(200);
734: p_ext_type varchar2(200);
735: p_ext_subtype varchar2(200);
736: p_destination_type varchar2(200);
737: p_destination_address ecx_tp_details.protocol_address%TYPE;
738: p_username ecx_tp_details.username%TYPE;
739: p_password ecx_tp_details.password%TYPE;
740: p_map_code varchar2(200);
741: p_queue_name varchar2(200);

Line 738: p_username ecx_tp_details.username%TYPE;

734: p_ext_type varchar2(200);
735: p_ext_subtype varchar2(200);
736: p_destination_type varchar2(200);
737: p_destination_address ecx_tp_details.protocol_address%TYPE;
738: p_username ecx_tp_details.username%TYPE;
739: p_password ecx_tp_details.password%TYPE;
740: p_map_code varchar2(200);
741: p_queue_name varchar2(200);
742: p_attribute1 varchar2(200);

Line 739: p_password ecx_tp_details.password%TYPE;

735: p_ext_subtype varchar2(200);
736: p_destination_type varchar2(200);
737: p_destination_address ecx_tp_details.protocol_address%TYPE;
738: p_username ecx_tp_details.username%TYPE;
739: p_password ecx_tp_details.password%TYPE;
740: p_map_code varchar2(200);
741: p_queue_name varchar2(200);
742: p_attribute1 varchar2(200);
743: p_attribute2 varchar2(200);

Line 1071: p_username ecx_tp_details.username%TYPE;

1067: p_message_standard varchar2(200);
1068: p_ext_type varchar2(200);
1069: p_ext_subtype varchar2(200);
1070: p_destination_type varchar2(200);
1071: p_username ecx_tp_details.username%TYPE;
1072: p_password ecx_tp_details.password%TYPE;
1073: p_map_code varchar2(200);
1074: p_queue_name varchar2(200);
1075: p_attribute1 varchar2(200);

Line 1072: p_password ecx_tp_details.password%TYPE;

1068: p_ext_type varchar2(200);
1069: p_ext_subtype varchar2(200);
1070: p_destination_type varchar2(200);
1071: p_username ecx_tp_details.username%TYPE;
1072: p_password ecx_tp_details.password%TYPE;
1073: p_map_code varchar2(200);
1074: p_queue_name varchar2(200);
1075: p_attribute1 varchar2(200);
1076: p_attribute2 varchar2(200);

Line 1082: p_destination_address ecx_tp_details.protocol_address%TYPE;

1078: p_attribute4 varchar2(200);
1079: p_attribute5 varchar2(200);
1080: p_source_code varchar2(2000);
1081: p_destination_code varchar2(200);
1082: p_destination_address ecx_tp_details.protocol_address%TYPE;
1083:
1084: p_party_id number; /* Bug 2122579 */
1085: p_party_site_id number;
1086: i_count pls_integer:=0;

Line 1521: p_username ecx_tp_details.username%TYPE;

1517: p_message_standard varchar2(200);
1518: p_ext_type varchar2(200);
1519: p_ext_subtype varchar2(200);
1520: p_destination_type varchar2(200);
1521: p_username ecx_tp_details.username%TYPE;
1522: p_password ecx_tp_details.password%TYPE;
1523: p_map_code varchar2(200);
1524: p_queue_name varchar2(200);
1525: p_source_code varchar2(2000);

Line 1522: p_password ecx_tp_details.password%TYPE;

1518: p_ext_type varchar2(200);
1519: p_ext_subtype varchar2(200);
1520: p_destination_type varchar2(200);
1521: p_username ecx_tp_details.username%TYPE;
1522: p_password ecx_tp_details.password%TYPE;
1523: p_map_code varchar2(200);
1524: p_queue_name varchar2(200);
1525: p_source_code varchar2(2000);
1526: p_destination_code varchar2(200);

Line 1527: p_destination_address ecx_tp_details.protocol_address%TYPE;

1523: p_map_code varchar2(200);
1524: p_queue_name varchar2(200);
1525: p_source_code varchar2(2000);
1526: p_destination_code varchar2(200);
1527: p_destination_address ecx_tp_details.protocol_address%TYPE;
1528: p_party_type varchar2(200);
1529:
1530: begin
1531: p_party_type := party_type; --bug #2183619

Line 1632: p_username ecx_tp_details.username%TYPE;

1628: is
1629: p_message_type varchar2(200);
1630: p_message_standard varchar2(200);
1631: p_destination_type varchar2(200);
1632: p_username ecx_tp_details.username%TYPE;
1633: p_password ecx_tp_details.password%TYPE;
1634: p_map_code varchar2(200);
1635: p_queue_name varchar2(200);
1636: p_destination_address ecx_tp_details.protocol_address%TYPE;

Line 1633: p_password ecx_tp_details.password%TYPE;

1629: p_message_type varchar2(200);
1630: p_message_standard varchar2(200);
1631: p_destination_type varchar2(200);
1632: p_username ecx_tp_details.username%TYPE;
1633: p_password ecx_tp_details.password%TYPE;
1634: p_map_code varchar2(200);
1635: p_queue_name varchar2(200);
1636: p_destination_address ecx_tp_details.protocol_address%TYPE;
1637: p_party_type varchar2(200);

Line 1636: p_destination_address ecx_tp_details.protocol_address%TYPE;

1632: p_username ecx_tp_details.username%TYPE;
1633: p_password ecx_tp_details.password%TYPE;
1634: p_map_code varchar2(200);
1635: p_queue_name varchar2(200);
1636: p_destination_address ecx_tp_details.protocol_address%TYPE;
1637: p_party_type varchar2(200);
1638:
1639: begin
1640: p_party_type := party_type; --bug #2183619

Line 1818: from ecx_tp_details etd,

1814: etd.password,
1815: etd.connection_type,
1816: hub_id,
1817: hub_user_id
1818: from ecx_tp_details etd,
1819: ecx_ext_processes eep,
1820: ecx_standards es
1821: where etd.source_tp_location_code = p_party_ext_code
1822: and eep.ext_type = p_ext_type

Line 2059: from ecx_tp_details etd,

2055: begin
2056:
2057:
2058: select etd.confirmation into o_confirmation
2059: from ecx_tp_details etd,
2060: ecx_tp_headers eth,
2061: ecx_ext_processes eep,
2062: ecx_transactions et,
2063: ecx_standards es,