APPS.CSF_GANTT_DATA_PKG dependencies on JTF_VARCHAR2_TABLE_2000

Line 126: , p_message_text OUT NOCOPY jtf_varchar2_table_2000

122: , p_init_msg_list IN Varchar2 DEFAULT NULL
123: , x_return_status OUT NOCOPY Varchar2
124: , x_msg_count OUT NOCOPY Number
125: , x_msg_data OUT NOCOPY Varchar2
126: , p_message_text OUT NOCOPY jtf_varchar2_table_2000
127: , p_message_code OUT NOCOPY jtf_varchar2_table_2000
128: );
129:
130: Procedure get_dispatch_task_dtls (

Line 127: , p_message_code OUT NOCOPY jtf_varchar2_table_2000

123: , x_return_status OUT NOCOPY Varchar2
124: , x_msg_count OUT NOCOPY Number
125: , x_msg_data OUT NOCOPY Varchar2
126: , p_message_text OUT NOCOPY jtf_varchar2_table_2000
127: , p_message_code OUT NOCOPY jtf_varchar2_table_2000
128: );
129:
130: Procedure get_dispatch_task_dtls (
131: p_api_version IN Number

Line 139: , p_res_type OUT NOCOPY jtf_varchar2_table_2000

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

Line 140: , p_res_name OUT NOCOPY jtf_varchar2_table_2000

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
143: , p_trip_id OUT NOCOPY jtf_number_table
144: , p_shift_start_date OUT NOCOPY jtf_date_table

Line 141: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000

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

Line 142: , p_res_key OUT NOCOPY jtf_varchar2_table_2000

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

Line 147: , p_shift_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
151: , p_vir_color OUT NOCOPY jtf_number_table

Line 155: , p_vir_tooltip OUT NOCOPY jtf_varchar2_table_2000

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
159: , real_end_date OUT NOCOPY jtf_date_table

Line 156: , p_vir_resource_key OUT NOCOPY jtf_varchar2_table_2000

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
159: , real_end_date OUT NOCOPY jtf_date_table
160: , real_color OUT NOCOPY jtf_number_table

Line 161: , real_NAME 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
165: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000

Line 162: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000

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
165: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
166: , real_parts_required OUT NOCOPY jtf_varchar2_table_100

Line 165: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000

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
169: , real_customer_conf OUT NOCOPY jtf_varchar2_table_100

Line 188: , p_res_type OUT NOCOPY jtf_varchar2_table_2000

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
192: , p_cost OUT NOCOPY jtf_number_table

Line 189: , p_res_name OUT NOCOPY jtf_varchar2_table_2000

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
192: , p_cost OUT NOCOPY jtf_number_table
193: , p_start_date IN DATE

Line 190: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000

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
192: , p_cost OUT NOCOPY jtf_number_table
193: , p_start_date IN DATE
194: , p_end_date IN DATE

Line 191: , p_res_key OUT NOCOPY jtf_varchar2_table_2000

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

Line 201: , p_bck_res_key OUT NOCOPY jtf_varchar2_table_2000

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

Line 206: , plan_name 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
210: , plan_resource_key OUT NOCOPY jtf_varchar2_table_2000

Line 207: , plan_tooltip OUT NOCOPY jtf_varchar2_table_2000

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
210: , plan_resource_key OUT NOCOPY jtf_varchar2_table_2000
211: , real_task_key OUT NOCOPY jtf_varchar2_table_100

Line 210: , plan_resource_key OUT NOCOPY jtf_varchar2_table_2000

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

Line 215: , real_name 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
219: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000

Line 216: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000

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
219: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000
220: , child_task OUT Nocopy jtf_varchar2_table_100

Line 219: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000

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
223: , real_after_hours OUT NOCOPY jtf_varchar2_table_100

Line 230: , oth_real_Name Out Nocopy jtf_varchar2_table_2000

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
234: , oth_real_child_task Out Nocopy jtf_varchar2_table_100

Line 233: , oth_real_resource_key Out Nocopy jtf_varchar2_table_2000

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
237: , oth_real_after_hours OUT NOCOPY jtf_varchar2_table_100

Line 317: , tooltip Out Nocopy jtf_varchar2_table_2000

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
321: , sch_adv_tz In Varchar2

Line 320: , resource_key Out Nocopy jtf_varchar2_table_2000

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:
324: Function convert_to_days (