DBA Data[Home] [Help]

APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on INV_CONVERT

Line 145: l_qty_picked := INV_Convert.INV_UM_Convert(

141: IF (l_debug = 1) THEN
142: mdebug('uom_code '|| l_trans_uom);
143: END IF;
144:
145: l_qty_picked := INV_Convert.INV_UM_Convert(
146: item_id => l_item_id,
147: precision => null,
148: from_quantity => l_qty_picked,
149: from_unit => l_picked_uom,

Line 1562: l_new_sec_qty_detailed := INV_Convert.inv_um_convert

1558: mdebug('l_new_sec_qty_detailed '||l_new_sec_qty_detailed);
1559: mdebug('l_old_sec_qty_detailed '||l_old_sec_qty_detailed);
1560: mdebug('The new qty detailed for MTRL will be old qty detailed - MMTT txn qty');
1561: IF(l_new_sec_qty_detailed <= 0 AND NVL(l_fulfillment_base, 'P') = 'P') THEN --Can happen for items with deviations
1562: l_new_sec_qty_detailed := INV_Convert.inv_um_convert
1563: (item_id => l_item_id,
1564: precision => null,
1565: from_quantity => l_new_quantity_detailed,
1566: from_unit => l_trolin_rec.uom_code,

Line 1571: l_new_quantity_detailed := INV_Convert.inv_um_convert

1567: to_unit => l_sec_uom_code,
1568: from_name => null,
1569: to_name => null);
1570: ELSIF(l_new_quantity_detailed <= 0 AND NVL(l_fulfillment_base, 'P') = 'S') THEN --Can happen for items with deviations
1571: l_new_quantity_detailed := INV_Convert.inv_um_convert
1572: (item_id => l_item_id,
1573: precision => null,
1574: from_quantity => l_new_sec_qty_detailed,
1575: from_unit => l_trolin_rec.uom_code,

Line 1595: l_new_sec_qty_detailed := INV_Convert.inv_um_convert

1591:
1592: IF (l_sec_uom_code IS NOT NULL) THEN --{dual uom item
1593: l_new_sec_qty_detailed := l_old_sec_qty_detailed - l_secondary_quantity;
1594: IF(l_new_sec_qty_detailed <= 0) THEN --Can happen for items with deviations
1595: l_new_sec_qty_detailed := INV_Convert.inv_um_convert
1596: (item_id => l_item_id,
1597: precision => null,
1598: from_quantity => l_new_quantity_detailed,
1599: from_unit => l_primary_uom,

Line 1618: l_new_quantity_detailed := l_old_quantity_detailed - INV_Convert.inv_um_convert

1614: ELSE
1615: IF (NVL(l_fulfillment_base, 'P') = 'S') THEN--{
1616: l_new_sec_qty_detailed := l_old_sec_qty_detailed - l_secondary_quantity;
1617:
1618: l_new_quantity_detailed := l_old_quantity_detailed - INV_Convert.inv_um_convert
1619: (item_id => l_item_id,
1620: precision => null,
1621: from_quantity => l_secondary_quantity,
1622: from_unit => l_sec_uom_code,

Line 1628: l_new_quantity_detailed := INV_Convert.inv_um_convert

1624: from_name => null,
1625: to_name => null);
1626:
1627: IF(l_new_quantity_detailed <= 0) THEN
1628: l_new_quantity_detailed := INV_Convert.inv_um_convert
1629: (item_id => l_item_id,
1630: precision => null,
1631: from_quantity => l_new_sec_qty_detailed,
1632: from_unit => l_sec_uom_code,

Line 1639: l_mol_delta_qty := INV_Convert.inv_um_convert

1635: to_name => null);
1636: END IF;
1637:
1638: ELSE
1639: l_mol_delta_qty := INV_Convert.inv_um_convert
1640: (item_id => l_item_id,
1641: precision => null,
1642: from_quantity => l_transaction_qty,
1643: from_unit => l_mmtt_transaction_uom,

Line 1653: l_new_sec_qty_detailed := INV_Convert.inv_um_convert

1649:
1650: IF (l_sec_uom_code IS NOT NULL) THEN --{dual uom item
1651: l_new_sec_qty_detailed := l_old_sec_qty_detailed - l_secondary_quantity;
1652: IF(l_new_sec_qty_detailed <= 0) THEN--{
1653: l_new_sec_qty_detailed := INV_Convert.inv_um_convert
1654: (item_id => l_item_id,
1655: precision => null,
1656: from_quantity => l_new_quantity_detailed,
1657: from_unit => l_trolin_rec.uom_code,

Line 1822: l_sec_detailed_qty := inv_convert.inv_um_convert

1818:
1819: if (l_move_order_type <> 3 ) then
1820: -- Bug 8312574
1821: IF ( l_trolin_rec.secondary_uom IS NOT NULL AND l_sec_detailed_qty <=0) THEN --16070349 raminoch
1822: l_sec_detailed_qty := inv_convert.inv_um_convert
1823: ( item_id => l_trolin_rec.inventory_item_id,
1824: precision => null,
1825: from_quantity => l_detailed_qty,
1826: from_unit => l_trolin_rec.uom_code,

Line 2556: l_txn_qty := inv_convert.inv_um_convert(

2552: l_txn_qty := l_sec_txn_qty;
2553: ELSIF(l_mtrl_uom = l_mmtt_transaction_uom) THEN
2554: l_txn_qty := l_txn_qty;
2555: ELSE
2556: l_txn_qty := inv_convert.inv_um_convert(
2557: item_id => l_item_id,
2558: precision => null,
2559: from_quantity => l_txn_qty,
2560: from_unit => l_mmtt_transaction_uom,

Line 2573: l_txn_qty := INV_Convert.inv_um_convert

2569: mdebug ('l_txn_qty : ' || l_txn_qty );
2570: END IF;
2571: /* IF (l_mtrl_uom <> l_mmtt_transaction_uom)
2572: THEN
2573: l_txn_qty := INV_Convert.inv_um_convert
2574: (item_id => l_item_id,
2575: precision => null,
2576: from_quantity => l_txn_qty,
2577: from_unit => l_mmtt_transaction_uom,

Line 2648: l_new_upd_resv_rec.primary_reservation_quantity := inv_convert.inv_um_convert (

2644: l_new_upd_resv_rec.secondary_reservation_quantity := 0;
2645: END IF;
2646:
2647: IF(l_new_upd_resv_rec.primary_reservation_quantity < 0 AND NVL(l_fulfillment_base, 'P') = 'S') THEN
2648: l_new_upd_resv_rec.primary_reservation_quantity := inv_convert.inv_um_convert (
2649: item_id => l_item_id,
2650: lot_number => l_rsv_lot_num,
2651: organization_id => l_rsv_org_id,
2652: precision => null,

Line 2666: l_new_upd_resv_rec.reservation_quantity := l_rsv_qty - inv_convert.inv_um_convert (

2662: ELSIF(l_sec_rsv_uom = l_rsv_uom) THEN
2663: l_new_upd_resv_rec.reservation_quantity := l_rsv_qty - l_sec_txn_qty;
2664: ELSE
2665: IF(NVL(l_fulfillment_base, 'P') = 'S') THEN
2666: l_new_upd_resv_rec.reservation_quantity := l_rsv_qty - inv_convert.inv_um_convert (
2667: item_id => l_item_id,
2668: lot_number => l_rsv_lot_num,
2669: organization_id => l_rsv_org_id,
2670: precision => null,

Line 2677: l_new_upd_resv_rec.reservation_quantity := l_rsv_qty - inv_convert.inv_um_convert (

2673: to_unit => l_rsv_uom,
2674: from_name => null,
2675: to_name => null);
2676: ELSE
2677: l_new_upd_resv_rec.reservation_quantity := l_rsv_qty - inv_convert.inv_um_convert (
2678: item_id => l_item_id,
2679: lot_number => l_rsv_lot_num,
2680: organization_id => l_rsv_org_id,
2681: precision => null,