[Home] [Help]
82: hire date then there will be a required change in the
83: assignment budget values.
84:
85: 110.6 22-MAY-98 Asahay 638603 modified update_hire_records
86: to update per_applications table
87: with DATE_END for those applicants
88: who are hired as EMPLOYEE and not
89: EMPLOYEE and APPLICANT.
90:
151: where pa.person_id = p_person_id
152: for update of person_id;
153: cursor app is
154: select 'application'
155: from per_applications pa
156: where pa.person_id = p_person_id
157: for update of person_id;
158: cursor per is
159: select 'person'
707: and a.person_id = p_person_id;
708: --
709: cursor app is
710: select application_id
711: from per_applications a
712: where a.person_id = p_person_id
713: and a.date_received = (
714: select max(a2.date_received)
715: from per_applications a2
711: from per_applications a
712: where a.person_id = p_person_id
713: and a.date_received = (
714: select max(a2.date_received)
715: from per_applications a2
716: where a2.person_id = a.person_id
717: and a2.date_received < p_start_date)
718: and not exists(select 1 --bug#2947287
719: from per_people_f peo
949: open app;
950: loop
951: fetch app into l_application_id;
952: exit when app%NOTFOUND;
953: update per_applications a1
954: set a1.date_end = p_start_date - 1
955: where a1.application_id = l_application_id
956: /* Fix for Bug 673066 */
957: and not exists (select 1
965: hr_utility.set_location('hr_date_chk.update_hire_records',25);
966:
967: if sql%rowcount <1 then
968: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
969: hr_utility.set_message_token('TABLE','PER_APPLICATIONS');
970: hr_utility.raise_error;
971: end if;
972: end loop;
973: close app;