DBA Data[Home] [Help]

APPS.JTF_TASK_TEMPLATES_PVT dependencies on JTF_TASK_UTL

Line 344: x_deleted_flag => jtf_task_utl.g_no,

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 ,

Line 369: x_created_by => jtf_task_utl.created_by,

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:

Line 371: x_last_updated_by => jtf_task_utl.updated_by,

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

Line 372: x_last_update_login => jtf_task_utl.login_id

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;

Line 466: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

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,

Line 467: p_attribute2 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,

Line 468: p_attribute3 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,

Line 469: p_attribute4 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,

Line 470: p_attribute5 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,

Line 471: p_attribute6 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,

Line 472: p_attribute7 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,

Line 473: p_attribute8 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,

Line 474: p_attribute9 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,

Line 475: p_attribute10 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,

Line 476: p_attribute11 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,

Line 477: p_attribute12 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

Line 478: p_attribute13 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: )

Line 479: p_attribute14 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: )
483: IS

Line 480: p_attribute15 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
484: l_api_version CONSTANT NUMBER := 1.0;

Line 481: p_attribute_category 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;
485: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK';

Line 643: p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,

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,

Line 644: p_attribute2 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,

Line 645: p_attribute3 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,

Line 646: p_attribute4 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,

Line 647: p_attribute5 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,

Line 648: p_attribute6 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,

Line 649: p_attribute7 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,

Line 650: p_attribute8 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,

Line 651: p_attribute9 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,

Line 652: p_attribute10 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,

Line 653: p_attribute11 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,

Line 654: p_attribute12 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,

Line 655: p_attribute13 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

Line 656: p_attribute14 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
660: )

Line 657: p_attribute15 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: )
661: IS

Line 658: p_attribute_category 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
662: l_task_id jtf_task_templates_b.task_template_id%TYPE;

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

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;

Line 973: x_last_updated_by => jtf_task_utl.updated_by,

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;

Line 974: x_last_update_login => jtf_task_utl.login_id

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:

Line 1000: AND (template_flag = jtf_task_utl.g_yes);

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: