DBA Data[Home] [Help]

APPS.GMI_RESERVATION_PUB dependencies on INV_RESERVATION_GLOBAL

Line 97: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type

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

Line 99: , p_sort_by_req_date IN NUMBER DEFAULT inv_reservation_global.g_query_no_sort

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

Line 100: , p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no

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

Line 101: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

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:

Line 273: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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

Line 274: , p_serial_number IN inv_reservation_global.serial_number_tbl_type

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

Line 275: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type

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

Line 436: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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

Line 437: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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:

Line 438: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type

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

Line 439: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type

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:

Line 591: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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

Line 592: , p_serial_number IN inv_reservation_global.serial_number_tbl_type

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:

Line 769: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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

Line 770: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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

Line 771: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type

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:

Line 772: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type

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