The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT status
FROM ies_transactions
WHERE transaction_id = :1' using p_transaction_id;
EXECUTE IMMEDIATE 'UPDATE ies_transactions SET status = 0 '||
'WHERE transaction_id = :1' USING p_transaction_id;
FND_MESSAGE.SET_NAME('IES', 'IES_STATUS_UPDATE_ERROR');