340: x_alarm_on => p_alarm_on,
341: x_alarm_count => p_alarm_count,
342: x_alarm_interval => p_alarm_interval,
343: x_alarm_interval_uom => p_alarm_interval_uom,
344: x_deleted_flag => jtf_task_utl.g_no,
345: x_attribute1 => p_attribute1 ,
346: x_attribute2 => p_attribute2 ,
347: x_attribute3 => p_attribute3 ,
348: x_attribute4 => p_attribute4 ,
365: x_task_name => p_task_name,
366: x_description => p_description,
367: x_task_confirmation_status => l_task_confirmation_status,
368: x_creation_date => SYSDATE,
369: x_created_by => jtf_task_utl.created_by,
370: x_last_update_date => SYSDATE,
371: x_last_updated_by => jtf_task_utl.updated_by,
372: x_last_update_login => jtf_task_utl.login_id
373:
367: x_task_confirmation_status => l_task_confirmation_status,
368: x_creation_date => SYSDATE,
369: x_created_by => jtf_task_utl.created_by,
370: x_last_update_date => SYSDATE,
371: x_last_updated_by => jtf_task_utl.updated_by,
372: x_last_update_login => jtf_task_utl.login_id
373:
374: );
375: OPEN c_jtf_tasks (l_rowid);
368: x_creation_date => SYSDATE,
369: x_created_by => jtf_task_utl.created_by,
370: x_last_update_date => SYSDATE,
371: x_last_updated_by => jtf_task_utl.updated_by,
372: x_last_update_login => jtf_task_utl.login_id
373:
374: );
375: OPEN c_jtf_tasks (l_rowid);
376: FETCH c_jtf_tasks INTO x;
462: DEFAULT fnd_api.g_miss_char,
463: x_return_status OUT NOCOPY VARCHAR2,
464: x_msg_count OUT NOCOPY NUMBER,
465: x_msg_data OUT NOCOPY VARCHAR2,
466: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
467: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
468: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
469: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
470: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
463: x_return_status OUT NOCOPY VARCHAR2,
464: x_msg_count OUT NOCOPY NUMBER,
465: x_msg_data OUT NOCOPY VARCHAR2,
466: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
467: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
468: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
469: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
470: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
471: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
464: x_msg_count OUT NOCOPY NUMBER,
465: x_msg_data OUT NOCOPY VARCHAR2,
466: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
467: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
468: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
469: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
470: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
471: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
472: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
465: x_msg_data OUT NOCOPY VARCHAR2,
466: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
467: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
468: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
469: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
470: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
471: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
472: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
473: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
466: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
467: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
468: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
469: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
470: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
471: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
472: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
473: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
474: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
467: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
468: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
469: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
470: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
471: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
472: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
473: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
474: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
475: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
468: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
469: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
470: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
471: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
472: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
473: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
474: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
475: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
476: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
469: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
470: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
471: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
472: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
473: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
474: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
475: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
476: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
477: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
470: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
471: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
472: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
473: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
474: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
475: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
476: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
477: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
478: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
471: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
472: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
473: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
474: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
475: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
476: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
477: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
478: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
479: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
472: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
473: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
474: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
475: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
476: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
477: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
478: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
479: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
480: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
473: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
474: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
475: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
476: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
477: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
478: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
479: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
480: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
481: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
474: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
475: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
476: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
477: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
478: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
479: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
480: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
481: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
482: )
475: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
476: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
477: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
478: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
479: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
480: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
481: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
482: )
483: IS
476: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
477: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
478: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
479: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
480: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
481: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
482: )
483: IS
484: l_api_version CONSTANT NUMBER := 1.0;
477: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
478: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
479: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
480: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
481: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
482: )
483: IS
484: l_api_version CONSTANT NUMBER := 1.0;
485: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK';
639: DEFAULT fnd_api.g_miss_char,
640: x_return_status OUT NOCOPY VARCHAR2,
641: x_msg_count OUT NOCOPY NUMBER,
642: x_msg_data OUT NOCOPY VARCHAR2,
643: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
644: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
645: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
646: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
647: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
640: x_return_status OUT NOCOPY VARCHAR2,
641: x_msg_count OUT NOCOPY NUMBER,
642: x_msg_data OUT NOCOPY VARCHAR2,
643: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
644: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
645: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
646: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
647: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
648: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
641: x_msg_count OUT NOCOPY NUMBER,
642: x_msg_data OUT NOCOPY VARCHAR2,
643: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
644: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
645: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
646: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
647: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
648: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
649: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
642: x_msg_data OUT NOCOPY VARCHAR2,
643: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
644: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
645: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
646: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
647: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
648: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
649: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
650: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
643: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
644: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
645: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
646: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
647: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
648: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
649: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
650: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
651: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
644: p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
645: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
646: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
647: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
648: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
649: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
650: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
651: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
652: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
645: p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
646: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
647: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
648: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
649: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
650: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
651: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
652: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
653: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
646: p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
647: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
648: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
649: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
650: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
651: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
652: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
653: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
654: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
647: p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
648: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
649: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
650: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
651: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
652: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
653: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
654: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
655: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
648: p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
649: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
650: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
651: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
652: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
653: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
654: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
655: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
656: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
649: p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
650: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
651: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
652: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
653: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
654: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
655: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
656: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
657: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
650: p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
651: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
652: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
653: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
654: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
655: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
656: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
657: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
658: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
651: p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
652: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
653: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
654: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
655: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
656: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
657: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
658: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
659: p_task_confirmation_status IN VARCHAR2
652: p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
653: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
654: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
655: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
656: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
657: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
658: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
659: p_task_confirmation_status IN VARCHAR2
660: )
653: p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
654: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
655: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
656: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
657: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
658: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
659: p_task_confirmation_status IN VARCHAR2
660: )
661: IS
654: p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
655: p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
656: p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
657: p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
658: p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
659: p_task_confirmation_status IN VARCHAR2
660: )
661: IS
662: l_task_id jtf_task_templates_b.task_template_id%TYPE;
854: decode( p_attribute13 , fnd_api.g_miss_char , attribute13 , p_attribute13 ) attribute13 ,
855: decode( p_attribute14 , fnd_api.g_miss_char , attribute14 , p_attribute14 ) attribute14 ,
856: decode( p_attribute15 , fnd_api.g_miss_char , attribute15 , p_attribute15 ) attribute15 ,
857: decode( p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
858: decode( p_task_confirmation_status,jtf_task_utl.g_miss_char,task_confirmation_status,p_task_confirmation_status)
859: task_confirmation_status
860: FROM jtf_task_templates_vl
861: WHERE task_template_id =
862: p_task_id;
969: x_task_name => l_task_name,
970: x_description => l_description,
971: x_task_confirmation_status => l_task_confirmation_status,
972: x_last_update_date => SYSDATE,
973: x_last_updated_by => jtf_task_utl.updated_by,
974: x_last_update_login => jtf_task_utl.login_id
975: );
976:
977: p_object_version_number := p_object_version_number + 1;
970: x_description => l_description,
971: x_task_confirmation_status => l_task_confirmation_status,
972: x_last_update_date => SYSDATE,
973: x_last_updated_by => jtf_task_utl.updated_by,
974: x_last_update_login => jtf_task_utl.login_id
975: );
976:
977: p_object_version_number := p_object_version_number + 1;
978:
996: SELECT dependency_id, object_version_number
997: FROM jtf_task_depends
998: WHERE ( task_id = l_task_id
999: OR dependent_on_task_id = l_task_id)
1000: AND (template_flag = jtf_task_utl.g_yes);
1001: BEGIN
1002: SAVEPOINT delete_task_pvt;
1003: x_return_status := fnd_api.g_ret_sts_success;
1004: