193:
194: PROCEDURE process_jobs
195: (
196: p_api_version IN NUMBER := 1.0,
197: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
198: p_commit IN VARCHAR2 := FND_API.G_FALSE,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: p_default IN VARCHAR2 := FND_API.G_FALSE,
201: p_module_type IN VARCHAR2,
194: PROCEDURE process_jobs
195: (
196: p_api_version IN NUMBER := 1.0,
197: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
198: p_commit IN VARCHAR2 := FND_API.G_FALSE,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: p_default IN VARCHAR2 := FND_API.G_FALSE,
201: p_module_type IN VARCHAR2,
202: x_return_status OUT NOCOPY VARCHAR2,
195: (
196: p_api_version IN NUMBER := 1.0,
197: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
198: p_commit IN VARCHAR2 := FND_API.G_FALSE,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: p_default IN VARCHAR2 := FND_API.G_FALSE,
201: p_module_type IN VARCHAR2,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
196: p_api_version IN NUMBER := 1.0,
197: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
198: p_commit IN VARCHAR2 := FND_API.G_FALSE,
199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200: p_default IN VARCHAR2 := FND_API.G_FALSE,
201: p_module_type IN VARCHAR2,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
208:
209: PROCEDURE update_job
210: (
211: p_api_version IN NUMBER := 1.0,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_default IN VARCHAR2 := FND_API.G_FALSE,
216: p_module_type IN VARCHAR2,
209: PROCEDURE update_job
210: (
211: p_api_version IN NUMBER := 1.0,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_default IN VARCHAR2 := FND_API.G_FALSE,
216: p_module_type IN VARCHAR2,
217: x_return_status OUT NOCOPY VARCHAR2,
210: (
211: p_api_version IN NUMBER := 1.0,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_default IN VARCHAR2 := FND_API.G_FALSE,
216: p_module_type IN VARCHAR2,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
211: p_api_version IN NUMBER := 1.0,
212: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_default IN VARCHAR2 := FND_API.G_FALSE,
216: p_module_type IN VARCHAR2,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
241: -- End of Comments
242: PROCEDURE process_stage_jobs
243: (
244: p_api_version IN NUMBER := 1.0,
245: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
246: p_commit IN VARCHAR2 := FND_API.G_FALSE,
247: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
248: p_module_type IN VARCHAR2,
249: p_workorder_tbl IN PRD_WORKORDER_TBL,
242: PROCEDURE process_stage_jobs
243: (
244: p_api_version IN NUMBER := 1.0,
245: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
246: p_commit IN VARCHAR2 := FND_API.G_FALSE,
247: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
248: p_module_type IN VARCHAR2,
249: p_workorder_tbl IN PRD_WORKORDER_TBL,
250: x_return_status OUT NOCOPY VARCHAR2,
243: (
244: p_api_version IN NUMBER := 1.0,
245: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
246: p_commit IN VARCHAR2 := FND_API.G_FALSE,
247: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
248: p_module_type IN VARCHAR2,
249: p_workorder_tbl IN PRD_WORKORDER_TBL,
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
254:
255: PROCEDURE release_visit_jobs
256: (
257: p_api_version IN NUMBER := 1.0,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
259: p_commit IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261: p_default IN VARCHAR2 := FND_API.G_FALSE,
262: p_module_type IN VARCHAR2 := NULL,
255: PROCEDURE release_visit_jobs
256: (
257: p_api_version IN NUMBER := 1.0,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
259: p_commit IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261: p_default IN VARCHAR2 := FND_API.G_FALSE,
262: p_module_type IN VARCHAR2 := NULL,
263: x_return_status OUT NOCOPY VARCHAR2,
256: (
257: p_api_version IN NUMBER := 1.0,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
259: p_commit IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261: p_default IN VARCHAR2 := FND_API.G_FALSE,
262: p_module_type IN VARCHAR2 := NULL,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
257: p_api_version IN NUMBER := 1.0,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
259: p_commit IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261: p_default IN VARCHAR2 := FND_API.G_FALSE,
262: p_module_type IN VARCHAR2 := NULL,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2,
270:
271: PROCEDURE cancel_visit_jobs
272: (
273: p_api_version IN NUMBER := 1.0,
274: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
275: p_commit IN VARCHAR2 := FND_API.G_FALSE,
276: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
277: p_default IN VARCHAR2 := FND_API.G_FALSE,
278: p_module_type IN VARCHAR2 := NULL,
271: PROCEDURE cancel_visit_jobs
272: (
273: p_api_version IN NUMBER := 1.0,
274: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
275: p_commit IN VARCHAR2 := FND_API.G_FALSE,
276: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
277: p_default IN VARCHAR2 := FND_API.G_FALSE,
278: p_module_type IN VARCHAR2 := NULL,
279: x_return_status OUT NOCOPY VARCHAR2,
272: (
273: p_api_version IN NUMBER := 1.0,
274: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
275: p_commit IN VARCHAR2 := FND_API.G_FALSE,
276: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
277: p_default IN VARCHAR2 := FND_API.G_FALSE,
278: p_module_type IN VARCHAR2 := NULL,
279: x_return_status OUT NOCOPY VARCHAR2,
280: x_msg_count OUT NOCOPY NUMBER,
273: p_api_version IN NUMBER := 1.0,
274: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
275: p_commit IN VARCHAR2 := FND_API.G_FALSE,
276: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
277: p_default IN VARCHAR2 := FND_API.G_FALSE,
278: p_module_type IN VARCHAR2 := NULL,
279: x_return_status OUT NOCOPY VARCHAR2,
280: x_msg_count OUT NOCOPY NUMBER,
281: x_msg_data OUT NOCOPY VARCHAR2,
286:
287: PROCEDURE validate_dependencies
288: (
289: p_api_version IN NUMBER := 1.0,
290: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
291: p_commit IN VARCHAR2 := FND_API.G_FALSE,
292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
293: p_default IN VARCHAR2 := FND_API.G_FALSE,
294: p_module_type IN VARCHAR2 := NULL,
287: PROCEDURE validate_dependencies
288: (
289: p_api_version IN NUMBER := 1.0,
290: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
291: p_commit IN VARCHAR2 := FND_API.G_FALSE,
292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
293: p_default IN VARCHAR2 := FND_API.G_FALSE,
294: p_module_type IN VARCHAR2 := NULL,
295: x_return_status OUT NOCOPY VARCHAR2,
288: (
289: p_api_version IN NUMBER := 1.0,
290: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
291: p_commit IN VARCHAR2 := FND_API.G_FALSE,
292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
293: p_default IN VARCHAR2 := FND_API.G_FALSE,
294: p_module_type IN VARCHAR2 := NULL,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
289: p_api_version IN NUMBER := 1.0,
290: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
291: p_commit IN VARCHAR2 := FND_API.G_FALSE,
292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
293: p_default IN VARCHAR2 := FND_API.G_FALSE,
294: p_module_type IN VARCHAR2 := NULL,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2,
302:
303: PROCEDURE reschedule_visit_jobs
304: (
305: p_api_version IN NUMBER := 1.0 ,
306: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
307: p_commit IN VARCHAR2 := FND_API.G_FALSE,
308: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
309: p_default IN VARCHAR2 := FND_API.G_FALSE,
310: p_module_type IN VARCHAR2 := Null,
303: PROCEDURE reschedule_visit_jobs
304: (
305: p_api_version IN NUMBER := 1.0 ,
306: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
307: p_commit IN VARCHAR2 := FND_API.G_FALSE,
308: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
309: p_default IN VARCHAR2 := FND_API.G_FALSE,
310: p_module_type IN VARCHAR2 := Null,
311: x_return_status OUT NOCOPY VARCHAR2,
304: (
305: p_api_version IN NUMBER := 1.0 ,
306: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
307: p_commit IN VARCHAR2 := FND_API.G_FALSE,
308: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
309: p_default IN VARCHAR2 := FND_API.G_FALSE,
310: p_module_type IN VARCHAR2 := Null,
311: x_return_status OUT NOCOPY VARCHAR2,
312: x_msg_count OUT NOCOPY NUMBER,
305: p_api_version IN NUMBER := 1.0 ,
306: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
307: p_commit IN VARCHAR2 := FND_API.G_FALSE,
308: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
309: p_default IN VARCHAR2 := FND_API.G_FALSE,
310: p_module_type IN VARCHAR2 := Null,
311: x_return_status OUT NOCOPY VARCHAR2,
312: x_msg_count OUT NOCOPY NUMBER,
313: x_msg_data OUT NOCOPY VARCHAR2,
332:
333: PROCEDURE INSERT_TURNOVER_NOTES
334: (
335: p_api_version IN NUMBER := 1.0 ,
336: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
337: p_commit IN VARCHAR2 := FND_API.G_FALSE,
338: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
339: p_default IN VARCHAR2 := FND_API.G_FALSE,
340: p_module_type IN VARCHAR2 := Null,
333: PROCEDURE INSERT_TURNOVER_NOTES
334: (
335: p_api_version IN NUMBER := 1.0 ,
336: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
337: p_commit IN VARCHAR2 := FND_API.G_FALSE,
338: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
339: p_default IN VARCHAR2 := FND_API.G_FALSE,
340: p_module_type IN VARCHAR2 := Null,
341: x_return_status OUT NOCOPY VARCHAR2,
334: (
335: p_api_version IN NUMBER := 1.0 ,
336: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
337: p_commit IN VARCHAR2 := FND_API.G_FALSE,
338: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
339: p_default IN VARCHAR2 := FND_API.G_FALSE,
340: p_module_type IN VARCHAR2 := Null,
341: x_return_status OUT NOCOPY VARCHAR2,
342: x_msg_count OUT NOCOPY NUMBER,
335: p_api_version IN NUMBER := 1.0 ,
336: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
337: p_commit IN VARCHAR2 := FND_API.G_FALSE,
338: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
339: p_default IN VARCHAR2 := FND_API.G_FALSE,
340: p_module_type IN VARCHAR2 := Null,
341: x_return_status OUT NOCOPY VARCHAR2,
342: x_msg_count OUT NOCOPY NUMBER,
343: x_msg_data OUT NOCOPY VARCHAR2,
366: -- JKJain, ER 9283136
367: PROCEDURE Unclose_Workorder
368: (
369: p_api_version IN NUMBER := 1.0,
370: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
371: p_commit IN VARCHAR2 := FND_API.G_FALSE,
372: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
373: p_default IN VARCHAR2 := FND_API.G_FALSE,
374: p_module_type IN VARCHAR2 := NULL,
367: PROCEDURE Unclose_Workorder
368: (
369: p_api_version IN NUMBER := 1.0,
370: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
371: p_commit IN VARCHAR2 := FND_API.G_FALSE,
372: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
373: p_default IN VARCHAR2 := FND_API.G_FALSE,
374: p_module_type IN VARCHAR2 := NULL,
375: x_return_status OUT NOCOPY VARCHAR2,
368: (
369: p_api_version IN NUMBER := 1.0,
370: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
371: p_commit IN VARCHAR2 := FND_API.G_FALSE,
372: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
373: p_default IN VARCHAR2 := FND_API.G_FALSE,
374: p_module_type IN VARCHAR2 := NULL,
375: x_return_status OUT NOCOPY VARCHAR2,
376: x_msg_count OUT NOCOPY NUMBER,
369: p_api_version IN NUMBER := 1.0,
370: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
371: p_commit IN VARCHAR2 := FND_API.G_FALSE,
372: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
373: p_default IN VARCHAR2 := FND_API.G_FALSE,
374: p_module_type IN VARCHAR2 := NULL,
375: x_return_status OUT NOCOPY VARCHAR2,
376: x_msg_count OUT NOCOPY NUMBER,
377: x_msg_data OUT NOCOPY VARCHAR2,
426: --ER#10257011 Supplier Warranty manisaga
427: PROCEDURE populate_entitlements
428: (
429: p_api_version IN NUMBER := 1.0,
430: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
431: p_commit IN VARCHAR2 := FND_API.G_FALSE,
432: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
433: p_contract_number IN NUMBER,
434: p_warranty_entl_rec IN OUT NOCOPY AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Rec_Type,
427: PROCEDURE populate_entitlements
428: (
429: p_api_version IN NUMBER := 1.0,
430: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
431: p_commit IN VARCHAR2 := FND_API.G_FALSE,
432: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
433: p_contract_number IN NUMBER,
434: p_warranty_entl_rec IN OUT NOCOPY AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Rec_Type,
435: p_user_role IN VARCHAR2,
428: (
429: p_api_version IN NUMBER := 1.0,
430: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
431: p_commit IN VARCHAR2 := FND_API.G_FALSE,
432: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
433: p_contract_number IN NUMBER,
434: p_warranty_entl_rec IN OUT NOCOPY AHL_WARRANTY_ENTL_PVT.Warranty_Entl_Rec_Type,
435: p_user_role IN VARCHAR2,
436: x_return_status OUT NOCOPY VARCHAR2,
444: p_workorder_op_id IN NUMBER := NULL,
445: p_new_status_code IN VARCHAR2,
446: --sukhwsin::Bug 12915297. Added new nullable parameter for hold reason.
447: p_hold_reason_code IN VARCHAR2 := NULL,
448: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
449: p_default IN VARCHAR2 := FND_API.G_FALSE,
450: p_module_type IN VARCHAR2 := Null,
451: x_return_status OUT NOCOPY VARCHAR2
452: );
445: p_new_status_code IN VARCHAR2,
446: --sukhwsin::Bug 12915297. Added new nullable parameter for hold reason.
447: p_hold_reason_code IN VARCHAR2 := NULL,
448: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
449: p_default IN VARCHAR2 := FND_API.G_FALSE,
450: p_module_type IN VARCHAR2 := Null,
451: x_return_status OUT NOCOPY VARCHAR2
452: );
453: --sukhwsin::Complex Assembly enhancements - Added following procedure for WO turnover notes for instance routing.
452: );
453: --sukhwsin::Complex Assembly enhancements - Added following procedure for WO turnover notes for instance routing.
454: PROCEDURE Add_Inst_Rtng_Notes_To_WO(
455: p_api_version IN NUMBER := 1.0,
456: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
457: p_commit IN VARCHAR2 := FND_API.G_FALSE,
458: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
459: x_return_status OUT NOCOPY VARCHAR2,
460: x_msg_count OUT NOCOPY NUMBER,
453: --sukhwsin::Complex Assembly enhancements - Added following procedure for WO turnover notes for instance routing.
454: PROCEDURE Add_Inst_Rtng_Notes_To_WO(
455: p_api_version IN NUMBER := 1.0,
456: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
457: p_commit IN VARCHAR2 := FND_API.G_FALSE,
458: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
459: x_return_status OUT NOCOPY VARCHAR2,
460: x_msg_count OUT NOCOPY NUMBER,
461: x_msg_data OUT NOCOPY VARCHAR2,
454: PROCEDURE Add_Inst_Rtng_Notes_To_WO(
455: p_api_version IN NUMBER := 1.0,
456: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
457: p_commit IN VARCHAR2 := FND_API.G_FALSE,
458: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
459: x_return_status OUT NOCOPY VARCHAR2,
460: x_msg_count OUT NOCOPY NUMBER,
461: x_msg_data OUT NOCOPY VARCHAR2,
462: p_workorder_id IN NUMBER,
487: -- Pre-reqs :
488: --
489: -- Standard IN Parameters :
490: -- p_api_version NUMBER := 1.0
491: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
492: -- p_commit VARCHAR2 := FND_API.G_FALSE
493: --
494: -- Standard OUT Parameters :
495: -- x_return_status VARCHAR2 Required
488: --
489: -- Standard IN Parameters :
490: -- p_api_version NUMBER := 1.0
491: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
492: -- p_commit VARCHAR2 := FND_API.G_FALSE
493: --
494: -- Standard OUT Parameters :
495: -- x_return_status VARCHAR2 Required
496: -- x_msg_count NUMBER Required
504: --
505: -- End of Comments --
506: PROCEDURE UPDATE_WO_AOG_STATUS(
507: P_API_VERSION IN NUMBER := 1.0,
508: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_TRUE,
509: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
510: --p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
511: P_WORKORDER_ID_TBL IN WORKORDER_ID_TBL_TYPE,
512: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
505: -- End of Comments --
506: PROCEDURE UPDATE_WO_AOG_STATUS(
507: P_API_VERSION IN NUMBER := 1.0,
508: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_TRUE,
509: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
510: --p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
511: P_WORKORDER_ID_TBL IN WORKORDER_ID_TBL_TYPE,
512: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
513: X_MSG_COUNT OUT NOCOPY NUMBER,
506: PROCEDURE UPDATE_WO_AOG_STATUS(
507: P_API_VERSION IN NUMBER := 1.0,
508: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_TRUE,
509: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
510: --p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
511: P_WORKORDER_ID_TBL IN WORKORDER_ID_TBL_TYPE,
512: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
513: X_MSG_COUNT OUT NOCOPY NUMBER,
514: X_MSG_DATA OUT NOCOPY varchar2 );