191:
192:
193: hr_general.g_data_migrator_mode := 'Y';
194:
195: l_fnd_logging := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
196: l_chunk_size := nvl(fnd_profile.value('HXC_ARCHIVE_RESTORE_CHUNK_SIZE'),50);
197:
198: OPEN c_tbb_id(p_data_set_id);
199:
192:
193: hr_general.g_data_migrator_mode := 'Y';
194:
195: l_fnd_logging := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
196: l_chunk_size := nvl(fnd_profile.value('HXC_ARCHIVE_RESTORE_CHUNK_SIZE'),50);
197:
198: OPEN c_tbb_id(p_data_set_id);
199:
200: LOOP
436: fnd_file.put_line(fnd_file.LOG,'Error during undo data set: '||sqlerrm);
437: ROLLBACK;
438: p_retcode:=2;
439:
440: IF (nvl(fnd_profile.value('AFLOG_ENABLED'),'N')='Y') THEN
441:
442: hxc_archive_restore_debug.print_table_record(p_table_name,
443: p_data_set_id,
444: p_column1,
463: BEGIN
464:
465: hr_general.g_data_migrator_mode := 'Y';
466:
467: l_fnd_logging := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
468: l_chunk_size := nvl(fnd_profile.value('HXC_ARCHIVE_RESTORE_CHUNK_SIZE'),25);
469:
470: undo_define_table(p_table_name => 'HXC_TIME_BUILDING_BLOCKS',
471: p_data_set_id => p_data_set_id,
464:
465: hr_general.g_data_migrator_mode := 'Y';
466:
467: l_fnd_logging := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
468: l_chunk_size := nvl(fnd_profile.value('HXC_ARCHIVE_RESTORE_CHUNK_SIZE'),25);
469:
470: undo_define_table(p_table_name => 'HXC_TIME_BUILDING_BLOCKS',
471: p_data_set_id => p_data_set_id,
472: p_chunk_size => l_chunk_size);