APPS.HR_DM_COPY dependencies on HR_DM_EXP_MIGRATIONS_V

Line 206: -- into HR_DM_EXP_MIGRATIONS_V view based on HR_DM_EXP_IMPS table

202: -- o Insert the data migrator packages rows from HR_API_MODULES
203: -- table into HR_DM_EXP_API_MODULES_V view based on
204: -- HR_DM_EXP_IMPS table.
205: -- o Insert the current migration row from HR_DM_MIGRATIONS tables
206: -- into HR_DM_EXP_MIGRATIONS_V view based on HR_DM_EXP_IMPS table
207: -- o Inserts the rows for the business_group_id being copied
208: -- from HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION,
209: -- HR_ALL_ORGANIZATION_UNITS_TL, HR_LOCATIONS_ALL and
210: -- HR_LOCATIONS_ALL_TL into HR_DM_EXP_IMPS for a FW migration

Line 300: -- into HR_DM_EXP_MIGRATIONS_V view based on HR_DM_EXP_IMPS table

296: end if;
297:
298:
299: -- Insert the current migration row from HR_DM_MIGRATIONS tables
300: -- into HR_DM_EXP_MIGRATIONS_V view based on HR_DM_EXP_IMPS table
301:
302: hr_dm_utility.message('INFO','Inserting row into hr_dm_exp_migrations_v',20);
303: insert into hr_dm_exp_migrations_v ( exp_imp_id
304: ,table_name

Line 302: hr_dm_utility.message('INFO','Inserting row into hr_dm_exp_migrations_v',20);

298:
299: -- Insert the current migration row from HR_DM_MIGRATIONS tables
300: -- into HR_DM_EXP_MIGRATIONS_V view based on HR_DM_EXP_IMPS table
301:
302: hr_dm_utility.message('INFO','Inserting row into hr_dm_exp_migrations_v',20);
303: insert into hr_dm_exp_migrations_v ( exp_imp_id
304: ,table_name
305: ,migration_id
306: ,source_database_instance

Line 303: insert into hr_dm_exp_migrations_v ( exp_imp_id

299: -- Insert the current migration row from HR_DM_MIGRATIONS tables
300: -- into HR_DM_EXP_MIGRATIONS_V view based on HR_DM_EXP_IMPS table
301:
302: hr_dm_utility.message('INFO','Inserting row into hr_dm_exp_migrations_v',20);
303: insert into hr_dm_exp_migrations_v ( exp_imp_id
304: ,table_name
305: ,migration_id
306: ,source_database_instance
307: ,destination_database_instance

Line 348: from hr_dm_exp_migrations_v v

344: ,to_char(creation_date,'YYYYMMDD HH24:MI:SS')
345: from hr_dm_migrations dm
346: where migration_id = p_migration_id
347: and not exists (select null
348: from hr_dm_exp_migrations_v v
349: where v.migration_id = dm.migration_id);
350:
351:
352: -- find the business_group_id and migration type for the current migration

Line 1070: from hr_dm_exp_migrations_v;

1066: destination_database_instance,
1067: hr_general.decode_lookup('HR_DM_MIGRATION_TYPE',migration_type),
1068: business_group_name,
1069: migration_start_date
1070: from hr_dm_exp_migrations_v;
1071:
1072: cursor csr_bg_check is
1073: select business_group_id
1074: from per_business_groups

Line 1288: -- into HR_DM_EXP_MIGRATIONS_V view based on HR_DM_EXP_IMPS table

1284:
1285:
1286: hr_utility.trace('call insert into hr_dm_migrations');
1287: -- Insert the current migration row from HR_DM_MIGRATIONS tables
1288: -- into HR_DM_EXP_MIGRATIONS_V view based on HR_DM_EXP_IMPS table
1289:
1290: select hr_dm_migrations_s.nextval
1291: into l_migration_id
1292: from dual;

Line 1332: from hr_dm_exp_migrations_v;

1328: ,last_updated_by
1329: ,last_update_login
1330: ,created_by
1331: ,to_date(creation_date,'YYYYMMDD HH24:MI:SS')
1332: from hr_dm_exp_migrations_v;
1333:
1334:
1335:
1336: