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 586: ecx_standards es

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

Line 609: ecx_standards es

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

Line 1146: ecx_standards es,

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

Line 1377: ecx_standards es

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

Line 1832: from ecx_standards

1828: ecx_utils.g_msgid := i_msgid;
1829: begin
1830: select standard_id
1831: into ecx_utils.g_standard_id
1832: from ecx_standards
1833: where standard_code = m_message_standard
1834: and standard_type = nvl(m_message_type, 'XML');
1835: if(l_statementEnabled) then
1836: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);

Line 1926: from ecx_standards

1922:
1923: /*begin
1924: select standard_id
1925: into ecx_utils.g_standard_id
1926: from ecx_standards
1927: where standard_code = m_message_standard
1928: and standard_type = nvl(m_message_type, 'XML');
1929: if(l_statementEnabled) then
1930: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);

Line 2155: from ecx_standards

2151:
2152: begin
2153: select standard_id
2154: into ecx_utils.g_standard_id
2155: from ecx_standards
2156: where standard_code = m_message_standard
2157: and standard_type = nvl(m_message_type, 'XML');
2158: if(l_statementEnabled) then
2159: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);

Line 2341: from ecx_standards

2337:
2338: begin
2339: select standard_id
2340: into ecx_utils.g_standard_id
2341: from ecx_standards
2342: where standard_code = i_message_standard
2343: and standard_type = nvl(i_message_type, 'XML');
2344: if(l_statementEnabled) then
2345: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);