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 HR_API

Line 165: and elig per opt apis. Added hr_api.g_sot.

161: Added function get_prtn_st_dt_aftr_wtg.
162: 14 May 99 G Perry 115.30 Added support for PLIP and PTIP.
163: 14 Jun 99 T Mathers 115.31 Changed to_dates to be NLS compliant
164: 17 Jun 99 bbulusu 115.32 Added wait_perd_cmpltn_dt to the Elig per
165: and elig per opt apis. Added hr_api.g_sot.
166: 23 Jun 99 G Perry 115.33 performance fixes and fixed balas spurious
167: use of dates.
168: 28 Jun 99 jcarpent 115.34 Added per_in_ler_id to elig_per api call.
169: and added p_per_in_ler_id to check_prev_elg

Line 1894: l_datetrack_mode := hr_api.g_update_override;

1890: p_update_override => l_update_override,
1891: p_update_change_insert => l_update_change_insert);
1892: --
1893: if l_update_override then
1894: l_datetrack_mode := hr_api.g_update_override;
1895:
1896: if g_debug then
1897: hr_utility.set_location('EPO l_datetrack_mode '||l_datetrack_mode, 777);
1898: end if;

Line 1901: l_datetrack_mode := hr_api.g_update;

1897: hr_utility.set_location('EPO l_datetrack_mode '||l_datetrack_mode, 777);
1898: end if;
1899:
1900: elsif l_update then
1901: l_datetrack_mode := hr_api.g_update;
1902:
1903: if g_debug then
1904: hr_utility.set_location('EPO l_datetrack_mode '||l_datetrack_mode, 777);
1905: end if;

Line 1907: l_datetrack_mode := hr_api.g_correction;

1903: if g_debug then
1904: hr_utility.set_location('EPO l_datetrack_mode '||l_datetrack_mode, 777);
1905: end if;
1906: else
1907: l_datetrack_mode := hr_api.g_correction;
1908:
1909: if g_debug then
1910: hr_utility.set_location('EPO l_datetrack_mode '||l_datetrack_mode, 777);
1911: end if;

Line 1918: IF l_datetrack_mode = hr_api.g_correction AND

1914: hr_utility.set_location('EPO l_per_in_ler_id' || l_per_in_ler_id, 777);
1915:
1916: -- insert into backup table if updating in correction mode
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

Line 2252: ,hr_api.g_sot),l_prtn_eff_strt_dt);

2248: --
2249: -- Use the later of the l_after_wtg_prtn_dt and l_prtn_eff_strt_dt
2250: -- for the participation start date.
2251: l_prtn_eff_strt_dt := greatest(nvl(l_prtn_st_dt_aftr_wtg
2252: ,hr_api.g_sot),l_prtn_eff_strt_dt);
2253: --
2254: end if;
2255: --
2256: if g_debug then

Line 2457: l_datetrack_mode := hr_api.g_update_override;

2453: p_update_change_insert => l_update_change_insert);
2454: --
2455: if l_update_override then
2456: --
2457: l_datetrack_mode := hr_api.g_update_override;
2458: --
2459: elsif l_update then
2460: --
2461: l_datetrack_mode := hr_api.g_update;

Line 2461: l_datetrack_mode := hr_api.g_update;

2457: l_datetrack_mode := hr_api.g_update_override;
2458: --
2459: elsif l_update then
2460: --
2461: l_datetrack_mode := hr_api.g_update;
2462: --
2463: else
2464: --
2465: l_datetrack_mode := hr_api.g_correction;

Line 2465: l_datetrack_mode := hr_api.g_correction;

2461: l_datetrack_mode := hr_api.g_update;
2462: --
2463: else
2464: --
2465: l_datetrack_mode := hr_api.g_correction;
2466: --
2467: end if;
2468: --
2469: -- If a waiting period applies, get the date when participation will begin

Line 2496: greatest(nvl(l_prtn_st_dt_aftr_wtg,hr_api.g_sot),l_prtn_eff_strt_dt);

2492: -- Use the later of the l_after_wtg_prtn_dt and l_prtn_eff_strt_dt
2493: -- for the participation start date.
2494: --
2495: l_prtn_eff_strt_dt :=
2496: greatest(nvl(l_prtn_st_dt_aftr_wtg,hr_api.g_sot),l_prtn_eff_strt_dt);
2497: --
2498: end if;
2499: --
2500: l_elig_flag := 'Y';

Line 2504: IF l_datetrack_mode = hr_api.g_correction AND

2500: l_elig_flag := 'Y';
2501: l_prtn_strt_dt := l_prtn_eff_strt_dt;
2502: --
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

Line 2732: p_datetrack_mode => hr_api.g_correction,

2728: p_prtn_end_dt => l_prtn_eff_strt_dt-1,
2729: -- p_effective_date => p_effective_date,
2730: p_effective_date => l_effective_dt,
2731: p_object_version_number => l_object_version_number_opt,
2732: p_datetrack_mode => hr_api.g_correction,
2733: p_program_application_id => fnd_global.prog_appl_id,
2734: p_program_id => fnd_global.conc_program_id,
2735: p_request_id => fnd_global.conc_request_id,
2736: p_program_update_date => sysdate);

Line 2762: l_datetrack_mode := hr_api.g_update_override;

2758: p_update_change_insert => l_update_change_insert);
2759: --
2760: if l_update_override then
2761: --
2762: l_datetrack_mode := hr_api.g_update_override;
2763: --
2764: elsif l_update then
2765: --
2766: l_datetrack_mode := hr_api.g_update;

Line 2766: l_datetrack_mode := hr_api.g_update;

2762: l_datetrack_mode := hr_api.g_update_override;
2763: --
2764: elsif l_update then
2765: --
2766: l_datetrack_mode := hr_api.g_update;
2767: --
2768: else
2769: --
2770: l_datetrack_mode := hr_api.g_correction;

Line 2770: l_datetrack_mode := hr_api.g_correction;

2766: l_datetrack_mode := hr_api.g_update;
2767: --
2768: else
2769: --
2770: l_datetrack_mode := hr_api.g_correction;
2771: --
2772: end if;
2773: --
2774: -- If a waiting period applies, get the date when participation will begin

Line 2801: greatest(nvl(l_prtn_st_dt_aftr_wtg,hr_api.g_sot),l_prtn_eff_strt_dt);

2797: -- Use the later of the l_after_wtg_prtn_dt and l_prtn_eff_strt_dt
2798: -- for the participation start date.
2799: --
2800: l_prtn_eff_strt_dt :=
2801: greatest(nvl(l_prtn_st_dt_aftr_wtg,hr_api.g_sot),l_prtn_eff_strt_dt);
2802: --
2803: end if;
2804: --
2805: l_elig_flag := 'Y';

Line 2809: IF l_datetrack_mode = hr_api.g_correction AND

2805: l_elig_flag := 'Y';
2806: l_prtn_strt_dt := l_prtn_eff_strt_dt;
2807: --
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

Line 3020: p_datetrack_mode => hr_api.g_correction,

3016: p_prtn_end_dt => l_prtn_eff_end_dt,
3017: -- p_effective_date => p_effective_date,
3018: p_effective_date => l_effective_dt,
3019: p_object_version_number => l_object_version_number_opt,
3020: p_datetrack_mode => hr_api.g_correction,
3021: p_program_application_id => fnd_global.prog_appl_id,
3022: p_program_id => fnd_global.conc_program_id,
3023: p_request_id => fnd_global.conc_request_id,
3024: p_program_update_date => sysdate);

Line 3045: l_datetrack_mode := hr_api.g_update_override;

3041: p_update_change_insert => l_update_change_insert);
3042: --
3043: if l_update_override then
3044: --
3045: l_datetrack_mode := hr_api.g_update_override;
3046: --
3047: elsif l_update then
3048: --
3049: l_datetrack_mode := hr_api.g_update;

Line 3049: l_datetrack_mode := hr_api.g_update;

3045: l_datetrack_mode := hr_api.g_update_override;
3046: --
3047: elsif l_update then
3048: --
3049: l_datetrack_mode := hr_api.g_update;
3050: --
3051: else
3052: --
3053: l_datetrack_mode := hr_api.g_correction;

Line 3053: l_datetrack_mode := hr_api.g_correction;

3049: l_datetrack_mode := hr_api.g_update;
3050: --
3051: else
3052: --
3053: l_datetrack_mode := hr_api.g_correction;
3054: --
3055: end if;
3056: --
3057: --

Line 3058: IF l_datetrack_mode = hr_api.g_correction AND

3054: --
3055: end if;
3056: --
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

Line 3722: l_datetrack_mode := hr_api.g_update_override;

3718: p_update_change_insert => l_update_change_insert);
3719: --
3720: if l_update_override then
3721: --
3722: l_datetrack_mode := hr_api.g_update_override;
3723: --
3724: elsif l_update then
3725: --
3726: l_datetrack_mode := hr_api.g_update;

Line 3726: l_datetrack_mode := hr_api.g_update;

3722: l_datetrack_mode := hr_api.g_update_override;
3723: --
3724: elsif l_update then
3725: --
3726: l_datetrack_mode := hr_api.g_update;
3727: --
3728: else
3729: --
3730: l_datetrack_mode := hr_api.g_correction;

Line 3730: l_datetrack_mode := hr_api.g_correction;

3726: l_datetrack_mode := hr_api.g_update;
3727: --
3728: else
3729: --
3730: l_datetrack_mode := hr_api.g_correction;
3731: --
3732: end if;
3733: --
3734: -- Update oiplip record with correct mode

Line 3736: IF l_datetrack_mode = hr_api.g_correction AND

3732: end if;
3733: --
3734: -- Update oiplip record with correct mode
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

Line 4211: l_datetrack_mode := hr_api.g_update_override;

4207: hr_utility.set_location('ben_determine_eligibility2.check_prev_elig Dn DTAPI_FDUM ', 10);
4208: end if;
4209:
4210: if l_update_override then
4211: l_datetrack_mode := hr_api.g_update_override;
4212:
4213: if g_debug then
4214: hr_utility.set_location('ben_elig_per_f l_datetrack_mode '|| l_datetrack_mode, 777);
4215: end if;

Line 4218: l_datetrack_mode := hr_api.g_update;

4214: hr_utility.set_location('ben_elig_per_f l_datetrack_mode '|| l_datetrack_mode, 777);
4215: end if;
4216:
4217: elsif l_update then
4218: l_datetrack_mode := hr_api.g_update;
4219:
4220: if g_debug then
4221: hr_utility.set_location('ben_elig_per_f l_datetrack_mode '|| l_datetrack_mode, 777);
4222: end if;

Line 4225: l_datetrack_mode := hr_api.g_correction;

4221: hr_utility.set_location('ben_elig_per_f l_datetrack_mode '|| l_datetrack_mode, 777);
4222: end if;
4223:
4224: else
4225: l_datetrack_mode := hr_api.g_correction;
4226:
4227: if g_debug then
4228: hr_utility.set_location('ben_elig_per_f l_datetrack_mode '|| l_datetrack_mode, 777);
4229: end if;

Line 4238: IF l_datetrack_mode = hr_api.g_correction AND

4234: hr_utility.set_location('l_per_in_ler_id'||l_per_in_ler_id,112);
4235: hr_utility.set_location('l_prev_per_in_ler_id'|| l_prev_per_in_ler_id,112);
4236: hr_utility.set_location('p_ler_id '|| p_ler_id,112);
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

Line 4563: greatest(nvl(l_prtn_st_dt_aftr_wtg,hr_api.g_sot),l_prtn_eff_strt_dt);

4559: -- Use the later of the l_after_wtg_prtn_dt and l_prtn_eff_strt_dt
4560: -- for the participation start date.
4561: --
4562: l_prtn_eff_strt_dt :=
4563: greatest(nvl(l_prtn_st_dt_aftr_wtg,hr_api.g_sot),l_prtn_eff_strt_dt);
4564: --
4565: end if;
4566: --
4567: hr_utility.set_location('Using prtn_eff_strt_dt : ' ||

Line 4806: l_datetrack_mode := hr_api.g_update_override;

4802: hr_utility.set_location('ben_determine_eligibility2.check_prev_elig Dn DTAPI_FDUM ', 10);
4803: --
4804: if l_update_override then
4805: --
4806: l_datetrack_mode := hr_api.g_update_override;
4807: --
4808: elsif l_update then
4809: --
4810: l_datetrack_mode := hr_api.g_update;

Line 4810: l_datetrack_mode := hr_api.g_update;

4806: l_datetrack_mode := hr_api.g_update_override;
4807: --
4808: elsif l_update then
4809: --
4810: l_datetrack_mode := hr_api.g_update;
4811: --
4812: else
4813: --
4814: l_datetrack_mode := hr_api.g_correction;

Line 4814: l_datetrack_mode := hr_api.g_correction;

4810: l_datetrack_mode := hr_api.g_update;
4811: --
4812: else
4813: --
4814: l_datetrack_mode := hr_api.g_correction;
4815: --
4816: end if;
4817: --
4818: -- If a waiting period applies, get the date when participation will begin

Line 4846: l_prtn_eff_strt_dt := greatest(nvl(l_prtn_st_dt_aftr_wtg, hr_api.g_sot)

4842: --
4843: -- Use the later of the l_after_wtg_prtn_dt and l_prtn_eff_strt_dt
4844: -- for the participation start date.
4845: --
4846: l_prtn_eff_strt_dt := greatest(nvl(l_prtn_st_dt_aftr_wtg, hr_api.g_sot)
4847: ,l_prtn_eff_strt_dt);
4848: --
4849: end if;
4850: --

Line 4865: IF l_datetrack_mode = hr_api.g_correction AND

4861: --
4862: hr_utility.set_location('SARKAR l_per_in_ler_id'||l_per_in_ler_id,112);
4863: hr_utility.set_location('SARKAR l_prev_per_in_ler_id'|| l_prev_per_in_ler_id,112);
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

Line 5093: p_datetrack_mode => hr_api.g_correction,

5089: p_effective_end_date => l_effective_end_date,
5090: p_prtn_end_dt => (l_prtn_eff_strt_dt -1),
5091: p_object_version_number => l_object_version_number,
5092: p_effective_date => l_effective_dt, -- 4947426
5093: p_datetrack_mode => hr_api.g_correction,
5094: p_program_application_id => fnd_global.prog_appl_id,
5095: p_program_id => fnd_global.conc_program_id,
5096: p_request_id => fnd_global.conc_request_id,
5097: p_program_update_date => sysdate);

Line 5121: l_datetrack_mode := hr_api.g_update_override;

5117: p_update_change_insert => l_update_change_insert);
5118: --
5119: if l_update_override then
5120: --
5121: l_datetrack_mode := hr_api.g_update_override;
5122: --
5123: elsif l_update then
5124: --
5125: l_datetrack_mode := hr_api.g_update;

