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_MANAGE_LIFE_EVENTS dependencies on BEN_DETERMINE_ELIGIBILITY

Line 636: calling ben_determine_eligibility.determine_elig_prfls.

632: 01 May 00 pbodla 115.200 - Task 131 : Elig dependent rows are
633: created before creating the electable
634: choice rows. Called procedures
635: ben_determine_dpnt_eligibility.main()after
636: calling ben_determine_eligibility.determine_elig_prfls.
637: p_upd_egd_with_epe_id called after
638: electable choice is created to set
639: electable choice id on dependent rows.
640: 12 May 00 mhoyes 115.201 - Pulled filtering out nocopy of benmngle into

Line 716: 05 Oct 00 gperry 115.230 Fixed call to ben_determine_eligibility

712: - Pil no longer required to be voided
713: if there is no impact of it on
714: eligibility, rates etc.,. It should
715: become processed.
716: 05 Oct 00 gperry 115.230 Fixed call to ben_determine_eligibility
717: so that it passes the life event
718: occurred date as p_effective_date
719: when run in selection mode. This
720: is due to how least work in bendete2

Line 1133: ben_determine_eligibility2.g_cache_first_inelig_object,ben_determine_eligibility2.g_cache_first_elig_object

1129: profile validation should happen
1130: 13-Sep-11 usaraswa 120.28.12010000.13 Bug 12715758 : In Process_comp_objects while calling ben_comp_obj_filter.filter_comp_objects sending
1131: p_effective_date instead of nvl(l_rec.lf_evt_ocrd_dt,p_effective_date).
1132: 14-Dec-11 usaraswa 120.28.12010000.14 Bug 12732878 : Added procedure check_for_first_eligible to check whether the comp objects present in the global variables
1133: ben_determine_eligibility2.g_cache_first_inelig_object,ben_determine_eligibility2.g_cache_first_elig_object
1134: are having any future records are there in ben_elig_per_f and ben_elig_per_opt_f tables.If the future records are present
1135: then inserting the future records in to back up table and deleting the future records.
1136: called the procedure check_for_first_eligible in process_comp_objects.
1137: 10-Oct-12 velvanop 120.28.12010000.15 Bug 14484394: Set g_max_errors_allowed for the Participation Process: Compensation Workbench Conc Program

Line 1165: --ben_determine_eligibility2.g_cache_first_inelig_object,ben_determine_eligibility2.g_cache_first_elig_object

