1: package body hr_dm_copy as
2: /* $Header: perdmcp.pkb 115.18 2002/03/07 08:51:10 pkm ship $ */
3:
4: --
5: ---------------------------- get_schema -----------------------------
62: l_schema varchar2(30);
63:
64: begin
65:
66: hr_dm_utility.message('ROUT','entry:hr_dm_copy.delete_datapump_tables', 5);
67:
68: -- get schema for PER
69: l_schema := get_schema('PER');
70:
183: 'Problem with constraint HR_PUMP_REQUESTS_FK1 - enable', 5);
184: end;
185:
186:
187: hr_dm_utility.message('ROUT','exit:hr_dm_copy.delete_datapump_tables', 35);
188:
189:
190:
191: exception
189:
190:
191: exception
192: when others then
193: hr_dm_utility.error(SQLCODE,'hr_dm_copy.delete_datapump_tables',
194: '(none)','R');
195: raise;
196: end delete_datapump_tables;
197:
246:
247:
248:
249: begin
250: hr_dm_utility.message('ROUT','entry:hr_dm_copy.source_copy', 5);
251: hr_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id ||
252: ')', 10);
253:
254:
1008:
1009: end if;
1010:
1011: commit;
1012: hr_dm_utility.message('ROUT','exit:hr_dm_copy.source_copy', 25);
1013: exception
1014: when others then
1015: hr_dm_utility.error(SQLCODE,'hr_dm_copy.source_copy',
1016: '(none)','R');
1011: commit;
1012: hr_dm_utility.message('ROUT','exit:hr_dm_copy.source_copy', 25);
1013: exception
1014: when others then
1015: hr_dm_utility.error(SQLCODE,'hr_dm_copy.source_copy',
1016: '(none)','R');
1017: raise;
1018: end source_copy;
1019:
1853:
1854: end destination_copy;
1855:
1856:
1857: end hr_dm_copy;