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 686: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

682: --
683: l_dflt_enrt_cd VARCHAR2(30);
684: l_dflt_enrt_rl NUMBER;
685: l_plan_rec ben_pl_f%ROWTYPE;
686: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
687: l_ler_dflt_flag varchar2(30); -- 3510229
688: BEGIN
689: --
690: g_debug := hr_utility.debug_enabled;

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

732: if g_debug then
733: hr_utility.set_location('In the case 2 ' , 100);
734: end if;
735: --
736: --l_dflt_enrt_cd := ben_cobj_cache.g_oipl_currow.dflt_enrt_cd;
737: --l_dflt_enrt_rl := ben_cobj_cache.g_oipl_currow.dflt_enrt_det_rl;
738: --
739: l_dflt_enrt_cd := p_oipl_rec.dflt_enrt_cd ;
740: l_dflt_enrt_rl := p_oipl_rec.dflt_enrt_det_rl ;

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

733: hr_utility.set_location('In the case 2 ' , 100);
734: end if;
735: --
736: --l_dflt_enrt_cd := ben_cobj_cache.g_oipl_currow.dflt_enrt_cd;
737: --l_dflt_enrt_rl := ben_cobj_cache.g_oipl_currow.dflt_enrt_det_rl;
738: --
739: l_dflt_enrt_cd := p_oipl_rec.dflt_enrt_cd ;
740: l_dflt_enrt_rl := p_oipl_rec.dflt_enrt_det_rl ;
741:

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

879: -- 6
880: --
881: hr_utility.set_location('In the case 2 ' , 100);
882: --
883: --l_dflt_enrt_cd := ben_cobj_cache.g_oipl_currow.dflt_enrt_cd;
884: --l_dflt_enrt_rl := ben_cobj_cache.g_oipl_currow.dflt_enrt_det_rl;
885: --
886: l_dflt_enrt_cd := p_oipl_rec.dflt_enrt_cd ;
887: l_dflt_enrt_rl := p_oipl_rec.dflt_enrt_det_rl ;

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

880: --
881: hr_utility.set_location('In the case 2 ' , 100);
882: --
883: --l_dflt_enrt_cd := ben_cobj_cache.g_oipl_currow.dflt_enrt_cd;
884: --l_dflt_enrt_rl := ben_cobj_cache.g_oipl_currow.dflt_enrt_det_rl;
885: --
886: l_dflt_enrt_cd := p_oipl_rec.dflt_enrt_cd ;
887: l_dflt_enrt_rl := p_oipl_rec.dflt_enrt_det_rl ;
888:

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

905: --
906: -- 7
907: --
908: -- Bug 1895874
909: -- l_dflt_enrt_cd := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_cd;
910: -- l_dflt_enrt_rl := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_det_rl;
911: --
912: if g_debug then
913: hr_utility.set_location(' p_pl_rec.pl_id '||p_oipl_rec.oipl_id ,110);

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

906: -- 7
907: --
908: -- Bug 1895874
909: -- l_dflt_enrt_cd := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_cd;
910: -- l_dflt_enrt_rl := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_det_rl;
911: --
912: if g_debug then
913: hr_utility.set_location(' p_pl_rec.pl_id '||p_oipl_rec.oipl_id ,110);
914: hr_utility.set_location(' p_pl_rec.nip_dflt_enrt_cd '||p_pl_rec.nip_dflt_enrt_cd ,110);

Line 2713: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

2709: l_enrd_ordr_num NUMBER;
2710: l_level VARCHAR2(30);
2711: l_plan_rec ben_pl_f%ROWTYPE;
2712: l_pgm_rec ben_pgm_f%ROWTYPE;
2713: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
2714: l_pen_rec ben_prtt_enrt_rslt_f%ROWTYPE;
2715: l_pl_typ_esd DATE;
2716: l_pl_typ_eed DATE;
2717: l_ler_esd DATE;

