DBA Data[Home] [Help]

APPS.HR_DM_INIT dependencies on HR_DM_RESOLVE_PKS

Line 1380: -- The table hr_dm_resolve_pks has entries for migrations from the current

1376: -- Description: The phase items for the upload phase are seeded
1377: -- into the hr_dm_phase_items. An entry is made for each group that is
1378: -- applicable for the current migration.
1379: --
1380: -- The table hr_dm_resolve_pks has entries for migrations from the current
1381: -- source database deleted for an FW or SR migration.
1382: --
1383: -- Input Parameters
1384: -- r_migration_data - record containing migration information

Line 1516: 'Deleting hr_dm_resolve_pks table for source database' ||

1512:
1513:
1514: IF r_migration_data.migration_type in ('FW','SR') THEN
1515: hr_dm_utility.message('INFO',
1516: 'Deleting hr_dm_resolve_pks table for source database' ||
1517: ' for FW or SR migration', 15);
1518: DELETE FROM hr_dm_resolve_pks
1519: WHERE source_database_instance = r_migration_data.source_database_instance;
1520: END IF;

Line 1518: DELETE FROM hr_dm_resolve_pks

1514: IF r_migration_data.migration_type in ('FW','SR') THEN
1515: hr_dm_utility.message('INFO',
1516: 'Deleting hr_dm_resolve_pks table for source database' ||
1517: ' for FW or SR migration', 15);
1518: DELETE FROM hr_dm_resolve_pks
1519: WHERE source_database_instance = r_migration_data.source_database_instance;
1520: END IF;
1521:
1522: IF r_migration_data.migration_type = 'A' THEN

Line 1524: 'Deleting hr_dm_resolve_pks table for source database' ||

1520: END IF;
1521:
1522: IF r_migration_data.migration_type = 'A' THEN
1523: hr_dm_utility.message('INFO',
1524: 'Deleting hr_dm_resolve_pks table for source database' ||
1525: ' for A migration and NR_NAVIGATION_UNITS data', 15);
1526: DELETE FROM hr_dm_resolve_pks
1527: WHERE source_database_instance = r_migration_data.source_database_instance
1528: AND TABLE_NAME = 'HR_NAVIGATION_UNITS';

Line 1526: DELETE FROM hr_dm_resolve_pks

1522: IF r_migration_data.migration_type = 'A' THEN
1523: hr_dm_utility.message('INFO',
1524: 'Deleting hr_dm_resolve_pks table for source database' ||
1525: ' for A migration and NR_NAVIGATION_UNITS data', 15);
1526: DELETE FROM hr_dm_resolve_pks
1527: WHERE source_database_instance = r_migration_data.source_database_instance
1528: AND TABLE_NAME = 'HR_NAVIGATION_UNITS';
1529: END IF;
1530: