APPS.HXC_ARCHIVE dependencies on HXC_DATA_SETS

Line 123: -- Update hxc_data_sets as BACKUP_IN_PROGRESS because the process is going to take some time.

119: l_chunk_size := nvl(fnd_profile.value('HXC_ARCHIVE_RESTORE_CHUNK_SIZE'),50);
120:
121: fnd_file.put_line(fnd_file.LOG,'--- > Chunk Size is: '||l_chunk_size);
122:
123: -- Update hxc_data_sets as BACKUP_IN_PROGRESS because the process is going to take some time.
124:
125: UPDATE hxc_data_sets
126: SET status = 'BACKUP_IN_PROGRESS'
127: WHERE data_set_id = p_data_set_id;

Line 125: UPDATE hxc_data_sets

121: fnd_file.put_line(fnd_file.LOG,'--- > Chunk Size is: '||l_chunk_size);
122:
123: -- Update hxc_data_sets as BACKUP_IN_PROGRESS because the process is going to take some time.
124:
125: UPDATE hxc_data_sets
126: SET status = 'BACKUP_IN_PROGRESS'
127: WHERE data_set_id = p_data_set_id;
128:
129: -- Delete from the temp tables, if there is any left over data.

Line 377: UPDATE hxc_data_sets

373: IF l_thread_success AND trans_count = 0
374: THEN
375: -- If all threads finished successfully and there is no data left in
376: -- hxc_data_set_details, then mark the data set as OFF_LINE.
377: UPDATE hxc_data_sets
378: SET status = 'OFF_LINE', validation_status = ' '
379: WHERE data_set_id = p_data_set_id;
380:
381: ELSE

Line 747: FROM hxc_data_sets

743: SELECT start_date,
744: end_date
745: INTO l_data_set_start_date,
746: l_data_set_end_date
747: FROM hxc_data_sets
748: WHERE data_set_id = p_data_set_id;
749:
750: OPEN get_tcs ;
751: LOOP