Line 3718: -- ben_cobj_cache.get_oipl_dets (

3714: -- Bug 2200139 For Override call the cache routine else call the benmnglecache
3715: -- this is not required as the data is fetched on the benovrrd.pkb
3716: --IF p_run_mode = 'V' THEN
3717: -- --
3718: -- ben_cobj_cache.get_oipl_dets (
3719: -- p_business_group_id => p_business_group_id
3720: -- ,p_effective_date => p_effective_date
3721: -- ,p_oipl_id => p_oipl_id
3722: -- ,p_inst_row => l_oipl_rec

Line 3727: l_oipl_rec := ben_cobj_cache.g_oipl_currow;

3723: -- ) ;
3724: -- --
3725: --ELSE
3726: --
3727: l_oipl_rec := ben_cobj_cache.g_oipl_currow;
3728: l_oipl_name := ben_cobj_cache.g_opt_currow.name;
3729: --
3730: --END IF;
3731: --

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

3724: -- --
3725: --ELSE
3726: --
3727: l_oipl_rec := ben_cobj_cache.g_oipl_currow;
3728: l_oipl_name := ben_cobj_cache.g_opt_currow.name;
3729: --
3730: --END IF;
3731: --
3732: l_pl_id := l_oipl_rec.pl_id;

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

3737: l_oipl_auto_enrt_flag := l_oipl_rec.auto_enrt_flag;
3738: l_oipl_auto_enrt_mthd_rl := l_oipl_rec.auto_enrt_mthd_rl;
3739: l_oipl_trk_inelig_per_flag := l_oipl_rec.trk_inelig_per_flag;
3740: --
3741: -- l_oipl_name := ben_cobj_cache.g_opt_currow.name;
3742: if g_debug then
3743: hr_utility.set_location('DONE OIPL NN: ' || l_proc, 10);
3744: end if;
3745: --

Line 4834: IF ben_cobj_cache.g_plip_currow.plip_id = l_plip_id

4830: IF c_ler_bnft_rstrn%NOTFOUND THEN
4831: --
4832: CLOSE c_ler_bnft_rstrn;
4833: -- Romoved the commented code
4834: IF ben_cobj_cache.g_plip_currow.plip_id = l_plip_id
4835: AND ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd = 'OPT'
4836: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_plip_currow.effective_start_date
4837: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_plip_currow.effective_end_date
4838: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id

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

4831: --
4832: CLOSE c_ler_bnft_rstrn;
4833: -- Romoved the commented code
4834: IF ben_cobj_cache.g_plip_currow.plip_id = l_plip_id
4835: AND ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd = 'OPT'
4836: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_plip_currow.effective_start_date
4837: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_plip_currow.effective_end_date
4838: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4839: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_plip_currow.pl_id

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

4832: CLOSE c_ler_bnft_rstrn;
4833: -- Romoved the commented code
4834: IF ben_cobj_cache.g_plip_currow.plip_id = l_plip_id
4835: AND ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd = 'OPT'
4836: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_plip_currow.effective_start_date
4837: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_plip_currow.effective_end_date
4838: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4839: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_plip_currow.pl_id
4840: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date

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

4833: -- Romoved the commented code
4834: IF ben_cobj_cache.g_plip_currow.plip_id = l_plip_id
4835: AND ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd = 'OPT'
4836: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_plip_currow.effective_start_date
4837: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_plip_currow.effective_end_date
4838: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4839: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_plip_currow.pl_id
4840: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4841: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN

Line 4838: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id

4834: IF ben_cobj_cache.g_plip_currow.plip_id = l_plip_id
4835: AND ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd = 'OPT'
4836: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_plip_currow.effective_start_date
4837: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_plip_currow.effective_end_date
4838: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4839: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_plip_currow.pl_id
4840: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4841: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4842: --

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

4835: AND ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd = 'OPT'
4836: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_plip_currow.effective_start_date
4837: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_plip_currow.effective_end_date
4838: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4839: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_plip_currow.pl_id
4840: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4841: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4842: --
4843: l_tmp_level := 2;

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

4836: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_plip_currow.effective_start_date
4837: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_plip_currow.effective_end_date
4838: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4839: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_plip_currow.pl_id
4840: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4841: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4842: --
4843: l_tmp_level := 2;
4844: l_restriction_pgm_id := ben_cobj_cache.g_plip_currow.pgm_id;

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

4837: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_plip_currow.effective_end_date
4838: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4839: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_plip_currow.pl_id
4840: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4841: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4842: --
4843: l_tmp_level := 2;
4844: l_restriction_pgm_id := ben_cobj_cache.g_plip_currow.pgm_id;
4845: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;

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

4840: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4841: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4842: --
4843: l_tmp_level := 2;
4844: l_restriction_pgm_id := ben_cobj_cache.g_plip_currow.pgm_id;
4845: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4846: l_boo_rstrctn_cd :=
4847: ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd;
4848: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_plip_currow.cvg_incr_r_decr_only_cd;

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

4841: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4842: --
4843: l_tmp_level := 2;
4844: l_restriction_pgm_id := ben_cobj_cache.g_plip_currow.pgm_id;
4845: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4846: l_boo_rstrctn_cd :=
4847: ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd;
4848: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_plip_currow.cvg_incr_r_decr_only_cd;
4849: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_num;

Line 4847: ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd;

4843: l_tmp_level := 2;
4844: l_restriction_pgm_id := ben_cobj_cache.g_plip_currow.pgm_id;
4845: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4846: l_boo_rstrctn_cd :=
4847: ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd;
4848: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_plip_currow.cvg_incr_r_decr_only_cd;
4849: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_num;
4850: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_wcf_num;
4851: --

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

4844: l_restriction_pgm_id := ben_cobj_cache.g_plip_currow.pgm_id;
4845: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4846: l_boo_rstrctn_cd :=
4847: ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd;
4848: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_plip_currow.cvg_incr_r_decr_only_cd;
4849: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_num;
4850: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_wcf_num;
4851: --
4852: ELSIF ben_cobj_cache.g_pl_currow.pl_id = l_pl_id

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

4845: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4846: l_boo_rstrctn_cd :=
4847: ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd;
4848: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_plip_currow.cvg_incr_r_decr_only_cd;
4849: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_num;
4850: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_wcf_num;
4851: --
4852: ELSIF ben_cobj_cache.g_pl_currow.pl_id = l_pl_id
4853: AND ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd = 'OPT'

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

4846: l_boo_rstrctn_cd :=
4847: ben_cobj_cache.g_plip_currow.bnft_or_option_rstrctn_cd;
4848: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_plip_currow.cvg_incr_r_decr_only_cd;
4849: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_num;
4850: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_wcf_num;
4851: --
4852: ELSIF ben_cobj_cache.g_pl_currow.pl_id = l_pl_id
4853: AND ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd = 'OPT'
4854: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_pl_currow.effective_start_date

Line 4852: ELSIF ben_cobj_cache.g_pl_currow.pl_id = l_pl_id

4848: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_plip_currow.cvg_incr_r_decr_only_cd;
4849: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_num;
4850: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_wcf_num;
4851: --
4852: ELSIF ben_cobj_cache.g_pl_currow.pl_id = l_pl_id
4853: AND ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd = 'OPT'
4854: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_pl_currow.effective_start_date
4855: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_pl_currow.effective_end_date
4856: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id

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

4849: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_num;
4850: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_wcf_num;
4851: --
4852: ELSIF ben_cobj_cache.g_pl_currow.pl_id = l_pl_id
4853: AND ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd = 'OPT'
4854: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_pl_currow.effective_start_date
4855: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_pl_currow.effective_end_date
4856: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4857: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_pl_currow.pl_id

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

4850: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_plip_currow.mx_cvg_mlt_incr_wcf_num;
4851: --
4852: ELSIF ben_cobj_cache.g_pl_currow.pl_id = l_pl_id
4853: AND ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd = 'OPT'
4854: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_pl_currow.effective_start_date
4855: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_pl_currow.effective_end_date
4856: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4857: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_pl_currow.pl_id
4858: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date

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

4851: --
4852: ELSIF ben_cobj_cache.g_pl_currow.pl_id = l_pl_id
4853: AND ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd = 'OPT'
4854: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_pl_currow.effective_start_date
4855: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_pl_currow.effective_end_date
4856: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4857: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_pl_currow.pl_id
4858: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4859: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN

Line 4856: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id

4852: ELSIF ben_cobj_cache.g_pl_currow.pl_id = l_pl_id
4853: AND ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd = 'OPT'
4854: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_pl_currow.effective_start_date
4855: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_pl_currow.effective_end_date
4856: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4857: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_pl_currow.pl_id
4858: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4859: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4860: --

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

4853: AND ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd = 'OPT'
4854: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_pl_currow.effective_start_date
4855: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_pl_currow.effective_end_date
4856: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4857: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_pl_currow.pl_id
4858: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4859: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4860: --
4861: l_tmp_level := 1;

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

4854: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_pl_currow.effective_start_date
4855: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_pl_currow.effective_end_date
4856: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4857: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_pl_currow.pl_id
4858: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4859: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4860: --
4861: l_tmp_level := 1;
4862: l_restriction_pgm_id := NULL;

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

4855: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_pl_currow.effective_end_date
4856: AND ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
4857: AND ben_cobj_cache.g_oipl_currow.pl_id = ben_cobj_cache.g_pl_currow.pl_id
4858: AND l_lf_evt_ocrd_dt >= ben_cobj_cache.g_oipl_currow.effective_start_date
4859: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4860: --
4861: l_tmp_level := 1;
4862: l_restriction_pgm_id := NULL;
4863: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;

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

4859: AND l_lf_evt_ocrd_dt <= ben_cobj_cache.g_oipl_currow.effective_end_date THEN
4860: --
4861: l_tmp_level := 1;
4862: l_restriction_pgm_id := NULL;
4863: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4864: l_boo_rstrctn_cd := ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd;
4865: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_pl_currow.cvg_incr_r_decr_only_cd;
4866: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_num;
4867: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_wcf_num;

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

4860: --
4861: l_tmp_level := 1;
4862: l_restriction_pgm_id := NULL;
4863: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4864: l_boo_rstrctn_cd := ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd;
4865: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_pl_currow.cvg_incr_r_decr_only_cd;
4866: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_num;
4867: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_wcf_num;
4868: --

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

4861: l_tmp_level := 1;
4862: l_restriction_pgm_id := NULL;
4863: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4864: l_boo_rstrctn_cd := ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd;
4865: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_pl_currow.cvg_incr_r_decr_only_cd;
4866: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_num;
4867: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_wcf_num;
4868: --
4869: END IF;

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

4862: l_restriction_pgm_id := NULL;
4863: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4864: l_boo_rstrctn_cd := ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd;
4865: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_pl_currow.cvg_incr_r_decr_only_cd;
4866: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_num;
4867: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_wcf_num;
4868: --
4869: END IF;
4870: ELSE

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

4863: l_oipl_ordr_num := ben_cobj_cache.g_oipl_currow.ordr_num;
4864: l_boo_rstrctn_cd := ben_cobj_cache.g_pl_currow.bnft_or_option_rstrctn_cd;
4865: l_cvg_incr_r_decr_only_cd := ben_cobj_cache.g_pl_currow.cvg_incr_r_decr_only_cd;
4866: l_mx_cvg_mlt_incr_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_num;
4867: l_mx_cvg_mlt_incr_wcf_num := ben_cobj_cache.g_pl_currow.mx_cvg_mlt_incr_wcf_num;
4868: --
4869: END IF;
4870: ELSE
4871: --

Line 6715: l_rec_enrt_perd_strt_dt NOT BETWEEN ben_cobj_cache.g_opt_currow.effective_start_date

6711: --
6712: -- check opt
6713: --
6714: IF (
6715: l_rec_enrt_perd_strt_dt NOT BETWEEN ben_cobj_cache.g_opt_currow.effective_start_date
6716: AND ben_cobj_cache.g_opt_currow.effective_end_date) THEN
6717: open c_opt_requery(l_opt_id,l_rec_enrt_perd_strt_dt);
6718: fetch c_opt_requery into l_dummy;
6719: if c_opt_requery%notfound then

Line 6716: AND ben_cobj_cache.g_opt_currow.effective_end_date) THEN

