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 1988: l_datetrack_mode := hr_api.g_update_override;

1984: p_update_override => l_update_override,
1985: p_update_change_insert => l_update_change_insert);
1986: --
1987: if l_update_override then
1988: l_datetrack_mode := hr_api.g_update_override;
1989:
1990: if g_debug then
1991: hr_utility.set_location('EPO l_datetrack_mode '||l_datetrack_mode, 777);
1992: end if;

Line 1995: l_datetrack_mode := hr_api.g_update;

1991: hr_utility.set_location('EPO l_datetrack_mode '||l_datetrack_mode, 777);
1992: end if;
1993:
1994: elsif l_update then
1995: l_datetrack_mode := hr_api.g_update;
1996:
1997: if g_debug then
1998: hr_utility.set_location('EPO l_datetrack_mode '||l_datetrack_mode, 777);
1999: end if;

Line 2001: l_datetrack_mode := hr_api.g_correction;

1997: if g_debug then
1998: hr_utility.set_location('EPO l_datetrack_mode '||l_datetrack_mode, 777);
1999: end if;
2000: else
2001: l_datetrack_mode := hr_api.g_correction;
2002:
2003: if g_debug then
2004: hr_utility.set_location('EPO l_datetrack_mode '||l_datetrack_mode, 777);
2005: end if;

Line 2012: IF l_datetrack_mode = hr_api.g_correction AND

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

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

2358: --
2359: -- Use the later of the l_after_wtg_prtn_dt and l_prtn_eff_strt_dt
2360: -- for the participation start date.
2361: l_prtn_eff_strt_dt := greatest(nvl(l_prtn_st_dt_aftr_wtg
2362: ,hr_api.g_sot),l_prtn_eff_strt_dt);
2363: --
2364: end if;
2365: --
2366: if g_debug then

Line 2567: l_datetrack_mode := hr_api.g_update_override;

2563: p_update_change_insert => l_update_change_insert);
2564: --
2565: if l_update_override then
2566: --
2567: l_datetrack_mode := hr_api.g_update_override;
2568: --
2569: elsif l_update then
2570: --
2571: l_datetrack_mode := hr_api.g_update;

Line 2571: l_datetrack_mode := hr_api.g_update;

2567: l_datetrack_mode := hr_api.g_update_override;
2568: --
2569: elsif l_update then
2570: --
2571: l_datetrack_mode := hr_api.g_update;
2572: --
2573: else
2574: --
2575: l_datetrack_mode := hr_api.g_correction;

Line 2575: l_datetrack_mode := hr_api.g_correction;

2571: l_datetrack_mode := hr_api.g_update;
2572: --
2573: else
2574: --
2575: l_datetrack_mode := hr_api.g_correction;
2576: --
2577: end if;
2578: --
2579: -- If a waiting period applies, get the date when participation will begin

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

2602: -- Use the later of the l_after_wtg_prtn_dt and l_prtn_eff_strt_dt
2603: -- for the participation start date.
2604: --
2605: l_prtn_eff_strt_dt :=
2606: greatest(nvl(l_prtn_st_dt_aftr_wtg,hr_api.g_sot),l_prtn_eff_strt_dt);
2607: --
2608: end if;
2609: --
2610: l_elig_flag := 'Y';

Line 2614: IF l_datetrack_mode = hr_api.g_correction AND

2610: l_elig_flag := 'Y';
2611: l_prtn_strt_dt := l_prtn_eff_strt_dt;
2612: --
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

Line 2632: IF (l_datetrack_mode = hr_api.g_update_override) -- AND

2628: --If the oipl comp object is still eligible then checking whether for the same comp object
2629: --Future records are present in ben_elig_per_opt_f tables.If present inserting them into
2630: --backup table.
2631:
2632: IF (l_datetrack_mode = hr_api.g_update_override) -- AND
2633: -- l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
2634: then --
2635: open c_prev_pil(p_pil_row.per_in_ler_id);
2636: fetch c_prev_pil into l_prev_pil_id;

Line 2898: p_datetrack_mode => hr_api.g_correction,

2894: p_prtn_end_dt => l_prtn_eff_strt_dt-1,
2895: -- p_effective_date => p_effective_date,
2896: p_effective_date => l_effective_dt,
2897: p_object_version_number => l_object_version_number_opt,
2898: p_datetrack_mode => hr_api.g_correction,
2899: p_program_application_id => fnd_global.prog_appl_id,
2900: p_program_id => fnd_global.conc_program_id,
2901: p_request_id => fnd_global.conc_request_id,
2902: p_program_update_date => sysdate);

Line 2928: l_datetrack_mode := hr_api.g_update_override;

2924: p_update_change_insert => l_update_change_insert);
2925: --
2926: if l_update_override then
2927: --
2928: l_datetrack_mode := hr_api.g_update_override;
2929: --
2930: elsif l_update then
2931: --
2932: l_datetrack_mode := hr_api.g_update;

Line 2932: l_datetrack_mode := hr_api.g_update;

2928: l_datetrack_mode := hr_api.g_update_override;
2929: --
2930: elsif l_update then
2931: --
2932: l_datetrack_mode := hr_api.g_update;
2933: --
2934: else
2935: --
2936: l_datetrack_mode := hr_api.g_correction;

Line 2936: l_datetrack_mode := hr_api.g_correction;

2932: l_datetrack_mode := hr_api.g_update;
2933: --
2934: else
2935: --
2936: l_datetrack_mode := hr_api.g_correction;
2937: --
2938: end if;
2939: --
2940: -- If a waiting period applies, get the date when participation will begin

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

2963: -- Use the later of the l_after_wtg_prtn_dt and l_prtn_eff_strt_dt
2964: -- for the participation start date.
2965: --
2966: l_prtn_eff_strt_dt :=
2967: greatest(nvl(l_prtn_st_dt_aftr_wtg,hr_api.g_sot),l_prtn_eff_strt_dt);
2968: --
2969: end if;
2970: --
2971: l_elig_flag := 'Y';

Line 2975: IF l_datetrack_mode = hr_api.g_correction AND

2971: l_elig_flag := 'Y';
2972: l_prtn_strt_dt := l_prtn_eff_strt_dt;
2973: --
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

Line 2994: IF (l_datetrack_mode = hr_api.g_update_override) -- AND

2990: --If the oipl comp object is Newly eligible then checking whether for the same comp object
2991: --Future records are present in ben_elig_per_opt_f tables.If present inserting them into
2992: --backup table.
2993:
2994: IF (l_datetrack_mode = hr_api.g_update_override) -- AND
2995: -- l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
2996: then --
2997: open c_prev_pil(p_pil_row.per_in_ler_id);
2998: fetch c_prev_pil into l_prev_pil_id;

Line 3241: p_datetrack_mode => hr_api.g_correction,

3237: p_prtn_end_dt => l_prtn_eff_end_dt,
3238: -- p_effective_date => p_effective_date,
3239: p_effective_date => l_effective_dt,
3240: p_object_version_number => l_object_version_number_opt,
3241: p_datetrack_mode => hr_api.g_correction,
3242: p_program_application_id => fnd_global.prog_appl_id,
3243: p_program_id => fnd_global.conc_program_id,
3244: p_request_id => fnd_global.conc_request_id,
3245: p_program_update_date => sysdate);

Line 3266: l_datetrack_mode := hr_api.g_update_override;

3262: p_update_change_insert => l_update_change_insert);
3263: --
3264: if l_update_override then
3265: --
3266: l_datetrack_mode := hr_api.g_update_override;
3267: --
3268: elsif l_update then
3269: --
3270: l_datetrack_mode := hr_api.g_update;

Line 3270: l_datetrack_mode := hr_api.g_update;

3266: l_datetrack_mode := hr_api.g_update_override;
3267: --
3268: elsif l_update then
3269: --
3270: l_datetrack_mode := hr_api.g_update;
3271: --
3272: else
3273: --
3274: l_datetrack_mode := hr_api.g_correction;

Line 3274: l_datetrack_mode := hr_api.g_correction;

3270: l_datetrack_mode := hr_api.g_update;
3271: --
3272: else
3273: --
3274: l_datetrack_mode := hr_api.g_correction;
3275: --
3276: end if;
3277: --
3278: --

Line 3279: IF l_datetrack_mode = hr_api.g_correction AND

3275: --
3276: end if;
3277: --
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

Line 3298: IF (l_datetrack_mode = hr_api.g_update_override) -- AND

3294: --If the oipl comp object is newly ineligible then checking whether for the same comp object
3295: --Future records are present in ben_elig_per_opt_f tables.If present inserting them into
3296: --backup table.
3297:
3298: IF (l_datetrack_mode = hr_api.g_update_override) -- AND
3299: -- l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
3300: then --
3301: open c_prev_pil(p_pil_row.per_in_ler_id);
3302: fetch c_prev_pil into l_prev_pil_id;

Line 3998: l_datetrack_mode := hr_api.g_update_override;

3994: p_update_change_insert => l_update_change_insert);
3995: --
3996: if l_update_override then
3997: --
3998: l_datetrack_mode := hr_api.g_update_override;
3999: --
4000: elsif l_update then
4001: --
4002: l_datetrack_mode := hr_api.g_update;

Line 4002: l_datetrack_mode := hr_api.g_update;

3998: l_datetrack_mode := hr_api.g_update_override;
3999: --
4000: elsif l_update then
4001: --
4002: l_datetrack_mode := hr_api.g_update;
4003: --
4004: else
4005: --
4006: l_datetrack_mode := hr_api.g_correction;

Line 4006: l_datetrack_mode := hr_api.g_correction;

4002: l_datetrack_mode := hr_api.g_update;
4003: --
4004: else
4005: --
4006: l_datetrack_mode := hr_api.g_correction;
4007: --
4008: end if;
4009: --
4010: -- Update oiplip record with correct mode

Line 4012: IF l_datetrack_mode = hr_api.g_correction AND

4008: end if;
4009: --
4010: -- Update oiplip record with correct mode
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

Line 4031: IF (l_datetrack_mode = hr_api.g_update_override) -- AND

4027: --If the oiplip comp object is Newly eligible/Still eligible then checking whether the same comp object
4028: --Future records are present in ben_elig_per_opt_f tables.If present inserting them into
4029: --backup table.
4030:
4031: IF (l_datetrack_mode = hr_api.g_update_override) -- AND
4032: -- l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
4033: then --
4034: open c_prev_pil(p_pil_row.per_in_ler_id);
4035: fetch c_prev_pil into l_prev_pil_id;

Line 4543: l_datetrack_mode := hr_api.g_update_override;

4539: hr_utility.set_location('ben_determine_eligibility2.check_prev_elig Dn DTAPI_FDUM ', 10);
4540: end if;
4541:
4542: if l_update_override then
4543: l_datetrack_mode := hr_api.g_update_override;
4544:
4545: if g_debug then
4546: hr_utility.set_location('ben_elig_per_f l_datetrack_mode '|| l_datetrack_mode, 777);
4547: end if;

Line 4550: l_datetrack_mode := hr_api.g_update;

4546: hr_utility.set_location('ben_elig_per_f l_datetrack_mode '|| l_datetrack_mode, 777);
4547: end if;
4548:
4549: elsif l_update then
4550: l_datetrack_mode := hr_api.g_update;
4551:
4552: if g_debug then
4553: hr_utility.set_location('ben_elig_per_f l_datetrack_mode '|| l_datetrack_mode, 777);
4554: end if;

Line 4557: l_datetrack_mode := hr_api.g_correction;

4553: hr_utility.set_location('ben_elig_per_f l_datetrack_mode '|| l_datetrack_mode, 777);
4554: end if;
4555:
4556: else
4557: l_datetrack_mode := hr_api.g_correction;
4558:
4559: if g_debug then
4560: hr_utility.set_location('ben_elig_per_f l_datetrack_mode '|| l_datetrack_mode, 777);
4561: end if;

Line 4570: IF l_datetrack_mode = hr_api.g_correction AND

4566: hr_utility.set_location('l_per_in_ler_id'||l_per_in_ler_id,112);
4567: hr_utility.set_location('l_prev_per_in_ler_id'|| l_prev_per_in_ler_id,112);
4568: hr_utility.set_location('p_ler_id '|| p_ler_id,112);
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

