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_SERIAL_PICK_PKG dependencies on INV_RESERVATION_GLOBAL

Line 22: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

18: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
19: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20: ,p_move_order_line_id NUMBER) IS
21:
22: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
23: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
24: l_txn_source_line_id NUMBER;
25: l_msg_count NUMBER;
26: CURSOR unstaged_reservations_csr(p_source_line_id NUMBER) IS

Line 23: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

19: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20: ,p_move_order_line_id NUMBER) IS
21:
22: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
23: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
24: l_txn_source_line_id NUMBER;
25: l_msg_count NUMBER;
26: CURSOR unstaged_reservations_csr(p_source_line_id NUMBER) IS
27: SELECT reservation_id

Line 95: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

91: l_return_status VARCHAR2(1);
92: l_msg_data VARCHAR2(2000);
93: l_unstaged_so_exists NUMBER := 0;
94: /*
95: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
96: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
97:
98: CURSOR unstaged_reservations_csr(p_source_line_id NUMBER) IS
99: SELECT reservation_id

Line 96: l_original_serial_number inv_reservation_global.serial_number_tbl_type;

92: l_msg_data VARCHAR2(2000);
93: l_unstaged_so_exists NUMBER := 0;
94: /*
95: l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
96: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
97:
98: CURSOR unstaged_reservations_csr(p_source_line_id NUMBER) IS
99: SELECT reservation_id
100: FROM mtl_reservations

Line 214: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

210: l_period_id NUMBER;
211: -- Bug 7190635
212: l_ato_item NUMBER := 0;
213: l_retain_ato_profile VARCHAR2(1) := NVL(fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS'),'N');
214: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
215: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
216: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
217: l_error_code NUMBER;
218: l_rsv_count NUMBER;

Line 215: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

211: -- Bug 7190635
212: l_ato_item NUMBER := 0;
213: l_retain_ato_profile VARCHAR2(1) := NVL(fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS'),'N');
214: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
215: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
216: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
217: l_error_code NUMBER;
218: l_rsv_count NUMBER;
219: l_prim_quantity_to_delete NUMBER;

Line 216: l_update_rec inv_reservation_global.mtl_reservation_rec_type;

212: l_ato_item NUMBER := 0;
213: l_retain_ato_profile VARCHAR2(1) := NVL(fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS'),'N');
214: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
215: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
216: l_update_rec inv_reservation_global.mtl_reservation_rec_type;
217: l_error_code NUMBER;
218: l_rsv_count NUMBER;
219: l_prim_quantity_to_delete NUMBER;
220: l_return_status VARCHAR2(1);

Line 221: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

217: l_error_code NUMBER;
218: l_rsv_count NUMBER;
219: l_prim_quantity_to_delete NUMBER;
220: l_return_status VARCHAR2(1);
221: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
222:
223:
224: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
225: -- Bug 7190635, Adding new cursor to fetch reservation id based on move order line id.