The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT error_column,
error_message
FROM wip_txn_interface_errors
WHERE transaction_id = p_transaction_id;
SELECT group_id
INTO l_groupID
FROM wip_move_txn_interface
WHERE transaction_id = p_txn_id
AND process_phase = WIP_CONSTANTS.MOVE_VAL
AND process_status = WIP_CONSTANTS.RUNNING
AND group_id IS NOT NULL;
p_insertAssy => fnd_api.g_true,
p_do_backflush => l_do_backflush,
x_returnStatus => x_returnStatus);
p_insertAssy => fnd_api.g_true,
p_do_backflush => l_do_backflush,
x_returnStatus => x_returnStatus);