DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PVT dependencies on INV_CONVERT

Line 826: l_quantity_to_detail := inv_convert.inv_um_convert(

822: l_lot_divisible_flag := 'Y';
823: END IF;
824:
825: IF (l_primary_uom <> p_mo_line_rec.uom_code) THEN
826: l_quantity_to_detail := inv_convert.inv_um_convert(
827: item_id => p_mo_line_rec.inventory_item_id
828: , PRECISION => NULL
829: , from_quantity => l_qty_to_detail_unconv
830: , from_unit => p_mo_line_rec.uom_code

Line 905: l_order_line_qty := inv_convert.inv_um_convert(

901: print_debug('l_order_line_uom = ' ||l_order_line_uom, 'Inv_Pick_Release_PVT.Process_Reservations');
902: END IF;
903:
904: IF (l_primary_uom <> l_order_line_uom) THEN
905: l_order_line_qty := inv_convert.inv_um_convert(
906: item_id => p_mo_line_rec.inventory_item_id
907: , PRECISION => NULL
908: , from_quantity => l_order_line_qty_unconv
909: , from_unit => l_order_line_uom

Line 976: l_unreserved_quantity := inv_convert.inv_um_convert(

972: l_unreserved_quantity := l_quantity_to_detail - l_reserved_quantity;
973: l_sec_unreserved_quantity := l_sec_quantity_to_detail - l_sec_reserved_quantity;
974: -- BUG 16444577
975: IF (l_fulfill_base = 'S') THEN
976: l_unreserved_quantity := inv_convert.inv_um_convert(
977: item_id => p_mo_line_rec.inventory_item_id
978: , PRECISION => NULL
979: , from_quantity => l_sec_unreserved_quantity
980: , from_unit => l_secondary_uom

Line 1244: l_new_rsv_quantity := inv_convert.inv_um_convert(

1240: ELSIF l_fulfill_base = 'S' AND l_demand_rsvs_ordered(l_index).reservation_uom_code = l_secondary_uom THEN
1241: l_new_rsv_quantity := l_new_sec_rsv_quantity;
1242: ELSIF l_fulfill_base = 'S' AND l_demand_rsvs_ordered(l_index).reservation_uom_code <> l_secondary_uom AND l_demand_rsvs_ordered(l_index).reservation_uom_code <> l_primary_uom THEN
1243:
1244: l_new_rsv_quantity := inv_convert.inv_um_convert(
1245: item_id => p_mo_line_rec.inventory_item_id
1246: , PRECISION => NULL
1247: , from_quantity => l_new_sec_rsv_quantity
1248: , from_unit => l_secondary_uom

Line 1265: l_new_rsv_quantity := inv_convert.inv_um_convert(

1261: fnd_msg_pub.ADD;
1262: RAISE fnd_api.g_exc_unexpected_error;
1263: END IF;
1264: ELSE
1265: l_new_rsv_quantity := inv_convert.inv_um_convert(
1266: item_id => p_mo_line_rec.inventory_item_id
1267: , PRECISION => NULL
1268: , from_quantity => l_new_prim_rsv_quantity
1269: , from_unit => l_primary_uom

Line 1405: l_update_rsv_rec.reservation_quantity := inv_convert.inv_um_convert(item_id=> l_update_rsv_rec.inventory_item_id

1401: l_update_rsv_rec.reservation_quantity := l_quantity_to_reserve;
1402: ELSIF l_update_rsv_rec.reservation_uom_code = l_secondary_uom THEN
1403: l_update_rsv_rec.reservation_quantity := l_sec_quantity_to_reserve;
1404: ELSE
1405: l_update_rsv_rec.reservation_quantity := inv_convert.inv_um_convert(item_id=> l_update_rsv_rec.inventory_item_id
1406: , lot_number => l_update_rsv_rec.lot_number
1407: , organization_id => l_update_rsv_rec.organization_id
1408: , PRECISION => NULL -- use default precision
1409: , from_quantity => l_quantity_to_reserve

Line 2817: l_quantity_detailed_conv := inv_convert.inv_um_convert(

2813: IF (is_debug) THEN
2814: print_debug('Move Order line UOM '||p_mo_line_rec.uom_code || 'Pri UOM:'|| l_primary_uom,'Inv_Pick_Release_PVT.Process_Line');
2815: END IF;
2816: IF (p_mo_line_rec.uom_code <> l_primary_uom ) THEN
2817: l_quantity_detailed_conv := inv_convert.inv_um_convert(
2818: item_id => p_mo_line_rec.inventory_item_id
2819: , PRECISION => NULL
2820: , from_quantity => l_quantity_detailed
2821: , from_unit => l_primary_uom

Line 3079: l_new_rsv_quantity := inv_convert.inv_um_convert(

3075: l_new_rsv_quantity := l_new_prim_rsv_quantity;
3076: ELSIF l_fulfill_base = 'S' and l_demand_rsvs_ordered(l_index).reservation_uom_code = l_secondary_uom THEN
3077: l_new_rsv_quantity := l_new_sec_rsv_quantity;
3078: ELSIF l_fulfill_base = 'S' AND l_demand_rsvs_ordered(l_index).reservation_uom_code <> l_secondary_uom AND l_demand_rsvs_ordered(l_index).reservation_uom_code <> l_primary_uom THEN
3079: l_new_rsv_quantity := inv_convert.inv_um_convert(
3080: item_id => p_mo_line_rec.inventory_item_id
3081: , PRECISION => NULL
3082: , from_quantity => l_new_sec_rsv_quantity
3083: , from_unit => l_secondary_uom

Line 3100: l_new_rsv_quantity := inv_convert.inv_um_convert(

3096: fnd_msg_pub.ADD;
3097: RAISE fnd_api.g_exc_unexpected_error;
3098: END IF;
3099: ELSE
3100: l_new_rsv_quantity := inv_convert.inv_um_convert(
3101: item_id => p_mo_line_rec.inventory_item_id
3102: , PRECISION => NULL
3103: , from_quantity => l_new_prim_rsv_quantity
3104: , from_unit => l_primary_uom

Line 3220: l_new_rsv_quantity := inv_convert.inv_um_convert(

3216: l_new_rsv_quantity := l_new_prim_rsv_quantity;
3217: ELSIF l_fulfill_base = 'S' and l_demand_rsvs_ordered(l_res_ordered_index).reservation_uom_code = l_secondary_uom THEN
3218: l_new_rsv_quantity := l_new_sec_rsv_quantity;
3219: ELSIF l_fulfill_base = 'S' AND l_demand_rsvs_ordered(l_res_ordered_index).reservation_uom_code <> l_secondary_uom AND l_demand_rsvs_ordered(l_res_ordered_index).reservation_uom_code <> l_primary_uom THEN
3220: l_new_rsv_quantity := inv_convert.inv_um_convert(
3221: item_id => p_mo_line_rec.inventory_item_id
3222: , PRECISION => NULL
3223: , from_quantity => l_new_sec_rsv_quantity
3224: , from_unit => l_secondary_uom

Line 3241: l_new_rsv_quantity := inv_convert.inv_um_convert(

3237: fnd_msg_pub.ADD;
3238: RAISE fnd_api.g_exc_unexpected_error;
3239: END IF;
3240: ELSE
3241: l_new_rsv_quantity := inv_convert.inv_um_convert(
3242: item_id => p_mo_line_rec.inventory_item_id
3243: , PRECISION => NULL
3244: , from_quantity => l_new_prim_rsv_quantity
3245: , from_unit => l_primary_uom

Line 3333: print_debug('calling inv_convert.inv_uom_convert', 'Inv_Pick_Release_PVT.Process_Line');

3329: -- records match (otherwise update the line with NULL)
3330: IF l_num_detail_recs > 0 THEN
3331: -- Calculate the quantity detailed in the UOM of the move order line
3332: IF (is_debug) THEN
3333: print_debug('calling inv_convert.inv_uom_convert', 'Inv_Pick_Release_PVT.Process_Line');
3334: print_debug('l_quantity_detailed = '|| l_quantity_detailed, 'Inv_Pick_Release_PVT.Process_Line');
3335: print_debug('l_sec_quantity_detailed = '|| l_sec_quantity_detailed, 'Inv_Pick_Release_PVT.Process_Line');
3336: END IF;
3337:

Line 3476: l_rsv_detailed_qty_conv := inv_convert.inv_um_convert(

3472: l_rsv_detailed_qty_conv := l_reservation_detailed_qty;
3473: ELSIF l_fulfill_base = 'S' AND l_demand_rsvs_ordered(l_res_ordered_index).reservation_uom_code = l_secondary_uom THEN
3474: l_rsv_detailed_qty_conv := l_rsv_detailed_qty2;
3475: ELSIF l_fulfill_base = 'S' AND l_demand_rsvs_ordered(l_res_ordered_index).reservation_uom_code <> l_secondary_uom AND l_demand_rsvs_ordered(l_res_ordered_index).reservation_uom_code <> l_primary_uom THEN
3476: l_rsv_detailed_qty_conv := inv_convert.inv_um_convert(
3477: item_id => p_mo_line_rec.inventory_item_id
3478: , PRECISION => NULL
3479: , from_quantity => l_rsv_detailed_qty2
3480: , from_unit => l_secondary_uom

Line 3497: l_rsv_detailed_qty_conv := inv_convert.inv_um_convert(

3493: fnd_msg_pub.ADD;
3494: RAISE fnd_api.g_exc_unexpected_error;
3495: END IF;
3496: ELSE
3497: l_rsv_detailed_qty_conv := inv_convert.inv_um_convert(
3498: item_id => p_mo_line_rec.inventory_item_id
3499: , PRECISION => NULL
3500: , from_quantity => l_reservation_detailed_qty
3501: , from_unit => l_primary_uom