APPS.GMA_PURGE_UTILITIES SQL Statements

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

Line: 14

    INSERT INTO sy_purg_err
      ( purge_id
      , line_no
      , creation_date
      , created_by
      , last_updated_by
      , last_update_date
      , text)
      VALUES
      ( NVL(p_purge_id,0)
      , sy_purg_err_line_seq.nextval
      , sysdate
      , NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),0)
      , NVL(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),0)
      , sysdate
      , NVL(SUBSTR(p_text,1,80),' ')
      );