APPS.ECX_INBOUND_TRIG dependencies on ECX_TP_DETAILS

Line 584: from ecx_tp_details etd,

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

Line 607: from ecx_tp_details etd,

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

Line 624: from ecx_tp_details

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

Line 1087: i_destination_address ecx_tp_details.protocol_address%TYPE;

1083: i_ext_subtype varchar2(200);
1084: i_source_code varchar2(200);
1085: i_destination_code varchar2(200);
1086: i_destination_type varchar2(200);
1087: i_destination_address ecx_tp_details.protocol_address%TYPE;
1088: i_username varchar2(200);
1089: i_password varchar2(500);
1090: i_hub_user_id number DEFAULT 0;
1091: pragma exception_init(e_qtimeout,-25228);

Line 1144: from ecx_tp_details etd,

1140: i_int_subtype,
1141: i_party_id,
1142: i_party_site_id,
1143: i_party_type
1144: from ecx_tp_details etd,
1145: ecx_ext_processes eep,
1146: ecx_standards es,
1147: ecx_transactions et,
1148: ecx_tp_headers eth

Line 1331: i_destination_address ecx_tp_details.protocol_address%TYPE;

1327: i_ext_subtype varchar2(200);
1328: i_source_code varchar2(200);
1329: i_destination_code varchar2(200);
1330: i_destination_type varchar2(200);
1331: i_destination_address ecx_tp_details.protocol_address%TYPE;
1332: i_username varchar2(200);
1333: i_password varchar2(500);
1334: m_password varchar2(500);
1335: i_hub_user_id number;

Line 1375: from ecx_tp_details etd,

1371: i_password,
1372: i_hub_user_id,
1373: i_ext_type,
1374: i_ext_subtype
1375: from ecx_tp_details etd,
1376: ecx_ext_processes eep,
1377: ecx_standards es
1378: where etd.tp_detail_id = i_tp_detail_id
1379: and es.standard_id = eep.standard_id

Line 1483: ecx_tp_details etd

1479: begin
1480: select party_type
1481: into i_party_type
1482: from ecx_tp_headers eth,
1483: ecx_tp_details etd
1484: where eth.tp_header_id = etd.tp_header_id
1485: and etd.tp_detail_id = i_tp_detail_id;
1486: exception
1487: when others then