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_VARCHAR2_TABLE_100

Line 160: task_number jtf_varchar2_table_100;

156:
157:
158: task_id jtf_number_table;
159: real_task_id jtf_number_table;
160: task_number jtf_varchar2_table_100;
161: task_type_id jtf_number_table;
162: trip_task_indicator jtf_number_table;
163: task_priority_id jtf_number_table;
164: source_object_type_code jtf_varchar2_table_100;

Line 164: source_object_type_code jtf_varchar2_table_100;

160: task_number jtf_varchar2_table_100;
161: task_type_id jtf_number_table;
162: trip_task_indicator jtf_number_table;
163: task_priority_id jtf_number_table;
164: source_object_type_code jtf_varchar2_table_100;
165: source_object_name jtf_varchar2_table_100;
166: source_object_id jtf_number_table;
167: planned_start_date jtf_date_table;
168: planned_end_date jtf_date_table;

Line 165: source_object_name jtf_varchar2_table_100;

161: task_type_id jtf_number_table;
162: trip_task_indicator jtf_number_table;
163: task_priority_id jtf_number_table;
164: source_object_type_code jtf_varchar2_table_100;
165: source_object_name jtf_varchar2_table_100;
166: source_object_id jtf_number_table;
167: planned_start_date jtf_date_table;
168: planned_end_date jtf_date_table;
169: scheduled_start_date jtf_date_table;

Line 171: task_confirmation_status jtf_varchar2_table_100;

167: planned_start_date jtf_date_table;
168: planned_end_date jtf_date_table;
169: scheduled_start_date jtf_date_table;
170: scheduled_end_date jtf_date_table;
171: task_confirmation_status jtf_varchar2_table_100;
172: parent_task_id jtf_number_table;
173: task_split_flag jtf_varchar2_table_100;
174: assignment_status_id jtf_number_table;
175: actual_start_date jtf_date_table;

Line 173: task_split_flag jtf_varchar2_table_100;

169: scheduled_start_date jtf_date_table;
170: scheduled_end_date jtf_date_table;
171: task_confirmation_status jtf_varchar2_table_100;
172: parent_task_id jtf_number_table;
173: task_split_flag jtf_varchar2_table_100;
174: assignment_status_id jtf_number_table;
175: actual_start_date jtf_date_table;
176: actual_end_date jtf_date_table;
177: city jtf_varchar2_table_2000;

Line 180: type_name jtf_varchar2_table_100;

176: actual_end_date jtf_date_table;
177: city jtf_varchar2_table_2000;
178: customer jtf_varchar2_table_400;
179: contract jtf_varchar2_table_400;
180: type_name jtf_varchar2_table_100;
181: assignment_status jtf_varchar2_table_100;
182: escalated jtf_number_table;
183: actual_effort jtf_number_table;
184: planned_effort jtf_number_table;

Line 181: assignment_status jtf_varchar2_table_100;

177: city jtf_varchar2_table_2000;
178: customer jtf_varchar2_table_400;
179: contract jtf_varchar2_table_400;
180: type_name jtf_varchar2_table_100;
181: assignment_status jtf_varchar2_table_100;
182: escalated jtf_number_table;
183: actual_effort jtf_number_table;
184: planned_effort jtf_number_table;
185: resource_id jtf_number_table;

Line 186: resource_type jtf_varchar2_table_100;

182: escalated jtf_number_table;
183: actual_effort jtf_number_table;
184: planned_effort jtf_number_table;
185: resource_id jtf_number_table;
186: resource_type jtf_varchar2_table_100;
187: resource_name jtf_varchar2_table_2000;
188: status_schedulable_flag jtf_varchar2_table_100;
189: type_schedulable_flag jtf_varchar2_table_100;
190: trip_id jtf_number_table;

Line 188: status_schedulable_flag jtf_varchar2_table_100;

184: planned_effort jtf_number_table;
185: resource_id jtf_number_table;
186: resource_type jtf_varchar2_table_100;
187: resource_name jtf_varchar2_table_2000;
188: status_schedulable_flag jtf_varchar2_table_100;
189: type_schedulable_flag jtf_varchar2_table_100;
190: trip_id jtf_number_table;
191: l_avail_type jtf_varchar2_table_100;
192: l_assign_id jtf_number_table;

Line 189: type_schedulable_flag jtf_varchar2_table_100;

185: resource_id jtf_number_table;
186: resource_type jtf_varchar2_table_100;
187: resource_name jtf_varchar2_table_2000;
188: status_schedulable_flag jtf_varchar2_table_100;
189: type_schedulable_flag jtf_varchar2_table_100;
190: trip_id jtf_number_table;
191: l_avail_type jtf_varchar2_table_100;
192: l_assign_id jtf_number_table;
193:

Line 191: l_avail_type jtf_varchar2_table_100;

187: resource_name jtf_varchar2_table_2000;
188: status_schedulable_flag jtf_varchar2_table_100;
189: type_schedulable_flag jtf_varchar2_table_100;
190: trip_id jtf_number_table;
191: l_avail_type jtf_varchar2_table_100;
192: l_assign_id jtf_number_table;
193:
194: l_prev_resource_id NUMBER;
195: l_prev_resource_type VARCHAR2(30);

Line 751: task_number := jtf_varchar2_table_100();

747: k :=0;
748: m :=0;
749: task_id := jtf_number_table();
750: real_task_id := jtf_number_table();
751: task_number := jtf_varchar2_table_100();
752: task_type_id := jtf_number_table();
753: trip_task_indicator := jtf_number_table();
754: task_priority_id := jtf_number_table();
755: source_object_type_code := jtf_varchar2_table_100();

