143: l_transaction_quantity2 NUMBER;
144: l_inventory_item_id NUMBER;
145: l_temp_id NUMBER;
146: l_serial_number VARCHAR2(30);
147: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
148: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
149: l_auto_pick_confirm NUMBER;
150: l_pick_release_status inv_pick_release_pub.inv_release_status_tbl_type;
151: l_return_status VARCHAR2(1);
853: , x_msg_data OUT NOCOPY VARCHAR2
854: , p_delete_temp_records IN BOOLEAN default TRUE /*Bug#5505709.*/
855: ) IS
856: l_reservation_id NUMBER := p_reservation_id;
857: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
858: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
859: l_mtl_reservation_tbl_count NUMBER := 0;
860: l_return_status VARCHAR2(1);
861: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
854: , p_delete_temp_records IN BOOLEAN default TRUE /*Bug#5505709.*/
855: ) IS
856: l_reservation_id NUMBER := p_reservation_id;
857: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
858: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
859: l_mtl_reservation_tbl_count NUMBER := 0;
860: l_return_status VARCHAR2(1);
861: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
862: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
857: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
858: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
859: l_mtl_reservation_tbl_count NUMBER := 0;
860: l_return_status VARCHAR2(1);
861: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
862: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
863: l_error_code NUMBER;
864: l_count NUMBER;
865: l_success BOOLEAN;
858: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
859: l_mtl_reservation_tbl_count NUMBER := 0;
860: l_return_status VARCHAR2(1);
861: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
862: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
863: l_error_code NUMBER;
864: l_count NUMBER;
865: l_success BOOLEAN;
866: l_umconvert_trans_quantity NUMBER := 0;
1430: , x_return_status OUT NOCOPY VARCHAR2
1431: , x_msg_count OUT NOCOPY NUMBER
1432: , x_msg_data OUT NOCOPY VARCHAR2
1433: ) IS
1434: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1435: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
1436: l_mtl_reservation_tbl_count NUMBER;
1437: l_return_status VARCHAR2(1);
1438: l_msg_count NUMBER;
1431: , x_msg_count OUT NOCOPY NUMBER
1432: , x_msg_data OUT NOCOPY VARCHAR2
1433: ) IS
1434: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1435: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
1436: l_mtl_reservation_tbl_count NUMBER;
1437: l_return_status VARCHAR2(1);
1438: l_msg_count NUMBER;
1439: l_msg_data VARCHAR2(2000);
1440: l_error_code NUMBER;
1441: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
1442: l_mmtt_count NUMBER;
1443: l_reservation_id NUMBER := p_reservation_id;
1444: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
1445: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
1446: l_reservable_type NUMBER;
1447:
1448: CURSOR lot_csr(l_transaction_temp_id NUMBER) IS
1441: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
1442: l_mmtt_count NUMBER;
1443: l_reservation_id NUMBER := p_reservation_id;
1444: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
1445: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
1446: l_reservable_type NUMBER;
1447:
1448: CURSOR lot_csr(l_transaction_temp_id NUMBER) IS
1449: SELECT lot_number