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 880: ,p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt)

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

Line 952: p_comp_obj_tree_row IN OUT NOCOPY ben_manage_life_events.g_cache_proc_objects_rec

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

Line 2024: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

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

Line 2297: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

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

Line 2534: RAISE ben_manage_life_events.g_record_error;

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

Line 2583: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

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

Line 3032: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

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

Line 3368: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

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

Line 3422: if ben_manage_life_events.fonm = 'Y'

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

Line 3423: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

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

Line 3425: g_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

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

Line 3769: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

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

Line 3835: ,ben_manage_life_events.g_los_flag) <> 0

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

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

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

Line 4027: ,ben_manage_life_events.g_los_rt_flag) <> 0

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

Line 4030: ,ben_manage_life_events.g_cal_rt_flag) <> 0

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

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

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

Line 4496: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

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

Line 4578: ,ben_manage_life_events.g_age_flag) <> 0

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

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

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

Line 4733: ,ben_manage_life_events.g_age_rt_flag) <> 0

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

Line 4736: ,ben_manage_life_events.g_cal_rt_flag) <> 0

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

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

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

Line 5111: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

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

Line 5453: ,p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec

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

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

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

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

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

Line 6065: ,ben_manage_life_events.g_cmp_rt_flag) <> 0

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

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

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

Line 6757: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

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

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

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

Line 6986: ,ben_manage_life_events.g_cal_rt_flag) <> 0

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

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

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

Line 7457: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

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

Line 7594: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

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

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

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

Line 7816: ,ben_manage_life_events.g_pft_rt_flag) <> 0

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

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

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

Line 8184: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

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

Line 8396: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec

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

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

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

Line 8797: ,ben_manage_life_events.g_hrw_rt_flag) <> 0

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

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

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

Line 10785: ,p_comp_obj_tree_row IN OUT NOCOPY ben_manage_life_events.g_cache_proc_objects_rec

10781: END determine_cobra_eligibility;
10782: --
10783: PROCEDURE derive_rates_and_factors
10784: (p_calculate_only_mode in boolean default false
10785: ,p_comp_obj_tree_row IN OUT NOCOPY ben_manage_life_events.g_cache_proc_objects_rec
10786: --
10787: -- Context info
10788: --
10789: ,p_per_row IN OUT NOCOPY per_all_people_f%ROWTYPE

Line 10854: if ben_manage_life_events.fonm = 'Y'

10850: --only for testing purpose we are using the global
10851: --variable and needs to be removed.
10852: --
10853: g_fonm_cvg_strt_dt := null ;
10854: if ben_manage_life_events.fonm = 'Y'
10855: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
10856: --
10857: g_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
10858: --

Line 10855: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

10851: --variable and needs to be removed.
10852: --
10853: g_fonm_cvg_strt_dt := null ;
10854: if ben_manage_life_events.fonm = 'Y'
10855: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
10856: --
10857: g_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
10858: --
10859: end if;

Line 10857: g_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

10853: g_fonm_cvg_strt_dt := null ;
10854: if ben_manage_life_events.fonm = 'Y'
10855: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
10856: --
10857: g_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
10858: --
10859: end if;
10860: --
10861: --END FONM