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_SETS

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 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 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 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