DECLARE
l_document_extra_info_id NUMBER := NULL;
l_object_version_number NUMBER := NULL;
BEGIN
hr_document_extra_info_api.create_doc_extra_info (
p_validate => FALSE,
p_person_id => 88247,
p_document_type_id => 4,
p_date_from => TO_DATE ('10-JUN-2012', 'DD-MON-YYYY'),
p_date_to => TO_DATE ('10-JUN-2012', 'DD-MON-YYYY'),
p_document_number => 'B009232',
p_document_extra_info_id => l_document_extra_info_id,
p_object_version_number => l_object_version_number
);
COMMIT;
DBMS_OUTPUT.put_line ('SUCCESS');
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ('FAILURE ' || SQLERRM);
END;
No comments:
Post a Comment