eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_TRANSFER_ORDER_PVT dependencies on INV_MO_LINE_DETAIL_UTIL

Line 162: PROCEDURE delete_troldt(x_return_status OUT NOCOPY VARCHAR2, x_msg_data OUT NOCOPY VARCHAR2, x_msg_count OUT NOCOPY NUMBER, p_troldt_tbl IN inv_mo_line_detail_util.g_mmtt_tbl_type, p_move_order_type IN NUMBER) IS

158: to_unit => l_primary_uom, from_name => NULL, to_name => NULL);
159: RETURN l_primary_quantity;
160: END get_primary_quantity;
161:
162: PROCEDURE delete_troldt(x_return_status OUT NOCOPY VARCHAR2, x_msg_data OUT NOCOPY VARCHAR2, x_msg_count OUT NOCOPY NUMBER, p_troldt_tbl IN inv_mo_line_detail_util.g_mmtt_tbl_type, p_move_order_type IN NUMBER) IS
163: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
164: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
165: l_mtl_reservation_count NUMBER;
166: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;

Line 163: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;

159: RETURN l_primary_quantity;
160: END get_primary_quantity;
161:
162: PROCEDURE delete_troldt(x_return_status OUT NOCOPY VARCHAR2, x_msg_data OUT NOCOPY VARCHAR2, x_msg_count OUT NOCOPY NUMBER, p_troldt_tbl IN inv_mo_line_detail_util.g_mmtt_tbl_type, p_move_order_type IN NUMBER) IS
163: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
164: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
165: l_mtl_reservation_count NUMBER;
166: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
167: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

Line 240: inv_mo_line_detail_util.delete_row(x_return_status => l_return_status, p_line_id => l_troldt_tbl(l_counter).move_order_line_id, p_line_detail_id => l_troldt_tbl(l_counter).transaction_temp_id);

236: EXCEPTION
237: WHEN OTHERS THEN
238: RAISE fnd_api.g_exc_unexpected_error;
239: END;
240: inv_mo_line_detail_util.delete_row(x_return_status => l_return_status, p_line_id => l_troldt_tbl(l_counter).move_order_line_id, p_line_detail_id => l_troldt_tbl(l_counter).transaction_temp_id);
241: END LOOP;
242:
243: x_return_status := l_return_status;
244: x_msg_data := l_msg_data;

Line 537: , p_troldt_tbl IN inv_mo_line_detail_util.g_mmtt_tbl_type

533: , x_msg_data OUT NOCOPY VARCHAR2
534: , x_msg_count OUT NOCOPY NUMBER
535: , p_trolin_rec IN inv_move_order_pub.trolin_rec_type
536: , p_old_trolin_rec IN inv_move_order_pub.trolin_rec_type
537: , p_troldt_tbl IN inv_mo_line_detail_util.g_mmtt_tbl_type
538: , p_move_order_type IN NUMBER
539: , x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type
540: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130
541: ) IS

Line 542: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;

538: , p_move_order_type IN NUMBER
539: , x_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type
540: , p_delete_mmtt IN VARCHAR2 DEFAULT 'YES' --Added bug3524130
541: ) IS
542: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
543: l_trolin_rec inv_move_order_pub.trolin_rec_type;
544: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
545: l_quantity_cancel NUMBER;
546: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;

Line 746: inv_mo_line_detail_util.delete_row(x_return_status => l_return_status, p_line_id => l_trolin_rec.line_id, p_line_detail_id => l_troldt_tbl(l_counter).transaction_temp_id);

742: WHEN OTHERS THEN
743: RAISE fnd_api.g_exc_unexpected_error;
744: END;
745: IF p_delete_mmtt = 'YES' THEN --Added bug3524130
746: inv_mo_line_detail_util.delete_row(x_return_status => l_return_status, p_line_id => l_trolin_rec.line_id, p_line_detail_id => l_troldt_tbl(l_counter).transaction_temp_id);
747: END IF;
748:
749: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
750: RAISE fnd_api.g_exc_unexpected_error;

Line 832: inv_mo_line_detail_util.update_row(x_return_status => l_return_status, p_mo_line_detail_rec => l_troldt_tbl(l_counter));

828: END IF;
829: -- END
830:
831: l_rsv_quantity := l_quantity_cancel;
832: inv_mo_line_detail_util.update_row(x_return_status => l_return_status, p_mo_line_detail_rec => l_troldt_tbl(l_counter));
833:
834: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
835: RAISE fnd_api.g_exc_unexpected_error;
836: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 921: inv_mo_line_detail_util.delete_row(x_return_status => l_return_status, p_line_id => l_trolin_rec.line_id, p_line_detail_id => l_troldt_tbl(l_counter).transaction_temp_id);

917: EXCEPTION
918: WHEN OTHERS THEN
919: RAISE fnd_api.g_exc_unexpected_error;
920: END;
921: inv_mo_line_detail_util.delete_row(x_return_status => l_return_status, p_line_id => l_trolin_rec.line_id, p_line_detail_id => l_troldt_tbl(l_counter).transaction_temp_id);
922:
923: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
924: RAISE fnd_api.g_exc_unexpected_error;
925: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 1123: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;

1119: l_trolin_val_rec inv_move_order_pub.trolin_val_rec_type;
1120: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1121: l_old_trolin_rec inv_move_order_pub.trolin_rec_type;
1122: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1123: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
1124: l_quantity_cancel NUMBER;
1125: l_mtl_reservations inv_reservation_global.mtl_reservation_tbl_type;
1126: l_mtl_reservation_count NUMBER;
1127: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;

Line 1411: l_troldt_tbl := inv_mo_line_detail_util.query_rows(p_line_id => l_trolin_rec.line_id);

1407: --debug('Calling inv_mold_query_rows');
1408: IF (l_debug = 1) THEN
1409: DEBUG('Calling inv_mold_query_rows for Line Id: ' || to_char(l_trolin_rec.line_id), 'Inv_Transfer_Order_PVT.Trolins');
1410: END IF;
1411: l_troldt_tbl := inv_mo_line_detail_util.query_rows(p_line_id => l_trolin_rec.line_id);
1412:
1413: IF (l_troldt_tbl.COUNT > 0) THEN
1414: IF (l_debug = 1) THEN
1415: DEBUG('Calling Delete_Troldt', 'Inv_Transfer_Order_PVT.Trolins');

Line 1461: l_troldt_tbl := inv_mo_line_detail_util.query_rows(p_line_id => l_trolin_rec.line_id);

1457: ) THEN
1458: IF (l_debug = 1) THEN
1459: DEBUG('calling mold query rows', 'Inv_Transfer_Order_PVT.Trolins');
1460: END IF;
1461: l_troldt_tbl := inv_mo_line_detail_util.query_rows(p_line_id => l_trolin_rec.line_id);
1462: IF (l_debug = 1) THEN
1463: DEBUG('after mold query rows', 'Inv_Transfer_Order_PVT.Trolins');
1464: END IF;
1465:

Line 2482: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;

2478: l_msg_count NUMBER;
2479: l_msg_data VARCHAR2(2000);
2480: l_error_code NUMBER;
2481: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2482: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
2483: l_mmtt_count NUMBER;
2484: l_reservation_id NUMBER;
2485: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2486: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

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

2691: END IF;
2692:
2693: -- query the move order line detail for the move order line
2694: -- detail id passed in
2695: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);
2696:
2697: --INVCONV
2698: OPEN get_item_details (l_mmtt_rec.organization_id, l_mmtt_rec.inventory_item_id);
2699: FETCH get_item_details INTO l_primary_uom_code, l_secondary_uom_code, l_tracking_quantity_ind,l_secondary_default_ind;