57: x_return_status OUT NOCOPY VARCHAR2
58: , x_msg_count OUT NOCOPY NUMBER
59: , x_msg_data OUT NOCOPY VARCHAR2
60: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
61: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
62: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
63: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
64: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
65: , x_error_code OUT NOCOPY NUMBER
59: , x_msg_data OUT NOCOPY VARCHAR2
60: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
61: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type
62: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
63: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
64: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
65: , x_error_code OUT NOCOPY NUMBER
66: );
67:
70: x_return_status OUT NOCOPY VARCHAR2
71: , x_msg_count OUT NOCOPY NUMBER
72: , x_msg_data OUT NOCOPY VARCHAR2
73: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
74: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
75: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
76: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
77: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
78: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
71: , x_msg_count OUT NOCOPY NUMBER
72: , x_msg_data OUT NOCOPY VARCHAR2
73: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
74: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
75: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
76: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
77: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
78: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
79: , x_quantity_reserved OUT NOCOPY NUMBER
72: , x_msg_data OUT NOCOPY VARCHAR2
73: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
74: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
75: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
76: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type
77: , p_partial_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
78: , p_force_reservation_flag IN VARCHAR2 DEFAULT fnd_api.g_false
79: , x_quantity_reserved OUT NOCOPY NUMBER
80: , x_reservation_id OUT NOCOPY NUMBER
85: x_return_status OUT NOCOPY VARCHAR2
86: , x_msg_count OUT NOCOPY NUMBER
87: , x_msg_data OUT NOCOPY VARCHAR2
88: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
89: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
90: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
91: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
92: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
93: );
86: , x_msg_count OUT NOCOPY NUMBER
87: , x_msg_data OUT NOCOPY VARCHAR2
88: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
89: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
90: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
91: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
92: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
93: );
94:
87: , x_msg_data OUT NOCOPY VARCHAR2
88: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
89: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
90: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
91: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
92: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
93: );
94:
95: PROCEDURE Delete_Reservation
88: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
89: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
90: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
91: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
92: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
93: );
94:
95: PROCEDURE Delete_Reservation
96: (
97: x_return_status OUT NOCOPY VARCHAR2
98: , x_msg_count OUT NOCOPY NUMBER
99: , x_msg_data OUT NOCOPY VARCHAR2
100: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
101: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
102: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
103: );
104:
105: PROCEDURE Transfer_Reservation
98: , x_msg_count OUT NOCOPY NUMBER
99: , x_msg_data OUT NOCOPY VARCHAR2
100: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
101: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
102: , p_serial_number IN inv_reservation_global.serial_number_tbl_type
103: );
104:
105: PROCEDURE Transfer_Reservation
106: (
109: , x_msg_count OUT NOCOPY NUMBER
110: , x_msg_data OUT NOCOPY VARCHAR2
111: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
112: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
113: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
114: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
115: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
116: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
117: , x_to_reservation_id OUT NOCOPY NUMBER
110: , x_msg_data OUT NOCOPY VARCHAR2
111: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
112: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
113: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
114: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
115: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
116: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
117: , x_to_reservation_id OUT NOCOPY NUMBER
118: );
111: , p_validation_flag IN VARCHAR2 DEFAULT fnd_api.g_true
112: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
113: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
114: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
115: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
116: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
117: , x_to_reservation_id OUT NOCOPY NUMBER
118: );
119:
112: , p_is_transfer_supply IN VARCHAR2 DEFAULT fnd_api.g_true
113: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
114: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
115: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type
116: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type
117: , x_to_reservation_id OUT NOCOPY NUMBER
118: );
119:
120: -- HW BUG#:1941429 procedure to calculate qty reserved for cross_docking
129: x_result_qty2 OUT NOCOPY NUMBER
130: );
131:
132: PROCEDURE Check_Shipping_Details
133: ( p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
134: , x_return_status OUT NOCOPY VARCHAR2
135: , x_msg_count OUT NOCOPY NUMBER
136: , x_msg_data OUT NOCOPY VARCHAR2
137: );