[Home] [Help]
PACKAGE: APPS.JTF_TASK_ASSIGNMENTS_PVT_W
Source
1 package jtf_task_assignments_pvt_w AUTHID CURRENT_USER as
2 /* $Header: jtfvtaws.pls 120.2 2006/04/26 04:41 knayyar noship $ */
3 procedure create_task_assignment(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_task_assignment_id NUMBER
7 , p_task_id NUMBER
8 , p_resource_type_code VARCHAR2
9 , p_resource_id NUMBER
10 , p_actual_effort NUMBER
11 , p_actual_effort_uom VARCHAR2
12 , p_schedule_flag VARCHAR2
13 , p_alarm_type_code VARCHAR2
14 , p_alarm_contact VARCHAR2
15 , p_sched_travel_distance NUMBER
16 , p_sched_travel_duration NUMBER
17 , p_sched_travel_duration_uom VARCHAR2
18 , p_actual_travel_distance NUMBER
19 , p_actual_travel_duration NUMBER
20 , p_actual_travel_duration_uom VARCHAR2
21 , p_actual_start_date date
22 , p_actual_end_date date
23 , p_palm_flag VARCHAR2
24 , p_wince_flag VARCHAR2
25 , p_laptop_flag VARCHAR2
26 , p_device1_flag VARCHAR2
27 , p_device2_flag VARCHAR2
28 , p_device3_flag VARCHAR2
29 , p_resource_territory_id NUMBER
30 , p_assignment_status_id NUMBER
31 , p_shift_construct_id NUMBER
32 , x_return_status out nocopy VARCHAR2
33 , x_msg_count out nocopy NUMBER
34 , x_msg_data out nocopy VARCHAR2
35 , x_task_assignment_id out nocopy NUMBER
36 , p_attribute1 VARCHAR2
37 , p_attribute2 VARCHAR2
38 , p_attribute3 VARCHAR2
39 , p_attribute4 VARCHAR2
40 , p_attribute5 VARCHAR2
41 , p_attribute6 VARCHAR2
42 , p_attribute7 VARCHAR2
43 , p_attribute8 VARCHAR2
44 , p_attribute9 VARCHAR2
45 , p_attribute10 VARCHAR2
46 , p_attribute11 VARCHAR2
47 , p_attribute12 VARCHAR2
48 , p_attribute13 VARCHAR2
49 , p_attribute14 VARCHAR2
50 , p_attribute15 VARCHAR2
51 , p_attribute_category VARCHAR2
52 , p_assignee_role VARCHAR2
53 , p_show_on_calendar VARCHAR2
54 , p_category_id NUMBER
55 , p_enable_workflow VARCHAR2
56 , p_abort_workflow VARCHAR2
57 , p_add_option VARCHAR2
58 , p_free_busy_type VARCHAR2
59 );
60 procedure create_task_assignment(p_api_version NUMBER
61 , p_init_msg_list VARCHAR2
62 , p_commit VARCHAR2
63 , p_task_assignment_id NUMBER
64 , p_task_id NUMBER
65 , p_resource_type_code VARCHAR2
66 , p_resource_id NUMBER
67 , p_actual_effort NUMBER
68 , p_actual_effort_uom VARCHAR2
69 , p_schedule_flag VARCHAR2
70 , p_alarm_type_code VARCHAR2
71 , p_alarm_contact VARCHAR2
72 , p_sched_travel_distance NUMBER
73 , p_sched_travel_duration NUMBER
74 , p_sched_travel_duration_uom VARCHAR2
75 , p_actual_travel_distance NUMBER
76 , p_actual_travel_duration NUMBER
77 , p_actual_travel_duration_uom VARCHAR2
78 , p_actual_start_date date
79 , p_actual_end_date date
80 , p_palm_flag VARCHAR2
81 , p_wince_flag VARCHAR2
82 , p_laptop_flag VARCHAR2
83 , p_device1_flag VARCHAR2
84 , p_device2_flag VARCHAR2
85 , p_device3_flag VARCHAR2
86 , p_resource_territory_id NUMBER
87 , p_assignment_status_id NUMBER
88 , p_shift_construct_id NUMBER
89 , x_return_status out nocopy VARCHAR2
90 , x_msg_count out nocopy NUMBER
91 , x_msg_data out nocopy VARCHAR2
92 , x_task_assignment_id out nocopy NUMBER
93 , p_attribute1 VARCHAR2
94 , p_attribute2 VARCHAR2
95 , p_attribute3 VARCHAR2
96 , p_attribute4 VARCHAR2
97 , p_attribute5 VARCHAR2
98 , p_attribute6 VARCHAR2
99 , p_attribute7 VARCHAR2
100 , p_attribute8 VARCHAR2
101 , p_attribute9 VARCHAR2
102 , p_attribute10 VARCHAR2
103 , p_attribute11 VARCHAR2
104 , p_attribute12 VARCHAR2
105 , p_attribute13 VARCHAR2
106 , p_attribute14 VARCHAR2
107 , p_attribute15 VARCHAR2
108 , p_attribute_category VARCHAR2
109 , p_assignee_role VARCHAR2
110 , p_show_on_calendar VARCHAR2
111 , p_category_id NUMBER
112 , p_enable_workflow VARCHAR2
113 , p_abort_workflow VARCHAR2
114 , p_add_option VARCHAR2
115 , p_free_busy_type VARCHAR2
116 , p_object_capacity_id NUMBER
117 );
118 procedure create_task_assignment(p_api_version NUMBER
119 , p_init_msg_list VARCHAR2
120 , p_commit VARCHAR2
121 , p_task_assignment_id NUMBER
122 , p_task_id NUMBER
123 , p_resource_type_code VARCHAR2
124 , p_resource_id NUMBER
125 , p_actual_effort NUMBER
126 , p_actual_effort_uom VARCHAR2
127 , p_schedule_flag VARCHAR2
128 , p_alarm_type_code VARCHAR2
129 , p_alarm_contact VARCHAR2
130 , p_sched_travel_distance NUMBER
131 , p_sched_travel_duration NUMBER
132 , p_sched_travel_duration_uom VARCHAR2
133 , p_actual_travel_distance NUMBER
134 , p_actual_travel_duration NUMBER
135 , p_actual_travel_duration_uom VARCHAR2
136 , p_actual_start_date date
137 , p_actual_end_date date
138 , p_palm_flag VARCHAR2
139 , p_wince_flag VARCHAR2
140 , p_laptop_flag VARCHAR2
141 , p_device1_flag VARCHAR2
142 , p_device2_flag VARCHAR2
143 , p_device3_flag VARCHAR2
144 , p_resource_territory_id NUMBER
145 , p_assignment_status_id NUMBER
146 , p_shift_construct_id NUMBER
147 , x_return_status out nocopy VARCHAR2
148 , x_msg_count out nocopy NUMBER
149 , x_msg_data out nocopy VARCHAR2
150 , x_task_assignment_id out nocopy NUMBER
151 , p_attribute1 VARCHAR2
152 , p_attribute2 VARCHAR2
153 , p_attribute3 VARCHAR2
154 , p_attribute4 VARCHAR2
155 , p_attribute5 VARCHAR2
156 , p_attribute6 VARCHAR2
157 , p_attribute7 VARCHAR2
158 , p_attribute8 VARCHAR2
159 , p_attribute9 VARCHAR2
160 , p_attribute10 VARCHAR2
161 , p_attribute11 VARCHAR2
162 , p_attribute12 VARCHAR2
163 , p_attribute13 VARCHAR2
164 , p_attribute14 VARCHAR2
165 , p_attribute15 VARCHAR2
166 , p_attribute_category VARCHAR2
167 , p_assignee_role VARCHAR2
168 , p_show_on_calendar VARCHAR2
169 , p_category_id NUMBER
170 , p_enable_workflow VARCHAR2
171 , p_abort_workflow VARCHAR2
172 , p_add_option VARCHAR2
173 );
174 procedure create_task_assignment(p_api_version NUMBER
175 , p_init_msg_list VARCHAR2
176 , p_commit VARCHAR2
177 , p_task_assignment_id NUMBER
178 , p_task_id NUMBER
179 , p_resource_type_code VARCHAR2
180 , p_resource_id NUMBER
181 , p_actual_effort NUMBER
182 , p_actual_effort_uom VARCHAR2
183 , p_schedule_flag VARCHAR2
184 , p_alarm_type_code VARCHAR2
185 , p_alarm_contact VARCHAR2
186 , p_sched_travel_distance NUMBER
187 , p_sched_travel_duration NUMBER
188 , p_sched_travel_duration_uom VARCHAR2
189 , p_actual_travel_distance NUMBER
190 , p_actual_travel_duration NUMBER
191 , p_actual_travel_duration_uom VARCHAR2
192 , p_actual_start_date date
193 , p_actual_end_date date
194 , p_palm_flag VARCHAR2
195 , p_wince_flag VARCHAR2
196 , p_laptop_flag VARCHAR2
197 , p_device1_flag VARCHAR2
198 , p_device2_flag VARCHAR2
199 , p_device3_flag VARCHAR2
200 , p_resource_territory_id NUMBER
201 , p_assignment_status_id NUMBER
202 , p_shift_construct_id NUMBER
203 , x_return_status out nocopy VARCHAR2
204 , x_msg_count out nocopy NUMBER
205 , x_msg_data out nocopy VARCHAR2
206 , x_task_assignment_id out nocopy NUMBER
207 , p_attribute1 VARCHAR2
208 , p_attribute2 VARCHAR2
209 , p_attribute3 VARCHAR2
210 , p_attribute4 VARCHAR2
211 , p_attribute5 VARCHAR2
212 , p_attribute6 VARCHAR2
213 , p_attribute7 VARCHAR2
214 , p_attribute8 VARCHAR2
215 , p_attribute9 VARCHAR2
216 , p_attribute10 VARCHAR2
217 , p_attribute11 VARCHAR2
218 , p_attribute12 VARCHAR2
219 , p_attribute13 VARCHAR2
220 , p_attribute14 VARCHAR2
221 , p_attribute15 VARCHAR2
222 , p_attribute_category VARCHAR2
223 , p_assignee_role VARCHAR2
224 , p_show_on_calendar VARCHAR2
225 , p_category_id NUMBER
226 , p_enable_workflow VARCHAR2
227 , p_abort_workflow VARCHAR2
228 );
229 procedure create_task_assignment(p_api_version NUMBER
230 , p_init_msg_list VARCHAR2
231 , p_commit VARCHAR2
232 , p_task_assignment_id NUMBER
233 , p_task_id NUMBER
234 , p_resource_type_code VARCHAR2
235 , p_resource_id NUMBER
236 , p_actual_effort NUMBER
237 , p_actual_effort_uom VARCHAR2
238 , p_schedule_flag VARCHAR2
239 , p_alarm_type_code VARCHAR2
240 , p_alarm_contact VARCHAR2
241 , p_sched_travel_distance NUMBER
242 , p_sched_travel_duration NUMBER
243 , p_sched_travel_duration_uom VARCHAR2
244 , p_actual_travel_distance NUMBER
245 , p_actual_travel_duration NUMBER
246 , p_actual_travel_duration_uom VARCHAR2
247 , p_actual_start_date date
248 , p_actual_end_date date
249 , p_palm_flag VARCHAR2
250 , p_wince_flag VARCHAR2
251 , p_laptop_flag VARCHAR2
252 , p_device1_flag VARCHAR2
253 , p_device2_flag VARCHAR2
254 , p_device3_flag VARCHAR2
255 , p_resource_territory_id NUMBER
256 , p_assignment_status_id NUMBER
257 , p_shift_construct_id NUMBER
258 , x_return_status out nocopy VARCHAR2
259 , x_msg_count out nocopy NUMBER
260 , x_msg_data out nocopy VARCHAR2
261 , x_task_assignment_id out nocopy NUMBER
262 , p_attribute1 VARCHAR2
263 , p_attribute2 VARCHAR2
264 , p_attribute3 VARCHAR2
265 , p_attribute4 VARCHAR2
266 , p_attribute5 VARCHAR2
267 , p_attribute6 VARCHAR2
268 , p_attribute7 VARCHAR2
269 , p_attribute8 VARCHAR2
270 , p_attribute9 VARCHAR2
271 , p_attribute10 VARCHAR2
272 , p_attribute11 VARCHAR2
273 , p_attribute12 VARCHAR2
274 , p_attribute13 VARCHAR2
275 , p_attribute14 VARCHAR2
276 , p_attribute15 VARCHAR2
277 , p_attribute_category VARCHAR2
278 , p_assignee_role VARCHAR2
279 , p_show_on_calendar VARCHAR2
280 , p_category_id NUMBER
281 );
282 procedure update_task_assignment(p_api_version NUMBER
283 , p_object_version_number in out nocopy NUMBER
284 , p_init_msg_list VARCHAR2
285 , p_commit VARCHAR2
286 , p_task_assignment_id NUMBER
287 , p_resource_type_code VARCHAR2
288 , p_resource_id NUMBER
289 , p_actual_effort NUMBER
290 , p_actual_effort_uom VARCHAR2
291 , p_schedule_flag VARCHAR2
292 , p_alarm_type_code VARCHAR2
293 , p_alarm_contact VARCHAR2
294 , p_sched_travel_distance NUMBER
295 , p_sched_travel_duration NUMBER
296 , p_sched_travel_duration_uom VARCHAR2
297 , p_actual_travel_distance NUMBER
298 , p_actual_travel_duration NUMBER
299 , p_actual_travel_duration_uom VARCHAR2
300 , p_actual_start_date date
301 , p_actual_end_date date
302 , p_palm_flag VARCHAR2
303 , p_wince_flag VARCHAR2
304 , p_laptop_flag VARCHAR2
305 , p_device1_flag VARCHAR2
306 , p_device2_flag VARCHAR2
307 , p_device3_flag VARCHAR2
308 , p_resource_territory_id NUMBER
309 , p_assignment_status_id NUMBER
310 , p_shift_construct_id NUMBER
311 , x_return_status out nocopy VARCHAR2
312 , x_msg_count out nocopy NUMBER
313 , x_msg_data out nocopy VARCHAR2
314 , p_attribute1 VARCHAR2
315 , p_attribute2 VARCHAR2
316 , p_attribute3 VARCHAR2
317 , p_attribute4 VARCHAR2
318 , p_attribute5 VARCHAR2
319 , p_attribute6 VARCHAR2
320 , p_attribute7 VARCHAR2
321 , p_attribute8 VARCHAR2
322 , p_attribute9 VARCHAR2
323 , p_attribute10 VARCHAR2
324 , p_attribute11 VARCHAR2
325 , p_attribute12 VARCHAR2
326 , p_attribute13 VARCHAR2
327 , p_attribute14 VARCHAR2
328 , p_attribute15 VARCHAR2
329 , p_attribute_category VARCHAR2
330 , p_assignee_role VARCHAR2
331 , p_show_on_calendar VARCHAR2
332 , p_category_id NUMBER
333 , p_enable_workflow VARCHAR2
334 , p_abort_workflow VARCHAR2
335 , p_free_busy_type VARCHAR2
336 );
337 procedure update_task_assignment(p_api_version NUMBER
338 , p_object_version_number in out nocopy NUMBER
339 , p_init_msg_list VARCHAR2
340 , p_commit VARCHAR2
341 , p_task_assignment_id NUMBER
342 , p_resource_type_code VARCHAR2
343 , p_resource_id NUMBER
344 , p_actual_effort NUMBER
345 , p_actual_effort_uom VARCHAR2
346 , p_schedule_flag VARCHAR2
347 , p_alarm_type_code VARCHAR2
348 , p_alarm_contact VARCHAR2
349 , p_sched_travel_distance NUMBER
350 , p_sched_travel_duration NUMBER
351 , p_sched_travel_duration_uom VARCHAR2
352 , p_actual_travel_distance NUMBER
353 , p_actual_travel_duration NUMBER
354 , p_actual_travel_duration_uom VARCHAR2
355 , p_actual_start_date date
356 , p_actual_end_date date
357 , p_palm_flag VARCHAR2
358 , p_wince_flag VARCHAR2
359 , p_laptop_flag VARCHAR2
360 , p_device1_flag VARCHAR2
361 , p_device2_flag VARCHAR2
362 , p_device3_flag VARCHAR2
363 , p_resource_territory_id NUMBER
364 , p_assignment_status_id NUMBER
365 , p_shift_construct_id NUMBER
366 , x_return_status out nocopy VARCHAR2
367 , x_msg_count out nocopy NUMBER
368 , x_msg_data out nocopy VARCHAR2
369 , p_attribute1 VARCHAR2
370 , p_attribute2 VARCHAR2
371 , p_attribute3 VARCHAR2
375 , p_attribute7 VARCHAR2
372 , p_attribute4 VARCHAR2
373 , p_attribute5 VARCHAR2
374 , p_attribute6 VARCHAR2
376 , p_attribute8 VARCHAR2
377 , p_attribute9 VARCHAR2
378 , p_attribute10 VARCHAR2
379 , p_attribute11 VARCHAR2
380 , p_attribute12 VARCHAR2
381 , p_attribute13 VARCHAR2
382 , p_attribute14 VARCHAR2
383 , p_attribute15 VARCHAR2
384 , p_attribute_category VARCHAR2
385 , p_assignee_role VARCHAR2
386 , p_show_on_calendar VARCHAR2
387 , p_category_id NUMBER
388 , p_enable_workflow VARCHAR2
389 , p_abort_workflow VARCHAR2
390 , p_free_busy_type VARCHAR2
391 , p_object_capacity_id NUMBER
392 );
393 procedure update_task_assignment(p_api_version NUMBER
394 , p_object_version_number in out nocopy NUMBER
395 , p_init_msg_list VARCHAR2
396 , p_commit VARCHAR2
397 , p_task_assignment_id NUMBER
398 , p_resource_type_code VARCHAR2
399 , p_resource_id NUMBER
400 , p_actual_effort NUMBER
401 , p_actual_effort_uom VARCHAR2
402 , p_schedule_flag VARCHAR2
403 , p_alarm_type_code VARCHAR2
404 , p_alarm_contact VARCHAR2
405 , p_sched_travel_distance NUMBER
406 , p_sched_travel_duration NUMBER
407 , p_sched_travel_duration_uom VARCHAR2
408 , p_actual_travel_distance NUMBER
409 , p_actual_travel_duration NUMBER
410 , p_actual_travel_duration_uom VARCHAR2
411 , p_actual_start_date date
412 , p_actual_end_date date
413 , p_palm_flag VARCHAR2
414 , p_wince_flag VARCHAR2
415 , p_laptop_flag VARCHAR2
416 , p_device1_flag VARCHAR2
417 , p_device2_flag VARCHAR2
418 , p_device3_flag VARCHAR2
419 , p_resource_territory_id NUMBER
420 , p_assignment_status_id NUMBER
421 , p_shift_construct_id NUMBER
422 , x_return_status out nocopy VARCHAR2
423 , x_msg_count out nocopy NUMBER
424 , x_msg_data out nocopy VARCHAR2
425 , p_attribute1 VARCHAR2
426 , p_attribute2 VARCHAR2
427 , p_attribute3 VARCHAR2
428 , p_attribute4 VARCHAR2
429 , p_attribute5 VARCHAR2
430 , p_attribute6 VARCHAR2
431 , p_attribute7 VARCHAR2
432 , p_attribute8 VARCHAR2
433 , p_attribute9 VARCHAR2
434 , p_attribute10 VARCHAR2
435 , p_attribute11 VARCHAR2
436 , p_attribute12 VARCHAR2
437 , p_attribute13 VARCHAR2
438 , p_attribute14 VARCHAR2
439 , p_attribute15 VARCHAR2
440 , p_attribute_category VARCHAR2
441 , p_assignee_role VARCHAR2
442 , p_show_on_calendar VARCHAR2
443 , p_category_id NUMBER
444 , p_enable_workflow VARCHAR2
445 , p_abort_workflow VARCHAR2
446 );
447 procedure update_task_assignment(p_api_version NUMBER
448 , p_object_version_number in out nocopy NUMBER
449 , p_init_msg_list VARCHAR2
450 , p_commit VARCHAR2
451 , p_task_assignment_id NUMBER
452 , p_resource_type_code VARCHAR2
453 , p_resource_id NUMBER
454 , p_actual_effort NUMBER
455 , p_actual_effort_uom VARCHAR2
456 , p_schedule_flag VARCHAR2
457 , p_alarm_type_code VARCHAR2
458 , p_alarm_contact VARCHAR2
459 , p_sched_travel_distance NUMBER
460 , p_sched_travel_duration NUMBER
461 , p_sched_travel_duration_uom VARCHAR2
462 , p_actual_travel_distance NUMBER
463 , p_actual_travel_duration NUMBER
464 , p_actual_travel_duration_uom VARCHAR2
465 , p_actual_start_date date
466 , p_actual_end_date date
467 , p_palm_flag VARCHAR2
468 , p_wince_flag VARCHAR2
469 , p_laptop_flag VARCHAR2
470 , p_device1_flag VARCHAR2
471 , p_device2_flag VARCHAR2
472 , p_device3_flag VARCHAR2
473 , p_resource_territory_id NUMBER
474 , p_assignment_status_id NUMBER
475 , p_shift_construct_id NUMBER
476 , x_return_status out nocopy VARCHAR2
477 , x_msg_count out nocopy NUMBER
478 , x_msg_data out nocopy VARCHAR2
479 , p_attribute1 VARCHAR2
480 , p_attribute2 VARCHAR2
481 , p_attribute3 VARCHAR2
482 , p_attribute4 VARCHAR2
483 , p_attribute5 VARCHAR2
484 , p_attribute6 VARCHAR2
485 , p_attribute7 VARCHAR2
486 , p_attribute8 VARCHAR2
487 , p_attribute9 VARCHAR2
488 , p_attribute10 VARCHAR2
489 , p_attribute11 VARCHAR2
490 , p_attribute12 VARCHAR2
491 , p_attribute13 VARCHAR2
492 , p_attribute14 VARCHAR2
493 , p_attribute15 VARCHAR2
494 , p_attribute_category VARCHAR2
495 , p_assignee_role VARCHAR2
496 , p_show_on_calendar VARCHAR2
497 , p_category_id NUMBER
498 );
499 end jtf_task_assignments_pvt_w;