DBA Data[Home] [Help]

APPS.ECX_INBOUND SQL Statements

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

Line: 23

 Updates the DOM for any mappings by refering to the g_node_tbl
**/
procedure updateDOM
	(
	i_target	IN	pls_integer
	)
is

i_method_name   varchar2(2000) := 'ecx_inbound.updatedom';
Line: 76

      ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_INBOUND.updateDOM');
Line: 78

               ecx_debug.log(l_statement,'ECX', SQLERRM || ' - ECX_INBOUND.updateDOM',
                            i_method_name);
Line: 85

end updateDOM;
Line: 166

      updateDOM(i_target);
Line: 416

	i_stack.delete(i_stack.COUNT);
Line: 1071

   select eo.root_element,
          0
   from   ecx_mappings em,
          ecx_objects eo
   where  em.map_id = p_map_id
   and    em.map_id = eo.map_id
   and    em.object_id_source = eo.object_id;
Line: 1154

      SELECT  root_element,
              fullpath
      INTO    i_root_name,
              i_filename
      FROM    ecx_objects eo
      WHERE   eo.map_id = ecx_utils.g_map_id
      AND     eo.object_type in ('DTD','XML')
      AND     eo.object_id = 2;
Line: 1175

   ecx_print_local.i_tmpxml.DELETE;
Line: 1176

   ecx_print_local.l_node_stack.DELETE;
Line: 1332

   i_stack.DELETE;
Line: 1628

      i_stack.DELETE;
Line: 1629

      ecx_print_local.i_tmpxml.DELETE;
Line: 1630

      ecx_print_local.l_node_stack.DELETE;
Line: 1631

      ecx_utils.g_node_tbl.DELETE;
Line: 1649

      i_stack.DELETE;
Line: 1650

      ecx_print_local.i_tmpxml.DELETE;
Line: 1651

      ecx_print_local.l_node_stack.DELETE;
Line: 1652

      ecx_utils.g_node_tbl.DELETE;