APPS.CSF_GANTT_DATA_PKG dependencies on JTF_VARCHAR2_TABLE_100

Line 156: , p_vir_task_id OUT NOCOPY jtf_varchar2_table_100

152: , p_shift_start_date OUT NOCOPY jtf_date_table
153: , p_shift_end_date OUT NOCOPY jtf_date_table
154: , p_block_trip OUT NOCOPY jtf_number_table
155: , p_shift_res_key OUT NOCOPY jtf_varchar2_table_2000
156: , p_vir_task_id OUT NOCOPY jtf_varchar2_table_100
157: , p_vir_start_date OUT NOCOPY jtf_date_table
158: , p_vir_end_date OUT NOCOPY jtf_date_table
159: , p_vir_color OUT NOCOPY jtf_number_table
160: , p_vir_name OUT NOCOPY jtf_varchar2_table_100

Line 160: , p_vir_name OUT NOCOPY jtf_varchar2_table_100

156: , p_vir_task_id OUT NOCOPY jtf_varchar2_table_100
157: , p_vir_start_date OUT NOCOPY jtf_date_table
158: , p_vir_end_date OUT NOCOPY jtf_date_table
159: , p_vir_color OUT NOCOPY jtf_number_table
160: , p_vir_name OUT NOCOPY jtf_varchar2_table_100
161: , p_vir_duration OUT NOCOPY jtf_number_table
162: , p_vir_task_type_id OUT NOCOPY jtf_number_table
163: , p_vir_tooltip OUT NOCOPY jtf_varchar2_table_2000
164: , p_vir_resource_key OUT NOCOPY jtf_varchar2_table_2000

Line 165: , real_task_id OUT NOCOPY jtf_varchar2_table_100

161: , p_vir_duration OUT NOCOPY jtf_number_table
162: , p_vir_task_type_id OUT NOCOPY jtf_number_table
163: , p_vir_tooltip OUT NOCOPY jtf_varchar2_table_2000
164: , p_vir_resource_key OUT NOCOPY jtf_varchar2_table_2000
165: , real_task_id OUT NOCOPY jtf_varchar2_table_100
166: , real_start_date OUT NOCOPY jtf_date_table
167: , real_end_date OUT NOCOPY jtf_date_table
168: , real_color OUT NOCOPY jtf_number_table
169: , real_NAME OUT NOCOPY jtf_varchar2_table_2000

Line 174: , real_parts_required OUT NOCOPY jtf_varchar2_table_100

170: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000
171: , real_DURATION OUT NOCOPY jtf_number_table
172: , real_task_type_id OUT NOCOPY jtf_number_table
173: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
174: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
175: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
176: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
177: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
178: , real_task_depend OUT NOCOPY jtf_varchar2_table_100

Line 175: , real_access_hours OUT NOCOPY jtf_varchar2_table_100

171: , real_DURATION OUT NOCOPY jtf_number_table
172: , real_task_type_id OUT NOCOPY jtf_number_table
173: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
174: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
175: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
176: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
177: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
178: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
179: , real_child_task OUT NOCOPY jtf_varchar2_table_100

Line 176: , real_after_hours OUT NOCOPY jtf_varchar2_table_100

172: , real_task_type_id OUT NOCOPY jtf_number_table
173: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
174: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
175: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
176: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
177: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
178: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
179: , real_child_task OUT NOCOPY jtf_varchar2_table_100
180: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000

Line 177: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100

173: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
174: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
175: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
176: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
177: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
178: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
179: , real_child_task OUT NOCOPY jtf_varchar2_table_100
180: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000
181: , p_show_arr_dep_tasks IN varchar2 DEFAULT 'N'

Line 178: , real_task_depend OUT NOCOPY jtf_varchar2_table_100

174: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
175: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
176: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
177: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
178: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
179: , real_child_task OUT NOCOPY jtf_varchar2_table_100
180: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000
181: , p_show_arr_dep_tasks IN varchar2 DEFAULT 'N'
182: , p_terr_name OUT NOCOPY jtf_varchar2_table_2000

Line 179: , real_child_task OUT NOCOPY jtf_varchar2_table_100

175: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
176: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
177: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
178: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
179: , real_child_task OUT NOCOPY jtf_varchar2_table_100
180: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000
181: , p_show_arr_dep_tasks IN varchar2 DEFAULT 'N'
182: , p_terr_name OUT NOCOPY jtf_varchar2_table_2000
183: , p_contact OUT NOCOPY jtf_varchar2_table_2000

Line 215: , plan_task_key OUT NOCOPY jtf_varchar2_table_100

211: , start_date OUT NOCOPY jtf_date_table
212: , end_date OUT NOCOPY jtf_date_table
213: , block_trip OUT NOCOPY jtf_number_table
214: , p_bck_res_key OUT NOCOPY jtf_varchar2_table_2000
215: , plan_task_key OUT NOCOPY jtf_varchar2_table_100
216: , plan_start_date OUT NOCOPY jtf_date_table
217: , plan_end_date OUT NOCOPY jtf_date_table
218: , plan_color OUT NOCOPY jtf_number_table
219: , plan_name OUT NOCOPY jtf_varchar2_table_2000

Line 224: , real_task_key OUT NOCOPY jtf_varchar2_table_100

220: , plan_tooltip OUT NOCOPY jtf_varchar2_table_2000
221: , plan_duration OUT NOCOPY jtf_number_table
222: , plan_task_type_id OUT NOCOPY jtf_number_table
223: , plan_resource_key OUT NOCOPY jtf_varchar2_table_2000
224: , real_task_key OUT NOCOPY jtf_varchar2_table_100
225: , real_start_date OUT NOCOPY jtf_date_table
226: , real_end_date OUT NOCOPY jtf_date_table
227: , real_color OUT NOCOPY jtf_number_table
228: , real_name OUT NOCOPY jtf_varchar2_table_2000

Line 233: , child_task OUT Nocopy jtf_varchar2_table_100

229: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000
230: , real_duration OUT NOCOPY jtf_number_table
231: , real_task_type_id OUT NOCOPY jtf_number_table
232: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
233: , child_task OUT Nocopy jtf_varchar2_table_100
234: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
235: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
236: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
237: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100

Line 234: , real_parts_required OUT NOCOPY jtf_varchar2_table_100

230: , real_duration OUT NOCOPY jtf_number_table
231: , real_task_type_id OUT NOCOPY jtf_number_table
232: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
233: , child_task OUT Nocopy jtf_varchar2_table_100
234: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
235: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
236: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
237: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
238: , real_task_depend OUT NOCOPY jtf_varchar2_table_100

Line 235: , real_access_hours OUT NOCOPY jtf_varchar2_table_100

231: , real_task_type_id OUT NOCOPY jtf_number_table
232: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
233: , child_task OUT Nocopy jtf_varchar2_table_100
234: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
235: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
236: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
237: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
238: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
239: , oth_real_task_id Out Nocopy jtf_varchar2_table_100

Line 236: , real_after_hours OUT NOCOPY jtf_varchar2_table_100

232: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
233: , child_task OUT Nocopy jtf_varchar2_table_100
234: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
235: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
236: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
237: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
238: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
239: , oth_real_task_id Out Nocopy jtf_varchar2_table_100
240: , oth_real_start_date Out Nocopy jtf_date_table

Line 237: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100

233: , child_task OUT Nocopy jtf_varchar2_table_100
234: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
235: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
236: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
237: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
238: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
239: , oth_real_task_id Out Nocopy jtf_varchar2_table_100
240: , oth_real_start_date Out Nocopy jtf_date_table
241: , oth_real_end_date Out Nocopy jtf_date_table

Line 238: , real_task_depend OUT NOCOPY jtf_varchar2_table_100

234: , real_parts_required OUT NOCOPY jtf_varchar2_table_100
235: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
236: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
237: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
238: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
239: , oth_real_task_id Out Nocopy jtf_varchar2_table_100
240: , oth_real_start_date Out Nocopy jtf_date_table
241: , oth_real_end_date Out Nocopy jtf_date_table
242: , oth_real_color Out Nocopy jtf_number_table

