1268: open c1 ;
1269: fetch c1 into l_dummy ;
1270: if c1%found then
1271: -- ER FPT
1272: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then
1273: open c2;
1274: fetch c2 into l_dummy;
1275: if c2%found then
1276: hr_utility.set_message(801,'HR_6385_APP_TERM_FUT_CHANGES' );
1669: P_end_of_time DATE) IS
1670: --
1671: BEGIN
1672: -- ER FPT
1673: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'N') then
1674:
1675: DELETE FROM per_all_people_f papf
1676: WHERE papf.person_id = P_person_id
1677: AND papf.business_group_id + 0 = P_Business_group_id
2462: BEGIN
2463: hr_utility.set_location('per_applications_pkg.update_row',10);
2464:
2465: -- ER FPT
2466: IF (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then
2467: -- Reverse Terminating the End Application
2468: if p_date_end is null then
2469: -- looping through the future APL
2470: for apl in future_apln loop