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_PUB dependencies on JTF_TASK_TEMPLATES_B

Line 254: l_task_group_id jtf_task_templates_b.task_group_id%TYPE;

250: l_task_status_id jtf_tasks_b.task_status_id%TYPE := p_task_status_id;
251: l_dependency_id jtf_task_depends.dependency_id%TYPE;
252: l_recurrence_rule_id jtf_task_recur_rules.recurrence_rule_id%TYPE;
253: l_task_rec jtf_task_recurrences_pub.task_details_rec;
254: l_task_group_id jtf_task_templates_b.task_group_id%TYPE;
255: l_description jtf_task_templates_tl.description%TYPE := p_description;
256: l_reccurence_generated NUMBER;
257: l_type VARCHAR2(10);
258: current_record INTEGER;

Line 260: l_task_confirmation_status jtf_task_templates_b.task_confirmation_status%TYPE;

256: l_reccurence_generated NUMBER;
257: l_type VARCHAR2(10);
258: current_record INTEGER;
259: x CHAR;
260: l_task_confirmation_status jtf_task_templates_b.task_confirmation_status%TYPE;
261:
262: CURSOR c_task_templates
263: IS
264: SELECT 1

Line 265: FROM jtf_task_templates_b

261:
262: CURSOR c_task_templates
263: IS
264: SELECT 1
265: FROM jtf_task_templates_b
266: WHERE task_template_id = x_task_id;
267: BEGIN
268: SAVEPOINT create_task_pub;
269: x_return_status := fnd_api.g_ret_sts_success;

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

818: p_task_confirmation_status IN VARCHAR2
819: ) is
820: l_api_version CONSTANT NUMBER := 1.0;
821: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_TEMPLATE';
822: l_task_id jtf_task_templates_b.task_template_id%TYPE := p_task_id;
823: l_task_number jtf_task_templates_b.task_number%TYPE := p_task_number;
824: l_task_name jtf_task_templates_tl.task_name%TYPE := p_task_name;
825: l_task_type_name jtf_task_types_tl.name%TYPE := p_task_type_name;
826: l_task_type_id jtf_task_types_b.task_type_id%TYPE := p_task_type_id;

Line 823: l_task_number jtf_task_templates_b.task_number%TYPE := p_task_number;

819: ) is
820: l_api_version CONSTANT NUMBER := 1.0;
821: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_TEMPLATE';
822: l_task_id jtf_task_templates_b.task_template_id%TYPE := p_task_id;
823: l_task_number jtf_task_templates_b.task_number%TYPE := p_task_number;
824: l_task_name jtf_task_templates_tl.task_name%TYPE := p_task_name;
825: l_task_type_name jtf_task_types_tl.name%TYPE := p_task_type_name;
826: l_task_type_id jtf_task_types_b.task_type_id%TYPE := p_task_type_id;
827: l_task_status_name jtf_task_statuses_tl.name%TYPE := p_task_status_name;

Line 831: l_duration jtf_task_templates_b.duration%TYPE;

827: l_task_status_name jtf_task_statuses_tl.name%TYPE := p_task_status_name;
828: l_task_status_id jtf_task_statuses_b.task_status_id%TYPE := p_task_status_id;
829: l_task_priority_name jtf_task_priorities_tl.name%TYPE := p_task_priority_name;
830: l_task_priority_id jtf_task_priorities_b.task_priority_id%TYPE := p_task_priority_id;
831: l_duration jtf_task_templates_b.duration%TYPE;
832: l_duration_uom jtf_task_templates_b.duration_uom%TYPE;
833: l_private_flag jtf_task_templates_b.private_flag%TYPE;
834: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;
835: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;

Line 832: l_duration_uom jtf_task_templates_b.duration_uom%TYPE;

828: l_task_status_id jtf_task_statuses_b.task_status_id%TYPE := p_task_status_id;
829: l_task_priority_name jtf_task_priorities_tl.name%TYPE := p_task_priority_name;
830: l_task_priority_id jtf_task_priorities_b.task_priority_id%TYPE := p_task_priority_id;
831: l_duration jtf_task_templates_b.duration%TYPE;
832: l_duration_uom jtf_task_templates_b.duration_uom%TYPE;
833: l_private_flag jtf_task_templates_b.private_flag%TYPE;
834: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;
835: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;
836: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;

Line 833: l_private_flag jtf_task_templates_b.private_flag%TYPE;

829: l_task_priority_name jtf_task_priorities_tl.name%TYPE := p_task_priority_name;
830: l_task_priority_id jtf_task_priorities_b.task_priority_id%TYPE := p_task_priority_id;
831: l_duration jtf_task_templates_b.duration%TYPE;
832: l_duration_uom jtf_task_templates_b.duration_uom%TYPE;
833: l_private_flag jtf_task_templates_b.private_flag%TYPE;
834: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;
835: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;
836: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;
837: l_description jtf_task_templates_tl.description%TYPE;

Line 834: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;

830: l_task_priority_id jtf_task_priorities_b.task_priority_id%TYPE := p_task_priority_id;
831: l_duration jtf_task_templates_b.duration%TYPE;
832: l_duration_uom jtf_task_templates_b.duration_uom%TYPE;
833: l_private_flag jtf_task_templates_b.private_flag%TYPE;
834: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;
835: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;
836: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;
837: l_description jtf_task_templates_tl.description%TYPE;
838: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;

Line 835: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;

831: l_duration jtf_task_templates_b.duration%TYPE;
832: l_duration_uom jtf_task_templates_b.duration_uom%TYPE;
833: l_private_flag jtf_task_templates_b.private_flag%TYPE;
834: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;
835: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;
836: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;
837: l_description jtf_task_templates_tl.description%TYPE;
838: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;
839: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;

Line 836: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;

832: l_duration_uom jtf_task_templates_b.duration_uom%TYPE;
833: l_private_flag jtf_task_templates_b.private_flag%TYPE;
834: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;
835: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;
836: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;
837: l_description jtf_task_templates_tl.description%TYPE;
838: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;
839: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;
840: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;

Line 838: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;

834: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;
835: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;
836: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;
837: l_description jtf_task_templates_tl.description%TYPE;
838: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;
839: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;
840: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;
841: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;
842: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;

Line 839: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;

835: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;
836: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;
837: l_description jtf_task_templates_tl.description%TYPE;
838: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;
839: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;
840: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;
841: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;
842: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;
843: l_notification_period jtf_task_templates_b.notification_period%TYPE;

Line 840: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;

836: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;
837: l_description jtf_task_templates_tl.description%TYPE;
838: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;
839: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;
840: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;
841: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;
842: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;
843: l_notification_period jtf_task_templates_b.notification_period%TYPE;
844: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;

Line 841: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;

837: l_description jtf_task_templates_tl.description%TYPE;
838: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;
839: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;
840: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;
841: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;
842: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;
843: l_notification_period jtf_task_templates_b.notification_period%TYPE;
844: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;
845: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;

Line 842: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;

838: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;
839: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;
840: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;
841: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;
842: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;
843: l_notification_period jtf_task_templates_b.notification_period%TYPE;
844: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;
845: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;
846: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;

Line 843: l_notification_period jtf_task_templates_b.notification_period%TYPE;

839: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;
840: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;
841: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;
842: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;
843: l_notification_period jtf_task_templates_b.notification_period%TYPE;
844: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;
845: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;
846: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;
847: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;

Line 844: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;

840: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;
841: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;
842: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;
843: l_notification_period jtf_task_templates_b.notification_period%TYPE;
844: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;
845: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;
846: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;
847: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;
848: l_alarm_on jtf_task_templates_b.alarm_on%TYPE;

Line 845: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;

841: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;
842: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;
843: l_notification_period jtf_task_templates_b.notification_period%TYPE;
844: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;
845: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;
846: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;
847: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;
848: l_alarm_on jtf_task_templates_b.alarm_on%TYPE;
849: l_alarm_count jtf_task_templates_b.alarm_count%TYPE;

Line 846: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;

