DBA Data[Home] [Help]

APPS.ECX_INBOUND_NEW SQL Statements

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

Line: 35

   l_level_stack.DELETE;
Line: 36

   ecx_print_local.i_tmpxml.DELETE;
Line: 37

   ecx_print_local.l_node_stack.DELETE;
Line: 38

   ecx_utils.g_node_tbl.DELETE;
Line: 93

   select  attribute_name,
           element_tag_name
   from    ecx_standard_attributes esa,
           ecx_standards es
   where   es.standard_id = p_standard_id
   and     esa.standard_id = es.standard_id;
Line: 100

   i_string  varchar2(2000) := ' update ecx_doclogs set ';
Line: 102

   i_update  boolean;
Line: 111

   i_update := false;
Line: 128

             i_update := true;
Line: 144

   if i_update
   then
      /** remove the last , and put the statement for the where clause **/
      i_string := substr(i_string,1,length(i_string)-1);
Line: 158

   return i_update;
Line: 230

   l_level_stack.DELETE(l_level_stack.COUNT);
Line: 768

      node_info_stack.DELETE(l_stack_indx);
Line: 945

   l_level_stack.DELETE;
Line: 948

   l_attr_rec.DELETE;
Line: 1131

   select  map_code
   from    ecx_mappings
   where   map_id = p_map_id;