DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on FND_API

Line 197: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 198: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 199: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 200: p_default IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 212: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 213: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 215: p_default IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 245: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 246: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 247: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 258: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 259: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 260: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 261: p_default IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 274: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 275: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 276: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 277: p_default IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 290: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 291: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 293: p_default IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 306: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 307: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 308: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 309: p_default IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 336: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 337: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 338: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 339: p_default IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 370: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 371: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 372: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 373: p_default IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 430: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 431: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 432: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 448: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 449: p_default IN VARCHAR2 := FND_API.G_FALSE,

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.

Line 456: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 457: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 458: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 491: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE

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

Line 492: -- p_commit VARCHAR2 := FND_API.G_FALSE

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

Line 508: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 509: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 510: --p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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