[Home] [Help]
8: /*---------------------------- PUBLIC ROUTINES ------------------------------*/
9:
10: -- ------------------------- main ------------------------
11: -- Description: This is the download phase slave. It reads an item from the
12: -- hr_dm_migration_ranges table and calls the appropriate TDS package
13: -- download procedure to download the data into data pump interface table i.e.
14: -- hr_pump_batch_lines.
15: --
16: --
75: tbl.short_name,
76: pi_dn.batch_id
77: from hr_dm_phase_items pi_dn,
78: hr_dm_tables tbl,
79: hr_dm_migration_ranges mr,
80: hr_dm_phase_items pi_rg
81: where pi_rg.phase_id = l_range_phase_id
82: and pi_rg.phase_item_id = mr.phase_item_id
83: and mr.status = 'NS'
215: -- close the cursor.
216: dbms_sql.close_cursor(l_cursor);
217:
218: -- update the no of records downloaded for the range.
219: update hr_dm_migration_ranges
220: set row_count = l_no_of_rec_downloaded
221: where range_id = l_table_range_rec.range_id;
222:
223: -- update status to completed