179: END IF;
180: --
181: IF l_pgmrule_pass THEN
182: --
183: ben_manage_life_events.g_cache_proc_object(l_ele_num).pl_id :=
184: l_pl_id_va(elenum);
185: ben_manage_life_events.g_cache_proc_object(l_ele_num).pgm_id :=
186: l_pgm_id_va(elenum);
187: ben_manage_life_events.g_cache_proc_object(l_ele_num).oipl_id :=
181: IF l_pgmrule_pass THEN
182: --
183: ben_manage_life_events.g_cache_proc_object(l_ele_num).pl_id :=
184: l_pl_id_va(elenum);
185: ben_manage_life_events.g_cache_proc_object(l_ele_num).pgm_id :=
186: l_pgm_id_va(elenum);
187: ben_manage_life_events.g_cache_proc_object(l_ele_num).oipl_id :=
188: l_oipl_id_va(elenum);
189: ben_manage_life_events.g_cache_proc_object(l_ele_num).plip_id :=
183: ben_manage_life_events.g_cache_proc_object(l_ele_num).pl_id :=
184: l_pl_id_va(elenum);
185: ben_manage_life_events.g_cache_proc_object(l_ele_num).pgm_id :=
186: l_pgm_id_va(elenum);
187: ben_manage_life_events.g_cache_proc_object(l_ele_num).oipl_id :=
188: l_oipl_id_va(elenum);
189: ben_manage_life_events.g_cache_proc_object(l_ele_num).plip_id :=
190: l_plip_id_va(elenum);
191: ben_manage_life_events.g_cache_proc_object(l_ele_num).ptip_id :=
185: ben_manage_life_events.g_cache_proc_object(l_ele_num).pgm_id :=
186: l_pgm_id_va(elenum);
187: ben_manage_life_events.g_cache_proc_object(l_ele_num).oipl_id :=
188: l_oipl_id_va(elenum);
189: ben_manage_life_events.g_cache_proc_object(l_ele_num).plip_id :=
190: l_plip_id_va(elenum);
191: ben_manage_life_events.g_cache_proc_object(l_ele_num).ptip_id :=
192: l_ptip_id_va(elenum);
193: ben_manage_life_events.g_cache_proc_object(l_ele_num).oiplip_id :=
187: ben_manage_life_events.g_cache_proc_object(l_ele_num).oipl_id :=
188: l_oipl_id_va(elenum);
189: ben_manage_life_events.g_cache_proc_object(l_ele_num).plip_id :=
190: l_plip_id_va(elenum);
191: ben_manage_life_events.g_cache_proc_object(l_ele_num).ptip_id :=
192: l_ptip_id_va(elenum);
193: ben_manage_life_events.g_cache_proc_object(l_ele_num).oiplip_id :=
194: l_oiplip_id_va(elenum);
195: ben_manage_life_events.g_cache_proc_object(l_ele_num).pl_nip :=
189: ben_manage_life_events.g_cache_proc_object(l_ele_num).plip_id :=
190: l_plip_id_va(elenum);
191: ben_manage_life_events.g_cache_proc_object(l_ele_num).ptip_id :=
192: l_ptip_id_va(elenum);
193: ben_manage_life_events.g_cache_proc_object(l_ele_num).oiplip_id :=
194: l_oiplip_id_va(elenum);
195: ben_manage_life_events.g_cache_proc_object(l_ele_num).pl_nip :=
196: l_pl_nip_va(elenum);
197: ben_manage_life_events.g_cache_proc_object(l_ele_num).trk_inelig_per_flag :=
191: ben_manage_life_events.g_cache_proc_object(l_ele_num).ptip_id :=
192: l_ptip_id_va(elenum);
193: ben_manage_life_events.g_cache_proc_object(l_ele_num).oiplip_id :=
194: l_oiplip_id_va(elenum);
195: ben_manage_life_events.g_cache_proc_object(l_ele_num).pl_nip :=
196: l_pl_nip_va(elenum);
197: ben_manage_life_events.g_cache_proc_object(l_ele_num).trk_inelig_per_flag :=
198: l_trk_inelig_per_flag_va(elenum);
199: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_pgm_id :=
193: ben_manage_life_events.g_cache_proc_object(l_ele_num).oiplip_id :=
194: l_oiplip_id_va(elenum);
195: ben_manage_life_events.g_cache_proc_object(l_ele_num).pl_nip :=
196: l_pl_nip_va(elenum);
197: ben_manage_life_events.g_cache_proc_object(l_ele_num).trk_inelig_per_flag :=
198: l_trk_inelig_per_flag_va(elenum);
199: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_pgm_id :=
200: l_par_pgm_id_va(elenum);
201: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_ptip_id :=
195: ben_manage_life_events.g_cache_proc_object(l_ele_num).pl_nip :=
196: l_pl_nip_va(elenum);
197: ben_manage_life_events.g_cache_proc_object(l_ele_num).trk_inelig_per_flag :=
198: l_trk_inelig_per_flag_va(elenum);
199: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_pgm_id :=
200: l_par_pgm_id_va(elenum);
201: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_ptip_id :=
202: l_par_ptip_id_va(elenum);
203: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_plip_id :=
197: ben_manage_life_events.g_cache_proc_object(l_ele_num).trk_inelig_per_flag :=
198: l_trk_inelig_per_flag_va(elenum);
199: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_pgm_id :=
200: l_par_pgm_id_va(elenum);
201: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_ptip_id :=
202: l_par_ptip_id_va(elenum);
203: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_plip_id :=
204: l_par_plip_id_va(elenum);
205: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_pl_id :=
199: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_pgm_id :=
200: l_par_pgm_id_va(elenum);
201: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_ptip_id :=
202: l_par_ptip_id_va(elenum);
203: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_plip_id :=
204: l_par_plip_id_va(elenum);
205: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_pl_id :=
206: l_par_pl_id_va(elenum);
207: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_opt_id :=
201: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_ptip_id :=
202: l_par_ptip_id_va(elenum);
203: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_plip_id :=
204: l_par_plip_id_va(elenum);
205: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_pl_id :=
206: l_par_pl_id_va(elenum);
207: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_opt_id :=
208: l_par_opt_id_va(elenum);
209: ben_manage_life_events.g_cache_proc_object(l_ele_num).flag_bit_val :=
203: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_plip_id :=
204: l_par_plip_id_va(elenum);
205: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_pl_id :=
206: l_par_pl_id_va(elenum);
207: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_opt_id :=
208: l_par_opt_id_va(elenum);
209: ben_manage_life_events.g_cache_proc_object(l_ele_num).flag_bit_val :=
210: l_flag_bit_val_va(elenum);
211: ben_manage_life_events.g_cache_proc_object(l_ele_num).oiplip_flag_bit_val :=
205: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_pl_id :=
206: l_par_pl_id_va(elenum);
207: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_opt_id :=
208: l_par_opt_id_va(elenum);
209: ben_manage_life_events.g_cache_proc_object(l_ele_num).flag_bit_val :=
210: l_flag_bit_val_va(elenum);
211: ben_manage_life_events.g_cache_proc_object(l_ele_num).oiplip_flag_bit_val :=
212: l_oiplip_flag_bit_val_va(elenum);
213: --
207: ben_manage_life_events.g_cache_proc_object(l_ele_num).par_opt_id :=
208: l_par_opt_id_va(elenum);
209: ben_manage_life_events.g_cache_proc_object(l_ele_num).flag_bit_val :=
210: l_flag_bit_val_va(elenum);
211: ben_manage_life_events.g_cache_proc_object(l_ele_num).oiplip_flag_bit_val :=
212: l_oiplip_flag_bit_val_va(elenum);
213: --
214: l_ele_num := l_ele_num + 1;
215: --
216: -- 5515506: If derived factors exists and the g_derivable_factors is 'NONE',
217: -- reset the derivable_factors parameter to 'ASC'
218: --
219: if ( (l_flag_bit_val_va(elenum) <> 0 OR l_oiplip_flag_bit_val_va(elenum) <> 0)
220: AND (ben_manage_life_events.g_derivable_factors = 'NONE') ) then
221: --
222: hr_utility.set_location('SET ben_manage_life_events.g_derivable_factors from NONE to ASC', 10);
223:
224: ben_manage_life_events.g_derivable_factors := 'ASC';
218: --
219: if ( (l_flag_bit_val_va(elenum) <> 0 OR l_oiplip_flag_bit_val_va(elenum) <> 0)
220: AND (ben_manage_life_events.g_derivable_factors = 'NONE') ) then
221: --
222: hr_utility.set_location('SET ben_manage_life_events.g_derivable_factors from NONE to ASC', 10);
223:
224: ben_manage_life_events.g_derivable_factors := 'ASC';
225: fnd_message.set_name('BEN','BEN_93605_RESET_DRVD_FCTR_PARM');
226: benutils.write(p_text => fnd_message.get);
220: AND (ben_manage_life_events.g_derivable_factors = 'NONE') ) then
221: --
222: hr_utility.set_location('SET ben_manage_life_events.g_derivable_factors from NONE to ASC', 10);
223:
224: ben_manage_life_events.g_derivable_factors := 'ASC';
225: fnd_message.set_name('BEN','BEN_93605_RESET_DRVD_FCTR_PARM');
226: benutils.write(p_text => fnd_message.get);
227: --
228: end if;
247: ben_cobj_cache.clear_down_cache;
248: ben_comp_object.clear_down_cache;
249: ben_elig_object.clear_down_cache;
250: ben_seeddata_object.clear_down_cache;
251: ben_manage_life_events.g_cache_person_prtn.delete;
252: ben_derive_part_and_rate_cache.clear_down_cache;
253: ben_derive_part_and_rate_facts.clear_down_cache;
254: ben_derive_part_and_rate_cvg.clear_down_cache;
255: ben_derive_part_and_rate_prem.clear_down_cache;