842: IS
843: SELECT 1
844: FROM dual
845: WHERE EXISTS (SELECT 1
846: FROM msd_dem_new_items
847: WHERE sr_instance_id = p_sr_instance_id
848: AND process_flag = 2);
849:
850: /*** LOCAL VARIABLES ***/
890: EXECUTE IMMEDIATE x_sql USING p_sr_instance_id;
891: msd_dem_common_utilities.log_debug ('Query End Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
892:
893: /* Set the process_flag */
894: UPDATE msd_dem_new_items
895: SET process_flag = 1
896: WHERE sr_instance_id = p_sr_instance_id
897: AND process_flag = 2;
898: