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:
63: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
64:
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
88: ,p_target_id => l_table_rec.actl_prem_id);
89: end if;
88: ,p_target_id => l_table_rec.actl_prem_id);
89: end if;
90: --
91: end loop;
92: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
93:
94: end;
95: --
96: -- DK Resolve For Table BEN_ACTN_TYP
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:
130: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
131: ben_dm_utility.message('INFO','bg : ' || l_bg_id,5) ;
127: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
128: for x in csr_get_all_eat loop
129:
130: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
131: ben_dm_utility.message('INFO','bg : ' || l_bg_id,5) ;
132: open csr_get_dk_eat (c_source_key => x.source_key
133: ,c_business_group_id => l_bg_id);
134: fetch csr_get_dk_eat into l_table_rec;
135: if csr_get_dk_eat%notfound then
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:
155:
156: ben_dm_data_util.update_pk_mapping
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:
155:
156: ben_dm_data_util.update_pk_mapping
157: (p_resolve_mapping_id => x.resolve_mapping_id
159:
160: end if;
161: --
162: end loop;
163: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
164: end;
165: --
166: -- DK Resolve For Table BEN_ACTY_BASE_RT_F
167: --
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);
199: open csr_get_dk_abr (c_source_key => x.source_key
200: ,c_business_group_id => l_bg_id);
221: ,p_target_id => l_table_rec.acty_base_rt_id);
222: end if;
223: --
224: end loop;
225: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
226: end;
227: --
228: -- DK Resolve For Table BEN_BENFTS_GRP
229: --
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);
261: open csr_get_dk_bng (c_source_key => x.source_key
262: ,c_business_group_id => l_bg_id);
283: ,p_target_id => l_table_rec.benfts_grp_id);
284: end if;
285: --
286: end loop;
287: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
288: end;
289:
290: --
291: -- DK Resolve For Table PAY_ELEMENT_LINKS_F
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);
325: -- Get element_type_id
326: ben_dm_utility.message('INFO','resolve_mapping_id1 '||x.resolve_mapping_id1,5) ;
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);
325: -- Get element_type_id
326: ben_dm_utility.message('INFO','resolve_mapping_id1 '||x.resolve_mapping_id1,5) ;
327: if x.resolve_mapping_id1 is not null then
328: l_target_id1 := get_target_id_for_mapping(x.resolve_mapping_id1);
329: end if;
330: ben_dm_utility.message('INFO','l_target_id1 '||l_target_id1,5) ;
326: ben_dm_utility.message('INFO','resolve_mapping_id1 '||x.resolve_mapping_id1,5) ;
327: if x.resolve_mapping_id1 is not null then
328: l_target_id1 := get_target_id_for_mapping(x.resolve_mapping_id1);
329: end if;
330: ben_dm_utility.message('INFO','l_target_id1 '||l_target_id1,5) ;
331: ben_dm_utility.message('INFO','l_bg_id '||l_bg_id,5) ;
332:
333: open csr_get_dk_pll (c_source_id => l_target_id1
334: ,c_business_group_id => l_bg_id);
327: if x.resolve_mapping_id1 is not null then
328: l_target_id1 := get_target_id_for_mapping(x.resolve_mapping_id1);
329: end if;
330: ben_dm_utility.message('INFO','l_target_id1 '||l_target_id1,5) ;
331: ben_dm_utility.message('INFO','l_bg_id '||l_bg_id,5) ;
332:
333: open csr_get_dk_pll (c_source_id => l_target_id1
334: ,c_business_group_id => l_bg_id);
335: fetch csr_get_dk_pll into l_table_rec;
355: ,p_target_id => l_table_rec.element_link_id);
356: end if;
357: --
358: end loop;
359: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
360: end;
361:
362: --
363: -- DK Resolve For Table BEN_BNFTS_BAL_F
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);
396: open csr_get_dk_bnb (c_source_key => x.source_key
397: ,c_business_group_id => l_bg_id);
418: ,p_target_id => l_table_rec.bnfts_bal_id);
419: end if;
420: --
421: end loop;
422: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
423: end;
424:
425: --
426: -- DK Resolve For Table BEN_BNFT_PRVDR_POOL_F
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);
459: open csr_get_dk_bpp (c_source_key => x.source_key
460: ,c_business_group_id => l_bg_id);
481: ,p_target_id => l_table_rec.bnft_prvdr_pool_id);
482: end if;
483: --
484: end loop;
485: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
486: end;
487:
488: --
489: -- DK Resolve For Table BEN_CMBN_PLIP_F
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);
522: open csr_get_dk_cpl (c_source_key => x.source_key
523: ,c_business_group_id => l_bg_id);
544: ,p_target_id => l_table_rec.cmbn_plip_id);
545: end if;
546: --
547: end loop;
548: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
549: end;
550:
551: --
552: -- DK Resolve For Table BEN_CMBN_PTIP_F
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);
585: open csr_get_dk_cbp (c_source_key => x.source_key
586: ,c_business_group_id => l_bg_id);
607: ,p_target_id => l_table_rec.cmbn_ptip_id);
608: end if;
609: --
610: end loop;
611: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
612: end;
613:
614: --
615: -- DK Resolve For Table BEN_CMBN_PTIP_OPT_F
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);
648: open csr_get_dk_cpt (c_source_key => x.source_key
649: ,c_business_group_id => l_bg_id);
670: ,p_target_id => l_table_rec.cmbn_ptip_opt_id);
671: end if;
672: --
673: end loop;
674: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
675: end;
676:
677: --
678: -- DK Resolve For Table BEN_CM_TRGR
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);
711: open csr_get_dk_bcr (c_source_key => x.source_key
712: ,c_business_group_id => l_bg_id);
733: ,p_target_id => l_table_rec.cm_trgr_id);
734: end if;
735: --
736: end loop;
737: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
738: end;
739:
740: --
741: -- DK Resolve For Table BEN_CM_TYP_F
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);
774: open csr_get_dk_cct (c_source_key => x.source_key
775: ,c_business_group_id => l_bg_id);
796: ,p_target_id => l_table_rec.cm_typ_id);
797: end if;
798: --
799: end loop;
800: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
801: end;
802:
803: --
804: -- DK Resolve For Table BEN_COMP_LVL_FCTR
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);
838: open csr_get_dk_clf (c_source_key => x.source_key
839: ,c_business_group_id => l_bg_id);
860: ,p_target_id => l_table_rec.comp_lvl_fctr_id);
861: end if;
862: --
863: end loop;
864: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
865: end;
866:
867: --
868: -- DK Resolve For Table BEN_CVG_AMT_CALC_MTHD_F
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);
901: open csr_get_dk_ccm (c_source_key => x.source_key
902: ,c_business_group_id => l_bg_id);
923: ,p_target_id => l_table_rec.cvg_amt_calc_mthd_id);
924: end if;
925: --
926: end loop;
927: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
928: end;
929:
930: --
931: -- DK Resolve For Table BEN_ENRT_PERD
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);
980: -- Get YR_PERD_ID
981: l_target_id1 := get_target_id_for_mapping(x.resolve_mapping_id1);
1025: ,p_target_id => l_table_rec.enrt_perd_id);
1026: end if;
1027: --
1028: end loop;
1029: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1030: end;
1031: --
1032: -- DK Resolve For Table BEN_LEE_RSN_F
1033: --
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);
1081: -- Get LER_ID
1082: if x.resolve_mapping_id1 is not null then
1128: ,p_target_id => l_table_rec.lee_rsn_id);
1129: end if;
1130: --
1131: end loop;
1132: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1133: end;
1134:
1135: --
1136: -- DK Resolve For Table BEN_LER_F
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);
1169: open csr_get_dk_ler (c_source_key => x.source_key
1170: ,c_business_group_id => l_bg_id);
1191: ,p_target_id => l_table_rec.ler_id);
1192: end if;
1193: --
1194: end loop;
1195: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1196: end;
1197:
1198: --
1199: -- DK Resolve For Table BEN_OIPLIP_F
1262: ,p_target_id => l_table_rec.oiplip_id);
1263: end if;
1264: --
1265: end loop;
1266: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1267: end;
1268:
1269: --
1270: -- DK Resolve For Table BEN_OIPL_F
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);
1307: -- Get PL_ID
1308: l_target_id1 := get_target_id_for_mapping(x.resolve_mapping_id1);
1335: ,p_target_id => l_table_rec.oipl_id);
1336: end if;
1337: --
1338: end loop;
1339: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1340: end;
1341:
1342: --
1343: -- DK Resolve For Table BEN_OPT_F
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);
1376: open csr_get_dk_opt (c_source_key => x.source_key
1377: ,c_business_group_id => l_bg_id);
1398: ,p_target_id => l_table_rec.opt_id);
1399: end if;
1400: --
1401: end loop;
1402: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1403: end;
1404:
1405: --
1406: -- DK Resolve For Table BEN_PGM_F
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);
1439: open csr_get_dk_pgm (c_source_key => x.source_key
1440: ,c_business_group_id => l_bg_id);
1461: ,p_target_id => l_table_rec.pgm_id);
1462: end if;
1463: --
1464: end loop;
1465: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1466: end;
1467:
1468: --
1469: -- DK Resolve For Table BEN_PLIP_F
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);
1506: -- Get PGM_ID
1507: l_target_id1 := get_target_id_for_mapping(x.resolve_mapping_id1);
1534: ,p_target_id => l_table_rec.plip_id);
1535: end if;
1536: --
1537: end loop;
1538: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1539: end;
1540:
1541: --
1542: -- DK Resolve For Table BEN_PL_F
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);
1575: open csr_get_dk_pln (c_source_key => x.source_key
1576: ,c_business_group_id => l_bg_id);
1597: ,p_target_id => l_table_rec.pl_id);
1598: end if;
1599: --
1600: end loop;
1601: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1602: end;
1603:
1604: --
1605: -- DK Resolve For Table BEN_PL_TYP_F
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);
1638: open csr_get_dk_ptp (c_source_key => x.source_key
1639: ,c_business_group_id => l_bg_id);
1660: ,p_target_id => l_table_rec.pl_typ_id);
1661: end if;
1662: --
1663: end loop;
1664: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1665: end;
1666:
1667: --
1668: -- DK Resolve For Table BEN_PTIP_F
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);
1705: -- Get PGM_ID
1706: l_target_id1 := get_target_id_for_mapping(x.resolve_mapping_id1);
1733: ,p_target_id => l_table_rec.ptip_id);
1734: end if;
1735: --
1736: end loop;
1737: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1738: end;
1739:
1740: --
1741: -- DK Resolve For Table BEN_YR_PERD
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);
1774: open csr_get_dk_yrp (c_source_key => x.source_key
1775: ,c_business_group_id => l_bg_id);
1796: ,p_target_id => l_table_rec.yr_perd_id);
1797: end if;
1798: --
1799: end loop;
1800: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1801: end;
1802:
1803: --
1804: -- DK Resolve For Table FF_FORMULAS_F
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);
1837: open csr_get_dk_fra (c_source_key => x.source_key
1838: ,c_business_group_id => l_bg_id);
1859: ,p_target_id => l_table_rec.formula_id);
1860: end if;
1861: --
1862: end loop;
1863: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1864: end;
1865:
1866: --
1867: -- DK Resolve For Table FND_ID_FLEX_STRUCTURES_VL
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);
1900: open csr_get_dk_fit (c_source_key => x.source_key
1901: ,c_business_group_id => l_bg_id);
1922: ,p_target_id => l_table_rec.id_flex_num);
1923: end if;
1924: --
1925: end loop;
1926: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1927: end;
1928:
1929: --
1930: -- DK Resolve For Table FND_USER
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);
1963: open csr_get_dk_fus (c_source_key => x.source_key
1964: ,c_business_group_id => l_bg_id);
1985: ,p_target_id => l_table_rec.user_id);
1986: end if;
1987: --
1988: end loop;
1989: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
1990: end;
1991:
1992: --
1993: -- DK Resolve For Table HR_ALL_ORGANIZATION_UNITS
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);
2026: open csr_get_dk_aou (c_source_key => x.source_key
2027: ,c_business_group_id => l_bg_id);
2048: ,p_target_id => l_table_rec.organization_id);
2049: end if;
2050: --
2051: end loop;
2052: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2053: end;
2054:
2055:
2056:
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);
2093: open csr_get_dk_ori (c_source_key => x.source_key
2094: ,c_business_group_id => l_bg_id);
2115: ,p_target_id => l_table_rec.organization_id);
2116: end if;
2117: --
2118: end loop;
2119: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2120: end;
2121:
2122:
2123:
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);
2159: open csr_get_dk_loc (c_source_key => x.source_key
2160: ,c_business_group_id => l_bg_id);
2181: ,p_target_id => l_table_rec.location_id);
2182: end if;
2183: --
2184: end loop;
2185: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2186: end;
2187:
2188: --
2189: -- DK Resolve For Table PAY_ALL_PAYROLLS_F
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);
2222: open csr_get_dk_prl (c_source_key => x.source_key
2223: ,c_business_group_id => l_bg_id);
2244: ,p_target_id => l_table_rec.payroll_id);
2245: end if;
2246: --
2247: end loop;
2248: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2249: end;
2250:
2251: --
2252: -- DK Resolve For Table PAY_ELEMENT_TYPES_F
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);
2286: open csr_get_dk_pet (c_source_key => x.source_key
2287: ,c_business_group_id => l_bg_id);
2308: ,p_target_id => l_table_rec.element_type_id);
2309: end if;
2310: --
2311: end loop;
2312: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2313: end;
2314:
2315: --
2316: -- DK Resolve For Table PAY_INPUT_VALUES_F
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);
2354: -- Get ELEMENT_TYPE_ID
2355: l_target_id1 := get_target_id_for_mapping(x.resolve_mapping_id1);
2380: ,p_target_id => l_table_rec.input_value_id);
2381: end if;
2382: --
2383: end loop;
2384: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2385: end;
2386:
2387: --
2388: -- DK Resolve For Table PER_ASSIGNMENT_STATUS_TYPES
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);
2429: l_pos1 := instr(x.source_key,'-',1);
2430: l_pos2 := instr(x.source_key,'-',-1,1);
2435: else
2436: l_business_group_id := null;
2437: end if;
2438:
2439: ben_dm_utility.message('INFO','l_pos1 '||l_pos1,5) ;
2440: ben_dm_utility.message('INFO','l_pos2 '||l_pos2,5) ;
2441: ben_dm_utility.message('INFO','l_user_status '||l_user_status,5) ;
2442: ben_dm_utility.message('INFO','l_legislation_code '||l_legislation_code,5) ;
2443: ben_dm_utility.message('INFO','l_business_group_id '||l_business_group_id,5) ;
2436: l_business_group_id := null;
2437: end if;
2438:
2439: ben_dm_utility.message('INFO','l_pos1 '||l_pos1,5) ;
2440: ben_dm_utility.message('INFO','l_pos2 '||l_pos2,5) ;
2441: ben_dm_utility.message('INFO','l_user_status '||l_user_status,5) ;
2442: ben_dm_utility.message('INFO','l_legislation_code '||l_legislation_code,5) ;
2443: ben_dm_utility.message('INFO','l_business_group_id '||l_business_group_id,5) ;
2444: open csr_get_dk_ast (c_user_status => l_user_status
2437: end if;
2438:
2439: ben_dm_utility.message('INFO','l_pos1 '||l_pos1,5) ;
2440: ben_dm_utility.message('INFO','l_pos2 '||l_pos2,5) ;
2441: ben_dm_utility.message('INFO','l_user_status '||l_user_status,5) ;
2442: ben_dm_utility.message('INFO','l_legislation_code '||l_legislation_code,5) ;
2443: ben_dm_utility.message('INFO','l_business_group_id '||l_business_group_id,5) ;
2444: open csr_get_dk_ast (c_user_status => l_user_status
2445: ,c_leg_code => l_legislation_code
2438:
2439: ben_dm_utility.message('INFO','l_pos1 '||l_pos1,5) ;
2440: ben_dm_utility.message('INFO','l_pos2 '||l_pos2,5) ;
2441: ben_dm_utility.message('INFO','l_user_status '||l_user_status,5) ;
2442: ben_dm_utility.message('INFO','l_legislation_code '||l_legislation_code,5) ;
2443: ben_dm_utility.message('INFO','l_business_group_id '||l_business_group_id,5) ;
2444: open csr_get_dk_ast (c_user_status => l_user_status
2445: ,c_leg_code => l_legislation_code
2446: ,c_bg_id => l_business_group_id);
2439: ben_dm_utility.message('INFO','l_pos1 '||l_pos1,5) ;
2440: ben_dm_utility.message('INFO','l_pos2 '||l_pos2,5) ;
2441: ben_dm_utility.message('INFO','l_user_status '||l_user_status,5) ;
2442: ben_dm_utility.message('INFO','l_legislation_code '||l_legislation_code,5) ;
2443: ben_dm_utility.message('INFO','l_business_group_id '||l_business_group_id,5) ;
2444: open csr_get_dk_ast (c_user_status => l_user_status
2445: ,c_leg_code => l_legislation_code
2446: ,c_bg_id => l_business_group_id);
2447: fetch csr_get_dk_ast into l_table_rec;
2467: ,p_target_id => l_table_rec.assignment_status_type_id);
2468: end if;
2469: --
2470: end loop;
2471: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2472: end;
2473:
2474: --
2475: -- DK Resolve For Table PER_GRADES
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);
2508: open csr_get_dk_gra (c_source_key => x.source_key
2509: ,c_business_group_id => l_bg_id);
2530: ,p_target_id => l_table_rec.grade_id);
2531: end if;
2532: --
2533: end loop;
2534: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2535: end;
2536:
2537: --
2538: -- DK Resolve For Table PER_JOBS
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);
2571: open csr_get_dk_job (c_source_key => x.source_key
2572: ,c_business_group_id => l_bg_id);
2593: ,p_target_id => l_table_rec.job_id);
2594: end if;
2595: --
2596: end loop;
2597: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2598: end;
2599:
2600: --
2601: -- DK Resolve For Table PER_PAY_BASES
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);
2634: open csr_get_dk_pyb (c_source_key => x.source_key
2635: ,c_business_group_id => l_bg_id);
2656: ,p_target_id => l_table_rec.pay_basis_id);
2657: end if;
2658: --
2659: end loop;
2660: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2661: end;
2662:
2663: --
2664: -- DK Resolve For Table PER_PERSON_TYPES
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);
2697: open csr_get_dk_prt (c_source_key => x.source_key
2698: ,c_business_group_id => l_bg_id);
2719: ,p_target_id => l_table_rec.person_type_id);
2720: end if;
2721: --
2722: end loop;
2723: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2724: end;
2725: --
2726: -- DK Resolve For Table PER_ABSENCE_ATTENDANCE_TYPES
2727: --
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);
2760: ben_dm_utility.message('INFO','l_business_group_id '||l_business_group_id,5) ;
2761:
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);
2760: ben_dm_utility.message('INFO','l_business_group_id '||l_business_group_id,5) ;
2761:
2762: open csr_get_dk_aat (c_source_key => x.source_key
2763: ,c_business_group_id => l_business_group_id);
2764: fetch csr_get_dk_aat into l_table_rec;
2784: ,p_target_id => l_table_rec.absence_attendance_type_id);
2785: end if;
2786: --
2787: end loop;
2788: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2789: end;
2790: --
2791: -- DK Resolve For Table PER_ABS_ATTENDANCE_REASONS
2792: --
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);
2828: ben_dm_utility.message('INFO','l_business_group_id '||l_business_group_id,5) ;
2829: --
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);
2828: ben_dm_utility.message('INFO','l_business_group_id '||l_business_group_id,5) ;
2829: --
2830: l_target_id1 := get_target_id_for_mapping(x.resolve_mapping_id1);
2831: --
2832: open csr_get_dk_aar (c_source_key => x.source_key
2855: ,p_target_id => l_table_rec.abs_attendance_reason_id);
2856: end if;
2857: --
2858: end loop;
2859: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2860: end;
2861: --
2862: --
2863: -- DK Resolve For Table HR_SOFT_CODING_KEYFLEX
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);
2898: open csr_get_dk_scl (c_entity_result_id => x.resolve_mapping_id1);
2899: fetch csr_get_dk_scl into l_table_rec;
2960: ,p_target_id => l_target_id);
2961: end if;
2962: --
2963: end loop;
2964: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
2965: end;
2966:
2967: --
2968: -- DK Resolve For Table PAY_PEOPLE_GROUPS
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:
3003: hr_general.g_data_migrator_mode := 'Y';
3004:
3112: ,p_target_id => l_target_id);
3113: end if;
3114: --
3115: end loop;
3116: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
3117: end;
3118: --
3119: -- Genegeral procedure to call all other dk procedire
3120:
3131: no_dk exception;
3132:
3133: Begin
3134: l_proc := g_package|| 'get_dk_frm_all' ;
3135: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;
3136:
3137: hr_general.g_data_migrator_mode := 'Y';
3138:
3139: -- DK Resolve for Table BEN_ACTL_PREM_F
3268: get_dk_frm_aar;
3269:
3270: --
3271:
3272: ben_dm_utility.message('INFO','Start of Report for Unresolved Developer Keys',5) ;
3273: for x in csr_get_no_target loop
3274: l_unresolved_dk := TRUE;
3275:
3276: ben_dm_utility.message('INFO','Resolve_Mapping_Id : ' || x.resolve_mapping_id,5);
3272: ben_dm_utility.message('INFO','Start of Report for Unresolved Developer Keys',5) ;
3273: for x in csr_get_no_target loop
3274: l_unresolved_dk := TRUE;
3275:
3276: ben_dm_utility.message('INFO','Resolve_Mapping_Id : ' || x.resolve_mapping_id,5);
3277: ben_dm_utility.message('INFO','Table_Name : ' || x.table_name,5);
3278: ben_dm_utility.message('INFO','Column_Name : ' || x.column_name,5);
3279: ben_dm_utility.message('INFO','Source_Key : ' || x.source_key,5);
3280: ben_dm_utility.message('INFO','Business_Group_name : ' || x.business_group_name,5);
3273: for x in csr_get_no_target loop
3274: l_unresolved_dk := TRUE;
3275:
3276: ben_dm_utility.message('INFO','Resolve_Mapping_Id : ' || x.resolve_mapping_id,5);
3277: ben_dm_utility.message('INFO','Table_Name : ' || x.table_name,5);
3278: ben_dm_utility.message('INFO','Column_Name : ' || x.column_name,5);
3279: ben_dm_utility.message('INFO','Source_Key : ' || x.source_key,5);
3280: ben_dm_utility.message('INFO','Business_Group_name : ' || x.business_group_name,5);
3281: --
3274: l_unresolved_dk := TRUE;
3275:
3276: ben_dm_utility.message('INFO','Resolve_Mapping_Id : ' || x.resolve_mapping_id,5);
3277: ben_dm_utility.message('INFO','Table_Name : ' || x.table_name,5);
3278: ben_dm_utility.message('INFO','Column_Name : ' || x.column_name,5);
3279: ben_dm_utility.message('INFO','Source_Key : ' || x.source_key,5);
3280: ben_dm_utility.message('INFO','Business_Group_name : ' || x.business_group_name,5);
3281: --
3282: end loop;
3275:
3276: ben_dm_utility.message('INFO','Resolve_Mapping_Id : ' || x.resolve_mapping_id,5);
3277: ben_dm_utility.message('INFO','Table_Name : ' || x.table_name,5);
3278: ben_dm_utility.message('INFO','Column_Name : ' || x.column_name,5);
3279: ben_dm_utility.message('INFO','Source_Key : ' || x.source_key,5);
3280: ben_dm_utility.message('INFO','Business_Group_name : ' || x.business_group_name,5);
3281: --
3282: end loop;
3283: ben_dm_utility.message('INFO','End of Report for Unresolved Developer Keys',5);
3276: ben_dm_utility.message('INFO','Resolve_Mapping_Id : ' || x.resolve_mapping_id,5);
3277: ben_dm_utility.message('INFO','Table_Name : ' || x.table_name,5);
3278: ben_dm_utility.message('INFO','Column_Name : ' || x.column_name,5);
3279: ben_dm_utility.message('INFO','Source_Key : ' || x.source_key,5);
3280: ben_dm_utility.message('INFO','Business_Group_name : ' || x.business_group_name,5);
3281: --
3282: end loop;
3283: ben_dm_utility.message('INFO','End of Report for Unresolved Developer Keys',5);
3284:
3279: ben_dm_utility.message('INFO','Source_Key : ' || x.source_key,5);
3280: ben_dm_utility.message('INFO','Business_Group_name : ' || x.business_group_name,5);
3281: --
3282: end loop;
3283: ben_dm_utility.message('INFO','End of Report for Unresolved Developer Keys',5);
3284:
3285: if l_unresolved_dk then
3286: ben_dm_utility.message('INFO','Error : Unresolved Developer Keys',5) ;
3287: raise no_dk;
3282: end loop;
3283: ben_dm_utility.message('INFO','End of Report for Unresolved Developer Keys',5);
3284:
3285: if l_unresolved_dk then
3286: ben_dm_utility.message('INFO','Error : Unresolved Developer Keys',5) ;
3287: raise no_dk;
3288: end if;
3289:
3290: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
3286: ben_dm_utility.message('INFO','Error : Unresolved Developer Keys',5) ;
3287: raise no_dk;
3288: end if;
3289:
3290: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
3291:
3292: Exception
3293: when others then
3294: ben_dm_utility.message('INFO','Error : ' || substr(sqlerrm,1,100) ,5) ;
3290: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;
3291:
3292: Exception
3293: when others then
3294: ben_dm_utility.message('INFO','Error : ' || substr(sqlerrm,1,100) ,5) ;
3295: raise ;
3296: end get_dk_frm_all ;
3297:
3298: