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 340: UPDATE hxc_data_sets

336:
337:
338: IF l_thread_success and trans_count = 0
339: THEN
340: UPDATE hxc_data_sets
341: SET status = 'ON_LINE', validation_status = 'E'
342: WHERE data_set_id = p_data_set_id;
343:
344: ELSE

Line 691: FROM hxc_data_sets

687: SELECT start_date,
688: end_date
689: INTO l_data_set_start_date,
690: l_data_set_end_date
691: FROM hxc_data_sets
692: WHERE data_set_id = p_data_set_id;
693:
694: OPEN get_tcs ;
695: LOOP