eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_COBJ_CACHE

Line 313: cached records. Also removed the calls to ben_cobj_cache

309: 26-jul-01 ikasire 115.143 bug1895874 added new nip_dflt_flag to ben_pl_f table.
310: In the internal procedure determine_dflt_enrt_cd
311: added to parameters p_pgm_rec,p_ptip_rec,p_plip_rec,
312: p_oipl_rec,p_pl_rec to get the data from the already
313: cached records. Also removed the calls to ben_cobj_cache
314: from internal determine_dflt_enrt_cd procedure as this
315: can not be used here.
316: 27-aug-01 tilak 115.144 bug:1949361 jurisdiction code is
317: derived inside benutils.formula.

Line 659: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

655: --
656: l_dflt_enrt_cd VARCHAR2(30);
657: l_dflt_enrt_rl NUMBER;
658: l_plan_rec ben_pl_f%ROWTYPE;
659: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
660: l_ler_dflt_flag varchar2(30); -- 3510229
661: BEGIN
662: --
663: g_debug := hr_utility.debug_enabled;

Line 709: --l_dflt_enrt_cd := ben_cobj_cache.g_oipl_currow.dflt_enrt_cd;

705: if g_debug then
706: hr_utility.set_location('In the case 2 ' , 100);
707: end if;
708: --
709: --l_dflt_enrt_cd := ben_cobj_cache.g_oipl_currow.dflt_enrt_cd;
710: --l_dflt_enrt_rl := ben_cobj_cache.g_oipl_currow.dflt_enrt_det_rl;
711: --
712: l_dflt_enrt_cd := p_oipl_rec.dflt_enrt_cd ;
713: l_dflt_enrt_rl := p_oipl_rec.dflt_enrt_det_rl ;

Line 710: --l_dflt_enrt_rl := ben_cobj_cache.g_oipl_currow.dflt_enrt_det_rl;

706: hr_utility.set_location('In the case 2 ' , 100);
707: end if;
708: --
709: --l_dflt_enrt_cd := ben_cobj_cache.g_oipl_currow.dflt_enrt_cd;
710: --l_dflt_enrt_rl := ben_cobj_cache.g_oipl_currow.dflt_enrt_det_rl;
711: --
712: l_dflt_enrt_cd := p_oipl_rec.dflt_enrt_cd ;
713: l_dflt_enrt_rl := p_oipl_rec.dflt_enrt_det_rl ;
714:

Line 856: --l_dflt_enrt_cd := ben_cobj_cache.g_oipl_currow.dflt_enrt_cd;

852: -- 6
853: --
854: hr_utility.set_location('In the case 2 ' , 100);
855: --
856: --l_dflt_enrt_cd := ben_cobj_cache.g_oipl_currow.dflt_enrt_cd;
857: --l_dflt_enrt_rl := ben_cobj_cache.g_oipl_currow.dflt_enrt_det_rl;
858: --
859: l_dflt_enrt_cd := p_oipl_rec.dflt_enrt_cd ;
860: l_dflt_enrt_rl := p_oipl_rec.dflt_enrt_det_rl ;

Line 857: --l_dflt_enrt_rl := ben_cobj_cache.g_oipl_currow.dflt_enrt_det_rl;

853: --
854: hr_utility.set_location('In the case 2 ' , 100);
855: --
856: --l_dflt_enrt_cd := ben_cobj_cache.g_oipl_currow.dflt_enrt_cd;
857: --l_dflt_enrt_rl := ben_cobj_cache.g_oipl_currow.dflt_enrt_det_rl;
858: --
859: l_dflt_enrt_cd := p_oipl_rec.dflt_enrt_cd ;
860: l_dflt_enrt_rl := p_oipl_rec.dflt_enrt_det_rl ;
861:

Line 882: -- l_dflt_enrt_cd := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_cd;

878: --
879: -- 7
880: --
881: -- Bug 1895874
882: -- l_dflt_enrt_cd := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_cd;
883: -- l_dflt_enrt_rl := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_det_rl;
884: --
885: if g_debug then
886: hr_utility.set_location(' p_pl_rec.pl_id '||p_oipl_rec.oipl_id ,110);

