APPS.CSF_GANTT_DATA_PKG dependencies on JTF_VARCHAR2_TABLE_2000

Line 134: , p_message_text OUT NOCOPY jtf_varchar2_table_2000

130: , p_init_msg_list IN Varchar2 DEFAULT NULL
131: , x_return_status OUT NOCOPY Varchar2
132: , x_msg_count OUT NOCOPY Number
133: , x_msg_data OUT NOCOPY Varchar2
134: , p_message_text OUT NOCOPY jtf_varchar2_table_2000
135: , p_message_code OUT NOCOPY jtf_varchar2_table_2000
136: );
137:
138: Procedure get_dispatch_task_dtls (

Line 135: , p_message_code OUT NOCOPY jtf_varchar2_table_2000

131: , x_return_status OUT NOCOPY Varchar2
132: , x_msg_count OUT NOCOPY Number
133: , x_msg_data OUT NOCOPY Varchar2
134: , p_message_text OUT NOCOPY jtf_varchar2_table_2000
135: , p_message_code OUT NOCOPY jtf_varchar2_table_2000
136: );
137:
138: Procedure get_dispatch_task_dtls (
139: p_api_version IN Number

Line 147: , p_res_type OUT NOCOPY jtf_varchar2_table_2000

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

Line 148: , p_res_name OUT NOCOPY jtf_varchar2_table_2000

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

Line 149: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000

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

Line 150: , p_res_key OUT NOCOPY jtf_varchar2_table_2000

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

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

Line 163: , p_vir_tooltip OUT NOCOPY jtf_varchar2_table_2000

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

Line 164: , p_vir_resource_key OUT NOCOPY jtf_varchar2_table_2000

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

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

Line 170: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000

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

Line 173: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000

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

Line 180: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000

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
184: );

Line 182: , p_terr_name OUT NOCOPY jtf_varchar2_table_2000

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
184: );
185:
186:

Line 183: , p_contact OUT NOCOPY jtf_varchar2_table_2000

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
184: );
185:
186:
187: PROCEDURE get_schedule_advise_options

Line 201: , p_res_type OUT NOCOPY jtf_varchar2_table_2000

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

Line 202: , p_res_name OUT NOCOPY jtf_varchar2_table_2000

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

Line 203: , p_res_typ_name OUT NOCOPY jtf_varchar2_table_2000

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
205: , p_cost OUT NOCOPY jtf_number_table
206: , p_start_date IN DATE
207: , p_end_date IN DATE

Line 204: , p_res_key OUT NOCOPY jtf_varchar2_table_2000

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

Line 214: , p_bck_res_key OUT NOCOPY jtf_varchar2_table_2000

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

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

Line 220: , plan_tooltip OUT NOCOPY jtf_varchar2_table_2000

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

Line 223: , plan_resource_key OUT NOCOPY jtf_varchar2_table_2000

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

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

Line 229: , real_tooltip OUT NOCOPY jtf_varchar2_table_2000

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

Line 232: , real_resource_key OUT NOCOPY jtf_varchar2_table_2000

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

Line 243: , oth_real_Name Out Nocopy jtf_varchar2_table_2000

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

Line 246: , oth_real_resource_key Out Nocopy jtf_varchar2_table_2000

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

Line 253: , p_vir_avail_type OUT NOCOPY jtf_varchar2_table_2000

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(
257: p_task_id NUMBER

Line 362: , tooltip Out Nocopy jtf_varchar2_table_2000

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

Line 365: , resource_key Out Nocopy jtf_varchar2_table_2000

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