Line 5125: l_datetrack_mode := hr_api.g_update;

5121: l_datetrack_mode := hr_api.g_update_override;
5122: --
5123: elsif l_update then
5124: --
5125: l_datetrack_mode := hr_api.g_update;
5126: --
5127: else
5128: --
5129: l_datetrack_mode := hr_api.g_correction;

Line 5129: l_datetrack_mode := hr_api.g_correction;

5125: l_datetrack_mode := hr_api.g_update;
5126: --
5127: else
5128: --
5129: l_datetrack_mode := hr_api.g_correction;
5130: --
5131: end if;
5132: --
5133: -- If a waiting period applies, get the date when participation will begin

Line 5159: l_prtn_eff_strt_dt := greatest(nvl(l_prtn_st_dt_aftr_wtg, hr_api.g_sot)

5155: --
5156: -- Use the later of the l_after_wtg_prtn_dt and l_prtn_eff_strt_dt
5157: -- for the participation start date.
5158: --
5159: l_prtn_eff_strt_dt := greatest(nvl(l_prtn_st_dt_aftr_wtg, hr_api.g_sot)
5160: ,l_prtn_eff_strt_dt);
5161: --
5162: end if;
5163: --

Line 5175: IF l_datetrack_mode = hr_api.g_correction AND

5171: l_elig_flag := 'Y';
5172: l_prtn_strt_dt := l_prtn_eff_strt_dt;
5173: --
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

Line 5398: p_datetrack_mode => hr_api.g_correction,

5394: p_prtn_end_dt => l_prtn_eff_end_dt,
5395: p_object_version_number => l_object_version_number,
5396: -- p_effective_date => p_effective_date,
5397: p_effective_date => l_effective_dt,
5398: p_datetrack_mode => hr_api.g_correction,
5399: p_program_application_id => fnd_global.prog_appl_id,
5400: p_program_id => fnd_global.conc_program_id,
5401: p_request_id => fnd_global.conc_request_id,
5402: p_program_update_date => sysdate);

Line 5425: l_datetrack_mode := hr_api.g_update_override;

5421: p_update_change_insert => l_update_change_insert);
5422: --
5423: if l_update_override then
5424: --
5425: l_datetrack_mode := hr_api.g_update_override;
5426: --
5427: elsif l_update then
5428: --
5429: l_datetrack_mode := hr_api.g_update;

Line 5429: l_datetrack_mode := hr_api.g_update;

5425: l_datetrack_mode := hr_api.g_update_override;
5426: --
5427: elsif l_update then
5428: --
5429: l_datetrack_mode := hr_api.g_update;
5430: --
5431: else
5432: --
5433: l_datetrack_mode := hr_api.g_correction;

Line 5433: l_datetrack_mode := hr_api.g_correction;

5429: l_datetrack_mode := hr_api.g_update;
5430: --
5431: else
5432: --
5433: l_datetrack_mode := hr_api.g_correction;
5434: --
5435: end if;
5436: --
5437: -- Update pil_id also since new row added due to current pil

Line 5447: IF l_datetrack_mode = hr_api.g_correction AND

5443: l_elig_flag := 'N';
5444: l_prtn_strt_dt := l_end_dt_plus_one;
5445: --
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