21: -- Procedure name : CREATE_RESERVATION
22: -- Type : Private
23: -- Function : Reserves the serial numbers in the p_serial_number_tbl
24: -- Pre-reqs :
25: -- Standard IN Parameters :
26: -- p_api_version IN NUMBER Required
27: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
28: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
29: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
27: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
28: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
29: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
30: -- p_module_type IN VARCHAR2 Default NULL
31: -- Standard OUT Parameters :
32: -- x_return_status OUT VARCHAR2 Required
33: -- x_msg_count OUT NUMBER Required
34: -- x_msg_data OUT VARCHAR2 Required
35:
59: -- Procedure name : UPDATE_RESERVATION
60: -- Type : Private
61: -- Function : Updates reservation for serial numbers in the p_serial_number_tbl
62: -- Pre-reqs :
63: -- Standard IN Parameters :
64: -- p_api_version IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
66: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
67: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
65: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
66: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
67: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
68: -- p_module_type IN VARCHAR2 Default NULL
69: -- Standard OUT Parameters :
70: -- x_return_status OUT VARCHAR2 Required
71: -- x_msg_count OUT NUMBER Required
72: -- x_msg_data OUT VARCHAR2 Required
73:
97: -- Procedure name : DELETE_RESERVATION
98: -- Type : Private
99: -- Function : API to delete all the reservation made for a requirement
100: -- Pre-reqs :
101: -- Standard IN Parameters :
102: -- p_api_version IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
104: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
103: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
104: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
106: -- p_module_type IN VARCHAR2 Default NULL
107: -- Standard OUT Parameters :
108: -- x_return_status OUT VARCHAR2 Required
109: -- x_msg_count OUT NUMBER Required
110: -- x_msg_data OUT VARCHAR2 Required
111:
135: -- Procedure name : RELIEVE_RESERVATION
136: -- Type : Private
137: -- Function : API to delete the reservation made for a particular serial number
138: -- Pre-reqs :
139: -- Standard IN Parameters :
140: -- p_api_version IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
142: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
141: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
142: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
144: -- p_module_type IN VARCHAR2 Default NULL
145: -- Standard OUT Parameters :
146: -- x_return_status OUT VARCHAR2 Required
147: -- x_msg_count OUT NUMBER Required
148: -- x_msg_data OUT VARCHAR2 Required
149:
174: -- Procedure name : TRANSFER_RESERVATION
175: -- Type : Private
176: -- Function : API to delete the reservation made for a particular serial number
177: -- Pre-reqs :
178: -- Standard IN Parameters :
179: -- p_api_version IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
181: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
180: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
181: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
183: -- p_module_type IN VARCHAR2 Default NULL
184: -- Standard OUT Parameters :
185: -- x_return_status OUT VARCHAR2 Required
186: -- x_msg_count OUT NUMBER Required
187: -- x_msg_data OUT VARCHAR2 Required
188:
211: -- Procedure name : UPDATE_VISIT_RESERVATIONS
212: -- Type : Private
213: -- Function : API to update all the reservations for s particular visit
214: -- Pre-reqs :
215: -- Standard IN Parameters :
216: -- Standard OUT Parameters :
217: -- x_return_status OUT VARCHAR2 Required
218: --
219: -- UPDATE_VISIT_RESERVATIONS Parameters:
212: -- Type : Private
213: -- Function : API to update all the reservations for s particular visit
214: -- Pre-reqs :
215: -- Standard IN Parameters :
216: -- Standard OUT Parameters :
217: -- x_return_status OUT VARCHAR2 Required
218: --
219: -- UPDATE_VISIT_RESERVATIONS Parameters:
220: -- p_visit_id : The visit id for which the reservations need to be transferred.
232: -- Procedure name : DELETE_VISIT_RESERVATIONS
233: -- Type : Private
234: -- Function : API to delete all the reservations for s particular visit
235: -- Pre-reqs :
236: -- Standard IN Parameters :
237: -- Standard OUT Parameters :
238: -- x_return_status OUT VARCHAR2 Required
239: --
240: -- DELETE_VISIT_RESERVATIONS Parameters:
233: -- Type : Private
234: -- Function : API to delete all the reservations for s particular visit
235: -- Pre-reqs :
236: -- Standard IN Parameters :
237: -- Standard OUT Parameters :
238: -- x_return_status OUT VARCHAR2 Required
239: --
240: -- DELETE_VISIT_RESERVATIONS Parameters:
241: -- p_visit_id : The visit id for which the reservations need to be deleted
253: -- Procedure name : TRANSFER_RESERVATION_MATRL_REQR
254: -- Type : Private
255: -- Function : API to transfer reservations for a particular material requirement
256: -- Pre-reqs :
257: -- Standard IN Parameters :
258: -- Standard OUT Parameters :
259: -- x_return_status OUT VARCHAR2 Required
260: -- x_msg_count
261: -- x_msg_data
254: -- Type : Private
255: -- Function : API to transfer reservations for a particular material requirement
256: -- Pre-reqs :
257: -- Standard IN Parameters :
258: -- Standard OUT Parameters :
259: -- x_return_status OUT VARCHAR2 Required
260: -- x_msg_count
261: -- x_msg_data
262: -- DELETE_VISIT_RESERVATIONS Parameters: