Monday, September 3, 2012

API to Create Document of Records



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