APPS.ECX_OUTBOUND SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 467

	i_stack.delete(i_stack.COUNT);

Line: 996

		select 	standard_id
		into  	i_standard_id
		from  	ecx_standards
		where 	standard_code = i_message_standard
                and     standard_type = nvl(i_message_type, 'XML');

Line: 1015

		select 	map_id
		into  	i_map_id
		from  	ecx_mappings
		where 	map_code = i_map_code;

Line: 1030

		select 	tp_header_id
		into  	i_tp_header_id
		from  	ecx_tp_headers
		where 	party_id = i_tp_id
		and 	party_site_id = i_tp_site_id
		and 	party_type = i_tp_type;

Line: 1048

		select 	root_element,
			fullpath
		into  	i_root_element,
			i_filename
		from  	ecx_objects eo
		where 	eo.map_id = i_map_id
		and   	eo.object_type in ('DTD','XML')
		and	eo.object_id = 2;

Line: 1222

	ecx_print_local.i_tmpxml.DELETE;

Line: 1223

	ecx_print_local.l_node_stack.DELETE;

Line: 1237

	if (not ecx_utils.g_delete_doctype) then
		ecx_print_local.document_node(i_root_element,i_filename,null);

Line: 1326

        i_stack.DELETE;

Line: 1327

	ecx_print_local.i_tmpxml.DELETE;

Line: 1328

	ecx_print_local.l_node_stack.DELETE;

Line: 1346

        i_stack.DELETE;

Line: 1347

	ecx_print_local.i_tmpxml.DELETE;

Line: 1348

	ecx_print_local.l_node_stack.DELETE;

Line: 1402

select  ecx_output_runs_s.NEXTVAL
from    dual;

Line: 1533

     	select  name
     	into    i_system
     	from    wf_systems
     	where   guid = wf_core.translate('WF_SYSTEM_GUID');

Line: 1816

select  ecx_output_runs_s.NEXTVAL
from    dual;