DBA Data[Home] [Help]

APPS.CSF_PLANBOARD_TASKS dependencies on JTF_VARCHAR2_TABLE_100

Line 158: task_number jtf_varchar2_table_100;

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;

Line 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;

Line 163: source_object_name 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;
167: scheduled_start_date jtf_date_table;

Line 169: task_confirmation_status jtf_varchar2_table_100;

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;

Line 171: task_split_flag jtf_varchar2_table_100;

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;

Line 178: type_name jtf_varchar2_table_100;

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;

Line 179: assignment_status jtf_varchar2_table_100;

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;

Line 184: resource_type 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;
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;

Line 186: status_schedulable_flag jtf_varchar2_table_100;

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:

Line 187: type_schedulable_flag jtf_varchar2_table_100;

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;

Line 525: task_number := jtf_varchar2_table_100();

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

Line 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();

Line 530: source_object_name := 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();
534: scheduled_start_date := jtf_date_table();

Line 536: task_confirmation_status := jtf_varchar2_table_100();

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

Line 538: task_split_flag := jtf_varchar2_table_100();

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

Line 545: type_name := jtf_varchar2_table_100();

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

Line 546: assignment_status := jtf_varchar2_table_100();

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

Line 551: resource_type := 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();
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();

Line 553: status_schedulable_flag := jtf_varchar2_table_100();

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:

Line 554: type_schedulable_flag := jtf_varchar2_table_100();

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;

Line 578: resource_type := jtf_varchar2_table_100();

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