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_RESTORE_PROCESS dependencies on HXC_DATA_SET

Line 41: IF NOT (hxc_data_set.validate_data_set_range(

37: -- check if the range of the data set does not overlap with an existing data set.
38: -- if it does we stop the process
39: fnd_file.put_line(fnd_file.LOG,'--- >Before validating Data Set range and unique name');
40:
41: IF NOT (hxc_data_set.validate_data_set_range(
42: p_data_set_name => p_data_set_name,
43: p_start_date => l_start_date,
44: p_stop_date => l_stop_date)) THEN
45: retcode := 2;

Line 49: fnd_file.put_line(fnd_file.LOG,'--- >Before inserting the record into HXC_DATA_SETS table');

45: retcode := 2;
46: return;
47: END IF;
48:
49: fnd_file.put_line(fnd_file.LOG,'--- >Before inserting the record into HXC_DATA_SETS table');
50: --
51: -- insert into the data set.
52: --
53: hxc_data_set.insert_into_data_set(l_data_set_id,

Line 53: hxc_data_set.insert_into_data_set(l_data_set_id,

49: fnd_file.put_line(fnd_file.LOG,'--- >Before inserting the record into HXC_DATA_SETS table');
50: --
51: -- insert into the data set.
52: --
53: hxc_data_set.insert_into_data_set(l_data_set_id,
54: p_data_set_name,
55: p_description,
56: l_start_date,
57: l_stop_date,

Line 62: hxc_data_set.show_data_set;

58: 'MARKING_IN_PROGRESS');
59:
60: fnd_file.put_line(fnd_file.LOG,'--- > New Data Set id is: '||l_data_set_id);
61:
62: hxc_data_set.show_data_set;
63:
64: fnd_file.put_line(fnd_file.LOG,'--- > Marking the tables with the data set');
65:
66: --

Line 69: hxc_data_set.mark_tables_with_data_set

65:
66: --
67: -- Mark the tables with the data set
68: --
69: hxc_data_set.mark_tables_with_data_set
70: (p_data_set_id => l_data_set_id,
71: p_start_date => l_start_date,
72: p_stop_date => l_stop_date);
73:

Line 75: update hxc_data_sets

71: p_start_date => l_start_date,
72: p_stop_date => l_stop_date);
73:
74: -- finally update the data set to be ON_LINE
75: update hxc_data_sets
76: set status = 'ON_LINE'
77: where data_set_id = l_data_set_id;
78:
79: fnd_file.put_line(fnd_file.LOG,'--- > End process ');

Line 104: l_data_set_name hxc_data_sets.data_set_name%type;

100: retcode OUT NOCOPY NUMBER,
101: p_data_set_id IN NUMBER)
102: IS
103:
104: l_data_set_name hxc_data_sets.data_set_name%type;
105: l_description hxc_data_sets.description%type;
106: l_start_date hxc_data_sets.start_date%type;
107: l_stop_date hxc_data_sets.end_date%type;
108: l_data_set_mode hxc_data_sets.data_set_mode%type;

Line 105: l_description hxc_data_sets.description%type;

101: p_data_set_id IN NUMBER)
102: IS
103:
104: l_data_set_name hxc_data_sets.data_set_name%type;
105: l_description hxc_data_sets.description%type;
106: l_start_date hxc_data_sets.start_date%type;
107: l_stop_date hxc_data_sets.end_date%type;
108: l_data_set_mode hxc_data_sets.data_set_mode%type;
109: l_status hxc_data_sets.status%type;

Line 106: l_start_date hxc_data_sets.start_date%type;

102: IS
103:
104: l_data_set_name hxc_data_sets.data_set_name%type;
105: l_description hxc_data_sets.description%type;
106: l_start_date hxc_data_sets.start_date%type;
107: l_stop_date hxc_data_sets.end_date%type;
108: l_data_set_mode hxc_data_sets.data_set_mode%type;
109: l_status hxc_data_sets.status%type;
110: l_validation_status hxc_data_sets.validation_status%type;

Line 107: l_stop_date hxc_data_sets.end_date%type;

103:
104: l_data_set_name hxc_data_sets.data_set_name%type;
105: l_description hxc_data_sets.description%type;
106: l_start_date hxc_data_sets.start_date%type;
107: l_stop_date hxc_data_sets.end_date%type;
108: l_data_set_mode hxc_data_sets.data_set_mode%type;
109: l_status hxc_data_sets.status%type;
110: l_validation_status hxc_data_sets.validation_status%type;
111: l_found_data_set BOOLEAN := FALSE;

Line 108: l_data_set_mode hxc_data_sets.data_set_mode%type;

104: l_data_set_name hxc_data_sets.data_set_name%type;
105: l_description hxc_data_sets.description%type;
106: l_start_date hxc_data_sets.start_date%type;
107: l_stop_date hxc_data_sets.end_date%type;
108: l_data_set_mode hxc_data_sets.data_set_mode%type;
109: l_status hxc_data_sets.status%type;
110: l_validation_status hxc_data_sets.validation_status%type;
111: l_found_data_set BOOLEAN := FALSE;
112:

Line 109: l_status hxc_data_sets.status%type;

105: l_description hxc_data_sets.description%type;
106: l_start_date hxc_data_sets.start_date%type;
107: l_stop_date hxc_data_sets.end_date%type;
108: l_data_set_mode hxc_data_sets.data_set_mode%type;
109: l_status hxc_data_sets.status%type;
110: l_validation_status hxc_data_sets.validation_status%type;
111: l_found_data_set BOOLEAN := FALSE;
112:
113:

Line 110: l_validation_status hxc_data_sets.validation_status%type;

106: l_start_date hxc_data_sets.start_date%type;
107: l_stop_date hxc_data_sets.end_date%type;
108: l_data_set_mode hxc_data_sets.data_set_mode%type;
109: l_status hxc_data_sets.status%type;
110: l_validation_status hxc_data_sets.validation_status%type;
111: l_found_data_set BOOLEAN := FALSE;
112:
113:
114: BEGIN

Line 119: hxc_data_set.get_data_set_info

115:
116: --
117: -- get the data set information
118: --
119: hxc_data_set.get_data_set_info
120: (p_data_set_id => p_data_set_id,
121: p_data_set_name => l_data_set_name,
122: p_description => l_description,
123: p_start_date => l_start_date,

Line 159: hxc_data_set.undo_define_data_set(p_data_set_id => p_data_set_id);

155:
156: --
157: -- Undo define data set
158: --
159: hxc_data_set.undo_define_data_set(p_data_set_id => p_data_set_id);
160:
161:
162: EXCEPTION
163: WHEN others THEN

Line 188: hxc_data_set.validate_data_set (p_data_set_id,

184:
185: --
186: -- validate the data set
187: --
188: hxc_data_set.validate_data_set (p_data_set_id,
189: l_error_count,
190: false
191: );
192:

Line 279: l_data_set_name VARCHAR2(80);-- hxc_data_sets.data_set_name%type;

275:
276:
277: l_data_set_start_date date;
278: l_data_set_end_date date;
279: l_data_set_name VARCHAR2(80);-- hxc_data_sets.data_set_name%type;
280: l_description hxc_data_sets.description%type;
281: l_data_set_mode hxc_data_sets.data_set_mode%type;
282: l_current_status hxc_data_sets.status%type;
283: l_validation_status hxc_data_sets.validation_status%type;

Line 280: l_description hxc_data_sets.description%type;

276:
277: l_data_set_start_date date;
278: l_data_set_end_date date;
279: l_data_set_name VARCHAR2(80);-- hxc_data_sets.data_set_name%type;
280: l_description hxc_data_sets.description%type;
281: l_data_set_mode hxc_data_sets.data_set_mode%type;
282: l_current_status hxc_data_sets.status%type;
283: l_validation_status hxc_data_sets.validation_status%type;
284: l_found_data_set BOOLEAN := FALSE;

Line 281: l_data_set_mode hxc_data_sets.data_set_mode%type;

277: l_data_set_start_date date;
278: l_data_set_end_date date;
279: l_data_set_name VARCHAR2(80);-- hxc_data_sets.data_set_name%type;
280: l_description hxc_data_sets.description%type;
281: l_data_set_mode hxc_data_sets.data_set_mode%type;
282: l_current_status hxc_data_sets.status%type;
283: l_validation_status hxc_data_sets.validation_status%type;
284: l_found_data_set BOOLEAN := FALSE;
285:

Line 282: l_current_status hxc_data_sets.status%type;

278: l_data_set_end_date date;
279: l_data_set_name VARCHAR2(80);-- hxc_data_sets.data_set_name%type;
280: l_description hxc_data_sets.description%type;
281: l_data_set_mode hxc_data_sets.data_set_mode%type;
282: l_current_status hxc_data_sets.status%type;
283: l_validation_status hxc_data_sets.validation_status%type;
284: l_found_data_set BOOLEAN := FALSE;
285:
286: l_error_count NUMBER;

Line 283: l_validation_status hxc_data_sets.validation_status%type;

279: l_data_set_name VARCHAR2(80);-- hxc_data_sets.data_set_name%type;
280: l_description hxc_data_sets.description%type;
281: l_data_set_mode hxc_data_sets.data_set_mode%type;
282: l_current_status hxc_data_sets.status%type;
283: l_validation_status hxc_data_sets.validation_status%type;
284: l_found_data_set BOOLEAN := FALSE;
285:
286: l_error_count NUMBER;
287: l_data_set_lock BOOLEAN;

Line 295: hxc_data_set.get_data_set_info

291:
292: --
293: -- get the data set information
294: --
295: hxc_data_set.get_data_set_info
296: (p_data_set_id => p_data_set_id,
297: p_data_set_name => l_data_set_name,
298: p_description => l_description,
299: p_start_date => l_data_set_start_date,

Line 403: -- Answer : We should not populate the hxc_data_set_details table because

399: end if;
400: */
401: ----------------------------------------------------------------------------
402: -- Question : What should we do in case of rerun ?
403: -- Answer : We should not populate the hxc_data_set_details table because
404: -- some records may have already been transferred during the previous
405: -- runs. Also the first run of Archive has already populated the
406: -- hxc_data_set_details with the correct number of records.
407: ----------------------------------------------------------------------------

Line 406: -- hxc_data_set_details with the correct number of records.

402: -- Question : What should we do in case of rerun ?
403: -- Answer : We should not populate the hxc_data_set_details table because
404: -- some records may have already been transferred during the previous
405: -- runs. Also the first run of Archive has already populated the
406: -- hxc_data_set_details with the correct number of records.
407: ----------------------------------------------------------------------------
408:
409: IF l_rerun = 'N' THEN
410:

Line 428: --fnd_file.put_line(fnd_file.LOG,'--- >Before populating the hxc_data_set_details table with table counts');

424: RETURN;
425:
426: END IF;
427:
428: --fnd_file.put_line(fnd_file.LOG,'--- >Before populating the hxc_data_set_details table with table counts');
429: --hxc_archive_restore_utils.populate_hxc_data_set_details(p_data_set_id);
430: END IF;
431:
432:

Line 429: --hxc_archive_restore_utils.populate_hxc_data_set_details(p_data_set_id);

425:
426: END IF;
427:
428: --fnd_file.put_line(fnd_file.LOG,'--- >Before populating the hxc_data_set_details table with table counts');
429: --hxc_archive_restore_utils.populate_hxc_data_set_details(p_data_set_id);
430: END IF;
431:
432:
433:

Line 450: hxc_data_set.mark_tables_with_data_set

446: -- Backup Table count snapshot
447: -- Count Snapshot check.
448:
449:
450: hxc_data_set.mark_tables_with_data_set
451: (p_data_set_id => p_data_set_id,
452: p_start_date => l_data_set_start_date,
453: p_stop_date => l_data_set_end_date);
454:

Line 458: hxc_data_set.lock_data_set

454:
455:
456: l_data_set_lock := FALSE;
457:
458: hxc_data_set.lock_data_set
459: (p_data_set_id => p_data_set_id,
460: p_start_date => l_data_set_start_date,
461: p_stop_date => l_data_set_end_date,
462: p_data_set_lock => l_data_set_lock);

Line 470: hxc_data_set.validate_data_set (p_data_set_id => p_data_set_id,

466: retcode := 2;
467: RETURN;
468: END IF;
469:
470: hxc_data_set.validate_data_set (p_data_set_id => p_data_set_id,
471: p_error_count => l_error_count,
472: p_all_errors => true);
473:
474: hxc_archive_restore_utils.core_table_count_snapshot

Line 520: hxc_data_set.release_lock_data_set(p_data_set_id);

516:
517:
518: /*
519:
520: hxc_data_set.release_lock_data_set(p_data_set_id);
521:
522: hxc_archive_restore_utils.core_table_count_snapshot
523: (p_tbb_count => l_tbb_count_2,
524: p_tau_count => l_tau_count_2,

Line 600: hxc_data_set.release_lock_data_set(p_data_set_id);

596: EXCEPTION
597:
598: WHEN e_chunk_count THEN
599: fnd_file.put_line(fnd_file.LOG,'=== > WRONG COUNT IN THE CHUNK');
600: hxc_data_set.release_lock_data_set(p_data_set_id);
601: ROLLBACK;
602: retcode := 2;
603:
604:

Line 669: l_data_set_name hxc_data_sets.data_set_name%type;

665:
666:
667: l_data_set_start_date date;
668: l_data_set_end_date date;
669: l_data_set_name hxc_data_sets.data_set_name%type;
670: l_description hxc_data_sets.description%type;
671: l_data_set_mode hxc_data_sets.data_set_mode%type;
672: l_current_status hxc_data_sets.status%type;
673: l_validation_status hxc_data_sets.validation_status%type;

Line 670: l_description hxc_data_sets.description%type;

666:
667: l_data_set_start_date date;
668: l_data_set_end_date date;
669: l_data_set_name hxc_data_sets.data_set_name%type;
670: l_description hxc_data_sets.description%type;
671: l_data_set_mode hxc_data_sets.data_set_mode%type;
672: l_current_status hxc_data_sets.status%type;
673: l_validation_status hxc_data_sets.validation_status%type;
674: l_found_data_set BOOLEAN := FALSE;

Line 671: l_data_set_mode hxc_data_sets.data_set_mode%type;

667: l_data_set_start_date date;
668: l_data_set_end_date date;
669: l_data_set_name hxc_data_sets.data_set_name%type;
670: l_description hxc_data_sets.description%type;
671: l_data_set_mode hxc_data_sets.data_set_mode%type;
672: l_current_status hxc_data_sets.status%type;
673: l_validation_status hxc_data_sets.validation_status%type;
674: l_found_data_set BOOLEAN := FALSE;
675:

Line 672: l_current_status hxc_data_sets.status%type;

668: l_data_set_end_date date;
669: l_data_set_name hxc_data_sets.data_set_name%type;
670: l_description hxc_data_sets.description%type;
671: l_data_set_mode hxc_data_sets.data_set_mode%type;
672: l_current_status hxc_data_sets.status%type;
673: l_validation_status hxc_data_sets.validation_status%type;
674: l_found_data_set BOOLEAN := FALSE;
675:
676:

Line 673: l_validation_status hxc_data_sets.validation_status%type;

669: l_data_set_name hxc_data_sets.data_set_name%type;
670: l_description hxc_data_sets.description%type;
671: l_data_set_mode hxc_data_sets.data_set_mode%type;
672: l_current_status hxc_data_sets.status%type;
673: l_validation_status hxc_data_sets.validation_status%type;
674: l_found_data_set BOOLEAN := FALSE;
675:
676:
677: BEGIN

Line 683: hxc_data_set.get_data_set_info

679:
680: --
681: -- get the data set information
682: --
683: hxc_data_set.get_data_set_info
684: (p_data_set_id => p_data_set_id,
685: p_data_set_name => l_data_set_name,
686: p_description => l_description,
687: p_start_date => l_data_set_start_date,

Line 996: FROM hxc_data_set_details

992: -- no need of the exact count, hence the rownum condition.
993:
994: SELECT count(1)
995: INTO l_count
996: FROM hxc_data_set_details
997: WHERE ROWNUM < 2 ;
998:
999: IF l_count >= 1
1000: THEN