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_GANTT_DATA_PKG dependencies on JTF_VARCHAR2_TABLE_100

Line 148: , p_vir_task_id OUT NOCOPY jtf_varchar2_table_100

144: , p_shift_start_date OUT NOCOPY jtf_date_table
145: , p_shift_end_date OUT NOCOPY jtf_date_table
146: , p_block_trip OUT NOCOPY jtf_number_table
147: , p_shift_res_key OUT NOCOPY jtf_varchar2_table_2000
148: , p_vir_task_id OUT NOCOPY jtf_varchar2_table_100
149: , p_vir_start_date OUT NOCOPY jtf_date_table
150: , p_vir_end_date OUT NOCOPY jtf_date_table
151: , p_vir_color OUT NOCOPY jtf_number_table
152: , p_vir_name OUT NOCOPY jtf_varchar2_table_100

Line 152: , p_vir_name OUT NOCOPY jtf_varchar2_table_100

148: , p_vir_task_id OUT NOCOPY jtf_varchar2_table_100
149: , p_vir_start_date OUT NOCOPY jtf_date_table
150: , p_vir_end_date OUT NOCOPY jtf_date_table
151: , p_vir_color OUT NOCOPY jtf_number_table
152: , p_vir_name OUT NOCOPY jtf_varchar2_table_100
153: , p_vir_duration OUT NOCOPY jtf_number_table
154: , p_vir_task_type_id OUT NOCOPY jtf_number_table
155: , p_vir_tooltip OUT NOCOPY jtf_varchar2_table_2000
156: , p_vir_resource_key OUT NOCOPY jtf_varchar2_table_2000

Line 157: , real_task_id OUT NOCOPY jtf_varchar2_table_100

153: , p_vir_duration OUT NOCOPY jtf_number_table
154: , p_vir_task_type_id OUT NOCOPY jtf_number_table
155: , p_vir_tooltip OUT NOCOPY jtf_varchar2_table_2000
156: , p_vir_resource_key OUT NOCOPY jtf_varchar2_table_2000
157: , real_task_id OUT NOCOPY jtf_varchar2_table_100
158: , real_start_date OUT NOCOPY jtf_date_table
159: , real_end_date OUT NOCOPY jtf_date_table
160: , real_color OUT NOCOPY jtf_number_table
161: , real_NAME OUT NOCOPY jtf_varchar2_table_2000

Line 166: , real_parts_required OUT NOCOPY jtf_varchar2_table_100

162: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000
163: , real_DURATION OUT NOCOPY jtf_number_table
164: , real_task_type_id OUT NOCOPY jtf_number_table
165: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
166: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
167: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
168: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
169: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
170: , real_task_depend OUT NOCOPY jtf_varchar2_table_100

Line 167: , real_access_hours OUT NOCOPY jtf_varchar2_table_100

163: , real_DURATION OUT NOCOPY jtf_number_table
164: , real_task_type_id OUT NOCOPY jtf_number_table
165: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
166: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
167: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
168: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
169: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
170: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
171: , real_child_task OUT NOCOPY jtf_varchar2_table_100

Line 168: , real_after_hours OUT NOCOPY jtf_varchar2_table_100

164: , real_task_type_id OUT NOCOPY jtf_number_table
165: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
166: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
167: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
168: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
169: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
170: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
171: , real_child_task OUT NOCOPY jtf_varchar2_table_100
172: , p_show_arr_dep_tasks IN varchar2 DEFAULT 'N');

Line 169: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100

165: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
166: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
167: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
168: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
169: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
170: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
171: , real_child_task OUT NOCOPY jtf_varchar2_table_100
172: , p_show_arr_dep_tasks IN varchar2 DEFAULT 'N');
173:

Line 170: , real_task_depend OUT NOCOPY jtf_varchar2_table_100

166: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
167: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
168: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
169: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
170: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
171: , real_child_task OUT NOCOPY jtf_varchar2_table_100
172: , p_show_arr_dep_tasks IN varchar2 DEFAULT 'N');
173:
174: PROCEDURE get_schedule_advise_options

Line 171: , real_child_task OUT NOCOPY jtf_varchar2_table_100

