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_UTILITY

Line 60: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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:

Line 85: -- ben_dm_utility.message('PARA','(p_dk_apr - ' || l_table_rec.name ||')', 10);

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;

Line 92: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 127: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 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

Line 152: ben_dm_utility.message('INFO','target : ' || l_table_rec.actn_typ_id,5) ;

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

Line 153: ben_dm_utility.message('INFO','mapping : ' || x.resolve_mapping_id,5) ;

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

Line 163: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 196: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 225: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 258: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 287: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 322: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

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

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

Line 331: ben_dm_utility.message('INFO','l_bg_id '||l_bg_id,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);
335: fetch csr_get_dk_pll into l_table_rec;

Line 359: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 393: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 422: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 456: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 485: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 519: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 548: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 582: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 611: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 645: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 674: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 708: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 737: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 771: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 800: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 835: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 864: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 898: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 927: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 977: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 1029: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 1078: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 1132: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 1166: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 1195: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 1266: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 1304: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 1339: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 1373: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 1402: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 1436: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 1465: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 1503: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 1538: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 1572: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 1601: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 1635: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 1664: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 1702: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 1737: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 1771: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 1800: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 1834: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 1863: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 1897: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 1926: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 1960: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 1989: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 2023: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 2052: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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:

Line 2090: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 2119: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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:

Line 2156: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 2185: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 2219: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 2248: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 2283: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 2312: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 2351: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 2384: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 2426: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 2439: ben_dm_utility.message('INFO','l_pos1 '||l_pos1,5) ;

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

Line 2440: ben_dm_utility.message('INFO','l_pos2 '||l_pos2,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

Line 2441: ben_dm_utility.message('INFO','l_user_status '||l_user_status,5) ;

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

Line 2442: ben_dm_utility.message('INFO','l_legislation_code '||l_legislation_code,5) ;

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

Line 2443: ben_dm_utility.message('INFO','l_business_group_id '||l_business_group_id,5) ;

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;

Line 2471: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 2505: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 2534: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 2568: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 2597: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 2631: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 2660: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 2694: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 2723: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 2757: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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:

Line 2760: ben_dm_utility.message('INFO','l_business_group_id '||l_business_group_id,5) ;

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;

Line 2788: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 2825: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 2828: ben_dm_utility.message('INFO','l_business_group_id '||l_business_group_id,5) ;

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

Line 2859: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 2895: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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;

Line 2964: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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

Line 3000: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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:

Line 3116: ben_dm_utility.message('INFO','Leaving : ' || l_proc,5) ;

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:

Line 3135: ben_dm_utility.message('INFO','Entering : ' || l_proc,5) ;

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

Line 3272: ben_dm_utility.message('INFO','Start of Report for Unresolved Developer Keys',5) ;

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

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

Line 3277: ben_dm_utility.message('INFO','Table_Name : ' || x.table_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: --

Line 3278: ben_dm_utility.message('INFO','Column_Name : ' || x.column_name,5);

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;

Line 3279: ben_dm_utility.message('INFO','Source_Key : ' || x.source_key,5);

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

Line 3280: ben_dm_utility.message('INFO','Business_Group_name : ' || x.business_group_name,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:

Line 3283: ben_dm_utility.message('INFO','End of Report for Unresolved Developer Keys',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:
3285: if l_unresolved_dk then
3286: ben_dm_utility.message('INFO','Error : Unresolved Developer Keys',5) ;
3287: raise no_dk;

Line 3286: ben_dm_utility.message('INFO','Error : Unresolved Developer Keys',5) ;

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

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

Line 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: