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.CSF_PLANBOARD_TASKS dependencies on JTF_NUMBER_TABLE

Line 156: task_id jtf_number_table;

152: l_depend_flag varchar2(2);
153: l_notes_flag varchar2(2);
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;

Line 157: real_task_id jtf_number_table;

153: l_notes_flag varchar2(2);
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;

Line 159: task_type_id jtf_number_table;

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;
163: source_object_name jtf_varchar2_table_100;

Line 160: trip_task_indicator jtf_number_table;

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;
163: source_object_name jtf_varchar2_table_100;
164: source_object_id jtf_number_table;

Line 161: task_priority_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;
163: source_object_name jtf_varchar2_table_100;
164: source_object_id jtf_number_table;
165: planned_start_date jtf_date_table;

Line 164: source_object_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;
168: scheduled_end_date jtf_date_table;

Line 170: parent_task_id jtf_number_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;
174: actual_end_date jtf_date_table;

Line 172: assignment_status_id jtf_number_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;
176: customer jtf_varchar2_table_400;

Line 180: escalated jtf_number_table;

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

Line 181: actual_effort jtf_number_table;

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;
184: resource_type jtf_varchar2_table_100;
185: resource_name jtf_varchar2_table_2000;

Line 182: planned_effort jtf_number_table;

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;
184: resource_type jtf_varchar2_table_100;
185: resource_name jtf_varchar2_table_2000;
186: status_schedulable_flag jtf_varchar2_table_100;

Line 183: resource_id jtf_number_table;

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

Line 188: trip_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;
192: l_prev_resource_type VARCHAR2(30);

Line 400: FROM TABLE(CAST(trip_id AS jtf_NUMBER_table))

396: CURSOR c_trip_status IS
397: SELECT object_capacity_id,status
398: FROM cac_sr_object_capacity
399: WHERE object_capacity_id in (select DISTINCT column_value
400: FROM TABLE(CAST(trip_id AS jtf_NUMBER_table))
401: where column_value <> 0);
402: i BINARY_INTEGER := 0;
403: BEGIN
404: IF g_trip_tbl.COUNT = 0

Line 423: FROM TABLE(CAST(real_task_id AS jtf_NUMBER_table))

419: , NVL(accesshour_required, 'N') access_flag
420: , NVL(after_hours_flag, 'N') after_flag
421: FROM csf_access_hours_b
422: WHERE task_id in (select DISTINCT column_value
423: FROM TABLE(CAST(real_task_id AS jtf_NUMBER_table))
424: where column_value <> 0);
425: i BINARY_INTEGER := 0;
426: BEGIN
427: IF g_access_tbl.COUNT = 0

Line 445: FROM TABLE(CAST(real_task_id AS jtf_NUMBER_table))

441: CURSOR c_parts_status IS
442: SELECT task_id
443: FROM csp_requirement_headers
444: WHERE task_id in (select DISTINCT column_value
445: FROM TABLE(CAST(real_task_id AS jtf_NUMBER_table))
446: where column_value <> 0);
447: i BINARY_INTEGER := 0;
448: BEGIN
449: IF g_parts_tbl.COUNT = 0

Line 523: task_id := jtf_number_table();

519: l_real_task_cnt := 0;
520: l_task_custom_color := 'N';
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();

Line 524: real_task_id := jtf_number_table();

520: l_task_custom_color := 'N';
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();

Line 526: task_type_id := jtf_number_table();

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();
530: source_object_name := jtf_varchar2_table_100();

Line 527: trip_task_indicator := jtf_number_table();

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();
530: source_object_name := jtf_varchar2_table_100();
531: source_object_id := jtf_number_table();

Line 528: task_priority_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();
530: source_object_name := jtf_varchar2_table_100();
531: source_object_id := jtf_number_table();
532: planned_start_date := jtf_date_table();

Line 531: source_object_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();
535: scheduled_end_date := jtf_date_table();

Line 537: parent_task_id := jtf_number_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();
541: actual_end_date := jtf_date_table();

Line 539: assignment_status_id := jtf_number_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();
543: customer := jtf_varchar2_table_400();

Line 547: escalated := jtf_number_table();

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

Line 548: actual_effort := jtf_number_table();

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();
551: resource_type := jtf_varchar2_table_100();
552: resource_name := jtf_varchar2_table_2000();

Line 549: planned_effort := jtf_number_table();

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();
551: resource_type := jtf_varchar2_table_100();
552: resource_name := jtf_varchar2_table_2000();
553: status_schedulable_flag := jtf_varchar2_table_100();

Line 550: resource_id := jtf_number_table();

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

Line 555: trip_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;
559: FETCH c_res

Line 577: resource_id := jtf_number_table();

573: l_pr.resource_name := resource_name(i);
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;