eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DM_UPLOAD_DK dependencies on BEN_DM_DATA_UTIL

Line 63: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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:
65: open csr_get_dk_apr(c_source_key => x.source_key
66: ,c_business_group_id => l_bg_id);
67: fetch csr_get_dk_apr into l_table_rec;

Line 86: ben_dm_data_util.update_pk_mapping

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;
90: --

Line 130: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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) ;
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;

Line 156: ben_dm_data_util.update_pk_mapping

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
158: ,p_target_id => l_table_rec.actn_typ_id);
159:
160: end if;

Line 198: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
201: fetch csr_get_dk_abr into l_table_rec;
202: if csr_get_dk_abr%notfound then

Line 219: ben_dm_data_util.update_pk_mapping

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);
222: end if;
223: --

Line 260: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
263: fetch csr_get_dk_bng into l_table_rec;
264: if csr_get_dk_bng%notfound then

Line 281: ben_dm_data_util.update_pk_mapping

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);
284: end if;
285: --

Line 324: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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) ;
327: if x.resolve_mapping_id1 is not null then
328: l_target_id1 := get_target_id_for_mapping(x.resolve_mapping_id1);

Line 353: ben_dm_data_util.update_pk_mapping

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);
356: end if;
357: --

Line 395: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
398: fetch csr_get_dk_bnb into l_table_rec;
399: if csr_get_dk_bnb%notfound then

Line 416: ben_dm_data_util.update_pk_mapping

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);
419: end if;
420: --

Line 458: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
461: fetch csr_get_dk_bpp into l_table_rec;
462: if csr_get_dk_bpp%notfound then

Line 479: ben_dm_data_util.update_pk_mapping

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);
482: end if;
483: --

Line 521: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
524: fetch csr_get_dk_cpl into l_table_rec;
525: if csr_get_dk_cpl%notfound then

Line 542: ben_dm_data_util.update_pk_mapping

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);
545: end if;
546: --

Line 584: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
587: fetch csr_get_dk_cbp into l_table_rec;
588: if csr_get_dk_cbp%notfound then

Line 605: ben_dm_data_util.update_pk_mapping

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);
608: end if;
609: --

Line 647: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
650: fetch csr_get_dk_cpt into l_table_rec;
651: if csr_get_dk_cpt%notfound then

Line 668: ben_dm_data_util.update_pk_mapping

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);
671: end if;
672: --

Line 710: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
713: fetch csr_get_dk_bcr into l_table_rec;
714: if csr_get_dk_bcr%notfound then

Line 731: ben_dm_data_util.update_pk_mapping

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);
734: end if;
735: --

Line 773: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
776: fetch csr_get_dk_cct into l_table_rec;
777: if csr_get_dk_cct%notfound then

Line 794: ben_dm_data_util.update_pk_mapping

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);
797: end if;
798: --

Line 837: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
840: fetch csr_get_dk_clf into l_table_rec;
841: if csr_get_dk_clf%notfound then

Line 858: ben_dm_data_util.update_pk_mapping

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);
861: end if;
862: --

Line 900: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
903: fetch csr_get_dk_ccm into l_table_rec;
904: if csr_get_dk_ccm%notfound then

Line 921: ben_dm_data_util.update_pk_mapping

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);
924: end if;
925: --

Line 979: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
982: -- Get PGM_ID
983: if x.resolve_mapping_id2 is not null then

Line 1023: ben_dm_data_util.update_pk_mapping

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);
1026: end if;
1027: --

Line 1080: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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
1083: l_target_id1 := get_target_id_for_mapping(x.resolve_mapping_id1);
1084: end if;

Line 1126: ben_dm_data_util.update_pk_mapping

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);
1129: end if;
1130: --

Line 1168: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
1171: fetch csr_get_dk_ler into l_table_rec;
1172: if csr_get_dk_ler%notfound then

Line 1189: ben_dm_data_util.update_pk_mapping

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);
1192: end if;
1193: --

Line 1233: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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
1235: l_target_id1 := get_target_id_for_mapping(x.resolve_mapping_id1);
1236: -- Get PLIP_ID
1237: l_target_id2 := get_target_id_for_mapping(x.resolve_mapping_id2);

Line 1260: ben_dm_data_util.update_pk_mapping

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);
1263: end if;
1264: --

Line 1306: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
1309: -- Get OPT_ID
1310: l_target_id2 := get_target_id_for_mapping(x.resolve_mapping_id2);

Line 1333: ben_dm_data_util.update_pk_mapping

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);
1336: end if;
1337: --

Line 1375: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
1378: fetch csr_get_dk_opt into l_table_rec;
1379: if csr_get_dk_opt%notfound then

Line 1396: ben_dm_data_util.update_pk_mapping

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);
1399: end if;
1400: --

Line 1438: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
1441: fetch csr_get_dk_pgm into l_table_rec;
1442: if csr_get_dk_pgm%notfound then

Line 1459: ben_dm_data_util.update_pk_mapping

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);
1462: end if;
1463: --

Line 1505: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
1508: -- Get PL_ID
1509: l_target_id2 := get_target_id_for_mapping(x.resolve_mapping_id2);

Line 1532: ben_dm_data_util.update_pk_mapping

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);
1535: end if;
1536: --

Line 1574: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
1577: fetch csr_get_dk_pln into l_table_rec;
1578: if csr_get_dk_pln%notfound then

Line 1595: ben_dm_data_util.update_pk_mapping

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);
1598: end if;
1599: --

Line 1637: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
1640: fetch csr_get_dk_ptp into l_table_rec;
1641: if csr_get_dk_ptp%notfound then

Line 1658: ben_dm_data_util.update_pk_mapping

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);
1661: end if;
1662: --

Line 1704: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
1707: -- Get PL_TYP_ID
1708: l_target_id2 := get_target_id_for_mapping(x.resolve_mapping_id2);

Line 1731: ben_dm_data_util.update_pk_mapping

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);
1734: end if;
1735: --

Line 1773: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
1776: fetch csr_get_dk_yrp into l_table_rec;
1777: if csr_get_dk_yrp%notfound then

Line 1794: ben_dm_data_util.update_pk_mapping

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);
1797: end if;
1798: --

Line 1836: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
1839: fetch csr_get_dk_fra into l_table_rec;
1840: if csr_get_dk_fra%notfound then

Line 1857: ben_dm_data_util.update_pk_mapping

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);
1860: end if;
1861: --

Line 1899: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
1902: fetch csr_get_dk_fit into l_table_rec;
1903: if csr_get_dk_fit%notfound then

Line 1920: ben_dm_data_util.update_pk_mapping

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);
1923: end if;
1924: --

Line 1962: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
1965: fetch csr_get_dk_fus into l_table_rec;
1966: if csr_get_dk_fus%notfound then

Line 1983: ben_dm_data_util.update_pk_mapping

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);
1986: end if;
1987: --

Line 2025: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
2028: fetch csr_get_dk_aou into l_table_rec;
2029: if csr_get_dk_aou%notfound then

Line 2046: ben_dm_data_util.update_pk_mapping

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);
2049: end if;
2050: --

Line 2092: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
2095: fetch csr_get_dk_ori into l_table_rec;
2096: if csr_get_dk_ori%notfound then

Line 2113: ben_dm_data_util.update_pk_mapping

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);
2116: end if;
2117: --

Line 2158: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
2161: fetch csr_get_dk_loc into l_table_rec;
2162: if csr_get_dk_loc%notfound then

Line 2179: ben_dm_data_util.update_pk_mapping

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);
2182: end if;
2183: --

Line 2221: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
2224: fetch csr_get_dk_prl into l_table_rec;
2225: if csr_get_dk_prl%notfound then

Line 2242: ben_dm_data_util.update_pk_mapping

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);
2245: end if;
2246: --

Line 2285: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
2288: fetch csr_get_dk_pet into l_table_rec;
2289: if csr_get_dk_pet%notfound then

Line 2306: ben_dm_data_util.update_pk_mapping

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);
2309: end if;
2310: --

Line 2353: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
2356: --
2357: open csr_get_dk_ipv (c_source_key => x.source_key

Line 2378: ben_dm_data_util.update_pk_mapping

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);
2381: end if;
2382: --

Line 2428: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
2431: l_user_status := substr(x.source_key,1,l_pos1-1);
2432: l_legislation_code := substr(x.source_key,l_pos1+1,l_pos2-l_pos1-1);

Line 2465: ben_dm_data_util.update_pk_mapping

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);
2468: end if;
2469: --

Line 2507: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
2510: fetch csr_get_dk_gra into l_table_rec;
2511: if csr_get_dk_gra%notfound then

Line 2528: ben_dm_data_util.update_pk_mapping

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);
2531: end if;
2532: --

Line 2570: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
2573: fetch csr_get_dk_job into l_table_rec;
2574: if csr_get_dk_job%notfound then

Line 2591: ben_dm_data_util.update_pk_mapping

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);
2594: end if;
2595: --

Line 2633: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
2636: fetch csr_get_dk_pyb into l_table_rec;
2637: if csr_get_dk_pyb%notfound then

Line 2654: ben_dm_data_util.update_pk_mapping

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);
2657: end if;
2658: --

Line 2696: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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);
2699: fetch csr_get_dk_prt into l_table_rec;
2700: if csr_get_dk_prt%notfound then

Line 2717: ben_dm_data_util.update_pk_mapping

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);
2720: end if;
2721: --

Line 2759: l_business_group_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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:
2762: open csr_get_dk_aat (c_source_key => x.source_key
2763: ,c_business_group_id => l_business_group_id);

Line 2782: ben_dm_data_util.update_pk_mapping

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);
2785: end if;
2786: --

Line 2827: l_business_group_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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: --
2830: l_target_id1 := get_target_id_for_mapping(x.resolve_mapping_id1);
2831: --

Line 2853: ben_dm_data_util.update_pk_mapping

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);
2856: end if;
2857: --

Line 2897: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

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;
2900: if csr_get_dk_scl%notfound then
2901: l_row_fetched := FALSE;

Line 2958: ben_dm_data_util.update_pk_mapping

2954: ,p_soft_coding_keyflex_id => l_target_id
2955: ,p_concatenated_segments => l_concatenated_segments
2956: ,p_validate => FALSE);
2957:
2958: ben_dm_data_util.update_pk_mapping
2959: (p_resolve_mapping_id => x.resolve_mapping_id
2960: ,p_target_id => l_target_id);
2961: end if;
2962: --

Line 3005: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);

3001: for x in csr_get_all_peg loop
3002:
3003: hr_general.g_data_migrator_mode := 'Y';
3004:
3005: l_bg_id := ben_dm_data_util.get_bg_id(x.business_group_name);
3006:
3007: open csr_get_dk_peg (c_entity_result_id => x.resolve_mapping_id1);
3008: fetch csr_get_dk_peg into l_table_rec;
3009: if csr_get_dk_peg%notfound then

Line 3110: ben_dm_data_util.update_pk_mapping

3106: ,p_group_name => l_group_name
3107: ,p_validate => FALSE);
3108:
3109: */
3110: ben_dm_data_util.update_pk_mapping
3111: (p_resolve_mapping_id => x.resolve_mapping_id
3112: ,p_target_id => l_target_id);
3113: end if;
3114: --