6712: -- check opt
6713: --
6714: IF (
6715: l_rec_enrt_perd_strt_dt NOT BETWEEN ben_cobj_cache.g_opt_currow.effective_start_date
6716: AND ben_cobj_cache.g_opt_currow.effective_end_date) THEN
6717: open c_opt_requery(l_opt_id,l_rec_enrt_perd_strt_dt);
6718: fetch c_opt_requery into l_dummy;
6719: if c_opt_requery%notfound then
6720: if g_debug then

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

6728: 'ENRT_PERD_STRT_DT',
6729: TO_CHAR(l_rec_enrt_perd_strt_dt));
6730: fnd_message.set_token(
6731: 'OPT_STRT_DT',
6732: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_start_date));
6733: fnd_message.set_token(
6734: 'OPT_END_DT',
6735: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_end_date));
6736: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

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

6731: 'OPT_STRT_DT',
6732: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_start_date));
6733: fnd_message.set_token(
6734: 'OPT_END_DT',
6735: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_end_date));
6736: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6737: p_electable_flag := 'N';
6738: RETURN;
6739: end if;

Line 8809: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

8805: --
8806: l_dflt_enrt_cd VARCHAR2(30);
8807: l_dflt_enrt_rl NUMBER;
8808: l_plan_rec ben_pl_f%ROWTYPE;
8809: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
8810: l_pl_rec ben_cobj_cache.g_pl_inst_row;
8811: BEGIN
8812: g_debug := hr_utility.debug_enabled;
8813: if g_debug then

