Technology Stack - EBS (MOSC)

MOSC Banner

API for attached file

edited Feb 13, 2019 4:02AM in Technology Stack - EBS (MOSC) 4 commentsAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center