APPS.MSD_DEM_QUERY_UTILITIES SQL Statements

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

Line: 43

        SELECT decode( m2a_dblink,
                      null, '',
                      '@'||m2a_dblink)
         INTO p_dblink
         FROM MSC_APPS_INSTANCES
         WHERE instance_id = p_instance_id;

Line: 78

select query
from msd_dem_queries  mdq,
     msd_dem_entity_queries mdeq
where mdeq.part1 = mdq.query_id
and mdeq.entity_name = p_entity_name;

Line: 85

select query
from msd_dem_queries  mdq,
     msd_dem_entity_queries mdeq
where mdeq.part2 = mdq.query_id
and mdeq.entity_name = p_entity_name;

Line: 92

select query
from msd_dem_queries  mdq,
     msd_dem_entity_queries mdeq
where mdeq.part3 = mdq.query_id
and mdeq.entity_name = p_entity_name;

Line: 173

			open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part1 = mdq.query_id and mdeq.entity_name = p_entity_name;

Line: 177

			open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part2 = mdq.query_id and mdeq.entity_name = p_entity_name;

Line: 181

			open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part3 = mdq.query_id and mdeq.entity_name = p_entity_name;

Line: 191

			open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part1 = mdq.query_id and mdeq.entity_name = p_entity_name||'_V';

Line: 195

			open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part2 = mdq.query_id and mdeq.entity_name = p_entity_name||'_V';

Line: 199

			open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part3 = mdq.query_id and mdeq.entity_name = p_entity_name||'_V';

Line: 232

                           execute immediate 'SELECT 1 FROM ' || cv_name || v_srdblink || ' WHERE 1 = 2 ' INTO x_is_view_valid;

Line: 303

      OPEN xc_get_parts FOR SELECT query
                               FROM msd_dem_entity_queries mdeq,
                                    msd_dem_queries mdq
                               WHERE  mdeq.entity_name = p_entity_name
                                  AND mdq.query_id = mdeq.part1;

Line: 311

      OPEN xc_get_parts FOR SELECT query
                               FROM msd_dem_entity_queries mdeq,
                                    msd_dem_queries mdq
                               WHERE  mdeq.entity_name = p_entity_name
                                  AND mdq.query_id = mdeq.part2;

Line: 319

      OPEN xc_get_parts FOR SELECT query
                               FROM msd_dem_entity_queries mdeq,
                                    msd_dem_queries mdq
                               WHERE  mdeq.entity_name = p_entity_name
                                  AND mdq.query_id = mdeq.part3;

Line: 348

         OPEN xc_get_parts FOR SELECT query
                                  FROM msd_dem_entity_queries mdeq,
                                       msd_dem_queries mdq
                                  WHERE  mdeq.entity_name = x_view_name
                                     AND mdq.query_id = mdeq.part1;

Line: 356

         OPEN xc_get_parts FOR SELECT query
                                  FROM msd_dem_entity_queries mdeq,
                                       msd_dem_queries mdq
                                  WHERE  mdeq.entity_name = x_view_name
                                     AND mdq.query_id = mdeq.part2;

Line: 364

         OPEN xc_get_parts FOR SELECT query
                                  FROM msd_dem_entity_queries mdeq,
                                       msd_dem_queries mdq
                                  WHERE  mdeq.entity_name = x_view_name
                                     AND mdq.query_id = mdeq.part3;

Line: 414

            EXECUTE IMMEDIATE 'SELECT 1 FROM ' || x_view_name || v_srdblink || ' WHERE 1 = 2 ' INTO x_is_view_valid;

Line: 476

      OPEN xc_get_parts FOR SELECT query
                               FROM msd_dem_entity_queries mdeq,
                                    msd_dem_queries mdq
                               WHERE  mdeq.entity_name = p_entity_name
                                  AND mdq.query_id = mdeq.part1;

Line: 484

      OPEN xc_get_parts FOR SELECT query
                               FROM msd_dem_entity_queries mdeq,
                                    msd_dem_queries mdq
                               WHERE  mdeq.entity_name = p_entity_name
                                  AND mdq.query_id = mdeq.part2;

Line: 492

      OPEN xc_get_parts FOR SELECT query
                               FROM msd_dem_entity_queries mdeq,
                                    msd_dem_queries mdq
                               WHERE  mdeq.entity_name = p_entity_name
                                  AND mdq.query_id = mdeq.part3;

Line: 558

    * Given a table name, location (MSD(2) or Demantra(1)), this procedure truncates(1) or deletes(2)
    * all data from the table.
    */
   PROCEDURE TRUNCATE_TABLE (
                errbuf              	OUT NOCOPY 	VARCHAR2,
                retcode             	OUT NOCOPY 	VARCHAR2,
                p_table_name		IN		VARCHAR2,
                p_owner			IN		NUMBER 	DEFAULT 1,
                p_truncate		IN		NUMBER 	DEFAULT 1 )
   IS

      x_schema		VARCHAR2(100) := NULL;

Line: 599

         x_sql := 'DELETE FROM ' || x_schema || '.' || p_table_name;