154:
155:
156: task_id jtf_number_table;
157: real_task_id jtf_number_table;
158: task_number jtf_varchar2_table_100;
159: task_type_id jtf_number_table;
160: trip_task_indicator jtf_number_table;
161: task_priority_id jtf_number_table;
162: source_object_type_code jtf_varchar2_table_100;
158: task_number jtf_varchar2_table_100;
159: task_type_id jtf_number_table;
160: trip_task_indicator jtf_number_table;
161: task_priority_id jtf_number_table;
162: source_object_type_code jtf_varchar2_table_100;
163: source_object_name jtf_varchar2_table_100;
164: source_object_id jtf_number_table;
165: planned_start_date jtf_date_table;
166: planned_end_date jtf_date_table;
159: task_type_id jtf_number_table;
160: trip_task_indicator jtf_number_table;
161: task_priority_id jtf_number_table;
162: source_object_type_code jtf_varchar2_table_100;
163: source_object_name jtf_varchar2_table_100;
164: source_object_id jtf_number_table;
165: planned_start_date jtf_date_table;
166: planned_end_date jtf_date_table;
167: scheduled_start_date jtf_date_table;
165: planned_start_date jtf_date_table;
166: planned_end_date jtf_date_table;
167: scheduled_start_date jtf_date_table;
168: scheduled_end_date jtf_date_table;
169: task_confirmation_status jtf_varchar2_table_100;
170: parent_task_id jtf_number_table;
171: task_split_flag jtf_varchar2_table_100;
172: assignment_status_id jtf_number_table;
173: actual_start_date jtf_date_table;
167: scheduled_start_date jtf_date_table;
168: scheduled_end_date jtf_date_table;
169: task_confirmation_status jtf_varchar2_table_100;
170: parent_task_id jtf_number_table;
171: task_split_flag jtf_varchar2_table_100;
172: assignment_status_id jtf_number_table;
173: actual_start_date jtf_date_table;
174: actual_end_date jtf_date_table;
175: city jtf_varchar2_table_2000;
174: actual_end_date jtf_date_table;
175: city jtf_varchar2_table_2000;
176: customer jtf_varchar2_table_400;
177: contract jtf_varchar2_table_400;
178: type_name jtf_varchar2_table_100;
179: assignment_status jtf_varchar2_table_100;
180: escalated jtf_number_table;
181: actual_effort jtf_number_table;
182: planned_effort jtf_number_table;
175: city jtf_varchar2_table_2000;
176: customer jtf_varchar2_table_400;
177: contract jtf_varchar2_table_400;
178: type_name jtf_varchar2_table_100;
179: assignment_status jtf_varchar2_table_100;
180: escalated jtf_number_table;
181: actual_effort jtf_number_table;
182: planned_effort jtf_number_table;
183: resource_id jtf_number_table;
180: escalated jtf_number_table;
181: actual_effort jtf_number_table;
182: planned_effort jtf_number_table;
183: resource_id jtf_number_table;
184: resource_type jtf_varchar2_table_100;
185: resource_name jtf_varchar2_table_2000;
186: status_schedulable_flag jtf_varchar2_table_100;
187: type_schedulable_flag jtf_varchar2_table_100;
188: trip_id jtf_number_table;
182: planned_effort jtf_number_table;
183: resource_id jtf_number_table;
184: resource_type jtf_varchar2_table_100;
185: resource_name jtf_varchar2_table_2000;
186: status_schedulable_flag jtf_varchar2_table_100;
187: type_schedulable_flag jtf_varchar2_table_100;
188: trip_id jtf_number_table;
189:
190:
183: resource_id jtf_number_table;
184: resource_type jtf_varchar2_table_100;
185: resource_name jtf_varchar2_table_2000;
186: status_schedulable_flag jtf_varchar2_table_100;
187: type_schedulable_flag jtf_varchar2_table_100;
188: trip_id jtf_number_table;
189:
190:
191: l_prev_resource_id NUMBER;
521: k :=0;
522: m :=0;
523: task_id := jtf_number_table();
524: real_task_id := jtf_number_table();
525: task_number := jtf_varchar2_table_100();
526: task_type_id := jtf_number_table();
527: trip_task_indicator := jtf_number_table();
528: task_priority_id := jtf_number_table();
529: source_object_type_code := jtf_varchar2_table_100();
525: task_number := jtf_varchar2_table_100();
526: task_type_id := jtf_number_table();
527: trip_task_indicator := jtf_number_table();
528: task_priority_id := jtf_number_table();
529: source_object_type_code := jtf_varchar2_table_100();
530: source_object_name := jtf_varchar2_table_100();
531: source_object_id := jtf_number_table();
532: planned_start_date := jtf_date_table();
533: planned_end_date := jtf_date_table();
526: task_type_id := jtf_number_table();
527: trip_task_indicator := jtf_number_table();
528: task_priority_id := jtf_number_table();
529: source_object_type_code := jtf_varchar2_table_100();
530: source_object_name := jtf_varchar2_table_100();
531: source_object_id := jtf_number_table();
532: planned_start_date := jtf_date_table();
533: planned_end_date := jtf_date_table();
534: scheduled_start_date := jtf_date_table();
532: planned_start_date := jtf_date_table();
533: planned_end_date := jtf_date_table();
534: scheduled_start_date := jtf_date_table();
535: scheduled_end_date := jtf_date_table();
536: task_confirmation_status := jtf_varchar2_table_100();
537: parent_task_id := jtf_number_table();
538: task_split_flag := jtf_varchar2_table_100();
539: assignment_status_id := jtf_number_table();
540: actual_start_date := jtf_date_table();
534: scheduled_start_date := jtf_date_table();
535: scheduled_end_date := jtf_date_table();
536: task_confirmation_status := jtf_varchar2_table_100();
537: parent_task_id := jtf_number_table();
538: task_split_flag := jtf_varchar2_table_100();
539: assignment_status_id := jtf_number_table();
540: actual_start_date := jtf_date_table();
541: actual_end_date := jtf_date_table();
542: city := jtf_varchar2_table_2000();
541: actual_end_date := jtf_date_table();
542: city := jtf_varchar2_table_2000();
543: customer := jtf_varchar2_table_400();
544: contract := jtf_varchar2_table_400();
545: type_name := jtf_varchar2_table_100();
546: assignment_status := jtf_varchar2_table_100();
547: escalated := jtf_number_table();
548: actual_effort := jtf_number_table();
549: planned_effort := jtf_number_table();
542: city := jtf_varchar2_table_2000();
543: customer := jtf_varchar2_table_400();
544: contract := jtf_varchar2_table_400();
545: type_name := jtf_varchar2_table_100();
546: assignment_status := jtf_varchar2_table_100();
547: escalated := jtf_number_table();
548: actual_effort := jtf_number_table();
549: planned_effort := jtf_number_table();
550: resource_id := jtf_number_table();
547: escalated := jtf_number_table();
548: actual_effort := jtf_number_table();
549: planned_effort := jtf_number_table();
550: resource_id := jtf_number_table();
551: resource_type := jtf_varchar2_table_100();
552: resource_name := jtf_varchar2_table_2000();
553: status_schedulable_flag := jtf_varchar2_table_100();
554: type_schedulable_flag := jtf_varchar2_table_100();
555: trip_id := jtf_number_table();
549: planned_effort := jtf_number_table();
550: resource_id := jtf_number_table();
551: resource_type := jtf_varchar2_table_100();
552: resource_name := jtf_varchar2_table_2000();
553: status_schedulable_flag := jtf_varchar2_table_100();
554: type_schedulable_flag := jtf_varchar2_table_100();
555: trip_id := jtf_number_table();
556:
557:
550: resource_id := jtf_number_table();
551: resource_type := jtf_varchar2_table_100();
552: resource_name := jtf_varchar2_table_2000();
553: status_schedulable_flag := jtf_varchar2_table_100();
554: type_schedulable_flag := jtf_varchar2_table_100();
555: trip_id := jtf_number_table();
556:
557:
558: OPEN c_res;
574: x_pb_tbl(k) := l_pr;
575: l_res_id_map_tbl(l_pr.resource_id||l_pr.resource_type) := k;
576: END LOOP;
577: resource_id := jtf_number_table();
578: resource_type := jtf_varchar2_table_100();
579: resource_name := jtf_varchar2_table_2000();
580:
581: OPEN c_task;
582: FETCH c_task