Line 239: , oth_real_task_id Out Nocopy jtf_varchar2_table_100

235: , real_access_hours OUT NOCOPY jtf_varchar2_table_100
236: , real_after_hours OUT NOCOPY jtf_varchar2_table_100
237: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100
238: , real_task_depend OUT NOCOPY jtf_varchar2_table_100
239: , oth_real_task_id Out Nocopy jtf_varchar2_table_100
240: , oth_real_start_date Out Nocopy jtf_date_table
241: , oth_real_end_date Out Nocopy jtf_date_table
242: , oth_real_color Out Nocopy jtf_number_table
243: , oth_real_Name Out Nocopy jtf_varchar2_table_2000

Line 247: , oth_real_child_task Out Nocopy jtf_varchar2_table_100

243: , oth_real_Name Out Nocopy jtf_varchar2_table_2000
244: , oth_real_Duration Out Nocopy jtf_number_table
245: , oth_real_task_type_id Out Nocopy jtf_number_table
246: , oth_real_resource_key Out Nocopy jtf_varchar2_table_2000
247: , oth_real_child_task Out Nocopy jtf_varchar2_table_100
248: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
249: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
250: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
251: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100

Line 248: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100

244: , oth_real_Duration Out Nocopy jtf_number_table
245: , oth_real_task_type_id Out Nocopy jtf_number_table
246: , oth_real_resource_key Out Nocopy jtf_varchar2_table_2000
247: , oth_real_child_task Out Nocopy jtf_varchar2_table_100
248: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
249: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
250: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
251: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
252: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100

Line 249: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100

245: , oth_real_task_type_id Out Nocopy jtf_number_table
246: , oth_real_resource_key Out Nocopy jtf_varchar2_table_2000
247: , oth_real_child_task Out Nocopy jtf_varchar2_table_100
248: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
249: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
250: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
251: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
252: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100
253: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000

Line 250: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100

246: , oth_real_resource_key Out Nocopy jtf_varchar2_table_2000
247: , oth_real_child_task Out Nocopy jtf_varchar2_table_100
248: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
249: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
250: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
251: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
252: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100
253: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000
254: );

Line 251: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100

247: , oth_real_child_task Out Nocopy jtf_varchar2_table_100
248: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
249: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
250: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
251: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
252: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100
253: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000
254: );
255:

Line 252: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100

248: , oth_real_parts_required OUT NOCOPY jtf_varchar2_table_100
249: , oth_real_access_hours OUT NOCOPY jtf_varchar2_table_100
250: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100
251: , oth_real_customer_conf OUT NOCOPY jtf_varchar2_table_100
252: , oth_real_task_depend OUT NOCOPY jtf_varchar2_table_100
253: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000
254: );
255:
256: FUNCTION get_tooltip_data_sch_advise(

Line 357: , task_id Out Nocopy jtf_varchar2_table_100

353: , p_request_id In varchar2
354: , x_return_status Out Nocopy Varchar2
355: , x_msg_count Out Nocopy Number
356: , x_msg_data Out Nocopy Varchar2
357: , task_id Out Nocopy jtf_varchar2_table_100
358: , start_date Out Nocopy jtf_date_table
359: , end_date Out Nocopy jtf_date_table
360: , color Out Nocopy jtf_number_table
361: , Name Out Nocopy jtf_varchar2_table_100

Line 361: , Name Out Nocopy jtf_varchar2_table_100

357: , task_id Out Nocopy jtf_varchar2_table_100
358: , start_date Out Nocopy jtf_date_table
359: , end_date Out Nocopy jtf_date_table
360: , color Out Nocopy jtf_number_table
361: , Name Out Nocopy jtf_varchar2_table_100
362: , tooltip Out Nocopy jtf_varchar2_table_2000
363: , Duration Out Nocopy jtf_number_table
364: , task_type_id Out Nocopy jtf_number_table
365: , resource_key Out Nocopy jtf_varchar2_table_2000