244: -- Parameters :
245: --
246: -- Standard IN Parameters :
247: -- p_api_version IN NUMBER Required
248: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
249: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
250: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
251: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
252: -- p_module_type IN VARCHAR2 Default NULL.
245: --
246: -- Standard IN Parameters :
247: -- p_api_version IN NUMBER Required
248: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
249: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
250: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
251: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
252: -- p_module_type IN VARCHAR2 Default NULL.
253: --
246: -- Standard IN Parameters :
247: -- p_api_version IN NUMBER Required
248: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
249: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
250: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
251: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
252: -- p_module_type IN VARCHAR2 Default NULL.
253: --
254: -- Standard OUT Parameters :
247: -- p_api_version IN NUMBER Required
248: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
249: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
250: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
251: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
252: -- p_module_type IN VARCHAR2 Default NULL.
253: --
254: -- Standard OUT Parameters :
255: -- x_return_status OUT VARCHAR2 Required
264: -- Initial Version 1.0
265: --------------------------------------------------------------------
266: PROCEDURE Process_Visit (
267: p_api_version IN NUMBER,
268: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
269: p_commit IN VARCHAR2 := FND_API.g_false,
270: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
271: p_module_type IN VARCHAR2 := 'JSP',
272: p_x_Visit_tbl IN OUT NOCOPY Visit_Tbl_Type,
265: --------------------------------------------------------------------
266: PROCEDURE Process_Visit (
267: p_api_version IN NUMBER,
268: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
269: p_commit IN VARCHAR2 := FND_API.g_false,
270: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
271: p_module_type IN VARCHAR2 := 'JSP',
272: p_x_Visit_tbl IN OUT NOCOPY Visit_Tbl_Type,
273: x_return_status OUT NOCOPY VARCHAR2,
266: PROCEDURE Process_Visit (
267: p_api_version IN NUMBER,
268: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
269: p_commit IN VARCHAR2 := FND_API.g_false,
270: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
271: p_module_type IN VARCHAR2 := 'JSP',
272: p_x_Visit_tbl IN OUT NOCOPY Visit_Tbl_Type,
273: x_return_status OUT NOCOPY VARCHAR2,
274: x_msg_count OUT NOCOPY NUMBER,
282: -- Parameters :
283: --
284: -- Standard IN Parameters :
285: -- p_api_version IN NUMBER Required
286: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
287: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
288: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
289: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
290: -- p_module_type IN VARCHAR2 Default NULL.
283: --
284: -- Standard IN Parameters :
285: -- p_api_version IN NUMBER Required
286: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
287: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
288: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
289: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
290: -- p_module_type IN VARCHAR2 Default NULL.
291: --
284: -- Standard IN Parameters :
285: -- p_api_version IN NUMBER Required
286: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
287: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
288: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
289: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
290: -- p_module_type IN VARCHAR2 Default NULL.
291: --
292: -- Standard OUT Parameters :
285: -- p_api_version IN NUMBER Required
286: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
287: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
288: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
289: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
290: -- p_module_type IN VARCHAR2 Default NULL.
291: --
292: -- Standard OUT Parameters :
293: -- x_return_status OUT VARCHAR2 Required
304: -- Initial Version 1.0
305: -------------------------------------------------------------------
306: PROCEDURE Get_Visit_Details (
307: p_api_version IN NUMBER,
308: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
309: p_commit IN VARCHAR2 := Fnd_Api.g_false,
310: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
311: p_module_type IN VARCHAR2 := 'JSP',
312: p_visit_id IN NUMBER,
305: -------------------------------------------------------------------
306: PROCEDURE Get_Visit_Details (
307: p_api_version IN NUMBER,
308: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
309: p_commit IN VARCHAR2 := Fnd_Api.g_false,
310: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
311: p_module_type IN VARCHAR2 := 'JSP',
312: p_visit_id IN NUMBER,
313: x_Visit_rec OUT NOCOPY Visit_Rec_Type,
306: PROCEDURE Get_Visit_Details (
307: p_api_version IN NUMBER,
308: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
309: p_commit IN VARCHAR2 := Fnd_Api.g_false,
310: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
311: p_module_type IN VARCHAR2 := 'JSP',
312: p_visit_id IN NUMBER,
313: x_Visit_rec OUT NOCOPY Visit_Rec_Type,
314: x_return_status OUT NOCOPY VARCHAR2,
324: -- Parameters :
325: --
326: -- Standard IN Parameters :
327: -- p_api_version IN NUMBER Required
328: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
329: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
330: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
331: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
332: -- p_module_type IN VARCHAR2 Default NULL.
325: --
326: -- Standard IN Parameters :
327: -- p_api_version IN NUMBER Required
328: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
329: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
330: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
331: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
332: -- p_module_type IN VARCHAR2 Default NULL.
333: --
326: -- Standard IN Parameters :
327: -- p_api_version IN NUMBER Required
328: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
329: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
330: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
331: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
332: -- p_module_type IN VARCHAR2 Default NULL.
333: --
334: -- Standard OUT Parameters :
327: -- p_api_version IN NUMBER Required
328: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
329: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
330: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
331: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
332: -- p_module_type IN VARCHAR2 Default NULL.
333: --
334: -- Standard OUT Parameters :
335: -- x_return_status OUT VARCHAR2 Required
344: -- Initial Version 1.0
345: -------------------------------------------------------------------
346: PROCEDURE UMP_Visit_Info (
347: p_api_version IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
349: p_commit IN VARCHAR2 := Fnd_Api.g_false,
350: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
351: p_module_type IN VARCHAR2 := Null,
352: p_unit_effectivity_id IN NUMBER,
345: -------------------------------------------------------------------
346: PROCEDURE UMP_Visit_Info (
347: p_api_version IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
349: p_commit IN VARCHAR2 := Fnd_Api.g_false,
350: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
351: p_module_type IN VARCHAR2 := Null,
352: p_unit_effectivity_id IN NUMBER,
353:
346: PROCEDURE UMP_Visit_Info (
347: p_api_version IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
349: p_commit IN VARCHAR2 := Fnd_Api.g_false,
350: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
351: p_module_type IN VARCHAR2 := Null,
352: p_unit_effectivity_id IN NUMBER,
353:
354: x_ump_visit_rec OUT NOCOPY Srch_UMP_Rec_Type,
364: -- Parameters :
365: --
366: -- Standard IN Parameters :
367: -- p_api_version IN NUMBER Required
368: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
369: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
370: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
371: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
372: -- p_module_type IN VARCHAR2 Default NULL.
365: --
366: -- Standard IN Parameters :
367: -- p_api_version IN NUMBER Required
368: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
369: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
370: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
371: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
372: -- p_module_type IN VARCHAR2 Default NULL.
373: --
366: -- Standard IN Parameters :
367: -- p_api_version IN NUMBER Required
368: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
369: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
370: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
371: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
372: -- p_module_type IN VARCHAR2 Default NULL.
373: --
374: -- Standard OUT Parameters :
367: -- p_api_version IN NUMBER Required
368: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
369: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
370: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
371: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
372: -- p_module_type IN VARCHAR2 Default NULL.
373: --
374: -- Standard OUT Parameters :
375: -- x_return_status OUT VARCHAR2 Required
385: -- Added by Srini p_x_cost_session, p_x_mr_session to support costing functionality
386: -------------------------------------------------------------------
387: PROCEDURE Close_Visit(
388: p_api_version IN NUMBER,
389: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
390: p_commit IN VARCHAR2 := Fnd_Api.g_false,
391: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
392: p_module_type IN VARCHAR2 := Null,
393: p_visit_id IN NUMBER,
386: -------------------------------------------------------------------
387: PROCEDURE Close_Visit(
388: p_api_version IN NUMBER,
389: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
390: p_commit IN VARCHAR2 := Fnd_Api.g_false,
391: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
392: p_module_type IN VARCHAR2 := Null,
393: p_visit_id IN NUMBER,
394: p_x_cost_session_id IN OUT NOCOPY NUMBER,
387: PROCEDURE Close_Visit(
388: p_api_version IN NUMBER,
389: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
390: p_commit IN VARCHAR2 := Fnd_Api.g_false,
391: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
392: p_module_type IN VARCHAR2 := Null,
393: p_visit_id IN NUMBER,
394: p_x_cost_session_id IN OUT NOCOPY NUMBER,
395: p_x_mr_session_id IN OUT NOCOPY NUMBER,
407: -- Parameters :
408: --
409: -- Standard IN Parameters :
410: -- p_api_version IN NUMBER Required
411: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
412: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
413: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
414: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
415: -- p_module_type IN VARCHAR2 Default NULL.
408: --
409: -- Standard IN Parameters :
410: -- p_api_version IN NUMBER Required
411: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
412: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
413: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
414: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
415: -- p_module_type IN VARCHAR2 Default NULL.
416: --
409: -- Standard IN Parameters :
410: -- p_api_version IN NUMBER Required
411: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
412: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
413: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
414: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
415: -- p_module_type IN VARCHAR2 Default NULL.
416: --
417: -- Standard OUT Parameters :
410: -- p_api_version IN NUMBER Required
411: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
412: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
413: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
414: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
415: -- p_module_type IN VARCHAR2 Default NULL.
416: --
417: -- Standard OUT Parameters :
418: -- x_return_status OUT VARCHAR2 Required
429: -- Initial Version 1.0
430: -------------------------------------------------------------------
431: PROCEDURE Cancel_Visit(
432: p_api_version IN NUMBER := 1.0,
433: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
434: p_commit IN VARCHAR2 := Fnd_Api.g_false,
435: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
436: p_module_type IN VARCHAR2 := Null,
437: p_visit_id IN NUMBER,
430: -------------------------------------------------------------------
431: PROCEDURE Cancel_Visit(
432: p_api_version IN NUMBER := 1.0,
433: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
434: p_commit IN VARCHAR2 := Fnd_Api.g_false,
435: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
436: p_module_type IN VARCHAR2 := Null,
437: p_visit_id IN NUMBER,
438: p_obj_ver_num IN NUMBER,
431: PROCEDURE Cancel_Visit(
432: p_api_version IN NUMBER := 1.0,
433: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
434: p_commit IN VARCHAR2 := Fnd_Api.g_false,
435: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
436: p_module_type IN VARCHAR2 := Null,
437: p_visit_id IN NUMBER,
438: p_obj_ver_num IN NUMBER,
439: x_return_status OUT NOCOPY VARCHAR2,
532:
533: PROCEDURE Validate_Component_Visit
534: (
535: p_api_version IN NUMBER := 1.0,
536: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
537: p_commit IN VARCHAR2 := FND_API.G_FALSE,
538: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
539: p_module_type IN VARCHAR2,
540: p_visit_rec IN VISIT_REC_TYPE,
533: PROCEDURE Validate_Component_Visit
534: (
535: p_api_version IN NUMBER := 1.0,
536: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
537: p_commit IN VARCHAR2 := FND_API.G_FALSE,
538: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
539: p_module_type IN VARCHAR2,
540: p_visit_rec IN VISIT_REC_TYPE,
541: x_return_status OUT NOCOPY VARCHAR2,
534: (
535: p_api_version IN NUMBER := 1.0,
536: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
537: p_commit IN VARCHAR2 := FND_API.G_FALSE,
538: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
539: p_module_type IN VARCHAR2,
540: p_visit_rec IN VISIT_REC_TYPE,
541: x_return_status OUT NOCOPY VARCHAR2,
542: x_msg_count OUT NOCOPY NUMBER,
546: -- SKPATHAK :: AVF ER: 13416865 :: 25-NOV-2011 :: START
547: -- To Create a Maintenance Visit
548: PROCEDURE Create_Visit (
549: p_api_version IN NUMBER,
550: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
551: p_commit IN VARCHAR2 := Fnd_Api.g_false,
552: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
553: p_module_type IN VARCHAR2 := 'JSP',
554: p_x_visit_rec IN OUT NOCOPY visit_rec_type,
547: -- To Create a Maintenance Visit
548: PROCEDURE Create_Visit (
549: p_api_version IN NUMBER,
550: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
551: p_commit IN VARCHAR2 := Fnd_Api.g_false,
552: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
553: p_module_type IN VARCHAR2 := 'JSP',
554: p_x_visit_rec IN OUT NOCOPY visit_rec_type,
555: x_return_status OUT NOCOPY VARCHAR2,
548: PROCEDURE Create_Visit (
549: p_api_version IN NUMBER,
550: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
551: p_commit IN VARCHAR2 := Fnd_Api.g_false,
552: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
553: p_module_type IN VARCHAR2 := 'JSP',
554: p_x_visit_rec IN OUT NOCOPY visit_rec_type,
555: x_return_status OUT NOCOPY VARCHAR2,
556: x_msg_count OUT NOCOPY NUMBER,
559:
560:
561: PROCEDURE Update_Visit (
562: p_api_version IN NUMBER,
563: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
564: p_commit IN VARCHAR2 := Fnd_Api.g_false,
565: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
566: p_module_type IN VARCHAR2 := 'JSP',
567: p_x_visit_rec IN OUT NOCOPY Visit_Rec_Type,
560:
561: PROCEDURE Update_Visit (
562: p_api_version IN NUMBER,
563: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
564: p_commit IN VARCHAR2 := Fnd_Api.g_false,
565: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
566: p_module_type IN VARCHAR2 := 'JSP',
567: p_x_visit_rec IN OUT NOCOPY Visit_Rec_Type,
568: x_return_status OUT NOCOPY VARCHAR2,
561: PROCEDURE Update_Visit (
562: p_api_version IN NUMBER,
563: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
564: p_commit IN VARCHAR2 := Fnd_Api.g_false,
565: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
566: p_module_type IN VARCHAR2 := 'JSP',
567: p_x_visit_rec IN OUT NOCOPY Visit_Rec_Type,
568: x_return_status OUT NOCOPY VARCHAR2,
569: x_msg_count OUT NOCOPY NUMBER,
573:
574: -- TCHIMIRA :: AVF ER: 13416865 :: 14-DEC-2011 :: Adding the below since it is now called from another package
575: PROCEDURE Delete_Visit (
576: p_api_version IN NUMBER,
577: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
578: p_commit IN VARCHAR2 := Fnd_Api.g_false,
579: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
580: p_visit_id IN NUMBER,
581: x_return_status OUT NOCOPY VARCHAR2,
574: -- TCHIMIRA :: AVF ER: 13416865 :: 14-DEC-2011 :: Adding the below since it is now called from another package
575: PROCEDURE Delete_Visit (
576: p_api_version IN NUMBER,
577: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
578: p_commit IN VARCHAR2 := Fnd_Api.g_false,
579: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
580: p_visit_id IN NUMBER,
581: x_return_status OUT NOCOPY VARCHAR2,
582: x_msg_count OUT NOCOPY NUMBER,
575: PROCEDURE Delete_Visit (
576: p_api_version IN NUMBER,
577: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
578: p_commit IN VARCHAR2 := Fnd_Api.g_false,
579: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
580: p_visit_id IN NUMBER,
581: x_return_status OUT NOCOPY VARCHAR2,
582: x_msg_count OUT NOCOPY NUMBER,
583: x_msg_data OUT NOCOPY VARCHAR2