DBA Data[Home] [Help]

APPS.INV_REPLENISH_DETAIL_PUB dependencies on INV_RESERVATION_GLOBAL

Line 154: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;

150: l_transaction_quantity2 NUMBER;
151: l_inventory_item_id NUMBER;
152: l_temp_id NUMBER;
153: l_serial_number VARCHAR2(30);
154: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
155: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
156: l_auto_pick_confirm NUMBER;
157: l_pick_release_status inv_pick_release_pub.inv_release_status_tbl_type;
158: l_return_status VARCHAR2(1);

Line 984: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

980: , x_msg_data OUT NOCOPY VARCHAR2
981: , p_delete_temp_records IN BOOLEAN default TRUE /*Bug#5505709.*/
982: ) IS
983: l_reservation_id NUMBER := p_reservation_id;
984: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
985: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
986: l_mtl_reservation_tbl_count NUMBER := 0;
987: l_return_status VARCHAR2(1);
988: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

Line 985: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

981: , p_delete_temp_records IN BOOLEAN default TRUE /*Bug#5505709.*/
982: ) IS
983: l_reservation_id NUMBER := p_reservation_id;
984: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
985: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
986: l_mtl_reservation_tbl_count NUMBER := 0;
987: l_return_status VARCHAR2(1);
988: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
989: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

Line 988: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

984: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
985: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
986: l_mtl_reservation_tbl_count NUMBER := 0;
987: l_return_status VARCHAR2(1);
988: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
989: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
990: l_error_code NUMBER;
991: l_count NUMBER;
992: l_success BOOLEAN;

Line 989: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

985: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
986: l_mtl_reservation_tbl_count NUMBER := 0;
987: l_return_status VARCHAR2(1);
988: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
989: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
990: l_error_code NUMBER;
991: l_count NUMBER;
992: l_success BOOLEAN;
993: l_umconvert_trans_quantity NUMBER := 0;

Line 1566: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

1562: , x_return_status OUT NOCOPY VARCHAR2
1563: , x_msg_count OUT NOCOPY NUMBER
1564: , x_msg_data OUT NOCOPY VARCHAR2
1565: ) IS
1566: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1567: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
1568: l_mtl_reservation_tbl_count NUMBER;
1569: l_return_status VARCHAR2(1);
1570: l_msg_count NUMBER;

Line 1567: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

1563: , x_msg_count OUT NOCOPY NUMBER
1564: , x_msg_data OUT NOCOPY VARCHAR2
1565: ) IS
1566: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1567: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
1568: l_mtl_reservation_tbl_count NUMBER;
1569: l_return_status VARCHAR2(1);
1570: l_msg_count NUMBER;
1571: l_msg_data VARCHAR2(2000);

Line 1576: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

1572: l_error_code NUMBER;
1573: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
1574: l_mmtt_count NUMBER;
1575: l_reservation_id NUMBER := p_reservation_id;
1576: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
1577: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
1578: l_reservable_type NUMBER;
1579:
1580: CURSOR lot_csr(l_transaction_temp_id NUMBER) IS

Line 1577: l_to_serial_number inv_reservation_global.serial_number_tbl_type;

1573: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
1574: l_mmtt_count NUMBER;
1575: l_reservation_id NUMBER := p_reservation_id;
1576: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
1577: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
1578: l_reservable_type NUMBER;
1579:
1580: CURSOR lot_csr(l_transaction_temp_id NUMBER) IS
1581: SELECT lot_number