81: l_imp_elig_per_elctbl_chc_id number ;
82: l_imp_ptip_id number;
83: l_imp_plip_id number;
84: l_imp_electable_flag varchar2(30);
85: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
86: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
87: l_plip_rec ben_cobj_cache.g_plip_inst_row;
88: l_pl_rec ben_cobj_cache.g_pl_inst_row;
89: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
82: l_imp_ptip_id number;
83: l_imp_plip_id number;
84: l_imp_electable_flag varchar2(30);
85: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
86: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
87: l_plip_rec ben_cobj_cache.g_plip_inst_row;
88: l_pl_rec ben_cobj_cache.g_pl_inst_row;
89: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
90: --
83: l_imp_plip_id number;
84: l_imp_electable_flag varchar2(30);
85: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
86: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
87: l_plip_rec ben_cobj_cache.g_plip_inst_row;
88: l_pl_rec ben_cobj_cache.g_pl_inst_row;
89: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
90: --
91: cursor c_epe(p_epe_id number) is
84: l_imp_electable_flag varchar2(30);
85: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
86: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
87: l_plip_rec ben_cobj_cache.g_plip_inst_row;
88: l_pl_rec ben_cobj_cache.g_pl_inst_row;
89: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
90: --
91: cursor c_epe(p_epe_id number) is
92: select enrt_cvg_strt_dt,pl_typ_id
85: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
86: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
87: l_plip_rec ben_cobj_cache.g_plip_inst_row;
88: l_pl_rec ben_cobj_cache.g_pl_inst_row;
89: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
90: --
91: cursor c_epe(p_epe_id number) is
92: select enrt_cvg_strt_dt,pl_typ_id
93: from ben_elig_per_elctbl_chc epe
233: l_comp_obj_tree_row.par_plip_id := p_plip_id;
234: --
235: if p_oipl_id is not null then
236: --
237: ben_cobj_cache.get_oipl_dets (
238: p_business_group_id => p_business_group_id
239: ,p_effective_date => p_effective_date
240: ,p_oipl_id => p_oipl_id
241: ,p_inst_row => l_oipl_rec
239: ,p_effective_date => p_effective_date
240: ,p_oipl_id => p_oipl_id
241: ,p_inst_row => l_oipl_rec
242: ) ;
243: ben_cobj_cache.g_oipl_currow := l_oipl_rec ;
244: --
245: end if ;
246: --
247: if p_pl_id is not null then
245: end if ;
246: --
247: if p_pl_id is not null then
248: --
249: ben_cobj_cache.get_pl_dets (
250: p_business_group_id => p_business_group_id
251: ,p_effective_date => p_effective_date
252: ,p_pl_id => p_pl_id
253: ,p_inst_row => l_pl_rec
251: ,p_effective_date => p_effective_date
252: ,p_pl_id => p_pl_id
253: ,p_inst_row => l_pl_rec
254: ) ;
255: ben_cobj_cache.g_pl_currow := l_pl_rec ;
256: --
257: end if ;
258: --
259: if p_plip_id is not null then
257: end if ;
258: --
259: if p_plip_id is not null then
260: --
261: ben_cobj_cache.get_plip_dets (
262: p_business_group_id => p_business_group_id
263: ,p_effective_date => p_effective_date
264: ,p_plip_id => p_plip_id
265: ,p_inst_row => l_plip_rec
263: ,p_effective_date => p_effective_date
264: ,p_plip_id => p_plip_id
265: ,p_inst_row => l_plip_rec
266: ) ;
267: ben_cobj_cache.g_plip_currow := l_plip_rec ;
268: --
269: end if ;
270: --
271: --
270: --
271: --
272: if p_ptip_id is not null then
273: --
274: ben_cobj_cache.get_ptip_dets (
275: p_business_group_id => p_business_group_id
276: ,p_effective_date => p_effective_date
277: ,p_ptip_id => p_ptip_id
278: ,p_inst_row => l_ptip_rec
276: ,p_effective_date => p_effective_date
277: ,p_ptip_id => p_ptip_id
278: ,p_inst_row => l_ptip_rec
279: ) ;
280: ben_cobj_cache.g_ptip_currow := l_ptip_rec ;
281: --
282: end if ;
283: --
284: if p_pgm_id is not null then
282: end if ;
283: --
284: if p_pgm_id is not null then
285: --
286: ben_cobj_cache.get_pgm_dets (
287: p_business_group_id => p_business_group_id
288: ,p_effective_date => p_effective_date
289: ,p_pgm_id => p_pgm_id
290: ,p_inst_row => l_pgm_rec
288: ,p_effective_date => p_effective_date
289: ,p_pgm_id => p_pgm_id
290: ,p_inst_row => l_pgm_rec
291: ) ;
292: ben_cobj_cache.g_pgm_currow := l_pgm_rec ;
293: --
294: end if ;
295: --
296: hr_utility.set_location('Calling ben_enrolment_requirements_ik.enrolment_requirements',30);