842: l_notification_flag jtf_task_templates_b.notification_flag%TYPE;
843: l_notification_period jtf_task_templates_b.notification_period%TYPE;
844: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;
845: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;
846: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;
847: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;
848: l_alarm_on jtf_task_templates_b.alarm_on%TYPE;
849: l_alarm_count jtf_task_templates_b.alarm_count%TYPE;
850: l_alarm_interval jtf_task_templates_b.alarm_interval%TYPE;

Line 847: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;

843: l_notification_period jtf_task_templates_b.notification_period%TYPE;
844: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;
845: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;
846: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;
847: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;
848: l_alarm_on jtf_task_templates_b.alarm_on%TYPE;
849: l_alarm_count jtf_task_templates_b.alarm_count%TYPE;
850: l_alarm_interval jtf_task_templates_b.alarm_interval%TYPE;
851: l_alarm_interval_uom jtf_task_templates_b.alarm_interval_uom%TYPE;

Line 848: l_alarm_on jtf_task_templates_b.alarm_on%TYPE;

844: l_notification_period_uom jtf_task_templates_b.notification_period_uom%TYPE;
845: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;
846: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;
847: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;
848: l_alarm_on jtf_task_templates_b.alarm_on%TYPE;
849: l_alarm_count jtf_task_templates_b.alarm_count%TYPE;
850: l_alarm_interval jtf_task_templates_b.alarm_interval%TYPE;
851: l_alarm_interval_uom jtf_task_templates_b.alarm_interval_uom%TYPE;
852: l_type varchar2(10);

Line 849: l_alarm_count jtf_task_templates_b.alarm_count%TYPE;

845: l_billable_flag jtf_task_templates_b.billable_flag%TYPE;
846: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;
847: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;
848: l_alarm_on jtf_task_templates_b.alarm_on%TYPE;
849: l_alarm_count jtf_task_templates_b.alarm_count%TYPE;
850: l_alarm_interval jtf_task_templates_b.alarm_interval%TYPE;
851: l_alarm_interval_uom jtf_task_templates_b.alarm_interval_uom%TYPE;
852: l_type varchar2(10);
853: l_task_confirmation_status jtf_task_templates_b.task_confirmation_status%TYPE;

Line 850: l_alarm_interval jtf_task_templates_b.alarm_interval%TYPE;

846: l_alarm_start jtf_task_templates_b.alarm_start%TYPE;
847: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;
848: l_alarm_on jtf_task_templates_b.alarm_on%TYPE;
849: l_alarm_count jtf_task_templates_b.alarm_count%TYPE;
850: l_alarm_interval jtf_task_templates_b.alarm_interval%TYPE;
851: l_alarm_interval_uom jtf_task_templates_b.alarm_interval_uom%TYPE;
852: l_type varchar2(10);
853: l_task_confirmation_status jtf_task_templates_b.task_confirmation_status%TYPE;
854:

Line 851: l_alarm_interval_uom jtf_task_templates_b.alarm_interval_uom%TYPE;

847: l_alarm_start_uom jtf_task_templates_b.alarm_start_uom%TYPE;
848: l_alarm_on jtf_task_templates_b.alarm_on%TYPE;
849: l_alarm_count jtf_task_templates_b.alarm_count%TYPE;
850: l_alarm_interval jtf_task_templates_b.alarm_interval%TYPE;
851: l_alarm_interval_uom jtf_task_templates_b.alarm_interval_uom%TYPE;
852: l_type varchar2(10);
853: l_task_confirmation_status jtf_task_templates_b.task_confirmation_status%TYPE;
854:
855:

Line 853: l_task_confirmation_status jtf_task_templates_b.task_confirmation_status%TYPE;

849: l_alarm_count jtf_task_templates_b.alarm_count%TYPE;
850: l_alarm_interval jtf_task_templates_b.alarm_interval%TYPE;
851: l_alarm_interval_uom jtf_task_templates_b.alarm_interval_uom%TYPE;
852: l_type varchar2(10);
853: l_task_confirmation_status jtf_task_templates_b.task_confirmation_status%TYPE;
854:
855:
856: CURSOR c_task_update (
857: l_task_id IN NUMBER