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