APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_DERIVE_PART_AND_RATE_CACHE

Line 1337: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_clf_rec_obj

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

Line 2302: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_los_rec_obj

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

Line 2589: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_age_rec_obj

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

Line 3035: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj

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

Line 3371: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_clf_rec_obj

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

Line 3798: l_elig_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;

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

Line 3799: l_rate_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;

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

Line 3800: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;

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

Line 3801: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_los_rec_obj;

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

Line 3850: ben_derive_part_and_rate_cache.get_los_stated(p_los_fctr_id=> p_los_fctr_id

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

Line 3856: ben_derive_part_and_rate_cache.get_los_elig(p_pgm_id=> p_pgm_id

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

Line 3952: ben_derive_part_and_rate_cache.get_los_elig(p_pgm_id=> p_pgm_id

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

Line 4045: ben_derive_part_and_rate_cache.get_los_stated(p_los_fctr_id=> p_los_fctr_id

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

Line 4051: ben_derive_part_and_rate_cache.get_los_rate(p_pgm_id=> p_pgm_id

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

Line 4145: ben_derive_part_and_rate_cache.get_los_rate(p_pgm_id=> p_pgm_id

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

Line 4524: l_elig_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;

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

Line 4525: l_rate_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;

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

Line 4526: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;

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

Line 4527: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_age_rec_obj;

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

Line 4596: ben_derive_part_and_rate_cache.get_age_stated(p_age_fctr_id=> p_age_fctr_id

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

Line 4602: ben_derive_part_and_rate_cache.get_age_elig(p_pgm_id=> p_pgm_id

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

Line 4645: ben_derive_part_and_rate_cache.get_age_elig(p_pgm_id=> p_pgm_id

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

Line 4753: ben_derive_part_and_rate_cache.get_age_stated(p_age_fctr_id=> p_age_fctr_id

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

Line 4763: ben_derive_part_and_rate_cache.get_age_rate(p_pgm_id=> p_pgm_id

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

Line 4807: ben_derive_part_and_rate_cache.get_age_rate(

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

Line 5112: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_clf_rec_obj

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

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

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

Line 5482: l_elig_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;

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

Line 5483: l_rate_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;

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

Line 5484: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;

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

Line 5485: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_obj;

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

Line 5653: ben_derive_part_and_rate_cache.get_comp_elig(p_pgm_id=> p_pgm_id

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

Line 5794: ben_derive_part_and_rate_cache.get_comp_elig(p_pgm_id=> p_pgm_id

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

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

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

Line 6084: ben_derive_part_and_rate_cache.get_comp_rate(p_pgm_id=> p_pgm_id

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

Line 6224: ben_derive_part_and_rate_cache.get_comp_rate(p_pgm_id=> p_pgm_id

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

Line 6794: l_elig_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;

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

Line 6795: l_rate_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;

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

Line 6796: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;

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

Line 6797: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_obj;

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

Line 6832: ben_derive_part_and_rate_cache.get_comb_elig(p_pgm_id=> p_pgm_id

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

Line 6916: ben_derive_part_and_rate_cache.get_comb_elig(p_pgm_id=> p_pgm_id

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

Line 7000: ben_derive_part_and_rate_cache.get_comb_rate(p_pgm_id=> p_pgm_id

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

Line 7069: ben_derive_part_and_rate_cache.get_comb_rate(p_pgm_id=> p_pgm_id

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

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

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

Line 7622: l_elig_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;

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

Line 7623: l_rate_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;

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

Line 7624: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;

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

Line 7625: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_obj;

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

Line 7663: ben_derive_part_and_rate_cache.get_pct_elig(p_pgm_id=> p_pgm_id

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

Line 7732: ben_derive_part_and_rate_cache.get_pct_elig(p_pgm_id=> p_pgm_id

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

Line 7829: ben_derive_part_and_rate_cache.get_pct_rate(p_pgm_id=> p_pgm_id

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

Line 7885: ben_derive_part_and_rate_cache.get_pct_rate(p_pgm_id=> p_pgm_id

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

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

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

Line 8428: l_elig_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;

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

Line 8429: l_rate_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;

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

Line 8430: l_rate_cvg_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;

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

Line 8431: l_rate_prem_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj;

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

Line 8470: ben_derive_part_and_rate_cache.get_hours_elig(p_pgm_id=> p_pgm_id

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

Line 8608: ben_derive_part_and_rate_cache.get_hours_elig(p_pgm_id=> p_pgm_id

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

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

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

Line 8820: ben_derive_part_and_rate_cache.get_hours_rate(p_pgm_id=> p_pgm_id

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

Line 8943: ben_derive_part_and_rate_cache.get_hours_rate(p_pgm_id=> p_pgm_id

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