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_TASKS_PUB dependencies on JTF_TASK_ASSIGNMENTS

Line 27: resource_type_code jtf_task_assignments.resource_type_code%TYPE

23: , task_template_id NUMBER
24: );
25:
26: TYPE task_assign_rec IS RECORD(
27: resource_type_code jtf_task_assignments.resource_type_code%TYPE
28: , resource_id jtf_task_assignments.resource_id%TYPE
29: , actual_start_date DATE := NULL
30: , actual_end_date DATE := NULL
31: , actual_effort jtf_task_assignments.actual_effort%TYPE := NULL

Line 28: , resource_id jtf_task_assignments.resource_id%TYPE

24: );
25:
26: TYPE task_assign_rec IS RECORD(
27: resource_type_code jtf_task_assignments.resource_type_code%TYPE
28: , resource_id jtf_task_assignments.resource_id%TYPE
29: , actual_start_date DATE := NULL
30: , actual_end_date DATE := NULL
31: , actual_effort jtf_task_assignments.actual_effort%TYPE := NULL
32: , actual_effort_uom jtf_task_assignments.actual_effort_uom%TYPE := NULL

Line 31: , actual_effort jtf_task_assignments.actual_effort%TYPE := NULL

27: resource_type_code jtf_task_assignments.resource_type_code%TYPE
28: , resource_id jtf_task_assignments.resource_id%TYPE
29: , actual_start_date DATE := NULL
30: , actual_end_date DATE := NULL
31: , actual_effort jtf_task_assignments.actual_effort%TYPE := NULL
32: , actual_effort_uom jtf_task_assignments.actual_effort_uom%TYPE := NULL
33: , sched_travel_distance jtf_task_assignments.sched_travel_distance%TYPE := NULL
34: , sched_travel_duration jtf_task_assignments.sched_travel_duration%TYPE := NULL
35: , sched_travel_duration_uom jtf_task_assignments.sched_travel_duration_uom%TYPE := NULL

Line 32: , actual_effort_uom jtf_task_assignments.actual_effort_uom%TYPE := NULL

28: , resource_id jtf_task_assignments.resource_id%TYPE
29: , actual_start_date DATE := NULL
30: , actual_end_date DATE := NULL
31: , actual_effort jtf_task_assignments.actual_effort%TYPE := NULL
32: , actual_effort_uom jtf_task_assignments.actual_effort_uom%TYPE := NULL
33: , sched_travel_distance jtf_task_assignments.sched_travel_distance%TYPE := NULL
34: , sched_travel_duration jtf_task_assignments.sched_travel_duration%TYPE := NULL
35: , sched_travel_duration_uom jtf_task_assignments.sched_travel_duration_uom%TYPE := NULL
36: , actual_travel_distance jtf_task_assignments.actual_travel_distance%TYPE := NULL

Line 33: , sched_travel_distance jtf_task_assignments.sched_travel_distance%TYPE := NULL

29: , actual_start_date DATE := NULL
30: , actual_end_date DATE := NULL
31: , actual_effort jtf_task_assignments.actual_effort%TYPE := NULL
32: , actual_effort_uom jtf_task_assignments.actual_effort_uom%TYPE := NULL
33: , sched_travel_distance jtf_task_assignments.sched_travel_distance%TYPE := NULL
34: , sched_travel_duration jtf_task_assignments.sched_travel_duration%TYPE := NULL
35: , sched_travel_duration_uom jtf_task_assignments.sched_travel_duration_uom%TYPE := NULL
36: , actual_travel_distance jtf_task_assignments.actual_travel_distance%TYPE := NULL
37: , actual_travel_duration jtf_task_assignments.actual_travel_duration%TYPE := NULL

Line 34: , sched_travel_duration jtf_task_assignments.sched_travel_duration%TYPE := NULL

30: , actual_end_date DATE := NULL
31: , actual_effort jtf_task_assignments.actual_effort%TYPE := NULL
32: , actual_effort_uom jtf_task_assignments.actual_effort_uom%TYPE := NULL
33: , sched_travel_distance jtf_task_assignments.sched_travel_distance%TYPE := NULL
34: , sched_travel_duration jtf_task_assignments.sched_travel_duration%TYPE := NULL
35: , sched_travel_duration_uom jtf_task_assignments.sched_travel_duration_uom%TYPE := NULL
36: , actual_travel_distance jtf_task_assignments.actual_travel_distance%TYPE := NULL
37: , actual_travel_duration jtf_task_assignments.actual_travel_duration%TYPE := NULL
38: , actual_travel_duration_uom jtf_task_assignments.actual_travel_duration_uom%TYPE := NULL

Line 35: , sched_travel_duration_uom jtf_task_assignments.sched_travel_duration_uom%TYPE := NULL

31: , actual_effort jtf_task_assignments.actual_effort%TYPE := NULL
32: , actual_effort_uom jtf_task_assignments.actual_effort_uom%TYPE := NULL
33: , sched_travel_distance jtf_task_assignments.sched_travel_distance%TYPE := NULL
34: , sched_travel_duration jtf_task_assignments.sched_travel_duration%TYPE := NULL
35: , sched_travel_duration_uom jtf_task_assignments.sched_travel_duration_uom%TYPE := NULL
36: , actual_travel_distance jtf_task_assignments.actual_travel_distance%TYPE := NULL
37: , actual_travel_duration jtf_task_assignments.actual_travel_duration%TYPE := NULL
38: , actual_travel_duration_uom jtf_task_assignments.actual_travel_duration_uom%TYPE := NULL
39: , schedule_flag jtf_task_assignments.schedule_flag%TYPE := NULL

Line 36: , actual_travel_distance jtf_task_assignments.actual_travel_distance%TYPE := NULL

32: , actual_effort_uom jtf_task_assignments.actual_effort_uom%TYPE := NULL
33: , sched_travel_distance jtf_task_assignments.sched_travel_distance%TYPE := NULL
34: , sched_travel_duration jtf_task_assignments.sched_travel_duration%TYPE := NULL
35: , sched_travel_duration_uom jtf_task_assignments.sched_travel_duration_uom%TYPE := NULL
36: , actual_travel_distance jtf_task_assignments.actual_travel_distance%TYPE := NULL
37: , actual_travel_duration jtf_task_assignments.actual_travel_duration%TYPE := NULL
38: , actual_travel_duration_uom jtf_task_assignments.actual_travel_duration_uom%TYPE := NULL
39: , schedule_flag jtf_task_assignments.schedule_flag%TYPE := NULL
40: , alarm_type_code jtf_task_assignments.alarm_type_code%TYPE := NULL

Line 37: , actual_travel_duration jtf_task_assignments.actual_travel_duration%TYPE := NULL

33: , sched_travel_distance jtf_task_assignments.sched_travel_distance%TYPE := NULL
34: , sched_travel_duration jtf_task_assignments.sched_travel_duration%TYPE := NULL
35: , sched_travel_duration_uom jtf_task_assignments.sched_travel_duration_uom%TYPE := NULL
36: , actual_travel_distance jtf_task_assignments.actual_travel_distance%TYPE := NULL
37: , actual_travel_duration jtf_task_assignments.actual_travel_duration%TYPE := NULL
38: , actual_travel_duration_uom jtf_task_assignments.actual_travel_duration_uom%TYPE := NULL
39: , schedule_flag jtf_task_assignments.schedule_flag%TYPE := NULL
40: , alarm_type_code jtf_task_assignments.alarm_type_code%TYPE := NULL
41: , alarm_contact jtf_task_assignments.alarm_contact%TYPE := NULL

Line 38: , actual_travel_duration_uom jtf_task_assignments.actual_travel_duration_uom%TYPE := NULL

34: , sched_travel_duration jtf_task_assignments.sched_travel_duration%TYPE := NULL
35: , sched_travel_duration_uom jtf_task_assignments.sched_travel_duration_uom%TYPE := NULL
36: , actual_travel_distance jtf_task_assignments.actual_travel_distance%TYPE := NULL
37: , actual_travel_duration jtf_task_assignments.actual_travel_duration%TYPE := NULL
38: , actual_travel_duration_uom jtf_task_assignments.actual_travel_duration_uom%TYPE := NULL
39: , schedule_flag jtf_task_assignments.schedule_flag%TYPE := NULL
40: , alarm_type_code jtf_task_assignments.alarm_type_code%TYPE := NULL
41: , alarm_contact jtf_task_assignments.alarm_contact%TYPE := NULL
42: , palm_flag jtf_task_assignments.palm_flag%TYPE := NULL

Line 39: , schedule_flag jtf_task_assignments.schedule_flag%TYPE := NULL

35: , sched_travel_duration_uom jtf_task_assignments.sched_travel_duration_uom%TYPE := NULL
36: , actual_travel_distance jtf_task_assignments.actual_travel_distance%TYPE := NULL
37: , actual_travel_duration jtf_task_assignments.actual_travel_duration%TYPE := NULL
38: , actual_travel_duration_uom jtf_task_assignments.actual_travel_duration_uom%TYPE := NULL
39: , schedule_flag jtf_task_assignments.schedule_flag%TYPE := NULL
40: , alarm_type_code jtf_task_assignments.alarm_type_code%TYPE := NULL
41: , alarm_contact jtf_task_assignments.alarm_contact%TYPE := NULL
42: , palm_flag jtf_task_assignments.palm_flag%TYPE := NULL
43: , wince_flag jtf_task_assignments.wince_flag%TYPE := NULL

Line 40: , alarm_type_code jtf_task_assignments.alarm_type_code%TYPE := NULL

36: , actual_travel_distance jtf_task_assignments.actual_travel_distance%TYPE := NULL
37: , actual_travel_duration jtf_task_assignments.actual_travel_duration%TYPE := NULL
38: , actual_travel_duration_uom jtf_task_assignments.actual_travel_duration_uom%TYPE := NULL
39: , schedule_flag jtf_task_assignments.schedule_flag%TYPE := NULL
40: , alarm_type_code jtf_task_assignments.alarm_type_code%TYPE := NULL
41: , alarm_contact jtf_task_assignments.alarm_contact%TYPE := NULL
42: , palm_flag jtf_task_assignments.palm_flag%TYPE := NULL
43: , wince_flag jtf_task_assignments.wince_flag%TYPE := NULL
44: , laptop_flag jtf_task_assignments.laptop_flag%TYPE := NULL

Line 41: , alarm_contact jtf_task_assignments.alarm_contact%TYPE := NULL

37: , actual_travel_duration jtf_task_assignments.actual_travel_duration%TYPE := NULL
38: , actual_travel_duration_uom jtf_task_assignments.actual_travel_duration_uom%TYPE := NULL
39: , schedule_flag jtf_task_assignments.schedule_flag%TYPE := NULL
40: , alarm_type_code jtf_task_assignments.alarm_type_code%TYPE := NULL
41: , alarm_contact jtf_task_assignments.alarm_contact%TYPE := NULL
42: , palm_flag jtf_task_assignments.palm_flag%TYPE := NULL
43: , wince_flag jtf_task_assignments.wince_flag%TYPE := NULL
44: , laptop_flag jtf_task_assignments.laptop_flag%TYPE := NULL
45: , device1_flag jtf_task_assignments.device1_flag%TYPE := NULL

Line 42: , palm_flag jtf_task_assignments.palm_flag%TYPE := NULL

38: , actual_travel_duration_uom jtf_task_assignments.actual_travel_duration_uom%TYPE := NULL
39: , schedule_flag jtf_task_assignments.schedule_flag%TYPE := NULL
40: , alarm_type_code jtf_task_assignments.alarm_type_code%TYPE := NULL
41: , alarm_contact jtf_task_assignments.alarm_contact%TYPE := NULL
42: , palm_flag jtf_task_assignments.palm_flag%TYPE := NULL
43: , wince_flag jtf_task_assignments.wince_flag%TYPE := NULL
44: , laptop_flag jtf_task_assignments.laptop_flag%TYPE := NULL
45: , device1_flag jtf_task_assignments.device1_flag%TYPE := NULL
46: , device2_flag jtf_task_assignments.device2_flag%TYPE := NULL

Line 43: , wince_flag jtf_task_assignments.wince_flag%TYPE := NULL

39: , schedule_flag jtf_task_assignments.schedule_flag%TYPE := NULL
40: , alarm_type_code jtf_task_assignments.alarm_type_code%TYPE := NULL
41: , alarm_contact jtf_task_assignments.alarm_contact%TYPE := NULL
42: , palm_flag jtf_task_assignments.palm_flag%TYPE := NULL
43: , wince_flag jtf_task_assignments.wince_flag%TYPE := NULL
44: , laptop_flag jtf_task_assignments.laptop_flag%TYPE := NULL
45: , device1_flag jtf_task_assignments.device1_flag%TYPE := NULL
46: , device2_flag jtf_task_assignments.device2_flag%TYPE := NULL
47: , device3_flag jtf_task_assignments.device3_flag%TYPE := NULL

Line 44: , laptop_flag jtf_task_assignments.laptop_flag%TYPE := NULL

40: , alarm_type_code jtf_task_assignments.alarm_type_code%TYPE := NULL
41: , alarm_contact jtf_task_assignments.alarm_contact%TYPE := NULL
42: , palm_flag jtf_task_assignments.palm_flag%TYPE := NULL
43: , wince_flag jtf_task_assignments.wince_flag%TYPE := NULL
44: , laptop_flag jtf_task_assignments.laptop_flag%TYPE := NULL
45: , device1_flag jtf_task_assignments.device1_flag%TYPE := NULL
46: , device2_flag jtf_task_assignments.device2_flag%TYPE := NULL
47: , device3_flag jtf_task_assignments.device3_flag%TYPE := NULL
48: , resource_territory_id jtf_task_assignments.resource_territory_id%TYPE := NULL

Line 45: , device1_flag jtf_task_assignments.device1_flag%TYPE := NULL

41: , alarm_contact jtf_task_assignments.alarm_contact%TYPE := NULL
42: , palm_flag jtf_task_assignments.palm_flag%TYPE := NULL
43: , wince_flag jtf_task_assignments.wince_flag%TYPE := NULL
44: , laptop_flag jtf_task_assignments.laptop_flag%TYPE := NULL
45: , device1_flag jtf_task_assignments.device1_flag%TYPE := NULL
46: , device2_flag jtf_task_assignments.device2_flag%TYPE := NULL
47: , device3_flag jtf_task_assignments.device3_flag%TYPE := NULL
48: , resource_territory_id jtf_task_assignments.resource_territory_id%TYPE := NULL
49: , assignment_status_id jtf_task_assignments.assignment_status_id%TYPE := NULL

Line 46: , device2_flag jtf_task_assignments.device2_flag%TYPE := NULL

42: , palm_flag jtf_task_assignments.palm_flag%TYPE := NULL
43: , wince_flag jtf_task_assignments.wince_flag%TYPE := NULL
44: , laptop_flag jtf_task_assignments.laptop_flag%TYPE := NULL
45: , device1_flag jtf_task_assignments.device1_flag%TYPE := NULL
46: , device2_flag jtf_task_assignments.device2_flag%TYPE := NULL
47: , device3_flag jtf_task_assignments.device3_flag%TYPE := NULL
48: , resource_territory_id jtf_task_assignments.resource_territory_id%TYPE := NULL
49: , assignment_status_id jtf_task_assignments.assignment_status_id%TYPE := NULL
50: , shift_construct_id jtf_task_assignments.shift_construct_id%TYPE := NULL

Line 47: , device3_flag jtf_task_assignments.device3_flag%TYPE := NULL

43: , wince_flag jtf_task_assignments.wince_flag%TYPE := NULL
44: , laptop_flag jtf_task_assignments.laptop_flag%TYPE := NULL
45: , device1_flag jtf_task_assignments.device1_flag%TYPE := NULL
46: , device2_flag jtf_task_assignments.device2_flag%TYPE := NULL
47: , device3_flag jtf_task_assignments.device3_flag%TYPE := NULL
48: , resource_territory_id jtf_task_assignments.resource_territory_id%TYPE := NULL
49: , assignment_status_id jtf_task_assignments.assignment_status_id%TYPE := NULL
50: , shift_construct_id jtf_task_assignments.shift_construct_id%TYPE := NULL
51: , show_on_calendar jtf_task_assignments.show_on_calendar%TYPE := NULL

Line 48: , resource_territory_id jtf_task_assignments.resource_territory_id%TYPE := NULL

44: , laptop_flag jtf_task_assignments.laptop_flag%TYPE := NULL
45: , device1_flag jtf_task_assignments.device1_flag%TYPE := NULL
46: , device2_flag jtf_task_assignments.device2_flag%TYPE := NULL
47: , device3_flag jtf_task_assignments.device3_flag%TYPE := NULL
48: , resource_territory_id jtf_task_assignments.resource_territory_id%TYPE := NULL
49: , assignment_status_id jtf_task_assignments.assignment_status_id%TYPE := NULL
50: , shift_construct_id jtf_task_assignments.shift_construct_id%TYPE := NULL
51: , show_on_calendar jtf_task_assignments.show_on_calendar%TYPE := NULL
52: , category_id jtf_task_assignments.category_id%TYPE := NULL

Line 49: , assignment_status_id jtf_task_assignments.assignment_status_id%TYPE := NULL

45: , device1_flag jtf_task_assignments.device1_flag%TYPE := NULL
46: , device2_flag jtf_task_assignments.device2_flag%TYPE := NULL
47: , device3_flag jtf_task_assignments.device3_flag%TYPE := NULL
48: , resource_territory_id jtf_task_assignments.resource_territory_id%TYPE := NULL
49: , assignment_status_id jtf_task_assignments.assignment_status_id%TYPE := NULL
50: , shift_construct_id jtf_task_assignments.shift_construct_id%TYPE := NULL
51: , show_on_calendar jtf_task_assignments.show_on_calendar%TYPE := NULL
52: , category_id jtf_task_assignments.category_id%TYPE := NULL
53: );

