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
,P_INV_POS_GRADE_WARNING =>P_INV_POS_GRADE_WARNING
,P_INV_JOB_GRADE_WARNING =>P_INV_JOB_GRADE_WARNING
);
dbms_output.put_line(‘vacancy ‘||r.name||’ closed’);
exception when others then
err_msg := sqlerrm;
dbms_output.put_line(‘Exception ‘||err_msg);
end;
end loop;

end;