Line 883: -- l_dflt_enrt_rl := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_det_rl;

879: -- 7
880: --
881: -- Bug 1895874
882: -- l_dflt_enrt_cd := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_cd;
883: -- l_dflt_enrt_rl := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_det_rl;
884: --
885: if g_debug then
886: hr_utility.set_location(' p_pl_rec.pl_id '||p_oipl_rec.oipl_id ,110);
887: hr_utility.set_location(' p_pl_rec.nip_dflt_enrt_cd '||p_pl_rec.nip_dflt_enrt_cd ,110);

Line 2686: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

2682: l_enrd_ordr_num NUMBER;
2683: l_level VARCHAR2(30);
2684: l_plan_rec ben_pl_f%ROWTYPE;
2685: l_pgm_rec ben_pgm_f%ROWTYPE;
2686: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
2687: l_pen_rec ben_prtt_enrt_rslt_f%ROWTYPE;
2688: l_pl_typ_esd DATE;
2689: l_pl_typ_eed DATE;
2690: l_ler_esd DATE;

Line 3660: -- ben_cobj_cache.get_oipl_dets (

3656: -- Bug 2200139 For Override call the cache routine else call the benmnglecache
3657: -- this is not required as the data is fetched on the benovrrd.pkb
3658: --IF p_run_mode = 'V' THEN
3659: -- --
3660: -- ben_cobj_cache.get_oipl_dets (
3661: -- p_business_group_id => p_business_group_id
3662: -- ,p_effective_date => p_effective_date
3663: -- ,p_oipl_id => p_oipl_id
3664: -- ,p_inst_row => l_oipl_rec

Line 3669: l_oipl_rec := ben_cobj_cache.g_oipl_currow;

3665: -- ) ;
3666: -- --
3667: --ELSE
3668: --
3669: l_oipl_rec := ben_cobj_cache.g_oipl_currow;
3670: l_oipl_name := ben_cobj_cache.g_opt_currow.name;
3671: --
3672: --END IF;
3673: --

Line 3670: l_oipl_name := ben_cobj_cache.g_opt_currow.name;

3666: -- --
3667: --ELSE
3668: --
3669: l_oipl_rec := ben_cobj_cache.g_oipl_currow;
3670: l_oipl_name := ben_cobj_cache.g_opt_currow.name;
3671: --
3672: --END IF;
3673: --
3674: l_pl_id := l_oipl_rec.pl_id;

Line 3683: -- l_oipl_name := ben_cobj_cache.g_opt_currow.name;

3679: l_oipl_auto_enrt_flag := l_oipl_rec.auto_enrt_flag;
3680: l_oipl_auto_enrt_mthd_rl := l_oipl_rec.auto_enrt_mthd_rl;
3681: l_oipl_trk_inelig_per_flag := l_oipl_rec.trk_inelig_per_flag;
3682: --
3683: -- l_oipl_name := ben_cobj_cache.g_opt_currow.name;
3684: if g_debug then
3685: hr_utility.set_location('DONE OIPL NN: ' || l_proc, 10);
3686: end if;
3687: --

Line 4744: IF ben_cobj_cache.g_plip_currow.plip_id = l_plip_id

4740: IF c_ler_bnft_rstrn%NOTFOUND THEN
4741: --
4742: CLOSE c_ler_bnft_rstrn;
4743: -- Romoved the commented code
4744: IF ben_cobj_cache.g_plip_currow.plip_id = l_plip_id
4745: AND ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd = 'OPT'
4746: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_plip_currow.effective_start_date
4747: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_plip_currow.effective_end_date
4748: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id

Line 4745: AND ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd = 'OPT'

4741: --
4742: CLOSE c_ler_bnft_rstrn;
4743: -- Romoved the commented code
4744: IF ben_cobj_cache.g_plip_currow.plip_id = l_plip_id
4745: AND ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd = 'OPT'
4746: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_plip_currow.effective_start_date
4747: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_plip_currow.effective_end_date
4748: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4749: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_plip_currow.pl_id

Line 4746: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_plip_currow.effective_start_date

4742: CLOSE c_ler_bnft_rstrn;
4743: -- Romoved the commented code
4744: IF ben_cobj_cache.g_plip_currow.plip_id = l_plip_id
4745: AND ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd = 'OPT'
4746: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_plip_currow.effective_start_date
4747: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_plip_currow.effective_end_date
4748: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4749: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_plip_currow.pl_id
4750: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date

Line 4747: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_plip_currow.effective_end_date

4743: -- Romoved the commented code
4744: IF ben_cobj_cache.g_plip_currow.plip_id = l_plip_id
4745: AND ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd = 'OPT'
4746: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_plip_currow.effective_start_date
4747: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_plip_currow.effective_end_date
4748: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4749: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_plip_currow.pl_id
4750: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4751: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN

Line 4748: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id

4744: IF ben_cobj_cache.g_plip_currow.plip_id = l_plip_id
4745: AND ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd = 'OPT'
4746: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_plip_currow.effective_start_date
4747: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_plip_currow.effective_end_date
4748: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4749: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_plip_currow.pl_id
4750: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4751: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4752: --

Line 4749: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_plip_currow.pl_id

4745: AND ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd = 'OPT'
4746: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_plip_currow.effective_start_date
4747: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_plip_currow.effective_end_date
4748: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4749: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_plip_currow.pl_id
4750: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4751: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4752: --
4753: l_tmp_level := 2;

Line 4750: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date

4746: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_plip_currow.effective_start_date
4747: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_plip_currow.effective_end_date
4748: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4749: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_plip_currow.pl_id
4750: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4751: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4752: --
4753: l_tmp_level := 2;
4754: l_restriction_pgm_id := ben_cobj_cache.g_plip_currow.pgm_id;

Line 4751: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN

4747: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_plip_currow.effective_end_date
4748: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4749: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_plip_currow.pl_id
4750: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4751: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4752: --
4753: l_tmp_level := 2;
4754: l_restriction_pgm_id := ben_cobj_cache.g_plip_currow.pgm_id;
4755: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;

Line 4754: l_restriction_pgm_id := ben_cobj_cache.g_plip_currow.pgm_id;

4750: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4751: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4752: --
4753: l_tmp_level := 2;
4754: l_restriction_pgm_id := ben_cobj_cache.g_plip_currow.pgm_id;
4755: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4756: l_boo_rstrctn_cd :=
4757: ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd;
4758: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_plip_currow.cvg_incr_r_decr_only_cd;

Line 4755: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;

4751: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4752: --
4753: l_tmp_level := 2;
4754: l_restriction_pgm_id := ben_cobj_cache.g_plip_currow.pgm_id;
4755: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4756: l_boo_rstrctn_cd :=
4757: ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd;
4758: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_plip_currow.cvg_incr_r_decr_only_cd;
4759: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_num;

Line 4757: ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd;

4753: l_tmp_level := 2;
4754: l_restriction_pgm_id := ben_cobj_cache.g_plip_currow.pgm_id;
4755: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4756: l_boo_rstrctn_cd :=
4757: ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd;
4758: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_plip_currow.cvg_incr_r_decr_only_cd;
4759: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_num;
4760: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_wcf_num;
4761: --

Line 4758: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_plip_currow.cvg_incr_r_decr_only_cd;

4754: l_restriction_pgm_id := ben_cobj_cache.g_plip_currow.pgm_id;
4755: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4756: l_boo_rstrctn_cd :=
4757: ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd;
4758: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_plip_currow.cvg_incr_r_decr_only_cd;
4759: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_num;
4760: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_wcf_num;
4761: --
4762: ELSIF ben_cobj_cache.g_pl_currow.pl_id = l_pl_id

Line 4759: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_num;

4755: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4756: l_boo_rstrctn_cd :=
4757: ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd;
4758: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_plip_currow.cvg_incr_r_decr_only_cd;
4759: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_num;
4760: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_wcf_num;
4761: --
4762: ELSIF ben_cobj_cache.g_pl_currow.pl_id = l_pl_id
4763: AND ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd = 'OPT'

Line 4760: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_wcf_num;

4756: l_boo_rstrctn_cd :=
4757: ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd;
4758: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_plip_currow.cvg_incr_r_decr_only_cd;
4759: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_num;
4760: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_wcf_num;
4761: --
4762: ELSIF ben_cobj_cache.g_pl_currow.pl_id = l_pl_id
4763: AND ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd = 'OPT'
4764: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_pl_currow.effective_start_date

Line 4762: ELSIF ben_cobj_cache.g_pl_currow.pl_id = l_pl_id

4758: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_plip_currow.cvg_incr_r_decr_only_cd;
4759: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_num;
4760: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_wcf_num;
4761: --
4762: ELSIF ben_cobj_cache.g_pl_currow.pl_id = l_pl_id
4763: AND ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd = 'OPT'
4764: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_pl_currow.effective_start_date
4765: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_pl_currow.effective_end_date
4766: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id

Line 4763: AND ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd = 'OPT'

4759: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_num;
4760: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_wcf_num;
4761: --
4762: ELSIF ben_cobj_cache.g_pl_currow.pl_id = l_pl_id
4763: AND ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd = 'OPT'
4764: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_pl_currow.effective_start_date
4765: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_pl_currow.effective_end_date
4766: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4767: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_pl_currow.pl_id

Line 4764: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_pl_currow.effective_start_date

4760: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_wcf_num;
4761: --
4762: ELSIF ben_cobj_cache.g_pl_currow.pl_id = l_pl_id
4763: AND ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd = 'OPT'
4764: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_pl_currow.effective_start_date
4765: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_pl_currow.effective_end_date
4766: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4767: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_pl_currow.pl_id
4768: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date

Line 4765: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_pl_currow.effective_end_date

4761: --
4762: ELSIF ben_cobj_cache.g_pl_currow.pl_id = l_pl_id
4763: AND ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd = 'OPT'
4764: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_pl_currow.effective_start_date
4765: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_pl_currow.effective_end_date
4766: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4767: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_pl_currow.pl_id
4768: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4769: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN

Line 4766: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id

4762: ELSIF ben_cobj_cache.g_pl_currow.pl_id = l_pl_id
4763: AND ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd = 'OPT'
4764: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_pl_currow.effective_start_date
4765: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_pl_currow.effective_end_date
4766: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4767: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_pl_currow.pl_id
4768: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4769: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4770: --

Line 4767: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_pl_currow.pl_id

4763: AND ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd = 'OPT'
4764: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_pl_currow.effective_start_date
4765: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_pl_currow.effective_end_date
4766: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4767: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_pl_currow.pl_id
4768: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4769: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4770: --
4771: l_tmp_level := 1;

Line 4768: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date

4764: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_pl_currow.effective_start_date
4765: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_pl_currow.effective_end_date
4766: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4767: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_pl_currow.pl_id
4768: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4769: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4770: --
4771: l_tmp_level := 1;
4772: l_restriction_pgm_id := NULL;

Line 4769: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN

4765: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_pl_currow.effective_end_date
4766: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4767: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_pl_currow.pl_id
4768: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4769: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4770: --
4771: l_tmp_level := 1;
4772: l_restriction_pgm_id := NULL;
4773: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;

Line 4773: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;

4769: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4770: --
4771: l_tmp_level := 1;
4772: l_restriction_pgm_id := NULL;
4773: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4774: l_boo_rstrctn_cd := ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd;
4775: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_pl_currow.cvg_incr_r_decr_only_cd;
4776: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_num;
4777: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_wcf_num;

Line 4774: l_boo_rstrctn_cd := ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd;

4770: --
4771: l_tmp_level := 1;
4772: l_restriction_pgm_id := NULL;
4773: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4774: l_boo_rstrctn_cd := ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd;
4775: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_pl_currow.cvg_incr_r_decr_only_cd;
4776: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_num;
4777: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_wcf_num;
4778: --

Line 4775: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_pl_currow.cvg_incr_r_decr_only_cd;

4771: l_tmp_level := 1;
4772: l_restriction_pgm_id := NULL;
4773: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4774: l_boo_rstrctn_cd := ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd;
4775: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_pl_currow.cvg_incr_r_decr_only_cd;
4776: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_num;
4777: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_wcf_num;
4778: --
4779: END IF;

Line 4776: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_num;

4772: l_restriction_pgm_id := NULL;
4773: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4774: l_boo_rstrctn_cd := ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd;
4775: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_pl_currow.cvg_incr_r_decr_only_cd;
4776: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_num;
4777: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_wcf_num;
4778: --
4779: END IF;
4780: ELSE

Line 4777: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_wcf_num;

4773: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4774: l_boo_rstrctn_cd := ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd;
4775: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_pl_currow.cvg_incr_r_decr_only_cd;
4776: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_num;
4777: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_wcf_num;
4778: --
4779: END IF;
4780: ELSE
4781: --

Line 6581: l_rec_enrt_perd_strt_dt NOT BETWEEN ben_cobj_cache.g_opt_currow.effective_start_date

6577: --
6578: -- check opt
6579: --
6580: IF (
6581: l_rec_enrt_perd_strt_dt NOT BETWEEN ben_cobj_cache.g_opt_currow.effective_start_date
6582: AND ben_cobj_cache.g_opt_currow.effective_end_date) THEN
6583: open c_opt_requery(l_opt_id,l_rec_enrt_perd_strt_dt);
6584: fetch c_opt_requery into l_dummy;
6585: if c_opt_requery%notfound then

Line 6582: AND ben_cobj_cache.g_opt_currow.effective_end_date) THEN

