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 369: -- Check if hxc_data_set_details table has records.

365: COMMIT;
366:
367:
368:
369: -- Check if hxc_data_set_details table has records.
370: -- ( Rownum condition put so that no FTS is issued by the DB.
371: -- We dont want the total count, just wanna know if it has atleast
372: -- one record )
373:

Line 377: FROM hxc_data_set_details;

373:
374: trans_count := 0;
375: SELECT COUNT(1)
376: INTO trans_count
377: FROM hxc_data_set_details;
378:
379: -- Done with the processing, update the data set status to OFFLINE.
380: IF l_thread_success AND trans_count = 0
381: THEN

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

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

Line 640: INSERT INTO hxc_data_set_details

636: tc_ovn_tab(i),
637: 'ARCHIVE-INCOMPLETE',
638: p_thread_id,
639: l_chunk_no);
640: INSERT INTO hxc_data_set_details
641: (data_set_id,
642: scope,
643: table_name,
644: row_count)