[Home] [Help]
976: mn_elcn_val are passed to cloned rows.
977: 22-Dec-03 Indrasen 115.333 CWBGLOBAL New Procedure
978: 10-Jan-04 tjesumic 115.334 new cursor c9 added in check_business_rule to validate
979: the cwb task for the budget flag
980: 20-Jan-04 ikasire 115.335/338 ben_pep_cache.clear_down_cache called after call to
981: ben_enrolment_requirements.update_defaults as it uses
982: a different effective date
983: 21-Jan-04 ikasire 115.339 Added p_trace_plans_flag to CWBGLOBAL procedure
984:
2580: and pep.per_in_ler_id is null
2581: and pep.pgm_id = l_envpgm_id
2582: and p_effective_date between pep.effective_start_date
2583: and pep.effective_end_date;
2584: ben_pep_cache.clear_down_pepcache;
2585: end if;
2586: close c_epe;
2587: --
2588: if l_oipl_id is not null then
2603: and pep.effective_end_date)
2604: and p_effective_date between epo.effective_start_date and
2605: epo.effective_end_date
2606: and epo.opt_id = l_oipl_rec.opt_id;
2607: ben_pep_cache.clear_down_epocache;
2608: end if;
2609: close c_epo;
2610: end if;
2611: --
2621: and pep.pgm_id is null
2622: and pep.pl_id = l_envpl_id
2623: and p_effective_date between pep.effective_start_date
2624: and pep.effective_end_date;
2625: ben_pep_cache.clear_down_pepcache;
2626: end if;
2627: close c_epe2;
2628: --
2629: if l_oipl_id is not null then
2646: and pep.effective_end_date)
2647: and p_effective_date between epo.effective_start_date and
2648: epo.effective_end_date
2649: and epo.opt_id = l_oipl_rec.opt_id;
2650: ben_pep_cache.clear_down_epocache;
2651: end if;
2652: close c_epo2;
2653: --
2654: end if;
2660: hr_utility.set_location('OIPL ID-update'||l_oipl_id,111);
2661: l_oipl_rec := ben_cobj_cache.g_oipl_currow;
2662: if l_envpgm_id is not null then
2663: --
2664: ben_pep_cache.get_pilepo_dets
2665: (p_person_id => p_person_id
2666: ,p_business_group_id => p_business_group_id
2667: ,p_effective_date => p_effective_date
2668: ,p_pgm_id => l_envpgm_id
2722: --
2723: if g_debug then
2724: hr_utility.set_location(' before pilpep ',111);
2725: end if;
2726: ben_pep_cache.get_pilpep_dets
2727: (p_person_id => p_person_id
2728: ,p_business_group_id => p_business_group_id
2729: ,p_effective_date => p_effective_date
2730: ,p_pgm_id => l_envpgm_id
10749: ben_env_object.setenv(p_lf_evt_ocrd_dt => l_rec.lf_evt_ocrd_dt);
10750: --
10751: -- Clear eligibility caches
10752: --
10753: ben_pep_cache.clear_down_cache;
10754: ben_epe_cache.clear_down_cache;
10755: --
10756: dt_fndate.change_ses_date
10757: (p_ses_date => nvl(l_rec.lf_evt_ocrd_dt,p_effective_date)
12241: if l_mode <> 'T' then
12242: --
12243: -- Clear eligibility caches
12244: --
12245: ben_pep_cache.clear_down_cache;
12246: ben_epe_cache.clear_down_cache;
12247: --
12248: -- PB : 5422 :
12249: -- l_strt_dt is not being used by the process to which it is passed.
12347: -- Clear Elig per Cache as ben_enrolment_requirements.update_defaults
12348: -- build the cache for previous eligibility.
12349: -- And in the benrates we need the current elig records.
12350: --
12351: ben_pep_cache.clear_down_cache;
12352: --
12353: -- Clear distribute rates function caches
12354: --
12355: ben_distribute_rates.clear_down_cache;