[Home] [Help]
1361: END IF;
1362: CLOSE c_item_info;
1363:
1364: IF l_primary_qty IS NULL THEN
1365: l_primary_qty := inv_convert.inv_um_convert(
1366: item_id => l_inventory_item_id
1367: , precision => NULL
1368: , from_quantity => l_txn_qty
1369: , from_unit => l_transaction_uom
1379: fnd_msg_pub.ADD;
1380: RAISE fnd_api.g_exc_error;
1381: END IF;
1382: ELSIF l_txn_qty IS NULL AND l_primary_qty IS NOT NULL THEN
1383: l_txn_qty := inv_convert.inv_um_convert(
1384: item_id => l_inventory_item_id
1385: , precision => NULL
1386: , from_quantity => l_primary_qty
1387: , from_unit => l_primary_uom
2181: IF p_lot_control_code = 2 THEN
2182: UPDATE mtl_transaction_lots_temp p
2183: SET (p.primary_quantity, p.transaction_quantity) =
2184: (SELECT p.primary_quantity - SUM(c.primary_quantity)
2185: , p.transaction_quantity - inv_convert.inv_um_convert(l_item_id, NULL, SUM(c.transaction_quantity), l_child_uom, l_parent_uom, NULL, NULL)
2186: FROM mtl_transaction_lots_temp c
2187: WHERE c.transaction_temp_id = p_child_line_id
2188: AND c.lot_number = p.lot_number
2189: GROUP BY c.lot_number)
2198: TRACE('Updating the Parent Task with Txn Temp ID = ' || p_parent_line_id, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2199: END IF;
2200:
2201: UPDATE mtl_material_transactions_temp
2202: SET transaction_quantity = transaction_quantity - inv_convert.inv_um_convert(inventory_item_id, NULL, l_child_txn_qty, l_child_uom, transaction_uom, NULL, NULL)
2203: , primary_quantity = primary_quantity - l_child_pri_qty
2204: WHERE transaction_temp_id = p_parent_line_id
2205: RETURNING primary_quantity INTO l_parent_pri_qty;
2206: