DBA Data[Home] [Help]

APPS.WMS_TASK_MGMT_PUB dependencies on INV_MO_LINE_DETAIL_UTIL

Line 3415: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;

3411: l_error_code NUMBER;
3412: l_count NUMBER;
3413: l_success BOOLEAN;
3414: l_umconvert_trans_quantity NUMBER := 0;
3415: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
3416: l_primary_uom VARCHAR2(10);
3417: l_ato_item NUMBER := 0;
3418: l_debug NUMBER;
3419: l_rsv_detailed_qty NUMBER;

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

3488: END IF;
3489: -- If item is ato item, reduce the detailed quantity by the transaction
3490: -- quantity and retain the reservation. Convert to primary uom before
3491: -- reducing detailed quantity.
3492: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);
3493: l_umconvert_trans_quantity:= p_transaction_quantity;
3494: IF l_mmtt_rec.inventory_item_id IS NOT NULL AND l_mmtt_rec.transaction_uom IS NOT NULL THEN
3495: IF l_debug = 1 THEN
3496: debug_print( 'UOM Convert = ');

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

3531: RAISE exc_not_deleted ;
3532: END IF;
3533: ELSE
3534: l_mtl_reservation_rec := l_mtl_reservation_tbl(1);
3535: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);
3536: IF l_debug = 1 THEN
3537: debug_print( 'Allocation UOM = ' || l_mmtt_rec.transaction_uom);
3538: debug_print( 'Reservation UOM = ' || l_mtl_reservation_rec.reservation_uom_code);
3539: END IF;

Line 3765: l_mold_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;

3761: x_msg_count OUT NOCOPY NUMBER ,
3762: x_msg_data OUT NOCOPY VARCHAR2 ) IS
3763:
3764: l_mo_line_rec inv_move_order_pub.trolin_rec_type;
3765: l_mold_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
3766: l_mo_type NUMBER;
3767: l_allow_backordering VARCHAR2(1) := 'Y';
3768: l_debug NUMBER;
3769: l_transaction_quantity NUMBER;