DBA Data[Home] [Help]

APPS.INV_MO_BACKORDER_PVT dependencies on INV_MO_LINE_DETAIL_UTIL

Line 162: l_mold_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;

158: , x_msg_count OUT NOCOPY NUMBER
159: , x_msg_data OUT NOCOPY VARCHAR2
160: ) IS
161: l_mo_line_rec inv_move_order_pub.trolin_rec_type;
162: l_mold_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
163: l_mo_type NUMBER;
164: l_allow_backordering VARCHAR2(1) := 'Y';
165:
166: CURSOR c_allow_backordering IS

Line 370: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;

366: l_error_code NUMBER;
367: l_count NUMBER;
368: l_success BOOLEAN;
369: l_umconvert_trans_quantity NUMBER := 0;
370: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
371: l_primary_uom VARCHAR2(10);
372: l_ato_item NUMBER := 0;
373: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
374:

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

445: DEBUG('l_ato_item = 1', 'DELETE_DETAILS');
446: -- If item is ato item, reduce the detailed quantity by the transaction
447: -- quantity and retain the reservation. Convert to primary uom before
448: -- reducing detailed quantity.
449: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);
450: l_umconvert_trans_quantity := p_transaction_quantity;
451:
452:
453: IF l_mmtt_rec.inventory_item_id IS NOT NULL

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

507: RAISE fnd_api.g_exc_unexpected_error;
508: END IF;
509: ELSE
510: l_mtl_reservation_rec := l_mtl_reservation_tbl(1);
511: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);
512: DEBUG('Allocation UOM = ' || l_mmtt_rec.transaction_uom, 'DELETE_DETAILS');
513: DEBUG('Reservation UOM = ' || l_mtl_reservation_rec.reservation_uom_code, 'DELETE_DETAILS');
514:
515: IF l_mmtt_rec.transaction_uom <> l_mtl_reservation_rec.reservation_uom_code THEN