APPS.ECX_INBOUND_TRIG dependencies on ECX_TP_DETAILS

Line 585: from ecx_tp_details etd,

581: select etd.map_id map_id,
582: etd.routing_id routing_id,
583: etd.tp_header_id tp_header_id,
584: etd.confirmation confirmation
585: from ecx_tp_details etd,
586: ecx_ext_processes eep,
587: ecx_standards es
588: where etd.source_tp_location_code = p_party_ext_code
589: and eep.ext_type = p_ext_type

Line 608: from ecx_tp_details etd,

604: )
605: is
606: select etd.tp_header_id tp_header_id,
607: etd.tp_detail_id tp_detail_id
608: from ecx_tp_details etd,
609: ecx_ext_processes eep,
610: ecx_standards es
611: where etd.source_tp_location_code = p_party_ext_code
612: and eep.ext_type = p_ext_type

Line 625: from ecx_tp_details

621: (
622: p_routing_id IN pls_integer
623: ) is
624: select tp_header_id
625: from ecx_tp_details
626: where tp_detail_id = p_routing_id;
627:
628: begin
629: if (l_procedureEnabled) then

Line 1102: i_destination_address ecx_tp_details.protocol_address%TYPE;

1098: i_ext_subtype varchar2(200);
1099: i_source_code varchar2(200);
1100: i_destination_code varchar2(200);
1101: i_destination_type varchar2(200);
1102: i_destination_address ecx_tp_details.protocol_address%TYPE;
1103: i_username varchar2(200);
1104: i_password varchar2(500);
1105: i_hub_user_id number DEFAULT 0;
1106: pragma exception_init(e_qtimeout,-25228);

Line 1159: from ecx_tp_details etd,

1155: i_int_subtype,
1156: i_party_id,
1157: i_party_site_id,
1158: i_party_type
1159: from ecx_tp_details etd,
1160: ecx_ext_processes eep,
1161: ecx_standards es,
1162: ecx_transactions et,
1163: ecx_tp_headers eth

Line 1346: i_destination_address ecx_tp_details.protocol_address%TYPE;

1342: i_ext_subtype varchar2(200);
1343: i_source_code varchar2(200);
1344: i_destination_code varchar2(200);
1345: i_destination_type varchar2(200);
1346: i_destination_address ecx_tp_details.protocol_address%TYPE;
1347: i_username varchar2(200);
1348: i_password varchar2(500);
1349: m_password varchar2(500);
1350: i_hub_user_id number;

Line 1390: from ecx_tp_details etd,

1386: i_password,
1387: i_hub_user_id,
1388: i_ext_type,
1389: i_ext_subtype
1390: from ecx_tp_details etd,
1391: ecx_ext_processes eep,
1392: ecx_standards es
1393: where etd.tp_detail_id = i_tp_detail_id
1394: and es.standard_id = eep.standard_id

Line 1498: ecx_tp_details etd

1494: begin
1495: select party_type
1496: into i_party_type
1497: from ecx_tp_headers eth,
1498: ecx_tp_details etd
1499: where eth.tp_header_id = etd.tp_header_id
1500: and etd.tp_detail_id = i_tp_detail_id;
1501: exception
1502: when others then