167: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
168: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
169: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
170: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
171: , real_child_task OUT NOCOPY jtf_varchar2_table_100
172: , p_show_arr_dep_tasks IN varchar2 DEFAULT 'N');
173:
174: PROCEDURE get_schedule_advise_options
175: (

Line 202: , plan_task_key OUT NOCOPY jtf_varchar2_table_100

198: , start_date OUT NOCOPY jtf_date_table
199: , end_date OUT NOCOPY jtf_date_table
200: , block_trip OUT NOCOPY jtf_number_table
201: , p_bck_res_key OUT NOCOPY jtf_varchar2_table_2000
202: , plan_task_key OUT NOCOPY jtf_varchar2_table_100
203: , plan_start_date OUT NOCOPY jtf_date_table
204: , plan_end_date OUT NOCOPY jtf_date_table
205: , plan_color OUT NOCOPY jtf_number_table
206: , plan_name OUT NOCOPY jtf_varchar2_table_2000

Line 211: , real_task_key OUT NOCOPY jtf_varchar2_table_100

207: , plan_tooltip OUT NOCOPY jtf_varchar2_table_2000
208: , plan_duration OUT NOCOPY jtf_number_table
209: , plan_task_type_id OUT NOCOPY jtf_number_table
210: , plan_resource_key OUT NOCOPY jtf_varchar2_table_2000
211: , real_task_key OUT NOCOPY jtf_varchar2_table_100
212: , real_start_date OUT NOCOPY jtf_date_table
213: , real_end_date OUT NOCOPY jtf_date_table
214: , real_color OUT NOCOPY jtf_number_table
215: , real_name OUT NOCOPY jtf_varchar2_table_2000

Line 220: , child_task OUT Nocopy jtf_varchar2_table_100

216: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000
217: , real_duration OUT NOCOPY jtf_number_table
218: , real_task_type_id OUT NOCOPY jtf_number_table
219: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
220: , child_task OUT Nocopy jtf_varchar2_table_100
221: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
222: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
223: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
224: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100

Line 221: , real_parts_required OUT NOCOPY jtf_varchar2_table_100

217: , real_duration OUT NOCOPY jtf_number_table
218: , real_task_type_id OUT NOCOPY jtf_number_table
219: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
220: , child_task OUT Nocopy jtf_varchar2_table_100
221: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
222: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
223: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
224: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
225: , real_task_depend OUT NOCOPY jtf_varchar2_table_100

Line 222: , real_access_hours OUT NOCOPY jtf_varchar2_table_100

218: , real_task_type_id OUT NOCOPY jtf_number_table
219: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
220: , child_task OUT Nocopy jtf_varchar2_table_100
221: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
222: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
223: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
224: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
225: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
226: , oth_real_task_id Out Nocopy jtf_varchar2_table_100

Line 223: , real_after_hours OUT NOCOPY jtf_varchar2_table_100

219: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
220: , child_task OUT Nocopy jtf_varchar2_table_100
221: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
222: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
223: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
224: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
225: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
226: , oth_real_task_id Out Nocopy jtf_varchar2_table_100
227: , oth_real_start_date Out Nocopy jtf_date_table

Line 224: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100

220: , child_task OUT Nocopy jtf_varchar2_table_100
221: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
222: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
223: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
224: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
225: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
226: , oth_real_task_id Out Nocopy jtf_varchar2_table_100
227: , oth_real_start_date Out Nocopy jtf_date_table
228: , oth_real_end_date Out Nocopy jtf_date_table

Line 225: , real_task_depend OUT NOCOPY jtf_varchar2_table_100

221: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
222: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
223: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
224: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
225: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
226: , oth_real_task_id Out Nocopy jtf_varchar2_table_100
227: , oth_real_start_date Out Nocopy jtf_date_table
228: , oth_real_end_date Out Nocopy jtf_date_table
229: , oth_real_color Out Nocopy jtf_number_table

Line 226: , oth_real_task_id Out Nocopy jtf_varchar2_table_100

222: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
223: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
224: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
225: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
226: , oth_real_task_id Out Nocopy jtf_varchar2_table_100
227: , oth_real_start_date Out Nocopy jtf_date_table
228: , oth_real_end_date Out Nocopy jtf_date_table
229: , oth_real_color Out Nocopy jtf_number_table
230: , oth_real_Name Out Nocopy jtf_varchar2_table_2000

Line 234: , oth_real_child_task Out Nocopy jtf_varchar2_table_100

230: , oth_real_Name Out Nocopy jtf_varchar2_table_2000
231: , oth_real_Duration Out Nocopy jtf_number_table
232: , oth_real_task_type_id Out Nocopy jtf_number_table
233: , oth_real_resource_key Out Nocopy jtf_varchar2_table_2000
234: , oth_real_child_task Out Nocopy jtf_varchar2_table_100
235: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
236: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
237: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
238: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100

Line 235: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100

231: , oth_real_Duration Out Nocopy jtf_number_table
232: , oth_real_task_type_id Out Nocopy jtf_number_table
233: , oth_real_resource_key Out Nocopy jtf_varchar2_table_2000
234: , oth_real_child_task Out Nocopy jtf_varchar2_table_100
235: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
236: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
237: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
238: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
239: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100

Line 236: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100

232: , oth_real_task_type_id Out Nocopy jtf_number_table
233: , oth_real_resource_key Out Nocopy jtf_varchar2_table_2000
234: , oth_real_child_task Out Nocopy jtf_varchar2_table_100
235: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
236: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
237: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
238: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
239: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100
240: );

Line 237: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100

233: , oth_real_resource_key Out Nocopy jtf_varchar2_table_2000
234: , oth_real_child_task Out Nocopy jtf_varchar2_table_100
235: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
236: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
237: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
238: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
239: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100
240: );
241:

Line 238: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100

234: , oth_real_child_task Out Nocopy jtf_varchar2_table_100
235: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
236: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
237: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
238: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
239: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100
240: );
241:
242: FUNCTION get_tooltip_data_sch_advise(

Line 239: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100

235: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
236: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
237: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
238: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
239: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100
240: );
241:
242: FUNCTION get_tooltip_data_sch_advise(
243: p_task_id NUMBER

Line 312: , task_id Out Nocopy jtf_varchar2_table_100

308: , p_request_id In varchar2
309: , x_return_status Out Nocopy Varchar2
310: , x_msg_count Out Nocopy Number
311: , x_msg_data Out Nocopy Varchar2
312: , task_id Out Nocopy jtf_varchar2_table_100
313: , start_date Out Nocopy jtf_date_table
314: , end_date Out Nocopy jtf_date_table
315: , color Out Nocopy jtf_number_table
316: , Name Out Nocopy jtf_varchar2_table_100

Line 316: , Name Out Nocopy jtf_varchar2_table_100

312: , task_id Out Nocopy jtf_varchar2_table_100
313: , start_date Out Nocopy jtf_date_table
314: , end_date Out Nocopy jtf_date_table
315: , color Out Nocopy jtf_number_table
316: , Name Out Nocopy jtf_varchar2_table_100
317: , tooltip Out Nocopy jtf_varchar2_table_2000
318: , Duration Out Nocopy jtf_number_table
319: , task_type_id Out Nocopy jtf_number_table
320: , resource_key Out Nocopy jtf_varchar2_table_2000