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_ELIGIBILITY2

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