APPS.CSF_GANTT_DATA_PKG dependencies on JTF_NUMBER_TABLE

Line 138: , p_res_id OUT NOCOPY jtf_number_table

134: , x_msg_count OUT NOCOPY Number
135: , x_msg_data OUT NOCOPY Varchar2
136: , p_start_date_range IN DATE
137: , p_end_date_range IN DATE
138: , p_res_id OUT NOCOPY jtf_number_table
139: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
140: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
141: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
142: , p_res_key OUT NOCOPY jtf_varchar2_table_2000

Line 143: , p_trip_id OUT NOCOPY jtf_number_table

139: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
140: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
141: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
142: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
143: , p_trip_id OUT NOCOPY jtf_number_table
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

Line 146: , p_block_trip OUT NOCOPY jtf_number_table

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

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

Line 153: , p_vir_duration OUT NOCOPY jtf_number_table

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

Line 154: , p_vir_task_type_id OUT NOCOPY jtf_number_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
157: , real_task_id OUT NOCOPY jtf_varchar2_table_100
158: , real_start_date OUT NOCOPY jtf_date_table

Line 160: , real_color OUT NOCOPY jtf_number_table

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

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

Line 164: , real_task_type_id OUT NOCOPY jtf_number_table

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

Line 187: , p_res_id OUT NOCOPY jtf_number_table

183: , p_resource_type IN VARCHAR2
184: , p_req_id IN NUMBER
185: , p_par_task IN NUMBER
186: , p_task_id IN NUMBER
187: , p_res_id OUT NOCOPY jtf_number_table
188: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
189: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
190: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
191: , p_res_key OUT NOCOPY jtf_varchar2_table_2000

Line 192: , p_cost OUT NOCOPY jtf_number_table

188: , p_res_type OUT NOCOPY jtf_varchar2_table_2000
189: , p_res_name OUT NOCOPY jtf_varchar2_table_2000
190: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000
191: , p_res_key OUT NOCOPY jtf_varchar2_table_2000
192: , p_cost OUT NOCOPY jtf_number_table
193: , p_start_date IN DATE
194: , p_end_date IN DATE
195: , sch_adv_tz In Varchar2
196: , inc_tz_code In Varchar2

Line 197: , trip_id OUT NOCOPY jtf_number_table

193: , p_start_date IN DATE
194: , p_end_date IN DATE
195: , sch_adv_tz In Varchar2
196: , inc_tz_code In Varchar2
197: , trip_id OUT NOCOPY jtf_number_table
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

Line 200: , block_trip OUT NOCOPY jtf_number_table

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

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

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

Line 209: , plan_task_type_id OUT NOCOPY jtf_number_table

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

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

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

Line 218: , real_task_type_id OUT NOCOPY jtf_number_table

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

Line 229: , oth_real_color Out Nocopy jtf_number_table

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

Line 231: , oth_real_Duration Out Nocopy jtf_number_table

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

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

Line 315: , color Out Nocopy jtf_number_table

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
317: , tooltip Out Nocopy jtf_varchar2_table_2000
318: , Duration Out Nocopy jtf_number_table
319: , task_type_id Out Nocopy jtf_number_table

Line 318: , Duration Out Nocopy jtf_number_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
321: , sch_adv_tz In Varchar2
322: );

Line 319: , task_type_id Out Nocopy jtf_number_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
321: , sch_adv_tz In Varchar2
322: );
323: