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 158: 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

154: l_primary_quantity := inv_convert.inv_um_convert(item_id => p_item_id, PRECISION => NULL, from_quantity => p_from_quantity, from_unit => p_from_unit, to_unit => l_primary_uom, from_name => NULL, to_name => NULL);
155: RETURN l_primary_quantity;
156: END get_primary_quantity;
157:
158: 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
159: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
160: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
161: l_mtl_reservation_count NUMBER;
162: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;

Line 159: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;

155: RETURN l_primary_quantity;
156: END get_primary_quantity;
157:
158: 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
159: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
160: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
161: l_mtl_reservation_count NUMBER;
162: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
163: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

Line 236: 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);

232: EXCEPTION
233: WHEN OTHERS THEN
234: RAISE fnd_api.g_exc_unexpected_error;
235: END;
236: 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);
237: END LOOP;
238:
239: x_return_status := l_return_status;
240: x_msg_data := l_msg_data;

Line 534: , p_troldt_tbl IN inv_mo_line_detail_util.g_mmtt_tbl_type

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

Line 539: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;

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

Line 743: 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);

739: WHEN OTHERS THEN
740: RAISE fnd_api.g_exc_unexpected_error;
741: END;
742: IF p_delete_mmtt = 'YES' THEN --Added bug3524130
743: 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);
744: END IF;
745:
746: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
747: RAISE fnd_api.g_exc_unexpected_error;

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

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

Line 918: 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);

914: EXCEPTION
915: WHEN OTHERS THEN
916: RAISE fnd_api.g_exc_unexpected_error;
917: END;
918: 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);
919:
920: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
921: RAISE fnd_api.g_exc_unexpected_error;
922: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 1120: l_troldt_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;

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

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

1394: --debug('Calling inv_mold_query_rows');
1395: IF (l_debug = 1) THEN
1396: DEBUG('Calling inv_mold_query_rows for Line Id: ' || to_char(l_trolin_rec.line_id), 'Inv_Transfer_Order_PVT.Trolins');
1397: END IF;
1398: l_troldt_tbl := inv_mo_line_detail_util.query_rows(p_line_id => l_trolin_rec.line_id);
1399:
1400: IF (l_troldt_tbl.COUNT > 0) THEN
1401: IF (l_debug = 1) THEN
1402: DEBUG('Calling Delete_Troldt', 'Inv_Transfer_Order_PVT.Trolins');

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

1444: ) THEN
1445: IF (l_debug = 1) THEN
1446: DEBUG('calling mold query rows', 'Inv_Transfer_Order_PVT.Trolins');
1447: END IF;
1448: l_troldt_tbl := inv_mo_line_detail_util.query_rows(p_line_id => l_trolin_rec.line_id);
1449: IF (l_debug = 1) THEN
1450: DEBUG('after mold query rows', 'Inv_Transfer_Order_PVT.Trolins');
1451: END IF;
1452:

Line 2469: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;

2465: l_msg_count NUMBER;
2466: l_msg_data VARCHAR2(2000);
2467: l_error_code NUMBER;
2468: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2469: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
2470: l_mmtt_count NUMBER;
2471: l_reservation_id NUMBER;
2472: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2473: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

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

2661: END IF;
2662:
2663: -- query the move order line detail for the move order line
2664: -- detail id passed in
2665: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);
2666: --INVCONV
2667: OPEN get_item_details (l_mmtt_rec.organization_id, l_mmtt_rec.inventory_item_id);
2668: FETCH get_item_details INTO l_primary_uom_code, l_secondary_uom_code, l_tracking_quantity_ind;
2669: CLOSE get_item_details;