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: 950

		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: 969

		select 	map_id
		into  	i_map_id
		from  	ecx_mappings
		where 	map_code = i_map_code;

Line: 984

		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: 1002

		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: 1176

	ecx_print_local.i_tmpxml.DELETE;

Line: 1177

	ecx_print_local.l_node_stack.DELETE;

Line: 1191

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

Line: 1291

        i_stack.DELETE;

Line: 1292

	ecx_print_local.i_tmpxml.DELETE;

Line: 1293

	ecx_print_local.l_node_stack.DELETE;

Line: 1311

        i_stack.DELETE;

Line: 1312

	ecx_print_local.i_tmpxml.DELETE;

Line: 1313

	ecx_print_local.l_node_stack.DELETE;

Line: 1367

select  ecx_output_runs_s.NEXTVAL
from    dual;

Line: 1498

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

Line: 1781

select  ecx_output_runs_s.NEXTVAL
from    dual;