DBA Data[Home] [Help]

APPS.INV_TRX_UTIL_PUB dependencies on INV_CONVERT

Line 1494: l_primary_qty := inv_convert.inv_um_convert(

1490: END IF;
1491: CLOSE c_item_info;
1492:
1493: IF l_primary_qty IS NULL THEN
1494: l_primary_qty := inv_convert.inv_um_convert(
1495: item_id => l_inventory_item_id
1496: , precision => NULL
1497: , from_quantity => l_txn_qty
1498: , from_unit => l_transaction_uom

Line 1512: l_txn_qty := inv_convert.inv_um_convert(

1508: fnd_msg_pub.ADD;
1509: RAISE fnd_api.g_exc_error;
1510: END IF;
1511: ELSIF l_txn_qty IS NULL AND l_primary_qty IS NOT NULL THEN
1512: l_txn_qty := inv_convert.inv_um_convert(
1513: item_id => l_inventory_item_id
1514: , precision => NULL
1515: , from_quantity => l_primary_qty
1516: , from_unit => l_primary_uom

Line 2363: , p.transaction_quantity - inv_convert.inv_um_convert(l_item_id, NULL, SUM(c.transaction_quantity), l_child_uom, l_parent_uom, NULL, NULL)

2359:
2360: UPDATE mtl_transaction_lots_temp p
2361: SET (p.primary_quantity, p.transaction_quantity, p.secondary_quantity) =
2362: (SELECT p.primary_quantity - SUM(c.primary_quantity)
2363: , p.transaction_quantity - inv_convert.inv_um_convert(l_item_id, NULL, SUM(c.transaction_quantity), l_child_uom, l_parent_uom, NULL, NULL)
2364: , p.secondary_quantity - SUM(c.secondary_quantity) --BUG12753174
2365: FROM mtl_transaction_lots_temp c
2366: WHERE c.transaction_temp_id = p_child_line_id
2367: AND c.lot_number = l_lot_number

Line 2379: , p.transaction_quantity - inv_convert.inv_um_convert(l_item_id, NULL, SUM(c.transaction_quantity), l_child_uom, l_parent_uom, NULL, NULL)

2375: /*
2376: UPDATE mtl_transaction_lots_temp p
2377: SET (p.primary_quantity, p.transaction_quantity) =
2378: (SELECT p.primary_quantity - SUM(c.primary_quantity)
2379: , p.transaction_quantity - inv_convert.inv_um_convert(l_item_id, NULL, SUM(c.transaction_quantity), l_child_uom, l_parent_uom, NULL, NULL)
2380: FROM mtl_transaction_lots_temp c
2381: WHERE c.transaction_temp_id = p_child_line_id
2382: AND c.lot_number = p.lot_number
2383: GROUP BY c.lot_number)

Line 2397: 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)

2393: TRACE('Updating the Parent Task with Txn Temp ID = ' || p_parent_line_id, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2394: END IF;
2395:
2396: UPDATE mtl_material_transactions_temp
2397: 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)
2398: , primary_quantity = primary_quantity - l_child_pri_qty
2399: , secondary_transaction_quantity = secondary_transaction_quantity - l_child_sec_txn_qty --BUG12753174
2400: WHERE transaction_temp_id = p_parent_line_id
2401: RETURNING primary_quantity INTO l_parent_pri_qty;