DBA Data[Home] [Help]

APPS.GMI_RESERVATION_PVT dependencies on INV_RESERVATION_GLOBAL

Line 61: , p_query_input IN inv_reservation_global.mtl_reservation_rec_type

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

Line 63: , x_mtl_reservation_tbl OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

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:

Line 74: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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

Line 75: , p_serial_number IN inv_reservation_global.serial_number_tbl_type

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

Line 76: , x_serial_number OUT NOCOPY inv_reservation_global.serial_number_tbl_type

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

Line 89: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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: );

Line 90: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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:

Line 91: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type

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

Line 92: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type

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: (

Line 101: , p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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

Line 102: , p_serial_number IN inv_reservation_global.serial_number_tbl_type

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: (

Line 113: , p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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

Line 114: , p_to_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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: );

Line 115: , p_original_serial_number IN inv_reservation_global.serial_number_tbl_type

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:

Line 116: , p_to_serial_number IN inv_reservation_global.serial_number_tbl_type

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

Line 133: ( p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

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: );