Tag Archives: PER_VACANCY_API

Vacancy Update API (PER_VACANCY_API.update_vacancy)

By | December 20, 2016

declare P_ASSIGNMENT_CHANGED boolean; p_inv_pos_grade_warning boolean; p_inv_job_grade_warning boolean; err_msg varchar2(500); cursor c1 is select vacancy_id,object_version_number,status,name from PER_ALL_VACANCIES where name = ‘IRC10377’; begin for r in c1 loop dbms_output.put_line(‘start’); begin PER_VACANCY_API.update_vacancy ( P_VALIDATE => FALSE , P_EFFECTIVE_DATE => TRUNC(SYSDATE) , P_VACANCY_ID =>r.vacancy_id , P_OBJECT_VERSION_NUMBER =>r.OBJECT_VERSION_NUMBER , P_DATE_TO => TRUNC(SYSDATE) , P_STATUS => ‘CLOSED’ , P_ASSIGNMENT_CHANGED => P_ASSIGNMENT_CHANGED… Read More »