The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select pri.rowid,
pri.transaction_id,
pri.source_type_code,
pri.source_organization_id,
pri.destination_organization_id,
pri.item_id,
pri.secondary_unit_of_measure,
pri.secondary_uom_code,
pri.secondary_quantity,
pri.quantity,
pri.preferred_grade
From po_requisitions_interface pri
Where pri.request_id = p_request_id
FOR UPDATE OF pri.secondary_unit_of_measure;
Select i.item_id,
i.item_no,
i.dualum_ind,
i.grade_ctl,
i.item_um,
i.item_um2
From ic_item_mst i,
mtl_system_items m
Where m.inventory_item_id = p_inv_item_id
And m.segment1 = i.item_no
And m.organization_id = p_organization_id;
SELECT mum.unit_of_measure
INTO l_passed_secondary_uom
FROM mtl_units_of_measure mum
WHERE mum.uom_code = cr_rec.secondary_uom_code;
UPDATE po_requisitions_interface pri
SET pri.secondary_unit_of_measure = l_secondary_unit_of_measure
WHERE rowid = cr_rec.rowid;
UPDATE po_requisitions_interface pri
SET pri.secondary_unit_of_measure = l_secondary_unit_of_measure
WHERE rowid = cr_rec.rowid;
UPDATE po_requisitions_interface
SET secondary_unit_of_measure = nvl(secondary_unit_of_measure,l_secondary_unit_of_measure),
secondary_quantity = l_secondary_quantity
WHERE rowid = cr_rec.rowid;
--if dual um 1 then update the secondary quantity since its fixed conversion.
ELSIF v_dualum_ind = 1 THEN
po_gml_db_common.VALIDATE_QUANTITY(
v_opm_item_id,
v_dualum_ind,
cr_rec.quantity,
v_item_um,
v_item_um2,
l_secondary_quantity) ;
UPDATE po_requisitions_interface
SET secondary_quantity = l_secondary_quantity
WHERE rowid = cr_rec.rowid;
Select qc_grade
Into v_qc_grade
From qc_grad_mst
Where qc_grade = cr_rec.preferred_grade
And delete_mark <> 1;
UPDATE po_requisitions_interface
SET secondary_quantity = NULL,
secondary_uom_code = NULL,
secondary_unit_of_measure = NULL
WHERE rowid = cr_rec.rowid;
UPDATE po_requisitions_interface
SET secondary_quantity = NULL,
secondary_uom_code = NULL,
secondary_unit_of_measure = NULL,
preferred_grade = NULL
WHERE rowid = cr_rec.rowid;
UPDATE po_requisitions_interface
SET secondary_quantity = NULL,
secondary_uom_code = NULL,
secondary_unit_of_measure = NULL,
preferred_grade = NULL
WHERE rowid = cr_rec.rowid;