2207:
2208: -- populate phase_items table
2209: populate_phase_items(r_migration_data);
2210:
2211: -- delete the contents of hr_dm_exp_imps table
2212: -- if we are on the source database only
2213: IF (r_migration_data.database_location = 'S') THEN
2214: DELETE hr_dm_exp_imps;
2215: COMMIT;
2210:
2211: -- delete the contents of hr_dm_exp_imps table
2212: -- if we are on the source database only
2213: IF (r_migration_data.database_location = 'S') THEN
2214: DELETE hr_dm_exp_imps;
2215: COMMIT;
2216: END IF;
2217:
2218: -- update status to completed