Line 4585: IF (l_datetrack_mode = hr_api.g_update_override) AND

4581: END IF;
4582:
4583: /* Bug 9020962: If future eligibility record exists, then insert the record
4584: in backup table ben_le_clsn_n_rstr */
4585: IF (l_datetrack_mode = hr_api.g_update_override) AND
4586: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
4587: --
4588:
4589: open c_prev_pil(p_pil_row.per_in_ler_id);

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

4950: -- Use the later of the l_after_wtg_prtn_dt and l_prtn_eff_strt_dt
4951: -- for the participation start date.
4952: --
4953: l_prtn_eff_strt_dt :=
4954: greatest(nvl(l_prtn_st_dt_aftr_wtg,hr_api.g_sot),l_prtn_eff_strt_dt);
4955: --
4956: end if;
4957: --
4958: hr_utility.set_location('Using prtn_eff_strt_dt : ' ||

Line 5197: l_datetrack_mode := hr_api.g_update_override;

5193: hr_utility.set_location('ben_determine_eligibility2.check_prev_elig Dn DTAPI_FDUM ', 10);
5194: --
5195: if l_update_override then
5196: --
5197: l_datetrack_mode := hr_api.g_update_override;
5198: --
5199: elsif l_update then
5200: --
5201: l_datetrack_mode := hr_api.g_update;

Line 5201: l_datetrack_mode := hr_api.g_update;

5197: l_datetrack_mode := hr_api.g_update_override;
5198: --
5199: elsif l_update then
5200: --
5201: l_datetrack_mode := hr_api.g_update;
5202: --
5203: else
5204: --
5205: l_datetrack_mode := hr_api.g_correction;

Line 5205: l_datetrack_mode := hr_api.g_correction;

5201: l_datetrack_mode := hr_api.g_update;
5202: --
5203: else
5204: --
5205: l_datetrack_mode := hr_api.g_correction;
5206: --
5207: end if;
5208: --
5209: -- If a waiting period applies, get the date when participation will begin

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

5233: --
5234: -- Use the later of the l_after_wtg_prtn_dt and l_prtn_eff_strt_dt
5235: -- for the participation start date.
5236: --
5237: l_prtn_eff_strt_dt := greatest(nvl(l_prtn_st_dt_aftr_wtg, hr_api.g_sot)
5238: ,l_prtn_eff_strt_dt);
5239: --
5240: end if;
5241: --

Line 5256: IF l_datetrack_mode = hr_api.g_correction AND

5252: --
5253: hr_utility.set_location('SARKAR l_per_in_ler_id'||l_per_in_ler_id,112);
5254: hr_utility.set_location('SARKAR l_prev_per_in_ler_id'|| l_prev_per_in_ler_id,112);
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

Line 5270: IF (l_datetrack_mode = hr_api.g_update_override) AND

5266: --
5267: END IF;
5268: /* Bug 9020962: If future eligibility record exists, then insert the record
5269: in backup table ben_le_clsn_n_rstr */
5270: IF (l_datetrack_mode = hr_api.g_update_override) AND
5271: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
5272: --
5273: open c_prev_pil(p_pil_row.per_in_ler_id);
5274: fetch c_prev_pil into l_prev_pil_id;

Line 5526: p_datetrack_mode => hr_api.g_correction,

5522: p_effective_end_date => l_effective_end_date,
5523: p_prtn_end_dt => (l_prtn_eff_strt_dt -1),
5524: p_object_version_number => l_object_version_number,
5525: p_effective_date => l_effective_dt, -- 4947426
5526: p_datetrack_mode => hr_api.g_correction,
5527: p_program_application_id => fnd_global.prog_appl_id,
5528: p_program_id => fnd_global.conc_program_id,
5529: p_request_id => fnd_global.conc_request_id,
5530: p_program_update_date => sysdate);

Line 5554: l_datetrack_mode := hr_api.g_update_override;

5550: p_update_change_insert => l_update_change_insert);
5551: --
5552: if l_update_override then
5553: --
5554: l_datetrack_mode := hr_api.g_update_override;
5555: --
5556: elsif l_update then
5557: --
5558: l_datetrack_mode := hr_api.g_update;

Line 5558: l_datetrack_mode := hr_api.g_update;

5554: l_datetrack_mode := hr_api.g_update_override;
5555: --
5556: elsif l_update then
5557: --
5558: l_datetrack_mode := hr_api.g_update;
5559: --
5560: else
5561: --
5562: l_datetrack_mode := hr_api.g_correction;

Line 5562: l_datetrack_mode := hr_api.g_correction;

5558: l_datetrack_mode := hr_api.g_update;
5559: --
5560: else
5561: --
5562: l_datetrack_mode := hr_api.g_correction;
5563: --
5564: end if;
5565: --
5566: -- If a waiting period applies, get the date when participation will begin

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

5588: --
5589: -- Use the later of the l_after_wtg_prtn_dt and l_prtn_eff_strt_dt
5590: -- for the participation start date.
5591: --
5592: l_prtn_eff_strt_dt := greatest(nvl(l_prtn_st_dt_aftr_wtg, hr_api.g_sot)
5593: ,l_prtn_eff_strt_dt);
5594: --
5595: end if;
5596: --

Line 5608: IF l_datetrack_mode = hr_api.g_correction AND

5604: l_elig_flag := 'Y';
5605: l_prtn_strt_dt := l_prtn_eff_strt_dt;
5606: --
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

Line 5622: IF (l_datetrack_mode = hr_api.g_update_override) AND

5618: end if;
5619:
5620: /* Bug 9020962: If future eligibility record exists, then insert the record
5621: in backup table ben_le_clsn_n_rstr */
5622: IF (l_datetrack_mode = hr_api.g_update_override) AND
5623: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
5624: --
5625: open c_prev_pil(p_pil_row.per_in_ler_id);
5626: fetch c_prev_pil into l_prev_pil_id;

Line 5872: p_datetrack_mode => hr_api.g_correction,

5868: p_prtn_end_dt => l_prtn_eff_end_dt,
5869: p_object_version_number => l_object_version_number,
5870: -- p_effective_date => p_effective_date,
5871: p_effective_date => l_effective_dt,
5872: p_datetrack_mode => hr_api.g_correction,
5873: p_program_application_id => fnd_global.prog_appl_id,
5874: p_program_id => fnd_global.conc_program_id,
5875: p_request_id => fnd_global.conc_request_id,
5876: p_program_update_date => sysdate);

Line 5899: l_datetrack_mode := hr_api.g_update_override;

5895: p_update_change_insert => l_update_change_insert);
5896: --
5897: if l_update_override then
5898: --
5899: l_datetrack_mode := hr_api.g_update_override;
5900: --
5901: elsif l_update then
5902: --
5903: l_datetrack_mode := hr_api.g_update;

Line 5903: l_datetrack_mode := hr_api.g_update;

5899: l_datetrack_mode := hr_api.g_update_override;
5900: --
5901: elsif l_update then
5902: --
5903: l_datetrack_mode := hr_api.g_update;
5904: --
5905: else
5906: --
5907: l_datetrack_mode := hr_api.g_correction;

Line 5907: l_datetrack_mode := hr_api.g_correction;

5903: l_datetrack_mode := hr_api.g_update;
5904: --
5905: else
5906: --
5907: l_datetrack_mode := hr_api.g_correction;
5908: --
5909: end if;
5910: --
5911: -- Update pil_id also since new row added due to current pil

Line 5921: IF l_datetrack_mode = hr_api.g_correction AND

5917: l_elig_flag := 'N';
5918: l_prtn_strt_dt := l_end_dt_plus_one;
5919: --
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

Line 5936: IF (l_datetrack_mode = hr_api.g_update_override) AND

5932: END IF;
5933:
5934: /* Bug 9020962: If future eligibility record exists, then insert the record
5935: in backup table ben_le_clsn_n_rstr */
5936: IF (l_datetrack_mode = hr_api.g_update_override) AND
5937: l_per_in_ler_id <> NVL(l_prev_per_in_ler_id,-1) THEN
5938: --
5939: open c_prev_pil(p_pil_row.per_in_ler_id);
5940: fetch c_prev_pil into l_prev_pil_id;