APPS.CSF_SPATIAL_DATALOAD_PUB SQL Statements

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

Line: 136

        EXECUTE IMMEDIATE 'SELECT 1
                           FROM SYS.DBA_DATA_FILES
                           WHERE tablespace_name = :1'
                  USING    l_table_space;

Line: 149

            CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'SELECT FROM SYS.DBA_DATA_FILES is failed : '||SQLCODE||'-'|| SQLERRM) ;

Line: 150

            CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'SELECT FROM SYS.DBA_DATA_FILES is failed : '||SQLCODE||'-'|| SQLERRM) ;

Line: 180

          EXECUTE IMMEDIATE 'UPDATE hz_locations SET geometry = NULL';

Line: 183

           EXECUTE IMMEDIATE 'UPDATE hz_locations l SET geometry = NULL
                              WHERE EXISTS   ( SELECT 1
                                                 FROM CSF_SPATIAL_CTRY_MAPPINGS sp
                                                WHERE l.country      = sp.hr_country_code
                                                  AND sp.spatial_dataset = :1 )'  USING l_data_set_name;

Line: 190

        CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'UPDATE hz_locations is successfull') ;

Line: 194

          CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'UPDATE hz_locations is failed : ' || SQLERRM) ;

Line: 195

          CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'UPDATE hz_locations is failed: ' || SQLERRM) ;

Line: 319

        EXECUTE IMMEDIATE 'SELECT 1
                           FROM SYS.DBA_DATA_FILES
                           WHERE tablespace_name = :1'
                  USING    l_table_space;

Line: 332

            CSF_SPATIAL_DATALOAD_PVT.put_stream(g_log,'SELECT FROM SYS.DBA_DATA_FILES is failed : '||SQLCODE||'-'|| SQLERRM) ;

Line: 333

            CSF_SPATIAL_DATALOAD_PVT.put_stream(g_output,'SELECT FROM SYS.DBA_DATA_FILES is failed : '||SQLCODE||'-'|| SQLERRM) ;