1 PACKAGE hr_dm_copy AUTHID CURRENT_USER AS
2 /* $Header: perdmcp.pkh 115.9 2002/03/07 08:51:12 pkm ship $ */
3
4 --
5 ----------------------- delete_datapump_tables ----------------------
6 -- This procedure truncates the following datapump tables
7 -- hr_pump_batch_header
8 -- hr_pump_batch_lines
9 -- hr_pump_requests
10 -- hr_pump_ranges
11 -- hr_pump_batch_exceptions
12 ---------------------------------------------------------------------
13 PROCEDURE delete_datapump_tables ;
14
15
16 ----------------------- source_copy ---------------------------------
17 -- This procedure does some of the tasks of Copy phase in source
18 -- database. It does the following :
19 -- o Insert the data migrator packages rows from HR_API_MODULES
20 -- table into HR_DM_EXP_API_MODULES_V view based on
21 -- HR_DM_EXP_IMP table.
22 -- o Insert the current migration row from HR_DM_MIGRATIONS tables
23 -- into HR_DM_EXP_MIGRATIONS_V view based on HR_DM_EXP_IMP table
24 -- Input Parameters :
25 -- p_migration_id - Migration Id of the current migration. Primary
26 -- key on hr_dm_migrations table.
27 -- p_last_migration_date - last migration date
28 -- Called By : Main controller in source database
29 ---------------------------------------------------------------------
30 PROCEDURE source_copy (p_migration_id number,
31 p_last_migration_date date);
32
33
34 ----------------------- destination_copy ---------------------------------
35 -- This procedure does some of the tasks of Copy phase in destination
36 -- database. It does the following :
37 -- o Call procedure delete_datapump_tables to truncate datapump
38 -- tables at destination.
39 -- o Delete the data migrator packages rows from HR_API_MODULES table
40 -- i.e where API_MODULE_TYPE = 'DM'.
41 -- o Insert the rows into HR_API_MODULES tables from HR_DM_EXP_API_MODULES_V
42 -- view based on HR_DM_EXP_IMP table
43 -- o Insert the row into HR_DM_MIGRATION table from HR_DM_EXP_MIGRATIONS_V
44 -- view based on HR_DM_EXP_IMP table.
45 -- Input Parameters :
46 -- p_migration_id - Migration Id of the current migration. Primary
47 -- key on hr_dm_migrations table.
48 -- Called By : Run manually at destination database
49 ---------------------------------------------------------------------
50 PROCEDURE destination_copy;
51
52 --
53
54
55 END hr_dm_copy;