DBA Data[Home] [Help]

APPS.JTF_TASK_TEMPLATES_PUB dependencies on JTF_TASK_UTL

Line 285: jtf_task_utl.validate_task_type (

281:
282: -------
283: ------- Validate Task Type
284: -------
285: jtf_task_utl.validate_task_type (
286: p_task_type_id => p_task_type_id,
287: p_task_type_name => p_task_type_name,
288: x_return_status => x_return_status,
289: x_task_type_id => l_task_type_id

Line 308: jtf_task_utl.validate_task_status (

304: else
305: l_type := 'TASK';
306: end if;
307:
308: jtf_task_utl.validate_task_status (
309: p_task_status_id => p_task_status_id,
310: p_task_status_name => p_task_status_name,
311: p_validation_type => l_type,
312: x_return_status => x_return_status,

Line 327: jtf_task_utl.validate_task_priority (

323:
324: -------
325: ------- Validate Task Priority
326: -------
327: jtf_task_utl.validate_task_priority (
328: p_task_priority_id => p_task_priority_id,
329: p_task_priority_name => p_task_priority_name,
330: x_return_status => x_return_status,
331: x_task_priority_id => l_task_priority_id

Line 338: jtf_task_utl.validate_effort (

334:
335: -------
336: ------- Validate Duration
337: -------
338: jtf_task_utl.validate_effort (
339: p_tag => 'Duration',
340: p_tag_uom => 'Duration UOM',
341: x_return_status => x_return_status,
342: p_effort => p_duration,

Line 355: jtf_task_utl.validate_effort (

351:
352: -------
353: ------- Validate Planned Effort
354: -------
355: jtf_task_utl.validate_effort (
356: p_tag => 'Planned Effort',
357: p_tag_uom => 'Planned Effort Unit of Measure',
358: x_return_status => x_return_status,
359: p_effort => p_planned_effort,

Line 371: jtf_task_utl.validate_flag (x_return_status => x_return_status, p_flag_name => 'Private Flag', p_flag_value => p_private_flag);

367:
368: -------
369: ------- Call the private flag
370: -------
371: jtf_task_utl.validate_flag (x_return_status => x_return_status, p_flag_name => 'Private Flag', p_flag_value => p_private_flag);
372:
373: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
374: THEN
375: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 384: jtf_task_utl.validate_flag (x_return_status => x_return_status, p_flag_name => 'Publish Flag', p_flag_value => p_publish_flag);

380:
381: -------
382: ------- Call the publish flag
383: -------
384: jtf_task_utl.validate_flag (x_return_status => x_return_status, p_flag_name => 'Publish Flag', p_flag_value => p_publish_flag);
385:
386: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
387: THEN
388: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 395: jtf_task_utl.validate_flag (

391:
392: -------
393: ------- Call the Restrict closure flag
394: -------
395: jtf_task_utl.validate_flag (
396: p_api_name => l_api_name,
397: p_init_msg_list => fnd_api.g_false,
398: x_return_status => x_return_status,
399: p_flag_name => 'Restrict Closure Flag',

Line 412: jtf_task_utl.validate_flag (

408:
409: -------
410: ------- Call the Multi Booked flag
411: -------
412: jtf_task_utl.validate_flag (
413: p_api_name => l_api_name,
414: p_init_msg_list => fnd_api.g_false,
415: x_return_status => x_return_status,
416: p_flag_name => 'Multi Booked Flag',

Line 429: jtf_task_utl.validate_flag (

425:
426: -------
427: ------- Call the milestone flag
428: -------
429: jtf_task_utl.validate_flag (
430: p_api_name => l_api_name,
431: p_init_msg_list => fnd_api.g_false,
432: x_return_status => x_return_status,
433: p_flag_name => 'Milestone Flag',

Line 446: jtf_task_utl.validate_flag (

442:
443: -------
444: ------- Call the Holiday Flag
445: -------
446: jtf_task_utl.validate_flag (
447: p_api_name => l_api_name,
448: p_init_msg_list => fnd_api.g_false,
449: x_return_status => x_return_status,
450: p_flag_name => 'Holiday Flag',

Line 463: jtf_task_utl.validate_flag (x_return_status => x_return_status, p_flag_name => 'Billable Flag', p_flag_value => p_billable_flag);

459:
460: -------
461: ------- Call the Billable Flag
462: -------
463: jtf_task_utl.validate_flag (x_return_status => x_return_status, p_flag_name => 'Billable Flag', p_flag_value => p_billable_flag);
464:
465: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
466: THEN
467: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 474: jtf_task_utl.validate_notification (

470:
471: -------
472: ------- Call the Validate Notification Parameters
473: -------
474: jtf_task_utl.validate_notification (
475: p_notification_flag => p_notification_flag,
476: p_notification_period => p_notification_period,
477: p_notification_period_uom => p_notification_period_uom,
478: x_return_status => x_return_status

Line 491: jtf_task_utl.validate_task_template_group (

487:
488: -------
489: ------- Call the Validate Task Template Group
490: -------
491: jtf_task_utl.validate_task_template_group (
492: p_task_template_group_id => p_task_group_id ,
493: p_task_template_group_name => p_task_group_name,
494: x_return_status => x_return_status ,
495: x_task_template_group_id => l_task_group_id );

Line 604: p_template_flag => jtf_task_utl.g_yes,

600: p_task_id => x_task_id,
601: p_dependent_on_task_id => p_task_depends_tbl (current_record).dependent_on_task_id,
602: p_dependent_on_task_number => p_task_depends_tbl (current_record).dependent_on_task_number,
603: p_dependency_type_code => p_task_depends_tbl (current_record).dependency_type_code,
604: p_template_flag => jtf_task_utl.g_yes,
605: p_adjustment_time => p_task_depends_tbl (current_record).adjustment_time,
606: p_adjustment_time_uom => p_task_depends_tbl (current_record).adjustment_time_uom,
607: p_validated_flag => p_task_depends_tbl (current_record).validated_flag,
608: x_dependency_id => l_dependency_id,

Line 647: p_template_flag => jtf_task_utl.g_yes,

643: p_init_msg_list => fnd_api.g_false,
644: p_commit => fnd_api.g_false,
645: p_task_id => x_task_id,
646: p_occurs_which => p_task_recur_rec.occurs_which,
647: p_template_flag => jtf_task_utl.g_yes,
648: p_day_of_week => p_task_recur_rec.day_of_week,
649: p_date_of_month => p_task_recur_rec.date_of_month,
650: p_occurs_month => p_task_recur_rec.occurs_month,
651: p_occurs_uom => p_task_recur_rec.occurs_uom,

Line 802: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

798: p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
799: x_return_status OUT NOCOPY VARCHAR2,
800: x_msg_count OUT NOCOPY NUMBER,
801: x_msg_data OUT NOCOPY VARCHAR2,
802: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
803: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
804: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
805: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
806: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 803: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

799: x_return_status OUT NOCOPY VARCHAR2,
800: x_msg_count OUT NOCOPY NUMBER,
801: x_msg_data OUT NOCOPY VARCHAR2,
802: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
803: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
804: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
805: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
806: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
807: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 804: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

800: x_msg_count OUT NOCOPY NUMBER,
801: x_msg_data OUT NOCOPY VARCHAR2,
802: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
803: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
804: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
805: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
806: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
807: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
808: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 805: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

801: x_msg_data OUT NOCOPY VARCHAR2,
802: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
803: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
804: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
805: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
806: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
807: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
808: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
809: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 806: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

802: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
803: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
804: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
805: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
806: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
807: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
808: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
809: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
810: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 807: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

803: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
804: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
805: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
806: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
807: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
808: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
809: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
810: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
811: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 808: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

804: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
805: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
806: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
807: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
808: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
809: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
810: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
811: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
812: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 809: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

805: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
806: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
807: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
808: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
809: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
810: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
811: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
812: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
813: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 810: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

806: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
807: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
808: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
809: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
810: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
811: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
812: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
813: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
814: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 811: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

807: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
808: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
809: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
810: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
811: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
812: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
813: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
814: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
815: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 812: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

808: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
809: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
810: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
811: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
812: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
813: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
814: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
815: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
816: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 813: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

809: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
810: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
811: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
812: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
813: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
814: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
815: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
816: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
817: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 814: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

810: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
811: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
812: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
813: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
814: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
815: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
816: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
817: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
818: p_task_confirmation_status IN VARCHAR2

Line 815: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

811: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
812: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
813: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
814: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
815: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
816: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
817: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
818: p_task_confirmation_status IN VARCHAR2
819: ) is

Line 816: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

812: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
813: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
814: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
815: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
816: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
817: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
818: p_task_confirmation_status IN VARCHAR2
819: ) is
820: l_api_version CONSTANT NUMBER := 1.0;

Line 817: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

813: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
814: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
815: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
816: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
817: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
818: p_task_confirmation_status IN VARCHAR2
819: ) is
820: l_api_version CONSTANT NUMBER := 1.0;
821: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_TEMPLATE';

Line 903: decode( p_task_confirmation_status,jtf_task_utl.g_miss_char,task_confirmation_status,p_task_confirmation_status)

899: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
900: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
901: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
902: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
903: decode( p_task_confirmation_status,jtf_task_utl.g_miss_char,task_confirmation_status,p_task_confirmation_status)
904: task_confirmation_status
905: FROM jtf_task_templates_vl
906: WHERE task_template_id = l_task_id;
907:

Line 945: jtf_task_utl.validate_task_template (

941: FROM dual;
942: SELECT DECODE (l_task_number, fnd_api.g_miss_char, NULL, l_task_number)
943: INTO l_task_number
944: FROM dual;
945: jtf_task_utl.validate_task_template (
946: p_task_id => l_task_id,
947: p_task_number => l_task_number,
948: x_task_id => l_task_id,
949: x_return_status => x_return_status

Line 1009: jtf_task_utl.validate_task_type (

1005: l_task_type_id := task_rec.task_type_id;
1006: ELSIF ( l_task_type_name = fnd_api.g_miss_char
1007: AND l_task_type_id <> fnd_api.g_miss_num)
1008: THEN
1009: jtf_task_utl.validate_task_type (
1010: p_task_type_id => l_task_type_id,
1011: p_task_type_name => NULL,
1012: x_return_status => x_return_status,
1013: x_task_type_id => l_task_type_id

Line 1018: jtf_task_utl.validate_task_type (

1014: );
1015: ELSIF ( l_task_type_name <> fnd_api.g_miss_char
1016: AND l_task_type_id = fnd_api.g_miss_num)
1017: THEN
1018: jtf_task_utl.validate_task_type (
1019: p_task_type_id => NULL,
1020: p_task_type_name => l_task_type_name,
1021: x_return_status => x_return_status,
1022: x_task_type_id => l_task_type_id

Line 1025: jtf_task_utl.validate_task_type (

1021: x_return_status => x_return_status,
1022: x_task_type_id => l_task_type_id
1023: );
1024: ELSE
1025: jtf_task_utl.validate_task_type (
1026: p_task_type_id => l_task_type_id,
1027: p_task_type_name => l_task_type_name,
1028: x_return_status => x_return_status,
1029: x_task_type_id => l_task_type_id

Line 1064: jtf_task_utl.validate_task_status (

1060: l_task_status_id := task_rec.task_status_id;
1061: ELSIF ( l_task_status_name = fnd_api.g_miss_char
1062: AND l_task_status_id <> fnd_api.g_miss_num)
1063: THEN
1064: jtf_task_utl.validate_task_status (
1065: p_task_status_id => l_task_status_id,
1066: p_task_status_name => NULL,
1067: p_validation_type => l_type,
1068: x_return_status => x_return_status,

Line 1074: jtf_task_utl.validate_task_status (

1070: );
1071: ELSIF ( l_task_status_name <> fnd_api.g_miss_char
1072: AND l_task_status_id = fnd_api.g_miss_num)
1073: THEN
1074: jtf_task_utl.validate_task_status (
1075: p_task_status_id => NULL,
1076: p_task_status_name => l_task_status_name,
1077: p_validation_type => l_type,
1078: x_return_status => x_return_status,

Line 1082: jtf_task_utl.validate_task_status (

1078: x_return_status => x_return_status,
1079: x_task_status_id => l_task_status_id
1080: );
1081: ELSE
1082: jtf_task_utl.validate_task_status (
1083: p_task_status_id => l_task_status_id,
1084: p_task_status_name => l_task_status_name,
1085: p_validation_type => l_type,
1086: x_return_status => x_return_status,

Line 1116: jtf_task_utl.validate_task_priority (

1112: l_task_priority_id := task_rec.task_priority_id;
1113: ELSIF ( l_task_priority_name = fnd_api.g_miss_char
1114: AND l_task_priority_id <> fnd_api.g_miss_num)
1115: THEN
1116: jtf_task_utl.validate_task_priority (
1117: p_task_priority_id => l_task_priority_id,
1118: p_task_priority_name => NULL,
1119: x_return_status => x_return_status,
1120: x_task_priority_id => l_task_priority_id

Line 1125: jtf_task_utl.validate_task_priority (

1121: );
1122: ELSIF ( l_task_priority_name <> fnd_api.g_miss_char
1123: AND l_task_priority_id = fnd_api.g_miss_num)
1124: THEN
1125: jtf_task_utl.validate_task_priority (
1126: p_task_priority_id => NULL,
1127: p_task_priority_name => l_task_priority_name,
1128: x_return_status => x_return_status,
1129: x_task_priority_id => l_task_priority_id

Line 1132: jtf_task_utl.validate_task_priority (

1128: x_return_status => x_return_status,
1129: x_task_priority_id => l_task_priority_id
1130: );
1131: ELSE
1132: jtf_task_utl.validate_task_priority (
1133: p_task_priority_id => l_task_priority_id,
1134: p_task_priority_name => l_task_priority_name,
1135: x_return_status => x_return_status,
1136: x_task_priority_id => l_task_priority_id

Line 1170: jtf_task_utl.validate_effort (

1166: ELSE
1167: l_duration_uom := task_rec.duration_uom;
1168: END IF;
1169:
1170: jtf_task_utl.validate_effort (
1171: p_tag => 'Duration',
1172: p_tag_uom => 'Duration UOM',
1173: p_effort => l_duration,
1174: p_effort_uom => l_duration_uom,

Line 1215: jtf_task_utl.validate_effort (

1211: END IF;
1212: */
1213:
1214:
1215: jtf_task_utl.validate_effort (
1216: p_tag => 'Planned Effort',
1217: p_tag_uom => 'Planned Effort Unit of Measure',
1218: p_effort => l_planned_effort,
1219: p_effort_uom => l_planned_effort_uom,

Line 1232: jtf_task_utl.validate_flag (p_flag_name => 'Private Flag', p_flag_value => p_private_flag, x_return_status => x_return_status);

1228: END IF;
1229:
1230: IF p_private_flag <> fnd_api.g_miss_char
1231: THEN
1232: jtf_task_utl.validate_flag (p_flag_name => 'Private Flag', p_flag_value => p_private_flag, x_return_status => x_return_status);
1233:
1234: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1235: THEN
1236: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1251: jtf_task_utl.validate_flag (p_flag_name => 'Publish Flag', p_flag_value => p_publish_flag, x_return_status => x_return_status);

1247: -------
1248: IF p_publish_flag <> fnd_api.g_miss_char
1249: OR p_publish_flag IS NULL
1250: THEN
1251: jtf_task_utl.validate_flag (p_flag_name => 'Publish Flag', p_flag_value => p_publish_flag, x_return_status => x_return_status);
1252:
1253: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1254: THEN
1255: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1272: jtf_task_utl.validate_flag (

1268: -------
1269: IF p_restrict_closure_flag <> fnd_api.g_miss_char
1270: OR p_restrict_closure_flag IS NULL
1271: THEN
1272: jtf_task_utl.validate_flag (
1273: p_flag_name => 'Restrict Closure Flag',
1274: p_flag_value => p_restrict_closure_flag,
1275: x_return_status => x_return_status
1276: );

Line 1295: jtf_task_utl.validate_flag (p_flag_name => 'Multi Booked Flag', p_flag_value => p_multi_booked_flag, x_return_status => x_return_status);

1291: -------
1292: IF p_multi_booked_flag <> fnd_api.g_miss_char
1293: OR p_multi_booked_flag IS NULL
1294: THEN
1295: jtf_task_utl.validate_flag (p_flag_name => 'Multi Booked Flag', p_flag_value => p_multi_booked_flag, x_return_status => x_return_status);
1296:
1297: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1298: THEN
1299: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1314: jtf_task_utl.validate_flag (p_flag_name => 'Milestone Flag', p_flag_value => p_milestone_flag, x_return_status => x_return_status);

1310: -------
1311: IF p_milestone_flag <> fnd_api.g_miss_char
1312: OR p_milestone_flag IS NULL
1313: THEN
1314: jtf_task_utl.validate_flag (p_flag_name => 'Milestone Flag', p_flag_value => p_milestone_flag, x_return_status => x_return_status);
1315:
1316: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1317: THEN
1318: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1334: jtf_task_utl.validate_flag (p_flag_name => 'Holiday Flag', p_flag_value => p_holiday_flag, x_return_status => x_return_status);

1330:
1331: IF p_holiday_flag <> fnd_api.g_miss_char
1332: OR p_holiday_flag IS NULL
1333: THEN
1334: jtf_task_utl.validate_flag (p_flag_name => 'Holiday Flag', p_flag_value => p_holiday_flag, x_return_status => x_return_status);
1335:
1336: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1337: THEN
1338: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1353: jtf_task_utl.validate_flag (p_flag_name => 'Billable Flag', p_flag_value => p_billable_flag, x_return_status => x_return_status);

1349: -------
1350:
1351: IF p_billable_flag <> fnd_api.g_miss_char
1352: THEN
1353: jtf_task_utl.validate_flag (p_flag_name => 'Billable Flag', p_flag_value => p_billable_flag, x_return_status => x_return_status);
1354:
1355: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1356: THEN
1357: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1389: jtf_task_utl.validate_alarm (

1385: l_alarm_on := task_rec.alarm_on;
1386: l_alarm_interval := task_rec.alarm_interval;
1387: l_alarm_interval_uom := task_rec.alarm_interval_uom;
1388: l_alarm_count := task_rec.alarm_count;
1389: jtf_task_utl.validate_alarm (
1390: p_alarm_start => l_alarm_start,
1391: p_alarm_start_uom => l_alarm_start_uom,
1392: p_alarm_on => l_alarm_on,
1393: p_alarm_count => l_alarm_count,

Line 1429: jtf_task_utl.validate_notification (

1425: THEN
1426: l_notification_flag := task_rec.notification_flag;
1427: l_notification_period := task_rec.notification_period;
1428: l_notification_period_uom := task_rec.notification_period_uom;
1429: jtf_task_utl.validate_notification (
1430: p_notification_flag => l_notification_flag,
1431: p_notification_period => l_notification_period,
1432: p_notification_period_uom => l_notification_period_uom,
1433: x_return_status => x_return_status

Line 1559: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1555: p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1556: x_return_status OUT NOCOPY VARCHAR2,
1557: x_msg_count OUT NOCOPY NUMBER,
1558: x_msg_data OUT NOCOPY VARCHAR2,
1559: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1560: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1561: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1562: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1563: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1560: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1556: x_return_status OUT NOCOPY VARCHAR2,
1557: x_msg_count OUT NOCOPY NUMBER,
1558: x_msg_data OUT NOCOPY VARCHAR2,
1559: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1560: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1561: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1562: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1563: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1564: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1561: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1557: x_msg_count OUT NOCOPY NUMBER,
1558: x_msg_data OUT NOCOPY VARCHAR2,
1559: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1560: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1561: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1562: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1563: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1564: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1565: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1562: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1558: x_msg_data OUT NOCOPY VARCHAR2,
1559: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1560: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1561: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1562: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1563: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1564: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1565: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1566: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1563: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1559: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1560: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1561: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1562: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1563: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1564: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1565: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1566: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1567: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1564: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1560: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1561: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1562: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1563: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1564: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1565: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1566: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1567: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1568: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1565: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1561: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1562: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1563: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1564: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1565: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1566: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1567: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1568: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1569: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1566: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1562: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1563: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1564: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1565: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1566: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1567: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1568: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1569: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1570: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1567: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1563: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1564: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1565: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1566: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1567: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1568: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1569: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1570: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1571: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1568: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1564: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1565: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1566: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1567: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1568: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1569: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1570: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1571: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1572: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1569: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1565: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1566: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1567: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1568: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1569: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1570: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1571: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1572: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1573: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

Line 1570: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1566: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1567: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1568: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1569: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1570: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1571: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1572: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1573: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1574: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

Line 1571: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1567: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1568: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1569: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1570: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1571: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1572: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1573: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1574: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1575: )

Line 1572: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1568: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1569: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1570: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1571: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1572: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1573: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1574: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1575: )
1576: IS

Line 1573: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

1569: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1570: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1571: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1572: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1573: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1574: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1575: )
1576: IS
1577: l_api_version CONSTANT NUMBER := 1.0;

Line 1574: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char

1570: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1571: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1572: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1573: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
1574: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1575: )
1576: IS
1577: l_api_version CONSTANT NUMBER := 1.0;
1578: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK';

Line 1731: jtf_task_utl.validate_task_template (

1727: fnd_msg_pub.add;
1728: x_return_status := fnd_api.g_ret_sts_unexp_error;
1729: RAISE fnd_api.g_exc_unexpected_error;
1730: ELSE
1731: jtf_task_utl.validate_task_template (
1732: p_task_id => l_task_id,
1733: p_task_number => l_task_number,
1734: x_task_id => l_task_id,
1735: x_return_status => x_return_status