The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT status
FROM ies_transactions
WHERE transaction_id = :1' using p_transaction_id;
PROCEDURE update_status_to_completed
(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_TRUE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_transaction_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30) := 'update_status_to_completed';
SAVEPOINT update_status_to_completed_sp;
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');
FND_MESSAGE.SET_NAME('IES', 'IES_STATUS_UPDATE_SUCCESS');
ROLLBACK TO update_status_to_completed_sp;
ROLLBACK TO update_status_to_completed_sp;
ROLLBACK TO update_status_to_completed_sp;
END update_status_to_completed;