eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_ARCHIVE dependencies on HXC_DATA_SET_DETAILS

Line 134: DELETE FROM hxc_data_set_details;

130:
131: DELETE FROM hxc_ar_detail_log ;
132: DELETE FROM hxc_ar_tc_ids_temp;
133: DELETE FROM hxc_ar_trans_temp;
134: DELETE FROM hxc_data_set_details;
135:
136: l_bb_ctr := 0;
137:
138: -- Get timecards in this data set.

Line 362: -- Check if hxc_data_set_details table has records.

358: COMMIT;
359:
360:
361:
362: -- Check if hxc_data_set_details table has records.
363: -- ( Rownum condition put so that no FTS is issued by the DB.
364: -- We dont want the total count, just wanna know if it has atleast
365: -- one record )
366:

Line 370: FROM hxc_data_set_details;

366:
367: trans_count := 0;
368: SELECT COUNT(1)
369: INTO trans_count
370: FROM hxc_data_set_details;
371:
372: -- Done with the processing, update the data set status to OFFLINE.
373: IF l_thread_success AND trans_count = 0
374: THEN

Line 376: -- hxc_data_set_details, then mark the data set as OFF_LINE.

372: -- Done with the processing, update the data set status to OFFLINE.
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:

Line 597: INSERT INTO hxc_data_set_details

593: tc_ovn_tab(i),
594: 'ARCHIVE-INCOMPLETE',
595: p_thread_id,
596: l_chunk_no);
597: INSERT INTO hxc_data_set_details
598: (data_set_id,
599: scope,
600: table_name,
601: row_count)