DECLARE
v_event_id NUMBER (10);
v_object_version_number NUMBER (10);
BEGIN
per_events_api.create_event
(p_validate => FALSE,
p_date_start => TRUNC (SYSDATE)
+ 10,
p_type => 'ENGLISH TEST',
p_business_group_id => 44,--HR/TCA merge
p_assignment_id => 81646,
p_date_end => TRUNC (SYSDATE)
p_emp_or_apl => 'A',
p_event_or_interview => 'I',
p_attribute_category => 'English Test',
p_attribute2 => '150',
p_event_id => v_event_id,
p_object_version_number => v_object_version_number
);
DBMS_OUTPUT.put_line ('v_event_id=' || v_event_id);
DBMS_OUTPUT.put_line ('v_object_version_number=' || v_object_version_number);
COMMIT;
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line (SQLERRM);
END;
No comments:
Post a Comment