eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TASK_TEMPLATES_PVT dependencies on JTF_TASK_TEMPLATES_B

Line 252: FROM jtf_task_templates_b

248:
249: CURSOR c_jtf_tasks (l_rowid IN ROWID)
250: IS
251: SELECT 1
252: FROM jtf_task_templates_b
253: WHERE ROWID = l_rowid;
254:
255: x CHAR;
256: BEGIN

Line 662: l_task_id jtf_task_templates_b.task_template_id%TYPE;

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;
663: l_task_group_id jtf_task_templates_b.task_group_id%TYPE;
664: l_task_number jtf_task_templates_b.task_number%TYPE;
665: l_task_type_id jtf_task_templates_b.task_type_id%TYPE;
666: l_task_status_id jtf_task_templates_b.task_status_id%TYPE;

Line 663: l_task_group_id jtf_task_templates_b.task_group_id%TYPE;

659: p_task_confirmation_status IN VARCHAR2
660: )
661: IS
662: l_task_id jtf_task_templates_b.task_template_id%TYPE;
663: l_task_group_id jtf_task_templates_b.task_group_id%TYPE;
664: l_task_number jtf_task_templates_b.task_number%TYPE;
665: l_task_type_id jtf_task_templates_b.task_type_id%TYPE;
666: l_task_status_id jtf_task_templates_b.task_status_id%TYPE;
667: l_task_priority_id jtf_task_templates_b.task_priority_id%TYPE;

Line 664: l_task_number jtf_task_templates_b.task_number%TYPE;

660: )
661: IS
662: l_task_id jtf_task_templates_b.task_template_id%TYPE;
663: l_task_group_id jtf_task_templates_b.task_group_id%TYPE;
664: l_task_number jtf_task_templates_b.task_number%TYPE;
665: l_task_type_id jtf_task_templates_b.task_type_id%TYPE;
666: l_task_status_id jtf_task_templates_b.task_status_id%TYPE;
667: l_task_priority_id jtf_task_templates_b.task_priority_id%TYPE;
668: l_duration jtf_task_templates_b.duration%TYPE;

Line 665: l_task_type_id jtf_task_templates_b.task_type_id%TYPE;

661: IS
662: l_task_id jtf_task_templates_b.task_template_id%TYPE;
663: l_task_group_id jtf_task_templates_b.task_group_id%TYPE;
664: l_task_number jtf_task_templates_b.task_number%TYPE;
665: l_task_type_id jtf_task_templates_b.task_type_id%TYPE;
666: l_task_status_id jtf_task_templates_b.task_status_id%TYPE;
667: l_task_priority_id jtf_task_templates_b.task_priority_id%TYPE;
668: l_duration jtf_task_templates_b.duration%TYPE;
669: l_duration_uom jtf_task_templates_b.duration_uom%TYPE;

Line 666: l_task_status_id jtf_task_templates_b.task_status_id%TYPE;

662: l_task_id jtf_task_templates_b.task_template_id%TYPE;
663: l_task_group_id jtf_task_templates_b.task_group_id%TYPE;
664: l_task_number jtf_task_templates_b.task_number%TYPE;
665: l_task_type_id jtf_task_templates_b.task_type_id%TYPE;
666: l_task_status_id jtf_task_templates_b.task_status_id%TYPE;
667: l_task_priority_id jtf_task_templates_b.task_priority_id%TYPE;
668: l_duration jtf_task_templates_b.duration%TYPE;
669: l_duration_uom jtf_task_templates_b.duration_uom%TYPE;
670: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;

Line 667: l_task_priority_id jtf_task_templates_b.task_priority_id%TYPE;

663: l_task_group_id jtf_task_templates_b.task_group_id%TYPE;
664: l_task_number jtf_task_templates_b.task_number%TYPE;
665: l_task_type_id jtf_task_templates_b.task_type_id%TYPE;
666: l_task_status_id jtf_task_templates_b.task_status_id%TYPE;
667: l_task_priority_id jtf_task_templates_b.task_priority_id%TYPE;
668: l_duration jtf_task_templates_b.duration%TYPE;
669: l_duration_uom jtf_task_templates_b.duration_uom%TYPE;
670: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;
671: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;

Line 668: l_duration jtf_task_templates_b.duration%TYPE;

664: l_task_number jtf_task_templates_b.task_number%TYPE;
665: l_task_type_id jtf_task_templates_b.task_type_id%TYPE;
666: l_task_status_id jtf_task_templates_b.task_status_id%TYPE;
667: l_task_priority_id jtf_task_templates_b.task_priority_id%TYPE;
668: l_duration jtf_task_templates_b.duration%TYPE;
669: l_duration_uom jtf_task_templates_b.duration_uom%TYPE;
670: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;
671: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;
672: l_private_flag jtf_task_templates_b.private_flag%TYPE;

Line 669: l_duration_uom jtf_task_templates_b.duration_uom%TYPE;

665: l_task_type_id jtf_task_templates_b.task_type_id%TYPE;
666: l_task_status_id jtf_task_templates_b.task_status_id%TYPE;
667: l_task_priority_id jtf_task_templates_b.task_priority_id%TYPE;
668: l_duration jtf_task_templates_b.duration%TYPE;
669: l_duration_uom jtf_task_templates_b.duration_uom%TYPE;
670: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;
671: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;
672: l_private_flag jtf_task_templates_b.private_flag%TYPE;
673: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;

Line 670: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;

666: l_task_status_id jtf_task_templates_b.task_status_id%TYPE;
667: l_task_priority_id jtf_task_templates_b.task_priority_id%TYPE;
668: l_duration jtf_task_templates_b.duration%TYPE;
669: l_duration_uom jtf_task_templates_b.duration_uom%TYPE;
670: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;
671: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;
672: l_private_flag jtf_task_templates_b.private_flag%TYPE;
673: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;
674: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;

Line 671: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;

667: l_task_priority_id jtf_task_templates_b.task_priority_id%TYPE;
668: l_duration jtf_task_templates_b.duration%TYPE;
669: l_duration_uom jtf_task_templates_b.duration_uom%TYPE;
670: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;
671: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;
672: l_private_flag jtf_task_templates_b.private_flag%TYPE;
673: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;
674: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;
675: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;

Line 672: l_private_flag jtf_task_templates_b.private_flag%TYPE;

668: l_duration jtf_task_templates_b.duration%TYPE;
669: l_duration_uom jtf_task_templates_b.duration_uom%TYPE;
670: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;
671: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;
672: l_private_flag jtf_task_templates_b.private_flag%TYPE;
673: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;
674: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;
675: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;
676: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;

Line 673: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;

669: l_duration_uom jtf_task_templates_b.duration_uom%TYPE;
670: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;
671: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;
672: l_private_flag jtf_task_templates_b.private_flag%TYPE;
673: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;
674: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;
675: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;
676: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;
677: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;

Line 674: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;

670: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;
671: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;
672: l_private_flag jtf_task_templates_b.private_flag%TYPE;
673: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;
674: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;
675: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;
676: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;
677: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;
678: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;

Line 675: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;

671: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;
672: l_private_flag jtf_task_templates_b.private_flag%TYPE;
673: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;
674: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;
675: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;
676: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;
677: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;
678: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;
679: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;

Line 676: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;

672: l_private_flag jtf_task_templates_b.private_flag%TYPE;
673: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;
674: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;
675: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;
676: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;
677: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;
678: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;
679: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;
680: l_notification_period jtf_task_templates_b.notification_period%TYPE;

Line 677: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;

673: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;
674: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;
675: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;
676: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;
677: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;
678: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;
679: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;
680: l_notification_period jtf_task_templates_b.notification_period%TYPE;
681: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;

Line 678: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;

674: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;
675: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;
676: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;
677: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;
678: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;
679: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;
680: l_notification_period jtf_task_templates_b.notification_period%TYPE;
681: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;
682: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;

Line 679: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;

675: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;
676: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;
677: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;
678: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;
679: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;
680: l_notification_period jtf_task_templates_b.notification_period%TYPE;
681: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;
682: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;
683: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;

Line 680: l_notification_period jtf_task_templates_b.notification_period%TYPE;

676: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;
677: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;
678: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;
679: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;
680: l_notification_period jtf_task_templates_b.notification_period%TYPE;
681: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;
682: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;
683: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;
684: l_alarm_on jtf_task_templates_b.alarm_on%TYPE;

Line 681: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;

677: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;
678: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;
679: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;
680: l_notification_period jtf_task_templates_b.notification_period%TYPE;
681: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;
682: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;
683: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;
684: l_alarm_on jtf_task_templates_b.alarm_on%TYPE;
685: l_alarm_count jtf_task_templates_b.alarm_count%TYPE;

Line 682: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;

678: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;
679: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;
680: l_notification_period jtf_task_templates_b.notification_period%TYPE;
681: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;
682: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;
683: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;
684: l_alarm_on jtf_task_templates_b.alarm_on%TYPE;
685: l_alarm_count jtf_task_templates_b.alarm_count%TYPE;
686: l_alarm_interval jtf_task_templates_b.alarm_interval%TYPE;

Line 683: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;

679: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;
680: l_notification_period jtf_task_templates_b.notification_period%TYPE;
681: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;
682: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;
683: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;
684: l_alarm_on jtf_task_templates_b.alarm_on%TYPE;
685: l_alarm_count jtf_task_templates_b.alarm_count%TYPE;
686: l_alarm_interval jtf_task_templates_b.alarm_interval%TYPE;
687: l_alarm_interval_uom jtf_task_templates_b.alarm_interval_uom%TYPE;

Line 684: l_alarm_on jtf_task_templates_b.alarm_on%TYPE;

680: l_notification_period jtf_task_templates_b.notification_period%TYPE;
681: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;
682: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;
683: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;
684: l_alarm_on jtf_task_templates_b.alarm_on%TYPE;
685: l_alarm_count jtf_task_templates_b.alarm_count%TYPE;
686: l_alarm_interval jtf_task_templates_b.alarm_interval%TYPE;
687: l_alarm_interval_uom jtf_task_templates_b.alarm_interval_uom%TYPE;
688: l_task_name jtf_task_templates_tl.task_name%TYPE;

Line 685: l_alarm_count jtf_task_templates_b.alarm_count%TYPE;

681: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;
682: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;
683: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;
684: l_alarm_on jtf_task_templates_b.alarm_on%TYPE;
685: l_alarm_count jtf_task_templates_b.alarm_count%TYPE;
686: l_alarm_interval jtf_task_templates_b.alarm_interval%TYPE;
687: l_alarm_interval_uom jtf_task_templates_b.alarm_interval_uom%TYPE;
688: l_task_name jtf_task_templates_tl.task_name%TYPE;
689: l_description jtf_task_templates_tl.description%TYPE;

Line 686: l_alarm_interval jtf_task_templates_b.alarm_interval%TYPE;

682: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;
683: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;
684: l_alarm_on jtf_task_templates_b.alarm_on%TYPE;
685: l_alarm_count jtf_task_templates_b.alarm_count%TYPE;
686: l_alarm_interval jtf_task_templates_b.alarm_interval%TYPE;
687: l_alarm_interval_uom jtf_task_templates_b.alarm_interval_uom%TYPE;
688: l_task_name jtf_task_templates_tl.task_name%TYPE;
689: l_description jtf_task_templates_tl.description%TYPE;
690: l_task_confirmation_status jtf_task_templates_b.task_confirmation_status%TYPE;

Line 687: l_alarm_interval_uom jtf_task_templates_b.alarm_interval_uom%TYPE;

683: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;
684: l_alarm_on jtf_task_templates_b.alarm_on%TYPE;
685: l_alarm_count jtf_task_templates_b.alarm_count%TYPE;
686: l_alarm_interval jtf_task_templates_b.alarm_interval%TYPE;
687: l_alarm_interval_uom jtf_task_templates_b.alarm_interval_uom%TYPE;
688: l_task_name jtf_task_templates_tl.task_name%TYPE;
689: l_description jtf_task_templates_tl.description%TYPE;
690: l_task_confirmation_status jtf_task_templates_b.task_confirmation_status%TYPE;
691:

Line 690: l_task_confirmation_status jtf_task_templates_b.task_confirmation_status%TYPE;

686: l_alarm_interval jtf_task_templates_b.alarm_interval%TYPE;
687: l_alarm_interval_uom jtf_task_templates_b.alarm_interval_uom%TYPE;
688: l_task_name jtf_task_templates_tl.task_name%TYPE;
689: l_description jtf_task_templates_tl.description%TYPE;
690: l_task_confirmation_status jtf_task_templates_b.task_confirmation_status%TYPE;
691:
692: CURSOR c_task
693: IS
694: SELECT task_number,

Line 992: l_task_id jtf_task_templates_b.task_template_id%TYPE := p_task_id;

988: x_msg_count OUT NOCOPY NUMBER,
989: x_msg_data OUT NOCOPY VARCHAR2
990: )
991: IS
992: l_task_id jtf_task_templates_b.task_template_id%TYPE := p_task_id;
993:
994: CURSOR c_dependencies
995: IS
996: SELECT dependency_id, object_version_number

Line 1044: UPDATE jtf_task_templates_b

1040: x_return_status := fnd_api.g_ret_sts_unexp_error;
1041: RAISE fnd_api.g_exc_unexpected_error;
1042: END IF;
1043:
1044: UPDATE jtf_task_templates_b
1045: SET deleted_flag = 'Y'
1046: WHERE task_template_id = l_task_id;
1047:
1048: IF SQL%NOTFOUND