APPS.RRS_ELOCATION_PKG SQL Statements

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

Line: 24

           SELECT status, domidx_opstatus
           FROM   sys.all_indexes
           WHERE  owner = 'RRS' and index_name = x_index_name;

Line: 38

	  -- Delete existing and Insert new metadata
	  Update_Index_Metadata(l_index_name);

Line: 47

   	    -- Delete existing and Insert new metadata
  	    Update_Index_Metadata(l_index_name);

Line: 65

	  -- Delete existing and Insert new metadata
	  Update_Index_Metadata(l_index_name);

Line: 74

   	    -- Delete existing and Insert new metadata
  	    Update_Index_Metadata(l_index_name);

Line: 94

PROCEDURE Update_Index_Metadata (
p_index_name   IN  VARCHAR2
)
IS
  x_del_meta                  varchar2(255);

Line: 108

  x_del_meta :=  'Delete from user_sdo_geom_metadata
		  Where  table_name = ''' || l_table_name ||
		  ''' and  column_name= ''GEOMETRY''';

Line: 113

  x_ins_meta :=  'INSERT INTO user_sdo_geom_metadata (
		  table_name, column_name, diminfo, srid ) VALUES (
		 '''|| l_table_name ||''', ''GEOMETRY'',
		   mdsys.sdo_dim_array(
		   mdsys.sdo_dim_element(''longitude'', -180, 180, 0.00005),
		   mdsys.sdo_dim_element(''latitude'', -90, 90, 0.00005)), 8307 )';

Line: 120

END Update_Index_Metadata;