[Home] [Help]
102: -- Procedure name : CREATE_RESERVATION
103: -- Type : Private
104: -- Function : Reserves the serial numbers in the p_serial_number_tbl
105: -- Pre-reqs :
106: -- Standard IN Parameters :
107: -- p_api_version IN NUMBER Required
108: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
109: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
110: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
108: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
109: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
110: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
111: -- p_module_type IN VARCHAR2 Default NULL
112: -- Standard OUT Parameters :
113: -- x_return_status OUT VARCHAR2 Required
114: -- x_msg_count OUT NUMBER Required
115: -- x_msg_data OUT VARCHAR2 Required
116: --
159: -- Procedure name : UPDATE_RESERVATION
160: -- Type : Private
161: -- Function : Updates reservation attributes for the reservation : p_reservation_id
162: -- Pre-reqs :
163: -- Standard IN Parameters :
164: -- p_api_version IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
166: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
167: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
165: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
166: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
167: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
168: -- p_module_type IN VARCHAR2 Default NULL
169: -- Standard OUT Parameters :
170: -- x_return_status OUT VARCHAR2 Required
171: -- x_msg_count OUT NUMBER Required
172: -- x_msg_data OUT VARCHAR2 Required
173: --
201: -- Procedure name : DELETE_RESERVATION
202: -- Type : Private
203: -- Function : API to delete the reservation made for a requirement asainst p_reservation_id
204: -- Pre-reqs :
205: -- Standard IN Parameters :
206: -- p_api_version IN NUMBER Required
207: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
208: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
209: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
207: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
208: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
209: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
210: -- p_module_type IN VARCHAR2 Default NULL
211: -- Standard OUT Parameters :
212: -- x_return_status OUT VARCHAR2 Required
213: -- x_msg_count OUT NUMBER Required
214: -- x_msg_data OUT VARCHAR2 Required
215: --
238: -- Procedure name : RELIEVE_RESERVATION
239: -- Type : Private
240: -- Function : API to delete a particular serial number from the reservation.
241: -- Pre-reqs :
242: -- Standard IN Parameters :
243: -- p_api_version IN NUMBER Required
244: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
245: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
244: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
245: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
246: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
247: -- p_module_type IN VARCHAR2 Default NULL
248: -- Standard OUT Parameters :
249: -- x_return_status OUT VARCHAR2 Required
250: -- x_msg_count OUT NUMBER Required
251: -- x_msg_data OUT VARCHAR2 Required
252: --
277: -- Type : Private
278: -- Function : API to transfer the reservation made for a particular requirement to another requirement
279: -- Used only when supply source type value changes (eg. IR to INV or INV to WO kind).
280: -- Pre-reqs :
281: -- Standard IN Parameters :
282: -- p_api_version IN NUMBER Required
283: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
284: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
285: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
283: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
284: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
285: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
286: -- p_module_type IN VARCHAR2 Default NULL
287: -- Standard OUT Parameters :
288: -- x_return_status OUT VARCHAR2 Required
289: -- x_msg_count OUT NUMBER Required
290: -- x_msg_data OUT VARCHAR2 Required
291: --
337: -- Procedure name : PROCESS_RESERVATION
338: -- Type : Private
339: -- Function : API to create/update/transfer the reservation for a particular requirement and serials combination.
340: -- Pre-reqs :
341: -- Standard IN Parameters :
342: -- p_api_version IN NUMBER Required
343: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
344: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
345: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
343: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
344: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
345: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
346: -- p_module_type IN VARCHAR2 Default NULL
347: -- Standard OUT Parameters :
348: -- x_return_status OUT VARCHAR2 Required
349: -- x_msg_count OUT NUMBER Required
350: -- x_msg_data OUT VARCHAR2 Required
351: --
388: -- Procedure name : CANCEL_RESERVATION
389: -- Type : Private
390: -- Function : API to relieve given serial numbers from their respective reservation.
391: -- Pre-reqs :
392: -- Standard IN Parameters :
393: -- p_api_version IN NUMBER Required
394: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
395: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
396: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
394: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
395: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
396: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
397: -- p_module_type IN VARCHAR2 Default NULL
398: -- Standard OUT Parameters :
399: -- x_return_status OUT VARCHAR2 Required
400: -- x_msg_count OUT NUMBER Required
401: -- x_msg_data OUT VARCHAR2 Required
402: --