6578: -- check opt
6579: --
6580: IF (
6581: l_rec_enrt_perd_strt_dt NOT BETWEEN ben_cobj_cache.g_opt_currow.effective_start_date
6582: AND ben_cobj_cache.g_opt_currow.effective_end_date) THEN
6583: open c_opt_requery(l_opt_id,l_rec_enrt_perd_strt_dt);
6584: fetch c_opt_requery into l_dummy;
6585: if c_opt_requery%notfound then
6586: if g_debug then

Line 6598: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_start_date));

6594: 'ENRT_PERD_STRT_DT',
6595: TO_CHAR(l_rec_enrt_perd_strt_dt));
6596: fnd_message.set_token(
6597: 'OPT_STRT_DT',
6598: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_start_date));
6599: fnd_message.set_token(
6600: 'OPT_END_DT',
6601: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_end_date));
6602: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

Line 6601: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_end_date));

6597: 'OPT_STRT_DT',
6598: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_start_date));
6599: fnd_message.set_token(
6600: 'OPT_END_DT',
6601: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_end_date));
6602: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6603: p_electable_flag := 'N';
6604: RETURN;
6605: end if;

Line 8670: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

8666: --
8667: l_dflt_enrt_cd VARCHAR2(30);
8668: l_dflt_enrt_rl NUMBER;
8669: l_plan_rec ben_pl_f%ROWTYPE;
8670: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
8671: l_pl_rec ben_cobj_cache.g_pl_inst_row;
8672: BEGIN
8673: g_debug := hr_utility.debug_enabled;
8674: if g_debug then

