DBA Data[Home] [Help]

APPS.WMS_TASK_MGMT_PUB dependencies on INV_MO_LINE_DETAIL_UTIL

Line 3504: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;

3500: l_error_code NUMBER;
3501: l_count NUMBER;
3502: l_success BOOLEAN;
3503: l_umconvert_trans_quantity NUMBER := 0;
3504: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
3505: l_primary_uom VARCHAR2(10);
3506: l_ato_item NUMBER := 0;
3507: l_debug NUMBER;
3508: l_rsv_detailed_qty NUMBER;

Line 3581: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);

3577: END IF;
3578: -- If item is ato item, reduce the detailed quantity by the transaction
3579: -- quantity and retain the reservation. Convert to primary uom before
3580: -- reducing detailed quantity.
3581: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);
3582: l_umconvert_trans_quantity:= p_transaction_quantity;
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 = ');

Line 3624: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);

3620: RAISE exc_not_deleted ;
3621: END IF;
3622: ELSE
3623: l_mtl_reservation_rec := l_mtl_reservation_tbl(1);
3624: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);
3625: IF l_debug = 1 THEN
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;

Line 3854: l_mold_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;

3850: x_msg_count OUT NOCOPY NUMBER ,
3851: x_msg_data OUT NOCOPY VARCHAR2 ) IS
3852:
3853: l_mo_line_rec inv_move_order_pub.trolin_rec_type;
3854: l_mold_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
3855: l_mo_type NUMBER;
3856: l_allow_backordering VARCHAR2(1) := 'Y';
3857: l_debug NUMBER;
3858: l_transaction_quantity NUMBER;