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_RESERVATION_GLOBAL

Line 164: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;

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;
168: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

Line 166: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;

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;
168: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
169: l_msg_count NUMBER;
170: l_msg_data VARCHAR2(2000);

Line 167: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

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;
168: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
169: l_msg_count NUMBER;
170: l_msg_data VARCHAR2(2000);
171: l_error_code NUMBER;

Line 168: l_dummy_sn inv_reservation_global.serial_number_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;
168: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
169: l_msg_count NUMBER;
170: l_msg_data VARCHAR2(2000);
171: l_error_code NUMBER;
172: l_return_status VARCHAR2(1);

Line 546: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;

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;
547: l_mtl_reservation_count NUMBER;
548: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
549: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
550: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

Line 548: l_rsv_temp_rec inv_reservation_global.mtl_reservation_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;
547: l_mtl_reservation_count NUMBER;
548: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
549: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
550: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
551: l_msg_count NUMBER;
552: l_msg_data VARCHAR2(2000);

Line 549: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

545: l_quantity_cancel NUMBER;
546: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
547: l_mtl_reservation_count NUMBER;
548: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
549: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
550: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
551: l_msg_count NUMBER;
552: l_msg_data VARCHAR2(2000);
553: l_error_code NUMBER;

Line 550: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

546: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
547: l_mtl_reservation_count NUMBER;
548: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_type;
549: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
550: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
551: l_msg_count NUMBER;
552: l_msg_data VARCHAR2(2000);
553: l_error_code NUMBER;
554: l_return_status VARCHAR2(1);

Line 1125: l_mtl_reservations inv_reservation_global.mtl_reservation_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;
1128: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1129: l_msg_count NUMBER;

Line 1127: l_rsv_temp_rec inv_reservation_global.mtl_reservation_rec_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;
1128: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1129: l_msg_count NUMBER;
1130: l_msg_data VARCHAR2(2000);
1131: l_move_order_type NUMBER;

Line 1128: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_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;
1128: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1129: l_msg_count NUMBER;
1130: l_msg_data VARCHAR2(2000);
1131: l_move_order_type NUMBER;
1132: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;

Line 1605: x_mtl_reservation_tbl OUT INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE

1601: p_locator_id IN NUMBER := FND_API.G_MISS_NUM,
1602: p_revision IN VARCHAR2 := FND_API.G_MISS_CHAR,
1603: p_lot_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
1604: p_serial_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
1605: x_mtl_reservation_tbl OUT INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE
1606: )
1607: IS
1608: l_rsv_temp_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
1609: l_mtl_reservation INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;

Line 1608: l_rsv_temp_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;

1604: p_serial_number IN VARCHAR2 := FND_API.G_MISS_CHAR,
1605: x_mtl_reservation_tbl OUT INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE
1606: )
1607: IS
1608: l_rsv_temp_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
1609: l_mtl_reservation INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
1610: l_mtl_reservation_count NUMBER;
1611: l_rsv_result_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
1612: BEGIN

Line 1609: l_mtl_reservation INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;

1605: x_mtl_reservation_tbl OUT INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE
1606: )
1607: IS
1608: l_rsv_temp_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
1609: l_mtl_reservation INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
1610: l_mtl_reservation_count NUMBER;
1611: l_rsv_result_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
1612: BEGIN
1613: l_rsv_temp_rec.demand_source_header_id := p_source_header_id;

Line 1611: l_rsv_result_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;

1607: IS
1608: l_rsv_temp_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
1609: l_mtl_reservation INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
1610: l_mtl_reservation_count NUMBER;
1611: l_rsv_result_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
1612: BEGIN
1613: l_rsv_temp_rec.demand_source_header_id := p_source_header_id;
1614: l_rsv_temp_Rec.demand_source_line_id := p_source_line_id;
1615: l_rsv_temp_rec.demand_source_delivery := p_source_delivery_id;

Line 2136: l_original_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

2132: SELECT reservation_id, transaction_quantity, primary_quantity
2133: FROM mtl_material_transactions_temp
2134: WHERE move_order_line_id = p_line_id;
2135:
2136: l_original_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2137: l_new_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2138:
2139: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2140: l_mtl_reservation_tbl_count NUMBER;

Line 2137: l_new_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

2133: FROM mtl_material_transactions_temp
2134: WHERE move_order_line_id = p_line_id;
2135:
2136: l_original_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2137: l_new_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2138:
2139: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2140: l_mtl_reservation_tbl_count NUMBER;
2141: l_reservation_id NUMBER;

Line 2139: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

2135:
2136: l_original_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2137: l_new_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2138:
2139: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2140: l_mtl_reservation_tbl_count NUMBER;
2141: l_reservation_id NUMBER;
2142: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2143:

Line 2142: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

2138:
2139: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2140: l_mtl_reservation_tbl_count NUMBER;
2141: l_reservation_id NUMBER;
2142: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2143:
2144: l_msg_count NUMBER;
2145: l_msg_data VARCHAR2(2000);
2146: l_return_status VARCHAR2(1);

Line 2296: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

2292: l_return_status VARCHAR2(1);
2293: l_msg_count NUMBER;
2294: l_msg_data VARCHAR2(2000);
2295: l_unstaged_so_exists NUMBER := 0;
2296: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2297: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2298: l_ato_item number := 0 ;
2299: l_debug number;
2300: BEGIN

Line 2297: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

2293: l_msg_count NUMBER;
2294: l_msg_data VARCHAR2(2000);
2295: l_unstaged_so_exists NUMBER := 0;
2296: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2297: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2298: l_ato_item number := 0 ;
2299: l_debug number;
2300: BEGIN
2301: -- Use cache to get value for l_debug

Line 2471: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

2467: )
2468: IS
2469: l_api_name CONSTANT VARCHAR2(30) := 'Finalize_Pick_Confirm';
2470:
2471: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2472: l_query_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2473: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2474: l_mtl_reservation_rec2 inv_reservation_global.mtl_reservation_rec_type;
2475: l_mtl_reservation_rec3 inv_reservation_global.mtl_reservation_rec_type;

Line 2472: l_query_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

2468: IS
2469: l_api_name CONSTANT VARCHAR2(30) := 'Finalize_Pick_Confirm';
2470:
2471: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2472: l_query_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2473: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2474: l_mtl_reservation_rec2 inv_reservation_global.mtl_reservation_rec_type;
2475: l_mtl_reservation_rec3 inv_reservation_global.mtl_reservation_rec_type;
2476: l_mtl_reservation_tbl_count NUMBER;

Line 2473: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

2469: l_api_name CONSTANT VARCHAR2(30) := 'Finalize_Pick_Confirm';
2470:
2471: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2472: l_query_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2473: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2474: l_mtl_reservation_rec2 inv_reservation_global.mtl_reservation_rec_type;
2475: l_mtl_reservation_rec3 inv_reservation_global.mtl_reservation_rec_type;
2476: l_mtl_reservation_tbl_count NUMBER;
2477: l_return_status VARCHAR2(1);

Line 2474: l_mtl_reservation_rec2 inv_reservation_global.mtl_reservation_rec_type;

2470:
2471: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2472: l_query_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2473: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2474: l_mtl_reservation_rec2 inv_reservation_global.mtl_reservation_rec_type;
2475: l_mtl_reservation_rec3 inv_reservation_global.mtl_reservation_rec_type;
2476: l_mtl_reservation_tbl_count NUMBER;
2477: l_return_status VARCHAR2(1);
2478: l_msg_count NUMBER;

Line 2475: l_mtl_reservation_rec3 inv_reservation_global.mtl_reservation_rec_type;

2471: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
2472: l_query_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2473: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
2474: l_mtl_reservation_rec2 inv_reservation_global.mtl_reservation_rec_type;
2475: l_mtl_reservation_rec3 inv_reservation_global.mtl_reservation_rec_type;
2476: l_mtl_reservation_tbl_count NUMBER;
2477: l_return_status VARCHAR2(1);
2478: l_msg_count NUMBER;
2479: l_msg_data VARCHAR2(2000);

Line 2485: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

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;
2487: l_shipping_attr wsh_interface.changedattributetabtype;
2488: l_source_header_id NUMBER;
2489: l_source_line_id NUMBER;

Line 2486: l_to_serial_number inv_reservation_global.serial_number_tbl_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;
2487: l_shipping_attr wsh_interface.changedattributetabtype;
2488: l_source_header_id NUMBER;
2489: l_source_line_id NUMBER;
2490: l_delivery_detail_id NUMBER;

Line 4201: l_mtl_reservation_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;

4197: l_mtl_reservation_rec.reservation_uom_id := NULL;
4198: l_mtl_reservation_rec.autodetail_group_id := NULL;
4199: l_mtl_reservation_rec.external_source_code := NULL;
4200: l_mtl_reservation_rec.external_source_line_id := NULL;
4201: l_mtl_reservation_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;
4202: l_mtl_reservation_rec.supply_source_header_id := NULL;
4203: l_mtl_reservation_rec.supply_source_line_id := NULL;
4204: l_mtl_reservation_rec.supply_source_name := NULL;
4205: l_mtl_reservation_rec.supply_source_line_detail := NULL;

Line 6139: l_mtl_reservation_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;

6135: l_mtl_reservation_rec.reservation_uom_id := NULL;
6136: l_mtl_reservation_rec.autodetail_group_id := NULL;
6137: l_mtl_reservation_rec.external_source_code := NULL;
6138: l_mtl_reservation_rec.external_source_line_id := NULL;
6139: l_mtl_reservation_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;
6140: l_mtl_reservation_rec.supply_source_header_id := NULL;
6141: l_mtl_reservation_rec.supply_source_line_id := NULL;
6142: l_mtl_reservation_rec.supply_source_name := NULL;
6143: l_mtl_reservation_rec.supply_source_line_detail := NULL;