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_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_MANAGE_LIFE_EVENTS

Line 30: ben_manage_life_events.

26: information.
27: 05 Jan 98 G Perry 110.3 Changed references of
28: ben_derive_part_rate_and_facts.
29: g_record_error to
30: ben_manage_life_events.
31: g_record_error.
32: 06 Jan 98 G Perry 110.4 No changes, someone arcsed this
33: in as gperry, probably udatta.
34: 13 Jan 98 G Perry 110.5 Commented out nocopy certain sections

Line 879: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)

875: --RCHASE Bug#Fix - pass PERSON_ID
876: ,p_param1 => 'PERSON_ID'
877: ,p_param1_value => to_char(nvl(p_person_id,-1))
878: ,p_param2 => 'BEN_IV_RT_STRT_DT'
879: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)
880: ,p_param3 => 'BEN_IV_CVG_STRT_DT'
881: ,p_param3_value => fnd_date.date_to_canonical(g_fonm_cvg_strt_dt)
882: );
883: --

Line 951: p_comp_obj_tree_row IN OUT NOCOPY ben_manage_life_events.g_cache_proc_objects_rec

947: -- This procedure has to be called first in order to initialise the data
948: -- structures that the code requires.
949: --
950: PROCEDURE cache_data_structures(
951: p_comp_obj_tree_row IN OUT NOCOPY ben_manage_life_events.g_cache_proc_objects_rec
952: ,p_empasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
953: ,p_benasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
954: ,p_pil_row IN OUT NOCOPY ben_per_in_ler%ROWTYPE
955: ,p_business_group_id IN NUMBER

Line 2023: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

2019: END no_life_event;
2020: --
2021: PROCEDURE min_max_breach
2022: (p_calculate_only_mode in boolean default false
2023: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
2024: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
2025: ,p_person_id IN NUMBER
2026: ,p_pgm_id IN NUMBER
2027: ,p_pl_id IN NUMBER

Line 2296: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

2292: --
2293: END min_max_breach;
2294: --
2295: FUNCTION los_calculation(
2296: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
2297: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
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

Line 2533: RAISE ben_manage_life_events.g_record_error;

2529: fnd_message.set_token('PROC'
2530: ,l_package);
2531: fnd_message.set_token('CODE1'
2532: ,p_rec.los_dt_to_use_cd);
2533: RAISE ben_manage_life_events.g_record_error;
2534: --
2535: END IF;
2536: --
2537: -- Account for case where person is not an employee thus has

Line 2582: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

2578: --
2579: END los_calculation;
2580: --
2581: FUNCTION age_calculation(
2582: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
2583: ,p_per_row IN per_all_people_f%ROWTYPE
2584: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
2585: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
2586: ,p_pil_row IN ben_per_in_ler%ROWTYPE

Line 3031: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

3027: --
3028: END age_calculation;
3029: --
3030: FUNCTION hours_calculation(
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

Line 3367: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

3363: -- to determine the compensation to avoid maitening the similar code at two
3364: -- different places.
3365: -------------------------------------------------------------------------------
3366: FUNCTION comp_calculation(
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

Line 3421: if ben_manage_life_events.fonm = 'Y'

3417: -- 1) Work out the start date
3418: -- 2) Perform Rounding
3419: --
3420: --FONM2
3421: if ben_manage_life_events.fonm = 'Y'
3422: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
3423: --
3424: g_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
3425: --

Line 3422: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

3418: -- 2) Perform Rounding
3419: --
3420: --FONM2
3421: if ben_manage_life_events.fonm = 'Y'
3422: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
3423: --
3424: g_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
3425: --
3426: else

Line 3424: g_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

3420: --FONM2
3421: if ben_manage_life_events.fonm = 'Y'
3422: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
3423: --
3424: g_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
3425: --
3426: else
3427: g_fonm_cvg_strt_dt := null ;
3428: end if;

Line 3768: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

3764: END comp_calculation;
3765: --
3766: PROCEDURE calculate_los
3767: (p_calculate_only_mode in boolean default false
3768: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
3769: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
3770: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
3771: ,p_pil_row IN ben_per_in_ler%ROWTYPE
3772: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

Line 3834: ,ben_manage_life_events.g_los_flag) <> 0

3830: -- 4) Test for min/max breach
3831: -- 5) If a breach did occur then create a ptnl_ler_for_per.
3832: --
3833: IF bitand(p_comp_obj_tree_row.flag_bit_val
3834: ,ben_manage_life_events.g_los_flag) <> 0
3835: OR p_los_fctr_id IS NOT NULL
3836: AND bitand(p_comp_obj_tree_row.flag_bit_val
3837: ,ben_manage_life_events.g_cal_flag) <> 0 THEN
3838: --

Line 3837: ,ben_manage_life_events.g_cal_flag) <> 0 THEN

3833: IF bitand(p_comp_obj_tree_row.flag_bit_val
3834: ,ben_manage_life_events.g_los_flag) <> 0
3835: OR p_los_fctr_id IS NOT NULL
3836: AND bitand(p_comp_obj_tree_row.flag_bit_val
3837: ,ben_manage_life_events.g_cal_flag) <> 0 THEN
3838: --
3839: -- hr_utility.set_location('LOS for ELIG',10);
3840: IF p_comp_rec.frz_los_flag = 'Y' THEN
3841: --

Line 4026: ,ben_manage_life_events.g_los_rt_flag) <> 0

4022: --
4023: END IF;
4024: --
4025: IF bitand(p_comp_obj_tree_row.flag_bit_val
4026: ,ben_manage_life_events.g_los_rt_flag) <> 0
4027: OR p_los_fctr_id IS NOT NULL
4028: AND bitand(p_comp_obj_tree_row.flag_bit_val
4029: ,ben_manage_life_events.g_cal_rt_flag) <> 0
4030: OR p_oiplip_id IS NOT NULL

Line 4029: ,ben_manage_life_events.g_cal_rt_flag) <> 0

4025: IF bitand(p_comp_obj_tree_row.flag_bit_val
4026: ,ben_manage_life_events.g_los_rt_flag) <> 0
4027: OR p_los_fctr_id IS NOT NULL
4028: AND bitand(p_comp_obj_tree_row.flag_bit_val
4029: ,ben_manage_life_events.g_cal_rt_flag) <> 0
4030: OR p_oiplip_id IS NOT NULL
4031: AND bitand(p_comp_obj_tree_row.oiplip_flag_bit_val
4032: ,ben_manage_life_events.g_los_rt_flag) <> 0 THEN
4033: --

Line 4032: ,ben_manage_life_events.g_los_rt_flag) <> 0 THEN

4028: AND bitand(p_comp_obj_tree_row.flag_bit_val
4029: ,ben_manage_life_events.g_cal_rt_flag) <> 0
4030: OR p_oiplip_id IS NOT NULL
4031: AND bitand(p_comp_obj_tree_row.oiplip_flag_bit_val
4032: ,ben_manage_life_events.g_los_rt_flag) <> 0 THEN
4033: --
4034: -- hr_utility.set_location('LOS for RT',10);
4035: IF p_comp_rec.rt_frz_los_flag = 'Y' THEN
4036: --

Line 4495: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

4491: -- Calculate AGE
4492: --
4493: PROCEDURE calculate_age
4494: (p_calculate_only_mode in boolean default false
4495: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
4496: ,p_per_row IN per_all_people_f%ROWTYPE
4497: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
4498: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
4499: ,p_pil_row IN ben_per_in_ler%ROWTYPE

Line 4577: ,ben_manage_life_events.g_age_flag) <> 0

4573: -- 5) Test for min/max breach
4574: -- 6) If a breach did occur then create a ptl_ler_for_per.
4575: --
4576: IF bitand(p_comp_obj_tree_row.flag_bit_val
4577: ,ben_manage_life_events.g_age_flag) <> 0
4578: OR p_age_fctr_id IS NOT NULL
4579: AND bitand(p_comp_obj_tree_row.flag_bit_val
4580: ,ben_manage_life_events.g_cal_flag) <> 0 THEN
4581: --

Line 4580: ,ben_manage_life_events.g_cal_flag) <> 0 THEN

4576: IF bitand(p_comp_obj_tree_row.flag_bit_val
4577: ,ben_manage_life_events.g_age_flag) <> 0
4578: OR p_age_fctr_id IS NOT NULL
4579: AND bitand(p_comp_obj_tree_row.flag_bit_val
4580: ,ben_manage_life_events.g_cal_flag) <> 0 THEN
4581: --
4582: --hr_utility.set_location('AGE for ELIG',10);
4583: IF p_comp_rec.frz_age_flag = 'Y' THEN
4584: --

Line 4732: ,ben_manage_life_events.g_age_rt_flag) <> 0

4728: hr_utility.set_location('age_val ' || p_comp_rec.age_val,10);
4729: --
4730: --
4731: IF bitand(p_comp_obj_tree_row.flag_bit_val
4732: ,ben_manage_life_events.g_age_rt_flag) <> 0
4733: OR p_age_fctr_id IS NOT NULL
4734: AND bitand(p_comp_obj_tree_row.flag_bit_val
4735: ,ben_manage_life_events.g_cal_rt_flag) <> 0
4736: OR p_oiplip_id IS NOT NULL

Line 4735: ,ben_manage_life_events.g_cal_rt_flag) <> 0

4731: IF bitand(p_comp_obj_tree_row.flag_bit_val
4732: ,ben_manage_life_events.g_age_rt_flag) <> 0
4733: OR p_age_fctr_id IS NOT NULL
4734: AND bitand(p_comp_obj_tree_row.flag_bit_val
4735: ,ben_manage_life_events.g_cal_rt_flag) <> 0
4736: OR p_oiplip_id IS NOT NULL
4737: AND bitand(p_comp_obj_tree_row.oiplip_flag_bit_val
4738: ,ben_manage_life_events.g_age_rt_flag) <> 0 THEN
4739: --

Line 4738: ,ben_manage_life_events.g_age_rt_flag) <> 0 THEN

4734: AND bitand(p_comp_obj_tree_row.flag_bit_val
4735: ,ben_manage_life_events.g_cal_rt_flag) <> 0
4736: OR p_oiplip_id IS NOT NULL
4737: AND bitand(p_comp_obj_tree_row.oiplip_flag_bit_val
4738: ,ben_manage_life_events.g_age_rt_flag) <> 0 THEN
4739: --
4740: --hr_utility.set_location('AGE for RT',10);
4741: IF p_comp_rec.rt_frz_age_flag = 'Y' THEN
4742: --

Line 5110: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

5106: --
5107: --
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

Line 5452: ,p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec

5448: -- Calculate compensation level
5449: --
5450: PROCEDURE calculate_compensation_level
5451: (p_calculate_only_mode in boolean default false
5452: ,p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec
5453: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
5454: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
5455: ,p_pil_row IN ben_per_in_ler%ROWTYPE
5456: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

Line 5503: procedure get_comp_objects(p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec,

5499: l_pgm_id number(15) := p_pgm_id;
5500: l_pl_id number(15) := p_pl_id;
5501: l_oipl_id number(15) := p_oipl_id;
5502: --
5503: procedure get_comp_objects(p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec,
5504: p_ptip_id IN number,
5505: p_plip_id IN number,
5506: p_oiplip_id IN number,
5507: p_effective_date IN date,

Line 5642: ,ben_manage_life_events.g_cmp_flag) <> 0 THEN

5638: -- 5) Test for min/max breach
5639: -- 6) If a breach did occur then create a ptl_ler_for_per.
5640: --
5641: IF bitand(p_comp_obj_tree_row.flag_bit_val
5642: ,ben_manage_life_events.g_cmp_flag) <> 0 THEN
5643: --
5644: -- hr_utility.set_location('COMP for ELIG',10);
5645: IF p_comp_rec.frz_cmp_lvl_flag = 'Y' THEN
5646: --

Line 6064: ,ben_manage_life_events.g_cmp_rt_flag) <> 0

6060: if g_debug then
6061: hr_utility.set_location(' Before entering into Rate Factors ', 15);
6062: end if;
6063: IF bitand(p_comp_obj_tree_row.flag_bit_val
6064: ,ben_manage_life_events.g_cmp_rt_flag) <> 0
6065: OR p_oiplip_id IS NOT NULL
6066: AND bitand(p_comp_obj_tree_row.oiplip_flag_bit_val
6067: ,ben_manage_life_events.g_cmp_rt_flag) <> 0 THEN
6068: --

Line 6067: ,ben_manage_life_events.g_cmp_rt_flag) <> 0 THEN

6063: IF bitand(p_comp_obj_tree_row.flag_bit_val
6064: ,ben_manage_life_events.g_cmp_rt_flag) <> 0
6065: OR p_oiplip_id IS NOT NULL
6066: AND bitand(p_comp_obj_tree_row.oiplip_flag_bit_val
6067: ,ben_manage_life_events.g_cmp_rt_flag) <> 0 THEN
6068: --
6069: if g_debug then
6070: hr_utility.set_location('COMP for RT',10);
6071: end if;

Line 6756: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

6752: --
6753: --
6754: PROCEDURE calculate_comb_age_and_los
6755: (p_calculate_only_mode in boolean default false
6756: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
6757: ,p_per_row IN per_all_people_f%ROWTYPE
6758: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
6759: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
6760: ,p_pil_row IN ben_per_in_ler%ROWTYPE

Line 6821: ,ben_manage_life_events.g_cal_flag) <> 0 THEN

6817: -- 4) Test for min/max breach
6818: -- 5) If a breach did occur then create a ptl_ler_for_per.
6819: --
6820: IF bitand(p_comp_obj_tree_row.flag_bit_val
6821: ,ben_manage_life_events.g_cal_flag) <> 0 THEN
6822: --
6823: -- hr_utility.set_location('CAL for ELIG',10);
6824: IF p_comp_rec.frz_comb_age_and_los_flag = 'Y' THEN
6825: --

Line 6985: ,ben_manage_life_events.g_cal_rt_flag) <> 0

6981: --
6982: -- hr_utility.set_location('p_comp_rec ' || p_comp_rec.cmbn_age_n_los_val,10);
6983: --
6984: IF bitand(p_comp_obj_tree_row.flag_bit_val
6985: ,ben_manage_life_events.g_cal_rt_flag) <> 0
6986: OR p_oiplip_id IS NOT NULL
6987: AND bitand(p_comp_obj_tree_row.oiplip_flag_bit_val
6988: ,ben_manage_life_events.g_cal_rt_flag) <> 0 THEN
6989: --

Line 6988: ,ben_manage_life_events.g_cal_rt_flag) <> 0 THEN

6984: IF bitand(p_comp_obj_tree_row.flag_bit_val
6985: ,ben_manage_life_events.g_cal_rt_flag) <> 0
6986: OR p_oiplip_id IS NOT NULL
6987: AND bitand(p_comp_obj_tree_row.oiplip_flag_bit_val
6988: ,ben_manage_life_events.g_cal_rt_flag) <> 0 THEN
6989: --
6990: -- hr_utility.set_location('CAL for RT',10);
6991: IF p_comp_rec.rt_frz_comb_age_and_los_flag = 'Y' THEN
6992: --

Line 7456: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

7452: END calculate_comb_age_and_los;
7453: --
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

Line 7593: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

7589: END percent_fulltime_min_max ;
7590:
7591: PROCEDURE calculate_percent_fulltime
7592: (p_calculate_only_mode in boolean default false
7593: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
7594: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
7595: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
7596: ,p_pil_row IN ben_per_in_ler%ROWTYPE
7597: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

Line 7652: ,ben_manage_life_events.g_pft_flag) <> 0 THEN

7648: -- 5) Test for min/max breach
7649: -- 6) If a breach did occur then create a ptl_ler_for_per.
7650: --
7651: IF bitand(p_comp_obj_tree_row.flag_bit_val
7652: ,ben_manage_life_events.g_pft_flag) <> 0 THEN
7653: --
7654: -- hr_utility.set_location('PFT for ELIG',10);
7655: IF p_comp_rec.frz_pct_fl_tm_flag = 'Y' THEN
7656: --

Line 7815: ,ben_manage_life_events.g_pft_rt_flag) <> 0

7811: --
7812: END IF;
7813: --
7814: IF bitand(p_comp_obj_tree_row.flag_bit_val
7815: ,ben_manage_life_events.g_pft_rt_flag) <> 0
7816: OR p_oiplip_id IS NOT NULL
7817: AND bitand(p_comp_obj_tree_row.oiplip_flag_bit_val
7818: ,ben_manage_life_events.g_pft_rt_flag) <> 0 THEN
7819: --

Line 7818: ,ben_manage_life_events.g_pft_rt_flag) <> 0 THEN

7814: IF bitand(p_comp_obj_tree_row.flag_bit_val
7815: ,ben_manage_life_events.g_pft_rt_flag) <> 0
7816: OR p_oiplip_id IS NOT NULL
7817: AND bitand(p_comp_obj_tree_row.oiplip_flag_bit_val
7818: ,ben_manage_life_events.g_pft_rt_flag) <> 0 THEN
7819: --
7820: -- hr_utility.set_location('PFT for RT',10);
7821: IF p_comp_rec.rt_frz_pct_fl_tm_flag = 'Y' THEN
7822: --

Line 8183: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

8179: END calculate_percent_fulltime;
8180: --
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

Line 8395: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

8391: END hours_worked_min_max ;
8392: --
8393: PROCEDURE calculate_hours_worked
8394: (p_calculate_only_mode in boolean default false
8395: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
8396: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
8397: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
8398: ,p_pil_row IN ben_per_in_ler%ROWTYPE
8399: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

Line 8459: ,ben_manage_life_events.g_hrw_flag) <> 0 THEN

8455: -- 4) Test for min/max breach
8456: -- 5) If a breach did occur then create a ptl_ler_for_per.
8457: --
8458: IF bitand(p_comp_obj_tree_row.flag_bit_val
8459: ,ben_manage_life_events.g_hrw_flag) <> 0 THEN
8460: --
8461: -- hr_utility.set_location('HRW for ELIG',10);
8462: IF p_comp_rec.frz_hrs_wkd_flag = 'Y' THEN
8463: --

Line 8796: ,ben_manage_life_events.g_hrw_rt_flag) <> 0

8792: --
8793: -- hr_utility.set_location('RFHWF=Y ' || l_package,10);
8794: --9999
8795: IF bitand(p_comp_obj_tree_row.flag_bit_val
8796: ,ben_manage_life_events.g_hrw_rt_flag) <> 0
8797: OR p_oiplip_id IS NOT NULL
8798: AND bitand(p_comp_obj_tree_row.oiplip_flag_bit_val
8799: ,ben_manage_life_events.g_hrw_rt_flag) <> 0 THEN
8800: --

Line 8799: ,ben_manage_life_events.g_hrw_rt_flag) <> 0 THEN

8795: IF bitand(p_comp_obj_tree_row.flag_bit_val
8796: ,ben_manage_life_events.g_hrw_rt_flag) <> 0
8797: OR p_oiplip_id IS NOT NULL
8798: AND bitand(p_comp_obj_tree_row.oiplip_flag_bit_val
8799: ,ben_manage_life_events.g_hrw_rt_flag) <> 0 THEN
8800: --
8801: if g_debug then
8802: hr_utility.set_location('HRW for RT',10);
8803: end if;

Line 10712: ,p_comp_obj_tree_row IN OUT NOCOPY ben_manage_life_events.g_cache_proc_objects_rec

10708: END determine_cobra_eligibility;
10709: --
10710: PROCEDURE derive_rates_and_factors
10711: (p_calculate_only_mode in boolean default false
10712: ,p_comp_obj_tree_row IN OUT NOCOPY ben_manage_life_events.g_cache_proc_objects_rec
10713: --
10714: -- Context info
10715: --
10716: ,p_per_row IN OUT NOCOPY per_all_people_f%ROWTYPE

Line 10781: if ben_manage_life_events.fonm = 'Y'

10777: --only for testing purpose we are using the global
10778: --variable and needs to be removed.
10779: --
10780: g_fonm_cvg_strt_dt := null ;
10781: if ben_manage_life_events.fonm = 'Y'
10782: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
10783: --
10784: g_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
10785: --

Line 10782: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

10778: --variable and needs to be removed.
10779: --
10780: g_fonm_cvg_strt_dt := null ;
10781: if ben_manage_life_events.fonm = 'Y'
10782: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
10783: --
10784: g_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
10785: --
10786: end if;

Line 10784: g_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

10780: g_fonm_cvg_strt_dt := null ;
10781: if ben_manage_life_events.fonm = 'Y'
10782: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
10783: --
10784: g_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
10785: --
10786: end if;
10787: --
10788: --END FONM