Line 8810: l_pl_rec ben_cobj_cache.g_pl_inst_row;

8806: l_dflt_enrt_cd VARCHAR2(30);
8807: l_dflt_enrt_rl NUMBER;
8808: l_plan_rec ben_pl_f%ROWTYPE;
8809: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
8810: l_pl_rec ben_cobj_cache.g_pl_inst_row;
8811: BEGIN
8812: g_debug := hr_utility.debug_enabled;
8813: if g_debug then
8814: hr_utility.set_location('Entering: ' || l_proc, 10);

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

8844: --
8845: -- 2
8846: -- Bug 5569758
8847: --
8848: ben_cobj_cache.get_oipl_dets (p_business_group_id => p_business_group_id,
8849: p_effective_date => p_effective_date,
8850: p_oipl_id => p_oipl_id,
8851: p_inst_row => l_oipl_rec
8852: );

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

8910: AND l_dflt_enrt_cd IS NULL THEN
8911: --
8912: -- 7
8913: --
8914: ben_cobj_cache.get_pl_dets (p_business_group_id => p_business_group_id,
8915: p_effective_date => p_effective_date,
8916: p_pl_id => p_pl_id,
8917: p_inst_row => l_pl_rec
8918: );

Line 9075: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;

9071: --
9072: l_dflt_enrt_cd VARCHAR2(30);
9073: l_dflt_enrt_rl NUMBER;
9074: l_plan_rec ben_pl_f%ROWTYPE;
9075: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
9076: l_ler_dflt_flag varchar2(30); -- 3510229
9077: BEGIN
9078: hr_utility.set_location('Entering: ' || l_proc, 10);
9079: --

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

9114: -- 2
9115: --
9116: hr_utility.set_location('In the case 2 ' , 100);
9117: --
9118: --l_dflt_enrt_cd := ben_cobj_cache.g_oipl_currow.dflt_enrt_cd;
9119: --l_dflt_enrt_rl := ben_cobj_cache.g_oipl_currow.dflt_enrt_det_rl;
9120: --
9121: l_dflt_enrt_cd := p_oipl_rec.dflt_enrt_cd ;
9122: l_dflt_enrt_rl := p_oipl_rec.dflt_enrt_det_rl ;

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

9115: --
9116: hr_utility.set_location('In the case 2 ' , 100);
9117: --
9118: --l_dflt_enrt_cd := ben_cobj_cache.g_oipl_currow.dflt_enrt_cd;
9119: --l_dflt_enrt_rl := ben_cobj_cache.g_oipl_currow.dflt_enrt_det_rl;
9120: --
9121: l_dflt_enrt_cd := p_oipl_rec.dflt_enrt_cd ;
9122: l_dflt_enrt_rl := p_oipl_rec.dflt_enrt_det_rl ;
9123:

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

9249: --
9250: -- 7
9251: --
9252: -- Bug 1895874
9253: -- l_dflt_enrt_cd := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_cd;
9254: -- l_dflt_enrt_rl := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_det_rl;
9255: --
9256: hr_utility.set_location(' p_pl_rec.pl_id '||p_oipl_rec.oipl_id ,110);
9257: hr_utility.set_location(' p_pl_rec.nip_dflt_enrt_cd '||p_pl_rec.nip_dflt_enrt_cd ,110);

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

