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 371: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;

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

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

459: DEBUG('l_ato_item = 1', 'DELETE_DETAILS');
460: -- If item is ato item, reduce the detailed quantity by the transaction
461: -- quantity and retain the reservation. Convert to primary uom before
462: -- reducing detailed quantity.
463: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);
464: l_umconvert_trans_quantity := p_transaction_quantity;
465:
466:
467: IF l_mmtt_rec.inventory_item_id IS NOT NULL

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

521: RAISE fnd_api.g_exc_unexpected_error;
522: END IF;
523: ELSE
524: l_mtl_reservation_rec := l_mtl_reservation_tbl(1);
525: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);
526: DEBUG('Allocation UOM = ' || l_mmtt_rec.transaction_uom, 'DELETE_DETAILS');
527: DEBUG('Reservation UOM = ' || l_mtl_reservation_rec.reservation_uom_code, 'DELETE_DETAILS');
528:
529: IF l_mmtt_rec.transaction_uom <> l_mtl_reservation_rec.reservation_uom_code THEN