125:
126:
127: CURSOR get_uom_class (p_uom_code VARCHAR2) IS
128: SELECT uom_class
129: FROM mtl_units_of_measure
130: WHERE uom_code = p_uom_code;
131:
132: l_from_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
133: l_to_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
128: SELECT uom_class
129: FROM mtl_units_of_measure
130: WHERE uom_code = p_uom_code;
131:
132: l_from_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
133: l_to_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
134: l_ret NUMBER;
135: l_revision NUMBER;
136:
129: FROM mtl_units_of_measure
130: WHERE uom_code = p_uom_code;
131:
132: l_from_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
133: l_to_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
134: l_ret NUMBER;
135: l_revision NUMBER;
136:
137: l_header_id NUMBER := NULL;
419: l_secondary_quantity NUMBER;
420: l_old_primary_quantity NUMBER;
421: l_old_secondary_quantity NUMBER;
422: l_batch_txn_qty NUMBER;
423: l_transaction_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
424:
425: BEGIN
426:
427: x_return_status := FND_API.G_RET_STS_SUCCESS;
539: CLOSE get_lot_transactions;
540:
541: SELECT uom_class
542: INTO l_transaction_uom_class
543: FROM mtl_units_of_measure_vl
544: WHERE uom_code = x_batch_txns.transaction_uom;
545:
546: i:=1;
547: l_batch_txn_qty := 0;