527: END LOOP;
528: END IF;
529:
530: x_query := replace (x_query, 'C_SR_INSTANCE_ID', to_char(p_sr_instance_id));
531: x_query := replace (x_query, 'C_SCHEMANAME', fnd_profile.value('MSD_DEM_SCHEMA'));
532:
533: msd_dem_common_utilities.log_debug (' The query v2 is - ');
534: msd_dem_common_utilities.log_debug (x_query);
535:
584: msd_dem_common_utilities.log_debug (' Truncate - ' || to_char(p_truncate));
585:
586: IF (p_owner = 1)
587: THEN
588: x_schema := fnd_profile.value('MSD_DEM_SCHEMA');
589: ELSE
590: x_retval := fnd_installation.get_app_info ( 'MSD', x_dummy1, x_dummy2, x_schema );
591: END IF;
592: