DBA Data[Home] [Help]

APPS.INV_REPLENISH_DETAIL_PUB dependencies on INV_RESERVATION_GLOBAL

Line 147: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;

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);

Line 857: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

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;

Line 858: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_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;

Line 861: l_original_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;

Line 862: l_to_serial_number inv_reservation_global.serial_number_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;
866: l_umconvert_trans_quantity NUMBER := 0;

Line 1434: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

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;

Line 1435: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

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);

Line 1444: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

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

Line 1445: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

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