1161: --
1162: -------------------------------------------------------------------------------
1163: --Bug 12732878 ud changes start
1164: --Added procedure check_for_first_eligible to check whether the comp objects present in the global variables
1165: --ben_determine_eligibility2.g_cache_first_inelig_object,ben_determine_eligibility2.g_cache_first_elig_object
1166: --are having any future records in ben_elig_per_f and ben_elig_per_opt_f tables.If the future records are
1167: --present then inserting the future records in to back up table and deleting the future records.
1168:
1169: procedure check_for_first_eligible(

Line 1281: l_first_num := nvl(ben_determine_eligibility2.g_cache_first_elig_object.first,0);

1277: hr_utility.set_location('uxx p_per_in_ler_id '||p_per_in_ler_id,10);
1278: hr_utility.set_location('uxx p_person_id '||p_person_id,10);
1279: hr_utility.set_location('uxx p_effective_date '||p_effective_date,10);
1280:
1281: l_first_num := nvl(ben_determine_eligibility2.g_cache_first_elig_object.first,0);
1282: l_max_num := nvl(ben_determine_eligibility2.g_cache_first_elig_object.last,0);
1283: l_first_num1 := nvl(ben_determine_eligibility2.g_cache_first_inelig_object.first,0);
1284: l_max_num1 := nvl(ben_determine_eligibility2.g_cache_first_inelig_object.last,0);
1285:

Line 1282: l_max_num := nvl(ben_determine_eligibility2.g_cache_first_elig_object.last,0);

1278: hr_utility.set_location('uxx p_person_id '||p_person_id,10);
1279: hr_utility.set_location('uxx p_effective_date '||p_effective_date,10);
1280:
1281: l_first_num := nvl(ben_determine_eligibility2.g_cache_first_elig_object.first,0);
1282: l_max_num := nvl(ben_determine_eligibility2.g_cache_first_elig_object.last,0);
1283: l_first_num1 := nvl(ben_determine_eligibility2.g_cache_first_inelig_object.first,0);
1284: l_max_num1 := nvl(ben_determine_eligibility2.g_cache_first_inelig_object.last,0);
1285:
1286: /* this if handles

Line 1283: l_first_num1 := nvl(ben_determine_eligibility2.g_cache_first_inelig_object.first,0);

1279: hr_utility.set_location('uxx p_effective_date '||p_effective_date,10);
1280:
1281: l_first_num := nvl(ben_determine_eligibility2.g_cache_first_elig_object.first,0);
1282: l_max_num := nvl(ben_determine_eligibility2.g_cache_first_elig_object.last,0);
1283: l_first_num1 := nvl(ben_determine_eligibility2.g_cache_first_inelig_object.first,0);
1284: l_max_num1 := nvl(ben_determine_eligibility2.g_cache_first_inelig_object.last,0);
1285:
1286: /* this if handles
1287: case 1: track inelig flag:'N'

Line 1284: l_max_num1 := nvl(ben_determine_eligibility2.g_cache_first_inelig_object.last,0);

1280:
1281: l_first_num := nvl(ben_determine_eligibility2.g_cache_first_elig_object.first,0);
1282: l_max_num := nvl(ben_determine_eligibility2.g_cache_first_elig_object.last,0);
1283: l_first_num1 := nvl(ben_determine_eligibility2.g_cache_first_inelig_object.first,0);
1284: l_max_num1 := nvl(ben_determine_eligibility2.g_cache_first_inelig_object.last,0);
1285:
1286: /* this if handles
1287: case 1: track inelig flag:'N'
1288: 1.fonm eligible

Line 1297: l_per_in_ler_id := ben_determine_eligibility2.g_cache_first_elig_object(l_first_num).per_in_ler_id;

1293: 3.event eligible in same month as fonm
1294: */
1295: if l_first_num <> 0 then
1296:
1297: l_per_in_ler_id := ben_determine_eligibility2.g_cache_first_elig_object(l_first_num).per_in_ler_id;
1298:
1299: hr_utility.set_location('uxx l_per_in_ler_id '||l_per_in_ler_id,10);
1300: hr_utility.set_location('uxx l_first_num '||l_first_num,10);
1301: hr_utility.set_location('uxx l_max_num '||l_max_num,10);

Line 1314: l_elig_per_id :=ben_determine_eligibility2.g_cache_first_elig_object(i).elig_per_id;

1310:
1311: for i in l_first_num..l_max_num loop --b
1312:
1313: hr_utility.set_location('uxx Start loop',10);
1314: l_elig_per_id :=ben_determine_eligibility2.g_cache_first_elig_object(i).elig_per_id;
1315: hr_utility.set_location('uxx l_elig_per_id '||l_elig_per_id,10);
1316:
1317: open c_elig_rec(l_elig_per_id,l_per_in_ler_id);
1318: fetch c_elig_rec into l_elig_per_rec;

Line 1342: ben_determine_eligibility3.save_to_restore

1338: hr_utility.set_location('uxx l_fut_elig_per_opt_rec.elig_per_opt_id '||l_fut_elig_per_opt_rec.elig_per_opt_id,10);
1339:
1340: if (l_fut_elig_per_opt_rec.elig_per_opt_id is not null) then
1341:
1342: ben_determine_eligibility3.save_to_restore
1343: (p_current_per_in_ler_id => l_per_in_ler_id
1344: ,p_per_in_ler_id => l_prev_pil_id
1345: ,p_elig_per_id => NUll
1346: ,p_elig_per_opt_id => l_fut_elig_per_opt_rec.elig_per_opt_id

Line 1357: ben_determine_eligibility3.save_to_restore

1353: end if;
1354: end loop;
1355: close c_prev_elig_opt_rec;
1356:
1357: ben_determine_eligibility3.save_to_restore
1358: (p_current_per_in_ler_id => l_per_in_ler_id
1359: ,p_per_in_ler_id => l_prev_pil_id
1360: ,p_elig_per_id => l_fut_elig_per_rec.elig_per_id
1361: ,p_elig_per_opt_id => NULL

Line 1403: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).pgm_id

1399: hr_utility.set_location('l_prev_pil_id '||l_prev_pil_id,10);
1400:
1401: for i in l_first_num1..l_max_num1 loop
1402: open c_prev_elig_rec(l_prev_pil_id
1403: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).pgm_id
1404: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).pl_id
1405: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).ptip_id
1406: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).plip_id
1407: ,p_effective_date);

