APPS.IES_TRANSACTIONS_PKG SQL Statements

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

Line: 14

   SELECT status
     FROM ies_transactions
    WHERE transaction_id = :1' using  p_transaction_id;

Line: 60

      EXECUTE IMMEDIATE 'UPDATE ies_transactions SET status = 0 '||
                    'WHERE transaction_id = :1' USING p_transaction_id;

Line: 63

  	 FND_MESSAGE.SET_NAME('IES', 'IES_STATUS_UPDATE_ERROR');