[Home] [Help]
346: l_uom_code := p_uom_code;
347: END IF;
348:
349: l_progress := '300';
350: x_secondary_quantity := inv_convert.inv_um_convert(
351: p_inventory_item_id
352: , g_precision
353: , p_quantity
354: , l_uom_code
481: l_progress := '100';
482: IF ( l_ont_pricing_qty_source = G_PRICE_SECONDARY AND
483: (l_uom_deviation_high IS NOT NULL OR l_uom_deviation_low IS NOT NULL) ) THEN
484: l_progress := '200';
485: l_converted_qty := inv_convert.inv_um_convert(
486: p_inventory_item_id
487: , 6
488: , p_quantity
489: , l_uom_code
850: l_attr_counter := l_attr_counter + 1;
851: END IF;
852: ELSE
853: IF ( wdd_rec.requested_quantity_uom <> p_uom_code ) THEN
854: l_line_quantity := inv_convert.inv_um_convert(
855: p_inventory_item_id
856: , 6
857: , wdd_rec.picked_quantity
858: , wdd_rec.requested_quantity_uom
1094: print_debug('Got from MMTT trxtempid='||mmtt_rec.transaction_temp_id||' trxqty='||mmtt_rec.transaction_quantity||' trxuom='||mmtt_rec.transaction_uom, 4);
1095: END IF;
1096:
1097: IF ( mmtt_rec.transaction_uom <> p_uom_code ) THEN
1098: l_line_quantity := inv_convert.inv_um_convert(
1099: p_inventory_item_id
1100: , 6
1101: , mmtt_rec.transaction_quantity
1102: , mmtt_rec.transaction_uom
1156: print_debug('Got form MTLT lottrxqty='||mtlt_rec.transaction_quantity, 4);
1157: END IF;
1158:
1159: IF ( mmtt_rec.transaction_uom <> p_uom_code ) THEN
1160: l_line_quantity := inv_convert.inv_um_convert(
1161: p_inventory_item_id
1162: , 6
1163: , mtlt_rec.transaction_quantity
1164: , mmtt_rec.transaction_uom
1383: -- Check that there is a valid uom conversin between primary and secondary.
1384: IF ( wdd_item_rec.primary_uom_code <> l_prev_pri_uom OR
1385: wdd_item_rec.secondary_uom_code <> l_prev_sec_uom ) THEN
1386: -- Call UOM API to check that there is a valid conversion rate
1387: INV_CONVERT.inv_um_conversion (
1388: from_unit => wdd_item_rec.primary_uom_code
1389: , to_unit => wdd_item_rec.secondary_uom_code
1390: , item_id => wdd_item_rec.inventory_item_id
1391: , uom_rate => l_uom_conv_rate );
1440: -- if item can defaulted check uom conversion to make sure it is valid
1441: IF ( l_default_ind = G_SECONDARY_DEFAULT ) THEN
1442: IF ( l_prev_pri_uom <> l_pri_uom OR l_prev_sec_uom <> l_sec_uom ) THEN
1443: -- Call UOM API to check that there is a valid conversion rate
1444: INV_CONVERT.inv_um_conversion (
1445: from_unit => l_pri_uom
1446: , to_unit => l_sec_uom
1447: , item_id => mmtt_item_rec.inventory_item_id
1448: , uom_rate => l_uom_conv_rate );
1496: -- Check UOM conversion to make sure it's valid
1497: IF ( l_temp = 0 AND l_default_ind = G_SECONDARY_DEFAULT ) THEN
1498: IF ( l_prev_pri_uom <> l_pri_uom OR l_prev_sec_uom <> l_sec_uom ) THEN
1499: -- Call UOM API to check that there is a valid conversion rate
1500: INV_CONVERT.inv_um_conversion (
1501: from_unit => l_pri_uom
1502: , to_unit => l_sec_uom
1503: , item_id => mmtt_item_rec.inventory_item_id
1504: , uom_rate => l_uom_conv_rate );
2286: , x_msg_count OUT NOCOPY NUMBER
2287: ) RETURN NUMBER IS
2288:
2289: CURSOR itemCur IS
2290: SELECT sum(inv_convert.inv_um_convert(wdd.inventory_item_id,
2291: 6,
2292: wdd.REQUESTED_QUANTITY,
2293: wdd.REQUESTED_QUANTITY_UOM,
2294: --msib.primary_uom_code,
2339: END IF;
2340:
2341: l_progress := '10';
2342:
2343: /**l_pri_input_qty := inv_convert.inv_um_convert(p_from_item_id,
2344: 6,
2345: p_from_item_pri_qty,
2346: p_from_item_pri_uom,
2347: p_from_item_pri_uom,
2510: IF (item_rec.secondary_default_ind = G_SECONDARY_DEFAULT AND item_rec.picked_quantity2 IS NULL) THEN
2511:
2512: --call the defaulting logic and see if the return < 0
2513:
2514: INV_CONVERT.inv_um_conversion (
2515: from_unit => item_rec.primary_uom_code
2516: , to_unit => item_rec.secondary_uom_code
2517: , item_id => item_rec.inventory_item_id
2518: , uom_rate => l_uom_conv_rate );