93: , x_return_status OUT NOCOPY VARCHAR2
94: , x_msg_count OUT NOCOPY NUMBER
95: , x_msg_data OUT NOCOPY VARCHAR2
96: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
97: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
98: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
99: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
100: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
101: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
95: , x_msg_data OUT NOCOPY VARCHAR2
96: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
97: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
98: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
99: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
100: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
101: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
102: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
103: , x_error_code OUT NOCOPY NUMBER
96: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
97: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
98: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
99: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
100: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
101: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
102: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
103: , x_error_code OUT NOCOPY NUMBER
104: ) IS
97: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
98: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
99: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort
100: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
101: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
102: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
103: , x_error_code OUT NOCOPY NUMBER
104: ) IS
105:
269: , x_return_status OUT NOCOPY VARCHAR2
270: , x_msg_count OUT NOCOPY NUMBER
271: , x_msg_data OUT NOCOPY VARCHAR2
272: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
273: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
274: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
275: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
276: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
277: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
270: , x_msg_count OUT NOCOPY NUMBER
271: , x_msg_data OUT NOCOPY VARCHAR2
272: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
273: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
274: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
275: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
276: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
277: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
278: , x_quantity_reserved OUT NOCOPY NUMBER
271: , x_msg_data OUT NOCOPY VARCHAR2
272: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
273: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
274: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
275: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
276: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
277: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
278: , x_quantity_reserved OUT NOCOPY NUMBER
279: , x_reservation_id OUT NOCOPY NUMBER
432: , x_return_status OUT NOCOPY VARCHAR2
433: , x_msg_count OUT NOCOPY NUMBER
434: , x_msg_data OUT NOCOPY VARCHAR2
435: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
436: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
437: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
438: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
439: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
440: ) IS
433: , x_msg_count OUT NOCOPY NUMBER
434: , x_msg_data OUT NOCOPY VARCHAR2
435: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
436: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
437: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
438: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
439: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
440: ) IS
441:
434: , x_msg_data OUT NOCOPY VARCHAR2
435: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
436: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
437: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
438: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
439: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
440: ) IS
441:
442: l_api_name CONSTANT VARCHAR2 (30) := 'Update_Reservation';
435: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
436: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
437: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
438: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
439: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
440: ) IS
441:
442: l_api_name CONSTANT VARCHAR2 (30) := 'Update_Reservation';
443:
587: , x_return_status OUT NOCOPY VARCHAR2
588: , x_msg_count OUT NOCOPY NUMBER
589: , x_msg_data OUT NOCOPY VARCHAR2
590: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
591: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
592: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
593: ) IS
594:
595: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Reservation';
588: , x_msg_count OUT NOCOPY NUMBER
589: , x_msg_data OUT NOCOPY VARCHAR2
590: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
591: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
592: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
593: ) IS
594:
595: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Reservation';
596:
765: , x_msg_count OUT NOCOPY NUMBER
766: , x_msg_data OUT NOCOPY VARCHAR2
767: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
768: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
769: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
770: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
771: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
772: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
773: , x_to_reservation_id OUT NOCOPY NUMBER
766: , x_msg_data OUT NOCOPY VARCHAR2
767: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
768: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
769: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
770: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
771: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
772: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
773: , x_to_reservation_id OUT NOCOPY NUMBER
774: ) IS
767: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
768: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
769: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
770: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
771: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
772: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
773: , x_to_reservation_id OUT NOCOPY NUMBER
774: ) IS
775:
768: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
769: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
770: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
771: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
772: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
773: , x_to_reservation_id OUT NOCOPY NUMBER
774: ) IS
775:
776: l_api_name CONSTANT VARCHAR2 (30) := 'Transfer_Reservation';