API for attached file
Is it safe to run the API for attached file even there is an command insert into FND_LOBS ??
DECLARE
l_rowid ROWID;
l_attached_document_id NUMBER;
l_document_id NUMBER;
l_seq_num NUMBER;
l_category_name VARCHAR2 (100) := 'Miscellaneous';
l_category_id NUMBER;
l_security_id NUMBER;
l_filename VARCHAR2 (240);
l_pk1_value NUMBER;
l_entity_name VARCHAR2 (100) := 'PER_PEOPLE_F';
l_file BFILE;
l_file_exists NUMBER := 0;
l_file_size NUMBER;
l_media_id NUMBER;
l_dstn_file BLOB;
mess_error VARCHAR2 (4000);
CURSOR main_cur
IS
SELECT ROWID,
PERSON_ID,
EMPLOYEE_NUMBER,
FULL_NAME,
FILE_NAME,
STATUS,