DBA Data[Home] [Help]

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 1921: ben_determine_eligibility3.save_to_restore

1917:
1918: IF l_datetrack_mode = hr_api.g_correction AND
1919: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
1920: --
1921: ben_determine_eligibility3.save_to_restore
1922: (p_current_per_in_ler_id => l_per_in_ler_id
1923: ,p_per_in_ler_id => l_prev_per_in_ler_id
1924: ,p_elig_per_id => NULL
1925: ,p_elig_per_opt_id => l_elig_per_opt_id

Line 2233: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg

2229: -- after the waiting period ends.
2230: if l_wait_perd_cmpltn_dt is not null and l_benmngle_parm_rec.mode_cd <> 'D' then
2231: -- Apply the participation start date code to the l_wait_perd_cmpltn_dt
2232: l_prtn_st_dt_aftr_wtg :=
2233: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg
2234: (p_person_id => p_person_id
2235: ,p_effective_date => p_effective_date
2236: ,p_business_group_id => p_business_group_id
2237: ,p_prtn_eff_strt_dt_cd => l_prtn_eff_strt_dt_cd

Line 2477: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg

2473: --
2474: -- Apply the participation start date code to the l_wait_perd_cmpltn_dt
2475: --
2476: l_prtn_st_dt_aftr_wtg :=
2477: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg
2478: (p_person_id => p_person_id,
2479: p_effective_date => p_effective_date,
2480: p_business_group_id => p_business_group_id,
2481: p_prtn_eff_strt_dt_cd => l_prtn_eff_strt_dt_cd,

Line 2507: ben_determine_eligibility3.save_to_restore

2503: hr_utility.set_location('SARKAR EPO l_per_in_ler_id' || l_per_in_ler_id, 10);
2504: IF l_datetrack_mode = hr_api.g_correction AND
2505: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) AND l_benmngle_parm_rec.mode_cd <> 'D' THEN
2506: --
2507: ben_determine_eligibility3.save_to_restore
2508: (p_current_per_in_ler_id => l_per_in_ler_id
2509: ,p_per_in_ler_id => l_prev_per_in_ler_id
2510: ,p_elig_per_id => NULL
2511: ,p_elig_per_opt_id => l_elig_per_opt_id

Line 2782: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg

2778: --
2779: -- Apply the participation start date code to the l_wait_perd_cmpltn_dt
2780: --
2781: l_prtn_st_dt_aftr_wtg :=
2782: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg
2783: (p_person_id => p_person_id,
2784: p_effective_date => p_effective_date,
2785: p_business_group_id => p_business_group_id,
2786: p_prtn_eff_strt_dt_cd => l_prtn_eff_strt_dt_cd,

Line 2812: ben_determine_eligibility3.save_to_restore

2808: --
2809: IF l_datetrack_mode = hr_api.g_correction AND
2810: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
2811: --
2812: ben_determine_eligibility3.save_to_restore
2813: (p_current_per_in_ler_id => l_per_in_ler_id
2814: ,p_per_in_ler_id => l_prev_per_in_ler_id
2815: ,p_elig_per_id => NULL
2816: ,p_elig_per_opt_id => l_elig_per_opt_id

Line 3061: ben_determine_eligibility3.save_to_restore

3057: --
3058: IF l_datetrack_mode = hr_api.g_correction AND
3059: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
3060: --
3061: ben_determine_eligibility3.save_to_restore
3062: (p_current_per_in_ler_id => l_per_in_ler_id
3063: ,p_per_in_ler_id => l_prev_per_in_ler_id
3064: ,p_elig_per_id => NULL
3065: ,p_elig_per_opt_id => l_elig_per_opt_id

Line 3739: ben_determine_eligibility3.save_to_restore

3735: --
3736: IF l_datetrack_mode = hr_api.g_correction AND
3737: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
3738: --
3739: ben_determine_eligibility3.save_to_restore
3740: (p_current_per_in_ler_id => l_per_in_ler_id
3741: ,p_per_in_ler_id => l_prev_per_in_ler_id
3742: ,p_elig_per_id => NULL
3743: ,p_elig_per_opt_id => l_prev_oiplip_elig_check.elig_per_opt_id

Line 4241: ben_determine_eligibility3.save_to_restore

4237:
4238: IF l_datetrack_mode = hr_api.g_correction AND
4239: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
4240:
4241: ben_determine_eligibility3.save_to_restore
4242: (p_current_per_in_ler_id => l_per_in_ler_id
4243: ,p_per_in_ler_id => l_prev_per_in_ler_id
4244: ,p_elig_per_id => l_elig_per_id
4245: ,p_elig_per_opt_id => NULL

Line 4544: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg

4540: --
4541: -- Apply the participation start date code to the l_wait_perd_cmpltn_dt
4542: --
4543: l_prtn_st_dt_aftr_wtg :=
4544: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg
4545: (p_person_id => p_person_id,
4546: p_effective_date => p_effective_date,
4547: p_business_group_id => p_business_group_id,
4548: p_prtn_eff_strt_dt_cd => l_prtn_eff_strt_dt_cd,

Line 4827: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg

4823: -- Apply the participation start date code to the l_wait_perd_cmpltn_dt
4824: --
4825: hr_utility.set_location('ben_determine_eligibility2.check_prev_elig GET_PSDAWTG ', 10);
4826: l_prtn_st_dt_aftr_wtg :=
4827: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg
4828: (p_person_id => p_person_id,
4829: p_effective_date => p_effective_date,
4830: p_business_group_id => p_business_group_id,
4831: p_prtn_eff_strt_dt_cd => l_prtn_eff_strt_dt_cd,

Line 4868: ben_determine_eligibility3.save_to_restore

4864: hr_utility.set_location('SARKAR p_ler_id '|| p_ler_id,112);
4865: IF l_datetrack_mode = hr_api.g_correction AND
4866: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
4867: --
4868: ben_determine_eligibility3.save_to_restore
4869: (p_current_per_in_ler_id => l_per_in_ler_id
4870: ,p_per_in_ler_id => l_prev_per_in_ler_id
4871: ,p_elig_per_id => l_elig_per_id
4872: ,p_elig_per_opt_id => NULL

Line 5141: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg

5137: --
5138: -- Apply the participation start date code to the l_wait_perd_cmpltn_dt
5139: --
5140: l_prtn_st_dt_aftr_wtg :=
5141: ben_determine_eligibility3.get_prtn_st_dt_aftr_wtg
5142: (p_person_id => p_person_id,
5143: p_effective_date => p_effective_date,
5144: p_business_group_id => p_business_group_id,
5145: p_prtn_eff_strt_dt_cd => l_prtn_eff_strt_dt_cd,

Line 5178: ben_determine_eligibility3.save_to_restore

5174: --
5175: IF l_datetrack_mode = hr_api.g_correction AND
5176: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
5177: --
5178: ben_determine_eligibility3.save_to_restore
5179: (p_current_per_in_ler_id => l_per_in_ler_id
5180: ,p_per_in_ler_id => l_prev_per_in_ler_id
5181: ,p_elig_per_id => l_elig_per_id
5182: ,p_elig_per_opt_id => NULL

Line 5450: ben_determine_eligibility3.save_to_restore

5446: --
5447: IF l_datetrack_mode = hr_api.g_correction AND
5448: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
5449: --
5450: ben_determine_eligibility3.save_to_restore
5451: (p_current_per_in_ler_id => l_per_in_ler_id
5452: ,p_per_in_ler_id => l_prev_per_in_ler_id
5453: ,p_elig_per_id => l_elig_per_id
5454: ,p_elig_per_opt_id => NULL