[Home] [Help]
310: 17-Mar-03 vsethi 115.96 - Bug 2650247 - populating the value of inelg_rsn_cd
311: in p_comp_obj_tree_row record.
312: 07-Apr-03 mmudigon 115.97 - Bug#2841136-Effective date is passed as
313: least of p_effective_date or lf_evt_ocrd_dt
314: to calls to ben_pep_cache.
315: Corrected typo in determining DT Track mode
316: for updating OIPLIP.
317: 24-Jun-03 hnarayan 115.98 - Bug 3001411 - changed cursor c_ptnl_le to
318: ignore LEs of type SCHEDDU, ABS, COMP and GSP
319: becos the presence of these LE shud not make a
320: person ineligible in case of waiting period setup.
321: 02-Sep-03 rpgupta 115.99 - Bug 3111613 - if cache does'nt return any
322: elig_per_id, raise an error
323: 18-Sep-03 mhoyes 115.100 - Phased in calls to ben_pep_cache1 rather than
324: ben_pep_cache.
325: 19 Sep 03 mhoyes 115.101 - 3150329 - Update eligibility APIs.
326: 26 Sep 03 mhoyes 115.102 - More update eligibility APIs.
327: 21 Jan 04 ikasire 115.103 BUG 3327841 - fixed the wrong assignment of epo
320: person ineligible in case of waiting period setup.
321: 02-Sep-03 rpgupta 115.99 - Bug 3111613 - if cache does'nt return any
322: elig_per_id, raise an error
323: 18-Sep-03 mhoyes 115.100 - Phased in calls to ben_pep_cache1 rather than
324: ben_pep_cache.
325: 19 Sep 03 mhoyes 115.101 - 3150329 - Update eligibility APIs.
326: 26 Sep 03 mhoyes 115.102 - More update eligibility APIs.
327: 21 Jan 04 ikasire 115.103 BUG 3327841 - fixed the wrong assignment of epo
328: data to pep. Also calling clear_down_cache
326: 26 Sep 03 mhoyes 115.102 - More update eligibility APIs.
327: 21 Jan 04 ikasire 115.103 BUG 3327841 - fixed the wrong assignment of epo
328: data to pep. Also calling clear_down_cache
329: to get the right data.
330: 02 Feb 04 ikasire 115.104 BUG 3327841 Using the ben_pep_cache1.get_currplnpep_dets
331: to get the current pep info instread of depending on
332: ben_pep_cache.get_pilepo_dets
333: 30 Mar 04 ikasire 115.105 fonm changes.
334: 15 Apr 04 ikasire 115.106 Bug 3550789 added a new procedure save_to_restore
328: data to pep. Also calling clear_down_cache
329: to get the right data.
330: 02 Feb 04 ikasire 115.104 BUG 3327841 Using the ben_pep_cache1.get_currplnpep_dets
331: to get the current pep info instread of depending on
332: ben_pep_cache.get_pilepo_dets
333: 30 Mar 04 ikasire 115.105 fonm changes.
334: 15 Apr 04 ikasire 115.106 Bug 3550789 added a new procedure save_to_restore
335: to save the PEP EPO data in certain cases when
336: we loose the data and can't restore as part of
360: benutils.formula in procedure get_start_end_dates
361: 24-Jul-06 kmahendr 115.120 Bug#5404392-added ben_newly_ineligible call
362: in the case of first time ineligible.
363: 25-aug-06 ssarkar 115.121 bug# 5478994 - passed ler_id to update_perf_eligible_person
364: 11-Dec-06 rgajula 115.122 Bug 5682845 - passed the l_envplipid to the call to ben_pep_Cache.get_pilepo_dets.
365: 07-Feb-07 kmahendr 115.124 Fidelity Enh to update inelig rows and
366: reversed fix made for 5682845
367: 08-Feb-07 kmahendr 115.125 Reversed the condition to update inelig rows
368: 16-Feb-07 rtagarra 115.126 ICM Changes.
1447: l_oiplip_rec ben_derive_part_and_rate_facts.g_cache_structure;
1448: l_pil_rec ben_per_in_ler%rowtype;
1449: l_prev_eligibility boolean;
1450: --
1451: l_oiplippep_dets ben_pep_cache.g_pep_rec;
1452: l_plnpep_dets ben_pep_cache.g_pep_rec;
1453: --
1454: l_elig_flag varchar2(1);
1455: l_prtn_strt_dt date;
1448: l_pil_rec ben_per_in_ler%rowtype;
1449: l_prev_eligibility boolean;
1450: --
1451: l_oiplippep_dets ben_pep_cache.g_pep_rec;
1452: l_plnpep_dets ben_pep_cache.g_pep_rec;
1453: --
1454: l_elig_flag varchar2(1);
1455: l_prtn_strt_dt date;
1456: l_oiplip_pep_id number;
1728: --with current pep record which fetched the right l_epo_row.prtn_strt_dt
1729: --like it is done in the c_prev_opt_elig_check cursor in the else clause
1730: --below.
1731: --
1732: -- ben_pep_cache.clear_down_cache ;
1733: -- clear_down_cache is not required as we have to use this
1734: -- output for only the previous eligibility. But keep in mind that the cursor
1735: -- c_prev_opt_elig_check return the previous elig_per_opt record with current
1736: -- elig_per record while evaluating the options.
1736: -- elig_per record while evaluating the options.
1737: --
1738: --reversed the fix made for 5682845 - it creates new set of rows
1739:
1740: ben_pep_cache.get_pilepo_dets
1741: (p_person_id => p_person_id
1742: ,p_business_group_id => p_business_group_id
1743: ,p_effective_date => l_effective_dt
1744: ,p_pgm_id => l_envpgm_id
2236: -- would not have brought back a record.
2237: --
2238: /* Bug 3327841 This info needs to be derived for the elig_per_opt
2239: records even in the subsequent life event also as the value
2240: we are getting from the ben_pep_cache is for the previous
2241: life event.
2242: */
2243: if l_first_elig or l_oipl_rec.opt_id is not null then
2244: --
2247: if g_debug then
2248: hr_utility.set_location('open c_get_elig_id ben_determine_eligibility2.check_prev_elig', 10);
2249: end if;
2250: --
2251: ben_pep_cache1.get_currplnpep_dets
2252: (p_comp_obj_tree_row => p_comp_obj_tree_row
2253: ,p_person_id => p_person_id
2254: ,p_effective_date => l_effective_dt
2255: --
3550: --
3551: hr_utility.set_location ('first inelig',121);
3552: -- Get elig id from ben_elig_per_f for the plan
3553: --
3554: ben_pep_cache1.get_currplnpep_dets
3555: (p_comp_obj_tree_row => p_comp_obj_tree_row
3556: ,p_person_id => p_person_id
3557: ,p_effective_date => l_effective_dt
3558: --
3784: end if;
3785: --
3786: -- Check for previous OIPLIP
3787: --
3788: ben_pep_cache.get_pilepo_dets
3789: (p_person_id => p_person_id
3790: ,p_business_group_id => p_business_group_id
3791: ,p_effective_date => l_effective_dt
3792: ,p_pgm_id => l_envpgm_id
3801: if g_debug then
3802: hr_utility.set_location('Record not found',10);
3803: end if;
3804: --
3805: ben_pep_cache1.get_curroiplippep_dets
3806: (p_comp_obj_tree_row => p_comp_obj_tree_row
3807: ,p_person_id => p_person_id
3808: ,p_effective_date => l_effective_dt
3809: --
4228: --
4229: if g_debug then
4230: hr_utility.set_location(' before pilpep ',111);
4231: end if;
4232: ben_pep_cache.get_pilpep_dets
4233: (p_person_id => p_person_id
4234: ,p_business_group_id => p_business_group_id
4235: ,p_effective_date => l_effective_dt
4236: ,p_pgm_id => l_envpgm_id