Line 8671: l_pl_rec ben_cobj_cache.g_pl_inst_row;

8667: l_dflt_enrt_cd VARCHAR2(30);
8668: l_dflt_enrt_rl NUMBER;
8669: l_plan_rec ben_pl_f%ROWTYPE;
8670: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
8671: l_pl_rec ben_cobj_cache.g_pl_inst_row;
8672: BEGIN
8673: g_debug := hr_utility.debug_enabled;
8674: if g_debug then
8675: hr_utility.set_location('Entering: ' || l_proc, 10);

Line 8709: ben_cobj_cache.get_oipl_dets (p_business_group_id => p_business_group_id,

8705: --
8706: -- 2
8707: -- Bug 5569758
8708: --
8709: ben_cobj_cache.get_oipl_dets (p_business_group_id => p_business_group_id,
8710: p_effective_date => p_effective_date,
8711: p_oipl_id => p_oipl_id,
8712: p_inst_row => l_oipl_rec
8713: );

Line 8775: ben_cobj_cache.get_pl_dets (p_business_group_id => p_business_group_id,

8771: AND l_dflt_enrt_cd IS NULL THEN
8772: --
8773: -- 7
8774: --
8775: ben_cobj_cache.get_pl_dets (p_business_group_id => p_business_group_id,
8776: p_effective_date => p_effective_date,
8777: p_pl_id => p_pl_id,
8778: p_inst_row => l_pl_rec
8779: );

Line 8936: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

8932: --
8933: l_dflt_enrt_cd VARCHAR2(30);
8934: l_dflt_enrt_rl NUMBER;
8935: l_plan_rec ben_pl_f%ROWTYPE;
8936: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
8937: l_ler_dflt_flag varchar2(30); -- 3510229
8938: BEGIN
8939: hr_utility.set_location('Entering: ' || l_proc, 10);
8940: --

Line 8979: --l_dflt_enrt_cd := ben_cobj_cache.g_oipl_currow.dflt_enrt_cd;

8975: -- 2
8976: --
8977: hr_utility.set_location('In the case 2 ' , 100);
8978: --
8979: --l_dflt_enrt_cd := ben_cobj_cache.g_oipl_currow.dflt_enrt_cd;
8980: --l_dflt_enrt_rl := ben_cobj_cache.g_oipl_currow.dflt_enrt_det_rl;
8981: --
8982: l_dflt_enrt_cd := p_oipl_rec.dflt_enrt_cd ;
8983: l_dflt_enrt_rl := p_oipl_rec.dflt_enrt_det_rl ;

Line 8980: --l_dflt_enrt_rl := ben_cobj_cache.g_oipl_currow.dflt_enrt_det_rl;

8976: --
8977: hr_utility.set_location('In the case 2 ' , 100);
8978: --
8979: --l_dflt_enrt_cd := ben_cobj_cache.g_oipl_currow.dflt_enrt_cd;
8980: --l_dflt_enrt_rl := ben_cobj_cache.g_oipl_currow.dflt_enrt_det_rl;
8981: --
8982: l_dflt_enrt_cd := p_oipl_rec.dflt_enrt_cd ;
8983: l_dflt_enrt_rl := p_oipl_rec.dflt_enrt_det_rl ;
8984:

Line 9114: -- l_dflt_enrt_cd := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_cd;

9110: --
9111: -- 7
9112: --
9113: -- Bug 1895874
9114: -- l_dflt_enrt_cd := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_cd;
9115: -- l_dflt_enrt_rl := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_det_rl;
9116: --
9117: hr_utility.set_location(' p_pl_rec.pl_id '||p_oipl_rec.oipl_id ,110);
9118: hr_utility.set_location(' p_pl_rec.nip_dflt_enrt_cd '||p_pl_rec.nip_dflt_enrt_cd ,110);

Line 9115: -- l_dflt_enrt_rl := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_det_rl;

9111: -- 7
9112: --
9113: -- Bug 1895874
9114: -- l_dflt_enrt_cd := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_cd;
9115: -- l_dflt_enrt_rl := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_det_rl;
9116: --
9117: hr_utility.set_location(' p_pl_rec.pl_id '||p_oipl_rec.oipl_id ,110);
9118: hr_utility.set_location(' p_pl_rec.nip_dflt_enrt_cd '||p_pl_rec.nip_dflt_enrt_cd ,110);
9119: hr_utility.set_location(' p_pl_rec.nip_dflt_flag '||p_pl_rec.nip_dflt_flag, 110) ;

Line 9287: if ben_cobj_cache.g_ptip_currow.ptip_id is not null

9283: --
9284: -- Check if context parameters are set. When context parameters are
9285: -- not set then fire cursor
9286: --
9287: if ben_cobj_cache.g_ptip_currow.ptip_id is not null
9288: or ben_cobj_cache.g_pl_currow.pl_id is not null
9289: or ben_cobj_cache.g_opt_currow.opt_id is not null
9290: or ben_cobj_cache.g_oipl_currow.oipl_id is not null
9291: then

Line 9288: or ben_cobj_cache.g_pl_currow.pl_id is not null

9284: -- Check if context parameters are set. When context parameters are
9285: -- not set then fire cursor
9286: --
9287: if ben_cobj_cache.g_ptip_currow.ptip_id is not null
9288: or ben_cobj_cache.g_pl_currow.pl_id is not null
9289: or ben_cobj_cache.g_opt_currow.opt_id is not null
9290: or ben_cobj_cache.g_oipl_currow.oipl_id is not null
9291: then
9292: --

Line 9289: or ben_cobj_cache.g_opt_currow.opt_id is not null

9285: -- not set then fire cursor
9286: --
9287: if ben_cobj_cache.g_ptip_currow.ptip_id is not null
9288: or ben_cobj_cache.g_pl_currow.pl_id is not null
9289: or ben_cobj_cache.g_opt_currow.opt_id is not null
9290: or ben_cobj_cache.g_oipl_currow.oipl_id is not null
9291: then
9292: --
9293: IF ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id

Line 9290: or ben_cobj_cache.g_oipl_currow.oipl_id is not null

9286: --
9287: if ben_cobj_cache.g_ptip_currow.ptip_id is not null
9288: or ben_cobj_cache.g_pl_currow.pl_id is not null
9289: or ben_cobj_cache.g_opt_currow.opt_id is not null
9290: or ben_cobj_cache.g_oipl_currow.oipl_id is not null
9291: then
9292: --
9293: IF ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
9294: AND (

Line 9293: IF ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id

9289: or ben_cobj_cache.g_opt_currow.opt_id is not null
9290: or ben_cobj_cache.g_oipl_currow.oipl_id is not null
9291: then
9292: --
9293: IF ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
9294: AND (
9295: (
9296: ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9297: AND ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)

Line 9296: ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL

9292: --
9293: IF ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
9294: AND (
9295: (
9296: ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9297: AND ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9298: OR ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9299: --
9300: p_level := 'OIPL';

Line 9297: AND ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)

9293: IF ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
9294: AND (
9295: (
9296: ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9297: AND ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9298: OR ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9299: --
9300: p_level := 'OIPL';
9301: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom;

Line 9298: OR ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN

9294: AND (
9295: (
9296: ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9297: AND ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9298: OR ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9299: --
9300: p_level := 'OIPL';
9301: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom;
9302: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val;

Line 9301: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom;

9297: AND ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9298: OR ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9299: --
9300: p_level := 'OIPL';
9301: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom;
9302: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val;
9303: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl;
9304: ELSIF ben_cobj_cache.g_opt_currow.opt_id = p_opt_id
9305: AND (

Line 9302: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val;

9298: OR ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9299: --
9300: p_level := 'OIPL';
9301: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom;
9302: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val;
9303: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl;
9304: ELSIF ben_cobj_cache.g_opt_currow.opt_id = p_opt_id
9305: AND (
9306: (

Line 9303: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl;

9299: --
9300: p_level := 'OIPL';
9301: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom;
9302: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val;
9303: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl;
9304: ELSIF ben_cobj_cache.g_opt_currow.opt_id = p_opt_id
9305: AND (
9306: (
9307: ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL

Line 9304: ELSIF ben_cobj_cache.g_opt_currow.opt_id = p_opt_id

9300: p_level := 'OIPL';
9301: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom;
9302: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val;
9303: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl;
9304: ELSIF ben_cobj_cache.g_opt_currow.opt_id = p_opt_id
9305: AND (
9306: (
9307: ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9308: AND ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)

Line 9307: ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL

9303: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl;
9304: ELSIF ben_cobj_cache.g_opt_currow.opt_id = p_opt_id
9305: AND (
9306: (
9307: ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9308: AND ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9309: OR ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9310: --
9311: p_level := 'OPT';

Line 9308: AND ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)

9304: ELSIF ben_cobj_cache.g_opt_currow.opt_id = p_opt_id
9305: AND (
9306: (
9307: ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9308: AND ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9309: OR ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9310: --
9311: p_level := 'OPT';
9312: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom;

Line 9309: OR ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN

9305: AND (
9306: (
9307: ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9308: AND ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9309: OR ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9310: --
9311: p_level := 'OPT';
9312: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom;
9313: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val;

Line 9312: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom;

9308: AND ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9309: OR ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9310: --
9311: p_level := 'OPT';
9312: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom;
9313: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val;
9314: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl;
9315: ELSIF ben_cobj_cache.g_pl_currow.pl_id = p_pl_id
9316: AND (

Line 9313: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val;

9309: OR ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9310: --
9311: p_level := 'OPT';
9312: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom;
9313: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val;
9314: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl;
9315: ELSIF ben_cobj_cache.g_pl_currow.pl_id = p_pl_id
9316: AND (
9317: (

Line 9314: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl;

9310: --
9311: p_level := 'OPT';
9312: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom;
9313: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val;
9314: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl;
9315: ELSIF ben_cobj_cache.g_pl_currow.pl_id = p_pl_id
9316: AND (
9317: (
9318: ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL

Line 9315: ELSIF ben_cobj_cache.g_pl_currow.pl_id = p_pl_id

9311: p_level := 'OPT';
9312: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom;
9313: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val;
9314: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl;
9315: ELSIF ben_cobj_cache.g_pl_currow.pl_id = p_pl_id
9316: AND (
9317: (
9318: ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9319: AND ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)

Line 9318: ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL

9314: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl;
9315: ELSIF ben_cobj_cache.g_pl_currow.pl_id = p_pl_id
9316: AND (
9317: (
9318: ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9319: AND ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9320: OR ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9321: --
9322: p_level := 'PL';

Line 9319: AND ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)

9315: ELSIF ben_cobj_cache.g_pl_currow.pl_id = p_pl_id
9316: AND (
9317: (
9318: ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9319: AND ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9320: OR ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9321: --
9322: p_level := 'PL';
9323: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom;

Line 9320: OR ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN

9316: AND (
9317: (
9318: ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9319: AND ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9320: OR ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9321: --
9322: p_level := 'PL';
9323: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom;
9324: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val;

Line 9323: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom;

9319: AND ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9320: OR ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9321: --
9322: p_level := 'PL';
9323: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom;
9324: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val;
9325: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl;
9326: ELSIF ben_cobj_cache.g_ptip_currow.ptip_id = p_ptip_id
9327: AND (

Line 9324: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val;

9320: OR ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9321: --
9322: p_level := 'PL';
9323: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom;
9324: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val;
9325: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl;
9326: ELSIF ben_cobj_cache.g_ptip_currow.ptip_id = p_ptip_id
9327: AND (
9328: (

Line 9325: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl;

9321: --
9322: p_level := 'PL';
9323: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom;
9324: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val;
9325: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl;
9326: ELSIF ben_cobj_cache.g_ptip_currow.ptip_id = p_ptip_id
9327: AND (
9328: (
9329: ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom IS NOT NULL

Line 9326: ELSIF ben_cobj_cache.g_ptip_currow.ptip_id = p_ptip_id

9322: p_level := 'PL';
9323: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom;
9324: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val;
9325: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl;
9326: ELSIF ben_cobj_cache.g_ptip_currow.ptip_id = p_ptip_id
9327: AND (
9328: (
9329: ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom IS NOT NULL
9330: AND ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)

Line 9329: ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom IS NOT NULL

9325: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl;
9326: ELSIF ben_cobj_cache.g_ptip_currow.ptip_id = p_ptip_id
9327: AND (
9328: (
9329: ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom IS NOT NULL
9330: AND ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9331: OR ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9332: --
9333: p_level := 'PTIP';

Line 9330: AND ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)

9326: ELSIF ben_cobj_cache.g_ptip_currow.ptip_id = p_ptip_id
9327: AND (
9328: (
9329: ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom IS NOT NULL
9330: AND ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9331: OR ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9332: --
9333: p_level := 'PTIP';
9334: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom;

Line 9331: OR ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN

9327: AND (
9328: (
9329: ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom IS NOT NULL
9330: AND ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9331: OR ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9332: --
9333: p_level := 'PTIP';
9334: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom;
9335: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val;

Line 9334: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom;

9330: AND ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9331: OR ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9332: --
9333: p_level := 'PTIP';
9334: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom;
9335: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val;
9336: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_rl;
9337: END IF;
9338: --

Line 9335: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val;

9331: OR ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9332: --
9333: p_level := 'PTIP';
9334: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom;
9335: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val;
9336: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_rl;
9337: END IF;
9338: --
9339: else

Line 9336: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_rl;

9332: --
9333: p_level := 'PTIP';
9334: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom;
9335: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val;
9336: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_rl;
9337: END IF;
9338: --
9339: else
9340: --