APPS.CSF_GANTT_DATA_PKG dependencies on JTF_NUMBER_TABLE

Line 146: , p_res_id OUT NOCOPY jtf_number_table

142: , x_msg_count OUT NOCOPY Number
143: , x_msg_data OUT NOCOPY Varchar2
144: , p_start_date_range IN DATE
145: , p_end_date_range IN DATE
146: , p_res_id OUT NOCOPY jtf_number_table
147: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
148: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
149: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
150: , p_res_key OUT NOCOPY jtf_varchar2_table_2000

Line 151: , p_trip_id OUT NOCOPY jtf_number_table

147: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
148: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
149: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
150: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
151: , p_trip_id OUT NOCOPY jtf_number_table
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

Line 154: , p_block_trip OUT NOCOPY jtf_number_table

150: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
151: , p_trip_id OUT NOCOPY jtf_number_table
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

Line 159: , p_vir_color 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
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

Line 161: , p_vir_duration OUT NOCOPY jtf_number_table

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
165: , real_task_id OUT NOCOPY jtf_varchar2_table_100

Line 162: , p_vir_task_type_id OUT NOCOPY jtf_number_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
165: , real_task_id OUT NOCOPY jtf_varchar2_table_100
166: , real_start_date OUT NOCOPY jtf_date_table

Line 168: , real_color OUT NOCOPY jtf_number_table

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

Line 171: , real_DURATION OUT NOCOPY jtf_number_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
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

Line 172: , real_task_type_id OUT NOCOPY jtf_number_table

168: , real_color OUT NOCOPY jtf_number_table
169: , real_NAME OUT NOCOPY jtf_varchar2_table_2000
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

Line 200: , p_res_id OUT NOCOPY jtf_number_table

196: , p_resource_type IN VARCHAR2
197: , p_req_id IN NUMBER
198: , p_par_task IN NUMBER
199: , p_task_id IN NUMBER
200: , p_res_id OUT NOCOPY jtf_number_table
201: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
202: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
203: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
204: , p_res_key OUT NOCOPY jtf_varchar2_table_2000

Line 205: , p_cost OUT NOCOPY jtf_number_table

201: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
202: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
203: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
204: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
205: , p_cost OUT NOCOPY jtf_number_table
206: , p_start_date IN DATE
207: , p_end_date IN DATE
208: , sch_adv_tz In Varchar2
209: , inc_tz_code In Varchar2

Line 210: , trip_id OUT NOCOPY jtf_number_table

206: , p_start_date IN DATE
207: , p_end_date IN DATE
208: , sch_adv_tz In Varchar2
209: , inc_tz_code In Varchar2
210: , trip_id OUT NOCOPY jtf_number_table
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

Line 213: , block_trip OUT NOCOPY jtf_number_table

209: , inc_tz_code In Varchar2
210: , trip_id OUT NOCOPY jtf_number_table
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

Line 218: , plan_color 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
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

Line 221: , plan_duration OUT NOCOPY jtf_number_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
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

Line 222: , plan_task_type_id OUT NOCOPY jtf_number_table

218: , plan_color OUT NOCOPY jtf_number_table
219: , plan_name OUT NOCOPY jtf_varchar2_table_2000
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

Line 227: , real_color 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
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

Line 230: , real_duration OUT NOCOPY jtf_number_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
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

Line 231: , real_task_type_id OUT NOCOPY jtf_number_table

227: , real_color OUT NOCOPY jtf_number_table
228: , real_name OUT NOCOPY jtf_varchar2_table_2000
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

Line 242: , oth_real_color Out Nocopy jtf_number_table

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

Line 244: , oth_real_Duration Out Nocopy jtf_number_table

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

Line 245: , oth_real_task_type_id Out Nocopy jtf_number_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
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

Line 360: , color Out Nocopy jtf_number_table

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
362: , tooltip Out Nocopy jtf_varchar2_table_2000
363: , Duration Out Nocopy jtf_number_table
364: , task_type_id Out Nocopy jtf_number_table

Line 363: , Duration Out Nocopy jtf_number_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
366: , sch_adv_tz In Varchar2
367: );

Line 364: , task_type_id Out Nocopy jtf_number_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
366: , sch_adv_tz In Varchar2
367: );
368: