[Home] [Help]
69:
70:
71: -- ------------------------- populate_pi_table_i ------------------------
72: -- Description: The phase items for the initialization phase are seeded
73: -- into the hr_dm_phase_items. (currently none required)
74: --
75: --
76: -- Input Parameters
77: -- r_migration_data - record containing migration information
119: --
120:
121: -- ------------------------- populate_pi_table_g ------------------------
122: -- Description: The phase items for the generator phase are seeded
123: -- into the hr_dm_phase_items.
124: --
125: --
126: -- Input Parameters
127: -- r_migration_data - record containing migration information
266: LOOP
267: FETCH csr_select_pi INTO l_loader_name, l_group_id, l_table_name;
268: EXIT WHEN csr_select_pi%NOTFOUND;
269:
270: INSERT INTO hr_dm_phase_items (PHASE_ITEM_ID,
271: PHASE_ID,
272: LOADER_NAME,
273: BATCH_ID,
274: GROUP_ID,
280: CREATION_DATE,
281: LAST_UPDATED_BY,
282: LAST_UPDATE_DATE,
283: LAST_UPDATE_LOGIN)
284: SELECT hr_dm_phase_items_s.nextval,
285: l_phase_id,
286: l_loader_name,
287: NULL,
288: l_group_id,
296: SYSDATE,
297: NULL
298: FROM dual
299: WHERE NOT EXISTS
300: (SELECT NULL FROM hr_dm_phase_items
301: WHERE ((phase_id = l_phase_id)
302: AND (table_name = l_table_name)));
303:
304: COMMIT;
327:
328:
329: -- ------------------------- populate_pi_table_r ------------------------
330: -- Description: The phase items for the range phase are seeded
331: -- into the hr_dm_phase_items. An entry is made for each table within
332: -- a group that is applicable for the current migration.
333: --
334: --
335: -- Input Parameters
376: LOOP
377: FETCH csr_select_pi INTO l_group_id, l_table_name;
378: EXIT WHEN csr_select_pi%NOTFOUND;
379:
380: INSERT INTO hr_dm_phase_items (PHASE_ITEM_ID,
381: PHASE_ID,
382: LOADER_NAME,
383: BATCH_ID,
384: GROUP_ID,
390: CREATION_DATE,
391: LAST_UPDATED_BY,
392: LAST_UPDATE_DATE,
393: LAST_UPDATE_LOGIN)
394: SELECT hr_dm_phase_items_s.nextval,
395: l_phase_id,
396: NULL,
397: NULL,
398: l_group_id,
406: SYSDATE,
407: NULL
408: FROM dual
409: WHERE NOT EXISTS
410: (SELECT NULL FROM hr_dm_phase_items
411: WHERE ((phase_id = l_phase_id)
412: AND (table_name = l_table_name)));
413:
414: COMMIT;
502: END get_filename;
503: --
504:
505: -- --------------------------- seed_ua_da_data ---------------------------
506: -- Description: Seeds the passed data into the hr_dm_phase_items and the
507: -- hr_dm_loader_phase_items tables
508: --
509: --
510: -- Input Parameters
538:
539: hr_dm_utility.message('INFO','Seeding ' || p_param_rec.loader_name , 10);
540:
541: -- get phase_item_ids for ua and da phases
542: SELECT HR_DM_PHASE_ITEMS_S.nextval
543: INTO l_phase_item_id_da
544: FROM dual;
545: SELECT HR_DM_PHASE_ITEMS_S.nextval
546: INTO l_phase_item_id_ua
541: -- get phase_item_ids for ua and da phases
542: SELECT HR_DM_PHASE_ITEMS_S.nextval
543: INTO l_phase_item_id_da
544: FROM dual;
545: SELECT HR_DM_PHASE_ITEMS_S.nextval
546: INTO l_phase_item_id_ua
547: FROM dual;
548: -- hr_dm_phase_items da phase
549: INSERT INTO hr_dm_phase_items (PHASE_ITEM_ID,
544: FROM dual;
545: SELECT HR_DM_PHASE_ITEMS_S.nextval
546: INTO l_phase_item_id_ua
547: FROM dual;
548: -- hr_dm_phase_items da phase
549: INSERT INTO hr_dm_phase_items (PHASE_ITEM_ID,
550: PHASE_ID,
551: LOADER_NAME,
552: LOADER_PARAMS_ID,
545: SELECT HR_DM_PHASE_ITEMS_S.nextval
546: INTO l_phase_item_id_ua
547: FROM dual;
548: -- hr_dm_phase_items da phase
549: INSERT INTO hr_dm_phase_items (PHASE_ITEM_ID,
550: PHASE_ID,
551: LOADER_NAME,
552: LOADER_PARAMS_ID,
553: BATCH_ID,
566: 'NS',
567: NULL,
568: NULL
569: FROM dual;
570: -- hr_dm_phase_items da phase
571: INSERT INTO hr_dm_phase_items (PHASE_ITEM_ID,
572: PHASE_ID,
573: LOADER_NAME,
574: LOADER_PARAMS_ID,
567: NULL,
568: NULL
569: FROM dual;
570: -- hr_dm_phase_items da phase
571: INSERT INTO hr_dm_phase_items (PHASE_ITEM_ID,
572: PHASE_ID,
573: LOADER_NAME,
574: LOADER_PARAMS_ID,
575: BATCH_ID,
900:
901:
902: -- ------------------------- populate_pi_table_da ------------------------
903: -- Description: The phase items for the download aol phase are seeded
904: -- into the hr_dm_phase_items. An entry is made for each aol loader within
905: -- a group that is applicable for the current migration.
906: --
907: -- UA phase items are also seeded in this procedure.
908: --
1033:
1034: EXIT WHEN csr_select_pi%NOTFOUND;
1035:
1036: -- seed data for:
1037: -- 1. hr_dm_phase_items da phase
1038: -- 2. hr_dm_phase_items ua phase
1039: -- 3. hr_dm_loader_phase_items
1040:
1041: -- no data is automatically seeded when:
1034: EXIT WHEN csr_select_pi%NOTFOUND;
1035:
1036: -- seed data for:
1037: -- 1. hr_dm_phase_items da phase
1038: -- 2. hr_dm_phase_items ua phase
1039: -- 3. hr_dm_loader_phase_items
1040:
1041: -- no data is automatically seeded when:
1042: -- 1. l_check_custom_flex_call is not null
1174: --
1175:
1176: -- ------------------------- populate_pi_table_dp ------------------------
1177: -- Description: The phase items for the download phase are seeded
1178: -- into the hr_dm_phase_items. An entry is made for each group that is
1179: -- applicable for the current migration.
1180: --
1181: -- It also truncates the datapump tables
1182: --
1258: p_batch_name => l_batch_name,
1259: p_business_group_name => l_business_group_name,
1260: p_reference => 'HR Data Migrator');
1261:
1262: INSERT INTO hr_dm_phase_items (PHASE_ITEM_ID,
1263: PHASE_ID,
1264: LOADER_NAME,
1265: BATCH_ID,
1266: GROUP_ID,
1272: CREATION_DATE,
1273: LAST_UPDATED_BY,
1274: LAST_UPDATE_DATE,
1275: LAST_UPDATE_LOGIN)
1276: SELECT hr_dm_phase_items_s.nextval,
1277: l_phase_id,
1278: NULL,
1279: l_batch_id,
1280: l_group_id,
1288: SYSDATE,
1289: NULL
1290: FROM dual
1291: WHERE NOT EXISTS
1292: (SELECT NULL FROM hr_dm_phase_items
1293: WHERE ((phase_id = l_phase_id)
1294: AND (batch_id = l_batch_id)
1295: AND (group_id = l_group_id)));
1296:
1320: --
1321:
1322: -- ------------------------- populate_pi_table_cp ------------------------
1323: -- Description: The phase items for the copy phase are seeded
1324: -- into the hr_dm_phase_items. (none required)
1325: --
1326: --
1327: -- Input Parameters
1328: -- r_migration_data - record containing migration information
1373:
1374:
1375: -- ------------------------- populate_pi_table_up ------------------------
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.
1458: l_batch_end - l_batch_start);
1459: EXIT WHEN (csr_select_batch_id%NOTFOUND);
1460:
1461: IF (l_group_text = l_batch_txt) THEN
1462: INSERT INTO hr_dm_phase_items (PHASE_ITEM_ID,
1463: PHASE_ID,
1464: LOADER_NAME,
1465: BATCH_ID,
1466: GROUP_ID,
1472: CREATION_DATE,
1473: LAST_UPDATED_BY,
1474: LAST_UPDATE_DATE,
1475: LAST_UPDATE_LOGIN)
1476: SELECT hr_dm_phase_items_s.nextval,
1477: l_phase_id,
1478: NULL,
1479: l_batch_id,
1480: l_group_id,
1488: SYSDATE,
1489: NULL
1490: FROM dual
1491: WHERE NOT EXISTS
1492: (SELECT NULL FROM hr_dm_phase_items
1493: WHERE ((phase_id = l_phase_id)
1494: AND (batch_id = l_batch_id)
1495: AND (group_id = l_group_id)));
1496:
1549:
1550:
1551: -- ------------------------- populate_pi_table_ua ------------------------
1552: -- Description: The phase items for the upload aol phase are seeded
1553: -- into the hr_dm_phase_items. An entry is made for each aol loader within
1554: -- a group that is applicable for the current migration.
1555: --
1556: -- This data is now seeded in the populate_pi_table_da procedure.
1557: --
1628: --
1629:
1630: -- ------------------------- populate_pi_table_d ------------------------
1631: -- Description: The phase items for the delete phase are seeded
1632: -- into the hr_dm_phase_items. An entry is made for each group that is
1633: -- applicable for the current migration.
1634: --
1635: --
1636: -- Input Parameters
1678: LOOP
1679: FETCH csr_select_pi INTO l_group_id, l_group_text;
1680: EXIT WHEN csr_select_pi%NOTFOUND;
1681:
1682: INSERT INTO hr_dm_phase_items (PHASE_ITEM_ID,
1683: PHASE_ID,
1684: LOADER_NAME,
1685: BATCH_ID,
1686: GROUP_ID,
1692: CREATION_DATE,
1693: LAST_UPDATED_BY,
1694: LAST_UPDATE_DATE,
1695: LAST_UPDATE_LOGIN)
1696: SELECT hr_dm_phase_items_s.nextval,
1697: l_phase_id,
1698: NULL,
1699: NULL,
1700: l_group_id,
1708: SYSDATE,
1709: NULL
1710: FROM dual
1711: WHERE NOT EXISTS
1712: (SELECT NULL FROM hr_dm_phase_items
1713: WHERE ((phase_id = l_phase_id)
1714: AND (group_id = l_group_id)));
1715:
1716: COMMIT;
1738: --
1739:
1740: -- ------------------------- populate_pi_table_ua ------------------------
1741: -- Description: The phase items for the clean up phase are seeded
1742: -- into the hr_dm_phase_items. An entry is made for each aol loader within
1743: -- a group that is applicable for the current migration.
1744: --
1745: --
1746: -- Input Parameters
1799: LOOP
1800: FETCH csr_select_pi INTO l_loader_name, l_loader_params_id, l_group_id;
1801: EXIT WHEN csr_select_pi%NOTFOUND;
1802:
1803: INSERT INTO hr_dm_phase_items (PHASE_ITEM_ID,
1804: PHASE_ID,
1805: LOADER_NAME,
1806: LOADER_PARAMS_ID,
1807: BATCH_ID,
1814: CREATION_DATE,
1815: LAST_UPDATED_BY,
1816: LAST_UPDATE_DATE,
1817: LAST_UPDATE_LOGIN)
1818: SELECT hr_dm_phase_items_s.nextval,
1819: l_phase_id,
1820: l_loader_name,
1821: l_loader_params_id,
1822: NULL,
1831: SYSDATE,
1832: NULL
1833: FROM dual
1834: WHERE NOT EXISTS
1835: (SELECT NULL FROM hr_dm_phase_items
1836: WHERE ((phase_id = l_phase_id)
1837: AND (loader_name = l_loader_name)));
1838:
1839: COMMIT;