447:
448: END IF;
449:
450: /* Get the query */
451: msd_dem_query_utilities.get_query2 (
452: x_retcode1,
453: x_large_sql,
454: l_identifier,
455: p_sr_instance_id,
559:
560: END IF;
561:
562: /* Get the query */
563: msd_dem_query_utilities.get_query2 (
564: x_retcode1,
565: x_large_sql,
566: x_pquery_identifier,
567: p_sr_instance_id,
656: IF (x_new_items_present = 1)
657: THEN
658: msd_dem_common_utilities.log_message ('Found new items for processing');
659:
660: msd_dem_query_utilities.get_query(
661: x_retcode,
662: x_sql,
663: 'DUMMY_ROWS_FOR_NEW_ITEMS',
664: p_sr_instance_id,