APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_DERIVE_PART_AND_RATE_CACHE

Line 1338: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_clf_rec_obj

1334: --
1335: FUNCTION get_salary_date(
1336: p_empasg_row IN per_all_assignments_f%ROWTYPE
1337: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
1338: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
1339: ,p_person_id IN NUMBER
1340: ,p_effective_date IN DATE
1341: ,p_min IN NUMBER
1342: ,p_max IN NUMBER

Line 2303: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_los_rec_obj

2299: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
2300: ,p_pil_row IN ben_per_in_ler%ROWTYPE
2301: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
2302: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
2303: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_los_rec_obj
2304: ,p_comp_rec IN OUT NOCOPY g_cache_structure
2305: ,p_effective_date IN DATE
2306: ,p_lf_evt_ocrd_dt IN DATE
2307: ,p_business_group_id IN NUMBER

Line 2590: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_age_rec_obj

2586: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
2587: ,p_pil_row IN ben_per_in_ler%ROWTYPE
2588: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
2589: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
2590: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_age_rec_obj
2591: ,p_effective_date IN DATE
2592: ,p_lf_evt_ocrd_dt IN DATE
2593: ,p_business_group_id IN NUMBER
2594: ,p_person_id IN NUMBER

Line 3036: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj

3032: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
3033: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
3034: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
3035: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
3036: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj
3037: ,p_business_group_id IN NUMBER
3038: ,p_person_id IN NUMBER
3039: ,p_pgm_id IN NUMBER
3040: ,p_pl_id IN NUMBER

Line 3372: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_clf_rec_obj

3368: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
3369: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
3370: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
3371: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
3372: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
3373: ,p_person_id IN NUMBER
3374: ,p_business_group_id IN NUMBER
3375: ,p_pgm_id IN NUMBER
3376: ,p_pl_id IN NUMBER

Line 3799: l_elig_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;

3795: l_rate_prem_result NUMBER;
3796: l_elig_result NUMBER;
3797: l_subtract_date DATE;
3798: l_start_date DATE;
3799: l_elig_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3800: l_rate_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3801: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3802: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3803: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;

Line 3800: l_rate_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;

3796: l_elig_result NUMBER;
3797: l_subtract_date DATE;
3798: l_start_date DATE;
3799: l_elig_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3800: l_rate_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3801: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3802: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3803: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
3804: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;

Line 3801: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;

3797: l_subtract_date DATE;
3798: l_start_date DATE;
3799: l_elig_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3800: l_rate_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3801: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3802: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3803: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
3804: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
3805: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

Line 3802: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;

3798: l_start_date DATE;
3799: l_elig_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3800: l_rate_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3801: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3802: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;
3803: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
3804: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
3805: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
3806: l_effective_date DATE := NVL(p_lf_evt_ocrd_dt

Line 3851: ben_derive_part_and_rate_cache.get_los_stated(p_los_fctr_id=> p_los_fctr_id

3847: ELSE
3848: --
3849: IF p_los_fctr_id IS NOT NULL THEN
3850: --
3851: ben_derive_part_and_rate_cache.get_los_stated(p_los_fctr_id=> p_los_fctr_id
3852: ,p_business_group_id => p_business_group_id
3853: ,p_rec => l_elig_rec);
3854: --
3855: ELSE

Line 3857: ben_derive_part_and_rate_cache.get_los_elig(p_pgm_id=> p_pgm_id

3853: ,p_rec => l_elig_rec);
3854: --
3855: ELSE
3856: --
3857: ben_derive_part_and_rate_cache.get_los_elig(p_pgm_id=> p_pgm_id
3858: ,p_pl_id => p_pl_id
3859: ,p_oipl_id => p_oipl_id
3860: ,p_plip_id => p_plip_id
3861: ,p_ptip_id => p_ptip_id

Line 3953: ben_derive_part_and_rate_cache.get_los_elig(p_pgm_id=> p_pgm_id

3949: -- was created before for the same breach
3950: l_los_val := p_comp_rec.los_val;
3951: Loop
3952: g_lf_evt_exists := false;
3953: ben_derive_part_and_rate_cache.get_los_elig(p_pgm_id=> p_pgm_id
3954: ,p_pl_id => p_pl_id
3955: ,p_oipl_id => p_oipl_id
3956: ,p_plip_id => p_plip_id
3957: ,p_ptip_id => p_ptip_id

Line 4046: ben_derive_part_and_rate_cache.get_los_stated(p_los_fctr_id=> p_los_fctr_id

4042: ELSE
4043: --
4044: IF p_los_fctr_id IS NOT NULL THEN
4045: --
4046: ben_derive_part_and_rate_cache.get_los_stated(p_los_fctr_id=> p_los_fctr_id
4047: ,p_business_group_id => p_business_group_id
4048: ,p_rec => l_rate_rec);
4049: --
4050: ELSE

Line 4052: ben_derive_part_and_rate_cache.get_los_rate(p_pgm_id=> p_pgm_id

4048: ,p_rec => l_rate_rec);
4049: --
4050: ELSE
4051: --
4052: ben_derive_part_and_rate_cache.get_los_rate(p_pgm_id=> p_pgm_id
4053: ,p_pl_id => p_pl_id
4054: ,p_oipl_id => p_oipl_id
4055: ,p_plip_id => p_plip_id
4056: ,p_ptip_id => p_ptip_id

Line 4146: ben_derive_part_and_rate_cache.get_los_rate(p_pgm_id=> p_pgm_id

4142:
4143: --
4144: IF l_rate_result is not null THEN
4145: --
4146: ben_derive_part_and_rate_cache.get_los_rate(p_pgm_id=> p_pgm_id
4147: ,p_pl_id => p_pl_id
4148: ,p_oipl_id => p_oipl_id
4149: ,p_plip_id => p_plip_id
4150: ,p_ptip_id => p_ptip_id

Line 4525: l_elig_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;

4521: l_rate_cvg_result NUMBER;
4522: l_rate_prem_result NUMBER;
4523: l_elig_result NUMBER;
4524: l_subtract_date DATE;
4525: l_elig_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4526: l_rate_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4527: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4528: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4529: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

Line 4526: l_rate_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;

4522: l_rate_prem_result NUMBER;
4523: l_elig_result NUMBER;
4524: l_subtract_date DATE;
4525: l_elig_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4526: l_rate_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4527: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4528: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4529: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
4530: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;

Line 4527: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;

4523: l_elig_result NUMBER;
4524: l_subtract_date DATE;
4525: l_elig_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4526: l_rate_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4527: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4528: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4529: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
4530: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
4531: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;

Line 4528: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;

4524: l_subtract_date DATE;
4525: l_elig_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4526: l_rate_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4527: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4528: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;
4529: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
4530: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
4531: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
4532: l_rate BOOLEAN := FALSE;

Line 4597: ben_derive_part_and_rate_cache.get_age_stated(p_age_fctr_id=> p_age_fctr_id

4593: -- so go and grab the values from the ben_age_fctr table
4594: --
4595: IF p_age_fctr_id IS NOT NULL THEN
4596: --
4597: ben_derive_part_and_rate_cache.get_age_stated(p_age_fctr_id=> p_age_fctr_id
4598: ,p_business_group_id => p_business_group_id
4599: ,p_rec => l_elig_rec);
4600: --
4601: ELSE

Line 4603: ben_derive_part_and_rate_cache.get_age_elig(p_pgm_id=> p_pgm_id

4599: ,p_rec => l_elig_rec);
4600: --
4601: ELSE
4602: --
4603: ben_derive_part_and_rate_cache.get_age_elig(p_pgm_id=> p_pgm_id
4604: ,p_pl_id => p_pl_id
4605: ,p_oipl_id => p_oipl_id
4606: ,p_plip_id => p_plip_id
4607: ,p_ptip_id => p_ptip_id

Line 4646: ben_derive_part_and_rate_cache.get_age_elig(p_pgm_id=> p_pgm_id

4642: --
4643: l_age_val := p_comp_rec.age_val;
4644: Loop
4645: g_lf_evt_exists := false;
4646: ben_derive_part_and_rate_cache.get_age_elig(p_pgm_id=> p_pgm_id
4647: ,p_pl_id => p_pl_id
4648: ,p_oipl_id => p_oipl_id
4649: ,p_plip_id => p_plip_id
4650: ,p_ptip_id => p_ptip_id

Line 4754: ben_derive_part_and_rate_cache.get_age_stated(p_age_fctr_id=> p_age_fctr_id

4750: --
4751: IF p_age_fctr_id IS NOT NULL THEN
4752: --
4753: --hr_utility.set_location(' p_age_fctr_id '||p_age_fctr_id,23);
4754: ben_derive_part_and_rate_cache.get_age_stated(p_age_fctr_id=> p_age_fctr_id
4755: ,p_business_group_id => p_business_group_id
4756: ,p_rec => l_rate_rec);
4757: --
4758: ELSE

Line 4764: ben_derive_part_and_rate_cache.get_age_rate(p_pgm_id=> p_pgm_id

4760: if g_debug then
4761: hr_utility.set_location('Getting Age for Rate',10);
4762: end if;
4763: --
4764: ben_derive_part_and_rate_cache.get_age_rate(p_pgm_id=> p_pgm_id
4765: ,p_pl_id => p_pl_id
4766: ,p_oipl_id => p_oipl_id
4767: ,p_plip_id => p_plip_id
4768: ,p_ptip_id => p_ptip_id

Line 4808: ben_derive_part_and_rate_cache.get_age_rate(

4804: --
4805: IF l_rate_result is not null THEN
4806: --
4807: --hr_utility.set_location(' Step 11',10 );
4808: ben_derive_part_and_rate_cache.get_age_rate(
4809: p_pgm_id => p_pgm_id
4810: ,p_pl_id => p_pl_id
4811: ,p_oipl_id => p_oipl_id
4812: ,p_plip_id => p_plip_id

Line 5113: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_clf_rec_obj

5109: PROCEDURE comp_level_min_max
5110: (p_calculate_only_mode in boolean default false
5111: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
5112: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
5113: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
5114: -- ,p_rate_rec IN OUT ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
5115: -- ,p_comp_rec IN OUT NOCOPY g_cache_structure
5116: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
5117: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

Line 5114: -- ,p_rate_rec IN OUT ben_derive_part_and_rate_cache.g_cache_clf_rec_obj

5110: (p_calculate_only_mode in boolean default false
5111: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
5112: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
5113: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
5114: -- ,p_rate_rec IN OUT ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
5115: -- ,p_comp_rec IN OUT NOCOPY g_cache_structure
5116: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
5117: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
5118: ,p_person_id IN NUMBER

Line 5483: l_elig_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;

5479: l_elig_result NUMBER;
5480: l_subtract_date DATE;
5481: l_lf_evt_ocrd_dt DATE;
5482: l_new_lf_evt_ocrd_dt DATE;
5483: l_elig_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;
5484: l_rate_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;
5485: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;
5486: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;
5487: l_break VARCHAR2(30);

Line 5484: l_rate_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;

5480: l_subtract_date DATE;
5481: l_lf_evt_ocrd_dt DATE;
5482: l_new_lf_evt_ocrd_dt DATE;
5483: l_elig_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;
5484: l_rate_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;
5485: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;
5486: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;
5487: l_break VARCHAR2(30);
5488: l_ok BOOLEAN;

Line 5485: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;

5481: l_lf_evt_ocrd_dt DATE;
5482: l_new_lf_evt_ocrd_dt DATE;
5483: l_elig_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;
5484: l_rate_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;
5485: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;
5486: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;
5487: l_break VARCHAR2(30);
5488: l_ok BOOLEAN;
5489: l_rec ben_person_object.g_person_date_info_rec;

Line 5486: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;

5482: l_new_lf_evt_ocrd_dt DATE;
5483: l_elig_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;
5484: l_rate_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;
5485: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;
5486: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;
5487: l_break VARCHAR2(30);
5488: l_ok BOOLEAN;
5489: l_rec ben_person_object.g_person_date_info_rec;
5490: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

Line 5654: ben_derive_part_and_rate_cache.get_comp_elig(p_pgm_id=> p_pgm_id

5650: NULL;
5651: --
5652: ELSE
5653: --
5654: ben_derive_part_and_rate_cache.get_comp_elig(p_pgm_id=> p_pgm_id
5655: ,p_pl_id => p_pl_id
5656: ,p_oipl_id => p_oipl_id
5657: ,p_plip_id => p_plip_id
5658: ,p_ptip_id => p_ptip_id

Line 5795: ben_derive_part_and_rate_cache.get_comp_elig(p_pgm_id=> p_pgm_id

5791: ben_whatif_elig.g_stat_comp IS NULL
5792: AND ben_whatif_elig.g_bnft_bal_comp IS NULL
5793: AND ben_whatif_elig.g_bal_comp IS NULL) THEN
5794: --
5795: ben_derive_part_and_rate_cache.get_comp_elig(p_pgm_id=> p_pgm_id
5796: ,p_pl_id => p_pl_id
5797: ,p_oipl_id => p_oipl_id
5798: ,p_plip_id => p_plip_id
5799: ,p_ptip_id => p_ptip_id

Line 6082: hr_utility.set_location('ben_derive_part_and_rate_cache '||p_oipl_id , 20);

6078: --
6079: ELSE
6080: --
6081: if g_debug then
6082: hr_utility.set_location('ben_derive_part_and_rate_cache '||p_oipl_id , 20);
6083: end if;
6084: --
6085: ben_derive_part_and_rate_cache.get_comp_rate(p_pgm_id=> p_pgm_id
6086: ,p_pl_id => p_pl_id

Line 6085: ben_derive_part_and_rate_cache.get_comp_rate(p_pgm_id=> p_pgm_id

6081: if g_debug then
6082: hr_utility.set_location('ben_derive_part_and_rate_cache '||p_oipl_id , 20);
6083: end if;
6084: --
6085: ben_derive_part_and_rate_cache.get_comp_rate(p_pgm_id=> p_pgm_id
6086: ,p_pl_id => p_pl_id
6087: ,p_oipl_id => p_oipl_id
6088: ,p_plip_id => p_plip_id
6089: ,p_ptip_id => p_ptip_id

Line 6225: ben_derive_part_and_rate_cache.get_comp_rate(p_pgm_id=> p_pgm_id

6221: --
6222: IF l_rate_result is not null THEN
6223: --
6224: --
6225: ben_derive_part_and_rate_cache.get_comp_rate(p_pgm_id=> p_pgm_id
6226: ,p_pl_id => p_pl_id
6227: ,p_oipl_id => p_oipl_id
6228: ,p_plip_id => p_plip_id
6229: ,p_ptip_id => p_ptip_id

Line 6795: l_elig_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;

6791: l_rt_los NUMBER;
6792: l_rt_los_uom VARCHAR2(30);
6793: l_ok BOOLEAN := TRUE;
6794: l_break VARCHAR2(30);
6795: l_elig_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6796: l_rate_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6797: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6798: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6799: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

Line 6796: l_rate_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;

6792: l_rt_los_uom VARCHAR2(30);
6793: l_ok BOOLEAN := TRUE;
6794: l_break VARCHAR2(30);
6795: l_elig_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6796: l_rate_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6797: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6798: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6799: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
6800: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;

Line 6797: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;

6793: l_ok BOOLEAN := TRUE;
6794: l_break VARCHAR2(30);
6795: l_elig_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6796: l_rate_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6797: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6798: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6799: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
6800: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
6801: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;

Line 6798: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;

6794: l_break VARCHAR2(30);
6795: l_elig_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6796: l_rate_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6797: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6798: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;
6799: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
6800: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
6801: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
6802: l_rate BOOLEAN := FALSE;

Line 6833: ben_derive_part_and_rate_cache.get_comb_elig(p_pgm_id=> p_pgm_id

6829: NULL;
6830: --
6831: ELSE
6832: --
6833: ben_derive_part_and_rate_cache.get_comb_elig(p_pgm_id=> p_pgm_id
6834: ,p_pl_id => p_pl_id
6835: ,p_oipl_id => p_oipl_id
6836: ,p_plip_id => p_plip_id
6837: ,p_ptip_id => p_ptip_id

Line 6917: ben_derive_part_and_rate_cache.get_comb_elig(p_pgm_id=> p_pgm_id

6913: null;
6914: --
6915: else
6916: --
6917: ben_derive_part_and_rate_cache.get_comb_elig(p_pgm_id=> p_pgm_id
6918: ,p_pl_id => p_pl_id
6919: ,p_oipl_id => p_oipl_id
6920: ,p_plip_id => p_plip_id
6921: ,p_ptip_id => p_ptip_id

Line 7001: ben_derive_part_and_rate_cache.get_comb_rate(p_pgm_id=> p_pgm_id

6997: --
6998: ELSE
6999: -- Rate calculation
7000: --
7001: ben_derive_part_and_rate_cache.get_comb_rate(p_pgm_id=> p_pgm_id
7002: ,p_pl_id => p_pl_id
7003: ,p_oipl_id => p_oipl_id
7004: ,p_plip_id => p_plip_id
7005: ,p_ptip_id => p_ptip_id

Line 7070: ben_derive_part_and_rate_cache.get_comb_rate(p_pgm_id=> p_pgm_id

7066: --
7067: -- p_comp_rec.rt_cmbn_age_n_los_val := l_rate_result;
7068: --
7069: --
7070: ben_derive_part_and_rate_cache.get_comb_rate(p_pgm_id=> p_pgm_id
7071: ,p_pl_id => p_pl_id
7072: ,p_oipl_id => p_oipl_id
7073: ,p_plip_id => p_plip_id
7074: ,p_ptip_id => p_ptip_id

Line 7459: --,p_rate_rec IN OUT ben_derive_part_and_rate_cache.g_cache_clf_rec_obj

7455: PROCEDURE percent_fulltime_min_max
7456: (p_calculate_only_mode in boolean default false
7457: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
7458: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
7459: --,p_rate_rec IN OUT ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
7460: ,p_comp_rec IN OUT NOCOPY g_cache_structure
7461: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
7462: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
7463: ,p_person_id IN NUMBER

Line 7623: l_elig_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;

7619: l_rate_cvg_result NUMBER;
7620: l_rate_prem_result NUMBER;
7621: l_break VARCHAR2(30);
7622: l_lf_evt_ocrd_dt DATE;
7623: l_elig_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7624: l_rate_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7625: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7626: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7627: l_rec ben_person_object.g_person_fte_info_rec;

Line 7624: l_rate_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;

7620: l_rate_prem_result NUMBER;
7621: l_break VARCHAR2(30);
7622: l_lf_evt_ocrd_dt DATE;
7623: l_elig_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7624: l_rate_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7625: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7626: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7627: l_rec ben_person_object.g_person_fte_info_rec;
7628: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

Line 7625: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;

7621: l_break VARCHAR2(30);
7622: l_lf_evt_ocrd_dt DATE;
7623: l_elig_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7624: l_rate_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7625: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7626: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7627: l_rec ben_person_object.g_person_fte_info_rec;
7628: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
7629: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;

Line 7626: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;

7622: l_lf_evt_ocrd_dt DATE;
7623: l_elig_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7624: l_rate_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7625: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7626: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;
7627: l_rec ben_person_object.g_person_fte_info_rec;
7628: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
7629: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
7630: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;

Line 7664: ben_derive_part_and_rate_cache.get_pct_elig(p_pgm_id=> p_pgm_id

7660: NULL;
7661: --
7662: ELSE
7663: --
7664: ben_derive_part_and_rate_cache.get_pct_elig(p_pgm_id=> p_pgm_id
7665: ,p_pl_id => p_pl_id
7666: ,p_oipl_id => p_oipl_id
7667: ,p_plip_id => p_plip_id
7668: ,p_ptip_id => p_ptip_id

Line 7733: ben_derive_part_and_rate_cache.get_pct_elig(p_pgm_id=> p_pgm_id

7729: null;
7730: --
7731: else
7732: --
7733: ben_derive_part_and_rate_cache.get_pct_elig(p_pgm_id=> p_pgm_id
7734: ,p_pl_id => p_pl_id
7735: ,p_oipl_id => p_oipl_id
7736: ,p_plip_id => p_plip_id
7737: ,p_ptip_id => p_ptip_id

Line 7830: ben_derive_part_and_rate_cache.get_pct_rate(p_pgm_id=> p_pgm_id

7826: NULL;
7827: --
7828: ELSE
7829: --
7830: ben_derive_part_and_rate_cache.get_pct_rate(p_pgm_id=> p_pgm_id
7831: ,p_pl_id => p_pl_id
7832: ,p_oipl_id => p_oipl_id
7833: ,p_plip_id => p_plip_id
7834: ,p_ptip_id => p_ptip_id

Line 7886: ben_derive_part_and_rate_cache.get_pct_rate(p_pgm_id=> p_pgm_id

7882: END IF;
7883: --
7884: IF l_rate_result is not null THEN
7885: --
7886: ben_derive_part_and_rate_cache.get_pct_rate(p_pgm_id=> p_pgm_id
7887: ,p_pl_id => p_pl_id
7888: ,p_oipl_id => p_oipl_id
7889: ,p_plip_id => p_plip_id
7890: ,p_ptip_id => p_ptip_id

Line 8186: --,p_rate_rec IN OUT ben_derive_part_and_rate_cache.g_cache_clf_rec_obj

8182: PROCEDURE hours_worked_min_max
8183: (p_calculate_only_mode in boolean default false
8184: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
8185: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
8186: --,p_rate_rec IN OUT ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
8187: ,p_comp_rec IN OUT NOCOPY g_cache_structure
8188: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
8189: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
8190: ,p_person_id IN NUMBER

Line 8429: l_elig_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;

8425: l_new_lf_evt_ocrd_dt DATE;
8426: l_start_date DATE;
8427: l_subtract_date DATE;
8428: l_ok BOOLEAN;
8429: l_elig_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8430: l_rate_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8431: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8432: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8433: l_rec ben_person_object.g_person_date_info_rec;

Line 8430: l_rate_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;

8426: l_start_date DATE;
8427: l_subtract_date DATE;
8428: l_ok BOOLEAN;
8429: l_elig_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8430: l_rate_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8431: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8432: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8433: l_rec ben_person_object.g_person_date_info_rec;
8434: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;

Line 8431: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;

8427: l_subtract_date DATE;
8428: l_ok BOOLEAN;
8429: l_elig_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8430: l_rate_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8431: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8432: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8433: l_rec ben_person_object.g_person_date_info_rec;
8434: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
8435: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;

Line 8432: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;

8428: l_ok BOOLEAN;
8429: l_elig_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8430: l_rate_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8431: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8432: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;
8433: l_rec ben_person_object.g_person_date_info_rec;
8434: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
8435: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
8436: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;

Line 8471: ben_derive_part_and_rate_cache.get_hours_elig(p_pgm_id=> p_pgm_id

8467: NULL;
8468: --
8469: ELSE
8470: --
8471: ben_derive_part_and_rate_cache.get_hours_elig(p_pgm_id=> p_pgm_id
8472: ,p_pl_id => p_pl_id
8473: ,p_oipl_id => p_oipl_id
8474: ,p_plip_id => p_plip_id
8475: ,p_ptip_id => p_ptip_id

Line 8609: ben_derive_part_and_rate_cache.get_hours_elig(p_pgm_id=> p_pgm_id

8605: AND (
8606: ben_whatif_elig.g_bal_hwf_val IS NULL
8607: AND ben_whatif_elig.g_bnft_bal_hwf_val IS NULL) THEN
8608: --
8609: ben_derive_part_and_rate_cache.get_hours_elig(p_pgm_id=> p_pgm_id
8610: ,p_pl_id => p_pl_id
8611: ,p_oipl_id => p_oipl_id
8612: ,p_plip_id => p_plip_id
8613: ,p_ptip_id => p_ptip_id

Line 8818: hr_utility.set_location('ben_derive_part_and_rate_cache '||p_oipl_id , 20);

8814: --
8815: ELSE
8816: --
8817: if g_debug then
8818: hr_utility.set_location('ben_derive_part_and_rate_cache '||p_oipl_id , 20);
8819: end if;
8820: --
8821: ben_derive_part_and_rate_cache.get_hours_rate(p_pgm_id=> p_pgm_id
8822: ,p_pl_id => p_pl_id

Line 8821: ben_derive_part_and_rate_cache.get_hours_rate(p_pgm_id=> p_pgm_id

8817: if g_debug then
8818: hr_utility.set_location('ben_derive_part_and_rate_cache '||p_oipl_id , 20);
8819: end if;
8820: --
8821: ben_derive_part_and_rate_cache.get_hours_rate(p_pgm_id=> p_pgm_id
8822: ,p_pl_id => p_pl_id
8823: ,p_oipl_id => p_oipl_id
8824: ,p_plip_id => p_plip_id
8825: ,p_ptip_id => p_ptip_id

Line 8944: ben_derive_part_and_rate_cache.get_hours_rate(p_pgm_id=> p_pgm_id

8940: if g_debug then
8941: hr_utility.set_location(' l_rate_result found '||l_rate_result , 40);
8942: end if;
8943: --
8944: ben_derive_part_and_rate_cache.get_hours_rate(p_pgm_id=> p_pgm_id
8945: ,p_pl_id => p_pl_id
8946: ,p_oipl_id => p_oipl_id
8947: ,p_plip_id => p_plip_id
8948: ,p_ptip_id => p_ptip_id