APPS.HXC_RESTORE dependencies on HXC_DATA_SETS

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

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

Line 127: UPDATE hxc_data_sets

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

Line 332: UPDATE hxc_data_sets

328:
329:
330: IF l_thread_success and trans_count = 0
331: THEN
332: UPDATE hxc_data_sets
333: SET status = 'ON_LINE', validation_status = 'E'
334: WHERE data_set_id = p_data_set_id;
335:
336: ELSE

Line 596: FROM hxc_data_sets

592: SELECT start_date,
593: end_date
594: INTO l_data_set_start_date,
595: l_data_set_end_date
596: FROM hxc_data_sets
597: WHERE data_set_id = p_data_set_id;
598:
599: OPEN get_tcs ;
600: LOOP