Line 1404: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).pl_id

1400:
1401: for i in l_first_num1..l_max_num1 loop
1402: open c_prev_elig_rec(l_prev_pil_id
1403: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).pgm_id
1404: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).pl_id
1405: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).ptip_id
1406: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).plip_id
1407: ,p_effective_date);
1408: fetch c_prev_elig_rec into l_fut_elig_per_rec;

Line 1405: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).ptip_id

1401: for i in l_first_num1..l_max_num1 loop
1402: open c_prev_elig_rec(l_prev_pil_id
1403: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).pgm_id
1404: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).pl_id
1405: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).ptip_id
1406: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).plip_id
1407: ,p_effective_date);
1408: fetch c_prev_elig_rec into l_fut_elig_per_rec;
1409: close c_prev_elig_rec;

Line 1406: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).plip_id

1402: open c_prev_elig_rec(l_prev_pil_id
1403: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).pgm_id
1404: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).pl_id
1405: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).ptip_id
1406: ,ben_determine_eligibility2.g_cache_first_inelig_object(i).plip_id
1407: ,p_effective_date);
1408: fetch c_prev_elig_rec into l_fut_elig_per_rec;
1409: close c_prev_elig_rec;
1410:

Line 1448: ben_determine_eligibility3.save_to_restore

1444: fetch c_get_elig_per_opt_rec into l_opt_rec;
1445: close c_get_elig_per_opt_rec;
1446: hr_utility.set_location('l_opt_rec.elig_per_opt_id '||l_opt_rec.elig_per_opt_id,10);
1447: hr_utility.set_location('l_opt_rec.effective_start_date '||l_opt_rec.effective_start_date,10);
1448: ben_determine_eligibility3.save_to_restore
1449: (p_current_per_in_ler_id => p_per_in_ler_id
1450: ,p_per_in_ler_id => l_prev_pil_id
1451: ,p_elig_per_id => NUll
1452: ,p_elig_per_opt_id => l_opt_rec.elig_per_opt_id

Line 1470: ben_determine_eligibility3.save_to_restore

1466: end if;
1467: end loop;
1468: close c_get_option;
1469: hr_utility.set_location('uxx before save to resote',10);
1470: ben_determine_eligibility3.save_to_restore
1471: (p_current_per_in_ler_id => p_per_in_ler_id
1472: ,p_per_in_ler_id => l_prev_pil_id
1473: ,p_elig_per_id => l_fut_elig_per_rec.elig_per_id
1474: ,p_elig_per_opt_id => NULL

Line 1497: ben_determine_eligibility3.save_to_restore

1493: hr_utility.set_location('uxx l_fut_elig_per_opt_rec.elig_per_opt_id '||l_fut_elig_per_opt_rec.elig_per_opt_id,10);
1494:
1495: if (l_fut_elig_per_opt_rec.elig_per_opt_id is not null) then
1496:
1497: ben_determine_eligibility3.save_to_restore
1498: (p_current_per_in_ler_id => p_per_in_ler_id
1499: ,p_per_in_ler_id => l_prev_pil_id
1500: ,p_elig_per_id => NUll
1501: ,p_elig_per_opt_id => l_fut_elig_per_opt_rec.elig_per_opt_id

Line 1513: ben_determine_eligibility3.save_to_restore

1509: end if;
1510: end loop;
1511: close c_prev_elig_opt_rec;
1512:
1513: ben_determine_eligibility3.save_to_restore
1514: (p_current_per_in_ler_id => p_per_in_ler_id
1515: ,p_per_in_ler_id => l_prev_pil_id
1516: ,p_elig_per_id => l_fut_elig_per_rec.elig_per_id
1517: ,p_elig_per_opt_id => NULL

Line 10642: ben_determine_eligibility2.g_cache_first_elig_object.delete;

10638: l_defer_deenrl_tbl.delete;
10639: -- End
10640: --Bug 12732878 ud changes start
10641: --Clearing the cache for every benmngle run
10642: ben_determine_eligibility2.g_cache_first_elig_object.delete;
10643: ben_determine_eligibility2.g_cache_first_inelig_object.delete;
10644: -- Bug 12732878 ud changs end
10645:
10646: dbms_session.free_unused_user_memory;

Line 10643: ben_determine_eligibility2.g_cache_first_inelig_object.delete;

10639: -- End
10640: --Bug 12732878 ud changes start
10641: --Clearing the cache for every benmngle run
10642: ben_determine_eligibility2.g_cache_first_elig_object.delete;
10643: ben_determine_eligibility2.g_cache_first_inelig_object.delete;
10644: -- Bug 12732878 ud changs end
10645:
10646: dbms_session.free_unused_user_memory;
10647: --

Line 11532: fnd_message.set_token('PROC','ben_determine_eligibility');

11528: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
11529: if l_mode not in ('R','T') then
11530: --
11531: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11532: fnd_message.set_token('PROC','ben_determine_eligibility');
11533: if g_debug then
11534: hr_utility.set_location (l_package||' Dn FND Mess ',80);
11535: end if;
11536: --

Line 11549: ben_determine_eligibility.determine_elig_prfls

11545: if g_debug then
11546: hr_utility.set_location (l_package||' BENDETEL ',80);
11547: end if;
11548: --
11549: ben_determine_eligibility.determine_elig_prfls
11550: (p_comp_obj_tree_row => l_comp_obj_tree_row
11551: ,p_par_elig_state => l_par_elig_state
11552: --
11553: ,p_per_row => l_per_row

Line 11676: --if program level comp object is ineligible then inserting the comp object to ben_determine_eligibility2.g_cache_first_inelig_object

11672: );
11673: --
11674: -------------------------------------------------------------------------------
11675: --Bug 12732878 ud changes start
11676: --if program level comp object is ineligible then inserting the comp object to ben_determine_eligibility2.g_cache_first_inelig_object
11677: --for checking any future records are there in ben_elig_per_f and ben_elig_per_opt_f tables.
11678: hr_utility.set_location('In the l_not_eligible if',20);
11679: if l_comp_obj_tree(l_treeele_num).pgm_id is not null then
11680: hr_utility.set_location('l_comp_obj_tree(l_treeele_num).pgm_id'||l_comp_obj_tree(l_treeele_num).pgm_id,10);

Line 11681: ben_determine_eligibility2.g_cache_first_inelig_object.extend;

11677: --for checking any future records are there in ben_elig_per_f and ben_elig_per_opt_f tables.
11678: hr_utility.set_location('In the l_not_eligible if',20);
11679: if l_comp_obj_tree(l_treeele_num).pgm_id is not null then
11680: hr_utility.set_location('l_comp_obj_tree(l_treeele_num).pgm_id'||l_comp_obj_tree(l_treeele_num).pgm_id,10);
11681: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
11682: ben_determine_eligibility2.g_cache_first_inelig_object
11683: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
11684: ben_determine_eligibility2.g_cache_first_inelig_object.last;
11685: ben_determine_eligibility2.g_cache_first_inelig_object

Line 11682: ben_determine_eligibility2.g_cache_first_inelig_object

11678: hr_utility.set_location('In the l_not_eligible if',20);
11679: if l_comp_obj_tree(l_treeele_num).pgm_id is not null then
11680: hr_utility.set_location('l_comp_obj_tree(l_treeele_num).pgm_id'||l_comp_obj_tree(l_treeele_num).pgm_id,10);
11681: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
11682: ben_determine_eligibility2.g_cache_first_inelig_object
11683: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
11684: ben_determine_eligibility2.g_cache_first_inelig_object.last;
11685: ben_determine_eligibility2.g_cache_first_inelig_object
11686: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=

Line 11683: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=

11679: if l_comp_obj_tree(l_treeele_num).pgm_id is not null then
11680: hr_utility.set_location('l_comp_obj_tree(l_treeele_num).pgm_id'||l_comp_obj_tree(l_treeele_num).pgm_id,10);
11681: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
11682: ben_determine_eligibility2.g_cache_first_inelig_object
11683: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
11684: ben_determine_eligibility2.g_cache_first_inelig_object.last;
11685: ben_determine_eligibility2.g_cache_first_inelig_object
11686: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
11687: l_comp_obj_tree(l_treeele_num).pgm_id;

Line 11684: ben_determine_eligibility2.g_cache_first_inelig_object.last;

11680: hr_utility.set_location('l_comp_obj_tree(l_treeele_num).pgm_id'||l_comp_obj_tree(l_treeele_num).pgm_id,10);
11681: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
11682: ben_determine_eligibility2.g_cache_first_inelig_object
11683: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
11684: ben_determine_eligibility2.g_cache_first_inelig_object.last;
11685: ben_determine_eligibility2.g_cache_first_inelig_object
11686: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
11687: l_comp_obj_tree(l_treeele_num).pgm_id;
11688: end if;

Line 11685: ben_determine_eligibility2.g_cache_first_inelig_object

11681: ben_determine_eligibility2.g_cache_first_inelig_object.extend;
11682: ben_determine_eligibility2.g_cache_first_inelig_object
11683: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
11684: ben_determine_eligibility2.g_cache_first_inelig_object.last;
11685: ben_determine_eligibility2.g_cache_first_inelig_object
11686: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
11687: l_comp_obj_tree(l_treeele_num).pgm_id;
11688: end if;
11689: --Bug 12732878 ud changes end

Line 11686: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=

11682: ben_determine_eligibility2.g_cache_first_inelig_object
11683: (ben_determine_eligibility2.g_cache_first_inelig_object.last).rowno :=
11684: ben_determine_eligibility2.g_cache_first_inelig_object.last;
11685: ben_determine_eligibility2.g_cache_first_inelig_object
11686: (ben_determine_eligibility2.g_cache_first_inelig_object.last).pgm_id :=
11687: l_comp_obj_tree(l_treeele_num).pgm_id;
11688: end if;
11689: --Bug 12732878 ud changes end
11690: --------------------------------------------------------------------------------

Line 12126: --ben_determine_eligibility2.g_cache_first_inelig_object,ben_determine_eligibility2.g_cache_first_elig_object

12122: --
12123: --------------------------------------------------------------------------
12124: --Bug 12732878 ud changes procedure start
12125: --Calling procedure check_for_first_eligible to check whether the comp objects present in the global variables
12126: --ben_determine_eligibility2.g_cache_first_inelig_object,ben_determine_eligibility2.g_cache_first_elig_object
12127: --are having any future records in ben_elig_per_f and ben_elig_opt_f tables.If the future records are present
12128: -- then inserting the future records in to back up table and deleting the future records.
12129:
12130: check_for_first_eligible(p_per_in_ler_id => l_pil_row.per_in_ler_id