The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_delete_stack => fnd_api.g_false,
p_separator => ' ');
update mtl_material_transactions_temp
set process_flag = 'E',
error_code = substr(l_errCode,1,240),
error_explanation = substr(x_errorMsg,1,240)
where transaction_header_id = p_txnHdrID
and process_flag in ('Y', 'W')
and transaction_source_type_id = 5
and transaction_action_id in (wip_constants.isscomp_action,
wip_constants.retcomp_action,
wip_constants.issnegc_action,
wip_constants.retnegc_action);
select transaction_source_type_id,
wip_entity_type,
transaction_source_id,
organization_id,
transaction_action_id
into l_txnSrcTypID,
l_wipEntityType,
l_wipEntityID,
l_orgID,
l_txnActionID
from mtl_material_transactions_temp
where transaction_temp_id = p_txnTmpID;
select entity_type
into l_wipEntityType
from wip_entities
where wip_entity_id = l_wipEntityID
and organization_id = l_orgID;