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

380: IF l_thread_success AND trans_count = 0
381: THEN
382: -- If all threads finished successfully and there is no data left in
383: -- hxc_data_set_details, then mark the data set as OFF_LINE.
384: UPDATE hxc_data_sets
385: SET status = 'OFF_LINE', validation_status = ' '
386: WHERE data_set_id = p_data_set_id;
387:
388: ELSE

Line 790: FROM hxc_data_sets

786: SELECT start_date,
787: end_date
788: INTO l_data_set_start_date,
789: l_data_set_end_date
790: FROM hxc_data_sets
791: WHERE data_set_id = p_data_set_id;
792:
793: OPEN get_tcs ;
794: LOOP