320: --end insert details
321: --
322:
323:
324: -- update table hr_dm_migration_requests
325: hr_dm_master.insert_request(p_phase => 'DA',
326: p_request_id => l_request_id,
327: p_master_slave => 'S',
328: p_migration_id => p_migration_id,
459:
460:
461: CURSOR csr_req_id IS
462: SELECT request_id
463: FROM hr_dm_migration_requests
464: WHERE phase_item_id = l_phase_item_id
465: AND enabled_flag = 'Y';
466:
467: -- get the migration details