[Home] [Help]
52: p_attribute13 IN VARCHAR2 DEFAULT NULL,
53: p_attribute14 IN VARCHAR2 DEFAULT NULL,
54: p_attribute15 IN VARCHAR2 DEFAULT NULL,
55: p_attribute_category IN VARCHAR2 DEFAULT NULL,
56: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
57: p_category_id IN NUMBER DEFAULT NULL,
58: p_enable_workflow IN VARCHAR2,
59: p_abort_workflow IN VARCHAR2,
60: p_object_capacity_id IN NUMBER,
196:
197: -------
198: ------- Validate the task
199: -------
200: jtf_task_utl.validate_task (
201: x_return_status => x_return_status,
202: p_task_id => l_task_id,
203: p_task_number => l_task_number,
204: x_task_id => l_task_id
220:
221: -----
222: ----- Validate the assigned resource.
223: -----
224: jtf_task_utl.validate_task_owner (
225: p_owner_type_code => p_resource_type_code,
226: p_owner_id => p_resource_id,
227: x_return_status => x_return_status,
228: x_owner_id => l_resource_id,
255:
256: -----
257: ----- Validate Assignment Status Id
258: -----
259: jtf_task_utl.validate_task_status (
260: p_task_status_id => l_assignment_status_id,
261: p_task_status_name => NULL,
262: p_validation_type => 'ASSIGNMENT',
263: x_return_status => x_return_status,
273:
274: -------
275: ------- Validate actual effort
276: -------
277: jtf_task_utl.validate_effort (
278: p_tag => jtf_task_utl.get_translated_lookup (
279: 'JTF_TASK_TRANSLATED_MESSAGES',
280: 'ACTUAL_EFFORT'
281: ),
274: -------
275: ------- Validate actual effort
276: -------
277: jtf_task_utl.validate_effort (
278: p_tag => jtf_task_utl.get_translated_lookup (
279: 'JTF_TASK_TRANSLATED_MESSAGES',
280: 'ACTUAL_EFFORT'
281: ),
282: p_tag_uom => jtf_task_utl.get_translated_lookup (
278: p_tag => jtf_task_utl.get_translated_lookup (
279: 'JTF_TASK_TRANSLATED_MESSAGES',
280: 'ACTUAL_EFFORT'
281: ),
282: p_tag_uom => jtf_task_utl.get_translated_lookup (
283: 'JTF_TASK_TRANSLATED_MESSAGES',
284: 'ACTUAL_EFFORT_UOM'
285: ),
286: x_return_status => x_return_status,
296:
297: -------
298: ------- Validate Sched. Travel Duration
299: -------
300: jtf_task_utl.validate_effort (
301: p_tag => jtf_task_utl.get_translated_lookup (
302: 'JTF_TASK_TRANSLATED_MESSAGES',
303: 'SCHEDULED_TRAVEL_DURATION'
304: ),
297: -------
298: ------- Validate Sched. Travel Duration
299: -------
300: jtf_task_utl.validate_effort (
301: p_tag => jtf_task_utl.get_translated_lookup (
302: 'JTF_TASK_TRANSLATED_MESSAGES',
303: 'SCHEDULED_TRAVEL_DURATION'
304: ),
305: p_tag_uom => jtf_task_utl.get_translated_lookup (
301: p_tag => jtf_task_utl.get_translated_lookup (
302: 'JTF_TASK_TRANSLATED_MESSAGES',
303: 'SCHEDULED_TRAVEL_DURATION'
304: ),
305: p_tag_uom => jtf_task_utl.get_translated_lookup (
306: 'JTF_TASK_TRANSLATED_MESSAGES',
307: 'SCHEDULED_TRAVEL_DURATION'
308: ),
309: x_return_status => x_return_status,
319:
320: -------
321: ------- Validate Actual Travel Duration
322: -------
323: jtf_task_utl.validate_effort (
324: p_tag => jtf_task_utl.get_translated_lookup (
325: 'JTF_TASK_TRANSLATED_MESSAGES',
326: 'ACTUAL_TRAVEL_DURATION'
327: ),
320: -------
321: ------- Validate Actual Travel Duration
322: -------
323: jtf_task_utl.validate_effort (
324: p_tag => jtf_task_utl.get_translated_lookup (
325: 'JTF_TASK_TRANSLATED_MESSAGES',
326: 'ACTUAL_TRAVEL_DURATION'
327: ),
328: p_tag_uom => jtf_task_utl.get_translated_lookup (
324: p_tag => jtf_task_utl.get_translated_lookup (
325: 'JTF_TASK_TRANSLATED_MESSAGES',
326: 'ACTUAL_TRAVEL_DURATION'
327: ),
328: p_tag_uom => jtf_task_utl.get_translated_lookup (
329: 'JTF_TASK_TRANSLATED_MESSAGES',
330: 'ACTUAL_TRAVEL_DURATION'
331: ),
332: x_return_status => x_return_status,
342:
343: -------
344: ------- Validate Actual Travel Distance
345: -------
346: jtf_task_utl.validate_distance (
347: p_distance_units => p_actual_travel_distance,
348: p_distance_tag => jtf_task_utl.get_translated_lookup (
349: 'JTF_TASK_TRANSLATED_MESSAGES',
350: 'ACTUAL_TRAVEL_DISTANCE'
344: ------- Validate Actual Travel Distance
345: -------
346: jtf_task_utl.validate_distance (
347: p_distance_units => p_actual_travel_distance,
348: p_distance_tag => jtf_task_utl.get_translated_lookup (
349: 'JTF_TASK_TRANSLATED_MESSAGES',
350: 'ACTUAL_TRAVEL_DISTANCE'
351: ),
352: x_return_status => x_return_status
360:
361: -------
362: ------- Validate Schedule Travel Distance
363: -------
364: jtf_task_utl.validate_distance (
365: p_distance_units => p_sched_travel_distance,
366: p_distance_tag => jtf_task_utl.get_translated_lookup (
367: 'JTF_TASK_TRANSLATED_MESSAGES',
368: 'SCHEDULED_TRAVEL_DISTANCE'
362: ------- Validate Schedule Travel Distance
363: -------
364: jtf_task_utl.validate_distance (
365: p_distance_units => p_sched_travel_distance,
366: p_distance_tag => jtf_task_utl.get_translated_lookup (
367: 'JTF_TASK_TRANSLATED_MESSAGES',
368: 'SCHEDULED_TRAVEL_DISTANCE'
369: ),
370: x_return_status => x_return_status
378:
379: -------
380: ------- Validate Schedule Flag
381: -------
382: jtf_task_utl.validate_flag (
383: x_return_status => x_return_status,
384: p_flag_name => jtf_task_utl.get_translated_lookup (
385: 'JTF_TASK_TRANSLATED_MESSAGES',
386: 'SCHEDULED_FLAG'
380: ------- Validate Schedule Flag
381: -------
382: jtf_task_utl.validate_flag (
383: x_return_status => x_return_status,
384: p_flag_name => jtf_task_utl.get_translated_lookup (
385: 'JTF_TASK_TRANSLATED_MESSAGES',
386: 'SCHEDULED_FLAG'
387: ),
388: p_flag_value => l_schedule_flag
423: */
424: -------
425: ------- Validate the flags.
426: -------
427: jtf_task_utl.validate_flag (
428: x_return_status => x_return_status,
429: p_flag_name => jtf_task_utl.get_translated_lookup (
430: 'JTF_TASK_TRANSLATED_MESSAGES',
431: 'PALM_FLAG'
425: ------- Validate the flags.
426: -------
427: jtf_task_utl.validate_flag (
428: x_return_status => x_return_status,
429: p_flag_name => jtf_task_utl.get_translated_lookup (
430: 'JTF_TASK_TRANSLATED_MESSAGES',
431: 'PALM_FLAG'
432: ),
433: p_flag_value => l_palm_flag
438: x_return_status := fnd_api.g_ret_sts_unexp_error;
439: RAISE fnd_api.g_exc_unexpected_error;
440: END IF;
441:
442: jtf_task_utl.validate_flag (
443: x_return_status => x_return_status,
444: p_flag_name => jtf_task_utl.get_translated_lookup (
445: 'JTF_TASK_TRANSLATED_MESSAGES',
446: 'WINCE_FLAG'
440: END IF;
441:
442: jtf_task_utl.validate_flag (
443: x_return_status => x_return_status,
444: p_flag_name => jtf_task_utl.get_translated_lookup (
445: 'JTF_TASK_TRANSLATED_MESSAGES',
446: 'WINCE_FLAG'
447: ),
448: p_flag_value => l_wince_flag
453: x_return_status := fnd_api.g_ret_sts_unexp_error;
454: RAISE fnd_api.g_exc_unexpected_error;
455: END IF;
456:
457: jtf_task_utl.validate_flag (
458: x_return_status => x_return_status,
459: p_flag_name => jtf_task_utl.get_translated_lookup (
460: 'JTF_TASK_TRANSLATED_MESSAGES',
461: 'LAPTOP_FLAG'
455: END IF;
456:
457: jtf_task_utl.validate_flag (
458: x_return_status => x_return_status,
459: p_flag_name => jtf_task_utl.get_translated_lookup (
460: 'JTF_TASK_TRANSLATED_MESSAGES',
461: 'LAPTOP_FLAG'
462: ),
463: p_flag_value => l_laptop_flag
468: x_return_status := fnd_api.g_ret_sts_unexp_error;
469: RAISE fnd_api.g_exc_unexpected_error;
470: END IF;
471:
472: jtf_task_utl.validate_flag (
473: x_return_status => x_return_status,
474: p_flag_name => jtf_task_utl.get_translated_lookup (
475: 'JTF_TASK_TRANSLATED_MESSAGES',
476: 'DEVICE1_FLAG'
470: END IF;
471:
472: jtf_task_utl.validate_flag (
473: x_return_status => x_return_status,
474: p_flag_name => jtf_task_utl.get_translated_lookup (
475: 'JTF_TASK_TRANSLATED_MESSAGES',
476: 'DEVICE1_FLAG'
477: ),
478: p_flag_value => l_device1_flag
483: x_return_status := fnd_api.g_ret_sts_unexp_error;
484: RAISE fnd_api.g_exc_unexpected_error;
485: END IF;
486:
487: jtf_task_utl.validate_flag (
488: x_return_status => x_return_status,
489: p_flag_name => jtf_task_utl.get_translated_lookup (
490: 'JTF_TASK_TRANSLATED_MESSAGES',
491: 'DEVICE2_FLAG'
485: END IF;
486:
487: jtf_task_utl.validate_flag (
488: x_return_status => x_return_status,
489: p_flag_name => jtf_task_utl.get_translated_lookup (
490: 'JTF_TASK_TRANSLATED_MESSAGES',
491: 'DEVICE2_FLAG'
492: ),
493: p_flag_value => l_device2_flag
498: x_return_status := fnd_api.g_ret_sts_unexp_error;
499: RAISE fnd_api.g_exc_unexpected_error;
500: END IF;
501:
502: jtf_task_utl.validate_flag (
503: x_return_status => x_return_status,
504: p_flag_name => jtf_task_utl.get_translated_lookup (
505: 'JTF_TASK_TRANSLATED_MESSAGES',
506: 'DEVICE3_FLAG'
500: END IF;
501:
502: jtf_task_utl.validate_flag (
503: x_return_status => x_return_status,
504: p_flag_name => jtf_task_utl.get_translated_lookup (
505: 'JTF_TASK_TRANSLATED_MESSAGES',
506: 'DEVICE3_FLAG'
507: ),
508: p_flag_value => l_device3_flag
514: RAISE fnd_api.g_exc_unexpected_error;
515: END IF;
516:
517: -- Validate the code in ON_SHOW_CALENDAR
518: jtf_task_utl.validate_flag (
519: x_return_status => x_return_status,
520: p_flag_name => jtf_task_utl.get_translated_lookup (
521: 'JTF_TASK_TRANSLATED_MESSAGES',
522: 'PRIMARY_FLAG'
516:
517: -- Validate the code in ON_SHOW_CALENDAR
518: jtf_task_utl.validate_flag (
519: x_return_status => x_return_status,
520: p_flag_name => jtf_task_utl.get_translated_lookup (
521: 'JTF_TASK_TRANSLATED_MESSAGES',
522: 'PRIMARY_FLAG'
523: ),
524: p_flag_value => l_show_on_calendar
530: RAISE fnd_api.g_exc_unexpected_error;
531: END IF;
532:
533: -- Validate the value in category_id
534: IF jtf_task_utl.g_validate_category = TRUE
535: THEN
536: jtf_task_utl.validate_category (
537: p_category_id => l_category_id,
538: x_return_status => x_return_status
532:
533: -- Validate the value in category_id
534: IF jtf_task_utl.g_validate_category = TRUE
535: THEN
536: jtf_task_utl.validate_category (
537: p_category_id => l_category_id,
538: x_return_status => x_return_status
539: );
540:
549: ----- Validate the Shift construct id.
550: -----
551: IF l_shift_construct_id IS NOT NULL
552: THEN
553: IF NOT jtf_task_utl.validate_shift_construct (l_shift_construct_id)
554: THEN
555: fnd_message.set_name ('JTF', 'JTF_TASK_CONSTRUCT_ID');
556: --fnd_message.set_token ('SHIFT_CONSTRUCT_ID', p_shift_construct_id);
557: fnd_message.set_token ('P_SHIFT_CONSTRUCT_ID', jtf_task_utl.get_translated_lookup(
553: IF NOT jtf_task_utl.validate_shift_construct (l_shift_construct_id)
554: THEN
555: fnd_message.set_name ('JTF', 'JTF_TASK_CONSTRUCT_ID');
556: --fnd_message.set_token ('SHIFT_CONSTRUCT_ID', p_shift_construct_id);
557: fnd_message.set_token ('P_SHIFT_CONSTRUCT_ID', jtf_task_utl.get_translated_lookup(
558: 'JTF_TASK_TRANSLATED_MESSAGES',
559: 'SHIFT_CONSTRUCT_ID')
560: );
561: fnd_msg_pub.add;
566: ----
567: ---- Validate dates
568: ----
569: ----
570: jtf_task_utl.validate_dates (
571: p_date_tag => jtf_task_utl.get_translated_lookup (
572: 'JTF_TASK_TRANSLATED_MESSAGES',
573: 'ACTUAL'
574: ),
567: ---- Validate dates
568: ----
569: ----
570: jtf_task_utl.validate_dates (
571: p_date_tag => jtf_task_utl.get_translated_lookup (
572: 'JTF_TASK_TRANSLATED_MESSAGES',
573: 'ACTUAL'
574: ),
575: p_start_date => l_actual_start_date,
755: p_attribute13 IN VARCHAR2 DEFAULT NULL,
756: p_attribute14 IN VARCHAR2 DEFAULT NULL,
757: p_attribute15 IN VARCHAR2 DEFAULT NULL,
758: p_attribute_category IN VARCHAR2 DEFAULT NULL,
759: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
760: p_category_id IN NUMBER DEFAULT NULL,
761: p_enable_workflow IN VARCHAR2,
762: p_abort_workflow IN VARCHAR2,
763: p_object_capacity_id IN NUMBER
882: p_attribute13 IN VARCHAR2 DEFAULT NULL,
883: p_attribute14 IN VARCHAR2 DEFAULT NULL,
884: p_attribute15 IN VARCHAR2 DEFAULT NULL,
885: p_attribute_category IN VARCHAR2 DEFAULT NULL,
886: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
887: p_category_id IN NUMBER DEFAULT NULL,
888: p_enable_workflow IN VARCHAR2,
889: p_abort_workflow IN VARCHAR2
890: )
1004: p_attribute13 IN VARCHAR2 DEFAULT NULL,
1005: p_attribute14 IN VARCHAR2 DEFAULT NULL,
1006: p_attribute15 IN VARCHAR2 DEFAULT NULL,
1007: p_attribute_category IN VARCHAR2 DEFAULT NULL,
1008: p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
1009: p_category_id IN NUMBER DEFAULT NULL
1010: )
1011: IS
1012: BEGIN
1207: x_return_status OUT NOCOPY VARCHAR2,
1208: x_msg_count OUT NOCOPY NUMBER,
1209: x_msg_data OUT NOCOPY VARCHAR2,
1210: p_attribute1 IN VARCHAR2
1211: DEFAULT jtf_task_utl.g_miss_char,
1212: p_attribute2 IN VARCHAR2
1213: DEFAULT jtf_task_utl.g_miss_char,
1214: p_attribute3 IN VARCHAR2
1215: DEFAULT jtf_task_utl.g_miss_char,
1209: x_msg_data OUT NOCOPY VARCHAR2,
1210: p_attribute1 IN VARCHAR2
1211: DEFAULT jtf_task_utl.g_miss_char,
1212: p_attribute2 IN VARCHAR2
1213: DEFAULT jtf_task_utl.g_miss_char,
1214: p_attribute3 IN VARCHAR2
1215: DEFAULT jtf_task_utl.g_miss_char,
1216: p_attribute4 IN VARCHAR2
1217: DEFAULT jtf_task_utl.g_miss_char,
1211: DEFAULT jtf_task_utl.g_miss_char,
1212: p_attribute2 IN VARCHAR2
1213: DEFAULT jtf_task_utl.g_miss_char,
1214: p_attribute3 IN VARCHAR2
1215: DEFAULT jtf_task_utl.g_miss_char,
1216: p_attribute4 IN VARCHAR2
1217: DEFAULT jtf_task_utl.g_miss_char,
1218: p_attribute5 IN VARCHAR2
1219: DEFAULT jtf_task_utl.g_miss_char,
1213: DEFAULT jtf_task_utl.g_miss_char,
1214: p_attribute3 IN VARCHAR2
1215: DEFAULT jtf_task_utl.g_miss_char,
1216: p_attribute4 IN VARCHAR2
1217: DEFAULT jtf_task_utl.g_miss_char,
1218: p_attribute5 IN VARCHAR2
1219: DEFAULT jtf_task_utl.g_miss_char,
1220: p_attribute6 IN VARCHAR2
1221: DEFAULT jtf_task_utl.g_miss_char,
1215: DEFAULT jtf_task_utl.g_miss_char,
1216: p_attribute4 IN VARCHAR2
1217: DEFAULT jtf_task_utl.g_miss_char,
1218: p_attribute5 IN VARCHAR2
1219: DEFAULT jtf_task_utl.g_miss_char,
1220: p_attribute6 IN VARCHAR2
1221: DEFAULT jtf_task_utl.g_miss_char,
1222: p_attribute7 IN VARCHAR2
1223: DEFAULT jtf_task_utl.g_miss_char,
1217: DEFAULT jtf_task_utl.g_miss_char,
1218: p_attribute5 IN VARCHAR2
1219: DEFAULT jtf_task_utl.g_miss_char,
1220: p_attribute6 IN VARCHAR2
1221: DEFAULT jtf_task_utl.g_miss_char,
1222: p_attribute7 IN VARCHAR2
1223: DEFAULT jtf_task_utl.g_miss_char,
1224: p_attribute8 IN VARCHAR2
1225: DEFAULT jtf_task_utl.g_miss_char,
1219: DEFAULT jtf_task_utl.g_miss_char,
1220: p_attribute6 IN VARCHAR2
1221: DEFAULT jtf_task_utl.g_miss_char,
1222: p_attribute7 IN VARCHAR2
1223: DEFAULT jtf_task_utl.g_miss_char,
1224: p_attribute8 IN VARCHAR2
1225: DEFAULT jtf_task_utl.g_miss_char,
1226: p_attribute9 IN VARCHAR2
1227: DEFAULT jtf_task_utl.g_miss_char,
1221: DEFAULT jtf_task_utl.g_miss_char,
1222: p_attribute7 IN VARCHAR2
1223: DEFAULT jtf_task_utl.g_miss_char,
1224: p_attribute8 IN VARCHAR2
1225: DEFAULT jtf_task_utl.g_miss_char,
1226: p_attribute9 IN VARCHAR2
1227: DEFAULT jtf_task_utl.g_miss_char,
1228: p_attribute10 IN VARCHAR2
1229: DEFAULT jtf_task_utl.g_miss_char,
1223: DEFAULT jtf_task_utl.g_miss_char,
1224: p_attribute8 IN VARCHAR2
1225: DEFAULT jtf_task_utl.g_miss_char,
1226: p_attribute9 IN VARCHAR2
1227: DEFAULT jtf_task_utl.g_miss_char,
1228: p_attribute10 IN VARCHAR2
1229: DEFAULT jtf_task_utl.g_miss_char,
1230: p_attribute11 IN VARCHAR2
1231: DEFAULT jtf_task_utl.g_miss_char,
1225: DEFAULT jtf_task_utl.g_miss_char,
1226: p_attribute9 IN VARCHAR2
1227: DEFAULT jtf_task_utl.g_miss_char,
1228: p_attribute10 IN VARCHAR2
1229: DEFAULT jtf_task_utl.g_miss_char,
1230: p_attribute11 IN VARCHAR2
1231: DEFAULT jtf_task_utl.g_miss_char,
1232: p_attribute12 IN VARCHAR2
1233: DEFAULT jtf_task_utl.g_miss_char,
1227: DEFAULT jtf_task_utl.g_miss_char,
1228: p_attribute10 IN VARCHAR2
1229: DEFAULT jtf_task_utl.g_miss_char,
1230: p_attribute11 IN VARCHAR2
1231: DEFAULT jtf_task_utl.g_miss_char,
1232: p_attribute12 IN VARCHAR2
1233: DEFAULT jtf_task_utl.g_miss_char,
1234: p_attribute13 IN VARCHAR2
1235: DEFAULT jtf_task_utl.g_miss_char,
1229: DEFAULT jtf_task_utl.g_miss_char,
1230: p_attribute11 IN VARCHAR2
1231: DEFAULT jtf_task_utl.g_miss_char,
1232: p_attribute12 IN VARCHAR2
1233: DEFAULT jtf_task_utl.g_miss_char,
1234: p_attribute13 IN VARCHAR2
1235: DEFAULT jtf_task_utl.g_miss_char,
1236: p_attribute14 IN VARCHAR2
1237: DEFAULT jtf_task_utl.g_miss_char,
1231: DEFAULT jtf_task_utl.g_miss_char,
1232: p_attribute12 IN VARCHAR2
1233: DEFAULT jtf_task_utl.g_miss_char,
1234: p_attribute13 IN VARCHAR2
1235: DEFAULT jtf_task_utl.g_miss_char,
1236: p_attribute14 IN VARCHAR2
1237: DEFAULT jtf_task_utl.g_miss_char,
1238: p_attribute15 IN VARCHAR2
1239: DEFAULT jtf_task_utl.g_miss_char,
1233: DEFAULT jtf_task_utl.g_miss_char,
1234: p_attribute13 IN VARCHAR2
1235: DEFAULT jtf_task_utl.g_miss_char,
1236: p_attribute14 IN VARCHAR2
1237: DEFAULT jtf_task_utl.g_miss_char,
1238: p_attribute15 IN VARCHAR2
1239: DEFAULT jtf_task_utl.g_miss_char,
1240: p_attribute_category IN VARCHAR2
1241: DEFAULT jtf_task_utl.g_miss_char,
1235: DEFAULT jtf_task_utl.g_miss_char,
1236: p_attribute14 IN VARCHAR2
1237: DEFAULT jtf_task_utl.g_miss_char,
1238: p_attribute15 IN VARCHAR2
1239: DEFAULT jtf_task_utl.g_miss_char,
1240: p_attribute_category IN VARCHAR2
1241: DEFAULT jtf_task_utl.g_miss_char,
1242: p_show_on_calendar IN VARCHAR2
1243: DEFAULT jtf_task_utl.g_miss_char,
1237: DEFAULT jtf_task_utl.g_miss_char,
1238: p_attribute15 IN VARCHAR2
1239: DEFAULT jtf_task_utl.g_miss_char,
1240: p_attribute_category IN VARCHAR2
1241: DEFAULT jtf_task_utl.g_miss_char,
1242: p_show_on_calendar IN VARCHAR2
1243: DEFAULT jtf_task_utl.g_miss_char,
1244: p_category_id IN NUMBER
1245: DEFAULT jtf_task_utl.g_miss_number,
1239: DEFAULT jtf_task_utl.g_miss_char,
1240: p_attribute_category IN VARCHAR2
1241: DEFAULT jtf_task_utl.g_miss_char,
1242: p_show_on_calendar IN VARCHAR2
1243: DEFAULT jtf_task_utl.g_miss_char,
1244: p_category_id IN NUMBER
1245: DEFAULT jtf_task_utl.g_miss_number,
1246: p_enable_workflow IN VARCHAR2,
1247: p_abort_workflow IN VARCHAR2,
1241: DEFAULT jtf_task_utl.g_miss_char,
1242: p_show_on_calendar IN VARCHAR2
1243: DEFAULT jtf_task_utl.g_miss_char,
1244: p_category_id IN NUMBER
1245: DEFAULT jtf_task_utl.g_miss_number,
1246: p_enable_workflow IN VARCHAR2,
1247: p_abort_workflow IN VARCHAR2,
1248: p_object_capacity_id IN NUMBER
1249: )
1612: -----
1613: ----- Validate Assignment Status Id
1614: -----
1615: l_assignment_status_id := task_ass_rec.assignment_status_id;
1616: jtf_task_utl.validate_task_status (
1617: p_task_status_id => l_assignment_status_id,
1618: p_task_status_name => NULL,
1619: p_validation_type => 'ASSIGNMENT',
1620: x_return_status => x_return_status,
1632: ----- Validate the assigned resource.
1633: -----
1634: l_resource_type_code := task_ass_rec.resource_type_code;
1635: l_resource_id := task_ass_rec.resource_id;
1636: jtf_task_utl.validate_task_owner (
1637: p_owner_type_code => l_resource_type_code,
1638: p_owner_id => l_resource_id,
1639: x_return_status => x_return_status,
1640: x_owner_id => l_resource_id,
1669: ------- Validate actual effort
1670: -------
1671: l_act_eff := task_ass_rec.actual_effort;
1672: l_act_eff_uom := task_ass_rec.actual_effort_uom;
1673: jtf_task_utl.validate_effort (
1674: p_tag => jtf_task_utl.get_translated_lookup (
1675: 'JTF_TASK_TRANSLATED_MESSAGES',
1676: 'ACTUAL_EFFORT'
1677: ),
1670: -------
1671: l_act_eff := task_ass_rec.actual_effort;
1672: l_act_eff_uom := task_ass_rec.actual_effort_uom;
1673: jtf_task_utl.validate_effort (
1674: p_tag => jtf_task_utl.get_translated_lookup (
1675: 'JTF_TASK_TRANSLATED_MESSAGES',
1676: 'ACTUAL_EFFORT'
1677: ),
1678: p_tag_uom => jtf_task_utl.get_translated_lookup (
1674: p_tag => jtf_task_utl.get_translated_lookup (
1675: 'JTF_TASK_TRANSLATED_MESSAGES',
1676: 'ACTUAL_EFFORT'
1677: ),
1678: p_tag_uom => jtf_task_utl.get_translated_lookup (
1679: 'JTF_TASK_TRANSLATED_MESSAGES',
1680: 'ACTUAL_EFFORT_UOM'
1681: ),
1682: x_return_status => x_return_status,
1693: l_shift_construct_id := task_ass_rec.shift_construct_id;
1694:
1695: IF l_shift_construct_id IS NOT NULL
1696: THEN
1697: IF NOT jtf_task_utl.validate_shift_construct (l_shift_construct_id)
1698: THEN
1699: fnd_message.set_name ('JTF', 'JTF_TASK_CONSTRUCT_ID');
1700: --fnd_message.set_token ('SHIFT_CONSTRUCT_ID', p_shift_construct_id);
1701: fnd_message.set_token ('P_SHIFT_CONSTRUCT_ID', jtf_task_utl.get_translated_lookup(
1697: IF NOT jtf_task_utl.validate_shift_construct (l_shift_construct_id)
1698: THEN
1699: fnd_message.set_name ('JTF', 'JTF_TASK_CONSTRUCT_ID');
1700: --fnd_message.set_token ('SHIFT_CONSTRUCT_ID', p_shift_construct_id);
1701: fnd_message.set_token ('P_SHIFT_CONSTRUCT_ID', jtf_task_utl.get_translated_lookup(
1702: 'JTF_TASK_TRANSLATED_MESSAGES',
1703: 'SHIFT_CONSTRUCT_ID')
1704: );
1705: fnd_msg_pub.add;
1716: ------- Validate Sched. Travel Duration
1717: -------
1718: l_sched_travel_duration := task_ass_rec.sched_travel_duration;
1719: l_sched_travel_dur_uom := task_ass_rec.sched_travel_dur_uom;
1720: jtf_task_utl.validate_effort (
1721: p_tag => jtf_task_utl.get_translated_lookup (
1722: 'JTF_TASK_TRANSLATED_MESSAGES',
1723: 'SCHEDULED_TRAVEL_DURATION'
1724: ),
1717: -------
1718: l_sched_travel_duration := task_ass_rec.sched_travel_duration;
1719: l_sched_travel_dur_uom := task_ass_rec.sched_travel_dur_uom;
1720: jtf_task_utl.validate_effort (
1721: p_tag => jtf_task_utl.get_translated_lookup (
1722: 'JTF_TASK_TRANSLATED_MESSAGES',
1723: 'SCHEDULED_TRAVEL_DURATION'
1724: ),
1725: p_tag_uom => jtf_task_utl.get_translated_lookup (
1721: p_tag => jtf_task_utl.get_translated_lookup (
1722: 'JTF_TASK_TRANSLATED_MESSAGES',
1723: 'SCHEDULED_TRAVEL_DURATION'
1724: ),
1725: p_tag_uom => jtf_task_utl.get_translated_lookup (
1726: 'JTF_TASK_TRANSLATED_MESSAGES',
1727: 'SCHEDULED_TRAVEL_DURATION_UOM'
1728: ),
1729: x_return_status => x_return_status,
1741: ------- Validate Actual Travel Duration
1742: -------
1743: l_actual_travel_duration := task_ass_rec.actual_travel_duration;
1744: l_actual_travel_dur_uom := task_ass_rec.actual_travel_dur_uom;
1745: jtf_task_utl.validate_effort (
1746: p_tag => jtf_task_utl.get_translated_lookup (
1747: 'JTF_TASK_TRANSLATED_MESSAGES',
1748: 'ACTUAL_TRAVEL_DURATION'
1749: ),
1742: -------
1743: l_actual_travel_duration := task_ass_rec.actual_travel_duration;
1744: l_actual_travel_dur_uom := task_ass_rec.actual_travel_dur_uom;
1745: jtf_task_utl.validate_effort (
1746: p_tag => jtf_task_utl.get_translated_lookup (
1747: 'JTF_TASK_TRANSLATED_MESSAGES',
1748: 'ACTUAL_TRAVEL_DURATION'
1749: ),
1750: p_tag_uom => jtf_task_utl.get_translated_lookup (
1746: p_tag => jtf_task_utl.get_translated_lookup (
1747: 'JTF_TASK_TRANSLATED_MESSAGES',
1748: 'ACTUAL_TRAVEL_DURATION'
1749: ),
1750: p_tag_uom => jtf_task_utl.get_translated_lookup (
1751: 'JTF_TASK_TRANSLATED_MESSAGES',
1752: 'SCHEDULED_TRAVEL_DURATION_UOM'
1753: ),
1754: x_return_status => x_return_status,
1765: -------
1766: ------- Validate Actual Travel Distance
1767: -------
1768: l_actual_travel_distance := task_ass_rec.actual_travel_distance;
1769: jtf_task_utl.validate_distance (
1770: p_distance_units => p_actual_travel_distance,
1771: p_distance_tag => jtf_task_utl.get_translated_lookup (
1772: 'JTF_TASK_TRANSLATED_MESSAGES',
1773: 'ACTUAL_TRAVEL_DISTANCE'
1767: -------
1768: l_actual_travel_distance := task_ass_rec.actual_travel_distance;
1769: jtf_task_utl.validate_distance (
1770: p_distance_units => p_actual_travel_distance,
1771: p_distance_tag => jtf_task_utl.get_translated_lookup (
1772: 'JTF_TASK_TRANSLATED_MESSAGES',
1773: 'ACTUAL_TRAVEL_DISTANCE'
1774: ),
1775: x_return_status => x_return_status
1784: -------
1785: ------- Validate Schedule Travel Distance
1786: -------
1787: l_sched_travel_distance := task_ass_rec.sched_travel_distance;
1788: jtf_task_utl.validate_distance (
1789: p_distance_units => p_sched_travel_distance,
1790: p_distance_tag => 'Schedule Travel Distance',
1791: x_return_status => x_return_status
1792: );
1800: ------
1801: ------ Palm flag.
1802: ------
1803: l_palm_flag := task_ass_rec.palm_flag;
1804: jtf_task_utl.validate_flag (
1805: x_return_status => x_return_status,
1806: p_flag_name => jtf_task_utl.get_translated_lookup (
1807: 'JTF_TASK_TRANSLATED_MESSAGES',
1808: 'PALM_FLAG'
1802: ------
1803: l_palm_flag := task_ass_rec.palm_flag;
1804: jtf_task_utl.validate_flag (
1805: x_return_status => x_return_status,
1806: p_flag_name => jtf_task_utl.get_translated_lookup (
1807: 'JTF_TASK_TRANSLATED_MESSAGES',
1808: 'PALM_FLAG'
1809: ),
1810: p_flag_value => l_palm_flag
1819: ------
1820: ------ Wince flag.
1821: ------
1822: l_wince_flag := task_ass_rec.wince_flag;
1823: jtf_task_utl.validate_flag (
1824: x_return_status => x_return_status,
1825: p_flag_name => jtf_task_utl.get_translated_lookup (
1826: 'JTF_TASK_TRANSLATED_MESSAGES',
1827: 'WINCE_FLAG'
1821: ------
1822: l_wince_flag := task_ass_rec.wince_flag;
1823: jtf_task_utl.validate_flag (
1824: x_return_status => x_return_status,
1825: p_flag_name => jtf_task_utl.get_translated_lookup (
1826: 'JTF_TASK_TRANSLATED_MESSAGES',
1827: 'WINCE_FLAG'
1828: ),
1829: p_flag_value => l_wince_flag
1838: ------
1839: ------ Laptop flag.
1840: ------
1841: l_laptop_flag := task_ass_rec.laptop_flag;
1842: jtf_task_utl.validate_flag (
1843: x_return_status => x_return_status,
1844: p_flag_name => jtf_task_utl.get_translated_lookup (
1845: 'JTF_TASK_TRANSLATED_MESSAGES',
1846: 'LAPTOP_FLAG'
1840: ------
1841: l_laptop_flag := task_ass_rec.laptop_flag;
1842: jtf_task_utl.validate_flag (
1843: x_return_status => x_return_status,
1844: p_flag_name => jtf_task_utl.get_translated_lookup (
1845: 'JTF_TASK_TRANSLATED_MESSAGES',
1846: 'LAPTOP_FLAG'
1847: ),
1848: p_flag_value => l_laptop_flag
1857: ------
1858: ------ Device1 flag.
1859: ------
1860: l_device1_flag := task_ass_rec.device1_flag;
1861: jtf_task_utl.validate_flag (
1862: x_return_status => x_return_status,
1863: p_flag_name => jtf_task_utl.get_translated_lookup (
1864: 'JTF_TASK_TRANSLATED_MESSAGES',
1865: 'DEVICE1_FLAG'
1859: ------
1860: l_device1_flag := task_ass_rec.device1_flag;
1861: jtf_task_utl.validate_flag (
1862: x_return_status => x_return_status,
1863: p_flag_name => jtf_task_utl.get_translated_lookup (
1864: 'JTF_TASK_TRANSLATED_MESSAGES',
1865: 'DEVICE1_FLAG'
1866: ),
1867: p_flag_value => l_device1_flag
1876: ------
1877: ------ Device2 flag.
1878: ------
1879: l_device2_flag := task_ass_rec.device1_flag;
1880: jtf_task_utl.validate_flag (
1881: x_return_status => x_return_status,
1882: p_flag_name => jtf_task_utl.get_translated_lookup (
1883: 'JTF_TASK_TRANSLATED_MESSAGES',
1884: 'DEVICE2_FLAG'
1878: ------
1879: l_device2_flag := task_ass_rec.device1_flag;
1880: jtf_task_utl.validate_flag (
1881: x_return_status => x_return_status,
1882: p_flag_name => jtf_task_utl.get_translated_lookup (
1883: 'JTF_TASK_TRANSLATED_MESSAGES',
1884: 'DEVICE2_FLAG'
1885: ),
1886: p_flag_value => l_device2_flag
1895: ------
1896: ------ Device3 flag.
1897: ------
1898: l_device3_flag := task_ass_rec.device3_flag;
1899: jtf_task_utl.validate_flag (
1900: x_return_status => x_return_status,
1901: p_flag_name => jtf_task_utl.get_translated_lookup (
1902: 'JTF_TASK_TRANSLATED_MESSAGES',
1903: 'DEVICE3_FLAG'
1897: ------
1898: l_device3_flag := task_ass_rec.device3_flag;
1899: jtf_task_utl.validate_flag (
1900: x_return_status => x_return_status,
1901: p_flag_name => jtf_task_utl.get_translated_lookup (
1902: 'JTF_TASK_TRANSLATED_MESSAGES',
1903: 'DEVICE3_FLAG'
1904: ),
1905: p_flag_value => l_device3_flag
1915: ------
1916: ------ Schedule flag.
1917: ------
1918: l_schedule_flag := task_ass_rec.schedule_flag;
1919: jtf_task_utl.validate_flag (
1920: x_return_status => x_return_status,
1921: p_flag_name => 'Schedule Flag',
1922: p_flag_value => l_schedule_flag
1923: );
1933: ----
1934: ----
1935: l_actual_start_date := task_ass_rec.actual_start_date;
1936: l_actual_end_date := task_ass_rec.actual_end_date;
1937: jtf_task_utl.validate_dates (
1938: p_date_tag => jtf_task_utl.get_translated_lookup (
1939: 'JTF_TASK_TRANSLATED_MESSAGES',
1940: 'ACTUAL'
1941: ),
1934: ----
1935: l_actual_start_date := task_ass_rec.actual_start_date;
1936: l_actual_end_date := task_ass_rec.actual_end_date;
1937: jtf_task_utl.validate_dates (
1938: p_date_tag => jtf_task_utl.get_translated_lookup (
1939: 'JTF_TASK_TRANSLATED_MESSAGES',
1940: 'ACTUAL'
1941: ),
1942: p_start_date => l_actual_start_date,
1951: END IF;
1952:
1953: -- Validate the value in SHOW_ON_CALENDAR
1954: l_show_on_calendar := task_ass_rec.show_on_calendar;
1955: jtf_task_utl.validate_flag (
1956: x_return_status => x_return_status,
1957: p_flag_name => jtf_task_utl.get_translated_lookup (
1958: 'JTF_TASK_TRANSLATED_MESSAGES',
1959: 'PRIMARY_FLAG'
1953: -- Validate the value in SHOW_ON_CALENDAR
1954: l_show_on_calendar := task_ass_rec.show_on_calendar;
1955: jtf_task_utl.validate_flag (
1956: x_return_status => x_return_status,
1957: p_flag_name => jtf_task_utl.get_translated_lookup (
1958: 'JTF_TASK_TRANSLATED_MESSAGES',
1959: 'PRIMARY_FLAG'
1960: ),
1961: p_flag_value => l_show_on_calendar
1968: END IF;
1969:
1970: -- Validate the value in category_id
1971: l_category_id := task_ass_rec.category_id;
1972: IF jtf_task_utl.g_validate_category = TRUE
1973: THEN
1974: jtf_task_utl.validate_category (
1975: p_category_id => l_category_id,
1976: x_return_status => x_return_status
1970: -- Validate the value in category_id
1971: l_category_id := task_ass_rec.category_id;
1972: IF jtf_task_utl.g_validate_category = TRUE
1973: THEN
1974: jtf_task_utl.validate_category (
1975: p_category_id => l_category_id,
1976: x_return_status => x_return_status
1977: );
1978:
1983: END IF;
1984: END IF;
1985:
1986: -- Validate the code in status id
1987: jtf_task_utl.validate_status (
1988: p_status_id => l_assignment_status_id,
1989: p_type => l_type,
1990: x_return_status => x_return_status
1991: );
2216: x_return_status OUT NOCOPY VARCHAR2,
2217: x_msg_count OUT NOCOPY NUMBER,
2218: x_msg_data OUT NOCOPY VARCHAR2,
2219: p_attribute1 IN VARCHAR2
2220: DEFAULT jtf_task_utl.g_miss_char,
2221: p_attribute2 IN VARCHAR2
2222: DEFAULT jtf_task_utl.g_miss_char,
2223: p_attribute3 IN VARCHAR2
2224: DEFAULT jtf_task_utl.g_miss_char,
2218: x_msg_data OUT NOCOPY VARCHAR2,
2219: p_attribute1 IN VARCHAR2
2220: DEFAULT jtf_task_utl.g_miss_char,
2221: p_attribute2 IN VARCHAR2
2222: DEFAULT jtf_task_utl.g_miss_char,
2223: p_attribute3 IN VARCHAR2
2224: DEFAULT jtf_task_utl.g_miss_char,
2225: p_attribute4 IN VARCHAR2
2226: DEFAULT jtf_task_utl.g_miss_char,
2220: DEFAULT jtf_task_utl.g_miss_char,
2221: p_attribute2 IN VARCHAR2
2222: DEFAULT jtf_task_utl.g_miss_char,
2223: p_attribute3 IN VARCHAR2
2224: DEFAULT jtf_task_utl.g_miss_char,
2225: p_attribute4 IN VARCHAR2
2226: DEFAULT jtf_task_utl.g_miss_char,
2227: p_attribute5 IN VARCHAR2
2228: DEFAULT jtf_task_utl.g_miss_char,
2222: DEFAULT jtf_task_utl.g_miss_char,
2223: p_attribute3 IN VARCHAR2
2224: DEFAULT jtf_task_utl.g_miss_char,
2225: p_attribute4 IN VARCHAR2
2226: DEFAULT jtf_task_utl.g_miss_char,
2227: p_attribute5 IN VARCHAR2
2228: DEFAULT jtf_task_utl.g_miss_char,
2229: p_attribute6 IN VARCHAR2
2230: DEFAULT jtf_task_utl.g_miss_char,
2224: DEFAULT jtf_task_utl.g_miss_char,
2225: p_attribute4 IN VARCHAR2
2226: DEFAULT jtf_task_utl.g_miss_char,
2227: p_attribute5 IN VARCHAR2
2228: DEFAULT jtf_task_utl.g_miss_char,
2229: p_attribute6 IN VARCHAR2
2230: DEFAULT jtf_task_utl.g_miss_char,
2231: p_attribute7 IN VARCHAR2
2232: DEFAULT jtf_task_utl.g_miss_char,
2226: DEFAULT jtf_task_utl.g_miss_char,
2227: p_attribute5 IN VARCHAR2
2228: DEFAULT jtf_task_utl.g_miss_char,
2229: p_attribute6 IN VARCHAR2
2230: DEFAULT jtf_task_utl.g_miss_char,
2231: p_attribute7 IN VARCHAR2
2232: DEFAULT jtf_task_utl.g_miss_char,
2233: p_attribute8 IN VARCHAR2
2234: DEFAULT jtf_task_utl.g_miss_char,
2228: DEFAULT jtf_task_utl.g_miss_char,
2229: p_attribute6 IN VARCHAR2
2230: DEFAULT jtf_task_utl.g_miss_char,
2231: p_attribute7 IN VARCHAR2
2232: DEFAULT jtf_task_utl.g_miss_char,
2233: p_attribute8 IN VARCHAR2
2234: DEFAULT jtf_task_utl.g_miss_char,
2235: p_attribute9 IN VARCHAR2
2236: DEFAULT jtf_task_utl.g_miss_char,
2230: DEFAULT jtf_task_utl.g_miss_char,
2231: p_attribute7 IN VARCHAR2
2232: DEFAULT jtf_task_utl.g_miss_char,
2233: p_attribute8 IN VARCHAR2
2234: DEFAULT jtf_task_utl.g_miss_char,
2235: p_attribute9 IN VARCHAR2
2236: DEFAULT jtf_task_utl.g_miss_char,
2237: p_attribute10 IN VARCHAR2
2238: DEFAULT jtf_task_utl.g_miss_char,
2232: DEFAULT jtf_task_utl.g_miss_char,
2233: p_attribute8 IN VARCHAR2
2234: DEFAULT jtf_task_utl.g_miss_char,
2235: p_attribute9 IN VARCHAR2
2236: DEFAULT jtf_task_utl.g_miss_char,
2237: p_attribute10 IN VARCHAR2
2238: DEFAULT jtf_task_utl.g_miss_char,
2239: p_attribute11 IN VARCHAR2
2240: DEFAULT jtf_task_utl.g_miss_char,
2234: DEFAULT jtf_task_utl.g_miss_char,
2235: p_attribute9 IN VARCHAR2
2236: DEFAULT jtf_task_utl.g_miss_char,
2237: p_attribute10 IN VARCHAR2
2238: DEFAULT jtf_task_utl.g_miss_char,
2239: p_attribute11 IN VARCHAR2
2240: DEFAULT jtf_task_utl.g_miss_char,
2241: p_attribute12 IN VARCHAR2
2242: DEFAULT jtf_task_utl.g_miss_char,
2236: DEFAULT jtf_task_utl.g_miss_char,
2237: p_attribute10 IN VARCHAR2
2238: DEFAULT jtf_task_utl.g_miss_char,
2239: p_attribute11 IN VARCHAR2
2240: DEFAULT jtf_task_utl.g_miss_char,
2241: p_attribute12 IN VARCHAR2
2242: DEFAULT jtf_task_utl.g_miss_char,
2243: p_attribute13 IN VARCHAR2
2244: DEFAULT jtf_task_utl.g_miss_char,
2238: DEFAULT jtf_task_utl.g_miss_char,
2239: p_attribute11 IN VARCHAR2
2240: DEFAULT jtf_task_utl.g_miss_char,
2241: p_attribute12 IN VARCHAR2
2242: DEFAULT jtf_task_utl.g_miss_char,
2243: p_attribute13 IN VARCHAR2
2244: DEFAULT jtf_task_utl.g_miss_char,
2245: p_attribute14 IN VARCHAR2
2246: DEFAULT jtf_task_utl.g_miss_char,
2240: DEFAULT jtf_task_utl.g_miss_char,
2241: p_attribute12 IN VARCHAR2
2242: DEFAULT jtf_task_utl.g_miss_char,
2243: p_attribute13 IN VARCHAR2
2244: DEFAULT jtf_task_utl.g_miss_char,
2245: p_attribute14 IN VARCHAR2
2246: DEFAULT jtf_task_utl.g_miss_char,
2247: p_attribute15 IN VARCHAR2
2248: DEFAULT jtf_task_utl.g_miss_char,
2242: DEFAULT jtf_task_utl.g_miss_char,
2243: p_attribute13 IN VARCHAR2
2244: DEFAULT jtf_task_utl.g_miss_char,
2245: p_attribute14 IN VARCHAR2
2246: DEFAULT jtf_task_utl.g_miss_char,
2247: p_attribute15 IN VARCHAR2
2248: DEFAULT jtf_task_utl.g_miss_char,
2249: p_attribute_category IN VARCHAR2
2250: DEFAULT jtf_task_utl.g_miss_char,
2244: DEFAULT jtf_task_utl.g_miss_char,
2245: p_attribute14 IN VARCHAR2
2246: DEFAULT jtf_task_utl.g_miss_char,
2247: p_attribute15 IN VARCHAR2
2248: DEFAULT jtf_task_utl.g_miss_char,
2249: p_attribute_category IN VARCHAR2
2250: DEFAULT jtf_task_utl.g_miss_char,
2251: p_show_on_calendar IN VARCHAR2
2252: DEFAULT jtf_task_utl.g_miss_char,
2246: DEFAULT jtf_task_utl.g_miss_char,
2247: p_attribute15 IN VARCHAR2
2248: DEFAULT jtf_task_utl.g_miss_char,
2249: p_attribute_category IN VARCHAR2
2250: DEFAULT jtf_task_utl.g_miss_char,
2251: p_show_on_calendar IN VARCHAR2
2252: DEFAULT jtf_task_utl.g_miss_char,
2253: p_category_id IN NUMBER
2254: DEFAULT jtf_task_utl.g_miss_number,
2248: DEFAULT jtf_task_utl.g_miss_char,
2249: p_attribute_category IN VARCHAR2
2250: DEFAULT jtf_task_utl.g_miss_char,
2251: p_show_on_calendar IN VARCHAR2
2252: DEFAULT jtf_task_utl.g_miss_char,
2253: p_category_id IN NUMBER
2254: DEFAULT jtf_task_utl.g_miss_number,
2255: p_enable_workflow IN VARCHAR2,
2256: p_abort_workflow IN VARCHAR2
2250: DEFAULT jtf_task_utl.g_miss_char,
2251: p_show_on_calendar IN VARCHAR2
2252: DEFAULT jtf_task_utl.g_miss_char,
2253: p_category_id IN NUMBER
2254: DEFAULT jtf_task_utl.g_miss_number,
2255: p_enable_workflow IN VARCHAR2,
2256: p_abort_workflow IN VARCHAR2
2257: )
2258: IS
2382: x_return_status OUT NOCOPY VARCHAR2,
2383: x_msg_count OUT NOCOPY NUMBER,
2384: x_msg_data OUT NOCOPY VARCHAR2,
2385: p_attribute1 IN VARCHAR2
2386: DEFAULT jtf_task_utl.g_miss_char,
2387: p_attribute2 IN VARCHAR2
2388: DEFAULT jtf_task_utl.g_miss_char,
2389: p_attribute3 IN VARCHAR2
2390: DEFAULT jtf_task_utl.g_miss_char,
2384: x_msg_data OUT NOCOPY VARCHAR2,
2385: p_attribute1 IN VARCHAR2
2386: DEFAULT jtf_task_utl.g_miss_char,
2387: p_attribute2 IN VARCHAR2
2388: DEFAULT jtf_task_utl.g_miss_char,
2389: p_attribute3 IN VARCHAR2
2390: DEFAULT jtf_task_utl.g_miss_char,
2391: p_attribute4 IN VARCHAR2
2392: DEFAULT jtf_task_utl.g_miss_char,
2386: DEFAULT jtf_task_utl.g_miss_char,
2387: p_attribute2 IN VARCHAR2
2388: DEFAULT jtf_task_utl.g_miss_char,
2389: p_attribute3 IN VARCHAR2
2390: DEFAULT jtf_task_utl.g_miss_char,
2391: p_attribute4 IN VARCHAR2
2392: DEFAULT jtf_task_utl.g_miss_char,
2393: p_attribute5 IN VARCHAR2
2394: DEFAULT jtf_task_utl.g_miss_char,
2388: DEFAULT jtf_task_utl.g_miss_char,
2389: p_attribute3 IN VARCHAR2
2390: DEFAULT jtf_task_utl.g_miss_char,
2391: p_attribute4 IN VARCHAR2
2392: DEFAULT jtf_task_utl.g_miss_char,
2393: p_attribute5 IN VARCHAR2
2394: DEFAULT jtf_task_utl.g_miss_char,
2395: p_attribute6 IN VARCHAR2
2396: DEFAULT jtf_task_utl.g_miss_char,
2390: DEFAULT jtf_task_utl.g_miss_char,
2391: p_attribute4 IN VARCHAR2
2392: DEFAULT jtf_task_utl.g_miss_char,
2393: p_attribute5 IN VARCHAR2
2394: DEFAULT jtf_task_utl.g_miss_char,
2395: p_attribute6 IN VARCHAR2
2396: DEFAULT jtf_task_utl.g_miss_char,
2397: p_attribute7 IN VARCHAR2
2398: DEFAULT jtf_task_utl.g_miss_char,
2392: DEFAULT jtf_task_utl.g_miss_char,
2393: p_attribute5 IN VARCHAR2
2394: DEFAULT jtf_task_utl.g_miss_char,
2395: p_attribute6 IN VARCHAR2
2396: DEFAULT jtf_task_utl.g_miss_char,
2397: p_attribute7 IN VARCHAR2
2398: DEFAULT jtf_task_utl.g_miss_char,
2399: p_attribute8 IN VARCHAR2
2400: DEFAULT jtf_task_utl.g_miss_char,
2394: DEFAULT jtf_task_utl.g_miss_char,
2395: p_attribute6 IN VARCHAR2
2396: DEFAULT jtf_task_utl.g_miss_char,
2397: p_attribute7 IN VARCHAR2
2398: DEFAULT jtf_task_utl.g_miss_char,
2399: p_attribute8 IN VARCHAR2
2400: DEFAULT jtf_task_utl.g_miss_char,
2401: p_attribute9 IN VARCHAR2
2402: DEFAULT jtf_task_utl.g_miss_char,
2396: DEFAULT jtf_task_utl.g_miss_char,
2397: p_attribute7 IN VARCHAR2
2398: DEFAULT jtf_task_utl.g_miss_char,
2399: p_attribute8 IN VARCHAR2
2400: DEFAULT jtf_task_utl.g_miss_char,
2401: p_attribute9 IN VARCHAR2
2402: DEFAULT jtf_task_utl.g_miss_char,
2403: p_attribute10 IN VARCHAR2
2404: DEFAULT jtf_task_utl.g_miss_char,
2398: DEFAULT jtf_task_utl.g_miss_char,
2399: p_attribute8 IN VARCHAR2
2400: DEFAULT jtf_task_utl.g_miss_char,
2401: p_attribute9 IN VARCHAR2
2402: DEFAULT jtf_task_utl.g_miss_char,
2403: p_attribute10 IN VARCHAR2
2404: DEFAULT jtf_task_utl.g_miss_char,
2405: p_attribute11 IN VARCHAR2
2406: DEFAULT jtf_task_utl.g_miss_char,
2400: DEFAULT jtf_task_utl.g_miss_char,
2401: p_attribute9 IN VARCHAR2
2402: DEFAULT jtf_task_utl.g_miss_char,
2403: p_attribute10 IN VARCHAR2
2404: DEFAULT jtf_task_utl.g_miss_char,
2405: p_attribute11 IN VARCHAR2
2406: DEFAULT jtf_task_utl.g_miss_char,
2407: p_attribute12 IN VARCHAR2
2408: DEFAULT jtf_task_utl.g_miss_char,
2402: DEFAULT jtf_task_utl.g_miss_char,
2403: p_attribute10 IN VARCHAR2
2404: DEFAULT jtf_task_utl.g_miss_char,
2405: p_attribute11 IN VARCHAR2
2406: DEFAULT jtf_task_utl.g_miss_char,
2407: p_attribute12 IN VARCHAR2
2408: DEFAULT jtf_task_utl.g_miss_char,
2409: p_attribute13 IN VARCHAR2
2410: DEFAULT jtf_task_utl.g_miss_char,
2404: DEFAULT jtf_task_utl.g_miss_char,
2405: p_attribute11 IN VARCHAR2
2406: DEFAULT jtf_task_utl.g_miss_char,
2407: p_attribute12 IN VARCHAR2
2408: DEFAULT jtf_task_utl.g_miss_char,
2409: p_attribute13 IN VARCHAR2
2410: DEFAULT jtf_task_utl.g_miss_char,
2411: p_attribute14 IN VARCHAR2
2412: DEFAULT jtf_task_utl.g_miss_char,
2406: DEFAULT jtf_task_utl.g_miss_char,
2407: p_attribute12 IN VARCHAR2
2408: DEFAULT jtf_task_utl.g_miss_char,
2409: p_attribute13 IN VARCHAR2
2410: DEFAULT jtf_task_utl.g_miss_char,
2411: p_attribute14 IN VARCHAR2
2412: DEFAULT jtf_task_utl.g_miss_char,
2413: p_attribute15 IN VARCHAR2
2414: DEFAULT jtf_task_utl.g_miss_char,
2408: DEFAULT jtf_task_utl.g_miss_char,
2409: p_attribute13 IN VARCHAR2
2410: DEFAULT jtf_task_utl.g_miss_char,
2411: p_attribute14 IN VARCHAR2
2412: DEFAULT jtf_task_utl.g_miss_char,
2413: p_attribute15 IN VARCHAR2
2414: DEFAULT jtf_task_utl.g_miss_char,
2415: p_attribute_category IN VARCHAR2
2416: DEFAULT jtf_task_utl.g_miss_char,
2410: DEFAULT jtf_task_utl.g_miss_char,
2411: p_attribute14 IN VARCHAR2
2412: DEFAULT jtf_task_utl.g_miss_char,
2413: p_attribute15 IN VARCHAR2
2414: DEFAULT jtf_task_utl.g_miss_char,
2415: p_attribute_category IN VARCHAR2
2416: DEFAULT jtf_task_utl.g_miss_char,
2417: p_show_on_calendar IN VARCHAR2
2418: DEFAULT jtf_task_utl.g_miss_char,
2412: DEFAULT jtf_task_utl.g_miss_char,
2413: p_attribute15 IN VARCHAR2
2414: DEFAULT jtf_task_utl.g_miss_char,
2415: p_attribute_category IN VARCHAR2
2416: DEFAULT jtf_task_utl.g_miss_char,
2417: p_show_on_calendar IN VARCHAR2
2418: DEFAULT jtf_task_utl.g_miss_char,
2419: p_category_id IN NUMBER
2420: DEFAULT jtf_task_utl.g_miss_number
2414: DEFAULT jtf_task_utl.g_miss_char,
2415: p_attribute_category IN VARCHAR2
2416: DEFAULT jtf_task_utl.g_miss_char,
2417: p_show_on_calendar IN VARCHAR2
2418: DEFAULT jtf_task_utl.g_miss_char,
2419: p_category_id IN NUMBER
2420: DEFAULT jtf_task_utl.g_miss_number
2421: )
2422: IS
2416: DEFAULT jtf_task_utl.g_miss_char,
2417: p_show_on_calendar IN VARCHAR2
2418: DEFAULT jtf_task_utl.g_miss_char,
2419: p_category_id IN NUMBER
2420: DEFAULT jtf_task_utl.g_miss_number
2421: )
2422: IS
2423: BEGIN
2424: jtf_task_assignments_pub.update_task_assignment (