APPS.HXC_ARCHIVE_RESTORE_PROCESS dependencies on HXC_DATA_SET_DETAILS

Line 403: -- Answer : We should not populate the hxc_data_set_details table because

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: ----------------------------------------------------------------------------

Line 406: -- hxc_data_set_details with the correct number of records.

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:

Line 428: --fnd_file.put_line(fnd_file.LOG,'--- >Before populating the hxc_data_set_details table with table counts');

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:

Line 429: --hxc_archive_restore_utils.populate_hxc_data_set_details(p_data_set_id);

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:

Line 996: FROM hxc_data_set_details

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