APPS.ECX_INBOUND_TRIG dependencies on ECX_STANDARDS

Line 128: ecx_standards es

124: is
125: select attribute_name,
126: element_tag_name
127: from ecx_standard_attributes esa,
128: ecx_standards es
129: where es.standard_code = p_standard_code
130: and es.standard_type = nvl(p_standard_type, 'XML')
131: and esa.standard_id = es.standard_id;
132:

Line 587: ecx_standards es

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
590: and eep.ext_subtype = p_ext_subtype
591: and eep.ext_process_id = etd.ext_process_id

Line 610: ecx_standards es

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
613: and eep.ext_subtype = p_ext_subtype
614: and eep.ext_process_id = etd.ext_process_id

Line 1161: ecx_standards es,

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
1164: where etd.tp_detail_id = i_tp_detail_id
1165: and es.standard_id = eep.standard_id

Line 1392: ecx_standards es

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
1395: and eep.ext_process_id = etd.ext_process_id;
1396:

Line 1847: from ecx_standards

1843: ecx_utils.g_msgid := i_msgid;
1844: begin
1845: select standard_id
1846: into ecx_utils.g_standard_id
1847: from ecx_standards
1848: where standard_code = m_message_standard
1849: and standard_type = nvl(m_message_type, 'XML');
1850: if(l_statementEnabled) then
1851: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);

Line 1941: from ecx_standards

1937:
1938: /*begin
1939: select standard_id
1940: into ecx_utils.g_standard_id
1941: from ecx_standards
1942: where standard_code = m_message_standard
1943: and standard_type = nvl(m_message_type, 'XML');
1944: if(l_statementEnabled) then
1945: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);

Line 2170: from ecx_standards

2166:
2167: begin
2168: select standard_id
2169: into ecx_utils.g_standard_id
2170: from ecx_standards
2171: where standard_code = m_message_standard
2172: and standard_type = nvl(m_message_type, 'XML');
2173: if(l_statementEnabled) then
2174: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);

Line 2356: from ecx_standards

2352:
2353: begin
2354: select standard_id
2355: into ecx_utils.g_standard_id
2356: from ecx_standards
2357: where standard_code = i_message_standard
2358: and standard_type = nvl(i_message_type, 'XML');
2359: if(l_statementEnabled) then
2360: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);