APPS.HR_DM_COPY dependencies on HR_DM_LIBRARY

Line 117: hr_dm_library.run_sql('truncate table ' || l_schema ||

113:
114: -- truncate datapump tables. call run_sql procedure to run
115: -- 'truncate ddl' command.
116: hr_dm_utility.message('INFO','Truncating table hr_pump_requests',10);
117: hr_dm_library.run_sql('truncate table ' || l_schema ||
118: '.hr_pump_requests');
119:
120: hr_dm_utility.message('INFO','Truncating table hr_pump_ranges',15);
121: hr_dm_library.run_sql('truncate table ' || l_schema ||

Line 121: hr_dm_library.run_sql('truncate table ' || l_schema ||

117: hr_dm_library.run_sql('truncate table ' || l_schema ||
118: '.hr_pump_requests');
119:
120: hr_dm_utility.message('INFO','Truncating table hr_pump_ranges',15);
121: hr_dm_library.run_sql('truncate table ' || l_schema ||
122: '.hr_pump_ranges');
123:
124: hr_dm_utility.message('INFO',
125: 'Truncating table hr_pump_batch_exceptions',20);

Line 126: hr_dm_library.run_sql('truncate table ' || l_schema ||

122: '.hr_pump_ranges');
123:
124: hr_dm_utility.message('INFO',
125: 'Truncating table hr_pump_batch_exceptions',20);
126: hr_dm_library.run_sql('truncate table ' || l_schema ||
127: '.hr_pump_batch_exceptions');
128:
129: hr_dm_utility.message('INFO',
130: 'Truncating table hr_pump_batch_line_user_keys',25);

Line 131: hr_dm_library.run_sql('truncate table ' || l_schema ||

127: '.hr_pump_batch_exceptions');
128:
129: hr_dm_utility.message('INFO',
130: 'Truncating table hr_pump_batch_line_user_keys',25);
131: hr_dm_library.run_sql('truncate table ' || l_schema ||
132: '.hr_pump_batch_line_user_keys');
133:
134: hr_dm_utility.message('INFO','Truncating table hr_pump_batch_lines',26);
135: hr_dm_library.run_sql('truncate table ' || l_schema ||

Line 135: hr_dm_library.run_sql('truncate table ' || l_schema ||

131: hr_dm_library.run_sql('truncate table ' || l_schema ||
132: '.hr_pump_batch_line_user_keys');
133:
134: hr_dm_utility.message('INFO','Truncating table hr_pump_batch_lines',26);
135: hr_dm_library.run_sql('truncate table ' || l_schema ||
136: '.hr_pump_batch_lines');
137:
138: hr_dm_utility.message('INFO',
139: 'Truncating table hr_pump_batch_headers',30);

Line 140: hr_dm_library.run_sql('truncate table ' || l_schema ||

136: '.hr_pump_batch_lines');
137:
138: hr_dm_utility.message('INFO',
139: 'Truncating table hr_pump_batch_headers',30);
140: hr_dm_library.run_sql('truncate table ' || l_schema ||
141: '.hr_pump_batch_headers');
142:
143:
144: -- enable foreign keys so we can do the truncates

Line 1203: hr_dm_library.run_sql('truncate table ' || l_schema ||

1199:
1200: hr_utility.trace('Importing migration details...');
1201: hr_utility.trace(l_cr);
1202: hr_utility.trace(' Truncating hr_dm_dt_deletes');
1203: hr_dm_library.run_sql('truncate table ' || l_schema ||
1204: '.hr_dm_dt_deletes');
1205:
1206: hr_utility.trace(' Setting g_data_migrator_mode to Y');
1207: hr_general.g_data_migrator_mode:='Y';