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_DOWNLOAD_DK dependencies on BEN_DM_RESOLVE_MAPPINGS

Line 85: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

81: l_row_fetched boolean := FALSE;
82: l_table_rec csr_get_dk_apr%rowtype;
83: l_table_name varchar2(30) := 'BEN_ACTL_PREM_F';
84: l_column_name varchar2(30) := 'ACTL_PREM_ID';
85: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
86:
87: begin
88:
89: l_rec_inserted_cnt := 0;

Line 121: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

117: -- <>
118: null;
119: else
120: --
121: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
122: --
123: ben_dm_data_util.create_pk_mapping
124: (p_resolve_mapping_id => l_resolve_mapping_id
125: ,p_table_name => l_table_name

Line 154: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

150: l_row_fetched boolean := FALSE;
151: l_table_rec csr_get_dk_eat%rowtype;
152: l_table_name varchar2(30) := 'BEN_ACTN_TYP';
153: l_column_name varchar2(30) := 'ACTN_TYP_ID';
154: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
155:
156: begin
157:
158: --

Line 186: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

182: -- <>
183: null;
184: else
185: --
186: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
187: --
188: ben_dm_data_util.create_pk_mapping
189: (p_resolve_mapping_id => l_resolve_mapping_id
190: ,p_table_name => l_table_name

Line 219: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

215: l_row_fetched boolean := FALSE;
216: l_table_rec csr_get_dk_abr%rowtype;
217: l_table_name varchar2(30) := 'BEN_ACTY_BASE_RT_F';
218: l_column_name varchar2(30) := 'ACTY_BASE_RT_ID';
219: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
220:
221: begin
222:
223: --

Line 251: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

247: -- <>
248: null;
249: else
250: --
251: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
252: --
253: ben_dm_data_util.create_pk_mapping
254: (p_resolve_mapping_id => l_resolve_mapping_id
255: ,p_table_name => l_table_name

Line 284: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

280: l_row_fetched boolean := FALSE;
281: l_table_rec csr_get_dk_bng%rowtype;
282: l_table_name varchar2(30) := 'BEN_BENFTS_GRP';
283: l_column_name varchar2(30) := 'BENFTS_GRP_ID';
284: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
285:
286: begin
287:
288: --

Line 316: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

312: -- <>
313: null;
314: else
315: --
316: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
317: --
318: ben_dm_data_util.create_pk_mapping
319: (p_resolve_mapping_id => l_resolve_mapping_id
320: ,p_table_name => l_table_name

Line 349: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

345: l_row_fetched boolean := FALSE;
346: l_table_rec csr_get_dk_bnb%rowtype;
347: l_table_name varchar2(30) := 'BEN_BNFTS_BAL_F';
348: l_column_name varchar2(30) := 'BNFTS_BAL_ID';
349: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
350:
351: begin
352:
353: --

Line 381: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

377: -- <>
378: null;
379: else
380: --
381: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
382: --
383: ben_dm_data_util.create_pk_mapping
384: (p_resolve_mapping_id => l_resolve_mapping_id
385: ,p_table_name => l_table_name

Line 415: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

411: l_row_fetched boolean := FALSE;
412: l_table_rec csr_get_dk_bpp%rowtype;
413: l_table_name varchar2(30) := 'BEN_BNFT_PRVDR_POOL_F';
414: l_column_name varchar2(30) := 'BNFT_PRVDR_POOL_ID';
415: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
416:
417: begin
418:
419: --

Line 447: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

443: -- <>
444: null;
445: else
446: --
447: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
448: --
449: ben_dm_data_util.create_pk_mapping
450: (p_resolve_mapping_id => l_resolve_mapping_id
451: ,p_table_name => l_table_name

Line 480: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

476: l_row_fetched boolean := FALSE;
477: l_table_rec csr_get_dk_cpl%rowtype;
478: l_table_name varchar2(30) := 'BEN_CMBN_PLIP_F';
479: l_column_name varchar2(30) := 'CMBN_PLIP_ID';
480: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
481:
482: begin
483:
484: --

Line 512: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

508: -- <>
509: null;
510: else
511: --
512: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
513: --
514: ben_dm_data_util.create_pk_mapping
515: (p_resolve_mapping_id => l_resolve_mapping_id
516: ,p_table_name => l_table_name

Line 545: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

541: l_row_fetched boolean := FALSE;
542: l_table_rec csr_get_dk_cbp%rowtype;
543: l_table_name varchar2(30) := 'BEN_CMBN_PTIP_F';
544: l_column_name varchar2(30) := 'CMBN_PTIP_ID';
545: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
546:
547: begin
548:
549: --

Line 577: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

573: -- <>
574: null;
575: else
576: --
577: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
578: --
579: ben_dm_data_util.create_pk_mapping
580: (p_resolve_mapping_id => l_resolve_mapping_id
581: ,p_table_name => l_table_name

Line 610: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

606: l_row_fetched boolean := FALSE;
607: l_table_rec csr_get_dk_cpt%rowtype;
608: l_table_name varchar2(30) := 'BEN_CMBN_PTIP_OPT_F';
609: l_column_name varchar2(30) := 'CMBN_PTIP_OPT_ID';
610: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
611:
612: begin
613:
614: --

Line 642: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

638: -- <>
639: null;
640: else
641: --
642: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
643: --
644: ben_dm_data_util.create_pk_mapping
645: (p_resolve_mapping_id => l_resolve_mapping_id
646: ,p_table_name => l_table_name

Line 675: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

671: l_row_fetched boolean := FALSE;
672: l_table_rec csr_get_dk_bcr%rowtype;
673: l_table_name varchar2(30) := 'BEN_CM_TRGR';
674: l_column_name varchar2(30) := 'CM_TRGR_ID';
675: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
676:
677: begin
678:
679: --

Line 707: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

703: -- <>
704: null;
705: else
706: --
707: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
708: --
709: ben_dm_data_util.create_pk_mapping
710: (p_resolve_mapping_id => l_resolve_mapping_id
711: ,p_table_name => l_table_name

Line 740: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

736: l_row_fetched boolean := FALSE;
737: l_table_rec csr_get_dk_cct%rowtype;
738: l_table_name varchar2(30) := 'BEN_CM_TYP_F';
739: l_column_name varchar2(30) := 'CM_TYP_ID';
740: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
741:
742: begin
743:
744: --

Line 772: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

768: -- <>
769: null;
770: else
771: --
772: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
773: --
774: ben_dm_data_util.create_pk_mapping
775: (p_resolve_mapping_id => l_resolve_mapping_id
776: ,p_table_name => l_table_name

Line 805: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

801: l_row_fetched boolean := FALSE;
802: l_table_rec csr_get_dk_clf%rowtype;
803: l_table_name varchar2(30) := 'BEN_COMP_LVL_FCTR';
804: l_column_name varchar2(30) := 'COMP_LVL_FCTR_ID';
805: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
806:
807: begin
808:
809: --

Line 837: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

833: -- <>
834: null;
835: else
836: --
837: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
838: --
839: ben_dm_data_util.create_pk_mapping
840: (p_resolve_mapping_id => l_resolve_mapping_id
841: ,p_table_name => l_table_name

Line 870: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

866: l_row_fetched boolean := FALSE;
867: l_table_rec csr_get_dk_ccm%rowtype;
868: l_table_name varchar2(30) := 'BEN_CVG_AMT_CALC_MTHD_F';
869: l_column_name varchar2(30) := 'CVG_AMT_CALC_MTHD_ID';
870: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
871:
872: begin
873:
874: --

Line 902: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

898: -- <>
899: null;
900: else
901: --
902: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
903: --
904: ben_dm_data_util.create_pk_mapping
905: (p_resolve_mapping_id => l_resolve_mapping_id
906: ,p_table_name => l_table_name

Line 945: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

941: l_table_rec csr_get_dk_enp%rowtype;
942: l_table_rec_pop csr_get_dk_pop%rowtype;
943: l_table_name varchar2(30) := 'BEN_ENRT_PERD';
944: l_column_name varchar2(30) := 'ENRT_PERD_ID';
945: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
946: l_yr_perd_id number;
947: l_popl_enrt_typ_cycl_id number;
948: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
949: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;

Line 948: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;

944: l_column_name varchar2(30) := 'ENRT_PERD_ID';
945: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
946: l_yr_perd_id number;
947: l_popl_enrt_typ_cycl_id number;
948: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
949: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;
950: l_resolve_mapping_id3 ben_dm_resolve_mappings.resolve_mapping_id%type;
951:
952: begin

Line 949: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;

945: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
946: l_yr_perd_id number;
947: l_popl_enrt_typ_cycl_id number;
948: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
949: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;
950: l_resolve_mapping_id3 ben_dm_resolve_mappings.resolve_mapping_id%type;
951:
952: begin
953:

Line 950: l_resolve_mapping_id3 ben_dm_resolve_mappings.resolve_mapping_id%type;

946: l_yr_perd_id number;
947: l_popl_enrt_typ_cycl_id number;
948: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
949: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;
950: l_resolve_mapping_id3 ben_dm_resolve_mappings.resolve_mapping_id%type;
951:
952: begin
953:
954: --

Line 1012: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

1008: get_dk_frm_yrp (p_business_group_name => p_business_group_name
1009: ,p_source_id => l_table_rec.yr_perd_id
1010: ,p_resolve_mapping_id => l_resolve_mapping_id1);
1011: --
1012: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
1013: --
1014: ben_dm_data_util.create_pk_mapping
1015: (p_resolve_mapping_id => l_resolve_mapping_id
1016: ,p_table_name => l_table_name

Line 1062: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

1058: l_table_rec csr_get_dk_len%rowtype;
1059: l_table_rec_pop csr_get_dk_pop%rowtype;
1060: l_table_name varchar2(30) := 'BEN_LEE_RSN_F';
1061: l_column_name varchar2(30) := 'LEE_RSN_ID';
1062: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1063: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
1064: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;
1065: l_resolve_mapping_id3 ben_dm_resolve_mappings.resolve_mapping_id%type;
1066:

Line 1063: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;

1059: l_table_rec_pop csr_get_dk_pop%rowtype;
1060: l_table_name varchar2(30) := 'BEN_LEE_RSN_F';
1061: l_column_name varchar2(30) := 'LEE_RSN_ID';
1062: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1063: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
1064: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;
1065: l_resolve_mapping_id3 ben_dm_resolve_mappings.resolve_mapping_id%type;
1066:
1067: begin

Line 1064: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;

1060: l_table_name varchar2(30) := 'BEN_LEE_RSN_F';
1061: l_column_name varchar2(30) := 'LEE_RSN_ID';
1062: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1063: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
1064: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;
1065: l_resolve_mapping_id3 ben_dm_resolve_mappings.resolve_mapping_id%type;
1066:
1067: begin
1068:

Line 1065: l_resolve_mapping_id3 ben_dm_resolve_mappings.resolve_mapping_id%type;

1061: l_column_name varchar2(30) := 'LEE_RSN_ID';
1062: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1063: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
1064: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;
1065: l_resolve_mapping_id3 ben_dm_resolve_mappings.resolve_mapping_id%type;
1066:
1067: begin
1068:
1069: --

Line 1128: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

1124: ben_dm_utility.message('INFO','new ler id 0 : ' || l_table_rec.ler_id,5) ;
1125: ben_dm_utility.message('INFO','new ler id : ' || l_resolve_mapping_id1,5) ;
1126: --
1127: --
1128: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
1129: --
1130: ben_dm_data_util.create_pk_mapping
1131: (p_resolve_mapping_id => l_resolve_mapping_id
1132: ,p_table_name => l_table_name

Line 1167: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

1163: l_row_fetched boolean := FALSE;
1164: l_table_rec csr_get_dk_ler%rowtype;
1165: l_table_name varchar2(30) := 'BEN_LER_F';
1166: l_column_name varchar2(30) := 'LER_ID';
1167: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1168:
1169: begin
1170:
1171: --

Line 1199: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

1195: -- <>
1196: null;
1197: else
1198: --
1199: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
1200: --
1201: ben_dm_data_util.create_pk_mapping
1202: (p_resolve_mapping_id => l_resolve_mapping_id
1203: ,p_table_name => l_table_name

Line 1240: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

1236: l_row_fetched boolean := FALSE;
1237: l_table_rec csr_get_dk_boi%rowtype;
1238: l_table_name varchar2(30) := 'BEN_OIPLIP_F';
1239: l_column_name varchar2(30) := 'OIPLIP_ID';
1240: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1241: l_oipl_id number;
1242: l_plip_id number;
1243: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
1244: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;

Line 1243: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;

1239: l_column_name varchar2(30) := 'OIPLIP_ID';
1240: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1241: l_oipl_id number;
1242: l_plip_id number;
1243: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
1244: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;
1245:
1246: begin
1247:

Line 1244: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;

1240: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1241: l_oipl_id number;
1242: l_plip_id number;
1243: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
1244: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;
1245:
1246: begin
1247:
1248: --

Line 1287: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

1283: get_dk_frm_cpp (p_business_group_name => p_business_group_name
1284: ,p_source_id => l_table_rec.plip_id
1285: ,p_resolve_mapping_id => l_resolve_mapping_id2);
1286: --
1287: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
1288: --
1289: ben_dm_data_util.create_pk_mapping
1290: (p_resolve_mapping_id => l_resolve_mapping_id
1291: ,p_table_name => l_table_name

Line 1323: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

1319: l_row_fetched boolean := FALSE;
1320: l_table_rec csr_get_dk_cop%rowtype;
1321: l_table_name varchar2(30) := 'BEN_OIPL_F';
1322: l_column_name varchar2(30) := 'OIPL_ID';
1323: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1324: l_opt_id number;
1325: l_pl_id number;
1326: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
1327: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;

Line 1326: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;

1322: l_column_name varchar2(30) := 'OIPL_ID';
1323: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1324: l_opt_id number;
1325: l_pl_id number;
1326: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
1327: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;
1328:
1329: begin
1330:

Line 1327: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;

1323: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1324: l_opt_id number;
1325: l_pl_id number;
1326: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
1327: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;
1328:
1329: begin
1330:
1331: -- debug messages

Line 1376: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

1372: ,p_source_id => l_table_rec.opt_id
1373: ,p_resolve_mapping_id => l_resolve_mapping_id2);
1374:
1375: --
1376: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
1377: --
1378: ben_dm_data_util.create_pk_mapping
1379: (p_resolve_mapping_id => l_resolve_mapping_id
1380: ,p_table_name => l_table_name

Line 1419: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

1415: l_row_fetched boolean := FALSE;
1416: l_table_rec csr_get_dk_opt%rowtype;
1417: l_table_name varchar2(30) := 'BEN_OPT_F';
1418: l_column_name varchar2(30) := 'OPT_ID';
1419: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1420:
1421: begin
1422:
1423: --

Line 1451: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

1447: -- <>
1448: null;
1449: else
1450: --
1451: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
1452: --
1453: ben_dm_data_util.create_pk_mapping
1454: (p_resolve_mapping_id => l_resolve_mapping_id
1455: ,p_table_name => l_table_name

Line 1491: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

1487: l_row_fetched boolean := FALSE;
1488: l_table_rec csr_get_dk_pgm%rowtype;
1489: l_table_name varchar2(30) := 'BEN_PGM_F';
1490: l_column_name varchar2(30) := 'PGM_ID';
1491: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1492:
1493: begin
1494:
1495: --

Line 1523: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

1519: -- <>
1520: null;
1521: else
1522: --
1523: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
1524: --
1525: ben_dm_data_util.create_pk_mapping
1526: (p_resolve_mapping_id => l_resolve_mapping_id
1527: ,p_table_name => l_table_name

Line 1563: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

1559: l_row_fetched boolean := FALSE;
1560: l_table_rec csr_get_dk_cpp%rowtype;
1561: l_table_name varchar2(30) := 'BEN_PLIP_F';
1562: l_column_name varchar2(30) := 'PLIP_ID';
1563: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1564: l_pgm_id number;
1565: l_pl_id number;
1566: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
1567: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;

Line 1566: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;

1562: l_column_name varchar2(30) := 'PLIP_ID';
1563: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1564: l_pgm_id number;
1565: l_pl_id number;
1566: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
1567: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;
1568:
1569: begin
1570:

Line 1567: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;

1563: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1564: l_pgm_id number;
1565: l_pl_id number;
1566: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
1567: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;
1568:
1569: begin
1570:
1571: --

Line 1611: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

1607: ,p_source_id => l_table_rec.pl_id
1608: ,p_resolve_mapping_id => l_resolve_mapping_id2);
1609:
1610: --
1611: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
1612: --
1613: ben_dm_data_util.create_pk_mapping
1614: (p_resolve_mapping_id => l_resolve_mapping_id
1615: ,p_table_name => l_table_name

Line 1654: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

1650: l_row_fetched boolean := FALSE;
1651: l_table_rec csr_get_dk_pln%rowtype;
1652: l_table_name varchar2(30) := 'BEN_PL_F';
1653: l_column_name varchar2(30) := 'PL_ID';
1654: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1655:
1656: begin
1657:
1658: --

Line 1686: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

1682: -- <>
1683: null;
1684: else
1685: --
1686: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
1687: --
1688: ben_dm_data_util.create_pk_mapping
1689: (p_resolve_mapping_id => l_resolve_mapping_id
1690: ,p_table_name => l_table_name

Line 1726: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

1722: l_row_fetched boolean := FALSE;
1723: l_table_rec csr_get_dk_ptp%rowtype;
1724: l_table_name varchar2(30) := 'BEN_PL_TYP_F';
1725: l_column_name varchar2(30) := 'PL_TYP_ID';
1726: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1727:
1728: begin
1729:
1730: --

Line 1758: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

1754: -- <>
1755: null;
1756: else
1757: --
1758: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
1759: --
1760: ben_dm_data_util.create_pk_mapping
1761: (p_resolve_mapping_id => l_resolve_mapping_id
1762: ,p_table_name => l_table_name

Line 1800: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

1796: l_row_fetched boolean := FALSE;
1797: l_table_rec csr_get_dk_ctp%rowtype;
1798: l_table_name varchar2(30) := 'BEN_PTIP_F';
1799: l_column_name varchar2(30) := 'PTIP_ID';
1800: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1801: l_pgm_id number;
1802: l_pl_typ_id number;
1803: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
1804: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;

Line 1803: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;

1799: l_column_name varchar2(30) := 'PTIP_ID';
1800: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1801: l_pgm_id number;
1802: l_pl_typ_id number;
1803: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
1804: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;
1805:
1806: begin
1807:

Line 1804: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;

1800: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1801: l_pgm_id number;
1802: l_pl_typ_id number;
1803: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
1804: l_resolve_mapping_id2 ben_dm_resolve_mappings.resolve_mapping_id%type;
1805:
1806: begin
1807:
1808: --

Line 1844: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

1840: get_dk_frm_ptp (p_business_group_name => p_business_group_name
1841: ,p_source_id => l_table_rec.pl_typ_id
1842: ,p_resolve_mapping_id => l_resolve_mapping_id2);
1843: --
1844: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
1845: --
1846: ben_dm_data_util.create_pk_mapping
1847: (p_resolve_mapping_id => l_resolve_mapping_id
1848: ,p_table_name => l_table_name

Line 1880: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

1876: l_row_fetched boolean := FALSE;
1877: l_table_rec csr_get_dk_yrp%rowtype;
1878: l_table_name varchar2(30) := 'BEN_YR_PERD';
1879: l_column_name varchar2(30) := 'YR_PERD_ID';
1880: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1881:
1882: begin
1883:
1884: --

Line 1912: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

1908: -- <>
1909: null;
1910: else
1911: --
1912: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
1913: --
1914: ben_dm_data_util.create_pk_mapping
1915: (p_resolve_mapping_id => l_resolve_mapping_id
1916: ,p_table_name => l_table_name

Line 1952: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

1948: l_row_fetched boolean := FALSE;
1949: l_table_rec csr_get_dk_fra%rowtype;
1950: l_table_name varchar2(30) := 'FF_FORMULAS_F';
1951: l_column_name varchar2(30) := 'FORMULA_ID';
1952: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
1953:
1954: begin
1955:
1956: --

Line 1984: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

1980: -- <>
1981: null;
1982: else
1983: --
1984: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
1985: --
1986: ben_dm_data_util.create_pk_mapping
1987: (p_resolve_mapping_id => l_resolve_mapping_id
1988: ,p_table_name => l_table_name

Line 2017: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

2013: l_row_fetched boolean := FALSE;
2014: l_table_rec csr_get_dk_fit%rowtype;
2015: l_table_name varchar2(30) := 'FND_ID_FLEX_STRUCTURES_VL';
2016: l_column_name varchar2(30) := 'ID_FLEX_NUM';
2017: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2018:
2019: begin
2020:
2021: --

Line 2049: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

2045: -- <>
2046: null;
2047: else
2048: --
2049: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
2050: --
2051: ben_dm_data_util.create_pk_mapping
2052: (p_resolve_mapping_id => l_resolve_mapping_id
2053: ,p_table_name => l_table_name

Line 2082: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

2078: l_row_fetched boolean := FALSE;
2079: l_table_rec csr_get_dk_fus%rowtype;
2080: l_table_name varchar2(30) := 'FND_USER';
2081: l_column_name varchar2(30) := 'USER_ID';
2082: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2083:
2084: begin
2085:
2086: --

Line 2114: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

2110: -- <>
2111: null;
2112: else
2113: --
2114: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
2115: --
2116: ben_dm_data_util.create_pk_mapping
2117: (p_resolve_mapping_id => l_resolve_mapping_id
2118: ,p_table_name => l_table_name

Line 2147: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

2143: l_row_fetched boolean := FALSE;
2144: l_table_rec csr_get_dk_aou%rowtype;
2145: l_table_name varchar2(30) := 'HR_ALL_ORGANIZATION_UNITS';
2146: l_column_name varchar2(30) := 'ORGANIZATION_ID';
2147: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2148: begin
2149:
2150: --
2151: -- Check to see if this developer key already exists in the BEN_DM_DEVELOPER_KEYS table

Line 2178: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

2174: -- <>
2175: null;
2176: else
2177: --
2178: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
2179: --
2180: -- when the business_group_id and organization id is the same
2181: -- assign target bg name into source key
2182: if l_table_rec.business_group_id = p_source_id then

Line 2208: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

2204: -- Declare local variables
2205: l_proc varchar2(72) := g_package || 'get_dk_frm_ori';
2206: l_table_name varchar2(30) := 'HR_ORGANIZATION_INFORMATION';
2207: l_column_name varchar2(30) := 'ORGANIZATION_ID';
2208: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2209:
2210: begin
2211:
2212: --

Line 2213: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

2209:
2210: begin
2211:
2212: --
2213: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
2214: --
2215: ben_dm_data_util.create_pk_mapping
2216: (p_resolve_mapping_id => l_resolve_mapping_id
2217: ,p_table_name => l_table_name

Line 2244: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

2240: l_row_fetched boolean := FALSE;
2241: l_table_rec csr_get_dk_loc%rowtype;
2242: l_table_name varchar2(30) := 'HR_LOCATIONS_ALL';
2243: l_column_name varchar2(30) := 'LOCATION_ID';
2244: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2245:
2246: begin
2247:
2248: --

Line 2276: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

2272: -- <>
2273: null;
2274: else
2275: --
2276: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
2277: --
2278: ben_dm_data_util.create_pk_mapping
2279: (p_resolve_mapping_id => l_resolve_mapping_id
2280: ,p_table_name => l_table_name

Line 2309: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

2305: l_row_fetched boolean := FALSE;
2306: l_table_rec csr_get_dk_prl%rowtype;
2307: l_table_name varchar2(30) := 'PAY_ALL_PAYROLLS_F';
2308: l_column_name varchar2(30) := 'PAYROLL_ID';
2309: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2310:
2311: begin
2312:
2313: --

Line 2341: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

2337: -- <>
2338: null;
2339: else
2340: --
2341: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
2342: --
2343: ben_dm_data_util.create_pk_mapping
2344: (p_resolve_mapping_id => l_resolve_mapping_id
2345: ,p_table_name => l_table_name

Line 2374: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

2370: l_row_fetched boolean := FALSE;
2371: l_table_rec csr_get_dk_pet%rowtype;
2372: l_table_name varchar2(30) := 'PAY_ELEMENT_TYPES_F';
2373: l_column_name varchar2(30) := 'ELEMENT_TYPE_ID';
2374: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2375:
2376: begin
2377:
2378: --

Line 2406: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

2402: -- <>
2403: null;
2404: else
2405: --
2406: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
2407: --
2408: ben_dm_data_util.create_pk_mapping
2409: (p_resolve_mapping_id => l_resolve_mapping_id
2410: ,p_table_name => l_table_name

Line 2448: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

2444: l_table_rec csr_get_dk_ipv%rowtype;
2445: l_table_name varchar2(30) := 'PAY_INPUT_VALUES_F';
2446: l_column_name varchar2(30) := 'INPUT_VALUE_ID';
2447: l_element_type_id number;
2448: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2449: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
2450:
2451: begin
2452:

Line 2449: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;

2445: l_table_name varchar2(30) := 'PAY_INPUT_VALUES_F';
2446: l_column_name varchar2(30) := 'INPUT_VALUE_ID';
2447: l_element_type_id number;
2448: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2449: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
2450:
2451: begin
2452:
2453: --

Line 2485: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

2481: ,p_source_id => l_table_rec.element_type_id
2482: ,p_resolve_mapping_id => l_resolve_mapping_id1);
2483:
2484: --
2485: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
2486: --
2487: ben_dm_data_util.create_pk_mapping
2488: (p_resolve_mapping_id => l_resolve_mapping_id
2489: ,p_table_name => l_table_name

Line 2521: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

2517: l_table_rec csr_get_dk_pll%rowtype;
2518: l_table_name varchar2(30) := 'PAY_ELEMENT_LINKS_F';
2519: l_column_name varchar2(30) := 'ELEMENT_LINK_ID';
2520: l_element_type_id number;
2521: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2522: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
2523:
2524: begin
2525:

Line 2522: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;

2518: l_table_name varchar2(30) := 'PAY_ELEMENT_LINKS_F';
2519: l_column_name varchar2(30) := 'ELEMENT_LINK_ID';
2520: l_element_type_id number;
2521: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2522: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
2523:
2524: begin
2525:
2526: --

Line 2558: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

2554: ,p_source_id => l_table_rec.element_type_id
2555: ,p_resolve_mapping_id => l_resolve_mapping_id1);
2556:
2557: --
2558: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
2559: --
2560: ben_dm_data_util.create_pk_mapping
2561: (p_resolve_mapping_id => l_resolve_mapping_id
2562: ,p_table_name => l_table_name

Line 2593: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

2589: l_row_fetched boolean := FALSE;
2590: l_table_rec csr_get_dk_ast%rowtype;
2591: l_table_name varchar2(30) := 'PER_ASSIGNMENT_STATUS_TYPES';
2592: l_column_name varchar2(30) := 'ASSIGNMENT_STATUS_TYPE_ID';
2593: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2594:
2595: begin
2596:
2597: --

Line 2625: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

2621: -- <>
2622: null;
2623: else
2624: --
2625: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
2626: --
2627: ben_dm_data_util.create_pk_mapping
2628: (p_resolve_mapping_id => l_resolve_mapping_id
2629: ,p_table_name => l_table_name

Line 2658: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

2654: l_row_fetched boolean := FALSE;
2655: l_table_rec csr_get_dk_gra%rowtype;
2656: l_table_name varchar2(30) := 'PER_GRADES';
2657: l_column_name varchar2(30) := 'GRADE_ID';
2658: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2659:
2660: begin
2661:
2662: --

Line 2690: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

2686: -- <>
2687: null;
2688: else
2689: --
2690: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
2691: --
2692: ben_dm_data_util.create_pk_mapping
2693: (p_resolve_mapping_id => l_resolve_mapping_id
2694: ,p_table_name => l_table_name

Line 2723: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

2719: l_row_fetched boolean := FALSE;
2720: l_table_rec csr_get_dk_job%rowtype;
2721: l_table_name varchar2(30) := 'PER_JOBS';
2722: l_column_name varchar2(30) := 'JOB_ID';
2723: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2724:
2725: begin
2726:
2727: --

Line 2755: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

2751: -- <>
2752: null;
2753: else
2754: --
2755: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
2756: --
2757: ben_dm_data_util.create_pk_mapping
2758: (p_resolve_mapping_id => l_resolve_mapping_id
2759: ,p_table_name => l_table_name

Line 2788: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

2784: l_row_fetched boolean := FALSE;
2785: l_table_rec csr_get_dk_pyb%rowtype;
2786: l_table_name varchar2(30) := 'PER_PAY_BASES';
2787: l_column_name varchar2(30) := 'PAY_BASIS_ID';
2788: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2789:
2790: begin
2791:
2792: --

Line 2820: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

2816: -- <>
2817: null;
2818: else
2819: --
2820: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
2821: --
2822: ben_dm_data_util.create_pk_mapping
2823: (p_resolve_mapping_id => l_resolve_mapping_id
2824: ,p_table_name => l_table_name

Line 2853: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

2849: l_row_fetched boolean := FALSE;
2850: l_table_rec csr_get_dk_prt%rowtype;
2851: l_table_name varchar2(30) := 'PER_PERSON_TYPES';
2852: l_column_name varchar2(30) := 'PERSON_TYPE_ID';
2853: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2854:
2855: begin
2856:
2857: --

Line 2885: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

2881: -- <>
2882: null;
2883: else
2884: --
2885: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
2886: --
2887: ben_dm_data_util.create_pk_mapping
2888: (p_resolve_mapping_id => l_resolve_mapping_id
2889: ,p_table_name => l_table_name

Line 2918: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

2914: l_row_fetched boolean := FALSE;
2915: l_table_rec csr_get_dk_aat%rowtype;
2916: l_table_name varchar2(30) := 'PER_ABSENCE_ATTENDANCE_TYPES';
2917: l_column_name varchar2(30) := 'ABSENCE_ATTENDANCE_TYPE_ID';
2918: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2919:
2920: begin
2921:
2922: --

Line 2950: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

2946: -- <>
2947: null;
2948: else
2949: --
2950: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
2951: --
2952: ben_dm_data_util.create_pk_mapping
2953: (p_resolve_mapping_id => l_resolve_mapping_id
2954: ,p_table_name => l_table_name

Line 2994: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

2990: l_row_fetched boolean := FALSE;
2991: l_table_rec csr_get_dk_aar%rowtype;
2992: l_table_name varchar2(30) := 'PER_ABS_ATTENDANCE_REASONS';
2993: l_column_name varchar2(30) := 'ABS_ATTENDANCE_REASON_ID';
2994: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2995: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
2996:
2997: begin
2998:

Line 2995: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;

2991: l_table_rec csr_get_dk_aar%rowtype;
2992: l_table_name varchar2(30) := 'PER_ABS_ATTENDANCE_REASONS';
2993: l_column_name varchar2(30) := 'ABS_ATTENDANCE_REASON_ID';
2994: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
2995: l_resolve_mapping_id1 ben_dm_resolve_mappings.resolve_mapping_id%type;
2996:
2997: begin
2998:
2999: --

Line 3031: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

3027: get_dk_frm_aat(p_business_group_name => p_business_group_name
3028: ,p_source_id => l_table_rec.absence_attendance_type_id
3029: ,p_resolve_mapping_id => l_resolve_mapping_id1);
3030: --
3031: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
3032: --
3033: ben_dm_data_util.create_pk_mapping
3034: (p_resolve_mapping_id => l_resolve_mapping_id
3035: ,p_table_name => l_table_name

Line 3068: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

3064: l_row_fetched boolean := FALSE;
3065: l_table_rec csr_get_dk_scl%rowtype;
3066: l_table_name varchar2(30) := 'HR_SOFT_CODING_KEYFLEX';
3067: l_column_name varchar2(30) := 'SOFT_CODING_KEYFLEX_ID';
3068: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
3069: l_migration_id number;
3070: l_result_id number;
3071:
3072: begin

Line 3102: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

3098: -- <>
3099: null;
3100: else
3101: --
3102: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
3103: --
3104:
3105: select max(migration_id)
3106: into l_migration_id

Line 3191: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;

3187: l_row_fetched boolean := FALSE;
3188: l_table_rec csr_get_dk_peg%rowtype;
3189: l_table_name varchar2(30) := 'PAY_PEOPLE_GROUPS';
3190: l_column_name varchar2(30) := 'PEOPLE_GROUP_ID';
3191: l_resolve_mapping_id ben_dm_resolve_mappings.resolve_mapping_id%type;
3192: l_migration_id number;
3193: l_result_id number;
3194:
3195: begin

Line 3225: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.

3221: -- <>
3222: null;
3223: else
3224: --
3225: -- Seed DK data into BEN_DM_RESOLVE_MAPPINGS table.
3226: --
3227:
3228: select max(migration_id)
3229: into l_migration_id