399: end if;
400: */
401: ----------------------------------------------------------------------------
402: -- Question : What should we do in case of rerun ?
403: -- Answer : We should not populate the hxc_data_set_details table because
404: -- some records may have already been transferred during the previous
405: -- runs. Also the first run of Archive has already populated the
406: -- hxc_data_set_details with the correct number of records.
407: ----------------------------------------------------------------------------
402: -- Question : What should we do in case of rerun ?
403: -- Answer : We should not populate the hxc_data_set_details table because
404: -- some records may have already been transferred during the previous
405: -- runs. Also the first run of Archive has already populated the
406: -- hxc_data_set_details with the correct number of records.
407: ----------------------------------------------------------------------------
408:
409: IF l_rerun = 'N' THEN
410:
424: RETURN;
425:
426: END IF;
427:
428: --fnd_file.put_line(fnd_file.LOG,'--- >Before populating the hxc_data_set_details table with table counts');
429: --hxc_archive_restore_utils.populate_hxc_data_set_details(p_data_set_id);
430: END IF;
431:
432:
425:
426: END IF;
427:
428: --fnd_file.put_line(fnd_file.LOG,'--- >Before populating the hxc_data_set_details table with table counts');
429: --hxc_archive_restore_utils.populate_hxc_data_set_details(p_data_set_id);
430: END IF;
431:
432:
433:
992: -- no need of the exact count, hence the rownum condition.
993:
994: SELECT count(1)
995: INTO l_count
996: FROM hxc_data_set_details
997: WHERE ROWNUM < 2 ;
998:
999: IF l_count >= 1
1000: THEN