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_DETERMINE_ELIGIBILITY2 dependencies on BEN_DETERMINE_ELIGIBILITY3

Line 356: to ben_determine_eligibility3.

352: added to still_ineligible condition
353: 27-Jan-06 mhoyes 115.116 Bug#4968123 - hr_utility debug and locally
354: defined plsql tuning.
355: 30-Jan-06 mhoyes 115.117 Bug#4968123 - moved out locall defined procs
356: to ben_determine_eligibility3.
357: 30-Jan-06 mhoyes 115.118 Bug#4968123 - moved out cursors
358: to ben_determine_eligibility4.
359: 28-Jun-06 swjain 115.119 Bug 5331889 Added person_id param in call to
360: benutils.formula in procedure get_start_end_dates

Line 2015: ben_determine_eligibility3.save_to_restore

2011:
2012: IF l_datetrack_mode = hr_api.g_correction AND
2013: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
2014: --
2015: ben_determine_eligibility3.save_to_restore
2016: (p_current_per_in_ler_id => l_per_in_ler_id
2017: ,p_per_in_ler_id => l_prev_per_in_ler_id
2018: ,p_elig_per_id => NULL
2019: ,p_elig_per_opt_id => l_elig_per_opt_id

Line 2343: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg

2339: -- after the waiting period ends.
2340: if l_wait_perd_cmpltn_dt is not null and l_benmngle_parm_rec.mode_cd <> 'D' then
2341: -- Apply the participation start date code to the l_wait_perd_cmpltn_dt
2342: l_prtn_st_dt_aftr_wtg :=
2343: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg
2344: (p_person_id => p_person_id
2345: ,p_effective_date => p_effective_date
2346: ,p_business_group_id => p_business_group_id
2347: ,p_prtn_eff_strt_dt_cd => l_prtn_eff_strt_dt_cd

Line 2587: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg

2583: --
2584: -- Apply the participation start date code to the l_wait_perd_cmpltn_dt
2585: --
2586: l_prtn_st_dt_aftr_wtg :=
2587: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg
2588: (p_person_id => p_person_id,
2589: p_effective_date => p_effective_date,
2590: p_business_group_id => p_business_group_id,
2591: p_prtn_eff_strt_dt_cd => l_prtn_eff_strt_dt_cd,

Line 2617: ben_determine_eligibility3.save_to_restore

2613: hr_utility.set_location('SARKAR EPO l_per_in_ler_id' || l_per_in_ler_id, 10);
2614: IF l_datetrack_mode = hr_api.g_correction AND
2615: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) AND l_benmngle_parm_rec.mode_cd <> 'D' THEN
2616: --
2617: ben_determine_eligibility3.save_to_restore
2618: (p_current_per_in_ler_id => l_per_in_ler_id
2619: ,p_per_in_ler_id => l_prev_per_in_ler_id
2620: ,p_elig_per_id => NULL
2621: ,p_elig_per_opt_id => l_elig_per_opt_id

Line 2659: ben_determine_eligibility3.save_to_restore

2655:
2656: if(l_ftr_elig_per_opt_rec.elig_per_opt_id is not null) then
2657: hr_utility.set_location('uxx save to restore in if ',10);
2658:
2659: ben_determine_eligibility3.save_to_restore
2660: (p_current_per_in_ler_id => l_per_in_ler_id
2661: ,p_per_in_ler_id => l_prev_pil_id
2662: ,p_elig_per_id => NUll
2663: ,p_elig_per_opt_id => l_ftr_elig_per_opt_rec.elig_per_opt_id

Line 2668: ben_determine_eligibility3.save_to_restore

2664: ,p_effective_date => l_ftr_elig_per_opt_rec.effective_start_date
2665: );
2666: else
2667: hr_utility.set_location('uxx save to restore in else ',10);
2668: ben_determine_eligibility3.save_to_restore
2669: (p_current_per_in_ler_id => l_per_in_ler_id
2670: ,p_per_in_ler_id => l_prev_per_in_ler_id
2671: ,p_elig_per_id => NULL
2672: ,p_elig_per_opt_id => l_elig_per_opt_id

Line 2948: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg

2944: --
2945: -- Apply the participation start date code to the l_wait_perd_cmpltn_dt
2946: --
2947: l_prtn_st_dt_aftr_wtg :=
2948: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg
2949: (p_person_id => p_person_id,
2950: p_effective_date => p_effective_date,
2951: p_business_group_id => p_business_group_id,
2952: p_prtn_eff_strt_dt_cd => l_prtn_eff_strt_dt_cd,

Line 2978: ben_determine_eligibility3.save_to_restore

2974: --
2975: IF l_datetrack_mode = hr_api.g_correction AND
2976: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
2977: --
2978: ben_determine_eligibility3.save_to_restore
2979: (p_current_per_in_ler_id => l_per_in_ler_id
2980: ,p_per_in_ler_id => l_prev_per_in_ler_id
2981: ,p_elig_per_id => NULL
2982: ,p_elig_per_opt_id => l_elig_per_opt_id

Line 3021: ben_determine_eligibility3.save_to_restore

3017:
3018: if(l_ftr_elig_per_opt_rec.elig_per_opt_id is not null) then
3019: hr_utility.set_location('uxx save to restore in if ',10);
3020:
3021: ben_determine_eligibility3.save_to_restore
3022: (p_current_per_in_ler_id => l_per_in_ler_id
3023: ,p_per_in_ler_id => l_prev_pil_id
3024: ,p_elig_per_id => NUll
3025: ,p_elig_per_opt_id => l_ftr_elig_per_opt_rec.elig_per_opt_id

Line 3030: ben_determine_eligibility3.save_to_restore

3026: ,p_effective_date => l_ftr_elig_per_opt_rec.effective_start_date
3027: );
3028: /* else
3029: hr_utility.set_location('uxx save to restore in else ',10);
3030: ben_determine_eligibility3.save_to_restore
3031: (p_current_per_in_ler_id => l_per_in_ler_id
3032: ,p_per_in_ler_id => l_prev_per_in_ler_id
3033: ,p_elig_per_id => NULL
3034: ,p_elig_per_opt_id => l_elig_per_opt_id

Line 3282: ben_determine_eligibility3.save_to_restore

3278: --
3279: IF l_datetrack_mode = hr_api.g_correction AND
3280: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
3281: --
3282: ben_determine_eligibility3.save_to_restore
3283: (p_current_per_in_ler_id => l_per_in_ler_id
3284: ,p_per_in_ler_id => l_prev_per_in_ler_id
3285: ,p_elig_per_id => NULL
3286: ,p_elig_per_opt_id => l_elig_per_opt_id

Line 3325: ben_determine_eligibility3.save_to_restore

3321:
3322: if(l_ftr_elig_per_opt_rec.elig_per_opt_id is not null) then
3323: hr_utility.set_location('uxx save to restore in if ',10);
3324:
3325: ben_determine_eligibility3.save_to_restore
3326: (p_current_per_in_ler_id => l_per_in_ler_id
3327: ,p_per_in_ler_id => l_prev_pil_id
3328: ,p_elig_per_id => NUll
3329: ,p_elig_per_opt_id => l_ftr_elig_per_opt_rec.elig_per_opt_id

Line 3334: ben_determine_eligibility3.save_to_restore

3330: ,p_effective_date => l_ftr_elig_per_opt_rec.effective_start_date
3331: );
3332: /* else
3333: hr_utility.set_location('uxx save to restore in else ',10);
3334: ben_determine_eligibility3.save_to_restore
3335: (p_current_per_in_ler_id => l_per_in_ler_id
3336: ,p_per_in_ler_id => l_prev_per_in_ler_id
3337: ,p_elig_per_id => NULL
3338: ,p_elig_per_opt_id => l_elig_per_opt_id

Line 4015: ben_determine_eligibility3.save_to_restore

4011: --
4012: IF l_datetrack_mode = hr_api.g_correction AND
4013: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
4014: --
4015: ben_determine_eligibility3.save_to_restore
4016: (p_current_per_in_ler_id => l_per_in_ler_id
4017: ,p_per_in_ler_id => l_prev_per_in_ler_id
4018: ,p_elig_per_id => NULL
4019: ,p_elig_per_opt_id => l_prev_oiplip_elig_check.elig_per_opt_id

Line 4058: ben_determine_eligibility3.save_to_restore

4054:
4055: if(l_ftr_elig_per_opt_rec.elig_per_opt_id is not null) then
4056: hr_utility.set_location('uxx save to restore in if ',10);
4057:
4058: ben_determine_eligibility3.save_to_restore
4059: (p_current_per_in_ler_id => l_per_in_ler_id
4060: ,p_per_in_ler_id => l_prev_pil_id
4061: ,p_elig_per_id => NUll
4062: ,p_elig_per_opt_id => l_ftr_elig_per_opt_rec.elig_per_opt_id

Line 4067: ben_determine_eligibility3.save_to_restore

4063: ,p_effective_date => l_ftr_elig_per_opt_rec.effective_start_date
4064: );
4065: /* else
4066: hr_utility.set_location('uxx save to restore in else ',10);
4067: ben_determine_eligibility3.save_to_restore
4068: (p_current_per_in_ler_id => l_per_in_ler_id
4069: ,p_per_in_ler_id => l_prev_per_in_ler_id
4070: ,p_elig_per_id => NULL
4071: ,p_elig_per_opt_id => l_prev_oiplip_elig_check.elig_per_opt_id

Line 4573: ben_determine_eligibility3.save_to_restore

4569:
4570: IF l_datetrack_mode = hr_api.g_correction AND
4571: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
4572:
4573: ben_determine_eligibility3.save_to_restore
4574: (p_current_per_in_ler_id => l_per_in_ler_id
4575: ,p_per_in_ler_id => l_prev_per_in_ler_id
4576: ,p_elig_per_id => l_elig_per_id
4577: ,p_elig_per_opt_id => NULL

Line 4607: ben_determine_eligibility3.save_to_restore

4603: p_effective_date);
4604: fetch c_elig_per_id into l_ftr_elig_per_rec;
4605: close c_elig_per_id;
4606: if(l_ftr_elig_per_rec.elig_per_id is not null) then
4607: ben_determine_eligibility3.save_to_restore
4608: (p_current_per_in_ler_id => l_per_in_ler_id
4609: ,p_per_in_ler_id => l_prev_pil_id
4610: ,p_elig_per_id => l_ftr_elig_per_rec.elig_per_id
4611: ,p_elig_per_opt_id => NULL

Line 4615: ben_determine_eligibility3.save_to_restore

4611: ,p_elig_per_opt_id => NULL
4612: ,p_effective_date => l_ftr_elig_per_rec.effective_start_date
4613: );
4614: else
4615: ben_determine_eligibility3.save_to_restore
4616: (p_current_per_in_ler_id => l_per_in_ler_id
4617: ,p_per_in_ler_id => l_prev_per_in_ler_id
4618: ,p_elig_per_id => l_elig_per_id
4619: ,p_elig_per_opt_id => NULL

Line 4935: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg

4931: --
4932: -- Apply the participation start date code to the l_wait_perd_cmpltn_dt
4933: --
4934: l_prtn_st_dt_aftr_wtg :=
4935: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg
4936: (p_person_id => p_person_id,
4937: p_effective_date => p_effective_date,
4938: p_business_group_id => p_business_group_id,
4939: p_prtn_eff_strt_dt_cd => l_prtn_eff_strt_dt_cd,

Line 5218: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg

5214: -- Apply the participation start date code to the l_wait_perd_cmpltn_dt
5215: --
5216: hr_utility.set_location('ben_determine_eligibility2.check_prev_elig GET_PSDAWTG ', 10);
5217: l_prtn_st_dt_aftr_wtg :=
5218: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg
5219: (p_person_id => p_person_id,
5220: p_effective_date => p_effective_date,
5221: p_business_group_id => p_business_group_id,
5222: p_prtn_eff_strt_dt_cd => l_prtn_eff_strt_dt_cd,

Line 5259: ben_determine_eligibility3.save_to_restore

5255: hr_utility.set_location('SARKAR p_ler_id '|| p_ler_id,112);
5256: IF l_datetrack_mode = hr_api.g_correction AND
5257: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
5258: --
5259: ben_determine_eligibility3.save_to_restore
5260: (p_current_per_in_ler_id => l_per_in_ler_id
5261: ,p_per_in_ler_id => l_prev_per_in_ler_id
5262: ,p_elig_per_id => l_elig_per_id
5263: ,p_elig_per_opt_id => NULL

Line 5291: ben_determine_eligibility3.save_to_restore

5287: fetch c_elig_per_id into l_ftr_elig_per_rec;
5288: close c_elig_per_id;
5289:
5290: if(l_ftr_elig_per_rec.elig_per_id is not null) then
5291: ben_determine_eligibility3.save_to_restore
5292: (p_current_per_in_ler_id => l_per_in_ler_id
5293: ,p_per_in_ler_id => l_prev_pil_id
5294: ,p_elig_per_id => l_ftr_elig_per_rec.elig_per_id
5295: ,p_elig_per_opt_id => NULL

Line 5299: ben_determine_eligibility3.save_to_restore

5295: ,p_elig_per_opt_id => NULL
5296: ,p_effective_date => l_ftr_elig_per_rec.effective_start_date
5297: );
5298: else
5299: ben_determine_eligibility3.save_to_restore
5300: (p_current_per_in_ler_id => l_per_in_ler_id
5301: ,p_per_in_ler_id => l_prev_per_in_ler_id
5302: ,p_elig_per_id => l_elig_per_id
5303: ,p_elig_per_opt_id => NULL

Line 5574: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg

5570: --
5571: -- Apply the participation start date code to the l_wait_perd_cmpltn_dt
5572: --
5573: l_prtn_st_dt_aftr_wtg :=
5574: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg
5575: (p_person_id => p_person_id,
5576: p_effective_date => p_effective_date,
5577: p_business_group_id => p_business_group_id,
5578: p_prtn_eff_strt_dt_cd => l_prtn_eff_strt_dt_cd,

Line 5611: ben_determine_eligibility3.save_to_restore

5607: --
5608: IF l_datetrack_mode = hr_api.g_correction AND
5609: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
5610: --
5611: ben_determine_eligibility3.save_to_restore
5612: (p_current_per_in_ler_id => l_per_in_ler_id
5613: ,p_per_in_ler_id => l_prev_per_in_ler_id
5614: ,p_elig_per_id => l_elig_per_id
5615: ,p_elig_per_opt_id => NULL

Line 5642: ben_determine_eligibility3.save_to_restore

5638: p_effective_date);
5639: fetch c_elig_per_id into l_ftr_elig_per_rec;
5640: close c_elig_per_id;
5641: if(l_ftr_elig_per_rec.elig_per_id is not null) then
5642: ben_determine_eligibility3.save_to_restore
5643: (p_current_per_in_ler_id => l_per_in_ler_id
5644: ,p_per_in_ler_id => l_prev_pil_id
5645: ,p_elig_per_id => l_ftr_elig_per_rec.elig_per_id
5646: ,p_elig_per_opt_id => NULL

Line 5650: ben_determine_eligibility3.save_to_restore

5646: ,p_elig_per_opt_id => NULL
5647: ,p_effective_date => l_ftr_elig_per_rec.effective_start_date
5648: );
5649: else
5650: ben_determine_eligibility3.save_to_restore
5651: (p_current_per_in_ler_id => l_per_in_ler_id
5652: ,p_per_in_ler_id => l_prev_per_in_ler_id
5653: ,p_elig_per_id => l_elig_per_id
5654: ,p_elig_per_opt_id => NULL

Line 5924: ben_determine_eligibility3.save_to_restore

5920: --
5921: IF l_datetrack_mode = hr_api.g_correction AND
5922: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
5923: --
5924: ben_determine_eligibility3.save_to_restore
5925: (p_current_per_in_ler_id => l_per_in_ler_id
5926: ,p_per_in_ler_id => l_prev_per_in_ler_id
5927: ,p_elig_per_id => l_elig_per_id
5928: ,p_elig_per_opt_id => NULL

Line 5958: ben_determine_eligibility3.save_to_restore

5954: fetch c_elig_per_id into l_ftr_elig_per_rec;
5955: close c_elig_per_id;
5956:
5957: if(l_ftr_elig_per_rec.elig_per_id is not null) then
5958: ben_determine_eligibility3.save_to_restore
5959: (p_current_per_in_ler_id => l_per_in_ler_id
5960: ,p_per_in_ler_id => l_prev_pil_id
5961: ,p_elig_per_id => l_ftr_elig_per_rec.elig_per_id
5962: ,p_elig_per_opt_id => NULL

Line 5966: ben_determine_eligibility3.save_to_restore

5962: ,p_elig_per_opt_id => NULL
5963: ,p_effective_date => l_ftr_elig_per_rec.effective_start_date
5964: );
5965: else
5966: ben_determine_eligibility3.save_to_restore
5967: (p_current_per_in_ler_id => l_per_in_ler_id
5968: ,p_per_in_ler_id => l_prev_per_in_ler_id
5969: ,p_elig_per_id => l_elig_per_id
5970: ,p_elig_per_opt_id => NULL