Line 50: , shift_construct_id jtf_task_assignments.shift_construct_id%TYPE := NULL

46: , device2_flag jtf_task_assignments.device2_flag%TYPE := NULL
47: , device3_flag jtf_task_assignments.device3_flag%TYPE := NULL
48: , resource_territory_id jtf_task_assignments.resource_territory_id%TYPE := NULL
49: , assignment_status_id jtf_task_assignments.assignment_status_id%TYPE := NULL
50: , shift_construct_id jtf_task_assignments.shift_construct_id%TYPE := NULL
51: , show_on_calendar jtf_task_assignments.show_on_calendar%TYPE := NULL
52: , category_id jtf_task_assignments.category_id%TYPE := NULL
53: );
54:

Line 51: , show_on_calendar jtf_task_assignments.show_on_calendar%TYPE := NULL

47: , device3_flag jtf_task_assignments.device3_flag%TYPE := NULL
48: , resource_territory_id jtf_task_assignments.resource_territory_id%TYPE := NULL
49: , assignment_status_id jtf_task_assignments.assignment_status_id%TYPE := NULL
50: , shift_construct_id jtf_task_assignments.shift_construct_id%TYPE := NULL
51: , show_on_calendar jtf_task_assignments.show_on_calendar%TYPE := NULL
52: , category_id jtf_task_assignments.category_id%TYPE := NULL
53: );
54:
55: TYPE task_assign_tbl IS TABLE OF task_assign_rec

Line 52: , category_id jtf_task_assignments.category_id%TYPE := NULL

48: , resource_territory_id jtf_task_assignments.resource_territory_id%TYPE := NULL
49: , assignment_status_id jtf_task_assignments.assignment_status_id%TYPE := NULL
50: , shift_construct_id jtf_task_assignments.shift_construct_id%TYPE := NULL
51: , show_on_calendar jtf_task_assignments.show_on_calendar%TYPE := NULL
52: , category_id jtf_task_assignments.category_id%TYPE := NULL
53: );
54:
55: TYPE task_assign_tbl IS TABLE OF task_assign_rec
56: INDEX BY BINARY_INTEGER;