9250: -- 7
9251: --
9252: -- Bug 1895874
9253: -- l_dflt_enrt_cd := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_cd;
9254: -- l_dflt_enrt_rl := ben_cobj_cache.g_pl_currow.nip_dflt_enrt_det_rl;
9255: --
9256: hr_utility.set_location(' p_pl_rec.pl_id '||p_oipl_rec.oipl_id ,110);
9257: hr_utility.set_location(' p_pl_rec.nip_dflt_enrt_cd '||p_pl_rec.nip_dflt_enrt_cd ,110);
9258: hr_utility.set_location(' p_pl_rec.nip_dflt_flag '||p_pl_rec.nip_dflt_flag, 110) ;

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

9422: --
9423: -- Check if context parameters are set. When context parameters are
9424: -- not set then fire cursor
9425: --
9426: if ben_cobj_cache.g_ptip_currow.ptip_id is not null
9427: or ben_cobj_cache.g_pl_currow.pl_id is not null
9428: or ben_cobj_cache.g_opt_currow.opt_id is not null
9429: or ben_cobj_cache.g_oipl_currow.oipl_id is not null
9430: then

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

9423: -- Check if context parameters are set. When context parameters are
9424: -- not set then fire cursor
9425: --
9426: if ben_cobj_cache.g_ptip_currow.ptip_id is not null
9427: or ben_cobj_cache.g_pl_currow.pl_id is not null
9428: or ben_cobj_cache.g_opt_currow.opt_id is not null
9429: or ben_cobj_cache.g_oipl_currow.oipl_id is not null
9430: then
9431: --

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

9424: -- not set then fire cursor
9425: --
9426: if ben_cobj_cache.g_ptip_currow.ptip_id is not null
9427: or ben_cobj_cache.g_pl_currow.pl_id is not null
9428: or ben_cobj_cache.g_opt_currow.opt_id is not null
9429: or ben_cobj_cache.g_oipl_currow.oipl_id is not null
9430: then
9431: --
9432: IF ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id

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

9425: --
9426: if ben_cobj_cache.g_ptip_currow.ptip_id is not null
9427: or ben_cobj_cache.g_pl_currow.pl_id is not null
9428: or ben_cobj_cache.g_opt_currow.opt_id is not null
9429: or ben_cobj_cache.g_oipl_currow.oipl_id is not null
9430: then
9431: --
9432: IF ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
9433: AND (

Line 9432: IF ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id

9428: or ben_cobj_cache.g_opt_currow.opt_id is not null
9429: or ben_cobj_cache.g_oipl_currow.oipl_id is not null
9430: then
9431: --
9432: IF ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
9433: AND (
9434: (
9435: ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9436: AND ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)

Line 9435: ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL

9431: --
9432: IF ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
9433: AND (
9434: (
9435: ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9436: AND ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9437: OR ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9438: --
9439: p_level := 'OIPL';

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

9432: IF ben_cobj_cache.g_oipl_currow.oipl_id = p_oipl_id
9433: AND (
9434: (
9435: ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9436: AND ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9437: OR ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9438: --
9439: p_level := 'OIPL';
9440: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom;

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

9433: AND (
9434: (
9435: ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9436: AND ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9437: OR ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9438: --
9439: p_level := 'OIPL';
9440: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom;
9441: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val;

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

9436: AND ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9437: OR ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9438: --
9439: p_level := 'OIPL';
9440: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom;
9441: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val;
9442: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl;
9443: ELSIF ben_cobj_cache.g_opt_currow.opt_id = p_opt_id
9444: AND (

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

9437: OR ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9438: --
9439: p_level := 'OIPL';
9440: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom;
9441: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val;
9442: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl;
9443: ELSIF ben_cobj_cache.g_opt_currow.opt_id = p_opt_id
9444: AND (
9445: (

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

9438: --
9439: p_level := 'OIPL';
9440: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom;
9441: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val;
9442: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl;
9443: ELSIF ben_cobj_cache.g_opt_currow.opt_id = p_opt_id
9444: AND (
9445: (
9446: ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL

Line 9443: ELSIF ben_cobj_cache.g_opt_currow.opt_id = p_opt_id

9439: p_level := 'OIPL';
9440: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_uom;
9441: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_val;
9442: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl;
9443: ELSIF ben_cobj_cache.g_opt_currow.opt_id = p_opt_id
9444: AND (
9445: (
9446: ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9447: AND ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)

Line 9446: ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL

9442: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_oipl_currow.rqd_perd_enrt_nenrt_rl;
9443: ELSIF ben_cobj_cache.g_opt_currow.opt_id = p_opt_id
9444: AND (
9445: (
9446: ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9447: AND ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9448: OR ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9449: --
9450: p_level := 'OPT';

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

9443: ELSIF ben_cobj_cache.g_opt_currow.opt_id = p_opt_id
9444: AND (
9445: (
9446: ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9447: AND ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9448: OR ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9449: --
9450: p_level := 'OPT';
9451: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom;

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

9444: AND (
9445: (
9446: ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9447: AND ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9448: OR ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9449: --
9450: p_level := 'OPT';
9451: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom;
9452: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val;

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

9447: AND ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9448: OR ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9449: --
9450: p_level := 'OPT';
9451: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom;
9452: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val;
9453: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl;
9454: ELSIF ben_cobj_cache.g_pl_currow.pl_id = p_pl_id
9455: AND (

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

9448: OR ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9449: --
9450: p_level := 'OPT';
9451: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom;
9452: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val;
9453: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl;
9454: ELSIF ben_cobj_cache.g_pl_currow.pl_id = p_pl_id
9455: AND (
9456: (

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

9449: --
9450: p_level := 'OPT';
9451: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom;
9452: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val;
9453: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl;
9454: ELSIF ben_cobj_cache.g_pl_currow.pl_id = p_pl_id
9455: AND (
9456: (
9457: ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL

Line 9454: ELSIF ben_cobj_cache.g_pl_currow.pl_id = p_pl_id

9450: p_level := 'OPT';
9451: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_uom;
9452: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_val;
9453: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl;
9454: ELSIF ben_cobj_cache.g_pl_currow.pl_id = p_pl_id
9455: AND (
9456: (
9457: ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9458: AND ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)

Line 9457: ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL

9453: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_opt_currow.rqd_perd_enrt_nenrt_rl;
9454: ELSIF ben_cobj_cache.g_pl_currow.pl_id = p_pl_id
9455: AND (
9456: (
9457: ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9458: AND ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9459: OR ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9460: --
9461: p_level := 'PL';

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

9454: ELSIF ben_cobj_cache.g_pl_currow.pl_id = p_pl_id
9455: AND (
9456: (
9457: ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9458: AND ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9459: OR ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9460: --
9461: p_level := 'PL';
9462: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom;

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

9455: AND (
9456: (
9457: ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom IS NOT NULL
9458: AND ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9459: OR ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9460: --
9461: p_level := 'PL';
9462: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom;
9463: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val;

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

9458: AND ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9459: OR ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9460: --
9461: p_level := 'PL';
9462: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom;
9463: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val;
9464: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl;
9465: ELSIF ben_cobj_cache.g_ptip_currow.ptip_id = p_ptip_id
9466: AND (

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

9459: OR ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9460: --
9461: p_level := 'PL';
9462: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom;
9463: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val;
9464: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl;
9465: ELSIF ben_cobj_cache.g_ptip_currow.ptip_id = p_ptip_id
9466: AND (
9467: (

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

9460: --
9461: p_level := 'PL';
9462: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom;
9463: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val;
9464: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl;
9465: ELSIF ben_cobj_cache.g_ptip_currow.ptip_id = p_ptip_id
9466: AND (
9467: (
9468: ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom IS NOT NULL

Line 9465: ELSIF ben_cobj_cache.g_ptip_currow.ptip_id = p_ptip_id

9461: p_level := 'PL';
9462: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_uom;
9463: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_val;
9464: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl;
9465: ELSIF ben_cobj_cache.g_ptip_currow.ptip_id = p_ptip_id
9466: AND (
9467: (
9468: ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom IS NOT NULL
9469: AND ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)

Line 9468: ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom IS NOT NULL

9464: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_pl_currow.rqd_perd_enrt_nenrt_rl;
9465: ELSIF ben_cobj_cache.g_ptip_currow.ptip_id = p_ptip_id
9466: AND (
9467: (
9468: ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom IS NOT NULL
9469: AND ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9470: OR ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9471: --
9472: p_level := 'PTIP';

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

9465: ELSIF ben_cobj_cache.g_ptip_currow.ptip_id = p_ptip_id
9466: AND (
9467: (
9468: ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom IS NOT NULL
9469: AND ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9470: OR ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9471: --
9472: p_level := 'PTIP';
9473: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom;

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

9466: AND (
9467: (
9468: ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom IS NOT NULL
9469: AND ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9470: OR ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9471: --
9472: p_level := 'PTIP';
9473: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom;
9474: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val;

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

9469: AND ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val IS NOT NULL)
9470: OR ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9471: --
9472: p_level := 'PTIP';
9473: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom;
9474: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val;
9475: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_rl;
9476: END IF;
9477: --

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

9470: OR ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_rl IS NOT NULL) THEN
9471: --
9472: p_level := 'PTIP';
9473: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom;
9474: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val;
9475: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_rl;
9476: END IF;
9477: --
9478: else

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

9471: --
9472: p_level := 'PTIP';
9473: p_rqd_perd_enrt_nenrt_uom := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_tm_uom;
9474: p_rqd_perd_enrt_nenrt_val := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_val;
9475: p_rqd_perd_enrt_nenrt_rl := ben_cobj_cache.g_ptip_currow.rqd_perd_enrt_nenrt_rl;
9476: END IF;
9477: --
9478: else
9479: --