Line 755: source_object_type_code := jtf_varchar2_table_100();

751: task_number := jtf_varchar2_table_100();
752: task_type_id := jtf_number_table();
753: trip_task_indicator := jtf_number_table();
754: task_priority_id := jtf_number_table();
755: source_object_type_code := jtf_varchar2_table_100();
756: source_object_name := jtf_varchar2_table_100();
757: source_object_id := jtf_number_table();
758: planned_start_date := jtf_date_table();
759: planned_end_date := jtf_date_table();

Line 756: source_object_name := jtf_varchar2_table_100();

752: task_type_id := jtf_number_table();
753: trip_task_indicator := jtf_number_table();
754: task_priority_id := jtf_number_table();
755: source_object_type_code := jtf_varchar2_table_100();
756: source_object_name := jtf_varchar2_table_100();
757: source_object_id := jtf_number_table();
758: planned_start_date := jtf_date_table();
759: planned_end_date := jtf_date_table();
760: scheduled_start_date := jtf_date_table();

Line 762: task_confirmation_status := jtf_varchar2_table_100();

758: planned_start_date := jtf_date_table();
759: planned_end_date := jtf_date_table();
760: scheduled_start_date := jtf_date_table();
761: scheduled_end_date := jtf_date_table();
762: task_confirmation_status := jtf_varchar2_table_100();
763: parent_task_id := jtf_number_table();
764: task_split_flag := jtf_varchar2_table_100();
765: assignment_status_id := jtf_number_table();
766: actual_start_date := jtf_date_table();

Line 764: task_split_flag := jtf_varchar2_table_100();

760: scheduled_start_date := jtf_date_table();
761: scheduled_end_date := jtf_date_table();
762: task_confirmation_status := jtf_varchar2_table_100();
763: parent_task_id := jtf_number_table();
764: task_split_flag := jtf_varchar2_table_100();
765: assignment_status_id := jtf_number_table();
766: actual_start_date := jtf_date_table();
767: actual_end_date := jtf_date_table();
768: city := jtf_varchar2_table_2000();

Line 771: type_name := jtf_varchar2_table_100();

767: actual_end_date := jtf_date_table();
768: city := jtf_varchar2_table_2000();
769: customer := jtf_varchar2_table_400();
770: contract := jtf_varchar2_table_400();
771: type_name := jtf_varchar2_table_100();
772: assignment_status := jtf_varchar2_table_100();
773: escalated := jtf_number_table();
774: actual_effort := jtf_number_table();
775: planned_effort := jtf_number_table();

Line 772: assignment_status := jtf_varchar2_table_100();

768: city := jtf_varchar2_table_2000();
769: customer := jtf_varchar2_table_400();
770: contract := jtf_varchar2_table_400();
771: type_name := jtf_varchar2_table_100();
772: assignment_status := jtf_varchar2_table_100();
773: escalated := jtf_number_table();
774: actual_effort := jtf_number_table();
775: planned_effort := jtf_number_table();
776: resource_id := jtf_number_table();

Line 777: resource_type := jtf_varchar2_table_100();

773: escalated := jtf_number_table();
774: actual_effort := jtf_number_table();
775: planned_effort := jtf_number_table();
776: resource_id := jtf_number_table();
777: resource_type := jtf_varchar2_table_100();
778: resource_name := jtf_varchar2_table_2000();
779: status_schedulable_flag := jtf_varchar2_table_100();
780: type_schedulable_flag := jtf_varchar2_table_100();
781: trip_id := jtf_number_table();

Line 779: status_schedulable_flag := jtf_varchar2_table_100();

775: planned_effort := jtf_number_table();
776: resource_id := jtf_number_table();
777: resource_type := jtf_varchar2_table_100();
778: resource_name := jtf_varchar2_table_2000();
779: status_schedulable_flag := jtf_varchar2_table_100();
780: type_schedulable_flag := jtf_varchar2_table_100();
781: trip_id := jtf_number_table();
782: l_avail_type := jtf_varchar2_table_100();
783: l_assign_id := jtf_number_table();

Line 780: type_schedulable_flag := jtf_varchar2_table_100();

776: resource_id := jtf_number_table();
777: resource_type := jtf_varchar2_table_100();
778: resource_name := jtf_varchar2_table_2000();
779: status_schedulable_flag := jtf_varchar2_table_100();
780: type_schedulable_flag := jtf_varchar2_table_100();
781: trip_id := jtf_number_table();
782: l_avail_type := jtf_varchar2_table_100();
783: l_assign_id := jtf_number_table();
784:

Line 782: l_avail_type := jtf_varchar2_table_100();

778: resource_name := jtf_varchar2_table_2000();
779: status_schedulable_flag := jtf_varchar2_table_100();
780: type_schedulable_flag := jtf_varchar2_table_100();
781: trip_id := jtf_number_table();
782: l_avail_type := jtf_varchar2_table_100();
783: l_assign_id := jtf_number_table();
784:
785:
786: -- fetch resources

Line 816: resource_type := jtf_varchar2_table_100();

812: x_pb_tbl(k) := l_pr;
813: l_res_id_map_tbl(l_pr.resource_id||l_pr.resource_type) := k;
814: END LOOP;
815: resource_id := jtf_number_table();
816: resource_type := jtf_varchar2_table_100();
817: resource_name := jtf_varchar2_table_2000();
818:
819: --if p_shift_reg is null and p_shift_std is null
820: --then