APPS.IEX_LOAD_FILE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7

Procedure UPDATE_AMV_ATTACH1
           (p_file_id             IN NUMBER )
IS
   l_attachment_id         NUMBER;

Line: 16

   Update jtf_amv_attachments
      set file_id = p_file_id
    where attachment_id = l_attachment_id
     and application_id = 695;

Line: 21

   UPDATE_FILE_NAME(p_file_id);

Line: 23

END UPDATE_AMV_ATTACH1;

Line: 26

Procedure UPDATE_AMV_ATTACH2
           (p_file_id             IN NUMBER )
IS
   l_attachment_id         NUMBER;

Line: 35

   Update jtf_amv_attachments
      set file_id = p_file_id
    where attachment_id = l_attachment_id
     and application_id = 695;

Line: 40

   UPDATE_FILE_NAME(p_file_id);

Line: 42

END UPDATE_AMV_ATTACH2;

Line: 45

Procedure UPDATE_AMV_ATTACH3
           (p_file_id             IN NUMBER )
IS
   l_attachment_id         NUMBER;

Line: 54

   Update jtf_amv_attachments
      set file_id = p_file_id
    where attachment_id = l_attachment_id
     and application_id = 695;

Line: 59

   UPDATE_FILE_NAME(p_file_id);

Line: 61

END UPDATE_AMV_ATTACH3;

Line: 64

Procedure UPDATE_AMV_ATTACH4
           (p_file_id             IN NUMBER )
IS
   l_attachment_id         NUMBER;

Line: 73

   Update jtf_amv_attachments
      set file_id = p_file_id
    where attachment_id = l_attachment_id
     and application_id = 695;

Line: 78

   UPDATE_FILE_NAME(p_file_id);

Line: 80

END UPDATE_AMV_ATTACH4;

Line: 83

Procedure UPDATE_AMV_ATTACH5
           (p_file_id             IN NUMBER )
IS
   l_attachment_id         NUMBER;

Line: 92

   Update jtf_amv_attachments
      set file_id = p_file_id
    where attachment_id = l_attachment_id
     and application_id = 695;

Line: 97

   UPDATE_FILE_NAME(p_file_id);

Line: 99

END UPDATE_AMV_ATTACH5;

Line: 102

Procedure UPDATE_FILE_NAME
           (p_file_id             IN NUMBER )
IS
  CURSOR C_GET_FileName (IN_ID NUMBER) IS
    SELECT substr(file_name, instr(file_name, '/IEXFm')+1, length(file_name)-instr(file_name,'/IEXFm') )
      FROM fnd_lobs
     WHERE file_id = IN_ID;

Line: 123

   Update fnd_lobs
      set file_name = l_file_name
    where file_id = p_file_id;

Line: 127

END UPDATE_FILE_NAME;