[Home] [Help]
17: begin
18:
19: select target_id
20: into l_target_id
21: from ben_dm_resolve_mappings
22: where resolve_mapping_id = p_resolve_mapping_id;
23:
24: return l_target_id;
25:
41: and name = c_source_key;
42:
43: cursor csr_get_all_apr is
44: select *
45: from ben_dm_resolve_mappings cm
46: where table_name = 'BEN_ACTL_PREM_F'
47: and target_id is null;
48:
49: -- Declare local variables
54: l_bg_id number;
55:
56: begin
57: --
58: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_ACTL_PREM_F.
59: --
60: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
61: for x in csr_get_all_apr loop
62:
79: -- <
80: null;
81: else
82: --
83: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
84: --
85: -- ben_dm_utility.message('PARA','(p_dk_apr - ' || l_table_rec.name ||')', 10);
86: ben_dm_data_util.update_pk_mapping
87: (p_resolve_mapping_id => x.resolve_mapping_id
107: ;
108:
109: cursor csr_get_all_eat is
110: select *
111: from ben_dm_resolve_mappings
112: where table_name = 'BEN_ACTN_TYP'
113: and target_id is null;
114:
115: -- Declare local variables
121:
122: begin
123:
124: --
125: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_ACTN_TYP
126: --
127: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
128: for x in csr_get_all_eat loop
129:
146: -- <
147: null;
148: else
149: --
150: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
151: --
152: ben_dm_utility.message('INFO','target : ' || l_table_rec.actn_typ_id,5) ;
153: ben_dm_utility.message('INFO','mapping : ' || x.resolve_mapping_id,5) ;
154:
176: and business_group_id = c_business_group_id;
177:
178: cursor csr_get_all_abr is
179: select *
180: from ben_dm_resolve_mappings
181: where table_name = 'BEN_ACTY_BASE_RT_F'
182: and target_id is null;
183:
184: -- Declare local variables
190:
191: begin
192:
193: --
194: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_ACTY_BASE_RT_F
195: --
196: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
197: for x in csr_get_all_abr loop
198: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
213: -- <
214: null;
215: else
216: --
217: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
218: --
219: ben_dm_data_util.update_pk_mapping
220: (p_resolve_mapping_id => x.resolve_mapping_id
221: ,p_target_id => l_table_rec.acty_base_rt_id);
238: ;
239:
240: cursor csr_get_all_bng is
241: select *
242: from ben_dm_resolve_mappings
243: where table_name = 'BEN_BENFTS_GRP'
244: and target_id is null;
245:
246: -- Declare local variables
252:
253: begin
254:
255: --
256: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_BENFTS_GRP
257: --
258: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
259: for x in csr_get_all_bng loop
260: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
275: -- <
276: null;
277: else
278: --
279: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
280: --
281: ben_dm_data_util.update_pk_mapping
282: (p_resolve_mapping_id => x.resolve_mapping_id
283: ,p_target_id => l_table_rec.benfts_grp_id);
301: and business_group_id = c_business_group_id;
302:
303: cursor csr_get_all_pll is
304: select *
305: from ben_dm_resolve_mappings
306: where table_name = 'PAY_ELEMENT_LINKS_F'
307: and target_id is null;
308:
309: -- Declare local variables
316:
317: begin
318:
319: --
320: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PAY_ELEMENT_LINKS_F
321: --
322: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
323: for x in csr_get_all_pll loop
324: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
347: -- <
348: null;
349: else
350: --
351: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
352: --
353: ben_dm_data_util.update_pk_mapping
354: (p_resolve_mapping_id => x.resolve_mapping_id
355: ,p_target_id => l_table_rec.element_link_id);
373: and business_group_id = c_business_group_id;
374:
375: cursor csr_get_all_bnb is
376: select *
377: from ben_dm_resolve_mappings
378: where table_name = 'BEN_BNFTS_BAL_F'
379: and target_id is null;
380:
381: -- Declare local variables
387:
388: begin
389:
390: --
391: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_BNFTS_BAL_F
392: --
393: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
394: for x in csr_get_all_bnb loop
395: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
410: -- <
411: null;
412: else
413: --
414: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
415: --
416: ben_dm_data_util.update_pk_mapping
417: (p_resolve_mapping_id => x.resolve_mapping_id
418: ,p_target_id => l_table_rec.bnfts_bal_id);
436: and business_group_id = c_business_group_id;
437:
438: cursor csr_get_all_bpp is
439: select *
440: from ben_dm_resolve_mappings
441: where table_name = 'BEN_BNFT_PRVDR_POOL_F'
442: and target_id is null;
443:
444: -- Declare local variables
450:
451: begin
452:
453: --
454: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_BNFT_PRVDR_POOL_F
455: --
456: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
457: for x in csr_get_all_bpp loop
458: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
473: -- <
474: null;
475: else
476: --
477: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
478: --
479: ben_dm_data_util.update_pk_mapping
480: (p_resolve_mapping_id => x.resolve_mapping_id
481: ,p_target_id => l_table_rec.bnft_prvdr_pool_id);
499: and business_group_id = c_business_group_id;
500:
501: cursor csr_get_all_cpl is
502: select *
503: from ben_dm_resolve_mappings
504: where table_name = 'BEN_CMBN_PLIP_F'
505: and target_id is null;
506:
507: -- Declare local variables
513:
514: begin
515:
516: --
517: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_CMBN_PLIP_F
518: --
519: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
520: for x in csr_get_all_cpl loop
521: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
536: -- <
537: null;
538: else
539: --
540: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
541: --
542: ben_dm_data_util.update_pk_mapping
543: (p_resolve_mapping_id => x.resolve_mapping_id
544: ,p_target_id => l_table_rec.cmbn_plip_id);
562: and business_group_id = c_business_group_id;
563:
564: cursor csr_get_all_cbp is
565: select *
566: from ben_dm_resolve_mappings
567: where table_name = 'BEN_CMBN_PTIP_F'
568: and target_id is null;
569:
570: -- Declare local variables
576:
577: begin
578:
579: --
580: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_CMBN_PTIP_F
581: --
582: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
583: for x in csr_get_all_cbp loop
584: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
599: -- <
600: null;
601: else
602: --
603: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
604: --
605: ben_dm_data_util.update_pk_mapping
606: (p_resolve_mapping_id => x.resolve_mapping_id
607: ,p_target_id => l_table_rec.cmbn_ptip_id);
625: and business_group_id = c_business_group_id;
626:
627: cursor csr_get_all_cpt is
628: select *
629: from ben_dm_resolve_mappings
630: where table_name = 'BEN_CMBN_PTIP_OPT_F'
631: and target_id is null;
632:
633: -- Declare local variables
639:
640: begin
641:
642: --
643: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_CMBN_PTIP_OPT_F
644: --
645: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
646: for x in csr_get_all_cpt loop
647: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
662: -- <
663: null;
664: else
665: --
666: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
667: --
668: ben_dm_data_util.update_pk_mapping
669: (p_resolve_mapping_id => x.resolve_mapping_id
670: ,p_target_id => l_table_rec.cmbn_ptip_opt_id);
688: ;
689:
690: cursor csr_get_all_bcr is
691: select *
692: from ben_dm_resolve_mappings
693: where table_name = 'BEN_CM_TRGR'
694: and target_id is null;
695:
696: -- Declare local variables
702:
703: begin
704:
705: --
706: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_CM_TRGR
707: --
708: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
709: for x in csr_get_all_bcr loop
710: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
725: -- <
726: null;
727: else
728: --
729: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
730: --
731: ben_dm_data_util.update_pk_mapping
732: (p_resolve_mapping_id => x.resolve_mapping_id
733: ,p_target_id => l_table_rec.cm_trgr_id);
751: and business_group_id = c_business_group_id;
752:
753: cursor csr_get_all_cct is
754: select *
755: from ben_dm_resolve_mappings
756: where table_name = 'BEN_CM_TYP_F'
757: and target_id is null;
758:
759: -- Declare local variables
765:
766: begin
767:
768: --
769: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_CM_TYP_F
770: --
771: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
772: for x in csr_get_all_cct loop
773: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
788: -- <
789: null;
790: else
791: --
792: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
793: --
794: ben_dm_data_util.update_pk_mapping
795: (p_resolve_mapping_id => x.resolve_mapping_id
796: ,p_target_id => l_table_rec.cm_typ_id);
815: ;
816:
817: cursor csr_get_all_clf is
818: select *
819: from ben_dm_resolve_mappings
820: where table_name = 'BEN_COMP_LVL_FCTR'
821: and target_id is null;
822:
823: -- Declare local variables
829:
830: begin
831:
832: --
833: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_COMP_LVL_FCTR
834: --
835: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
836: for x in csr_get_all_clf loop
837: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
852: -- <
853: null;
854: else
855: --
856: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
857: --
858: ben_dm_data_util.update_pk_mapping
859: (p_resolve_mapping_id => x.resolve_mapping_id
860: ,p_target_id => l_table_rec.comp_lvl_fctr_id);
878: and business_group_id = c_business_group_id;
879:
880: cursor csr_get_all_ccm is
881: select *
882: from ben_dm_resolve_mappings
883: where table_name = 'BEN_CVG_AMT_CALC_MTHD_F'
884: and target_id is null;
885:
886: -- Declare local variables
892:
893: begin
894:
895: --
896: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_CVG_AMT_CALC_MTHD_F
897: --
898: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
899: for x in csr_get_all_ccm loop
900: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
915: -- <
916: null;
917: else
918: --
919: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
920: --
921: ben_dm_data_util.update_pk_mapping
922: (p_resolve_mapping_id => x.resolve_mapping_id
923: ,p_target_id => l_table_rec.cvg_amt_calc_mthd_id);
945: ;
946:
947: cursor csr_get_all_enp is
948: select *
949: from ben_dm_resolve_mappings
950: where table_name = 'BEN_ENRT_PERD'
951: and target_id is null;
952:
953: cursor csr_get_dk_pop (c_pgm_id number, c_pl_id number, c_business_group_id number) is
971:
972: begin
973:
974: --
975: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_ENRT_PERD
976: --
977: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
978: for x in csr_get_all_enp loop
979: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
1017: -- <
1018: null;
1019: else
1020: --
1021: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
1022: --
1023: ben_dm_data_util.update_pk_mapping
1024: (p_resolve_mapping_id => x.resolve_mapping_id
1025: ,p_target_id => l_table_rec.enrt_perd_id);
1047: and business_group_id = c_business_group_id;
1048:
1049: cursor csr_get_all_len is
1050: select *
1051: from ben_dm_resolve_mappings
1052: where table_name = 'BEN_LEE_RSN_F'
1053: and target_id is null;
1054:
1055: cursor csr_get_dk_pop (c_pgm_id number, c_pl_id number, c_business_group_id number) is
1072:
1073: begin
1074:
1075: --
1076: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_ENRT_PERD
1077: --
1078: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1079: for x in csr_get_all_len loop
1080: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
1120: -- <
1121: null;
1122: else
1123: --
1124: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
1125: --
1126: ben_dm_data_util.update_pk_mapping
1127: (p_resolve_mapping_id => x.resolve_mapping_id
1128: ,p_target_id => l_table_rec.lee_rsn_id);
1146: and business_group_id = c_business_group_id;
1147:
1148: cursor csr_get_all_ler is
1149: select *
1150: from ben_dm_resolve_mappings
1151: where table_name = 'BEN_LER_F'
1152: and target_id is null;
1153:
1154: -- Declare local variables
1160:
1161: begin
1162:
1163: --
1164: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_LER_F
1165: --
1166: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1167: for x in csr_get_all_ler loop
1168: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
1183: -- <
1184: null;
1185: else
1186: --
1187: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
1188: --
1189: ben_dm_data_util.update_pk_mapping
1190: (p_resolve_mapping_id => x.resolve_mapping_id
1191: ,p_target_id => l_table_rec.ler_id);
1210: and plip_id = c_target_id2;
1211:
1212: cursor csr_get_all_boi is
1213: select *
1214: from ben_dm_resolve_mappings
1215: where table_name = 'BEN_OIPLIP_F'
1216: and target_id is null;
1217:
1218: -- Declare local variables
1226:
1227: begin
1228:
1229: --
1230: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_OIPLIP_F
1231: --
1232: for x in csr_get_all_boi loop
1233: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
1234: -- Get OIPL_ID
1254: -- <
1255: null;
1256: else
1257: --
1258: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
1259: --
1260: ben_dm_data_util.update_pk_mapping
1261: (p_resolve_mapping_id => x.resolve_mapping_id
1262: ,p_target_id => l_table_rec.oiplip_id);
1282: and business_group_id = c_business_group_id;
1283:
1284: cursor csr_get_all_cop is
1285: select *
1286: from ben_dm_resolve_mappings
1287: where table_name = 'BEN_OIPL_F'
1288: and target_id is null;
1289:
1290: -- Declare local variables
1298:
1299: begin
1300:
1301: --
1302: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_OIPL_F
1303: --
1304: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1305: for x in csr_get_all_cop loop
1306: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
1327: -- <
1328: null;
1329: else
1330: --
1331: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
1332: --
1333: ben_dm_data_util.update_pk_mapping
1334: (p_resolve_mapping_id => x.resolve_mapping_id
1335: ,p_target_id => l_table_rec.oipl_id);
1353: and business_group_id = c_business_group_id;
1354:
1355: cursor csr_get_all_opt is
1356: select *
1357: from ben_dm_resolve_mappings
1358: where table_name = 'BEN_OPT_F'
1359: and target_id is null;
1360:
1361: -- Declare local variables
1367:
1368: begin
1369:
1370: --
1371: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_OPT_F
1372: --
1373: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1374: for x in csr_get_all_opt loop
1375: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
1390: -- <
1391: null;
1392: else
1393: --
1394: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
1395: --
1396: ben_dm_data_util.update_pk_mapping
1397: (p_resolve_mapping_id => x.resolve_mapping_id
1398: ,p_target_id => l_table_rec.opt_id);
1416: and business_group_id = c_business_group_id;
1417:
1418: cursor csr_get_all_pgm is
1419: select *
1420: from ben_dm_resolve_mappings
1421: where table_name = 'BEN_PGM_F'
1422: and target_id is null;
1423:
1424: -- Declare local variables
1430:
1431: begin
1432:
1433: --
1434: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_PGM_F
1435: --
1436: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1437: for x in csr_get_all_pgm loop
1438: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
1453: -- <
1454: null;
1455: else
1456: --
1457: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
1458: --
1459: ben_dm_data_util.update_pk_mapping
1460: (p_resolve_mapping_id => x.resolve_mapping_id
1461: ,p_target_id => l_table_rec.pgm_id);
1481: and business_group_id = c_business_group_id;
1482:
1483: cursor csr_get_all_cpp is
1484: select *
1485: from ben_dm_resolve_mappings
1486: where table_name = 'BEN_PLIP_F'
1487: and target_id is null;
1488:
1489: -- Declare local variables
1497:
1498: begin
1499:
1500: --
1501: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_PLIP_F
1502: --
1503: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1504: for x in csr_get_all_cpp loop
1505: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
1526: -- <
1527: null;
1528: else
1529: --
1530: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
1531: --
1532: ben_dm_data_util.update_pk_mapping
1533: (p_resolve_mapping_id => x.resolve_mapping_id
1534: ,p_target_id => l_table_rec.plip_id);
1552: and business_group_id = c_business_group_id;
1553:
1554: cursor csr_get_all_pln is
1555: select *
1556: from ben_dm_resolve_mappings
1557: where table_name = 'BEN_PL_F'
1558: and target_id is null;
1559:
1560: -- Declare local variables
1566:
1567: begin
1568:
1569: --
1570: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_PL_F
1571: --
1572: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1573: for x in csr_get_all_pln loop
1574: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
1589: -- <
1590: null;
1591: else
1592: --
1593: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
1594: --
1595: ben_dm_data_util.update_pk_mapping
1596: (p_resolve_mapping_id => x.resolve_mapping_id
1597: ,p_target_id => l_table_rec.pl_id);
1615: and business_group_id = c_business_group_id;
1616:
1617: cursor csr_get_all_ptp is
1618: select *
1619: from ben_dm_resolve_mappings
1620: where table_name = 'BEN_PL_TYP_F'
1621: and target_id is null;
1622:
1623: -- Declare local variables
1629:
1630: begin
1631:
1632: --
1633: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_PL_TYP_F
1634: --
1635: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1636: for x in csr_get_all_ptp loop
1637: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
1652: -- <
1653: null;
1654: else
1655: --
1656: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
1657: --
1658: ben_dm_data_util.update_pk_mapping
1659: (p_resolve_mapping_id => x.resolve_mapping_id
1660: ,p_target_id => l_table_rec.pl_typ_id);
1680: and business_group_id = c_business_group_id;
1681:
1682: cursor csr_get_all_ctp is
1683: select *
1684: from ben_dm_resolve_mappings
1685: where table_name = 'BEN_PTIP_F'
1686: and target_id is null;
1687:
1688: -- Declare local variables
1696:
1697: begin
1698:
1699: --
1700: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_PTIP_F
1701: --
1702: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1703: for x in csr_get_all_ctp loop
1704: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
1725: -- <
1726: null;
1727: else
1728: --
1729: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
1730: --
1731: ben_dm_data_util.update_pk_mapping
1732: (p_resolve_mapping_id => x.resolve_mapping_id
1733: ,p_target_id => l_table_rec.ptip_id);
1751: and business_group_id = c_business_group_id;
1752:
1753: cursor csr_get_all_yrp is
1754: select *
1755: from ben_dm_resolve_mappings
1756: where table_name = 'BEN_YR_PERD'
1757: and target_id is null;
1758:
1759: -- Declare local variables
1765:
1766: begin
1767:
1768: --
1769: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table BEN_YR_PERD
1770: --
1771: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1772: for x in csr_get_all_yrp loop
1773: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
1788: -- <
1789: null;
1790: else
1791: --
1792: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
1793: --
1794: ben_dm_data_util.update_pk_mapping
1795: (p_resolve_mapping_id => x.resolve_mapping_id
1796: ,p_target_id => l_table_rec.yr_perd_id);
1814: and business_group_id = c_business_group_id;
1815:
1816: cursor csr_get_all_fra is
1817: select *
1818: from ben_dm_resolve_mappings
1819: where table_name = 'FF_FORMULAS_F'
1820: and target_id is null;
1821:
1822: -- Declare local variables
1828:
1829: begin
1830:
1831: --
1832: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table FF_FORMULAS_F
1833: --
1834: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1835: for x in csr_get_all_fra loop
1836: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
1851: -- <
1852: null;
1853: else
1854: --
1855: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
1856: --
1857: ben_dm_data_util.update_pk_mapping
1858: (p_resolve_mapping_id => x.resolve_mapping_id
1859: ,p_target_id => l_table_rec.formula_id);
1877: ;
1878:
1879: cursor csr_get_all_fit is
1880: select *
1881: from ben_dm_resolve_mappings
1882: where table_name = 'FND_ID_FLEX_STRUCTURES_VL'
1883: and target_id is null;
1884:
1885: -- Declare local variables
1891:
1892: begin
1893:
1894: --
1895: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table FND_ID_FLEX_STRUCTURES_VL
1896: --
1897: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1898: for x in csr_get_all_fit loop
1899: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
1914: -- <
1915: null;
1916: else
1917: --
1918: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
1919: --
1920: ben_dm_data_util.update_pk_mapping
1921: (p_resolve_mapping_id => x.resolve_mapping_id
1922: ,p_target_id => l_table_rec.id_flex_num);
1940: ;
1941:
1942: cursor csr_get_all_fus is
1943: select *
1944: from ben_dm_resolve_mappings
1945: where table_name = 'FND_USER'
1946: and target_id is null;
1947:
1948: -- Declare local variables
1954:
1955: begin
1956:
1957: --
1958: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table FND_USER
1959: --
1960: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
1961: for x in csr_get_all_fus loop
1962: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
1977: -- <
1978: null;
1979: else
1980: --
1981: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
1982: --
1983: ben_dm_data_util.update_pk_mapping
1984: (p_resolve_mapping_id => x.resolve_mapping_id
1985: ,p_target_id => l_table_rec.user_id);
2003: and business_group_id = c_business_group_id;
2004:
2005: cursor csr_get_all_aou is
2006: select *
2007: from ben_dm_resolve_mappings
2008: where table_name = 'HR_ALL_ORGANIZATION_UNITS'
2009: and target_id is null;
2010:
2011: -- Declare local variables
2017:
2018: begin
2019:
2020: --
2021: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table HR_ALL_ORGANIZATION_UNITS
2022: --
2023: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2024: for x in csr_get_all_aou loop
2025: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
2040: -- <
2041: null;
2042: else
2043: --
2044: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
2045: --
2046: ben_dm_data_util.update_pk_mapping
2047: (p_resolve_mapping_id => x.resolve_mapping_id
2048: ,p_target_id => l_table_rec.organization_id);
2069: and business_group_id = c_business_group_id;
2070:
2071: cursor csr_get_all_ori is
2072: select *
2073: from ben_dm_resolve_mappings
2074: where table_name = 'HR_ORGANIZATION_INFORMATION'
2075: and target_id is null;
2076:
2077: -- Declare local variables
2084:
2085: begin
2086:
2087: --
2088: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table HR_ALL_ORGANIZATION_UNITS
2089: --
2090: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2091: for x in csr_get_all_ori loop
2092: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
2107: -- <
2108: null;
2109: else
2110: --
2111: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
2112: --
2113: ben_dm_data_util.update_pk_mapping
2114: (p_resolve_mapping_id => x.resolve_mapping_id
2115: ,p_target_id => l_table_rec.organization_id);
2136: ;
2137:
2138: cursor csr_get_all_loc is
2139: select *
2140: from ben_dm_resolve_mappings
2141: where table_name = 'HR_LOCATIONS_ALL'
2142: and target_id is null;
2143:
2144: -- Declare local variables
2150:
2151: begin
2152:
2153: --
2154: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table HR_LOCATIONS_ALL
2155: --
2156: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2157: for x in csr_get_all_loc loop
2158: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
2173: -- <
2174: null;
2175: else
2176: --
2177: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
2178: --
2179: ben_dm_data_util.update_pk_mapping
2180: (p_resolve_mapping_id => x.resolve_mapping_id
2181: ,p_target_id => l_table_rec.location_id);
2199: and business_group_id = c_business_group_id;
2200:
2201: cursor csr_get_all_prl is
2202: select *
2203: from ben_dm_resolve_mappings
2204: where table_name = 'PAY_ALL_PAYROLLS_F'
2205: and target_id is null;
2206:
2207: -- Declare local variables
2213:
2214: begin
2215:
2216: --
2217: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PAY_ALL_PAYROLLS_F
2218: --
2219: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2220: for x in csr_get_all_prl loop
2221: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
2236: -- <
2237: null;
2238: else
2239: --
2240: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
2241: --
2242: ben_dm_data_util.update_pk_mapping
2243: (p_resolve_mapping_id => x.resolve_mapping_id
2244: ,p_target_id => l_table_rec.payroll_id);
2263: and (LEGISLATION_CODE = 'US' or LEGISLATION_CODE is null);
2264:
2265: cursor csr_get_all_pet is
2266: select *
2267: from ben_dm_resolve_mappings
2268: where table_name = 'PAY_ELEMENT_TYPES_F'
2269: and target_id is null;
2270:
2271: -- Declare local variables
2277:
2278: begin
2279:
2280: --
2281: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PAY_ELEMENT_TYPES_F
2282: --
2283: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2284: for x in csr_get_all_pet loop
2285: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
2300: -- <
2301: null;
2302: else
2303: --
2304: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
2305: --
2306: ben_dm_data_util.update_pk_mapping
2307: (p_resolve_mapping_id => x.resolve_mapping_id
2308: ,p_target_id => l_table_rec.element_type_id);
2329: and (LEGISLATION_CODE = 'US' or LEGISLATION_CODE is null);
2330:
2331: cursor csr_get_all_ipv is
2332: select *
2333: from ben_dm_resolve_mappings
2334: where table_name = 'PAY_INPUT_VALUES_F'
2335: and target_id is null;
2336:
2337: -- Declare local variables
2345:
2346: begin
2347:
2348: --
2349: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PAY_INPUT_VALUES_F
2350: --
2351: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2352: for x in csr_get_all_ipv loop
2353: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
2372: -- <
2373: null;
2374: else
2375: --
2376: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
2377: --
2378: ben_dm_data_util.update_pk_mapping
2379: (p_resolve_mapping_id => x.resolve_mapping_id
2380: ,p_target_id => l_table_rec.input_value_id);
2401: and nvl(business_group_id,-1) = nvl(c_bg_id,-1) ;
2402:
2403: cursor csr_get_all_ast is
2404: select *
2405: from ben_dm_resolve_mappings
2406: where table_name = 'PER_ASSIGNMENT_STATUS_TYPES'
2407: and target_id is null;
2408:
2409: -- Declare local variables
2420:
2421: begin
2422:
2423: --
2424: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PER_ASSIGNMENT_STATUS_TYPES
2425: --
2426: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2427: for x in csr_get_all_ast loop
2428: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
2459: -- <
2460: null;
2461: else
2462: --
2463: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
2464: --
2465: ben_dm_data_util.update_pk_mapping
2466: (p_resolve_mapping_id => x.resolve_mapping_id
2467: ,p_target_id => l_table_rec.assignment_status_type_id);
2485: ;
2486:
2487: cursor csr_get_all_gra is
2488: select *
2489: from ben_dm_resolve_mappings
2490: where table_name = 'PER_GRADES'
2491: and target_id is null;
2492:
2493: -- Declare local variables
2499:
2500: begin
2501:
2502: --
2503: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PER_GRADES
2504: --
2505: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2506: for x in csr_get_all_gra loop
2507: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
2522: -- <
2523: null;
2524: else
2525: --
2526: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
2527: --
2528: ben_dm_data_util.update_pk_mapping
2529: (p_resolve_mapping_id => x.resolve_mapping_id
2530: ,p_target_id => l_table_rec.grade_id);
2548: ;
2549:
2550: cursor csr_get_all_job is
2551: select *
2552: from ben_dm_resolve_mappings
2553: where table_name = 'PER_JOBS'
2554: and target_id is null;
2555:
2556: -- Declare local variables
2562:
2563: begin
2564:
2565: --
2566: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PER_JOBS
2567: --
2568: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2569: for x in csr_get_all_job loop
2570: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
2585: -- <
2586: null;
2587: else
2588: --
2589: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
2590: --
2591: ben_dm_data_util.update_pk_mapping
2592: (p_resolve_mapping_id => x.resolve_mapping_id
2593: ,p_target_id => l_table_rec.job_id);
2611: ;
2612:
2613: cursor csr_get_all_pyb is
2614: select *
2615: from ben_dm_resolve_mappings
2616: where table_name = 'PER_PAY_BASES'
2617: and target_id is null;
2618:
2619: -- Declare local variables
2625:
2626: begin
2627:
2628: --
2629: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PER_PAY_BASES
2630: --
2631: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2632: for x in csr_get_all_pyb loop
2633: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
2648: -- <
2649: null;
2650: else
2651: --
2652: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
2653: --
2654: ben_dm_data_util.update_pk_mapping
2655: (p_resolve_mapping_id => x.resolve_mapping_id
2656: ,p_target_id => l_table_rec.pay_basis_id);
2674: and business_group_id = c_business_group_id ;
2675:
2676: cursor csr_get_all_prt is
2677: select *
2678: from ben_dm_resolve_mappings
2679: where table_name = 'PER_PERSON_TYPES'
2680: and target_id is null;
2681:
2682: -- Declare local variables
2688:
2689: begin
2690:
2691: --
2692: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PER_PERSON_TYPES
2693: --
2694: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2695: for x in csr_get_all_prt loop
2696: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
2711: -- <
2712: null;
2713: else
2714: --
2715: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
2716: --
2717: ben_dm_data_util.update_pk_mapping
2718: (p_resolve_mapping_id => x.resolve_mapping_id
2719: ,p_target_id => l_table_rec.person_type_id);
2737: and business_group_id = c_business_group_id;
2738:
2739: cursor csr_get_all_aat is
2740: select *
2741: from ben_dm_resolve_mappings
2742: where table_name = 'PER_ABSENCE_ATTENDANCE_TYPES'
2743: and target_id is null;
2744:
2745: -- Declare local variables
2751:
2752: begin
2753:
2754: --
2755: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PER_ABSENCE_ATTENDANCE_TYPES
2756: --
2757: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2758: for x in csr_get_all_aat loop
2759: l_business_group_id := ben_dm_data_util.get_bg_id(x.business_group_name);
2776: -- <
2777: null;
2778: else
2779: --
2780: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
2781: --
2782: ben_dm_data_util.update_pk_mapping
2783: (p_resolve_mapping_id => x.resolve_mapping_id
2784: ,p_target_id => l_table_rec.absence_attendance_type_id);
2804: and business_group_id = c_business_group_id;
2805:
2806: cursor csr_get_all_aar is
2807: select *
2808: from ben_dm_resolve_mappings
2809: where table_name = 'PER_ABS_ATTENDANCE_REASONS'
2810: and target_id is null;
2811:
2812: -- Declare local variables
2819: --
2820: begin
2821:
2822: --
2823: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PER_ABS_ATTENDANCE_REASONS
2824: --
2825: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2826: for x in csr_get_all_aar loop
2827: l_business_group_id := ben_dm_data_util.get_bg_id(x.business_group_name);
2847: -- <
2848: null;
2849: else
2850: --
2851: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
2852: --
2853: ben_dm_data_util.update_pk_mapping
2854: (p_resolve_mapping_id => x.resolve_mapping_id
2855: ,p_target_id => l_table_rec.abs_attendance_reason_id);
2872: where entity_result_id = c_entity_result_id;
2873:
2874: cursor csr_get_all_scl is
2875: select *
2876: from ben_dm_resolve_mappings
2877: where table_name = 'HR_SOFT_CODING_KEYFLEX'
2878: and target_id is null;
2879:
2880: -- Declare local variables
2889:
2890: begin
2891:
2892: --
2893: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table HR_SOFT_CODING_KEYFLEX
2894: --
2895: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
2896: for x in csr_get_all_scl loop
2897: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
2911: -- <
2912: null;
2913: else
2914: --
2915: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
2916: --
2917:
2918: if l_table_rec.INFORMATION4 is not null then
2919: l_table_rec.INFORMATION4 := l_bg_id;
2977: where entity_result_id = c_entity_result_id;
2978:
2979: cursor csr_get_all_peg is
2980: select *
2981: from ben_dm_resolve_mappings
2982: where table_name = 'PAY_PEOPLE_GROUPS'
2983: and target_id is null;
2984:
2985: -- Declare local variables
2994:
2995: begin
2996:
2997: --
2998: -- Select all rows from BEN_DM_RESOLVE_MAPPINGS for table PAY_PEOPLE_GROUPS
2999: --
3000: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
3001: for x in csr_get_all_peg loop
3002:
3020: -- <
3021: null;
3022: else
3023: --
3024: -- Update DK data into BEN_DM_RESOLVE_MAPPINGS table.
3025: --
3026:
3027: select people_group_structure
3028: into l_people_group_structure
3121: Procedure get_dk_frm_all is
3122:
3123: cursor csr_get_no_target is
3124: select *
3125: from ben_dm_resolve_mappings
3126: where target_id is null;
3127:
3128:
3129: l_proc varchar2(75) ;