DBA Data[Home] [Help]

APPS.WMS_TASK_MGMT_PUB dependencies on INV_CONVERT

Line 1556: x_split_uom_quantities(i).secondary_quantity := inv_convert.inv_um_convert(item_id => l_mmtt_inventory_item_id ,

1552: x_split_uom_quantities(i).primary_quantity := p_split_quantities(i).quantity;
1553: x_split_uom_quantities(i).transaction_quantity := p_split_quantities(i).quantity;
1554: -- Added for Bug 16099247
1555: IF (l_tracking_quantity_ind='PS' AND p_split_quantities(i).secondary_qty is NULL) THEN
1556: x_split_uom_quantities(i).secondary_quantity := inv_convert.inv_um_convert(item_id => l_mmtt_inventory_item_id ,
1557: PRECISION => l_decimal_precision ,
1558: from_quantity => p_split_quantities(i).quantity ,
1559: from_unit => l_mmtt_item_primary_uom_code ,
1560: to_unit => l_mmtt_secondary_uom ,

Line 1575: x_split_uom_quantities(i).secondary_quantity := inv_convert.inv_um_convert(item_id => l_mmtt_inventory_item_id ,

1571: l_task_tbl_transaction_qty := p_split_quantities(i).quantity;
1572: x_split_uom_quantities(i).transaction_quantity := p_split_quantities(i).quantity;
1573: -- Added for Bug 16099247
1574: IF (l_tracking_quantity_ind='PS' AND p_split_quantities(i).secondary_qty is NULL) THEN
1575: x_split_uom_quantities(i).secondary_quantity := inv_convert.inv_um_convert(item_id => l_mmtt_inventory_item_id ,
1576: PRECISION => l_decimal_precision ,
1577: from_quantity => p_split_quantities(i).quantity ,
1578: from_unit => l_mmtt_transaction_uom ,
1579: to_unit => l_mmtt_secondary_uom ,

Line 1587: print_msg(l_procedure_name , ' mmtt transaction UOM quantity table UOM are not same, calling inv_convert.inv_um_convert with :');

1583: x_split_uom_quantities(i).secondary_quantity := p_split_quantities(i).secondary_qty;
1584: END IF;
1585: ELSE
1586: IF g_debug = 1 THEN
1587: print_msg(l_procedure_name , ' mmtt transaction UOM quantity table UOM are not same, calling inv_convert.inv_um_convert with :');
1588: print_msg(l_procedure_name, ' item_id : '||l_mmtt_inventory_item_id);
1589: print_msg(l_procedure_name, ' PRECISION : '|| l_decimal_precision);
1590: print_msg(l_procedure_name, ' from_quantity :'|| p_split_quantities(i).quantity);
1591: print_msg(l_procedure_name, ' from_unit :'||p_split_quantities(i).uom);

Line 1594: l_task_tbl_transaction_qty := inv_convert.inv_um_convert( item_id => l_mmtt_inventory_item_id ,

1590: print_msg(l_procedure_name, ' from_quantity :'|| p_split_quantities(i).quantity);
1591: print_msg(l_procedure_name, ' from_unit :'||p_split_quantities(i).uom);
1592: print_msg(l_procedure_name, ' to_unit :'||l_mmtt_transaction_uom);
1593: END IF;
1594: l_task_tbl_transaction_qty := inv_convert.inv_um_convert( item_id => l_mmtt_inventory_item_id ,
1595: PRECISION => l_decimal_precision ,
1596: from_quantity => p_split_quantities(i).quantity ,
1597: from_unit => p_split_quantities(i).uom ,
1598: to_unit => l_mmtt_transaction_uom ,

Line 1603: x_split_uom_quantities(i).secondary_quantity := inv_convert.inv_um_convert(item_id => l_mmtt_inventory_item_id ,

1599: from_name => NULL ,
1600: to_name => NULL );
1601: -- Added for Bug 16099247
1602: IF (l_tracking_quantity_ind='PS' AND p_split_quantities(i).secondary_qty is NULL) THEN
1603: x_split_uom_quantities(i).secondary_quantity := inv_convert.inv_um_convert(item_id => l_mmtt_inventory_item_id ,
1604: PRECISION => l_decimal_precision ,
1605: from_quantity => p_split_quantities(i).quantity ,
1606: from_unit => p_split_quantities(i).uom ,
1607: to_unit => l_mmtt_secondary_uom ,

Line 1630: x_split_uom_quantities(i).secondary_quantity := inv_convert.inv_um_convert(item_id => l_mmtt_inventory_item_id ,

1626: l_task_tbl_primary_qty := p_split_quantities(i).quantity;
1627: x_split_uom_quantities(i).primary_quantity := p_split_quantities(i).quantity;
1628: -- Added for Bug 16099247
1629: IF (l_tracking_quantity_ind='PS' AND p_split_quantities(i).secondary_qty is NULL) THEN
1630: x_split_uom_quantities(i).secondary_quantity := inv_convert.inv_um_convert(item_id => l_mmtt_inventory_item_id ,
1631: PRECISION => l_decimal_precision ,
1632: from_quantity => p_split_quantities(i).quantity ,
1633: from_unit => p_split_quantities(i).uom ,
1634: to_unit => l_mmtt_secondary_uom ,

Line 1650: l_task_tbl_primary_qty := inv_convert.inv_um_convert(item_id => l_mmtt_inventory_item_id ,

1646: print_msg(l_procedure_name, ' from_quantity :'|| p_split_quantities(i).quantity);
1647: print_msg(l_procedure_name, ' from_unit :'||p_split_quantities(i).uom);
1648: print_msg(l_procedure_name, ' to_unit :'||l_mmtt_transaction_uom);
1649: END IF;
1650: l_task_tbl_primary_qty := inv_convert.inv_um_convert(item_id => l_mmtt_inventory_item_id ,
1651: PRECISION => l_decimal_precision ,
1652: from_quantity => p_split_quantities(i).quantity ,
1653: from_unit => p_split_quantities(i).uom ,
1654: to_unit => l_mmtt_item_primary_uom_code ,

Line 1659: x_split_uom_quantities(i).secondary_quantity := inv_convert.inv_um_convert(item_id => l_mmtt_inventory_item_id ,

1655: from_name => NULL ,
1656: to_name => NULL);
1657: -- Added for Bug 16099247
1658: IF (l_tracking_quantity_ind='PS' AND p_split_quantities(i).secondary_qty is NULL) THEN
1659: x_split_uom_quantities(i).secondary_quantity := inv_convert.inv_um_convert(item_id => l_mmtt_inventory_item_id ,
1660: PRECISION => l_decimal_precision ,
1661: from_quantity => p_split_quantities(i).quantity ,
1662: from_unit => p_split_quantities(i).uom ,
1663: to_unit => l_mmtt_secondary_uom ,

Line 3587: l_umconvert_trans_quantity := inv_convert.inv_um_convert( item_id => l_mmtt_rec.inventory_item_id ,

3583: IF l_mmtt_rec.inventory_item_id IS NOT NULL AND l_mmtt_rec.transaction_uom IS NOT NULL THEN
3584: IF l_debug = 1 THEN
3585: debug_print( 'UOM Convert = ');
3586: END IF;
3587: l_umconvert_trans_quantity := inv_convert.inv_um_convert( item_id => l_mmtt_rec.inventory_item_id ,
3588: PRECISION => NULL ,
3589: from_quantity => p_transaction_quantity ,
3590: from_unit => l_mmtt_rec.transaction_uom ,
3591: to_unit => l_primary_uom ,

Line 3630: l_umconvert_trans_quantity := inv_convert.inv_um_convert( item_id => l_mmtt_rec.inventory_item_id ,

3626: debug_print( 'Allocation UOM = ' || l_mmtt_rec.transaction_uom);
3627: debug_print( 'Reservation UOM = ' || l_mtl_reservation_rec.reservation_uom_code);
3628: END IF;
3629: IF l_mmtt_rec.transaction_uom <> l_mtl_reservation_rec.reservation_uom_code THEN
3630: l_umconvert_trans_quantity := inv_convert.inv_um_convert( item_id => l_mmtt_rec.inventory_item_id ,
3631: PRECISION => NULL ,
3632: from_quantity => ABS(p_transaction_quantity) ,
3633: from_unit => l_mmtt_rec.transaction_uom ,
3634: to_unit => l_mtl_reservation_rec.reservation_uom_code ,

Line 4228: l_new_upd_resv_rec.reservation_quantity := l_rsv_qty - INV_Convert.inv_um_convert ( item_id => l_transaction_record.inventory_item_id,

4224: IF (l_rsv_qty > l_transaction_record.primary_quantity ) THEN
4225: l_old_upd_resv_rec.reservation_id := l_reservation_id ;
4226: l_new_upd_resv_rec.primary_reservation_quantity := l_pri_rsv_qty - l_transaction_record.primary_quantity ;
4227: IF (l_pri_rsv_uom <> l_rsv_uom ) THEN
4228: l_new_upd_resv_rec.reservation_quantity := l_rsv_qty - INV_Convert.inv_um_convert ( item_id => l_transaction_record.inventory_item_id,
4229: precision => null,
4230: from_quantity => l_transaction_record.primary_quantity ,
4231: from_unit => l_pri_rsv_uom,
4232: to_unit => l_rsv_uom,