DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ELIGIBILITY2 dependencies on BEN_PEP_CACHE

Line 314: to calls to ben_pep_cache.

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

Line 323: 18-Sep-03 mhoyes 115.100 - Phased in calls to ben_pep_cache1 rather than

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

Line 324: ben_pep_cache.

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

Line 330: 02 Feb 04 ikasire 115.104 BUG 3327841 Using the ben_pep_cache1.get_currplnpep_dets

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

Line 332: ben_pep_cache.get_pilepo_dets

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

Line 364: 11-Dec-06 rgajula 115.122 Bug 5682845 - passed the l_envplipid to the call to ben_pep_Cache.get_pilepo_dets.

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.

Line 1438: l_oiplippep_dets ben_pep_cache.g_pep_rec;

1434: l_oiplip_rec ben_derive_part_and_rate_facts.g_cache_structure;
1435: l_pil_rec ben_per_in_ler%rowtype;
1436: l_prev_eligibility boolean;
1437: --
1438: l_oiplippep_dets ben_pep_cache.g_pep_rec;
1439: l_plnpep_dets ben_pep_cache.g_pep_rec;
1440: --
1441: l_elig_flag varchar2(1);
1442: l_prtn_strt_dt date;

Line 1439: l_plnpep_dets ben_pep_cache.g_pep_rec;

1435: l_pil_rec ben_per_in_ler%rowtype;
1436: l_prev_eligibility boolean;
1437: --
1438: l_oiplippep_dets ben_pep_cache.g_pep_rec;
1439: l_plnpep_dets ben_pep_cache.g_pep_rec;
1440: --
1441: l_elig_flag varchar2(1);
1442: l_prtn_strt_dt date;
1443: l_oiplip_pep_id number;

Line 1638: -- ben_pep_cache.clear_down_cache ;

1634: --with current pep record which fetched the right l_epo_row.prtn_strt_dt
1635: --like it is done in the c_prev_opt_elig_check cursor in the else clause
1636: --below.
1637: --
1638: -- ben_pep_cache.clear_down_cache ;
1639: -- clear_down_cache is not required as we have to use this
1640: -- output for only the previous eligibility. But keep in mind that the cursor
1641: -- c_prev_opt_elig_check return the previous elig_per_opt record with current
1642: -- elig_per record while evaluating the options.

Line 1646: ben_pep_cache.get_pilepo_dets

1642: -- elig_per record while evaluating the options.
1643: --
1644: --reversed the fix made for 5682845 - it creates new set of rows
1645:
1646: ben_pep_cache.get_pilepo_dets
1647: (p_person_id => p_person_id
1648: ,p_business_group_id => p_business_group_id
1649: ,p_effective_date => l_effective_dt
1650: ,p_pgm_id => l_envpgm_id

Line 2146: we are getting from the ben_pep_cache is for the previous

2142: -- would not have brought back a record.
2143: --
2144: /* Bug 3327841 This info needs to be derived for the elig_per_opt
2145: records even in the subsequent life event also as the value
2146: we are getting from the ben_pep_cache is for the previous
2147: life event.
2148: */
2149: if l_first_elig or l_oipl_rec.opt_id is not null then
2150: --

Line 2157: ben_pep_cache1.get_currplnpep_dets

2153: if g_debug then
2154: hr_utility.set_location('open c_get_elig_id ben_determine_eligibility2.check_prev_elig', 10);
2155: end if;
2156: --
2157: ben_pep_cache1.get_currplnpep_dets
2158: (p_comp_obj_tree_row => p_comp_obj_tree_row
2159: ,p_person_id => p_person_id
2160: ,p_effective_date => l_effective_dt
2161: --

Line 3278: ben_pep_cache1.get_currplnpep_dets

3274: --
3275: hr_utility.set_location ('first inelig',121);
3276: -- Get elig id from ben_elig_per_f for the plan
3277: --
3278: ben_pep_cache1.get_currplnpep_dets
3279: (p_comp_obj_tree_row => p_comp_obj_tree_row
3280: ,p_person_id => p_person_id
3281: ,p_effective_date => l_effective_dt
3282: --

Line 3512: ben_pep_cache.get_pilepo_dets

3508: end if;
3509: --
3510: -- Check for previous OIPLIP
3511: --
3512: ben_pep_cache.get_pilepo_dets
3513: (p_person_id => p_person_id
3514: ,p_business_group_id => p_business_group_id
3515: ,p_effective_date => l_effective_dt
3516: ,p_pgm_id => l_envpgm_id

Line 3529: ben_pep_cache1.get_curroiplippep_dets

3525: if g_debug then
3526: hr_utility.set_location('Record not found',10);
3527: end if;
3528: --
3529: ben_pep_cache1.get_curroiplippep_dets
3530: (p_comp_obj_tree_row => p_comp_obj_tree_row
3531: ,p_person_id => p_person_id
3532: ,p_effective_date => l_effective_dt
3533: --

Line 3900: ben_pep_cache.get_pilpep_dets

3896: --
3897: if g_debug then
3898: hr_utility.set_location(' before pilpep ',111);
3899: end if;
3900: ben_pep_cache.get_pilpep_dets
3901: (p_person_id => p_person_id
3902: ,p_business_group_id => p_business_group_id
3903: ,p_effective_date => l_effective_dt
3904: ,p_pgm_id => l_envpgm_id