[Home] [Help]
PACKAGE BODY: APPS.JTF_TASKS_PUB_W
Source
1 package body jtf_tasks_pub_w as
2 /* $Header: jtfbtktb.pls 120.7 2006/04/26 04:26 knayyar ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5 rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');
6 rosetta_g_mistake_date_low date := to_date('01/01/-4710', 'MM/DD/SYYYY');
7
8 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9 function rosetta_g_miss_date_in_map(d date) return date as
10 begin
11 if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12 if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13 return d;
14 end;
15
16 procedure rosetta_table_copy_in_p6(t out nocopy jtf_tasks_pub.task_assign_tbl, a0 JTF_VARCHAR2_TABLE_100
17 , a1 JTF_NUMBER_TABLE
18 , a2 JTF_DATE_TABLE
19 , a3 JTF_DATE_TABLE
20 , a4 JTF_NUMBER_TABLE
21 , a5 JTF_VARCHAR2_TABLE_100
22 , a6 JTF_NUMBER_TABLE
23 , a7 JTF_NUMBER_TABLE
24 , a8 JTF_VARCHAR2_TABLE_100
25 , a9 JTF_NUMBER_TABLE
26 , a10 JTF_NUMBER_TABLE
27 , a11 JTF_VARCHAR2_TABLE_100
28 , a12 JTF_VARCHAR2_TABLE_100
29 , a13 JTF_VARCHAR2_TABLE_100
30 , a14 JTF_VARCHAR2_TABLE_200
31 , a15 JTF_VARCHAR2_TABLE_100
32 , a16 JTF_VARCHAR2_TABLE_100
33 , a17 JTF_VARCHAR2_TABLE_100
34 , a18 JTF_VARCHAR2_TABLE_100
35 , a19 JTF_VARCHAR2_TABLE_100
36 , a20 JTF_VARCHAR2_TABLE_100
37 , a21 JTF_NUMBER_TABLE
38 , a22 JTF_NUMBER_TABLE
39 , a23 JTF_NUMBER_TABLE
40 , a24 JTF_VARCHAR2_TABLE_100
41 , a25 JTF_NUMBER_TABLE
42 ) as
43 ddindx binary_integer; indx binary_integer;
44 begin
45 if a0 is not null and a0.count > 0 then
46 if a0.count > 0 then
47 indx := a0.first;
48 ddindx := 1;
49 while true loop
50 t(ddindx).resource_type_code := a0(indx);
51 t(ddindx).resource_id := a1(indx);
52 t(ddindx).actual_start_date := rosetta_g_miss_date_in_map(a2(indx));
53 t(ddindx).actual_end_date := rosetta_g_miss_date_in_map(a3(indx));
54 t(ddindx).actual_effort := a4(indx);
55 t(ddindx).actual_effort_uom := a5(indx);
56 t(ddindx).sched_travel_distance := a6(indx);
57 t(ddindx).sched_travel_duration := a7(indx);
58 t(ddindx).sched_travel_duration_uom := a8(indx);
59 t(ddindx).actual_travel_distance := a9(indx);
60 t(ddindx).actual_travel_duration := a10(indx);
61 t(ddindx).actual_travel_duration_uom := a11(indx);
62 t(ddindx).schedule_flag := a12(indx);
63 t(ddindx).alarm_type_code := a13(indx);
64 t(ddindx).alarm_contact := a14(indx);
65 t(ddindx).palm_flag := a15(indx);
66 t(ddindx).wince_flag := a16(indx);
67 t(ddindx).laptop_flag := a17(indx);
68 t(ddindx).device1_flag := a18(indx);
69 t(ddindx).device2_flag := a19(indx);
70 t(ddindx).device3_flag := a20(indx);
71 t(ddindx).resource_territory_id := a21(indx);
72 t(ddindx).assignment_status_id := a22(indx);
73 t(ddindx).shift_construct_id := a23(indx);
74 t(ddindx).show_on_calendar := a24(indx);
75 t(ddindx).category_id := a25(indx);
76 ddindx := ddindx+1;
77 if a0.last =indx
78 then exit;
79 end if;
80 indx := a0.next(indx);
81 end loop;
82 end if;
83 end if;
84 end rosetta_table_copy_in_p6;
85 procedure rosetta_table_copy_out_p6(t jtf_tasks_pub.task_assign_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
86 , a1 out nocopy JTF_NUMBER_TABLE
87 , a2 out nocopy JTF_DATE_TABLE
88 , a3 out nocopy JTF_DATE_TABLE
89 , a4 out nocopy JTF_NUMBER_TABLE
90 , a5 out nocopy JTF_VARCHAR2_TABLE_100
91 , a6 out nocopy JTF_NUMBER_TABLE
92 , a7 out nocopy JTF_NUMBER_TABLE
93 , a8 out nocopy JTF_VARCHAR2_TABLE_100
94 , a9 out nocopy JTF_NUMBER_TABLE
95 , a10 out nocopy JTF_NUMBER_TABLE
96 , a11 out nocopy JTF_VARCHAR2_TABLE_100
97 , a12 out nocopy JTF_VARCHAR2_TABLE_100
98 , a13 out nocopy JTF_VARCHAR2_TABLE_100
99 , a14 out nocopy JTF_VARCHAR2_TABLE_200
100 , a15 out nocopy JTF_VARCHAR2_TABLE_100
101 , a16 out nocopy JTF_VARCHAR2_TABLE_100
102 , a17 out nocopy JTF_VARCHAR2_TABLE_100
103 , a18 out nocopy JTF_VARCHAR2_TABLE_100
104 , a19 out nocopy JTF_VARCHAR2_TABLE_100
105 , a20 out nocopy JTF_VARCHAR2_TABLE_100
106 , a21 out nocopy JTF_NUMBER_TABLE
107 , a22 out nocopy JTF_NUMBER_TABLE
108 , a23 out nocopy JTF_NUMBER_TABLE
109 , a24 out nocopy JTF_VARCHAR2_TABLE_100
110 , a25 out nocopy JTF_NUMBER_TABLE
111 ) as
112 ddindx binary_integer; indx binary_integer;
113 begin
114 if t is null or t.count = 0 then
115 a0 := JTF_VARCHAR2_TABLE_100();
116 a1 := JTF_NUMBER_TABLE();
117 a2 := JTF_DATE_TABLE();
118 a3 := JTF_DATE_TABLE();
119 a4 := JTF_NUMBER_TABLE();
120 a5 := JTF_VARCHAR2_TABLE_100();
121 a6 := JTF_NUMBER_TABLE();
122 a7 := JTF_NUMBER_TABLE();
123 a8 := JTF_VARCHAR2_TABLE_100();
124 a9 := JTF_NUMBER_TABLE();
125 a10 := JTF_NUMBER_TABLE();
126 a11 := JTF_VARCHAR2_TABLE_100();
127 a12 := JTF_VARCHAR2_TABLE_100();
128 a13 := JTF_VARCHAR2_TABLE_100();
129 a14 := JTF_VARCHAR2_TABLE_200();
130 a15 := JTF_VARCHAR2_TABLE_100();
131 a16 := JTF_VARCHAR2_TABLE_100();
132 a17 := JTF_VARCHAR2_TABLE_100();
133 a18 := JTF_VARCHAR2_TABLE_100();
134 a19 := JTF_VARCHAR2_TABLE_100();
135 a20 := JTF_VARCHAR2_TABLE_100();
136 a21 := JTF_NUMBER_TABLE();
137 a22 := JTF_NUMBER_TABLE();
138 a23 := JTF_NUMBER_TABLE();
139 a24 := JTF_VARCHAR2_TABLE_100();
140 a25 := JTF_NUMBER_TABLE();
141 else
142 a0 := JTF_VARCHAR2_TABLE_100();
143 a1 := JTF_NUMBER_TABLE();
144 a2 := JTF_DATE_TABLE();
145 a3 := JTF_DATE_TABLE();
146 a4 := JTF_NUMBER_TABLE();
147 a5 := JTF_VARCHAR2_TABLE_100();
148 a6 := JTF_NUMBER_TABLE();
149 a7 := JTF_NUMBER_TABLE();
150 a8 := JTF_VARCHAR2_TABLE_100();
151 a9 := JTF_NUMBER_TABLE();
152 a10 := JTF_NUMBER_TABLE();
153 a11 := JTF_VARCHAR2_TABLE_100();
154 a12 := JTF_VARCHAR2_TABLE_100();
155 a13 := JTF_VARCHAR2_TABLE_100();
156 a14 := JTF_VARCHAR2_TABLE_200();
157 a15 := JTF_VARCHAR2_TABLE_100();
158 a16 := JTF_VARCHAR2_TABLE_100();
159 a17 := JTF_VARCHAR2_TABLE_100();
160 a18 := JTF_VARCHAR2_TABLE_100();
161 a19 := JTF_VARCHAR2_TABLE_100();
162 a20 := JTF_VARCHAR2_TABLE_100();
163 a21 := JTF_NUMBER_TABLE();
164 a22 := JTF_NUMBER_TABLE();
165 a23 := JTF_NUMBER_TABLE();
166 a24 := JTF_VARCHAR2_TABLE_100();
167 a25 := JTF_NUMBER_TABLE();
168 if t.count > 0 then
169 a0.extend(t.count);
170 a1.extend(t.count);
171 a2.extend(t.count);
172 a3.extend(t.count);
173 a4.extend(t.count);
174 a5.extend(t.count);
175 a6.extend(t.count);
176 a7.extend(t.count);
177 a8.extend(t.count);
178 a9.extend(t.count);
179 a10.extend(t.count);
180 a11.extend(t.count);
181 a12.extend(t.count);
182 a13.extend(t.count);
183 a14.extend(t.count);
184 a15.extend(t.count);
185 a16.extend(t.count);
186 a17.extend(t.count);
187 a18.extend(t.count);
188 a19.extend(t.count);
189 a20.extend(t.count);
190 a21.extend(t.count);
191 a22.extend(t.count);
192 a23.extend(t.count);
193 a24.extend(t.count);
194 a25.extend(t.count);
195 ddindx := t.first;
196 indx := 1;
197 while true loop
198 a0(indx) := t(ddindx).resource_type_code;
199 a1(indx) := t(ddindx).resource_id;
200 a2(indx) := t(ddindx).actual_start_date;
201 a3(indx) := t(ddindx).actual_end_date;
202 a4(indx) := t(ddindx).actual_effort;
203 a5(indx) := t(ddindx).actual_effort_uom;
204 a6(indx) := t(ddindx).sched_travel_distance;
205 a7(indx) := t(ddindx).sched_travel_duration;
206 a8(indx) := t(ddindx).sched_travel_duration_uom;
207 a9(indx) := t(ddindx).actual_travel_distance;
208 a10(indx) := t(ddindx).actual_travel_duration;
209 a11(indx) := t(ddindx).actual_travel_duration_uom;
210 a12(indx) := t(ddindx).schedule_flag;
211 a13(indx) := t(ddindx).alarm_type_code;
212 a14(indx) := t(ddindx).alarm_contact;
213 a15(indx) := t(ddindx).palm_flag;
214 a16(indx) := t(ddindx).wince_flag;
215 a17(indx) := t(ddindx).laptop_flag;
216 a18(indx) := t(ddindx).device1_flag;
217 a19(indx) := t(ddindx).device2_flag;
218 a20(indx) := t(ddindx).device3_flag;
219 a21(indx) := t(ddindx).resource_territory_id;
220 a22(indx) := t(ddindx).assignment_status_id;
221 a23(indx) := t(ddindx).shift_construct_id;
222 a24(indx) := t(ddindx).show_on_calendar;
223 a25(indx) := t(ddindx).category_id;
224 indx := indx+1;
225 if t.last =ddindx
226 then exit;
227 end if;
228 ddindx := t.next(ddindx);
229 end loop;
230 end if;
231 end if;
232 end rosetta_table_copy_out_p6;
233
234 procedure rosetta_table_copy_in_p9(t out nocopy jtf_tasks_pub.task_depends_tbl, a0 JTF_NUMBER_TABLE
235 , a1 JTF_NUMBER_TABLE
236 , a2 JTF_VARCHAR2_TABLE_100
237 , a3 JTF_NUMBER_TABLE
238 , a4 JTF_VARCHAR2_TABLE_100
239 , a5 JTF_VARCHAR2_TABLE_100
240 ) as
241 ddindx binary_integer; indx binary_integer;
242 begin
243 if a0 is not null and a0.count > 0 then
244 if a0.count > 0 then
245 indx := a0.first;
246 ddindx := 1;
247 while true loop
248 t(ddindx).dependent_on_task_id := a0(indx);
249 t(ddindx).dependent_on_task_number := a1(indx);
250 t(ddindx).dependency_type_code := a2(indx);
251 t(ddindx).adjustment_time := a3(indx);
252 t(ddindx).adjustment_time_uom := a4(indx);
253 t(ddindx).validated_flag := a5(indx);
254 ddindx := ddindx+1;
255 if a0.last =indx
256 then exit;
257 end if;
258 indx := a0.next(indx);
259 end loop;
260 end if;
261 end if;
262 end rosetta_table_copy_in_p9;
263 procedure rosetta_table_copy_out_p9(t jtf_tasks_pub.task_depends_tbl, a0 out nocopy JTF_NUMBER_TABLE
264 , a1 out nocopy JTF_NUMBER_TABLE
265 , a2 out nocopy JTF_VARCHAR2_TABLE_100
266 , a3 out nocopy JTF_NUMBER_TABLE
267 , a4 out nocopy JTF_VARCHAR2_TABLE_100
268 , a5 out nocopy JTF_VARCHAR2_TABLE_100
269 ) as
270 ddindx binary_integer; indx binary_integer;
271 begin
272 if t is null or t.count = 0 then
273 a0 := JTF_NUMBER_TABLE();
274 a1 := JTF_NUMBER_TABLE();
275 a2 := JTF_VARCHAR2_TABLE_100();
276 a3 := JTF_NUMBER_TABLE();
277 a4 := JTF_VARCHAR2_TABLE_100();
278 a5 := JTF_VARCHAR2_TABLE_100();
279 else
280 a0 := JTF_NUMBER_TABLE();
281 a1 := JTF_NUMBER_TABLE();
282 a2 := JTF_VARCHAR2_TABLE_100();
283 a3 := JTF_NUMBER_TABLE();
284 a4 := JTF_VARCHAR2_TABLE_100();
285 a5 := JTF_VARCHAR2_TABLE_100();
286 if t.count > 0 then
287 a0.extend(t.count);
288 a1.extend(t.count);
289 a2.extend(t.count);
290 a3.extend(t.count);
291 a4.extend(t.count);
292 a5.extend(t.count);
293 ddindx := t.first;
294 indx := 1;
295 while true loop
296 a0(indx) := t(ddindx).dependent_on_task_id;
297 a1(indx) := t(ddindx).dependent_on_task_number;
298 a2(indx) := t(ddindx).dependency_type_code;
299 a3(indx) := t(ddindx).adjustment_time;
300 a4(indx) := t(ddindx).adjustment_time_uom;
301 a5(indx) := t(ddindx).validated_flag;
302 indx := indx+1;
303 if t.last =ddindx
304 then exit;
305 end if;
306 ddindx := t.next(ddindx);
307 end loop;
308 end if;
309 end if;
310 end rosetta_table_copy_out_p9;
311
312 procedure rosetta_table_copy_in_p12(t out nocopy jtf_tasks_pub.task_rsrc_req_tbl, a0 JTF_VARCHAR2_TABLE_100
313 , a1 JTF_NUMBER_TABLE
314 , a2 JTF_VARCHAR2_TABLE_100
315 ) as
316 ddindx binary_integer; indx binary_integer;
317 begin
318 if a0 is not null and a0.count > 0 then
319 if a0.count > 0 then
320 indx := a0.first;
321 ddindx := 1;
322 while true loop
323 t(ddindx).resource_type_code := a0(indx);
324 t(ddindx).required_units := a1(indx);
325 t(ddindx).enabled_flag := a2(indx);
326 ddindx := ddindx+1;
327 if a0.last =indx
328 then exit;
329 end if;
330 indx := a0.next(indx);
331 end loop;
332 end if;
333 end if;
334 end rosetta_table_copy_in_p12;
335 procedure rosetta_table_copy_out_p12(t jtf_tasks_pub.task_rsrc_req_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
336 , a1 out nocopy JTF_NUMBER_TABLE
337 , a2 out nocopy JTF_VARCHAR2_TABLE_100
338 ) as
339 ddindx binary_integer; indx binary_integer;
340 begin
341 if t is null or t.count = 0 then
342 a0 := JTF_VARCHAR2_TABLE_100();
343 a1 := JTF_NUMBER_TABLE();
344 a2 := JTF_VARCHAR2_TABLE_100();
345 else
346 a0 := JTF_VARCHAR2_TABLE_100();
347 a1 := JTF_NUMBER_TABLE();
348 a2 := JTF_VARCHAR2_TABLE_100();
349 if t.count > 0 then
350 a0.extend(t.count);
351 a1.extend(t.count);
352 a2.extend(t.count);
353 ddindx := t.first;
354 indx := 1;
355 while true loop
356 a0(indx) := t(ddindx).resource_type_code;
357 a1(indx) := t(ddindx).required_units;
358 a2(indx) := t(ddindx).enabled_flag;
359 indx := indx+1;
360 if t.last =ddindx
361 then exit;
362 end if;
363 ddindx := t.next(ddindx);
364 end loop;
365 end if;
366 end if;
367 end rosetta_table_copy_out_p12;
368
369 procedure rosetta_table_copy_in_p15(t out nocopy jtf_tasks_pub.task_refer_tbl, a0 JTF_VARCHAR2_TABLE_100
370 , a1 JTF_VARCHAR2_TABLE_100
371 , a2 JTF_VARCHAR2_TABLE_100
372 , a3 JTF_NUMBER_TABLE
373 , a4 JTF_VARCHAR2_TABLE_2000
374 , a5 JTF_VARCHAR2_TABLE_100
375 , a6 JTF_VARCHAR2_TABLE_2000
376 ) as
377 ddindx binary_integer; indx binary_integer;
378 begin
379 if a0 is not null and a0.count > 0 then
380 if a0.count > 0 then
381 indx := a0.first;
382 ddindx := 1;
383 while true loop
384 t(ddindx).object_type_code := a0(indx);
385 t(ddindx).object_type_name := a1(indx);
386 t(ddindx).object_name := a2(indx);
387 t(ddindx).object_id := a3(indx);
388 t(ddindx).object_details := a4(indx);
392 if a0.last =indx
389 t(ddindx).reference_code := a5(indx);
390 t(ddindx).usage := a6(indx);
391 ddindx := ddindx+1;
393 then exit;
394 end if;
395 indx := a0.next(indx);
396 end loop;
397 end if;
398 end if;
399 end rosetta_table_copy_in_p15;
400 procedure rosetta_table_copy_out_p15(t jtf_tasks_pub.task_refer_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
401 , a1 out nocopy JTF_VARCHAR2_TABLE_100
402 , a2 out nocopy JTF_VARCHAR2_TABLE_100
403 , a3 out nocopy JTF_NUMBER_TABLE
404 , a4 out nocopy JTF_VARCHAR2_TABLE_2000
405 , a5 out nocopy JTF_VARCHAR2_TABLE_100
406 , a6 out nocopy JTF_VARCHAR2_TABLE_2000
407 ) as
408 ddindx binary_integer; indx binary_integer;
409 begin
410 if t is null or t.count = 0 then
411 a0 := JTF_VARCHAR2_TABLE_100();
412 a1 := JTF_VARCHAR2_TABLE_100();
413 a2 := JTF_VARCHAR2_TABLE_100();
414 a3 := JTF_NUMBER_TABLE();
415 a4 := JTF_VARCHAR2_TABLE_2000();
416 a5 := JTF_VARCHAR2_TABLE_100();
417 a6 := JTF_VARCHAR2_TABLE_2000();
418 else
419 a0 := JTF_VARCHAR2_TABLE_100();
420 a1 := JTF_VARCHAR2_TABLE_100();
421 a2 := JTF_VARCHAR2_TABLE_100();
422 a3 := JTF_NUMBER_TABLE();
423 a4 := JTF_VARCHAR2_TABLE_2000();
424 a5 := JTF_VARCHAR2_TABLE_100();
425 a6 := JTF_VARCHAR2_TABLE_2000();
426 if t.count > 0 then
427 a0.extend(t.count);
428 a1.extend(t.count);
429 a2.extend(t.count);
430 a3.extend(t.count);
431 a4.extend(t.count);
432 a5.extend(t.count);
433 a6.extend(t.count);
434 ddindx := t.first;
435 indx := 1;
436 while true loop
437 a0(indx) := t(ddindx).object_type_code;
438 a1(indx) := t(ddindx).object_type_name;
439 a2(indx) := t(ddindx).object_name;
440 a3(indx) := t(ddindx).object_id;
441 a4(indx) := t(ddindx).object_details;
442 a5(indx) := t(ddindx).reference_code;
443 a6(indx) := t(ddindx).usage;
444 indx := indx+1;
445 if t.last =ddindx
446 then exit;
447 end if;
448 ddindx := t.next(ddindx);
449 end loop;
450 end if;
451 end if;
452 end rosetta_table_copy_out_p15;
453
454 procedure rosetta_table_copy_in_p20(t out nocopy jtf_tasks_pub.task_dates_tbl, a0 JTF_NUMBER_TABLE
455 , a1 JTF_VARCHAR2_TABLE_100
456 , a2 JTF_VARCHAR2_TABLE_100
457 , a3 JTF_DATE_TABLE
458 ) as
459 ddindx binary_integer; indx binary_integer;
460 begin
461 if a0 is not null and a0.count > 0 then
462 if a0.count > 0 then
463 indx := a0.first;
464 ddindx := 1;
465 while true loop
466 t(ddindx).date_type_id := a0(indx);
467 t(ddindx).date_type_name := a1(indx);
468 t(ddindx).date_type := a2(indx);
469 t(ddindx).date_value := rosetta_g_miss_date_in_map(a3(indx));
470 ddindx := ddindx+1;
471 if a0.last =indx
472 then exit;
473 end if;
474 indx := a0.next(indx);
475 end loop;
476 end if;
477 end if;
478 end rosetta_table_copy_in_p20;
479 procedure rosetta_table_copy_out_p20(t jtf_tasks_pub.task_dates_tbl, a0 out nocopy JTF_NUMBER_TABLE
480 , a1 out nocopy JTF_VARCHAR2_TABLE_100
481 , a2 out nocopy JTF_VARCHAR2_TABLE_100
482 , a3 out nocopy JTF_DATE_TABLE
483 ) as
484 ddindx binary_integer; indx binary_integer;
485 begin
486 if t is null or t.count = 0 then
487 a0 := JTF_NUMBER_TABLE();
488 a1 := JTF_VARCHAR2_TABLE_100();
489 a2 := JTF_VARCHAR2_TABLE_100();
490 a3 := JTF_DATE_TABLE();
491 else
492 a0 := JTF_NUMBER_TABLE();
493 a1 := JTF_VARCHAR2_TABLE_100();
494 a2 := JTF_VARCHAR2_TABLE_100();
495 a3 := JTF_DATE_TABLE();
496 if t.count > 0 then
497 a0.extend(t.count);
498 a1.extend(t.count);
499 a2.extend(t.count);
500 a3.extend(t.count);
501 ddindx := t.first;
502 indx := 1;
503 while true loop
504 a0(indx) := t(ddindx).date_type_id;
505 a1(indx) := t(ddindx).date_type_name;
506 a2(indx) := t(ddindx).date_type;
507 a3(indx) := t(ddindx).date_value;
508 indx := indx+1;
509 if t.last =ddindx
510 then exit;
511 end if;
512 ddindx := t.next(ddindx);
513 end loop;
514 end if;
515 end if;
516 end rosetta_table_copy_out_p20;
517
518 procedure rosetta_table_copy_in_p23(t out nocopy jtf_tasks_pub.task_notes_tbl, a0 JTF_NUMBER_TABLE
519 , a1 JTF_NUMBER_TABLE
520 , a2 JTF_VARCHAR2_TABLE_4000
521 , a3 JTF_VARCHAR2_TABLE_32767
522 , a4 JTF_VARCHAR2_TABLE_100
523 , a5 JTF_NUMBER_TABLE
524 , a6 JTF_DATE_TABLE
525 , a7 JTF_VARCHAR2_TABLE_100
526 , a8 JTF_NUMBER_TABLE
527 , a9 JTF_VARCHAR2_TABLE_200
528 , a10 JTF_VARCHAR2_TABLE_200
529 , a11 JTF_VARCHAR2_TABLE_200
530 , a12 JTF_VARCHAR2_TABLE_200
531 , a13 JTF_VARCHAR2_TABLE_200
532 , a14 JTF_VARCHAR2_TABLE_200
533 , a15 JTF_VARCHAR2_TABLE_200
537 , a19 JTF_VARCHAR2_TABLE_200
534 , a16 JTF_VARCHAR2_TABLE_200
535 , a17 JTF_VARCHAR2_TABLE_200
536 , a18 JTF_VARCHAR2_TABLE_200
538 , a20 JTF_VARCHAR2_TABLE_200
539 , a21 JTF_VARCHAR2_TABLE_200
540 , a22 JTF_VARCHAR2_TABLE_200
541 , a23 JTF_VARCHAR2_TABLE_200
542 , a24 JTF_VARCHAR2_TABLE_100
543 ) as
544 ddindx binary_integer; indx binary_integer;
545 begin
546 if a0 is not null and a0.count > 0 then
547 if a0.count > 0 then
548 indx := a0.first;
549 ddindx := 1;
550 while true loop
551 t(ddindx).parent_note_id := a0(indx);
552 t(ddindx).org_id := a1(indx);
553 t(ddindx).notes := a2(indx);
554 t(ddindx).notes_detail := a3(indx);
555 t(ddindx).note_status := a4(indx);
556 t(ddindx).entered_by := a5(indx);
557 t(ddindx).entered_date := rosetta_g_miss_date_in_map(a6(indx));
558 t(ddindx).note_type := a7(indx);
559 t(ddindx).jtf_note_id := a8(indx);
560 t(ddindx).attribute1 := a9(indx);
561 t(ddindx).attribute2 := a10(indx);
562 t(ddindx).attribute3 := a11(indx);
563 t(ddindx).attribute4 := a12(indx);
564 t(ddindx).attribute5 := a13(indx);
565 t(ddindx).attribute6 := a14(indx);
566 t(ddindx).attribute7 := a15(indx);
567 t(ddindx).attribute8 := a16(indx);
568 t(ddindx).attribute9 := a17(indx);
569 t(ddindx).attribute10 := a18(indx);
570 t(ddindx).attribute11 := a19(indx);
571 t(ddindx).attribute12 := a20(indx);
572 t(ddindx).attribute13 := a21(indx);
573 t(ddindx).attribute14 := a22(indx);
574 t(ddindx).attribute15 := a23(indx);
575 t(ddindx).context := a24(indx);
576 ddindx := ddindx+1;
577 if a0.last =indx
578 then exit;
579 end if;
580 indx := a0.next(indx);
581 end loop;
582 end if;
583 end if;
584 end rosetta_table_copy_in_p23;
585 procedure rosetta_table_copy_out_p23(t jtf_tasks_pub.task_notes_tbl, a0 out nocopy JTF_NUMBER_TABLE
586 , a1 out nocopy JTF_NUMBER_TABLE
587 , a2 out nocopy JTF_VARCHAR2_TABLE_4000
588 , a3 out nocopy JTF_VARCHAR2_TABLE_32767
589 , a4 out nocopy JTF_VARCHAR2_TABLE_100
590 , a5 out nocopy JTF_NUMBER_TABLE
591 , a6 out nocopy JTF_DATE_TABLE
592 , a7 out nocopy JTF_VARCHAR2_TABLE_100
593 , a8 out nocopy JTF_NUMBER_TABLE
594 , a9 out nocopy JTF_VARCHAR2_TABLE_200
595 , a10 out nocopy JTF_VARCHAR2_TABLE_200
596 , a11 out nocopy JTF_VARCHAR2_TABLE_200
597 , a12 out nocopy JTF_VARCHAR2_TABLE_200
598 , a13 out nocopy JTF_VARCHAR2_TABLE_200
599 , a14 out nocopy JTF_VARCHAR2_TABLE_200
600 , a15 out nocopy JTF_VARCHAR2_TABLE_200
601 , a16 out nocopy JTF_VARCHAR2_TABLE_200
602 , a17 out nocopy JTF_VARCHAR2_TABLE_200
603 , a18 out nocopy JTF_VARCHAR2_TABLE_200
604 , a19 out nocopy JTF_VARCHAR2_TABLE_200
605 , a20 out nocopy JTF_VARCHAR2_TABLE_200
606 , a21 out nocopy JTF_VARCHAR2_TABLE_200
607 , a22 out nocopy JTF_VARCHAR2_TABLE_200
608 , a23 out nocopy JTF_VARCHAR2_TABLE_200
609 , a24 out nocopy JTF_VARCHAR2_TABLE_100
610 ) as
611 ddindx binary_integer; indx binary_integer;
612 begin
613 if t is null or t.count = 0 then
614 a0 := JTF_NUMBER_TABLE();
615 a1 := JTF_NUMBER_TABLE();
616 a2 := JTF_VARCHAR2_TABLE_4000();
617 a3 := JTF_VARCHAR2_TABLE_32767();
618 a4 := JTF_VARCHAR2_TABLE_100();
619 a5 := JTF_NUMBER_TABLE();
620 a6 := JTF_DATE_TABLE();
621 a7 := JTF_VARCHAR2_TABLE_100();
622 a8 := JTF_NUMBER_TABLE();
623 a9 := JTF_VARCHAR2_TABLE_200();
624 a10 := JTF_VARCHAR2_TABLE_200();
625 a11 := JTF_VARCHAR2_TABLE_200();
626 a12 := JTF_VARCHAR2_TABLE_200();
627 a13 := JTF_VARCHAR2_TABLE_200();
628 a14 := JTF_VARCHAR2_TABLE_200();
629 a15 := JTF_VARCHAR2_TABLE_200();
630 a16 := JTF_VARCHAR2_TABLE_200();
631 a17 := JTF_VARCHAR2_TABLE_200();
632 a18 := JTF_VARCHAR2_TABLE_200();
633 a19 := JTF_VARCHAR2_TABLE_200();
634 a20 := JTF_VARCHAR2_TABLE_200();
635 a21 := JTF_VARCHAR2_TABLE_200();
636 a22 := JTF_VARCHAR2_TABLE_200();
637 a23 := JTF_VARCHAR2_TABLE_200();
638 a24 := JTF_VARCHAR2_TABLE_100();
639 else
640 a0 := JTF_NUMBER_TABLE();
641 a1 := JTF_NUMBER_TABLE();
642 a2 := JTF_VARCHAR2_TABLE_4000();
643 a3 := JTF_VARCHAR2_TABLE_32767();
644 a4 := JTF_VARCHAR2_TABLE_100();
645 a5 := JTF_NUMBER_TABLE();
646 a6 := JTF_DATE_TABLE();
647 a7 := JTF_VARCHAR2_TABLE_100();
648 a8 := JTF_NUMBER_TABLE();
649 a9 := JTF_VARCHAR2_TABLE_200();
650 a10 := JTF_VARCHAR2_TABLE_200();
651 a11 := JTF_VARCHAR2_TABLE_200();
652 a12 := JTF_VARCHAR2_TABLE_200();
653 a13 := JTF_VARCHAR2_TABLE_200();
657 a17 := JTF_VARCHAR2_TABLE_200();
654 a14 := JTF_VARCHAR2_TABLE_200();
655 a15 := JTF_VARCHAR2_TABLE_200();
656 a16 := JTF_VARCHAR2_TABLE_200();
658 a18 := JTF_VARCHAR2_TABLE_200();
659 a19 := JTF_VARCHAR2_TABLE_200();
660 a20 := JTF_VARCHAR2_TABLE_200();
661 a21 := JTF_VARCHAR2_TABLE_200();
662 a22 := JTF_VARCHAR2_TABLE_200();
663 a23 := JTF_VARCHAR2_TABLE_200();
664 a24 := JTF_VARCHAR2_TABLE_100();
665 if t.count > 0 then
666 a0.extend(t.count);
667 a1.extend(t.count);
668 a2.extend(t.count);
669 a3.extend(t.count);
670 a4.extend(t.count);
671 a5.extend(t.count);
672 a6.extend(t.count);
673 a7.extend(t.count);
674 a8.extend(t.count);
675 a9.extend(t.count);
676 a10.extend(t.count);
677 a11.extend(t.count);
678 a12.extend(t.count);
679 a13.extend(t.count);
680 a14.extend(t.count);
681 a15.extend(t.count);
682 a16.extend(t.count);
683 a17.extend(t.count);
684 a18.extend(t.count);
685 a19.extend(t.count);
686 a20.extend(t.count);
687 a21.extend(t.count);
688 a22.extend(t.count);
689 a23.extend(t.count);
690 a24.extend(t.count);
691 ddindx := t.first;
692 indx := 1;
693 while true loop
694 a0(indx) := t(ddindx).parent_note_id;
695 a1(indx) := t(ddindx).org_id;
696 a2(indx) := t(ddindx).notes;
697 a3(indx) := t(ddindx).notes_detail;
698 a4(indx) := t(ddindx).note_status;
699 a5(indx) := t(ddindx).entered_by;
700 a6(indx) := t(ddindx).entered_date;
701 a7(indx) := t(ddindx).note_type;
702 a8(indx) := t(ddindx).jtf_note_id;
703 a9(indx) := t(ddindx).attribute1;
704 a10(indx) := t(ddindx).attribute2;
705 a11(indx) := t(ddindx).attribute3;
706 a12(indx) := t(ddindx).attribute4;
707 a13(indx) := t(ddindx).attribute5;
708 a14(indx) := t(ddindx).attribute6;
709 a15(indx) := t(ddindx).attribute7;
710 a16(indx) := t(ddindx).attribute8;
711 a17(indx) := t(ddindx).attribute9;
712 a18(indx) := t(ddindx).attribute10;
713 a19(indx) := t(ddindx).attribute11;
714 a20(indx) := t(ddindx).attribute12;
715 a21(indx) := t(ddindx).attribute13;
716 a22(indx) := t(ddindx).attribute14;
717 a23(indx) := t(ddindx).attribute15;
718 a24(indx) := t(ddindx).context;
719 indx := indx+1;
720 if t.last =ddindx
721 then exit;
722 end if;
723 ddindx := t.next(ddindx);
724 end loop;
725 end if;
726 end if;
727 end rosetta_table_copy_out_p23;
728
729 procedure rosetta_table_copy_in_p26(t out nocopy jtf_tasks_pub.task_contacts_tbl, a0 JTF_NUMBER_TABLE
730 , a1 JTF_VARCHAR2_TABLE_100
731 , a2 JTF_VARCHAR2_TABLE_100
732 , a3 JTF_VARCHAR2_TABLE_100
733 ) as
734 ddindx binary_integer; indx binary_integer;
735 begin
736 if a0 is not null and a0.count > 0 then
737 if a0.count > 0 then
738 indx := a0.first;
739 ddindx := 1;
740 while true loop
741 t(ddindx).contact_id := a0(indx);
742 t(ddindx).contact_type_code := a1(indx);
743 t(ddindx).escalation_notify_flag := a2(indx);
744 t(ddindx).escalation_requester_flag := a3(indx);
745 ddindx := ddindx+1;
746 if a0.last =indx
747 then exit;
748 end if;
749 indx := a0.next(indx);
750 end loop;
751 end if;
752 end if;
753 end rosetta_table_copy_in_p26;
754 procedure rosetta_table_copy_out_p26(t jtf_tasks_pub.task_contacts_tbl, a0 out nocopy JTF_NUMBER_TABLE
755 , a1 out nocopy JTF_VARCHAR2_TABLE_100
756 , a2 out nocopy JTF_VARCHAR2_TABLE_100
757 , a3 out nocopy JTF_VARCHAR2_TABLE_100
758 ) as
759 ddindx binary_integer; indx binary_integer;
760 begin
761 if t is null or t.count = 0 then
762 a0 := JTF_NUMBER_TABLE();
763 a1 := JTF_VARCHAR2_TABLE_100();
764 a2 := JTF_VARCHAR2_TABLE_100();
765 a3 := JTF_VARCHAR2_TABLE_100();
766 else
767 a0 := JTF_NUMBER_TABLE();
768 a1 := JTF_VARCHAR2_TABLE_100();
769 a2 := JTF_VARCHAR2_TABLE_100();
770 a3 := JTF_VARCHAR2_TABLE_100();
771 if t.count > 0 then
772 a0.extend(t.count);
773 a1.extend(t.count);
774 a2.extend(t.count);
775 a3.extend(t.count);
776 ddindx := t.first;
777 indx := 1;
778 while true loop
779 a0(indx) := t(ddindx).contact_id;
780 a1(indx) := t(ddindx).contact_type_code;
781 a2(indx) := t(ddindx).escalation_notify_flag;
782 a3(indx) := t(ddindx).escalation_requester_flag;
783 indx := indx+1;
784 if t.last =ddindx
785 then exit;
786 end if;
787 ddindx := t.next(ddindx);
788 end loop;
789 end if;
790 end if;
791 end rosetta_table_copy_out_p26;
792
796 , a3 JTF_VARCHAR2_TABLE_4000
793 procedure rosetta_table_copy_in_p31(t out nocopy jtf_tasks_pub.task_table_type, a0 JTF_NUMBER_TABLE
794 , a1 JTF_VARCHAR2_TABLE_100
795 , a2 JTF_VARCHAR2_TABLE_100
797 , a4 JTF_NUMBER_TABLE
798 , a5 JTF_VARCHAR2_TABLE_100
799 , a6 JTF_NUMBER_TABLE
800 , a7 JTF_VARCHAR2_TABLE_100
801 , a8 JTF_NUMBER_TABLE
802 , a9 JTF_VARCHAR2_TABLE_100
803 , a10 JTF_VARCHAR2_TABLE_100
804 , a11 JTF_NUMBER_TABLE
805 , a12 JTF_VARCHAR2_TABLE_4000
806 , a13 JTF_NUMBER_TABLE
807 , a14 JTF_VARCHAR2_TABLE_4000
808 , a15 JTF_NUMBER_TABLE
809 , a16 JTF_VARCHAR2_TABLE_400
810 , a17 JTF_VARCHAR2_TABLE_100
811 , a18 JTF_VARCHAR2_TABLE_100
812 , a19 JTF_NUMBER_TABLE
813 , a20 JTF_NUMBER_TABLE
814 , a21 JTF_DATE_TABLE
815 , a22 JTF_DATE_TABLE
816 , a23 JTF_DATE_TABLE
817 , a24 JTF_DATE_TABLE
818 , a25 JTF_DATE_TABLE
819 , a26 JTF_DATE_TABLE
820 , a27 JTF_VARCHAR2_TABLE_100
821 , a28 JTF_NUMBER_TABLE
822 , a29 JTF_VARCHAR2_TABLE_100
823 , a30 JTF_NUMBER_TABLE
824 , a31 JTF_VARCHAR2_TABLE_100
825 , a32 JTF_NUMBER_TABLE
826 , a33 JTF_VARCHAR2_TABLE_100
827 , a34 JTF_NUMBER_TABLE
828 , a35 JTF_VARCHAR2_TABLE_100
829 , a36 JTF_NUMBER_TABLE
830 , a37 JTF_VARCHAR2_TABLE_100
831 , a38 JTF_VARCHAR2_TABLE_100
832 , a39 JTF_VARCHAR2_TABLE_100
833 , a40 JTF_VARCHAR2_TABLE_100
834 , a41 JTF_VARCHAR2_TABLE_100
835 , a42 JTF_VARCHAR2_TABLE_100
836 , a43 JTF_NUMBER_TABLE
837 , a44 JTF_VARCHAR2_TABLE_100
838 , a45 JTF_NUMBER_TABLE
839 , a46 JTF_VARCHAR2_TABLE_100
840 , a47 JTF_NUMBER_TABLE
841 , a48 JTF_NUMBER_TABLE
842 , a49 JTF_VARCHAR2_TABLE_100
843 , a50 JTF_VARCHAR2_TABLE_100
844 , a51 JTF_NUMBER_TABLE
845 , a52 JTF_NUMBER_TABLE
846 , a53 JTF_NUMBER_TABLE
847 , a54 JTF_VARCHAR2_TABLE_100
848 , a55 JTF_VARCHAR2_TABLE_200
849 , a56 JTF_VARCHAR2_TABLE_200
850 , a57 JTF_VARCHAR2_TABLE_200
851 , a58 JTF_VARCHAR2_TABLE_200
852 , a59 JTF_VARCHAR2_TABLE_200
853 , a60 JTF_VARCHAR2_TABLE_200
854 , a61 JTF_VARCHAR2_TABLE_200
855 , a62 JTF_VARCHAR2_TABLE_200
856 , a63 JTF_VARCHAR2_TABLE_200
857 , a64 JTF_VARCHAR2_TABLE_200
858 , a65 JTF_VARCHAR2_TABLE_200
859 , a66 JTF_VARCHAR2_TABLE_200
860 , a67 JTF_VARCHAR2_TABLE_200
861 , a68 JTF_VARCHAR2_TABLE_200
862 , a69 JTF_VARCHAR2_TABLE_200
863 , a70 JTF_VARCHAR2_TABLE_200
864 , a71 JTF_NUMBER_TABLE
865 , a72 JTF_DATE_TABLE
866 , a73 JTF_VARCHAR2_TABLE_4000
867 , a74 JTF_NUMBER_TABLE
868 , a75 JTF_DATE_TABLE
869 , a76 JTF_DATE_TABLE
870 , a77 JTF_VARCHAR2_TABLE_100
871 , a78 JTF_VARCHAR2_TABLE_100
872 , a79 JTF_VARCHAR2_TABLE_100
873 , a80 JTF_NUMBER_TABLE
874 , a81 JTF_NUMBER_TABLE
875 ) as
876 ddindx binary_integer; indx binary_integer;
877 begin
878 if a0 is not null and a0.count > 0 then
879 if a0.count > 0 then
880 indx := a0.first;
881 ddindx := 1;
882 while true loop
883 t(ddindx).task_id := a0(indx);
884 t(ddindx).task_number := a1(indx);
885 t(ddindx).task_name := a2(indx);
886 t(ddindx).description := a3(indx);
887 t(ddindx).task_type_id := a4(indx);
888 t(ddindx).task_type := a5(indx);
889 t(ddindx).task_status_id := a6(indx);
890 t(ddindx).task_status := a7(indx);
891 t(ddindx).task_priority_id := a8(indx);
892 t(ddindx).task_priority := a9(indx);
893 t(ddindx).owner_type_code := a10(indx);
894 t(ddindx).owner_id := a11(indx);
895 t(ddindx).owner := a12(indx);
896 t(ddindx).assigned_by_id := a13(indx);
897 t(ddindx).assigned_by_name := a14(indx);
898 t(ddindx).customer_id := a15(indx);
899 t(ddindx).customer_name := a16(indx);
900 t(ddindx).customer_number := a17(indx);
901 t(ddindx).cust_account_number := a18(indx);
902 t(ddindx).cust_account_id := a19(indx);
903 t(ddindx).address_id := a20(indx);
904 t(ddindx).planned_start_date := rosetta_g_miss_date_in_map(a21(indx));
905 t(ddindx).planned_end_date := rosetta_g_miss_date_in_map(a22(indx));
906 t(ddindx).scheduled_start_date := rosetta_g_miss_date_in_map(a23(indx));
907 t(ddindx).scheduled_end_date := rosetta_g_miss_date_in_map(a24(indx));
908 t(ddindx).actual_start_date := rosetta_g_miss_date_in_map(a25(indx));
909 t(ddindx).actual_end_date := rosetta_g_miss_date_in_map(a26(indx));
910 t(ddindx).object_type_code := a27(indx);
911 t(ddindx).object_id := a28(indx);
912 t(ddindx).obect_name := a29(indx);
913 t(ddindx).duration := a30(indx);
914 t(ddindx).duration_uom := a31(indx);
915 t(ddindx).planned_effort := a32(indx);
916 t(ddindx).planned_effort_uom := a33(indx);
920 t(ddindx).reason_code := a37(indx);
917 t(ddindx).actual_effort := a34(indx);
918 t(ddindx).actual_effort_uom := a35(indx);
919 t(ddindx).percentage_complete := a36(indx);
921 t(ddindx).private_flag := a38(indx);
922 t(ddindx).publish_flag := a39(indx);
923 t(ddindx).multi_booked_flag := a40(indx);
924 t(ddindx).milestone_flag := a41(indx);
925 t(ddindx).holiday_flag := a42(indx);
926 t(ddindx).workflow_process_id := a43(indx);
927 t(ddindx).notification_flag := a44(indx);
928 t(ddindx).notification_period := a45(indx);
929 t(ddindx).notification_period_uom := a46(indx);
930 t(ddindx).parent_task_id := a47(indx);
931 t(ddindx).alarm_start := a48(indx);
932 t(ddindx).alarm_start_uom := a49(indx);
933 t(ddindx).alarm_on := a50(indx);
934 t(ddindx).alarm_count := a51(indx);
935 t(ddindx).alarm_fired_count := a52(indx);
936 t(ddindx).alarm_interval := a53(indx);
937 t(ddindx).alarm_interval_uom := a54(indx);
938 t(ddindx).attribute1 := a55(indx);
939 t(ddindx).attribute2 := a56(indx);
940 t(ddindx).attribute3 := a57(indx);
941 t(ddindx).attribute4 := a58(indx);
942 t(ddindx).attribute5 := a59(indx);
943 t(ddindx).attribute6 := a60(indx);
944 t(ddindx).attribute7 := a61(indx);
945 t(ddindx).attribute8 := a62(indx);
946 t(ddindx).attribute9 := a63(indx);
947 t(ddindx).attribute10 := a64(indx);
948 t(ddindx).attribute11 := a65(indx);
949 t(ddindx).attribute12 := a66(indx);
950 t(ddindx).attribute13 := a67(indx);
951 t(ddindx).attribute14 := a68(indx);
952 t(ddindx).attribute15 := a69(indx);
953 t(ddindx).attribute_category := a70(indx);
954 t(ddindx).owner_territory_id := a71(indx);
955 t(ddindx).creation_date := rosetta_g_miss_date_in_map(a72(indx));
956 t(ddindx).escalation_level := a73(indx);
957 t(ddindx).object_version_number := a74(indx);
958 t(ddindx).calendar_start_date := rosetta_g_miss_date_in_map(a75(indx));
959 t(ddindx).calendar_end_date := rosetta_g_miss_date_in_map(a76(indx));
960 t(ddindx).date_selected := a77(indx);
961 t(ddindx).task_split_flag := a78(indx);
962 t(ddindx).child_position := a79(indx);
963 t(ddindx).child_sequence_num := a80(indx);
964 t(ddindx).location_id := a81(indx);
965 ddindx := ddindx+1;
966 if a0.last =indx
967 then exit;
968 end if;
969 indx := a0.next(indx);
970 end loop;
971 end if;
972 end if;
973 end rosetta_table_copy_in_p31;
974 procedure rosetta_table_copy_out_p31(t jtf_tasks_pub.task_table_type, a0 out nocopy JTF_NUMBER_TABLE
975 , a1 out nocopy JTF_VARCHAR2_TABLE_100
976 , a2 out nocopy JTF_VARCHAR2_TABLE_100
977 , a3 out nocopy JTF_VARCHAR2_TABLE_4000
978 , a4 out nocopy JTF_NUMBER_TABLE
979 , a5 out nocopy JTF_VARCHAR2_TABLE_100
980 , a6 out nocopy JTF_NUMBER_TABLE
981 , a7 out nocopy JTF_VARCHAR2_TABLE_100
982 , a8 out nocopy JTF_NUMBER_TABLE
983 , a9 out nocopy JTF_VARCHAR2_TABLE_100
984 , a10 out nocopy JTF_VARCHAR2_TABLE_100
985 , a11 out nocopy JTF_NUMBER_TABLE
986 , a12 out nocopy JTF_VARCHAR2_TABLE_4000
987 , a13 out nocopy JTF_NUMBER_TABLE
988 , a14 out nocopy JTF_VARCHAR2_TABLE_4000
989 , a15 out nocopy JTF_NUMBER_TABLE
990 , a16 out nocopy JTF_VARCHAR2_TABLE_400
991 , a17 out nocopy JTF_VARCHAR2_TABLE_100
992 , a18 out nocopy JTF_VARCHAR2_TABLE_100
993 , a19 out nocopy JTF_NUMBER_TABLE
994 , a20 out nocopy JTF_NUMBER_TABLE
995 , a21 out nocopy JTF_DATE_TABLE
996 , a22 out nocopy JTF_DATE_TABLE
997 , a23 out nocopy JTF_DATE_TABLE
998 , a24 out nocopy JTF_DATE_TABLE
999 , a25 out nocopy JTF_DATE_TABLE
1000 , a26 out nocopy JTF_DATE_TABLE
1001 , a27 out nocopy JTF_VARCHAR2_TABLE_100
1002 , a28 out nocopy JTF_NUMBER_TABLE
1003 , a29 out nocopy JTF_VARCHAR2_TABLE_100
1004 , a30 out nocopy JTF_NUMBER_TABLE
1005 , a31 out nocopy JTF_VARCHAR2_TABLE_100
1006 , a32 out nocopy JTF_NUMBER_TABLE
1007 , a33 out nocopy JTF_VARCHAR2_TABLE_100
1008 , a34 out nocopy JTF_NUMBER_TABLE
1009 , a35 out nocopy JTF_VARCHAR2_TABLE_100
1010 , a36 out nocopy JTF_NUMBER_TABLE
1011 , a37 out nocopy JTF_VARCHAR2_TABLE_100
1012 , a38 out nocopy JTF_VARCHAR2_TABLE_100
1013 , a39 out nocopy JTF_VARCHAR2_TABLE_100
1014 , a40 out nocopy JTF_VARCHAR2_TABLE_100
1015 , a41 out nocopy JTF_VARCHAR2_TABLE_100
1016 , a42 out nocopy JTF_VARCHAR2_TABLE_100
1017 , a43 out nocopy JTF_NUMBER_TABLE
1018 , a44 out nocopy JTF_VARCHAR2_TABLE_100
1019 , a45 out nocopy JTF_NUMBER_TABLE
1020 , a46 out nocopy JTF_VARCHAR2_TABLE_100
1021 , a47 out nocopy JTF_NUMBER_TABLE
1022 , a48 out nocopy JTF_NUMBER_TABLE
1023 , a49 out nocopy JTF_VARCHAR2_TABLE_100
1024 , a50 out nocopy JTF_VARCHAR2_TABLE_100
1025 , a51 out nocopy JTF_NUMBER_TABLE
1026 , a52 out nocopy JTF_NUMBER_TABLE
1027 , a53 out nocopy JTF_NUMBER_TABLE
1028 , a54 out nocopy JTF_VARCHAR2_TABLE_100
1029 , a55 out nocopy JTF_VARCHAR2_TABLE_200
1033 , a59 out nocopy JTF_VARCHAR2_TABLE_200
1030 , a56 out nocopy JTF_VARCHAR2_TABLE_200
1031 , a57 out nocopy JTF_VARCHAR2_TABLE_200
1032 , a58 out nocopy JTF_VARCHAR2_TABLE_200
1034 , a60 out nocopy JTF_VARCHAR2_TABLE_200
1035 , a61 out nocopy JTF_VARCHAR2_TABLE_200
1036 , a62 out nocopy JTF_VARCHAR2_TABLE_200
1037 , a63 out nocopy JTF_VARCHAR2_TABLE_200
1038 , a64 out nocopy JTF_VARCHAR2_TABLE_200
1039 , a65 out nocopy JTF_VARCHAR2_TABLE_200
1040 , a66 out nocopy JTF_VARCHAR2_TABLE_200
1041 , a67 out nocopy JTF_VARCHAR2_TABLE_200
1042 , a68 out nocopy JTF_VARCHAR2_TABLE_200
1043 , a69 out nocopy JTF_VARCHAR2_TABLE_200
1044 , a70 out nocopy JTF_VARCHAR2_TABLE_200
1045 , a71 out nocopy JTF_NUMBER_TABLE
1046 , a72 out nocopy JTF_DATE_TABLE
1047 , a73 out nocopy JTF_VARCHAR2_TABLE_4000
1048 , a74 out nocopy JTF_NUMBER_TABLE
1049 , a75 out nocopy JTF_DATE_TABLE
1050 , a76 out nocopy JTF_DATE_TABLE
1051 , a77 out nocopy JTF_VARCHAR2_TABLE_100
1052 , a78 out nocopy JTF_VARCHAR2_TABLE_100
1053 , a79 out nocopy JTF_VARCHAR2_TABLE_100
1054 , a80 out nocopy JTF_NUMBER_TABLE
1055 , a81 out nocopy JTF_NUMBER_TABLE
1056 ) as
1057 ddindx binary_integer; indx binary_integer;
1058 begin
1059 if t is null or t.count = 0 then
1060 a0 := JTF_NUMBER_TABLE();
1061 a1 := JTF_VARCHAR2_TABLE_100();
1062 a2 := JTF_VARCHAR2_TABLE_100();
1063 a3 := JTF_VARCHAR2_TABLE_4000();
1064 a4 := JTF_NUMBER_TABLE();
1065 a5 := JTF_VARCHAR2_TABLE_100();
1066 a6 := JTF_NUMBER_TABLE();
1067 a7 := JTF_VARCHAR2_TABLE_100();
1068 a8 := JTF_NUMBER_TABLE();
1069 a9 := JTF_VARCHAR2_TABLE_100();
1070 a10 := JTF_VARCHAR2_TABLE_100();
1071 a11 := JTF_NUMBER_TABLE();
1072 a12 := JTF_VARCHAR2_TABLE_4000();
1073 a13 := JTF_NUMBER_TABLE();
1074 a14 := JTF_VARCHAR2_TABLE_4000();
1075 a15 := JTF_NUMBER_TABLE();
1076 a16 := JTF_VARCHAR2_TABLE_400();
1077 a17 := JTF_VARCHAR2_TABLE_100();
1078 a18 := JTF_VARCHAR2_TABLE_100();
1079 a19 := JTF_NUMBER_TABLE();
1080 a20 := JTF_NUMBER_TABLE();
1081 a21 := JTF_DATE_TABLE();
1082 a22 := JTF_DATE_TABLE();
1083 a23 := JTF_DATE_TABLE();
1084 a24 := JTF_DATE_TABLE();
1085 a25 := JTF_DATE_TABLE();
1086 a26 := JTF_DATE_TABLE();
1087 a27 := JTF_VARCHAR2_TABLE_100();
1088 a28 := JTF_NUMBER_TABLE();
1089 a29 := JTF_VARCHAR2_TABLE_100();
1090 a30 := JTF_NUMBER_TABLE();
1091 a31 := JTF_VARCHAR2_TABLE_100();
1092 a32 := JTF_NUMBER_TABLE();
1093 a33 := JTF_VARCHAR2_TABLE_100();
1094 a34 := JTF_NUMBER_TABLE();
1095 a35 := JTF_VARCHAR2_TABLE_100();
1096 a36 := JTF_NUMBER_TABLE();
1097 a37 := JTF_VARCHAR2_TABLE_100();
1098 a38 := JTF_VARCHAR2_TABLE_100();
1099 a39 := JTF_VARCHAR2_TABLE_100();
1100 a40 := JTF_VARCHAR2_TABLE_100();
1101 a41 := JTF_VARCHAR2_TABLE_100();
1102 a42 := JTF_VARCHAR2_TABLE_100();
1103 a43 := JTF_NUMBER_TABLE();
1104 a44 := JTF_VARCHAR2_TABLE_100();
1105 a45 := JTF_NUMBER_TABLE();
1106 a46 := JTF_VARCHAR2_TABLE_100();
1107 a47 := JTF_NUMBER_TABLE();
1108 a48 := JTF_NUMBER_TABLE();
1109 a49 := JTF_VARCHAR2_TABLE_100();
1110 a50 := JTF_VARCHAR2_TABLE_100();
1111 a51 := JTF_NUMBER_TABLE();
1112 a52 := JTF_NUMBER_TABLE();
1113 a53 := JTF_NUMBER_TABLE();
1114 a54 := JTF_VARCHAR2_TABLE_100();
1115 a55 := JTF_VARCHAR2_TABLE_200();
1116 a56 := JTF_VARCHAR2_TABLE_200();
1117 a57 := JTF_VARCHAR2_TABLE_200();
1118 a58 := JTF_VARCHAR2_TABLE_200();
1119 a59 := JTF_VARCHAR2_TABLE_200();
1120 a60 := JTF_VARCHAR2_TABLE_200();
1121 a61 := JTF_VARCHAR2_TABLE_200();
1122 a62 := JTF_VARCHAR2_TABLE_200();
1123 a63 := JTF_VARCHAR2_TABLE_200();
1124 a64 := JTF_VARCHAR2_TABLE_200();
1125 a65 := JTF_VARCHAR2_TABLE_200();
1126 a66 := JTF_VARCHAR2_TABLE_200();
1127 a67 := JTF_VARCHAR2_TABLE_200();
1128 a68 := JTF_VARCHAR2_TABLE_200();
1129 a69 := JTF_VARCHAR2_TABLE_200();
1130 a70 := JTF_VARCHAR2_TABLE_200();
1131 a71 := JTF_NUMBER_TABLE();
1132 a72 := JTF_DATE_TABLE();
1133 a73 := JTF_VARCHAR2_TABLE_4000();
1134 a74 := JTF_NUMBER_TABLE();
1135 a75 := JTF_DATE_TABLE();
1136 a76 := JTF_DATE_TABLE();
1137 a77 := JTF_VARCHAR2_TABLE_100();
1138 a78 := JTF_VARCHAR2_TABLE_100();
1139 a79 := JTF_VARCHAR2_TABLE_100();
1140 a80 := JTF_NUMBER_TABLE();
1141 a81 := JTF_NUMBER_TABLE();
1142 else
1143 a0 := JTF_NUMBER_TABLE();
1144 a1 := JTF_VARCHAR2_TABLE_100();
1145 a2 := JTF_VARCHAR2_TABLE_100();
1146 a3 := JTF_VARCHAR2_TABLE_4000();
1147 a4 := JTF_NUMBER_TABLE();
1148 a5 := JTF_VARCHAR2_TABLE_100();
1149 a6 := JTF_NUMBER_TABLE();
1150 a7 := JTF_VARCHAR2_TABLE_100();
1151 a8 := JTF_NUMBER_TABLE();
1152 a9 := JTF_VARCHAR2_TABLE_100();
1153 a10 := JTF_VARCHAR2_TABLE_100();
1154 a11 := JTF_NUMBER_TABLE();
1155 a12 := JTF_VARCHAR2_TABLE_4000();
1156 a13 := JTF_NUMBER_TABLE();
1157 a14 := JTF_VARCHAR2_TABLE_4000();
1158 a15 := JTF_NUMBER_TABLE();
1159 a16 := JTF_VARCHAR2_TABLE_400();
1160 a17 := JTF_VARCHAR2_TABLE_100();
1161 a18 := JTF_VARCHAR2_TABLE_100();
1162 a19 := JTF_NUMBER_TABLE();
1163 a20 := JTF_NUMBER_TABLE();
1164 a21 := JTF_DATE_TABLE();
1165 a22 := JTF_DATE_TABLE();
1166 a23 := JTF_DATE_TABLE();
1167 a24 := JTF_DATE_TABLE();
1171 a28 := JTF_NUMBER_TABLE();
1168 a25 := JTF_DATE_TABLE();
1169 a26 := JTF_DATE_TABLE();
1170 a27 := JTF_VARCHAR2_TABLE_100();
1172 a29 := JTF_VARCHAR2_TABLE_100();
1173 a30 := JTF_NUMBER_TABLE();
1174 a31 := JTF_VARCHAR2_TABLE_100();
1175 a32 := JTF_NUMBER_TABLE();
1176 a33 := JTF_VARCHAR2_TABLE_100();
1177 a34 := JTF_NUMBER_TABLE();
1178 a35 := JTF_VARCHAR2_TABLE_100();
1179 a36 := JTF_NUMBER_TABLE();
1180 a37 := JTF_VARCHAR2_TABLE_100();
1181 a38 := JTF_VARCHAR2_TABLE_100();
1182 a39 := JTF_VARCHAR2_TABLE_100();
1183 a40 := JTF_VARCHAR2_TABLE_100();
1184 a41 := JTF_VARCHAR2_TABLE_100();
1185 a42 := JTF_VARCHAR2_TABLE_100();
1186 a43 := JTF_NUMBER_TABLE();
1187 a44 := JTF_VARCHAR2_TABLE_100();
1188 a45 := JTF_NUMBER_TABLE();
1189 a46 := JTF_VARCHAR2_TABLE_100();
1190 a47 := JTF_NUMBER_TABLE();
1191 a48 := JTF_NUMBER_TABLE();
1192 a49 := JTF_VARCHAR2_TABLE_100();
1193 a50 := JTF_VARCHAR2_TABLE_100();
1194 a51 := JTF_NUMBER_TABLE();
1195 a52 := JTF_NUMBER_TABLE();
1196 a53 := JTF_NUMBER_TABLE();
1197 a54 := JTF_VARCHAR2_TABLE_100();
1198 a55 := JTF_VARCHAR2_TABLE_200();
1199 a56 := JTF_VARCHAR2_TABLE_200();
1200 a57 := JTF_VARCHAR2_TABLE_200();
1201 a58 := JTF_VARCHAR2_TABLE_200();
1202 a59 := JTF_VARCHAR2_TABLE_200();
1203 a60 := JTF_VARCHAR2_TABLE_200();
1204 a61 := JTF_VARCHAR2_TABLE_200();
1205 a62 := JTF_VARCHAR2_TABLE_200();
1206 a63 := JTF_VARCHAR2_TABLE_200();
1207 a64 := JTF_VARCHAR2_TABLE_200();
1208 a65 := JTF_VARCHAR2_TABLE_200();
1209 a66 := JTF_VARCHAR2_TABLE_200();
1210 a67 := JTF_VARCHAR2_TABLE_200();
1211 a68 := JTF_VARCHAR2_TABLE_200();
1212 a69 := JTF_VARCHAR2_TABLE_200();
1213 a70 := JTF_VARCHAR2_TABLE_200();
1214 a71 := JTF_NUMBER_TABLE();
1215 a72 := JTF_DATE_TABLE();
1216 a73 := JTF_VARCHAR2_TABLE_4000();
1217 a74 := JTF_NUMBER_TABLE();
1218 a75 := JTF_DATE_TABLE();
1219 a76 := JTF_DATE_TABLE();
1220 a77 := JTF_VARCHAR2_TABLE_100();
1221 a78 := JTF_VARCHAR2_TABLE_100();
1222 a79 := JTF_VARCHAR2_TABLE_100();
1223 a80 := JTF_NUMBER_TABLE();
1224 a81 := JTF_NUMBER_TABLE();
1225 if t.count > 0 then
1226 a0.extend(t.count);
1227 a1.extend(t.count);
1228 a2.extend(t.count);
1229 a3.extend(t.count);
1230 a4.extend(t.count);
1231 a5.extend(t.count);
1232 a6.extend(t.count);
1233 a7.extend(t.count);
1234 a8.extend(t.count);
1235 a9.extend(t.count);
1236 a10.extend(t.count);
1237 a11.extend(t.count);
1238 a12.extend(t.count);
1239 a13.extend(t.count);
1240 a14.extend(t.count);
1241 a15.extend(t.count);
1242 a16.extend(t.count);
1243 a17.extend(t.count);
1244 a18.extend(t.count);
1245 a19.extend(t.count);
1246 a20.extend(t.count);
1247 a21.extend(t.count);
1248 a22.extend(t.count);
1249 a23.extend(t.count);
1250 a24.extend(t.count);
1251 a25.extend(t.count);
1252 a26.extend(t.count);
1253 a27.extend(t.count);
1254 a28.extend(t.count);
1255 a29.extend(t.count);
1256 a30.extend(t.count);
1257 a31.extend(t.count);
1258 a32.extend(t.count);
1259 a33.extend(t.count);
1260 a34.extend(t.count);
1261 a35.extend(t.count);
1262 a36.extend(t.count);
1263 a37.extend(t.count);
1264 a38.extend(t.count);
1265 a39.extend(t.count);
1266 a40.extend(t.count);
1267 a41.extend(t.count);
1268 a42.extend(t.count);
1269 a43.extend(t.count);
1270 a44.extend(t.count);
1271 a45.extend(t.count);
1272 a46.extend(t.count);
1273 a47.extend(t.count);
1274 a48.extend(t.count);
1275 a49.extend(t.count);
1276 a50.extend(t.count);
1277 a51.extend(t.count);
1278 a52.extend(t.count);
1279 a53.extend(t.count);
1280 a54.extend(t.count);
1281 a55.extend(t.count);
1282 a56.extend(t.count);
1283 a57.extend(t.count);
1284 a58.extend(t.count);
1285 a59.extend(t.count);
1286 a60.extend(t.count);
1287 a61.extend(t.count);
1288 a62.extend(t.count);
1289 a63.extend(t.count);
1290 a64.extend(t.count);
1291 a65.extend(t.count);
1292 a66.extend(t.count);
1293 a67.extend(t.count);
1294 a68.extend(t.count);
1295 a69.extend(t.count);
1296 a70.extend(t.count);
1297 a71.extend(t.count);
1298 a72.extend(t.count);
1299 a73.extend(t.count);
1300 a74.extend(t.count);
1301 a75.extend(t.count);
1302 a76.extend(t.count);
1303 a77.extend(t.count);
1304 a78.extend(t.count);
1305 a79.extend(t.count);
1306 a80.extend(t.count);
1307 a81.extend(t.count);
1311 a0(indx) := t(ddindx).task_id;
1308 ddindx := t.first;
1309 indx := 1;
1310 while true loop
1312 a1(indx) := t(ddindx).task_number;
1313 a2(indx) := t(ddindx).task_name;
1314 a3(indx) := t(ddindx).description;
1315 a4(indx) := t(ddindx).task_type_id;
1316 a5(indx) := t(ddindx).task_type;
1317 a6(indx) := t(ddindx).task_status_id;
1318 a7(indx) := t(ddindx).task_status;
1319 a8(indx) := t(ddindx).task_priority_id;
1320 a9(indx) := t(ddindx).task_priority;
1321 a10(indx) := t(ddindx).owner_type_code;
1322 a11(indx) := t(ddindx).owner_id;
1323 a12(indx) := t(ddindx).owner;
1324 a13(indx) := t(ddindx).assigned_by_id;
1325 a14(indx) := t(ddindx).assigned_by_name;
1326 a15(indx) := t(ddindx).customer_id;
1327 a16(indx) := t(ddindx).customer_name;
1328 a17(indx) := t(ddindx).customer_number;
1329 a18(indx) := t(ddindx).cust_account_number;
1330 a19(indx) := t(ddindx).cust_account_id;
1331 a20(indx) := t(ddindx).address_id;
1332 a21(indx) := t(ddindx).planned_start_date;
1333 a22(indx) := t(ddindx).planned_end_date;
1334 a23(indx) := t(ddindx).scheduled_start_date;
1335 a24(indx) := t(ddindx).scheduled_end_date;
1336 a25(indx) := t(ddindx).actual_start_date;
1337 a26(indx) := t(ddindx).actual_end_date;
1338 a27(indx) := t(ddindx).object_type_code;
1339 a28(indx) := t(ddindx).object_id;
1340 a29(indx) := t(ddindx).obect_name;
1341 a30(indx) := t(ddindx).duration;
1342 a31(indx) := t(ddindx).duration_uom;
1343 a32(indx) := t(ddindx).planned_effort;
1344 a33(indx) := t(ddindx).planned_effort_uom;
1345 a34(indx) := t(ddindx).actual_effort;
1346 a35(indx) := t(ddindx).actual_effort_uom;
1347 a36(indx) := t(ddindx).percentage_complete;
1348 a37(indx) := t(ddindx).reason_code;
1349 a38(indx) := t(ddindx).private_flag;
1350 a39(indx) := t(ddindx).publish_flag;
1351 a40(indx) := t(ddindx).multi_booked_flag;
1352 a41(indx) := t(ddindx).milestone_flag;
1353 a42(indx) := t(ddindx).holiday_flag;
1354 a43(indx) := t(ddindx).workflow_process_id;
1355 a44(indx) := t(ddindx).notification_flag;
1356 a45(indx) := t(ddindx).notification_period;
1357 a46(indx) := t(ddindx).notification_period_uom;
1358 a47(indx) := t(ddindx).parent_task_id;
1359 a48(indx) := t(ddindx).alarm_start;
1360 a49(indx) := t(ddindx).alarm_start_uom;
1361 a50(indx) := t(ddindx).alarm_on;
1362 a51(indx) := t(ddindx).alarm_count;
1363 a52(indx) := t(ddindx).alarm_fired_count;
1364 a53(indx) := t(ddindx).alarm_interval;
1365 a54(indx) := t(ddindx).alarm_interval_uom;
1366 a55(indx) := t(ddindx).attribute1;
1367 a56(indx) := t(ddindx).attribute2;
1368 a57(indx) := t(ddindx).attribute3;
1369 a58(indx) := t(ddindx).attribute4;
1370 a59(indx) := t(ddindx).attribute5;
1371 a60(indx) := t(ddindx).attribute6;
1372 a61(indx) := t(ddindx).attribute7;
1373 a62(indx) := t(ddindx).attribute8;
1374 a63(indx) := t(ddindx).attribute9;
1375 a64(indx) := t(ddindx).attribute10;
1376 a65(indx) := t(ddindx).attribute11;
1377 a66(indx) := t(ddindx).attribute12;
1378 a67(indx) := t(ddindx).attribute13;
1379 a68(indx) := t(ddindx).attribute14;
1380 a69(indx) := t(ddindx).attribute15;
1381 a70(indx) := t(ddindx).attribute_category;
1382 a71(indx) := t(ddindx).owner_territory_id;
1383 a72(indx) := t(ddindx).creation_date;
1384 a73(indx) := t(ddindx).escalation_level;
1385 a74(indx) := t(ddindx).object_version_number;
1386 a75(indx) := t(ddindx).calendar_start_date;
1387 a76(indx) := t(ddindx).calendar_end_date;
1388 a77(indx) := t(ddindx).date_selected;
1389 a78(indx) := t(ddindx).task_split_flag;
1390 a79(indx) := t(ddindx).child_position;
1391 a80(indx) := t(ddindx).child_sequence_num;
1392 a81(indx) := t(ddindx).location_id;
1393 indx := indx+1;
1394 if t.last =ddindx
1395 then exit;
1396 end if;
1397 ddindx := t.next(ddindx);
1398 end loop;
1399 end if;
1400 end if;
1401 end rosetta_table_copy_out_p31;
1402
1403 procedure rosetta_table_copy_in_p34(t out nocopy jtf_tasks_pub.sort_data, a0 JTF_VARCHAR2_TABLE_100
1404 , a1 JTF_VARCHAR2_TABLE_100
1405 ) as
1406 ddindx binary_integer; indx binary_integer;
1407 begin
1408 if a0 is not null and a0.count > 0 then
1409 if a0.count > 0 then
1410 indx := a0.first;
1411 ddindx := 1;
1412 while true loop
1413 t(ddindx).field_name := a0(indx);
1414 t(ddindx).asc_dsc_flag := a1(indx);
1415 ddindx := ddindx+1;
1416 if a0.last =indx
1417 then exit;
1418 end if;
1419 indx := a0.next(indx);
1420 end loop;
1421 end if;
1422 end if;
1423 end rosetta_table_copy_in_p34;
1424 procedure rosetta_table_copy_out_p34(t jtf_tasks_pub.sort_data, a0 out nocopy JTF_VARCHAR2_TABLE_100
1425 , a1 out nocopy JTF_VARCHAR2_TABLE_100
1426 ) as
1430 a0 := JTF_VARCHAR2_TABLE_100();
1427 ddindx binary_integer; indx binary_integer;
1428 begin
1429 if t is null or t.count = 0 then
1431 a1 := JTF_VARCHAR2_TABLE_100();
1432 else
1433 a0 := JTF_VARCHAR2_TABLE_100();
1434 a1 := JTF_VARCHAR2_TABLE_100();
1435 if t.count > 0 then
1436 a0.extend(t.count);
1437 a1.extend(t.count);
1438 ddindx := t.first;
1439 indx := 1;
1440 while true loop
1441 a0(indx) := t(ddindx).field_name;
1442 a1(indx) := t(ddindx).asc_dsc_flag;
1443 indx := indx+1;
1444 if t.last =ddindx
1445 then exit;
1446 end if;
1447 ddindx := t.next(ddindx);
1448 end loop;
1449 end if;
1450 end if;
1451 end rosetta_table_copy_out_p34;
1452
1453 procedure rosetta_table_copy_in_p53(t out nocopy jtf_tasks_pub.task_details_tbl, a0 JTF_NUMBER_TABLE
1454 , a1 JTF_NUMBER_TABLE
1455 ) as
1456 ddindx binary_integer; indx binary_integer;
1457 begin
1458 if a0 is not null and a0.count > 0 then
1459 if a0.count > 0 then
1460 indx := a0.first;
1461 ddindx := 1;
1462 while true loop
1463 t(ddindx).task_id := a0(indx);
1464 t(ddindx).task_template_id := a1(indx);
1465 ddindx := ddindx+1;
1466 if a0.last =indx
1467 then exit;
1468 end if;
1469 indx := a0.next(indx);
1470 end loop;
1471 end if;
1472 end if;
1473 end rosetta_table_copy_in_p53;
1474 procedure rosetta_table_copy_out_p53(t jtf_tasks_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
1475 , a1 out nocopy JTF_NUMBER_TABLE
1476 ) as
1477 ddindx binary_integer; indx binary_integer;
1478 begin
1479 if t is null or t.count = 0 then
1480 a0 := JTF_NUMBER_TABLE();
1481 a1 := JTF_NUMBER_TABLE();
1482 else
1483 a0 := JTF_NUMBER_TABLE();
1484 a1 := JTF_NUMBER_TABLE();
1485 if t.count > 0 then
1486 a0.extend(t.count);
1487 a1.extend(t.count);
1488 ddindx := t.first;
1489 indx := 1;
1490 while true loop
1491 a0(indx) := t(ddindx).task_id;
1492 a1(indx) := t(ddindx).task_template_id;
1493 indx := indx+1;
1494 if t.last =ddindx
1495 then exit;
1496 end if;
1497 ddindx := t.next(ddindx);
1498 end loop;
1499 end if;
1500 end if;
1501 end rosetta_table_copy_out_p53;
1502
1503 procedure create_task(p_api_version NUMBER
1504 , p_init_msg_list VARCHAR2
1505 , p_commit VARCHAR2
1506 , p_task_id NUMBER
1507 , p_task_name VARCHAR2
1508 , p_task_type_name VARCHAR2
1509 , p_task_type_id NUMBER
1510 , p_description VARCHAR2
1511 , p_task_status_name VARCHAR2
1512 , p_task_status_id NUMBER
1513 , p_task_priority_name VARCHAR2
1514 , p_task_priority_id NUMBER
1515 , p_owner_type_name VARCHAR2
1516 , p_owner_type_code VARCHAR2
1517 , p_owner_id NUMBER
1518 , p_owner_territory_id NUMBER
1519 , p_assigned_by_name VARCHAR2
1520 , p_assigned_by_id NUMBER
1521 , p_customer_number VARCHAR2
1522 , p_customer_id NUMBER
1523 , p_cust_account_number VARCHAR2
1524 , p_cust_account_id NUMBER
1525 , p_address_id NUMBER
1526 , p_address_number VARCHAR2
1527 , p_planned_start_date date
1528 , p_planned_end_date date
1529 , p_scheduled_start_date date
1530 , p_scheduled_end_date date
1531 , p_actual_start_date date
1532 , p_actual_end_date date
1533 , p_timezone_id NUMBER
1534 , p_timezone_name VARCHAR2
1535 , p_source_object_type_code VARCHAR2
1536 , p_source_object_id NUMBER
1537 , p_source_object_name VARCHAR2
1538 , p_duration NUMBER
1539 , p_duration_uom VARCHAR2
1540 , p_planned_effort NUMBER
1541 , p_planned_effort_uom VARCHAR2
1542 , p_actual_effort NUMBER
1543 , p_actual_effort_uom VARCHAR2
1544 , p_percentage_complete NUMBER
1545 , p_reason_code VARCHAR2
1546 , p_private_flag VARCHAR2
1547 , p_publish_flag VARCHAR2
1548 , p_restrict_closure_flag VARCHAR2
1549 , p_multi_booked_flag VARCHAR2
1550 , p_milestone_flag VARCHAR2
1551 , p_holiday_flag VARCHAR2
1552 , p_billable_flag VARCHAR2
1553 , p_bound_mode_code VARCHAR2
1554 , p_soft_bound_flag VARCHAR2
1555 , p_workflow_process_id NUMBER
1556 , p_notification_flag VARCHAR2
1557 , p_notification_period NUMBER
1558 , p_notification_period_uom VARCHAR2
1559 , p_parent_task_number VARCHAR2
1560 , p_parent_task_id NUMBER
1561 , p_alarm_start NUMBER
1562 , p_alarm_start_uom VARCHAR2
1563 , p_alarm_on VARCHAR2
1564 , p_alarm_count NUMBER
1565 , p_alarm_interval NUMBER
1566 , p_alarm_interval_uom VARCHAR2
1567 , p_palm_flag VARCHAR2
1568 , p_wince_flag VARCHAR2
1569 , p_laptop_flag VARCHAR2
1570 , p_device1_flag VARCHAR2
1571 , p_device2_flag VARCHAR2
1572 , p_device3_flag VARCHAR2
1573 , p_costs NUMBER
1577 , p73_a1 JTF_NUMBER_TABLE
1574 , p_currency_code VARCHAR2
1575 , p_escalation_level VARCHAR2
1576 , p73_a0 JTF_VARCHAR2_TABLE_100
1578 , p73_a2 JTF_DATE_TABLE
1579 , p73_a3 JTF_DATE_TABLE
1580 , p73_a4 JTF_NUMBER_TABLE
1581 , p73_a5 JTF_VARCHAR2_TABLE_100
1582 , p73_a6 JTF_NUMBER_TABLE
1583 , p73_a7 JTF_NUMBER_TABLE
1584 , p73_a8 JTF_VARCHAR2_TABLE_100
1585 , p73_a9 JTF_NUMBER_TABLE
1586 , p73_a10 JTF_NUMBER_TABLE
1587 , p73_a11 JTF_VARCHAR2_TABLE_100
1588 , p73_a12 JTF_VARCHAR2_TABLE_100
1589 , p73_a13 JTF_VARCHAR2_TABLE_100
1590 , p73_a14 JTF_VARCHAR2_TABLE_200
1591 , p73_a15 JTF_VARCHAR2_TABLE_100
1592 , p73_a16 JTF_VARCHAR2_TABLE_100
1593 , p73_a17 JTF_VARCHAR2_TABLE_100
1594 , p73_a18 JTF_VARCHAR2_TABLE_100
1595 , p73_a19 JTF_VARCHAR2_TABLE_100
1596 , p73_a20 JTF_VARCHAR2_TABLE_100
1597 , p73_a21 JTF_NUMBER_TABLE
1598 , p73_a22 JTF_NUMBER_TABLE
1599 , p73_a23 JTF_NUMBER_TABLE
1600 , p73_a24 JTF_VARCHAR2_TABLE_100
1601 , p73_a25 JTF_NUMBER_TABLE
1602 , p74_a0 JTF_NUMBER_TABLE
1603 , p74_a1 JTF_NUMBER_TABLE
1604 , p74_a2 JTF_VARCHAR2_TABLE_100
1605 , p74_a3 JTF_NUMBER_TABLE
1606 , p74_a4 JTF_VARCHAR2_TABLE_100
1607 , p74_a5 JTF_VARCHAR2_TABLE_100
1608 , p75_a0 JTF_VARCHAR2_TABLE_100
1609 , p75_a1 JTF_NUMBER_TABLE
1610 , p75_a2 JTF_VARCHAR2_TABLE_100
1611 , p76_a0 JTF_VARCHAR2_TABLE_100
1612 , p76_a1 JTF_VARCHAR2_TABLE_100
1613 , p76_a2 JTF_VARCHAR2_TABLE_100
1614 , p76_a3 JTF_NUMBER_TABLE
1615 , p76_a4 JTF_VARCHAR2_TABLE_2000
1616 , p76_a5 JTF_VARCHAR2_TABLE_100
1617 , p76_a6 JTF_VARCHAR2_TABLE_2000
1618 , p77_a0 JTF_NUMBER_TABLE
1619 , p77_a1 JTF_VARCHAR2_TABLE_100
1620 , p77_a2 JTF_VARCHAR2_TABLE_100
1621 , p77_a3 JTF_DATE_TABLE
1622 , p78_a0 JTF_NUMBER_TABLE
1623 , p78_a1 JTF_NUMBER_TABLE
1624 , p78_a2 JTF_VARCHAR2_TABLE_4000
1625 , p78_a3 JTF_VARCHAR2_TABLE_32767
1626 , p78_a4 JTF_VARCHAR2_TABLE_100
1627 , p78_a5 JTF_NUMBER_TABLE
1628 , p78_a6 JTF_DATE_TABLE
1629 , p78_a7 JTF_VARCHAR2_TABLE_100
1630 , p78_a8 JTF_NUMBER_TABLE
1631 , p78_a9 JTF_VARCHAR2_TABLE_200
1632 , p78_a10 JTF_VARCHAR2_TABLE_200
1633 , p78_a11 JTF_VARCHAR2_TABLE_200
1634 , p78_a12 JTF_VARCHAR2_TABLE_200
1635 , p78_a13 JTF_VARCHAR2_TABLE_200
1636 , p78_a14 JTF_VARCHAR2_TABLE_200
1637 , p78_a15 JTF_VARCHAR2_TABLE_200
1638 , p78_a16 JTF_VARCHAR2_TABLE_200
1639 , p78_a17 JTF_VARCHAR2_TABLE_200
1640 , p78_a18 JTF_VARCHAR2_TABLE_200
1641 , p78_a19 JTF_VARCHAR2_TABLE_200
1642 , p78_a20 JTF_VARCHAR2_TABLE_200
1643 , p78_a21 JTF_VARCHAR2_TABLE_200
1644 , p78_a22 JTF_VARCHAR2_TABLE_200
1645 , p78_a23 JTF_VARCHAR2_TABLE_200
1646 , p78_a24 JTF_VARCHAR2_TABLE_100
1647 , p79_a0 NUMBER
1648 , p79_a1 NUMBER
1649 , p79_a2 NUMBER
1650 , p79_a3 NUMBER
1651 , p79_a4 VARCHAR2
1652 , p79_a5 NUMBER
1653 , p79_a6 NUMBER
1654 , p79_a7 DATE
1655 , p79_a8 DATE
1656 , p80_a0 JTF_NUMBER_TABLE
1657 , p80_a1 JTF_VARCHAR2_TABLE_100
1658 , p80_a2 JTF_VARCHAR2_TABLE_100
1659 , p80_a3 JTF_VARCHAR2_TABLE_100
1660 , x_return_status out nocopy VARCHAR2
1661 , x_msg_count out nocopy NUMBER
1662 , x_msg_data out nocopy VARCHAR2
1663 , x_task_id out nocopy NUMBER
1664 , p_attribute1 VARCHAR2
1665 , p_attribute2 VARCHAR2
1666 , p_attribute3 VARCHAR2
1667 , p_attribute4 VARCHAR2
1668 , p_attribute5 VARCHAR2
1669 , p_attribute6 VARCHAR2
1670 , p_attribute7 VARCHAR2
1671 , p_attribute8 VARCHAR2
1672 , p_attribute9 VARCHAR2
1673 , p_attribute10 VARCHAR2
1674 , p_attribute11 VARCHAR2
1675 , p_attribute12 VARCHAR2
1676 , p_attribute13 VARCHAR2
1677 , p_attribute14 VARCHAR2
1678 , p_attribute15 VARCHAR2
1679 , p_attribute_category VARCHAR2
1680 , p_date_selected VARCHAR2
1681 , p_category_id NUMBER
1682 , p_show_on_calendar VARCHAR2
1683 , p_owner_status_id NUMBER
1684 , p_template_id NUMBER
1685 , p_template_group_id NUMBER
1686 , p_enable_workflow VARCHAR2
1687 , p_abort_workflow VARCHAR2
1688 , p_task_split_flag VARCHAR2
1689 , p_reference_flag VARCHAR2
1690 , p_child_position VARCHAR2
1691 , p_child_sequence_num NUMBER
1692 , p_location_id NUMBER
1693 )
1694
1695 as
1696 ddp_planned_start_date date;
1697 ddp_planned_end_date date;
1698 ddp_scheduled_start_date date;
1699 ddp_scheduled_end_date date;
1700 ddp_actual_start_date date;
1701 ddp_actual_end_date date;
1702 ddp_task_assign_tbl jtf_tasks_pub.task_assign_tbl;
1703 ddp_task_depends_tbl jtf_tasks_pub.task_depends_tbl;
1704 ddp_task_rsrc_req_tbl jtf_tasks_pub.task_rsrc_req_tbl;
1705 ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;
1706 ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;
1707 ddp_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
1708 ddp_task_recur_rec jtf_tasks_pub.task_recur_rec;
1709 ddp_task_contacts_tbl jtf_tasks_pub.task_contacts_tbl;
1710 ddindx binary_integer; indx binary_integer;
1711 begin
1712
1713 -- copy data to the local IN or IN-OUT args, if any
1714
1715
1716
1717
1721
1718
1719
1720
1722
1723
1724
1725
1726
1727
1728
1729
1730
1731
1732
1733
1734
1735
1736
1737
1738 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
1739
1740 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
1741
1742 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
1743
1744 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
1745
1746 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
1747
1748 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
1749
1750
1751
1752
1753
1754
1755
1756
1757
1758
1759
1760
1761
1762
1763
1764
1765
1766
1767
1768
1769
1770
1771
1772
1773
1774
1775
1776
1777
1778
1779
1780
1781
1782
1783
1784
1785
1786
1787
1788
1789
1790
1791
1792
1793 jtf_tasks_pub_w.rosetta_table_copy_in_p6(ddp_task_assign_tbl, p73_a0
1794 , p73_a1
1795 , p73_a2
1796 , p73_a3
1797 , p73_a4
1798 , p73_a5
1799 , p73_a6
1800 , p73_a7
1801 , p73_a8
1802 , p73_a9
1803 , p73_a10
1804 , p73_a11
1805 , p73_a12
1806 , p73_a13
1807 , p73_a14
1808 , p73_a15
1809 , p73_a16
1810 , p73_a17
1811 , p73_a18
1812 , p73_a19
1813 , p73_a20
1814 , p73_a21
1815 , p73_a22
1816 , p73_a23
1817 , p73_a24
1818 , p73_a25
1819 );
1820
1821 jtf_tasks_pub_w.rosetta_table_copy_in_p9(ddp_task_depends_tbl, p74_a0
1822 , p74_a1
1823 , p74_a2
1824 , p74_a3
1825 , p74_a4
1826 , p74_a5
1827 );
1828
1829 jtf_tasks_pub_w.rosetta_table_copy_in_p12(ddp_task_rsrc_req_tbl, p75_a0
1830 , p75_a1
1831 , p75_a2
1832 );
1833
1834 jtf_tasks_pub_w.rosetta_table_copy_in_p15(ddp_task_refer_tbl, p76_a0
1835 , p76_a1
1836 , p76_a2
1837 , p76_a3
1838 , p76_a4
1839 , p76_a5
1840 , p76_a6
1841 );
1842
1843 jtf_tasks_pub_w.rosetta_table_copy_in_p20(ddp_task_dates_tbl, p77_a0
1844 , p77_a1
1845 , p77_a2
1846 , p77_a3
1847 );
1848
1849 jtf_tasks_pub_w.rosetta_table_copy_in_p23(ddp_task_notes_tbl, p78_a0
1850 , p78_a1
1851 , p78_a2
1852 , p78_a3
1853 , p78_a4
1854 , p78_a5
1855 , p78_a6
1856 , p78_a7
1857 , p78_a8
1858 , p78_a9
1859 , p78_a10
1860 , p78_a11
1861 , p78_a12
1862 , p78_a13
1863 , p78_a14
1864 , p78_a15
1865 , p78_a16
1866 , p78_a17
1867 , p78_a18
1868 , p78_a19
1869 , p78_a20
1870 , p78_a21
1871 , p78_a22
1872 , p78_a23
1873 , p78_a24
1874 );
1875
1876 ddp_task_recur_rec.occurs_which := p79_a0;
1877 ddp_task_recur_rec.day_of_week := p79_a1;
1878 ddp_task_recur_rec.date_of_month := p79_a2;
1879 ddp_task_recur_rec.occurs_month := p79_a3;
1880 ddp_task_recur_rec.occurs_uom := p79_a4;
1881 ddp_task_recur_rec.occurs_every := p79_a5;
1882 ddp_task_recur_rec.occurs_number := p79_a6;
1883 ddp_task_recur_rec.start_date_active := rosetta_g_miss_date_in_map(p79_a7);
1884 ddp_task_recur_rec.end_date_active := rosetta_g_miss_date_in_map(p79_a8);
1885
1886 jtf_tasks_pub_w.rosetta_table_copy_in_p26(ddp_task_contacts_tbl, p80_a0
1887 , p80_a1
1888 , p80_a2
1889 , p80_a3
1890 );
1891
1892
1893
1894
1895
1896
1897
1898
1899
1900
1901
1902
1903
1904
1905
1906
1907
1908
1909
1910
1911
1912
1913
1914
1915
1916
1917
1918
1919
1920
1921
1922
1923
1924
1925 -- here's the delegated call to the old PL/SQL routine
1926 jtf_tasks_pub.create_task(p_api_version,
1927 p_init_msg_list,
1928 p_commit,
1929 p_task_id,
1930 p_task_name,
1931 p_task_type_name,
1932 p_task_type_id,
1933 p_description,
1934 p_task_status_name,
1935 p_task_status_id,
1936 p_task_priority_name,
1937 p_task_priority_id,
1938 p_owner_type_name,
1939 p_owner_type_code,
1940 p_owner_id,
1941 p_owner_territory_id,
1942 p_assigned_by_name,
1943 p_assigned_by_id,
1947 p_cust_account_id,
1944 p_customer_number,
1945 p_customer_id,
1946 p_cust_account_number,
1948 p_address_id,
1949 p_address_number,
1950 ddp_planned_start_date,
1951 ddp_planned_end_date,
1952 ddp_scheduled_start_date,
1953 ddp_scheduled_end_date,
1954 ddp_actual_start_date,
1955 ddp_actual_end_date,
1956 p_timezone_id,
1957 p_timezone_name,
1958 p_source_object_type_code,
1959 p_source_object_id,
1960 p_source_object_name,
1961 p_duration,
1962 p_duration_uom,
1963 p_planned_effort,
1964 p_planned_effort_uom,
1965 p_actual_effort,
1966 p_actual_effort_uom,
1967 p_percentage_complete,
1968 p_reason_code,
1969 p_private_flag,
1970 p_publish_flag,
1971 p_restrict_closure_flag,
1972 p_multi_booked_flag,
1973 p_milestone_flag,
1974 p_holiday_flag,
1975 p_billable_flag,
1976 p_bound_mode_code,
1977 p_soft_bound_flag,
1978 p_workflow_process_id,
1979 p_notification_flag,
1980 p_notification_period,
1981 p_notification_period_uom,
1982 p_parent_task_number,
1983 p_parent_task_id,
1984 p_alarm_start,
1985 p_alarm_start_uom,
1986 p_alarm_on,
1987 p_alarm_count,
1988 p_alarm_interval,
1989 p_alarm_interval_uom,
1990 p_palm_flag,
1991 p_wince_flag,
1992 p_laptop_flag,
1993 p_device1_flag,
1994 p_device2_flag,
1995 p_device3_flag,
1996 p_costs,
1997 p_currency_code,
1998 p_escalation_level,
1999 ddp_task_assign_tbl,
2000 ddp_task_depends_tbl,
2001 ddp_task_rsrc_req_tbl,
2002 ddp_task_refer_tbl,
2003 ddp_task_dates_tbl,
2004 ddp_task_notes_tbl,
2005 ddp_task_recur_rec,
2006 ddp_task_contacts_tbl,
2007 x_return_status,
2008 x_msg_count,
2009 x_msg_data,
2010 x_task_id,
2011 p_attribute1,
2012 p_attribute2,
2013 p_attribute3,
2014 p_attribute4,
2015 p_attribute5,
2016 p_attribute6,
2017 p_attribute7,
2018 p_attribute8,
2019 p_attribute9,
2020 p_attribute10,
2021 p_attribute11,
2022 p_attribute12,
2023 p_attribute13,
2024 p_attribute14,
2025 p_attribute15,
2026 p_attribute_category,
2027 p_date_selected,
2028 p_category_id,
2029 p_show_on_calendar,
2030 p_owner_status_id,
2031 p_template_id,
2032 p_template_group_id,
2033 p_enable_workflow,
2034 p_abort_workflow,
2035 p_task_split_flag,
2036 p_reference_flag,
2037 p_child_position,
2038 p_child_sequence_num,
2039 p_location_id);
2040
2041 -- copy data back from the local variables to OUT or IN-OUT args, if any
2042
2043
2044
2045
2046
2047
2048
2049
2050
2051
2052
2053
2054
2055
2056
2057
2058
2059
2060
2061
2062
2063
2064
2065
2066
2067
2068
2069
2070
2071
2072
2073
2074
2075
2076
2077
2078
2079
2080
2081
2082
2083
2084
2085
2086
2087
2088
2089
2090
2091
2092
2093
2094
2095
2096
2097
2098
2099
2100
2101
2102
2103
2104
2105
2106
2107
2108
2109
2110
2111
2112
2113
2114
2115
2116
2117
2118
2119
2120
2121
2122
2123
2124
2125
2126
2127
2128
2129
2130
2131
2132
2133
2134
2135
2136
2137
2138
2139
2140
2141
2142
2143
2144
2145
2146
2147
2148
2149
2150
2151
2152
2153
2154
2155 end;
2156
2157 procedure create_task(p_api_version NUMBER
2158 , p_init_msg_list VARCHAR2
2159 , p_commit VARCHAR2
2160 , p_task_id NUMBER
2161 , p_task_name VARCHAR2
2162 , p_task_type_name VARCHAR2
2163 , p_task_type_id NUMBER
2164 , p_description VARCHAR2
2165 , p_task_status_name VARCHAR2
2166 , p_task_status_id NUMBER
2167 , p_task_priority_name VARCHAR2
2168 , p_task_priority_id NUMBER
2169 , p_owner_type_name VARCHAR2
2170 , p_owner_type_code VARCHAR2
2171 , p_owner_id NUMBER
2172 , p_owner_territory_id NUMBER
2173 , p_assigned_by_name VARCHAR2
2177 , p_cust_account_number VARCHAR2
2174 , p_assigned_by_id NUMBER
2175 , p_customer_number VARCHAR2
2176 , p_customer_id NUMBER
2178 , p_cust_account_id NUMBER
2179 , p_address_id NUMBER
2180 , p_address_number VARCHAR2
2181 , p_planned_start_date date
2182 , p_planned_end_date date
2183 , p_scheduled_start_date date
2184 , p_scheduled_end_date date
2185 , p_actual_start_date date
2186 , p_actual_end_date date
2187 , p_timezone_id NUMBER
2188 , p_timezone_name VARCHAR2
2189 , p_source_object_type_code VARCHAR2
2190 , p_source_object_id NUMBER
2191 , p_source_object_name VARCHAR2
2192 , p_duration NUMBER
2193 , p_duration_uom VARCHAR2
2194 , p_planned_effort NUMBER
2195 , p_planned_effort_uom VARCHAR2
2196 , p_actual_effort NUMBER
2197 , p_actual_effort_uom VARCHAR2
2198 , p_percentage_complete NUMBER
2199 , p_reason_code VARCHAR2
2200 , p_private_flag VARCHAR2
2201 , p_publish_flag VARCHAR2
2202 , p_restrict_closure_flag VARCHAR2
2203 , p_multi_booked_flag VARCHAR2
2204 , p_milestone_flag VARCHAR2
2205 , p_holiday_flag VARCHAR2
2206 , p_billable_flag VARCHAR2
2207 , p_bound_mode_code VARCHAR2
2208 , p_soft_bound_flag VARCHAR2
2209 , p_workflow_process_id NUMBER
2210 , p_notification_flag VARCHAR2
2211 , p_notification_period NUMBER
2212 , p_notification_period_uom VARCHAR2
2213 , p_parent_task_number VARCHAR2
2214 , p_parent_task_id NUMBER
2215 , p_alarm_start NUMBER
2216 , p_alarm_start_uom VARCHAR2
2217 , p_alarm_on VARCHAR2
2218 , p_alarm_count NUMBER
2219 , p_alarm_interval NUMBER
2220 , p_alarm_interval_uom VARCHAR2
2221 , p_palm_flag VARCHAR2
2222 , p_wince_flag VARCHAR2
2223 , p_laptop_flag VARCHAR2
2224 , p_device1_flag VARCHAR2
2225 , p_device2_flag VARCHAR2
2226 , p_device3_flag VARCHAR2
2227 , p_costs NUMBER
2228 , p_currency_code VARCHAR2
2229 , p_escalation_level VARCHAR2
2230 , x_return_status out nocopy VARCHAR2
2231 , x_msg_count out nocopy NUMBER
2232 , x_msg_data out nocopy VARCHAR2
2233 , x_task_id out nocopy NUMBER
2234 , p_attribute1 VARCHAR2
2235 , p_attribute2 VARCHAR2
2236 , p_attribute3 VARCHAR2
2237 , p_attribute4 VARCHAR2
2238 , p_attribute5 VARCHAR2
2239 , p_attribute6 VARCHAR2
2240 , p_attribute7 VARCHAR2
2241 , p_attribute8 VARCHAR2
2242 , p_attribute9 VARCHAR2
2243 , p_attribute10 VARCHAR2
2244 , p_attribute11 VARCHAR2
2245 , p_attribute12 VARCHAR2
2246 , p_attribute13 VARCHAR2
2247 , p_attribute14 VARCHAR2
2248 , p_attribute15 VARCHAR2
2249 , p_attribute_category VARCHAR2
2250 , p_date_selected VARCHAR2
2251 , p_category_id NUMBER
2252 , p_show_on_calendar VARCHAR2
2253 , p_owner_status_id NUMBER
2254 , p_template_id NUMBER
2255 , p_template_group_id NUMBER
2256 , p_enable_workflow VARCHAR2
2257 , p_abort_workflow VARCHAR2
2258 , p_task_split_flag VARCHAR2
2259 , p_reference_flag VARCHAR2
2260 , p_child_position VARCHAR2
2261 , p_child_sequence_num NUMBER
2262 )
2263
2264 as
2265 ddp_planned_start_date date;
2266 ddp_planned_end_date date;
2267 ddp_scheduled_start_date date;
2268 ddp_scheduled_end_date date;
2269 ddp_actual_start_date date;
2270 ddp_actual_end_date date;
2271 ddindx binary_integer; indx binary_integer;
2272 begin
2273
2274 -- copy data to the local IN or IN-OUT args, if any
2275
2276
2277
2278
2279
2280
2281
2282
2283
2284
2285
2286
2287
2288
2289
2290
2291
2292
2293
2294
2295
2296
2297
2298
2299 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
2300
2301 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
2302
2303 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
2304
2305 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
2306
2307 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
2308
2309 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
2310
2311
2312
2313
2314
2315
2316
2317
2318
2319
2320
2321
2322
2323
2324
2325
2326
2327
2328
2329
2330
2331
2332
2333
2334
2335
2336
2337
2338
2339
2340
2341
2342
2343
2344
2345
2346
2347
2348
2349
2350
2351
2352
2353
2354
2355
2356
2357
2358
2359
2360
2361
2362
2363
2364
2365
2366
2367
2368
2369
2370
2371
2372
2373
2374
2375
2376
2377
2378
2379
2380
2381
2382
2383
2384
2385
2386 -- here's the delegated call to the old PL/SQL routine
2387 jtf_tasks_pub.create_task(p_api_version,
2388 p_init_msg_list,
2389 p_commit,
2390 p_task_id,
2391 p_task_name,
2392 p_task_type_name,
2393 p_task_type_id,
2394 p_description,
2395 p_task_status_name,
2396 p_task_status_id,
2397 p_task_priority_name,
2398 p_task_priority_id,
2399 p_owner_type_name,
2400 p_owner_type_code,
2401 p_owner_id,
2402 p_owner_territory_id,
2403 p_assigned_by_name,
2404 p_assigned_by_id,
2405 p_customer_number,
2406 p_customer_id,
2407 p_cust_account_number,
2408 p_cust_account_id,
2409 p_address_id,
2410 p_address_number,
2411 ddp_planned_start_date,
2412 ddp_planned_end_date,
2413 ddp_scheduled_start_date,
2414 ddp_scheduled_end_date,
2415 ddp_actual_start_date,
2416 ddp_actual_end_date,
2417 p_timezone_id,
2418 p_timezone_name,
2419 p_source_object_type_code,
2420 p_source_object_id,
2421 p_source_object_name,
2422 p_duration,
2423 p_duration_uom,
2424 p_planned_effort,
2425 p_planned_effort_uom,
2426 p_actual_effort,
2427 p_actual_effort_uom,
2428 p_percentage_complete,
2429 p_reason_code,
2430 p_private_flag,
2431 p_publish_flag,
2432 p_restrict_closure_flag,
2433 p_multi_booked_flag,
2434 p_milestone_flag,
2435 p_holiday_flag,
2436 p_billable_flag,
2437 p_bound_mode_code,
2438 p_soft_bound_flag,
2439 p_workflow_process_id,
2440 p_notification_flag,
2441 p_notification_period,
2442 p_notification_period_uom,
2443 p_parent_task_number,
2444 p_parent_task_id,
2445 p_alarm_start,
2446 p_alarm_start_uom,
2447 p_alarm_on,
2448 p_alarm_count,
2449 p_alarm_interval,
2450 p_alarm_interval_uom,
2451 p_palm_flag,
2452 p_wince_flag,
2456 p_device3_flag,
2453 p_laptop_flag,
2454 p_device1_flag,
2455 p_device2_flag,
2457 p_costs,
2458 p_currency_code,
2459 p_escalation_level,
2460 x_return_status,
2461 x_msg_count,
2462 x_msg_data,
2463 x_task_id,
2464 p_attribute1,
2465 p_attribute2,
2466 p_attribute3,
2467 p_attribute4,
2468 p_attribute5,
2469 p_attribute6,
2470 p_attribute7,
2471 p_attribute8,
2472 p_attribute9,
2473 p_attribute10,
2474 p_attribute11,
2475 p_attribute12,
2476 p_attribute13,
2477 p_attribute14,
2478 p_attribute15,
2479 p_attribute_category,
2480 p_date_selected,
2481 p_category_id,
2482 p_show_on_calendar,
2483 p_owner_status_id,
2484 p_template_id,
2485 p_template_group_id,
2486 p_enable_workflow,
2487 p_abort_workflow,
2488 p_task_split_flag,
2489 p_reference_flag,
2490 p_child_position,
2491 p_child_sequence_num);
2492
2493 -- copy data back from the local variables to OUT or IN-OUT args, if any
2494
2495
2496
2497
2498
2499
2500
2501
2502
2503
2504
2505
2506
2507
2508
2509
2510
2511
2512
2513
2514
2515
2516
2517
2518
2519
2520
2521
2522
2523
2524
2525
2526
2527
2528
2529
2530
2531
2532
2533
2534
2535
2536
2537
2538
2539
2540
2541
2542
2543
2544
2545
2546
2547
2548
2549
2550
2551
2552
2553
2554
2555
2556
2557
2558
2559
2560
2561
2562
2563
2564
2565
2566
2567
2568
2569
2570
2571
2572
2573
2574
2575
2576
2577
2578
2579
2580
2581
2582
2583
2584
2585
2586
2587
2588
2589
2590
2591
2592
2593
2594
2595
2596
2597
2598 end;
2599
2600 procedure create_task(p_api_version NUMBER
2601 , p_init_msg_list VARCHAR2
2602 , p_commit VARCHAR2
2603 , p_task_id NUMBER
2604 , p_task_name VARCHAR2
2605 , p_task_type_name VARCHAR2
2606 , p_task_type_id NUMBER
2607 , p_description VARCHAR2
2608 , p_task_status_name VARCHAR2
2609 , p_task_status_id NUMBER
2610 , p_task_priority_name VARCHAR2
2611 , p_task_priority_id NUMBER
2612 , p_owner_type_name VARCHAR2
2613 , p_owner_type_code VARCHAR2
2614 , p_owner_id NUMBER
2615 , p_owner_territory_id NUMBER
2616 , p_assigned_by_name VARCHAR2
2617 , p_assigned_by_id NUMBER
2618 , p_customer_number VARCHAR2
2619 , p_customer_id NUMBER
2620 , p_cust_account_number VARCHAR2
2621 , p_cust_account_id NUMBER
2622 , p_address_id NUMBER
2623 , p_address_number VARCHAR2
2624 , p_planned_start_date date
2625 , p_planned_end_date date
2626 , p_scheduled_start_date date
2627 , p_scheduled_end_date date
2628 , p_actual_start_date date
2629 , p_actual_end_date date
2630 , p_timezone_id NUMBER
2631 , p_timezone_name VARCHAR2
2632 , p_source_object_type_code VARCHAR2
2633 , p_source_object_id NUMBER
2634 , p_source_object_name VARCHAR2
2635 , p_duration NUMBER
2636 , p_duration_uom VARCHAR2
2637 , p_planned_effort NUMBER
2638 , p_planned_effort_uom VARCHAR2
2639 , p_actual_effort NUMBER
2640 , p_actual_effort_uom VARCHAR2
2641 , p_percentage_complete NUMBER
2642 , p_reason_code VARCHAR2
2643 , p_private_flag VARCHAR2
2644 , p_publish_flag VARCHAR2
2645 , p_restrict_closure_flag VARCHAR2
2646 , p_multi_booked_flag VARCHAR2
2647 , p_milestone_flag VARCHAR2
2648 , p_holiday_flag VARCHAR2
2649 , p_billable_flag VARCHAR2
2650 , p_bound_mode_code VARCHAR2
2651 , p_soft_bound_flag VARCHAR2
2652 , p_workflow_process_id NUMBER
2653 , p_notification_flag VARCHAR2
2654 , p_notification_period NUMBER
2655 , p_notification_period_uom VARCHAR2
2656 , p_parent_task_number VARCHAR2
2657 , p_parent_task_id NUMBER
2658 , p_alarm_start NUMBER
2659 , p_alarm_start_uom VARCHAR2
2660 , p_alarm_on VARCHAR2
2661 , p_alarm_count NUMBER
2662 , p_alarm_interval NUMBER
2663 , p_alarm_interval_uom VARCHAR2
2664 , p_palm_flag VARCHAR2
2665 , p_wince_flag VARCHAR2
2666 , p_laptop_flag VARCHAR2
2667 , p_device1_flag VARCHAR2
2668 , p_device2_flag VARCHAR2
2669 , p_device3_flag VARCHAR2
2670 , p_costs NUMBER
2671 , p_currency_code VARCHAR2
2672 , p_escalation_level VARCHAR2
2673 , x_return_status out nocopy VARCHAR2
2677 , p_attribute1 VARCHAR2
2674 , x_msg_count out nocopy NUMBER
2675 , x_msg_data out nocopy VARCHAR2
2676 , x_task_id out nocopy NUMBER
2678 , p_attribute2 VARCHAR2
2679 , p_attribute3 VARCHAR2
2680 , p_attribute4 VARCHAR2
2681 , p_attribute5 VARCHAR2
2682 , p_attribute6 VARCHAR2
2683 , p_attribute7 VARCHAR2
2684 , p_attribute8 VARCHAR2
2685 , p_attribute9 VARCHAR2
2686 , p_attribute10 VARCHAR2
2687 , p_attribute11 VARCHAR2
2688 , p_attribute12 VARCHAR2
2689 , p_attribute13 VARCHAR2
2690 , p_attribute14 VARCHAR2
2691 , p_attribute15 VARCHAR2
2692 , p_attribute_category VARCHAR2
2693 , p_date_selected VARCHAR2
2694 , p_category_id NUMBER
2695 , p_show_on_calendar VARCHAR2
2696 , p_owner_status_id NUMBER
2697 , p_template_id NUMBER
2698 , p_template_group_id NUMBER
2699 , p_enable_workflow VARCHAR2
2700 , p_abort_workflow VARCHAR2
2701 )
2702
2703 as
2704 ddp_planned_start_date date;
2705 ddp_planned_end_date date;
2706 ddp_scheduled_start_date date;
2707 ddp_scheduled_end_date date;
2708 ddp_actual_start_date date;
2709 ddp_actual_end_date date;
2710 ddindx binary_integer; indx binary_integer;
2711 begin
2712
2713 -- copy data to the local IN or IN-OUT args, if any
2714
2715
2716
2717
2718
2719
2720
2721
2722
2723
2724
2725
2726
2727
2728
2729
2730
2731
2732
2733
2734
2735
2736
2737
2738 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
2739
2740 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
2741
2742 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
2743
2744 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
2745
2746 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
2747
2748 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
2749
2750
2751
2752
2753
2754
2755
2756
2757
2758
2759
2760
2761
2762
2763
2764
2765
2766
2767
2768
2769
2770
2771
2772
2773
2774
2775
2776
2777
2778
2779
2780
2781
2782
2783
2784
2785
2786
2787
2788
2789
2790
2791
2792
2793
2794
2795
2796
2797
2798
2799
2800
2801
2802
2803
2804
2805
2806
2807
2808
2809
2810
2811
2812
2813
2814
2815
2816
2817
2818
2819
2820
2821 -- here's the delegated call to the old PL/SQL routine
2822 jtf_tasks_pub.create_task(p_api_version,
2823 p_init_msg_list,
2824 p_commit,
2825 p_task_id,
2826 p_task_name,
2827 p_task_type_name,
2828 p_task_type_id,
2829 p_description,
2830 p_task_status_name,
2831 p_task_status_id,
2832 p_task_priority_name,
2833 p_task_priority_id,
2834 p_owner_type_name,
2835 p_owner_type_code,
2836 p_owner_id,
2837 p_owner_territory_id,
2838 p_assigned_by_name,
2839 p_assigned_by_id,
2840 p_customer_number,
2841 p_customer_id,
2842 p_cust_account_number,
2843 p_cust_account_id,
2844 p_address_id,
2845 p_address_number,
2846 ddp_planned_start_date,
2847 ddp_planned_end_date,
2848 ddp_scheduled_start_date,
2849 ddp_scheduled_end_date,
2850 ddp_actual_start_date,
2851 ddp_actual_end_date,
2852 p_timezone_id,
2853 p_timezone_name,
2854 p_source_object_type_code,
2855 p_source_object_id,
2856 p_source_object_name,
2857 p_duration,
2858 p_duration_uom,
2859 p_planned_effort,
2860 p_planned_effort_uom,
2861 p_actual_effort,
2862 p_actual_effort_uom,
2863 p_percentage_complete,
2864 p_reason_code,
2865 p_private_flag,
2866 p_publish_flag,
2867 p_restrict_closure_flag,
2868 p_multi_booked_flag,
2869 p_milestone_flag,
2870 p_holiday_flag,
2871 p_billable_flag,
2872 p_bound_mode_code,
2873 p_soft_bound_flag,
2874 p_workflow_process_id,
2875 p_notification_flag,
2876 p_notification_period,
2877 p_notification_period_uom,
2878 p_parent_task_number,
2879 p_parent_task_id,
2880 p_alarm_start,
2881 p_alarm_start_uom,
2882 p_alarm_on,
2883 p_alarm_count,
2884 p_alarm_interval,
2885 p_alarm_interval_uom,
2886 p_palm_flag,
2887 p_wince_flag,
2888 p_laptop_flag,
2889 p_device1_flag,
2890 p_device2_flag,
2891 p_device3_flag,
2892 p_costs,
2896 x_msg_count,
2893 p_currency_code,
2894 p_escalation_level,
2895 x_return_status,
2897 x_msg_data,
2898 x_task_id,
2899 p_attribute1,
2900 p_attribute2,
2901 p_attribute3,
2902 p_attribute4,
2903 p_attribute5,
2904 p_attribute6,
2905 p_attribute7,
2906 p_attribute8,
2907 p_attribute9,
2908 p_attribute10,
2909 p_attribute11,
2910 p_attribute12,
2911 p_attribute13,
2912 p_attribute14,
2913 p_attribute15,
2914 p_attribute_category,
2915 p_date_selected,
2916 p_category_id,
2917 p_show_on_calendar,
2918 p_owner_status_id,
2919 p_template_id,
2920 p_template_group_id,
2921 p_enable_workflow,
2922 p_abort_workflow);
2923
2924 -- copy data back from the local variables to OUT or IN-OUT args, if any
2925
2926
2927
2928
2929
2930
2931
2932
2933
2934
2935
2936
2937
2938
2939
2940
2941
2942
2943
2944
2945
2946
2947
2948
2949
2950
2951
2952
2953
2954
2955
2956
2957
2958
2959
2960
2961
2962
2963
2964
2965
2966
2967
2968
2969
2970
2971
2972
2973
2974
2975
2976
2977
2978
2979
2980
2981
2982
2983
2984
2985
2986
2987
2988
2989
2990
2991
2992
2993
2994
2995
2996
2997
2998
2999
3000
3001
3002
3003
3004
3005
3006
3007
3008
3009
3010
3011
3012
3013
3014
3015
3016
3017
3018
3019
3020
3021
3022
3023
3024
3025 end;
3026
3027 procedure create_task(p_api_version NUMBER
3028 , p_init_msg_list VARCHAR2
3029 , p_commit VARCHAR2
3030 , p_task_id NUMBER
3031 , p_task_name VARCHAR2
3032 , p_task_type_name VARCHAR2
3033 , p_task_type_id NUMBER
3034 , p_description VARCHAR2
3035 , p_task_status_name VARCHAR2
3036 , p_task_status_id NUMBER
3037 , p_task_priority_name VARCHAR2
3038 , p_task_priority_id NUMBER
3039 , p_owner_type_name VARCHAR2
3040 , p_owner_type_code VARCHAR2
3041 , p_owner_id NUMBER
3042 , p_owner_territory_id NUMBER
3043 , p_assigned_by_name VARCHAR2
3044 , p_assigned_by_id NUMBER
3045 , p_customer_number VARCHAR2
3046 , p_customer_id NUMBER
3047 , p_cust_account_number VARCHAR2
3048 , p_cust_account_id NUMBER
3049 , p_address_id NUMBER
3050 , p_address_number VARCHAR2
3051 , p_planned_start_date date
3052 , p_planned_end_date date
3053 , p_scheduled_start_date date
3054 , p_scheduled_end_date date
3055 , p_actual_start_date date
3056 , p_actual_end_date date
3057 , p_timezone_id NUMBER
3058 , p_timezone_name VARCHAR2
3059 , p_source_object_type_code VARCHAR2
3060 , p_source_object_id NUMBER
3061 , p_source_object_name VARCHAR2
3062 , p_duration NUMBER
3063 , p_duration_uom VARCHAR2
3064 , p_planned_effort NUMBER
3065 , p_planned_effort_uom VARCHAR2
3066 , p_actual_effort NUMBER
3067 , p_actual_effort_uom VARCHAR2
3068 , p_percentage_complete NUMBER
3069 , p_reason_code VARCHAR2
3070 , p_private_flag VARCHAR2
3071 , p_publish_flag VARCHAR2
3072 , p_restrict_closure_flag VARCHAR2
3073 , p_multi_booked_flag VARCHAR2
3074 , p_milestone_flag VARCHAR2
3075 , p_holiday_flag VARCHAR2
3076 , p_billable_flag VARCHAR2
3077 , p_bound_mode_code VARCHAR2
3078 , p_soft_bound_flag VARCHAR2
3079 , p_workflow_process_id NUMBER
3080 , p_notification_flag VARCHAR2
3081 , p_notification_period NUMBER
3082 , p_notification_period_uom VARCHAR2
3083 , p_parent_task_number VARCHAR2
3084 , p_parent_task_id NUMBER
3085 , p_alarm_start NUMBER
3086 , p_alarm_start_uom VARCHAR2
3087 , p_alarm_on VARCHAR2
3088 , p_alarm_count NUMBER
3089 , p_alarm_interval NUMBER
3090 , p_alarm_interval_uom VARCHAR2
3091 , p_palm_flag VARCHAR2
3092 , p_wince_flag VARCHAR2
3093 , p_laptop_flag VARCHAR2
3094 , p_device1_flag VARCHAR2
3095 , p_device2_flag VARCHAR2
3096 , p_device3_flag VARCHAR2
3097 , p_costs NUMBER
3098 , p_currency_code VARCHAR2
3099 , p_escalation_level VARCHAR2
3100 , p73_a0 JTF_VARCHAR2_TABLE_100
3101 , p73_a1 JTF_NUMBER_TABLE
3102 , p73_a2 JTF_DATE_TABLE
3103 , p73_a3 JTF_DATE_TABLE
3104 , p73_a4 JTF_NUMBER_TABLE
3105 , p73_a5 JTF_VARCHAR2_TABLE_100
3106 , p73_a6 JTF_NUMBER_TABLE
3107 , p73_a7 JTF_NUMBER_TABLE
3108 , p73_a8 JTF_VARCHAR2_TABLE_100
3109 , p73_a9 JTF_NUMBER_TABLE
3113 , p73_a13 JTF_VARCHAR2_TABLE_100
3110 , p73_a10 JTF_NUMBER_TABLE
3111 , p73_a11 JTF_VARCHAR2_TABLE_100
3112 , p73_a12 JTF_VARCHAR2_TABLE_100
3114 , p73_a14 JTF_VARCHAR2_TABLE_200
3115 , p73_a15 JTF_VARCHAR2_TABLE_100
3116 , p73_a16 JTF_VARCHAR2_TABLE_100
3117 , p73_a17 JTF_VARCHAR2_TABLE_100
3118 , p73_a18 JTF_VARCHAR2_TABLE_100
3119 , p73_a19 JTF_VARCHAR2_TABLE_100
3120 , p73_a20 JTF_VARCHAR2_TABLE_100
3121 , p73_a21 JTF_NUMBER_TABLE
3122 , p73_a22 JTF_NUMBER_TABLE
3123 , p73_a23 JTF_NUMBER_TABLE
3124 , p73_a24 JTF_VARCHAR2_TABLE_100
3125 , p73_a25 JTF_NUMBER_TABLE
3126 , p74_a0 JTF_NUMBER_TABLE
3127 , p74_a1 JTF_NUMBER_TABLE
3128 , p74_a2 JTF_VARCHAR2_TABLE_100
3129 , p74_a3 JTF_NUMBER_TABLE
3130 , p74_a4 JTF_VARCHAR2_TABLE_100
3131 , p74_a5 JTF_VARCHAR2_TABLE_100
3132 , p75_a0 JTF_VARCHAR2_TABLE_100
3133 , p75_a1 JTF_NUMBER_TABLE
3134 , p75_a2 JTF_VARCHAR2_TABLE_100
3135 , p76_a0 JTF_VARCHAR2_TABLE_100
3136 , p76_a1 JTF_VARCHAR2_TABLE_100
3137 , p76_a2 JTF_VARCHAR2_TABLE_100
3138 , p76_a3 JTF_NUMBER_TABLE
3139 , p76_a4 JTF_VARCHAR2_TABLE_2000
3140 , p76_a5 JTF_VARCHAR2_TABLE_100
3141 , p76_a6 JTF_VARCHAR2_TABLE_2000
3142 , p77_a0 JTF_NUMBER_TABLE
3143 , p77_a1 JTF_VARCHAR2_TABLE_100
3144 , p77_a2 JTF_VARCHAR2_TABLE_100
3145 , p77_a3 JTF_DATE_TABLE
3146 , p78_a0 JTF_NUMBER_TABLE
3147 , p78_a1 JTF_NUMBER_TABLE
3148 , p78_a2 JTF_VARCHAR2_TABLE_4000
3149 , p78_a3 JTF_VARCHAR2_TABLE_32767
3150 , p78_a4 JTF_VARCHAR2_TABLE_100
3151 , p78_a5 JTF_NUMBER_TABLE
3152 , p78_a6 JTF_DATE_TABLE
3153 , p78_a7 JTF_VARCHAR2_TABLE_100
3154 , p78_a8 JTF_NUMBER_TABLE
3155 , p78_a9 JTF_VARCHAR2_TABLE_200
3156 , p78_a10 JTF_VARCHAR2_TABLE_200
3157 , p78_a11 JTF_VARCHAR2_TABLE_200
3158 , p78_a12 JTF_VARCHAR2_TABLE_200
3159 , p78_a13 JTF_VARCHAR2_TABLE_200
3160 , p78_a14 JTF_VARCHAR2_TABLE_200
3161 , p78_a15 JTF_VARCHAR2_TABLE_200
3162 , p78_a16 JTF_VARCHAR2_TABLE_200
3163 , p78_a17 JTF_VARCHAR2_TABLE_200
3164 , p78_a18 JTF_VARCHAR2_TABLE_200
3165 , p78_a19 JTF_VARCHAR2_TABLE_200
3166 , p78_a20 JTF_VARCHAR2_TABLE_200
3167 , p78_a21 JTF_VARCHAR2_TABLE_200
3168 , p78_a22 JTF_VARCHAR2_TABLE_200
3169 , p78_a23 JTF_VARCHAR2_TABLE_200
3170 , p78_a24 JTF_VARCHAR2_TABLE_100
3171 , p79_a0 NUMBER
3172 , p79_a1 NUMBER
3173 , p79_a2 NUMBER
3174 , p79_a3 NUMBER
3175 , p79_a4 VARCHAR2
3176 , p79_a5 NUMBER
3177 , p79_a6 NUMBER
3178 , p79_a7 DATE
3179 , p79_a8 DATE
3180 , p80_a0 JTF_NUMBER_TABLE
3181 , p80_a1 JTF_VARCHAR2_TABLE_100
3182 , p80_a2 JTF_VARCHAR2_TABLE_100
3183 , p80_a3 JTF_VARCHAR2_TABLE_100
3184 , x_return_status out nocopy VARCHAR2
3185 , x_msg_count out nocopy NUMBER
3186 , x_msg_data out nocopy VARCHAR2
3187 , x_task_id out nocopy NUMBER
3188 , p_attribute1 VARCHAR2
3189 , p_attribute2 VARCHAR2
3190 , p_attribute3 VARCHAR2
3191 , p_attribute4 VARCHAR2
3192 , p_attribute5 VARCHAR2
3193 , p_attribute6 VARCHAR2
3194 , p_attribute7 VARCHAR2
3195 , p_attribute8 VARCHAR2
3196 , p_attribute9 VARCHAR2
3197 , p_attribute10 VARCHAR2
3198 , p_attribute11 VARCHAR2
3199 , p_attribute12 VARCHAR2
3200 , p_attribute13 VARCHAR2
3201 , p_attribute14 VARCHAR2
3202 , p_attribute15 VARCHAR2
3203 , p_attribute_category VARCHAR2
3204 , p_date_selected VARCHAR2
3205 , p_category_id NUMBER
3206 , p_show_on_calendar VARCHAR2
3207 , p_owner_status_id NUMBER
3208 , p_template_id NUMBER
3209 , p_template_group_id NUMBER
3210 )
3211
3212 as
3213 ddp_planned_start_date date;
3214 ddp_planned_end_date date;
3215 ddp_scheduled_start_date date;
3216 ddp_scheduled_end_date date;
3217 ddp_actual_start_date date;
3218 ddp_actual_end_date date;
3219 ddp_task_assign_tbl jtf_tasks_pub.task_assign_tbl;
3220 ddp_task_depends_tbl jtf_tasks_pub.task_depends_tbl;
3221 ddp_task_rsrc_req_tbl jtf_tasks_pub.task_rsrc_req_tbl;
3222 ddp_task_refer_tbl jtf_tasks_pub.task_refer_tbl;
3223 ddp_task_dates_tbl jtf_tasks_pub.task_dates_tbl;
3224 ddp_task_notes_tbl jtf_tasks_pub.task_notes_tbl;
3225 ddp_task_recur_rec jtf_tasks_pub.task_recur_rec;
3226 ddp_task_contacts_tbl jtf_tasks_pub.task_contacts_tbl;
3227 ddindx binary_integer; indx binary_integer;
3228 begin
3229
3230 -- copy data to the local IN or IN-OUT args, if any
3231
3232
3233
3234
3235
3236
3237
3238
3239
3240
3241
3242
3243
3244
3245
3246
3247
3248
3249
3250
3251
3252
3253
3254
3255 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
3256
3257 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
3258
3262
3259 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
3260
3261 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
3263 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
3264
3265 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
3266
3267
3268
3269
3270
3271
3272
3273
3274
3275
3276
3277
3278
3279
3280
3281
3282
3283
3284
3285
3286
3287
3288
3289
3290
3291
3292
3293
3294
3295
3296
3297
3298
3299
3300
3301
3302
3303
3304
3305
3306
3307
3308
3309
3310 jtf_tasks_pub_w.rosetta_table_copy_in_p6(ddp_task_assign_tbl, p73_a0
3311 , p73_a1
3312 , p73_a2
3313 , p73_a3
3314 , p73_a4
3315 , p73_a5
3316 , p73_a6
3317 , p73_a7
3318 , p73_a8
3319 , p73_a9
3320 , p73_a10
3321 , p73_a11
3322 , p73_a12
3323 , p73_a13
3324 , p73_a14
3325 , p73_a15
3326 , p73_a16
3327 , p73_a17
3328 , p73_a18
3329 , p73_a19
3330 , p73_a20
3331 , p73_a21
3332 , p73_a22
3333 , p73_a23
3334 , p73_a24
3335 , p73_a25
3336 );
3337
3338 jtf_tasks_pub_w.rosetta_table_copy_in_p9(ddp_task_depends_tbl, p74_a0
3339 , p74_a1
3340 , p74_a2
3341 , p74_a3
3342 , p74_a4
3343 , p74_a5
3344 );
3345
3346 jtf_tasks_pub_w.rosetta_table_copy_in_p12(ddp_task_rsrc_req_tbl, p75_a0
3347 , p75_a1
3348 , p75_a2
3349 );
3350
3351 jtf_tasks_pub_w.rosetta_table_copy_in_p15(ddp_task_refer_tbl, p76_a0
3352 , p76_a1
3353 , p76_a2
3354 , p76_a3
3355 , p76_a4
3356 , p76_a5
3357 , p76_a6
3358 );
3359
3360 jtf_tasks_pub_w.rosetta_table_copy_in_p20(ddp_task_dates_tbl, p77_a0
3361 , p77_a1
3362 , p77_a2
3363 , p77_a3
3364 );
3365
3366 jtf_tasks_pub_w.rosetta_table_copy_in_p23(ddp_task_notes_tbl, p78_a0
3367 , p78_a1
3368 , p78_a2
3369 , p78_a3
3370 , p78_a4
3371 , p78_a5
3372 , p78_a6
3373 , p78_a7
3374 , p78_a8
3375 , p78_a9
3376 , p78_a10
3377 , p78_a11
3378 , p78_a12
3379 , p78_a13
3380 , p78_a14
3381 , p78_a15
3382 , p78_a16
3383 , p78_a17
3384 , p78_a18
3385 , p78_a19
3386 , p78_a20
3387 , p78_a21
3388 , p78_a22
3389 , p78_a23
3390 , p78_a24
3391 );
3392
3393 ddp_task_recur_rec.occurs_which := p79_a0;
3394 ddp_task_recur_rec.day_of_week := p79_a1;
3395 ddp_task_recur_rec.date_of_month := p79_a2;
3396 ddp_task_recur_rec.occurs_month := p79_a3;
3397 ddp_task_recur_rec.occurs_uom := p79_a4;
3398 ddp_task_recur_rec.occurs_every := p79_a5;
3399 ddp_task_recur_rec.occurs_number := p79_a6;
3400 ddp_task_recur_rec.start_date_active := rosetta_g_miss_date_in_map(p79_a7);
3401 ddp_task_recur_rec.end_date_active := rosetta_g_miss_date_in_map(p79_a8);
3402
3403 jtf_tasks_pub_w.rosetta_table_copy_in_p26(ddp_task_contacts_tbl, p80_a0
3404 , p80_a1
3405 , p80_a2
3406 , p80_a3
3407 );
3408
3409
3410
3411
3412
3413
3414
3415
3416
3417
3418
3419
3420
3421
3422
3423
3424
3425
3426
3427
3428
3429
3430
3431
3432
3433
3434
3435 -- here's the delegated call to the old PL/SQL routine
3436 jtf_tasks_pub.create_task(p_api_version,
3437 p_init_msg_list,
3438 p_commit,
3439 p_task_id,
3440 p_task_name,
3441 p_task_type_name,
3442 p_task_type_id,
3443 p_description,
3444 p_task_status_name,
3445 p_task_status_id,
3446 p_task_priority_name,
3447 p_task_priority_id,
3448 p_owner_type_name,
3449 p_owner_type_code,
3450 p_owner_id,
3451 p_owner_territory_id,
3452 p_assigned_by_name,
3453 p_assigned_by_id,
3454 p_customer_number,
3455 p_customer_id,
3456 p_cust_account_number,
3457 p_cust_account_id,
3458 p_address_id,
3459 p_address_number,
3460 ddp_planned_start_date,
3461 ddp_planned_end_date,
3462 ddp_scheduled_start_date,
3463 ddp_scheduled_end_date,
3464 ddp_actual_start_date,
3465 ddp_actual_end_date,
3466 p_timezone_id,
3467 p_timezone_name,
3468 p_source_object_type_code,
3469 p_source_object_id,
3473 p_planned_effort,
3470 p_source_object_name,
3471 p_duration,
3472 p_duration_uom,
3474 p_planned_effort_uom,
3475 p_actual_effort,
3476 p_actual_effort_uom,
3477 p_percentage_complete,
3478 p_reason_code,
3479 p_private_flag,
3480 p_publish_flag,
3481 p_restrict_closure_flag,
3482 p_multi_booked_flag,
3483 p_milestone_flag,
3484 p_holiday_flag,
3485 p_billable_flag,
3486 p_bound_mode_code,
3487 p_soft_bound_flag,
3488 p_workflow_process_id,
3489 p_notification_flag,
3490 p_notification_period,
3491 p_notification_period_uom,
3492 p_parent_task_number,
3493 p_parent_task_id,
3494 p_alarm_start,
3495 p_alarm_start_uom,
3496 p_alarm_on,
3497 p_alarm_count,
3498 p_alarm_interval,
3499 p_alarm_interval_uom,
3500 p_palm_flag,
3501 p_wince_flag,
3502 p_laptop_flag,
3503 p_device1_flag,
3504 p_device2_flag,
3505 p_device3_flag,
3506 p_costs,
3507 p_currency_code,
3508 p_escalation_level,
3509 ddp_task_assign_tbl,
3510 ddp_task_depends_tbl,
3511 ddp_task_rsrc_req_tbl,
3512 ddp_task_refer_tbl,
3513 ddp_task_dates_tbl,
3514 ddp_task_notes_tbl,
3515 ddp_task_recur_rec,
3516 ddp_task_contacts_tbl,
3517 x_return_status,
3518 x_msg_count,
3519 x_msg_data,
3520 x_task_id,
3521 p_attribute1,
3522 p_attribute2,
3523 p_attribute3,
3524 p_attribute4,
3525 p_attribute5,
3526 p_attribute6,
3527 p_attribute7,
3528 p_attribute8,
3529 p_attribute9,
3530 p_attribute10,
3531 p_attribute11,
3532 p_attribute12,
3533 p_attribute13,
3534 p_attribute14,
3535 p_attribute15,
3536 p_attribute_category,
3537 p_date_selected,
3538 p_category_id,
3539 p_show_on_calendar,
3540 p_owner_status_id,
3541 p_template_id,
3542 p_template_group_id);
3543
3544 -- copy data back from the local variables to OUT or IN-OUT args, if any
3545
3546
3547
3548
3549
3550
3551
3552
3553
3554
3555
3556
3557
3558
3559
3560
3561
3562
3563
3564
3565
3566
3567
3568
3569
3570
3571
3572
3573
3574
3575
3576
3577
3578
3579
3580
3581
3582
3583
3584
3585
3586
3587
3588
3589
3590
3591
3592
3593
3594
3595
3596
3597
3598
3599
3600
3601
3602
3603
3604
3605
3606
3607
3608
3609
3610
3611
3612
3613
3614
3615
3616
3617
3618
3619
3620
3621
3622
3623
3624
3625
3626
3627
3628
3629
3630
3631
3632
3633
3634
3635
3636
3637
3638
3639
3640
3641
3642
3643
3644
3645
3646
3647
3648
3649
3650
3651 end;
3652
3653 procedure update_task(p_api_version NUMBER
3654 , p_init_msg_list VARCHAR2
3655 , p_commit VARCHAR2
3656 , p_object_version_number in out nocopy NUMBER
3657 , p_task_id NUMBER
3658 , p_task_number VARCHAR2
3659 , p_task_name VARCHAR2
3660 , p_task_type_name VARCHAR2
3661 , p_task_type_id NUMBER
3662 , p_description VARCHAR2
3663 , p_task_status_name VARCHAR2
3664 , p_task_status_id NUMBER
3665 , p_task_priority_name VARCHAR2
3666 , p_task_priority_id NUMBER
3667 , p_owner_type_name VARCHAR2
3668 , p_owner_type_code VARCHAR2
3669 , p_owner_id NUMBER
3670 , p_owner_territory_id NUMBER
3671 , p_assigned_by_name VARCHAR2
3672 , p_assigned_by_id NUMBER
3673 , p_customer_number VARCHAR2
3674 , p_customer_id NUMBER
3675 , p_cust_account_number VARCHAR2
3676 , p_cust_account_id NUMBER
3677 , p_address_id NUMBER
3678 , p_address_number VARCHAR2
3679 , p_planned_start_date date
3680 , p_planned_end_date date
3681 , p_scheduled_start_date date
3682 , p_scheduled_end_date date
3683 , p_actual_start_date date
3684 , p_actual_end_date date
3685 , p_timezone_id NUMBER
3686 , p_timezone_name VARCHAR2
3687 , p_source_object_type_code VARCHAR2
3688 , p_source_object_id NUMBER
3689 , p_source_object_name VARCHAR2
3690 , p_duration NUMBER
3691 , p_duration_uom VARCHAR2
3692 , p_planned_effort NUMBER
3693 , p_planned_effort_uom VARCHAR2
3694 , p_actual_effort NUMBER
3695 , p_actual_effort_uom VARCHAR2
3696 , p_percentage_complete NUMBER
3697 , p_reason_code VARCHAR2
3698 , p_private_flag VARCHAR2
3702 , p_milestone_flag VARCHAR2
3699 , p_publish_flag VARCHAR2
3700 , p_restrict_closure_flag VARCHAR2
3701 , p_multi_booked_flag VARCHAR2
3703 , p_holiday_flag VARCHAR2
3704 , p_billable_flag VARCHAR2
3705 , p_bound_mode_code VARCHAR2
3706 , p_soft_bound_flag VARCHAR2
3707 , p_workflow_process_id NUMBER
3708 , p_notification_flag VARCHAR2
3709 , p_notification_period NUMBER
3710 , p_notification_period_uom VARCHAR2
3711 , p_alarm_start NUMBER
3712 , p_alarm_start_uom VARCHAR2
3713 , p_alarm_on VARCHAR2
3714 , p_alarm_count NUMBER
3715 , p_alarm_fired_count NUMBER
3716 , p_alarm_interval NUMBER
3717 , p_alarm_interval_uom VARCHAR2
3718 , p_palm_flag VARCHAR2
3719 , p_wince_flag VARCHAR2
3720 , p_laptop_flag VARCHAR2
3721 , p_device1_flag VARCHAR2
3722 , p_device2_flag VARCHAR2
3723 , p_device3_flag VARCHAR2
3724 , p_costs NUMBER
3725 , p_currency_code VARCHAR2
3726 , p_escalation_level VARCHAR2
3727 , x_return_status out nocopy VARCHAR2
3728 , x_msg_count out nocopy NUMBER
3729 , x_msg_data out nocopy VARCHAR2
3730 , p_attribute1 VARCHAR2
3731 , p_attribute2 VARCHAR2
3732 , p_attribute3 VARCHAR2
3733 , p_attribute4 VARCHAR2
3734 , p_attribute5 VARCHAR2
3735 , p_attribute6 VARCHAR2
3736 , p_attribute7 VARCHAR2
3737 , p_attribute8 VARCHAR2
3738 , p_attribute9 VARCHAR2
3739 , p_attribute10 VARCHAR2
3740 , p_attribute11 VARCHAR2
3741 , p_attribute12 VARCHAR2
3742 , p_attribute13 VARCHAR2
3743 , p_attribute14 VARCHAR2
3744 , p_attribute15 VARCHAR2
3745 , p_attribute_category VARCHAR2
3746 , p_date_selected VARCHAR2
3747 , p_category_id NUMBER
3748 , p_show_on_calendar VARCHAR2
3749 , p_owner_status_id NUMBER
3750 , p_parent_task_id NUMBER
3751 , p_parent_task_number VARCHAR2
3752 , p_enable_workflow VARCHAR2
3753 , p_abort_workflow VARCHAR2
3754 , p_task_split_flag VARCHAR2
3755 , p_child_position VARCHAR2
3756 , p_child_sequence_num NUMBER
3757 , p_location_id NUMBER
3758 )
3759
3760 as
3761 ddp_planned_start_date date;
3762 ddp_planned_end_date date;
3763 ddp_scheduled_start_date date;
3764 ddp_scheduled_end_date date;
3765 ddp_actual_start_date date;
3766 ddp_actual_end_date date;
3767 ddindx binary_integer; indx binary_integer;
3768 begin
3769
3770 -- copy data to the local IN or IN-OUT args, if any
3771
3772
3773
3774
3775
3776
3777
3778
3779
3780
3781
3782
3783
3784
3785
3786
3787
3788
3789
3790
3791
3792
3793
3794
3795
3796
3797 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
3798
3799 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
3800
3801 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
3802
3803 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
3804
3805 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
3806
3807 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
3808
3809
3810
3811
3812
3813
3814
3815
3816
3817
3818
3819
3820
3821
3822
3823
3824
3825
3826
3827
3828
3829
3830
3831
3832
3833
3834
3835
3836
3837
3838
3839
3840
3841
3842
3843
3844
3845
3846
3847
3848
3849
3850
3851
3852
3853
3854
3855
3856
3857
3858
3859
3860
3861
3862
3863
3864
3865
3866
3867
3868
3869
3870
3871
3872
3873
3874
3875
3876
3877
3878
3879
3880
3881
3882 -- here's the delegated call to the old PL/SQL routine
3883 jtf_tasks_pub.update_task(p_api_version,
3884 p_init_msg_list,
3885 p_commit,
3886 p_object_version_number,
3887 p_task_id,
3888 p_task_number,
3889 p_task_name,
3890 p_task_type_name,
3891 p_task_type_id,
3892 p_description,
3893 p_task_status_name,
3894 p_task_status_id,
3895 p_task_priority_name,
3896 p_task_priority_id,
3897 p_owner_type_name,
3898 p_owner_type_code,
3899 p_owner_id,
3900 p_owner_territory_id,
3901 p_assigned_by_name,
3902 p_assigned_by_id,
3903 p_customer_number,
3904 p_customer_id,
3905 p_cust_account_number,
3906 p_cust_account_id,
3907 p_address_id,
3908 p_address_number,
3909 ddp_planned_start_date,
3910 ddp_planned_end_date,
3911 ddp_scheduled_start_date,
3915 p_timezone_id,
3912 ddp_scheduled_end_date,
3913 ddp_actual_start_date,
3914 ddp_actual_end_date,
3916 p_timezone_name,
3917 p_source_object_type_code,
3918 p_source_object_id,
3919 p_source_object_name,
3920 p_duration,
3921 p_duration_uom,
3922 p_planned_effort,
3923 p_planned_effort_uom,
3924 p_actual_effort,
3925 p_actual_effort_uom,
3926 p_percentage_complete,
3927 p_reason_code,
3928 p_private_flag,
3929 p_publish_flag,
3930 p_restrict_closure_flag,
3931 p_multi_booked_flag,
3932 p_milestone_flag,
3933 p_holiday_flag,
3934 p_billable_flag,
3935 p_bound_mode_code,
3936 p_soft_bound_flag,
3937 p_workflow_process_id,
3938 p_notification_flag,
3939 p_notification_period,
3940 p_notification_period_uom,
3941 p_alarm_start,
3942 p_alarm_start_uom,
3943 p_alarm_on,
3944 p_alarm_count,
3945 p_alarm_fired_count,
3946 p_alarm_interval,
3947 p_alarm_interval_uom,
3948 p_palm_flag,
3949 p_wince_flag,
3950 p_laptop_flag,
3951 p_device1_flag,
3952 p_device2_flag,
3953 p_device3_flag,
3954 p_costs,
3955 p_currency_code,
3956 p_escalation_level,
3957 x_return_status,
3958 x_msg_count,
3959 x_msg_data,
3960 p_attribute1,
3961 p_attribute2,
3962 p_attribute3,
3963 p_attribute4,
3964 p_attribute5,
3965 p_attribute6,
3966 p_attribute7,
3967 p_attribute8,
3968 p_attribute9,
3969 p_attribute10,
3970 p_attribute11,
3971 p_attribute12,
3972 p_attribute13,
3973 p_attribute14,
3974 p_attribute15,
3975 p_attribute_category,
3976 p_date_selected,
3977 p_category_id,
3978 p_show_on_calendar,
3979 p_owner_status_id,
3980 p_parent_task_id,
3981 p_parent_task_number,
3982 p_enable_workflow,
3983 p_abort_workflow,
3984 p_task_split_flag,
3985 p_child_position,
3986 p_child_sequence_num,
3987 p_location_id);
3988
3989 -- copy data back from the local variables to OUT or IN-OUT args, if any
3990
3991
3992
3993
3994
3995
3996
3997
3998
3999
4000
4001
4002
4003
4004
4005
4006
4007
4008
4009
4010
4011
4012
4013
4014
4015
4016
4017
4018
4019
4020
4021
4022
4023
4024
4025
4026
4027
4028
4029
4030
4031
4032
4033
4034
4035
4036
4037
4038
4039
4040
4041
4042
4043
4044
4045
4046
4047
4048
4049
4050
4051
4052
4053
4054
4055
4056
4057
4058
4059
4060
4061
4062
4063
4064
4065
4066
4067
4068
4069
4070
4071
4072
4073
4074
4075
4076
4077
4078
4079
4080
4081
4082
4083
4084
4085
4086
4087
4088
4089
4090
4091
4092
4093
4094 end;
4095
4096 procedure update_task(p_api_version NUMBER
4097 , p_init_msg_list VARCHAR2
4098 , p_commit VARCHAR2
4099 , p_object_version_number in out nocopy NUMBER
4100 , p_task_id NUMBER
4101 , p_task_number VARCHAR2
4102 , p_task_name VARCHAR2
4103 , p_task_type_name VARCHAR2
4104 , p_task_type_id NUMBER
4105 , p_description VARCHAR2
4106 , p_task_status_name VARCHAR2
4107 , p_task_status_id NUMBER
4108 , p_task_priority_name VARCHAR2
4109 , p_task_priority_id NUMBER
4110 , p_owner_type_name VARCHAR2
4111 , p_owner_type_code VARCHAR2
4112 , p_owner_id NUMBER
4113 , p_owner_territory_id NUMBER
4114 , p_assigned_by_name VARCHAR2
4115 , p_assigned_by_id NUMBER
4116 , p_customer_number VARCHAR2
4117 , p_customer_id NUMBER
4118 , p_cust_account_number VARCHAR2
4119 , p_cust_account_id NUMBER
4120 , p_address_id NUMBER
4121 , p_address_number VARCHAR2
4122 , p_planned_start_date date
4123 , p_planned_end_date date
4124 , p_scheduled_start_date date
4125 , p_scheduled_end_date date
4126 , p_actual_start_date date
4127 , p_actual_end_date date
4128 , p_timezone_id NUMBER
4129 , p_timezone_name VARCHAR2
4130 , p_source_object_type_code VARCHAR2
4131 , p_source_object_id NUMBER
4132 , p_source_object_name VARCHAR2
4133 , p_duration NUMBER
4134 , p_duration_uom VARCHAR2
4135 , p_planned_effort NUMBER
4136 , p_planned_effort_uom VARCHAR2
4137 , p_actual_effort NUMBER
4138 , p_actual_effort_uom VARCHAR2
4139 , p_percentage_complete NUMBER
4140 , p_reason_code VARCHAR2
4144 , p_multi_booked_flag VARCHAR2
4141 , p_private_flag VARCHAR2
4142 , p_publish_flag VARCHAR2
4143 , p_restrict_closure_flag VARCHAR2
4145 , p_milestone_flag VARCHAR2
4146 , p_holiday_flag VARCHAR2
4147 , p_billable_flag VARCHAR2
4148 , p_bound_mode_code VARCHAR2
4149 , p_soft_bound_flag VARCHAR2
4150 , p_workflow_process_id NUMBER
4151 , p_notification_flag VARCHAR2
4152 , p_notification_period NUMBER
4153 , p_notification_period_uom VARCHAR2
4154 , p_alarm_start NUMBER
4155 , p_alarm_start_uom VARCHAR2
4156 , p_alarm_on VARCHAR2
4157 , p_alarm_count NUMBER
4158 , p_alarm_fired_count NUMBER
4159 , p_alarm_interval NUMBER
4160 , p_alarm_interval_uom VARCHAR2
4161 , p_palm_flag VARCHAR2
4162 , p_wince_flag VARCHAR2
4163 , p_laptop_flag VARCHAR2
4164 , p_device1_flag VARCHAR2
4165 , p_device2_flag VARCHAR2
4166 , p_device3_flag VARCHAR2
4167 , p_costs NUMBER
4168 , p_currency_code VARCHAR2
4169 , p_escalation_level VARCHAR2
4170 , x_return_status out nocopy VARCHAR2
4171 , x_msg_count out nocopy NUMBER
4172 , x_msg_data out nocopy VARCHAR2
4173 , p_attribute1 VARCHAR2
4174 , p_attribute2 VARCHAR2
4175 , p_attribute3 VARCHAR2
4176 , p_attribute4 VARCHAR2
4177 , p_attribute5 VARCHAR2
4178 , p_attribute6 VARCHAR2
4179 , p_attribute7 VARCHAR2
4180 , p_attribute8 VARCHAR2
4181 , p_attribute9 VARCHAR2
4182 , p_attribute10 VARCHAR2
4183 , p_attribute11 VARCHAR2
4184 , p_attribute12 VARCHAR2
4185 , p_attribute13 VARCHAR2
4186 , p_attribute14 VARCHAR2
4187 , p_attribute15 VARCHAR2
4188 , p_attribute_category VARCHAR2
4189 , p_date_selected VARCHAR2
4190 , p_category_id NUMBER
4191 , p_show_on_calendar VARCHAR2
4192 , p_owner_status_id NUMBER
4193 , p_parent_task_id NUMBER
4194 , p_parent_task_number VARCHAR2
4195 , p_enable_workflow VARCHAR2
4196 , p_abort_workflow VARCHAR2
4197 , p_task_split_flag VARCHAR2
4198 , p_child_position VARCHAR2
4199 , p_child_sequence_num NUMBER
4200 )
4201
4202 as
4203 ddp_planned_start_date date;
4204 ddp_planned_end_date date;
4205 ddp_scheduled_start_date date;
4206 ddp_scheduled_end_date date;
4207 ddp_actual_start_date date;
4208 ddp_actual_end_date date;
4209 ddindx binary_integer; indx binary_integer;
4210 begin
4211
4212 -- copy data to the local IN or IN-OUT args, if any
4213
4214
4215
4216
4217
4218
4219
4220
4221
4222
4223
4224
4225
4226
4227
4228
4229
4230
4231
4232
4233
4234
4235
4236
4237
4238
4239 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
4240
4241 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
4242
4243 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
4244
4245 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
4246
4247 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
4248
4249 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
4250
4251
4252
4253
4254
4255
4256
4257
4258
4259
4260
4261
4262
4263
4264
4265
4266
4267
4268
4269
4270
4271
4272
4273
4274
4275
4276
4277
4278
4279
4280
4281
4282
4283
4284
4285
4286
4287
4288
4289
4290
4291
4292
4293
4294
4295
4296
4297
4298
4299
4300
4301
4302
4303
4304
4305
4306
4307
4308
4309
4310
4311
4312
4313
4314
4315
4316
4317
4318
4319
4320
4321
4322
4323 -- here's the delegated call to the old PL/SQL routine
4324 jtf_tasks_pub.update_task(p_api_version,
4325 p_init_msg_list,
4326 p_commit,
4327 p_object_version_number,
4328 p_task_id,
4329 p_task_number,
4330 p_task_name,
4331 p_task_type_name,
4332 p_task_type_id,
4333 p_description,
4334 p_task_status_name,
4335 p_task_status_id,
4336 p_task_priority_name,
4337 p_task_priority_id,
4338 p_owner_type_name,
4339 p_owner_type_code,
4340 p_owner_id,
4341 p_owner_territory_id,
4342 p_assigned_by_name,
4343 p_assigned_by_id,
4344 p_customer_number,
4345 p_customer_id,
4346 p_cust_account_number,
4347 p_cust_account_id,
4348 p_address_id,
4349 p_address_number,
4350 ddp_planned_start_date,
4354 ddp_actual_start_date,
4351 ddp_planned_end_date,
4352 ddp_scheduled_start_date,
4353 ddp_scheduled_end_date,
4355 ddp_actual_end_date,
4356 p_timezone_id,
4357 p_timezone_name,
4358 p_source_object_type_code,
4359 p_source_object_id,
4360 p_source_object_name,
4361 p_duration,
4362 p_duration_uom,
4363 p_planned_effort,
4364 p_planned_effort_uom,
4365 p_actual_effort,
4366 p_actual_effort_uom,
4367 p_percentage_complete,
4368 p_reason_code,
4369 p_private_flag,
4370 p_publish_flag,
4371 p_restrict_closure_flag,
4372 p_multi_booked_flag,
4373 p_milestone_flag,
4374 p_holiday_flag,
4375 p_billable_flag,
4376 p_bound_mode_code,
4377 p_soft_bound_flag,
4378 p_workflow_process_id,
4379 p_notification_flag,
4380 p_notification_period,
4381 p_notification_period_uom,
4382 p_alarm_start,
4383 p_alarm_start_uom,
4384 p_alarm_on,
4385 p_alarm_count,
4386 p_alarm_fired_count,
4387 p_alarm_interval,
4388 p_alarm_interval_uom,
4389 p_palm_flag,
4390 p_wince_flag,
4391 p_laptop_flag,
4392 p_device1_flag,
4393 p_device2_flag,
4394 p_device3_flag,
4395 p_costs,
4396 p_currency_code,
4397 p_escalation_level,
4398 x_return_status,
4399 x_msg_count,
4400 x_msg_data,
4401 p_attribute1,
4402 p_attribute2,
4403 p_attribute3,
4404 p_attribute4,
4405 p_attribute5,
4406 p_attribute6,
4407 p_attribute7,
4408 p_attribute8,
4409 p_attribute9,
4410 p_attribute10,
4411 p_attribute11,
4412 p_attribute12,
4413 p_attribute13,
4414 p_attribute14,
4415 p_attribute15,
4416 p_attribute_category,
4417 p_date_selected,
4418 p_category_id,
4419 p_show_on_calendar,
4420 p_owner_status_id,
4421 p_parent_task_id,
4422 p_parent_task_number,
4423 p_enable_workflow,
4424 p_abort_workflow,
4425 p_task_split_flag,
4426 p_child_position,
4427 p_child_sequence_num);
4428
4429 -- copy data back from the local variables to OUT or IN-OUT args, if any
4430
4431
4432
4433
4434
4435
4436
4437
4438
4439
4440
4441
4442
4443
4444
4445
4446
4447
4448
4449
4450
4451
4452
4453
4454
4455
4456
4457
4458
4459
4460
4461
4462
4463
4464
4465
4466
4467
4468
4469
4470
4471
4472
4473
4474
4475
4476
4477
4478
4479
4480
4481
4482
4483
4484
4485
4486
4487
4488
4489
4490
4491
4492
4493
4494
4495
4496
4497
4498
4499
4500
4501
4502
4503
4504
4505
4506
4507
4508
4509
4510
4511
4512
4513
4514
4515
4516
4517
4518
4519
4520
4521
4522
4523
4524
4525
4526
4527
4528
4529
4530
4531
4532
4533 end;
4534
4535 procedure update_task(p_api_version NUMBER
4536 , p_init_msg_list VARCHAR2
4537 , p_commit VARCHAR2
4538 , p_object_version_number in out nocopy NUMBER
4539 , p_task_id NUMBER
4540 , p_task_number VARCHAR2
4541 , p_task_name VARCHAR2
4542 , p_task_type_name VARCHAR2
4543 , p_task_type_id NUMBER
4544 , p_description VARCHAR2
4545 , p_task_status_name VARCHAR2
4546 , p_task_status_id NUMBER
4547 , p_task_priority_name VARCHAR2
4548 , p_task_priority_id NUMBER
4549 , p_owner_type_name VARCHAR2
4550 , p_owner_type_code VARCHAR2
4551 , p_owner_id NUMBER
4552 , p_owner_territory_id NUMBER
4553 , p_assigned_by_name VARCHAR2
4554 , p_assigned_by_id NUMBER
4555 , p_customer_number VARCHAR2
4556 , p_customer_id NUMBER
4557 , p_cust_account_number VARCHAR2
4558 , p_cust_account_id NUMBER
4559 , p_address_id NUMBER
4560 , p_address_number VARCHAR2
4561 , p_planned_start_date date
4562 , p_planned_end_date date
4563 , p_scheduled_start_date date
4564 , p_scheduled_end_date date
4565 , p_actual_start_date date
4566 , p_actual_end_date date
4567 , p_timezone_id NUMBER
4568 , p_timezone_name VARCHAR2
4569 , p_source_object_type_code VARCHAR2
4570 , p_source_object_id NUMBER
4571 , p_source_object_name VARCHAR2
4572 , p_duration NUMBER
4573 , p_duration_uom VARCHAR2
4574 , p_planned_effort NUMBER
4578 , p_percentage_complete NUMBER
4575 , p_planned_effort_uom VARCHAR2
4576 , p_actual_effort NUMBER
4577 , p_actual_effort_uom VARCHAR2
4579 , p_reason_code VARCHAR2
4580 , p_private_flag VARCHAR2
4581 , p_publish_flag VARCHAR2
4582 , p_restrict_closure_flag VARCHAR2
4583 , p_multi_booked_flag VARCHAR2
4584 , p_milestone_flag VARCHAR2
4585 , p_holiday_flag VARCHAR2
4586 , p_billable_flag VARCHAR2
4587 , p_bound_mode_code VARCHAR2
4588 , p_soft_bound_flag VARCHAR2
4589 , p_workflow_process_id NUMBER
4590 , p_notification_flag VARCHAR2
4591 , p_notification_period NUMBER
4592 , p_notification_period_uom VARCHAR2
4593 , p_alarm_start NUMBER
4594 , p_alarm_start_uom VARCHAR2
4595 , p_alarm_on VARCHAR2
4596 , p_alarm_count NUMBER
4597 , p_alarm_fired_count NUMBER
4598 , p_alarm_interval NUMBER
4599 , p_alarm_interval_uom VARCHAR2
4600 , p_palm_flag VARCHAR2
4601 , p_wince_flag VARCHAR2
4602 , p_laptop_flag VARCHAR2
4603 , p_device1_flag VARCHAR2
4604 , p_device2_flag VARCHAR2
4605 , p_device3_flag VARCHAR2
4606 , p_costs NUMBER
4607 , p_currency_code VARCHAR2
4608 , p_escalation_level VARCHAR2
4609 , x_return_status out nocopy VARCHAR2
4610 , x_msg_count out nocopy NUMBER
4611 , x_msg_data out nocopy VARCHAR2
4612 , p_attribute1 VARCHAR2
4613 , p_attribute2 VARCHAR2
4614 , p_attribute3 VARCHAR2
4615 , p_attribute4 VARCHAR2
4616 , p_attribute5 VARCHAR2
4617 , p_attribute6 VARCHAR2
4618 , p_attribute7 VARCHAR2
4619 , p_attribute8 VARCHAR2
4620 , p_attribute9 VARCHAR2
4621 , p_attribute10 VARCHAR2
4622 , p_attribute11 VARCHAR2
4623 , p_attribute12 VARCHAR2
4624 , p_attribute13 VARCHAR2
4625 , p_attribute14 VARCHAR2
4626 , p_attribute15 VARCHAR2
4627 , p_attribute_category VARCHAR2
4628 , p_date_selected VARCHAR2
4629 , p_category_id NUMBER
4630 , p_show_on_calendar VARCHAR2
4631 , p_owner_status_id NUMBER
4632 , p_parent_task_id NUMBER
4633 , p_parent_task_number VARCHAR2
4634 , p_enable_workflow VARCHAR2
4635 , p_abort_workflow VARCHAR2
4636 )
4637
4638 as
4639 ddp_planned_start_date date;
4640 ddp_planned_end_date date;
4641 ddp_scheduled_start_date date;
4642 ddp_scheduled_end_date date;
4643 ddp_actual_start_date date;
4644 ddp_actual_end_date date;
4645 ddindx binary_integer; indx binary_integer;
4646 begin
4647
4648 -- copy data to the local IN or IN-OUT args, if any
4649
4650
4651
4652
4653
4654
4655
4656
4657
4658
4659
4660
4661
4662
4663
4664
4665
4666
4667
4668
4669
4670
4671
4672
4673
4674
4675 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
4676
4677 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
4678
4679 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
4680
4681 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
4682
4683 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
4684
4685 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
4686
4687
4688
4689
4690
4691
4692
4693
4694
4695
4696
4697
4698
4699
4700
4701
4702
4703
4704
4705
4706
4707
4708
4709
4710
4711
4712
4713
4714
4715
4716
4717
4718
4719
4720
4721
4722
4723
4724
4725
4726
4727
4728
4729
4730
4731
4732
4733
4734
4735
4736
4737
4738
4739
4740
4741
4742
4743
4744
4745
4746
4747
4748
4749
4750
4751
4752
4753
4754
4755
4756 -- here's the delegated call to the old PL/SQL routine
4757 jtf_tasks_pub.update_task(p_api_version,
4758 p_init_msg_list,
4759 p_commit,
4760 p_object_version_number,
4761 p_task_id,
4762 p_task_number,
4763 p_task_name,
4764 p_task_type_name,
4765 p_task_type_id,
4766 p_description,
4767 p_task_status_name,
4768 p_task_status_id,
4769 p_task_priority_name,
4770 p_task_priority_id,
4771 p_owner_type_name,
4772 p_owner_type_code,
4773 p_owner_id,
4774 p_owner_territory_id,
4775 p_assigned_by_name,
4776 p_assigned_by_id,
4777 p_customer_number,
4778 p_customer_id,
4779 p_cust_account_number,
4780 p_cust_account_id,
4781 p_address_id,
4782 p_address_number,
4783 ddp_planned_start_date,
4784 ddp_planned_end_date,
4785 ddp_scheduled_start_date,
4789 p_timezone_id,
4786 ddp_scheduled_end_date,
4787 ddp_actual_start_date,
4788 ddp_actual_end_date,
4790 p_timezone_name,
4791 p_source_object_type_code,
4792 p_source_object_id,
4793 p_source_object_name,
4794 p_duration,
4795 p_duration_uom,
4796 p_planned_effort,
4797 p_planned_effort_uom,
4798 p_actual_effort,
4799 p_actual_effort_uom,
4800 p_percentage_complete,
4801 p_reason_code,
4802 p_private_flag,
4803 p_publish_flag,
4804 p_restrict_closure_flag,
4805 p_multi_booked_flag,
4806 p_milestone_flag,
4807 p_holiday_flag,
4808 p_billable_flag,
4809 p_bound_mode_code,
4810 p_soft_bound_flag,
4811 p_workflow_process_id,
4812 p_notification_flag,
4813 p_notification_period,
4814 p_notification_period_uom,
4815 p_alarm_start,
4816 p_alarm_start_uom,
4817 p_alarm_on,
4818 p_alarm_count,
4819 p_alarm_fired_count,
4820 p_alarm_interval,
4821 p_alarm_interval_uom,
4822 p_palm_flag,
4823 p_wince_flag,
4824 p_laptop_flag,
4825 p_device1_flag,
4826 p_device2_flag,
4827 p_device3_flag,
4828 p_costs,
4829 p_currency_code,
4830 p_escalation_level,
4831 x_return_status,
4832 x_msg_count,
4833 x_msg_data,
4834 p_attribute1,
4835 p_attribute2,
4836 p_attribute3,
4837 p_attribute4,
4838 p_attribute5,
4839 p_attribute6,
4840 p_attribute7,
4841 p_attribute8,
4842 p_attribute9,
4843 p_attribute10,
4844 p_attribute11,
4845 p_attribute12,
4846 p_attribute13,
4847 p_attribute14,
4848 p_attribute15,
4849 p_attribute_category,
4850 p_date_selected,
4851 p_category_id,
4852 p_show_on_calendar,
4853 p_owner_status_id,
4854 p_parent_task_id,
4855 p_parent_task_number,
4856 p_enable_workflow,
4857 p_abort_workflow);
4858
4859 -- copy data back from the local variables to OUT or IN-OUT args, if any
4860
4861
4862
4863
4864
4865
4866
4867
4868
4869
4870
4871
4872
4873
4874
4875
4876
4877
4878
4879
4880
4881
4882
4883
4884
4885
4886
4887
4888
4889
4890
4891
4892
4893
4894
4895
4896
4897
4898
4899
4900
4901
4902
4903
4904
4905
4906
4907
4908
4909
4910
4911
4912
4913
4914
4915
4916
4917
4918
4919
4920
4921
4922
4923
4924
4925
4926
4927
4928
4929
4930
4931
4932
4933
4934
4935
4936
4937
4938
4939
4940
4941
4942
4943
4944
4945
4946
4947
4948
4949
4950
4951
4952
4953
4954
4955
4956
4957
4958
4959
4960 end;
4961
4962 procedure update_task(p_api_version NUMBER
4963 , p_init_msg_list VARCHAR2
4964 , p_commit VARCHAR2
4965 , p_object_version_number in out nocopy NUMBER
4966 , p_task_id NUMBER
4967 , p_task_number VARCHAR2
4968 , p_task_name VARCHAR2
4969 , p_task_type_name VARCHAR2
4970 , p_task_type_id NUMBER
4971 , p_description VARCHAR2
4972 , p_task_status_name VARCHAR2
4973 , p_task_status_id NUMBER
4974 , p_task_priority_name VARCHAR2
4975 , p_task_priority_id NUMBER
4976 , p_owner_type_name VARCHAR2
4977 , p_owner_type_code VARCHAR2
4978 , p_owner_id NUMBER
4979 , p_owner_territory_id NUMBER
4980 , p_assigned_by_name VARCHAR2
4981 , p_assigned_by_id NUMBER
4982 , p_customer_number VARCHAR2
4983 , p_customer_id NUMBER
4984 , p_cust_account_number VARCHAR2
4985 , p_cust_account_id NUMBER
4986 , p_address_id NUMBER
4987 , p_address_number VARCHAR2
4988 , p_planned_start_date date
4989 , p_planned_end_date date
4990 , p_scheduled_start_date date
4991 , p_scheduled_end_date date
4992 , p_actual_start_date date
4993 , p_actual_end_date date
4994 , p_timezone_id NUMBER
4995 , p_timezone_name VARCHAR2
4996 , p_source_object_type_code VARCHAR2
4997 , p_source_object_id NUMBER
4998 , p_source_object_name VARCHAR2
4999 , p_duration NUMBER
5000 , p_duration_uom VARCHAR2
5001 , p_planned_effort NUMBER
5002 , p_planned_effort_uom VARCHAR2
5003 , p_actual_effort NUMBER
5004 , p_actual_effort_uom VARCHAR2
5005 , p_percentage_complete NUMBER
5006 , p_reason_code VARCHAR2
5007 , p_private_flag VARCHAR2
5008 , p_publish_flag VARCHAR2
5012 , p_holiday_flag VARCHAR2
5009 , p_restrict_closure_flag VARCHAR2
5010 , p_multi_booked_flag VARCHAR2
5011 , p_milestone_flag VARCHAR2
5013 , p_billable_flag VARCHAR2
5014 , p_bound_mode_code VARCHAR2
5015 , p_soft_bound_flag VARCHAR2
5016 , p_workflow_process_id NUMBER
5017 , p_notification_flag VARCHAR2
5018 , p_notification_period NUMBER
5019 , p_notification_period_uom VARCHAR2
5020 , p_alarm_start NUMBER
5021 , p_alarm_start_uom VARCHAR2
5022 , p_alarm_on VARCHAR2
5023 , p_alarm_count NUMBER
5024 , p_alarm_fired_count NUMBER
5025 , p_alarm_interval NUMBER
5026 , p_alarm_interval_uom VARCHAR2
5027 , p_palm_flag VARCHAR2
5028 , p_wince_flag VARCHAR2
5029 , p_laptop_flag VARCHAR2
5030 , p_device1_flag VARCHAR2
5031 , p_device2_flag VARCHAR2
5032 , p_device3_flag VARCHAR2
5033 , p_costs NUMBER
5034 , p_currency_code VARCHAR2
5035 , p_escalation_level VARCHAR2
5036 , x_return_status out nocopy VARCHAR2
5037 , x_msg_count out nocopy NUMBER
5038 , x_msg_data out nocopy VARCHAR2
5039 , p_attribute1 VARCHAR2
5040 , p_attribute2 VARCHAR2
5041 , p_attribute3 VARCHAR2
5042 , p_attribute4 VARCHAR2
5043 , p_attribute5 VARCHAR2
5044 , p_attribute6 VARCHAR2
5045 , p_attribute7 VARCHAR2
5046 , p_attribute8 VARCHAR2
5047 , p_attribute9 VARCHAR2
5048 , p_attribute10 VARCHAR2
5049 , p_attribute11 VARCHAR2
5050 , p_attribute12 VARCHAR2
5051 , p_attribute13 VARCHAR2
5052 , p_attribute14 VARCHAR2
5053 , p_attribute15 VARCHAR2
5054 , p_attribute_category VARCHAR2
5055 , p_date_selected VARCHAR2
5056 , p_category_id NUMBER
5057 , p_show_on_calendar VARCHAR2
5058 , p_owner_status_id NUMBER
5059 , p_parent_task_id NUMBER
5060 , p_parent_task_number VARCHAR2
5061 )
5062
5063 as
5064 ddp_planned_start_date date;
5065 ddp_planned_end_date date;
5066 ddp_scheduled_start_date date;
5067 ddp_scheduled_end_date date;
5068 ddp_actual_start_date date;
5069 ddp_actual_end_date date;
5070 ddindx binary_integer; indx binary_integer;
5071 begin
5072
5073 -- copy data to the local IN or IN-OUT args, if any
5074
5075
5076
5077
5078
5079
5080
5081
5082
5083
5084
5085
5086
5087
5088
5089
5090
5091
5092
5093
5094
5095
5096
5097
5098
5099
5100 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
5101
5102 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
5103
5104 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
5105
5106 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
5107
5108 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
5109
5110 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
5111
5112
5113
5114
5115
5116
5117
5118
5119
5120
5121
5122
5123
5124
5125
5126
5127
5128
5129
5130
5131
5132
5133
5134
5135
5136
5137
5138
5139
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
5151
5152
5153
5154
5155
5156
5157
5158
5159
5160
5161
5162
5163
5164
5165
5166
5167
5168
5169
5170
5171
5172
5173
5174
5175
5176
5177
5178
5179 -- here's the delegated call to the old PL/SQL routine
5180 jtf_tasks_pub.update_task(p_api_version,
5181 p_init_msg_list,
5182 p_commit,
5183 p_object_version_number,
5184 p_task_id,
5185 p_task_number,
5186 p_task_name,
5187 p_task_type_name,
5188 p_task_type_id,
5189 p_description,
5190 p_task_status_name,
5191 p_task_status_id,
5192 p_task_priority_name,
5193 p_task_priority_id,
5194 p_owner_type_name,
5195 p_owner_type_code,
5196 p_owner_id,
5197 p_owner_territory_id,
5198 p_assigned_by_name,
5199 p_assigned_by_id,
5200 p_customer_number,
5201 p_customer_id,
5202 p_cust_account_number,
5203 p_cust_account_id,
5204 p_address_id,
5205 p_address_number,
5206 ddp_planned_start_date,
5207 ddp_planned_end_date,
5208 ddp_scheduled_start_date,
5209 ddp_scheduled_end_date,
5210 ddp_actual_start_date,
5211 ddp_actual_end_date,
5212 p_timezone_id,
5213 p_timezone_name,
5214 p_source_object_type_code,
5215 p_source_object_id,
5216 p_source_object_name,
5217 p_duration,
5221 p_actual_effort,
5218 p_duration_uom,
5219 p_planned_effort,
5220 p_planned_effort_uom,
5222 p_actual_effort_uom,
5223 p_percentage_complete,
5224 p_reason_code,
5225 p_private_flag,
5226 p_publish_flag,
5227 p_restrict_closure_flag,
5228 p_multi_booked_flag,
5229 p_milestone_flag,
5230 p_holiday_flag,
5231 p_billable_flag,
5232 p_bound_mode_code,
5233 p_soft_bound_flag,
5234 p_workflow_process_id,
5235 p_notification_flag,
5236 p_notification_period,
5237 p_notification_period_uom,
5238 p_alarm_start,
5239 p_alarm_start_uom,
5240 p_alarm_on,
5241 p_alarm_count,
5242 p_alarm_fired_count,
5243 p_alarm_interval,
5244 p_alarm_interval_uom,
5245 p_palm_flag,
5246 p_wince_flag,
5247 p_laptop_flag,
5248 p_device1_flag,
5249 p_device2_flag,
5250 p_device3_flag,
5251 p_costs,
5252 p_currency_code,
5253 p_escalation_level,
5254 x_return_status,
5255 x_msg_count,
5256 x_msg_data,
5257 p_attribute1,
5258 p_attribute2,
5259 p_attribute3,
5260 p_attribute4,
5261 p_attribute5,
5262 p_attribute6,
5263 p_attribute7,
5264 p_attribute8,
5265 p_attribute9,
5266 p_attribute10,
5267 p_attribute11,
5268 p_attribute12,
5269 p_attribute13,
5270 p_attribute14,
5271 p_attribute15,
5272 p_attribute_category,
5273 p_date_selected,
5274 p_category_id,
5275 p_show_on_calendar,
5276 p_owner_status_id,
5277 p_parent_task_id,
5278 p_parent_task_number);
5279
5280 -- copy data back from the local variables to OUT or IN-OUT args, if any
5281
5282
5283
5284
5285
5286
5287
5288
5289
5290
5291
5292
5293
5294
5295
5296
5297
5298
5299
5300
5301
5302
5303
5304
5305
5306
5307
5308
5309
5310
5311
5312
5313
5314
5315
5316
5317
5318
5319
5320
5321
5322
5323
5324
5325
5326
5327
5328
5329
5330
5331
5332
5333
5334
5335
5336
5337
5338
5339
5340
5341
5342
5343
5344
5345
5346
5347
5348
5349
5350
5351
5352
5353
5354
5355
5356
5357
5358
5359
5360
5361
5362
5363
5364
5365
5366
5367
5368
5369
5370
5371
5372
5373
5374
5375
5376
5377
5378
5379 end;
5380
5381 procedure export_query_task(p_api_version NUMBER
5382 , p_init_msg_list VARCHAR2
5383 , p_validate_level VARCHAR2
5384 , p_file_name VARCHAR2
5385 , p_task_number VARCHAR2
5386 , p_task_id NUMBER
5387 , p_task_name VARCHAR2
5388 , p_description VARCHAR2
5389 , p_task_type_name VARCHAR2
5390 , p_task_type_id NUMBER
5391 , p_task_status_name VARCHAR2
5392 , p_task_status_id NUMBER
5393 , p_task_priority_name VARCHAR2
5394 , p_task_priority_id NUMBER
5395 , p_owner_type_code VARCHAR2
5396 , p_owner_id NUMBER
5397 , p_assigned_name VARCHAR2
5398 , p_assigned_by_id NUMBER
5399 , p_address_id NUMBER
5400 , p_owner_territory_id NUMBER
5401 , p_customer_id NUMBER
5402 , p_customer_name VARCHAR2
5403 , p_customer_number VARCHAR2
5404 , p_cust_account_number VARCHAR2
5405 , p_cust_account_id NUMBER
5406 , p_planned_start_date date
5407 , p_planned_end_date date
5408 , p_scheduled_start_date date
5409 , p_scheduled_end_date date
5410 , p_actual_start_date date
5411 , p_actual_end_date date
5412 , p_object_type_code VARCHAR2
5413 , p_object_name VARCHAR2
5414 , p_source_object_id NUMBER
5415 , p_percentage_complete NUMBER
5416 , p_reason_code VARCHAR2
5417 , p_private_flag VARCHAR2
5418 , p_restrict_closure_flag VARCHAR2
5419 , p_multi_booked_flag VARCHAR2
5420 , p_milestone_flag VARCHAR2
5421 , p_holiday_flag VARCHAR2
5422 , p_workflow_process_id NUMBER
5423 , p_notification_flag VARCHAR2
5424 , p_parent_task_id NUMBER
5425 , p_alarm_on VARCHAR2
5426 , p_alarm_count NUMBER
5427 , p_alarm_fired_count NUMBER
5428 , p_ref_object_id NUMBER
5429 , p_ref_object_type_code VARCHAR2
5430 , p49_a0 JTF_VARCHAR2_TABLE_100
5431 , p49_a1 JTF_VARCHAR2_TABLE_100
5432 , p_start_pointer NUMBER
5433 , p_rec_wanted NUMBER
5434 , p_show_all VARCHAR2
5435 , p_query_or_next_code VARCHAR2
5436 , p54_a0 out nocopy JTF_NUMBER_TABLE
5437 , p54_a1 out nocopy JTF_VARCHAR2_TABLE_100
5441 , p54_a5 out nocopy JTF_VARCHAR2_TABLE_100
5438 , p54_a2 out nocopy JTF_VARCHAR2_TABLE_100
5439 , p54_a3 out nocopy JTF_VARCHAR2_TABLE_4000
5440 , p54_a4 out nocopy JTF_NUMBER_TABLE
5442 , p54_a6 out nocopy JTF_NUMBER_TABLE
5443 , p54_a7 out nocopy JTF_VARCHAR2_TABLE_100
5444 , p54_a8 out nocopy JTF_NUMBER_TABLE
5445 , p54_a9 out nocopy JTF_VARCHAR2_TABLE_100
5446 , p54_a10 out nocopy JTF_VARCHAR2_TABLE_100
5447 , p54_a11 out nocopy JTF_NUMBER_TABLE
5448 , p54_a12 out nocopy JTF_VARCHAR2_TABLE_4000
5449 , p54_a13 out nocopy JTF_NUMBER_TABLE
5450 , p54_a14 out nocopy JTF_VARCHAR2_TABLE_4000
5451 , p54_a15 out nocopy JTF_NUMBER_TABLE
5452 , p54_a16 out nocopy JTF_VARCHAR2_TABLE_400
5453 , p54_a17 out nocopy JTF_VARCHAR2_TABLE_100
5454 , p54_a18 out nocopy JTF_VARCHAR2_TABLE_100
5455 , p54_a19 out nocopy JTF_NUMBER_TABLE
5456 , p54_a20 out nocopy JTF_NUMBER_TABLE
5457 , p54_a21 out nocopy JTF_DATE_TABLE
5458 , p54_a22 out nocopy JTF_DATE_TABLE
5459 , p54_a23 out nocopy JTF_DATE_TABLE
5460 , p54_a24 out nocopy JTF_DATE_TABLE
5461 , p54_a25 out nocopy JTF_DATE_TABLE
5462 , p54_a26 out nocopy JTF_DATE_TABLE
5463 , p54_a27 out nocopy JTF_VARCHAR2_TABLE_100
5464 , p54_a28 out nocopy JTF_NUMBER_TABLE
5465 , p54_a29 out nocopy JTF_VARCHAR2_TABLE_100
5466 , p54_a30 out nocopy JTF_NUMBER_TABLE
5467 , p54_a31 out nocopy JTF_VARCHAR2_TABLE_100
5468 , p54_a32 out nocopy JTF_NUMBER_TABLE
5469 , p54_a33 out nocopy JTF_VARCHAR2_TABLE_100
5470 , p54_a34 out nocopy JTF_NUMBER_TABLE
5471 , p54_a35 out nocopy JTF_VARCHAR2_TABLE_100
5472 , p54_a36 out nocopy JTF_NUMBER_TABLE
5473 , p54_a37 out nocopy JTF_VARCHAR2_TABLE_100
5474 , p54_a38 out nocopy JTF_VARCHAR2_TABLE_100
5475 , p54_a39 out nocopy JTF_VARCHAR2_TABLE_100
5476 , p54_a40 out nocopy JTF_VARCHAR2_TABLE_100
5477 , p54_a41 out nocopy JTF_VARCHAR2_TABLE_100
5478 , p54_a42 out nocopy JTF_VARCHAR2_TABLE_100
5479 , p54_a43 out nocopy JTF_NUMBER_TABLE
5480 , p54_a44 out nocopy JTF_VARCHAR2_TABLE_100
5481 , p54_a45 out nocopy JTF_NUMBER_TABLE
5482 , p54_a46 out nocopy JTF_VARCHAR2_TABLE_100
5483 , p54_a47 out nocopy JTF_NUMBER_TABLE
5484 , p54_a48 out nocopy JTF_NUMBER_TABLE
5485 , p54_a49 out nocopy JTF_VARCHAR2_TABLE_100
5486 , p54_a50 out nocopy JTF_VARCHAR2_TABLE_100
5487 , p54_a51 out nocopy JTF_NUMBER_TABLE
5488 , p54_a52 out nocopy JTF_NUMBER_TABLE
5489 , p54_a53 out nocopy JTF_NUMBER_TABLE
5490 , p54_a54 out nocopy JTF_VARCHAR2_TABLE_100
5491 , p54_a55 out nocopy JTF_VARCHAR2_TABLE_200
5492 , p54_a56 out nocopy JTF_VARCHAR2_TABLE_200
5493 , p54_a57 out nocopy JTF_VARCHAR2_TABLE_200
5494 , p54_a58 out nocopy JTF_VARCHAR2_TABLE_200
5495 , p54_a59 out nocopy JTF_VARCHAR2_TABLE_200
5496 , p54_a60 out nocopy JTF_VARCHAR2_TABLE_200
5497 , p54_a61 out nocopy JTF_VARCHAR2_TABLE_200
5498 , p54_a62 out nocopy JTF_VARCHAR2_TABLE_200
5499 , p54_a63 out nocopy JTF_VARCHAR2_TABLE_200
5500 , p54_a64 out nocopy JTF_VARCHAR2_TABLE_200
5501 , p54_a65 out nocopy JTF_VARCHAR2_TABLE_200
5502 , p54_a66 out nocopy JTF_VARCHAR2_TABLE_200
5503 , p54_a67 out nocopy JTF_VARCHAR2_TABLE_200
5504 , p54_a68 out nocopy JTF_VARCHAR2_TABLE_200
5505 , p54_a69 out nocopy JTF_VARCHAR2_TABLE_200
5506 , p54_a70 out nocopy JTF_VARCHAR2_TABLE_200
5507 , p54_a71 out nocopy JTF_NUMBER_TABLE
5508 , p54_a72 out nocopy JTF_DATE_TABLE
5509 , p54_a73 out nocopy JTF_VARCHAR2_TABLE_4000
5510 , p54_a74 out nocopy JTF_NUMBER_TABLE
5511 , p54_a75 out nocopy JTF_DATE_TABLE
5512 , p54_a76 out nocopy JTF_DATE_TABLE
5513 , p54_a77 out nocopy JTF_VARCHAR2_TABLE_100
5514 , p54_a78 out nocopy JTF_VARCHAR2_TABLE_100
5515 , p54_a79 out nocopy JTF_VARCHAR2_TABLE_100
5516 , p54_a80 out nocopy JTF_NUMBER_TABLE
5517 , p54_a81 out nocopy JTF_NUMBER_TABLE
5518 , x_total_retrieved out nocopy NUMBER
5519 , x_total_returned out nocopy NUMBER
5520 , x_return_status out nocopy VARCHAR2
5521 , x_msg_count out nocopy NUMBER
5522 , x_msg_data out nocopy VARCHAR2
5523 , x_object_version_number in out nocopy NUMBER
5524 , p_location_id NUMBER
5525 )
5526
5527 as
5528 ddp_planned_start_date date;
5529 ddp_planned_end_date date;
5530 ddp_scheduled_start_date date;
5531 ddp_scheduled_end_date date;
5532 ddp_actual_start_date date;
5533 ddp_actual_end_date date;
5534 ddp_sort_data jtf_tasks_pub.sort_data;
5535 ddx_task_table jtf_tasks_pub.task_table_type;
5536 ddindx binary_integer; indx binary_integer;
5537 begin
5538
5539 -- copy data to the local IN or IN-OUT args, if any
5540
5541
5542
5543
5544
5545
5546
5547
5548
5549
5550
5551
5552
5553
5554
5555
5556
5557
5558
5559
5560
5561
5562
5563
5564
5565 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
5566
5567 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
5568
5569 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
5570
5571 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
5572
5576
5573 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
5574
5575 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
5577
5578
5579
5580
5581
5582
5583
5584
5585
5586
5587
5588
5589
5590
5591
5592
5593
5594
5595 jtf_tasks_pub_w.rosetta_table_copy_in_p34(ddp_sort_data, p49_a0
5596 , p49_a1
5597 );
5598
5599
5600
5601
5602
5603
5604
5605
5606
5607
5608
5609
5610
5611 -- here's the delegated call to the old PL/SQL routine
5612 jtf_tasks_pub.export_query_task(p_api_version,
5613 p_init_msg_list,
5614 p_validate_level,
5615 p_file_name,
5616 p_task_number,
5617 p_task_id,
5618 p_task_name,
5619 p_description,
5620 p_task_type_name,
5621 p_task_type_id,
5622 p_task_status_name,
5623 p_task_status_id,
5624 p_task_priority_name,
5625 p_task_priority_id,
5626 p_owner_type_code,
5627 p_owner_id,
5628 p_assigned_name,
5629 p_assigned_by_id,
5630 p_address_id,
5631 p_owner_territory_id,
5632 p_customer_id,
5633 p_customer_name,
5634 p_customer_number,
5635 p_cust_account_number,
5636 p_cust_account_id,
5637 ddp_planned_start_date,
5638 ddp_planned_end_date,
5639 ddp_scheduled_start_date,
5640 ddp_scheduled_end_date,
5641 ddp_actual_start_date,
5642 ddp_actual_end_date,
5643 p_object_type_code,
5644 p_object_name,
5645 p_source_object_id,
5646 p_percentage_complete,
5647 p_reason_code,
5648 p_private_flag,
5649 p_restrict_closure_flag,
5650 p_multi_booked_flag,
5651 p_milestone_flag,
5652 p_holiday_flag,
5653 p_workflow_process_id,
5654 p_notification_flag,
5655 p_parent_task_id,
5656 p_alarm_on,
5657 p_alarm_count,
5658 p_alarm_fired_count,
5659 p_ref_object_id,
5660 p_ref_object_type_code,
5661 ddp_sort_data,
5662 p_start_pointer,
5663 p_rec_wanted,
5664 p_show_all,
5665 p_query_or_next_code,
5666 ddx_task_table,
5667 x_total_retrieved,
5668 x_total_returned,
5669 x_return_status,
5670 x_msg_count,
5671 x_msg_data,
5672 x_object_version_number,
5673 p_location_id);
5674
5675 -- copy data back from the local variables to OUT or IN-OUT args, if any
5676
5677
5678
5679
5680
5681
5682
5683
5684
5685
5686
5687
5688
5689
5690
5691
5692
5693
5694
5695
5696
5697
5698
5699
5700
5701
5702
5703
5704
5705
5706
5707
5708
5709
5710
5711
5712
5713
5714
5715
5716
5717
5718
5719
5720
5721
5722
5723
5724
5725
5726
5727
5728
5729
5730 jtf_tasks_pub_w.rosetta_table_copy_out_p31(ddx_task_table, p54_a0
5731 , p54_a1
5732 , p54_a2
5733 , p54_a3
5734 , p54_a4
5735 , p54_a5
5736 , p54_a6
5737 , p54_a7
5738 , p54_a8
5739 , p54_a9
5740 , p54_a10
5741 , p54_a11
5742 , p54_a12
5743 , p54_a13
5744 , p54_a14
5745 , p54_a15
5746 , p54_a16
5747 , p54_a17
5748 , p54_a18
5749 , p54_a19
5750 , p54_a20
5751 , p54_a21
5752 , p54_a22
5753 , p54_a23
5754 , p54_a24
5755 , p54_a25
5756 , p54_a26
5757 , p54_a27
5758 , p54_a28
5759 , p54_a29
5760 , p54_a30
5761 , p54_a31
5762 , p54_a32
5763 , p54_a33
5764 , p54_a34
5765 , p54_a35
5766 , p54_a36
5767 , p54_a37
5768 , p54_a38
5769 , p54_a39
5770 , p54_a40
5771 , p54_a41
5772 , p54_a42
5773 , p54_a43
5774 , p54_a44
5775 , p54_a45
5776 , p54_a46
5777 , p54_a47
5778 , p54_a48
5779 , p54_a49
5780 , p54_a50
5781 , p54_a51
5782 , p54_a52
5783 , p54_a53
5784 , p54_a54
5785 , p54_a55
5786 , p54_a56
5787 , p54_a57
5788 , p54_a58
5789 , p54_a59
5790 , p54_a60
5791 , p54_a61
5792 , p54_a62
5793 , p54_a63
5794 , p54_a64
5795 , p54_a65
5796 , p54_a66
5797 , p54_a67
5798 , p54_a68
5799 , p54_a69
5800 , p54_a70
5801 , p54_a71
5802 , p54_a72
5803 , p54_a73
5804 , p54_a74
5808 , p54_a78
5805 , p54_a75
5806 , p54_a76
5807 , p54_a77
5809 , p54_a79
5810 , p54_a80
5811 , p54_a81
5812 );
5813
5814
5815
5816
5817
5818
5819
5820 end;
5821
5822 procedure export_query_task(p_api_version NUMBER
5823 , p_init_msg_list VARCHAR2
5824 , p_validate_level VARCHAR2
5825 , p_file_name VARCHAR2
5826 , p_task_number VARCHAR2
5827 , p_task_id NUMBER
5828 , p_task_name VARCHAR2
5829 , p_description VARCHAR2
5830 , p_task_type_name VARCHAR2
5831 , p_task_type_id NUMBER
5832 , p_task_status_name VARCHAR2
5833 , p_task_status_id NUMBER
5834 , p_task_priority_name VARCHAR2
5835 , p_task_priority_id NUMBER
5836 , p_owner_type_code VARCHAR2
5837 , p_owner_id NUMBER
5838 , p_assigned_name VARCHAR2
5839 , p_assigned_by_id NUMBER
5840 , p_address_id NUMBER
5841 , p_owner_territory_id NUMBER
5842 , p_customer_id NUMBER
5843 , p_customer_name VARCHAR2
5844 , p_customer_number VARCHAR2
5845 , p_cust_account_number VARCHAR2
5846 , p_cust_account_id NUMBER
5847 , p_planned_start_date date
5848 , p_planned_end_date date
5849 , p_scheduled_start_date date
5850 , p_scheduled_end_date date
5851 , p_actual_start_date date
5852 , p_actual_end_date date
5853 , p_object_type_code VARCHAR2
5854 , p_object_name VARCHAR2
5855 , p_source_object_id NUMBER
5856 , p_percentage_complete NUMBER
5857 , p_reason_code VARCHAR2
5858 , p_private_flag VARCHAR2
5859 , p_restrict_closure_flag VARCHAR2
5860 , p_multi_booked_flag VARCHAR2
5861 , p_milestone_flag VARCHAR2
5862 , p_holiday_flag VARCHAR2
5863 , p_workflow_process_id NUMBER
5864 , p_notification_flag VARCHAR2
5865 , p_parent_task_id NUMBER
5866 , p_alarm_on VARCHAR2
5867 , p_alarm_count NUMBER
5868 , p_alarm_fired_count NUMBER
5869 , p_ref_object_id NUMBER
5870 , p_ref_object_type_code VARCHAR2
5871 , p49_a0 JTF_VARCHAR2_TABLE_100
5872 , p49_a1 JTF_VARCHAR2_TABLE_100
5873 , p_start_pointer NUMBER
5874 , p_rec_wanted NUMBER
5875 , p_show_all VARCHAR2
5876 , p_query_or_next_code VARCHAR2
5877 , p54_a0 out nocopy JTF_NUMBER_TABLE
5878 , p54_a1 out nocopy JTF_VARCHAR2_TABLE_100
5879 , p54_a2 out nocopy JTF_VARCHAR2_TABLE_100
5880 , p54_a3 out nocopy JTF_VARCHAR2_TABLE_4000
5881 , p54_a4 out nocopy JTF_NUMBER_TABLE
5882 , p54_a5 out nocopy JTF_VARCHAR2_TABLE_100
5883 , p54_a6 out nocopy JTF_NUMBER_TABLE
5884 , p54_a7 out nocopy JTF_VARCHAR2_TABLE_100
5885 , p54_a8 out nocopy JTF_NUMBER_TABLE
5886 , p54_a9 out nocopy JTF_VARCHAR2_TABLE_100
5887 , p54_a10 out nocopy JTF_VARCHAR2_TABLE_100
5888 , p54_a11 out nocopy JTF_NUMBER_TABLE
5889 , p54_a12 out nocopy JTF_VARCHAR2_TABLE_4000
5890 , p54_a13 out nocopy JTF_NUMBER_TABLE
5891 , p54_a14 out nocopy JTF_VARCHAR2_TABLE_4000
5892 , p54_a15 out nocopy JTF_NUMBER_TABLE
5893 , p54_a16 out nocopy JTF_VARCHAR2_TABLE_400
5894 , p54_a17 out nocopy JTF_VARCHAR2_TABLE_100
5895 , p54_a18 out nocopy JTF_VARCHAR2_TABLE_100
5896 , p54_a19 out nocopy JTF_NUMBER_TABLE
5897 , p54_a20 out nocopy JTF_NUMBER_TABLE
5898 , p54_a21 out nocopy JTF_DATE_TABLE
5899 , p54_a22 out nocopy JTF_DATE_TABLE
5900 , p54_a23 out nocopy JTF_DATE_TABLE
5901 , p54_a24 out nocopy JTF_DATE_TABLE
5902 , p54_a25 out nocopy JTF_DATE_TABLE
5903 , p54_a26 out nocopy JTF_DATE_TABLE
5904 , p54_a27 out nocopy JTF_VARCHAR2_TABLE_100
5905 , p54_a28 out nocopy JTF_NUMBER_TABLE
5906 , p54_a29 out nocopy JTF_VARCHAR2_TABLE_100
5907 , p54_a30 out nocopy JTF_NUMBER_TABLE
5908 , p54_a31 out nocopy JTF_VARCHAR2_TABLE_100
5909 , p54_a32 out nocopy JTF_NUMBER_TABLE
5910 , p54_a33 out nocopy JTF_VARCHAR2_TABLE_100
5911 , p54_a34 out nocopy JTF_NUMBER_TABLE
5912 , p54_a35 out nocopy JTF_VARCHAR2_TABLE_100
5913 , p54_a36 out nocopy JTF_NUMBER_TABLE
5914 , p54_a37 out nocopy JTF_VARCHAR2_TABLE_100
5915 , p54_a38 out nocopy JTF_VARCHAR2_TABLE_100
5916 , p54_a39 out nocopy JTF_VARCHAR2_TABLE_100
5917 , p54_a40 out nocopy JTF_VARCHAR2_TABLE_100
5918 , p54_a41 out nocopy JTF_VARCHAR2_TABLE_100
5919 , p54_a42 out nocopy JTF_VARCHAR2_TABLE_100
5920 , p54_a43 out nocopy JTF_NUMBER_TABLE
5921 , p54_a44 out nocopy JTF_VARCHAR2_TABLE_100
5922 , p54_a45 out nocopy JTF_NUMBER_TABLE
5923 , p54_a46 out nocopy JTF_VARCHAR2_TABLE_100
5924 , p54_a47 out nocopy JTF_NUMBER_TABLE
5925 , p54_a48 out nocopy JTF_NUMBER_TABLE
5926 , p54_a49 out nocopy JTF_VARCHAR2_TABLE_100
5927 , p54_a50 out nocopy JTF_VARCHAR2_TABLE_100
5928 , p54_a51 out nocopy JTF_NUMBER_TABLE
5929 , p54_a52 out nocopy JTF_NUMBER_TABLE
5930 , p54_a53 out nocopy JTF_NUMBER_TABLE
5931 , p54_a54 out nocopy JTF_VARCHAR2_TABLE_100
5932 , p54_a55 out nocopy JTF_VARCHAR2_TABLE_200
5933 , p54_a56 out nocopy JTF_VARCHAR2_TABLE_200
5934 , p54_a57 out nocopy JTF_VARCHAR2_TABLE_200
5935 , p54_a58 out nocopy JTF_VARCHAR2_TABLE_200
5936 , p54_a59 out nocopy JTF_VARCHAR2_TABLE_200
5940 , p54_a63 out nocopy JTF_VARCHAR2_TABLE_200
5937 , p54_a60 out nocopy JTF_VARCHAR2_TABLE_200
5938 , p54_a61 out nocopy JTF_VARCHAR2_TABLE_200
5939 , p54_a62 out nocopy JTF_VARCHAR2_TABLE_200
5941 , p54_a64 out nocopy JTF_VARCHAR2_TABLE_200
5942 , p54_a65 out nocopy JTF_VARCHAR2_TABLE_200
5943 , p54_a66 out nocopy JTF_VARCHAR2_TABLE_200
5944 , p54_a67 out nocopy JTF_VARCHAR2_TABLE_200
5945 , p54_a68 out nocopy JTF_VARCHAR2_TABLE_200
5946 , p54_a69 out nocopy JTF_VARCHAR2_TABLE_200
5947 , p54_a70 out nocopy JTF_VARCHAR2_TABLE_200
5948 , p54_a71 out nocopy JTF_NUMBER_TABLE
5949 , p54_a72 out nocopy JTF_DATE_TABLE
5950 , p54_a73 out nocopy JTF_VARCHAR2_TABLE_4000
5951 , p54_a74 out nocopy JTF_NUMBER_TABLE
5952 , p54_a75 out nocopy JTF_DATE_TABLE
5953 , p54_a76 out nocopy JTF_DATE_TABLE
5954 , p54_a77 out nocopy JTF_VARCHAR2_TABLE_100
5955 , p54_a78 out nocopy JTF_VARCHAR2_TABLE_100
5956 , p54_a79 out nocopy JTF_VARCHAR2_TABLE_100
5957 , p54_a80 out nocopy JTF_NUMBER_TABLE
5958 , p54_a81 out nocopy JTF_NUMBER_TABLE
5959 , x_total_retrieved out nocopy NUMBER
5960 , x_total_returned out nocopy NUMBER
5961 , x_return_status out nocopy VARCHAR2
5962 , x_msg_count out nocopy NUMBER
5963 , x_msg_data out nocopy VARCHAR2
5964 , x_object_version_number in out nocopy NUMBER
5965 )
5966
5967 as
5968 ddp_planned_start_date date;
5969 ddp_planned_end_date date;
5970 ddp_scheduled_start_date date;
5971 ddp_scheduled_end_date date;
5972 ddp_actual_start_date date;
5973 ddp_actual_end_date date;
5974 ddp_sort_data jtf_tasks_pub.sort_data;
5975 ddx_task_table jtf_tasks_pub.task_table_type;
5976 ddindx binary_integer; indx binary_integer;
5977 begin
5978
5979 -- copy data to the local IN or IN-OUT args, if any
5980
5981
5982
5983
5984
5985
5986
5987
5988
5989
5990
5991
5992
5993
5994
5995
5996
5997
5998
5999
6000
6001
6002
6003
6004
6005 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
6006
6007 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
6008
6009 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
6010
6011 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
6012
6013 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
6014
6015 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
6016
6017
6018
6019
6020
6021
6022
6023
6024
6025
6026
6027
6028
6029
6030
6031
6032
6033
6034
6035 jtf_tasks_pub_w.rosetta_table_copy_in_p34(ddp_sort_data, p49_a0
6036 , p49_a1
6037 );
6038
6039
6040
6041
6042
6043
6044
6045
6046
6047
6048
6049
6050 -- here's the delegated call to the old PL/SQL routine
6051 jtf_tasks_pub.export_query_task(p_api_version,
6052 p_init_msg_list,
6053 p_validate_level,
6054 p_file_name,
6055 p_task_number,
6056 p_task_id,
6057 p_task_name,
6058 p_description,
6059 p_task_type_name,
6060 p_task_type_id,
6061 p_task_status_name,
6062 p_task_status_id,
6063 p_task_priority_name,
6064 p_task_priority_id,
6065 p_owner_type_code,
6066 p_owner_id,
6067 p_assigned_name,
6068 p_assigned_by_id,
6069 p_address_id,
6070 p_owner_territory_id,
6071 p_customer_id,
6072 p_customer_name,
6073 p_customer_number,
6074 p_cust_account_number,
6075 p_cust_account_id,
6076 ddp_planned_start_date,
6077 ddp_planned_end_date,
6078 ddp_scheduled_start_date,
6079 ddp_scheduled_end_date,
6080 ddp_actual_start_date,
6081 ddp_actual_end_date,
6082 p_object_type_code,
6083 p_object_name,
6084 p_source_object_id,
6085 p_percentage_complete,
6086 p_reason_code,
6087 p_private_flag,
6088 p_restrict_closure_flag,
6089 p_multi_booked_flag,
6090 p_milestone_flag,
6091 p_holiday_flag,
6092 p_workflow_process_id,
6093 p_notification_flag,
6094 p_parent_task_id,
6095 p_alarm_on,
6096 p_alarm_count,
6097 p_alarm_fired_count,
6098 p_ref_object_id,
6099 p_ref_object_type_code,
6100 ddp_sort_data,
6101 p_start_pointer,
6102 p_rec_wanted,
6103 p_show_all,
6104 p_query_or_next_code,
6105 ddx_task_table,
6106 x_total_retrieved,
6107 x_total_returned,
6108 x_return_status,
6109 x_msg_count,
6110 x_msg_data,
6111 x_object_version_number);
6112
6113 -- copy data back from the local variables to OUT or IN-OUT args, if any
6114
6115
6116
6117
6118
6119
6120
6121
6122
6123
6124
6125
6126
6127
6128
6129
6130
6131
6132
6133
6134
6135
6136
6137
6138
6139
6140
6141
6142
6143
6144
6145
6146
6147
6148
6149
6150
6151
6152
6153
6154
6155
6156
6157
6158
6159
6160
6161
6162
6163
6164
6165
6166
6167
6168 jtf_tasks_pub_w.rosetta_table_copy_out_p31(ddx_task_table, p54_a0
6169 , p54_a1
6170 , p54_a2
6171 , p54_a3
6172 , p54_a4
6173 , p54_a5
6174 , p54_a6
6175 , p54_a7
6176 , p54_a8
6177 , p54_a9
6178 , p54_a10
6179 , p54_a11
6180 , p54_a12
6181 , p54_a13
6182 , p54_a14
6183 , p54_a15
6184 , p54_a16
6185 , p54_a17
6186 , p54_a18
6187 , p54_a19
6188 , p54_a20
6189 , p54_a21
6190 , p54_a22
6191 , p54_a23
6192 , p54_a24
6193 , p54_a25
6194 , p54_a26
6195 , p54_a27
6196 , p54_a28
6197 , p54_a29
6198 , p54_a30
6199 , p54_a31
6200 , p54_a32
6201 , p54_a33
6202 , p54_a34
6203 , p54_a35
6204 , p54_a36
6205 , p54_a37
6206 , p54_a38
6207 , p54_a39
6208 , p54_a40
6209 , p54_a41
6210 , p54_a42
6211 , p54_a43
6212 , p54_a44
6213 , p54_a45
6214 , p54_a46
6215 , p54_a47
6216 , p54_a48
6217 , p54_a49
6218 , p54_a50
6219 , p54_a51
6220 , p54_a52
6221 , p54_a53
6222 , p54_a54
6223 , p54_a55
6224 , p54_a56
6225 , p54_a57
6226 , p54_a58
6227 , p54_a59
6228 , p54_a60
6229 , p54_a61
6230 , p54_a62
6231 , p54_a63
6232 , p54_a64
6233 , p54_a65
6234 , p54_a66
6235 , p54_a67
6236 , p54_a68
6237 , p54_a69
6238 , p54_a70
6239 , p54_a71
6240 , p54_a72
6241 , p54_a73
6242 , p54_a74
6243 , p54_a75
6244 , p54_a76
6245 , p54_a77
6246 , p54_a78
6247 , p54_a79
6248 , p54_a80
6249 , p54_a81
6250 );
6251
6252
6253
6254
6255
6256
6257 end;
6258
6259 procedure query_task(p_api_version NUMBER
6260 , p_init_msg_list VARCHAR2
6261 , p_validate_level VARCHAR2
6262 , p_task_number VARCHAR2
6263 , p_task_id NUMBER
6264 , p_task_name VARCHAR2
6265 , p_description VARCHAR2
6266 , p_task_type_name VARCHAR2
6267 , p_task_type_id NUMBER
6268 , p_task_status_name VARCHAR2
6269 , p_task_status_id NUMBER
6273 , p_owner_id NUMBER
6270 , p_task_priority_name VARCHAR2
6271 , p_task_priority_id NUMBER
6272 , p_owner_type_code VARCHAR2
6274 , p_assigned_name VARCHAR2
6275 , p_assigned_by_id NUMBER
6276 , p_address_id NUMBER
6277 , p_owner_territory_id NUMBER
6278 , p_customer_id NUMBER
6279 , p_customer_name VARCHAR2
6280 , p_customer_number VARCHAR2
6281 , p_cust_account_number VARCHAR2
6282 , p_cust_account_id NUMBER
6283 , p_planned_start_date date
6284 , p_planned_end_date date
6285 , p_scheduled_start_date date
6286 , p_scheduled_end_date date
6287 , p_actual_start_date date
6288 , p_actual_end_date date
6289 , p_object_type_code VARCHAR2
6290 , p_object_name VARCHAR2
6291 , p_source_object_id NUMBER
6292 , p_percentage_complete NUMBER
6293 , p_reason_code VARCHAR2
6294 , p_private_flag VARCHAR2
6295 , p_restrict_closure_flag VARCHAR2
6296 , p_multi_booked_flag VARCHAR2
6297 , p_milestone_flag VARCHAR2
6298 , p_holiday_flag VARCHAR2
6299 , p_workflow_process_id NUMBER
6300 , p_notification_flag VARCHAR2
6301 , p_parent_task_id NUMBER
6302 , p_alarm_on VARCHAR2
6303 , p_alarm_count NUMBER
6304 , p_alarm_fired_count NUMBER
6305 , p_ref_object_id NUMBER
6306 , p_ref_object_type_code VARCHAR2
6307 , p48_a0 JTF_VARCHAR2_TABLE_100
6308 , p48_a1 JTF_VARCHAR2_TABLE_100
6309 , p_start_pointer NUMBER
6310 , p_rec_wanted NUMBER
6311 , p_show_all VARCHAR2
6312 , p_query_or_next_code VARCHAR2
6313 , p53_a0 out nocopy JTF_NUMBER_TABLE
6314 , p53_a1 out nocopy JTF_VARCHAR2_TABLE_100
6315 , p53_a2 out nocopy JTF_VARCHAR2_TABLE_100
6316 , p53_a3 out nocopy JTF_VARCHAR2_TABLE_4000
6317 , p53_a4 out nocopy JTF_NUMBER_TABLE
6318 , p53_a5 out nocopy JTF_VARCHAR2_TABLE_100
6319 , p53_a6 out nocopy JTF_NUMBER_TABLE
6320 , p53_a7 out nocopy JTF_VARCHAR2_TABLE_100
6321 , p53_a8 out nocopy JTF_NUMBER_TABLE
6322 , p53_a9 out nocopy JTF_VARCHAR2_TABLE_100
6323 , p53_a10 out nocopy JTF_VARCHAR2_TABLE_100
6324 , p53_a11 out nocopy JTF_NUMBER_TABLE
6325 , p53_a12 out nocopy JTF_VARCHAR2_TABLE_4000
6326 , p53_a13 out nocopy JTF_NUMBER_TABLE
6327 , p53_a14 out nocopy JTF_VARCHAR2_TABLE_4000
6328 , p53_a15 out nocopy JTF_NUMBER_TABLE
6329 , p53_a16 out nocopy JTF_VARCHAR2_TABLE_400
6330 , p53_a17 out nocopy JTF_VARCHAR2_TABLE_100
6331 , p53_a18 out nocopy JTF_VARCHAR2_TABLE_100
6332 , p53_a19 out nocopy JTF_NUMBER_TABLE
6333 , p53_a20 out nocopy JTF_NUMBER_TABLE
6334 , p53_a21 out nocopy JTF_DATE_TABLE
6335 , p53_a22 out nocopy JTF_DATE_TABLE
6336 , p53_a23 out nocopy JTF_DATE_TABLE
6337 , p53_a24 out nocopy JTF_DATE_TABLE
6338 , p53_a25 out nocopy JTF_DATE_TABLE
6339 , p53_a26 out nocopy JTF_DATE_TABLE
6340 , p53_a27 out nocopy JTF_VARCHAR2_TABLE_100
6341 , p53_a28 out nocopy JTF_NUMBER_TABLE
6342 , p53_a29 out nocopy JTF_VARCHAR2_TABLE_100
6343 , p53_a30 out nocopy JTF_NUMBER_TABLE
6344 , p53_a31 out nocopy JTF_VARCHAR2_TABLE_100
6345 , p53_a32 out nocopy JTF_NUMBER_TABLE
6346 , p53_a33 out nocopy JTF_VARCHAR2_TABLE_100
6347 , p53_a34 out nocopy JTF_NUMBER_TABLE
6348 , p53_a35 out nocopy JTF_VARCHAR2_TABLE_100
6349 , p53_a36 out nocopy JTF_NUMBER_TABLE
6350 , p53_a37 out nocopy JTF_VARCHAR2_TABLE_100
6351 , p53_a38 out nocopy JTF_VARCHAR2_TABLE_100
6352 , p53_a39 out nocopy JTF_VARCHAR2_TABLE_100
6353 , p53_a40 out nocopy JTF_VARCHAR2_TABLE_100
6354 , p53_a41 out nocopy JTF_VARCHAR2_TABLE_100
6355 , p53_a42 out nocopy JTF_VARCHAR2_TABLE_100
6356 , p53_a43 out nocopy JTF_NUMBER_TABLE
6357 , p53_a44 out nocopy JTF_VARCHAR2_TABLE_100
6358 , p53_a45 out nocopy JTF_NUMBER_TABLE
6359 , p53_a46 out nocopy JTF_VARCHAR2_TABLE_100
6360 , p53_a47 out nocopy JTF_NUMBER_TABLE
6361 , p53_a48 out nocopy JTF_NUMBER_TABLE
6362 , p53_a49 out nocopy JTF_VARCHAR2_TABLE_100
6363 , p53_a50 out nocopy JTF_VARCHAR2_TABLE_100
6364 , p53_a51 out nocopy JTF_NUMBER_TABLE
6365 , p53_a52 out nocopy JTF_NUMBER_TABLE
6366 , p53_a53 out nocopy JTF_NUMBER_TABLE
6367 , p53_a54 out nocopy JTF_VARCHAR2_TABLE_100
6368 , p53_a55 out nocopy JTF_VARCHAR2_TABLE_200
6369 , p53_a56 out nocopy JTF_VARCHAR2_TABLE_200
6370 , p53_a57 out nocopy JTF_VARCHAR2_TABLE_200
6371 , p53_a58 out nocopy JTF_VARCHAR2_TABLE_200
6372 , p53_a59 out nocopy JTF_VARCHAR2_TABLE_200
6373 , p53_a60 out nocopy JTF_VARCHAR2_TABLE_200
6374 , p53_a61 out nocopy JTF_VARCHAR2_TABLE_200
6375 , p53_a62 out nocopy JTF_VARCHAR2_TABLE_200
6376 , p53_a63 out nocopy JTF_VARCHAR2_TABLE_200
6377 , p53_a64 out nocopy JTF_VARCHAR2_TABLE_200
6378 , p53_a65 out nocopy JTF_VARCHAR2_TABLE_200
6379 , p53_a66 out nocopy JTF_VARCHAR2_TABLE_200
6380 , p53_a67 out nocopy JTF_VARCHAR2_TABLE_200
6381 , p53_a68 out nocopy JTF_VARCHAR2_TABLE_200
6382 , p53_a69 out nocopy JTF_VARCHAR2_TABLE_200
6383 , p53_a70 out nocopy JTF_VARCHAR2_TABLE_200
6384 , p53_a71 out nocopy JTF_NUMBER_TABLE
6385 , p53_a72 out nocopy JTF_DATE_TABLE
6386 , p53_a73 out nocopy JTF_VARCHAR2_TABLE_4000
6387 , p53_a74 out nocopy JTF_NUMBER_TABLE
6388 , p53_a75 out nocopy JTF_DATE_TABLE
6389 , p53_a76 out nocopy JTF_DATE_TABLE
6390 , p53_a77 out nocopy JTF_VARCHAR2_TABLE_100
6391 , p53_a78 out nocopy JTF_VARCHAR2_TABLE_100
6392 , p53_a79 out nocopy JTF_VARCHAR2_TABLE_100
6393 , p53_a80 out nocopy JTF_NUMBER_TABLE
6394 , p53_a81 out nocopy JTF_NUMBER_TABLE
6395 , x_total_retrieved out nocopy NUMBER
6396 , x_total_returned out nocopy NUMBER
6397 , x_return_status out nocopy VARCHAR2
6398 , x_msg_count out nocopy NUMBER
6399 , x_msg_data out nocopy VARCHAR2
6400 , x_object_version_number in out nocopy NUMBER
6401 , p_location_id NUMBER
6402 )
6403
6404 as
6405 ddp_planned_start_date date;
6406 ddp_planned_end_date date;
6407 ddp_scheduled_start_date date;
6408 ddp_scheduled_end_date date;
6409 ddp_actual_start_date date;
6410 ddp_actual_end_date date;
6411 ddp_sort_data jtf_tasks_pub.sort_data;
6412 ddx_task_table jtf_tasks_pub.task_table_type;
6413 ddindx binary_integer; indx binary_integer;
6414 begin
6415
6416 -- copy data to the local IN or IN-OUT args, if any
6417
6418
6419
6420
6421
6422
6423
6424
6425
6426
6427
6428
6429
6430
6431
6432
6433
6434
6435
6436
6437
6438
6439
6440
6441 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
6442
6443 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
6444
6445 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
6446
6447 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
6448
6449 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
6450
6451 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
6452
6453
6454
6455
6456
6457
6458
6459
6460
6461
6462
6463
6464
6465
6466
6467
6468
6469
6470
6471 jtf_tasks_pub_w.rosetta_table_copy_in_p34(ddp_sort_data, p48_a0
6472 , p48_a1
6473 );
6474
6475
6476
6477
6478
6479
6480
6481
6482
6483
6484
6485
6486
6487 -- here's the delegated call to the old PL/SQL routine
6488 jtf_tasks_pub.query_task(p_api_version,
6489 p_init_msg_list,
6490 p_validate_level,
6491 p_task_number,
6492 p_task_id,
6493 p_task_name,
6494 p_description,
6495 p_task_type_name,
6496 p_task_type_id,
6497 p_task_status_name,
6498 p_task_status_id,
6499 p_task_priority_name,
6500 p_task_priority_id,
6501 p_owner_type_code,
6502 p_owner_id,
6503 p_assigned_name,
6504 p_assigned_by_id,
6505 p_address_id,
6506 p_owner_territory_id,
6507 p_customer_id,
6508 p_customer_name,
6509 p_customer_number,
6510 p_cust_account_number,
6511 p_cust_account_id,
6512 ddp_planned_start_date,
6513 ddp_planned_end_date,
6514 ddp_scheduled_start_date,
6515 ddp_scheduled_end_date,
6516 ddp_actual_start_date,
6517 ddp_actual_end_date,
6518 p_object_type_code,
6519 p_object_name,
6520 p_source_object_id,
6521 p_percentage_complete,
6522 p_reason_code,
6523 p_private_flag,
6524 p_restrict_closure_flag,
6525 p_multi_booked_flag,
6526 p_milestone_flag,
6527 p_holiday_flag,
6528 p_workflow_process_id,
6529 p_notification_flag,
6530 p_parent_task_id,
6531 p_alarm_on,
6532 p_alarm_count,
6533 p_alarm_fired_count,
6534 p_ref_object_id,
6535 p_ref_object_type_code,
6536 ddp_sort_data,
6537 p_start_pointer,
6538 p_rec_wanted,
6539 p_show_all,
6540 p_query_or_next_code,
6541 ddx_task_table,
6542 x_total_retrieved,
6543 x_total_returned,
6544 x_return_status,
6545 x_msg_count,
6546 x_msg_data,
6547 x_object_version_number,
6548 p_location_id);
6549
6550 -- copy data back from the local variables to OUT or IN-OUT args, if any
6551
6552
6553
6554
6555
6556
6557
6558
6559
6560
6561
6562
6563
6564
6565
6566
6567
6568
6569
6570
6571
6572
6573
6574
6575
6576
6577
6578
6579
6580
6581
6582
6583
6584
6585
6586
6587
6588
6589
6590
6591
6592
6593
6594
6595
6596
6597
6598
6599
6600
6601
6602
6603
6604 jtf_tasks_pub_w.rosetta_table_copy_out_p31(ddx_task_table, p53_a0
6605 , p53_a1
6606 , p53_a2
6607 , p53_a3
6608 , p53_a4
6609 , p53_a5
6610 , p53_a6
6611 , p53_a7
6612 , p53_a8
6613 , p53_a9
6614 , p53_a10
6615 , p53_a11
6616 , p53_a12
6617 , p53_a13
6618 , p53_a14
6619 , p53_a15
6620 , p53_a16
6621 , p53_a17
6622 , p53_a18
6623 , p53_a19
6624 , p53_a20
6625 , p53_a21
6626 , p53_a22
6627 , p53_a23
6628 , p53_a24
6629 , p53_a25
6630 , p53_a26
6631 , p53_a27
6632 , p53_a28
6633 , p53_a29
6634 , p53_a30
6635 , p53_a31
6636 , p53_a32
6637 , p53_a33
6638 , p53_a34
6639 , p53_a35
6640 , p53_a36
6641 , p53_a37
6642 , p53_a38
6643 , p53_a39
6644 , p53_a40
6645 , p53_a41
6646 , p53_a42
6647 , p53_a43
6648 , p53_a44
6649 , p53_a45
6650 , p53_a46
6651 , p53_a47
6652 , p53_a48
6653 , p53_a49
6654 , p53_a50
6655 , p53_a51
6656 , p53_a52
6657 , p53_a53
6658 , p53_a54
6659 , p53_a55
6660 , p53_a56
6661 , p53_a57
6662 , p53_a58
6663 , p53_a59
6664 , p53_a60
6665 , p53_a61
6666 , p53_a62
6667 , p53_a63
6668 , p53_a64
6669 , p53_a65
6670 , p53_a66
6671 , p53_a67
6672 , p53_a68
6673 , p53_a69
6674 , p53_a70
6675 , p53_a71
6676 , p53_a72
6677 , p53_a73
6678 , p53_a74
6679 , p53_a75
6680 , p53_a76
6681 , p53_a77
6682 , p53_a78
6683 , p53_a79
6684 , p53_a80
6685 , p53_a81
6686 );
6687
6688
6689
6690
6691
6692
6693
6694 end;
6695
6696 procedure query_task(p_api_version NUMBER
6697 , p_init_msg_list VARCHAR2
6698 , p_validate_level VARCHAR2
6699 , p_task_number VARCHAR2
6700 , p_task_id NUMBER
6701 , p_task_name VARCHAR2
6702 , p_description VARCHAR2
6703 , p_task_type_name VARCHAR2
6704 , p_task_type_id NUMBER
6705 , p_task_status_name VARCHAR2
6706 , p_task_status_id NUMBER
6707 , p_task_priority_name VARCHAR2
6708 , p_task_priority_id NUMBER
6709 , p_owner_type_code VARCHAR2
6710 , p_owner_id NUMBER
6711 , p_assigned_name VARCHAR2
6712 , p_assigned_by_id NUMBER
6713 , p_address_id NUMBER
6714 , p_owner_territory_id NUMBER
6715 , p_customer_id NUMBER
6716 , p_customer_name VARCHAR2
6717 , p_customer_number VARCHAR2
6718 , p_cust_account_number VARCHAR2
6719 , p_cust_account_id NUMBER
6720 , p_planned_start_date date
6721 , p_planned_end_date date
6722 , p_scheduled_start_date date
6723 , p_scheduled_end_date date
6724 , p_actual_start_date date
6725 , p_actual_end_date date
6726 , p_object_type_code VARCHAR2
6727 , p_object_name VARCHAR2
6728 , p_source_object_id NUMBER
6729 , p_percentage_complete NUMBER
6730 , p_reason_code VARCHAR2
6731 , p_private_flag VARCHAR2
6732 , p_restrict_closure_flag VARCHAR2
6733 , p_multi_booked_flag VARCHAR2
6734 , p_milestone_flag VARCHAR2
6735 , p_holiday_flag VARCHAR2
6736 , p_workflow_process_id NUMBER
6737 , p_notification_flag VARCHAR2
6738 , p_parent_task_id NUMBER
6739 , p_alarm_on VARCHAR2
6740 , p_alarm_count NUMBER
6741 , p_alarm_fired_count NUMBER
6742 , p_ref_object_id NUMBER
6743 , p_ref_object_type_code VARCHAR2
6744 , p48_a0 JTF_VARCHAR2_TABLE_100
6748 , p_show_all VARCHAR2
6745 , p48_a1 JTF_VARCHAR2_TABLE_100
6746 , p_start_pointer NUMBER
6747 , p_rec_wanted NUMBER
6749 , p_query_or_next_code VARCHAR2
6750 , p53_a0 out nocopy JTF_NUMBER_TABLE
6751 , p53_a1 out nocopy JTF_VARCHAR2_TABLE_100
6752 , p53_a2 out nocopy JTF_VARCHAR2_TABLE_100
6753 , p53_a3 out nocopy JTF_VARCHAR2_TABLE_4000
6754 , p53_a4 out nocopy JTF_NUMBER_TABLE
6755 , p53_a5 out nocopy JTF_VARCHAR2_TABLE_100
6756 , p53_a6 out nocopy JTF_NUMBER_TABLE
6757 , p53_a7 out nocopy JTF_VARCHAR2_TABLE_100
6758 , p53_a8 out nocopy JTF_NUMBER_TABLE
6759 , p53_a9 out nocopy JTF_VARCHAR2_TABLE_100
6760 , p53_a10 out nocopy JTF_VARCHAR2_TABLE_100
6761 , p53_a11 out nocopy JTF_NUMBER_TABLE
6762 , p53_a12 out nocopy JTF_VARCHAR2_TABLE_4000
6763 , p53_a13 out nocopy JTF_NUMBER_TABLE
6764 , p53_a14 out nocopy JTF_VARCHAR2_TABLE_4000
6765 , p53_a15 out nocopy JTF_NUMBER_TABLE
6766 , p53_a16 out nocopy JTF_VARCHAR2_TABLE_400
6767 , p53_a17 out nocopy JTF_VARCHAR2_TABLE_100
6768 , p53_a18 out nocopy JTF_VARCHAR2_TABLE_100
6769 , p53_a19 out nocopy JTF_NUMBER_TABLE
6770 , p53_a20 out nocopy JTF_NUMBER_TABLE
6771 , p53_a21 out nocopy JTF_DATE_TABLE
6772 , p53_a22 out nocopy JTF_DATE_TABLE
6773 , p53_a23 out nocopy JTF_DATE_TABLE
6774 , p53_a24 out nocopy JTF_DATE_TABLE
6775 , p53_a25 out nocopy JTF_DATE_TABLE
6776 , p53_a26 out nocopy JTF_DATE_TABLE
6777 , p53_a27 out nocopy JTF_VARCHAR2_TABLE_100
6778 , p53_a28 out nocopy JTF_NUMBER_TABLE
6779 , p53_a29 out nocopy JTF_VARCHAR2_TABLE_100
6780 , p53_a30 out nocopy JTF_NUMBER_TABLE
6781 , p53_a31 out nocopy JTF_VARCHAR2_TABLE_100
6782 , p53_a32 out nocopy JTF_NUMBER_TABLE
6783 , p53_a33 out nocopy JTF_VARCHAR2_TABLE_100
6784 , p53_a34 out nocopy JTF_NUMBER_TABLE
6785 , p53_a35 out nocopy JTF_VARCHAR2_TABLE_100
6786 , p53_a36 out nocopy JTF_NUMBER_TABLE
6787 , p53_a37 out nocopy JTF_VARCHAR2_TABLE_100
6788 , p53_a38 out nocopy JTF_VARCHAR2_TABLE_100
6789 , p53_a39 out nocopy JTF_VARCHAR2_TABLE_100
6790 , p53_a40 out nocopy JTF_VARCHAR2_TABLE_100
6791 , p53_a41 out nocopy JTF_VARCHAR2_TABLE_100
6792 , p53_a42 out nocopy JTF_VARCHAR2_TABLE_100
6793 , p53_a43 out nocopy JTF_NUMBER_TABLE
6794 , p53_a44 out nocopy JTF_VARCHAR2_TABLE_100
6795 , p53_a45 out nocopy JTF_NUMBER_TABLE
6796 , p53_a46 out nocopy JTF_VARCHAR2_TABLE_100
6797 , p53_a47 out nocopy JTF_NUMBER_TABLE
6798 , p53_a48 out nocopy JTF_NUMBER_TABLE
6799 , p53_a49 out nocopy JTF_VARCHAR2_TABLE_100
6800 , p53_a50 out nocopy JTF_VARCHAR2_TABLE_100
6801 , p53_a51 out nocopy JTF_NUMBER_TABLE
6802 , p53_a52 out nocopy JTF_NUMBER_TABLE
6803 , p53_a53 out nocopy JTF_NUMBER_TABLE
6804 , p53_a54 out nocopy JTF_VARCHAR2_TABLE_100
6805 , p53_a55 out nocopy JTF_VARCHAR2_TABLE_200
6806 , p53_a56 out nocopy JTF_VARCHAR2_TABLE_200
6807 , p53_a57 out nocopy JTF_VARCHAR2_TABLE_200
6808 , p53_a58 out nocopy JTF_VARCHAR2_TABLE_200
6809 , p53_a59 out nocopy JTF_VARCHAR2_TABLE_200
6810 , p53_a60 out nocopy JTF_VARCHAR2_TABLE_200
6811 , p53_a61 out nocopy JTF_VARCHAR2_TABLE_200
6812 , p53_a62 out nocopy JTF_VARCHAR2_TABLE_200
6813 , p53_a63 out nocopy JTF_VARCHAR2_TABLE_200
6814 , p53_a64 out nocopy JTF_VARCHAR2_TABLE_200
6815 , p53_a65 out nocopy JTF_VARCHAR2_TABLE_200
6816 , p53_a66 out nocopy JTF_VARCHAR2_TABLE_200
6817 , p53_a67 out nocopy JTF_VARCHAR2_TABLE_200
6818 , p53_a68 out nocopy JTF_VARCHAR2_TABLE_200
6819 , p53_a69 out nocopy JTF_VARCHAR2_TABLE_200
6820 , p53_a70 out nocopy JTF_VARCHAR2_TABLE_200
6821 , p53_a71 out nocopy JTF_NUMBER_TABLE
6822 , p53_a72 out nocopy JTF_DATE_TABLE
6823 , p53_a73 out nocopy JTF_VARCHAR2_TABLE_4000
6824 , p53_a74 out nocopy JTF_NUMBER_TABLE
6825 , p53_a75 out nocopy JTF_DATE_TABLE
6826 , p53_a76 out nocopy JTF_DATE_TABLE
6827 , p53_a77 out nocopy JTF_VARCHAR2_TABLE_100
6828 , p53_a78 out nocopy JTF_VARCHAR2_TABLE_100
6829 , p53_a79 out nocopy JTF_VARCHAR2_TABLE_100
6830 , p53_a80 out nocopy JTF_NUMBER_TABLE
6831 , p53_a81 out nocopy JTF_NUMBER_TABLE
6832 , x_total_retrieved out nocopy NUMBER
6833 , x_total_returned out nocopy NUMBER
6834 , x_return_status out nocopy VARCHAR2
6835 , x_msg_count out nocopy NUMBER
6836 , x_msg_data out nocopy VARCHAR2
6837 , x_object_version_number in out nocopy NUMBER
6838 )
6839
6840 as
6841 ddp_planned_start_date date;
6842 ddp_planned_end_date date;
6843 ddp_scheduled_start_date date;
6844 ddp_scheduled_end_date date;
6845 ddp_actual_start_date date;
6846 ddp_actual_end_date date;
6847 ddp_sort_data jtf_tasks_pub.sort_data;
6848 ddx_task_table jtf_tasks_pub.task_table_type;
6849 ddindx binary_integer; indx binary_integer;
6850 begin
6851
6852 -- copy data to the local IN or IN-OUT args, if any
6853
6854
6855
6856
6857
6858
6859
6860
6861
6862
6863
6864
6865
6866
6867
6868
6869
6870
6871
6872
6873
6874
6875
6876
6877 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
6878
6879 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
6880
6881 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
6882
6883 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
6884
6885 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
6886
6887 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
6888
6889
6890
6891
6892
6893
6894
6898
6895
6896
6897
6899
6900
6901
6902
6903
6904
6905
6906
6907 jtf_tasks_pub_w.rosetta_table_copy_in_p34(ddp_sort_data, p48_a0
6908 , p48_a1
6909 );
6910
6911
6912
6913
6914
6915
6916
6917
6918
6919
6920
6921
6922 -- here's the delegated call to the old PL/SQL routine
6923 jtf_tasks_pub.query_task(p_api_version,
6924 p_init_msg_list,
6925 p_validate_level,
6926 p_task_number,
6927 p_task_id,
6928 p_task_name,
6929 p_description,
6930 p_task_type_name,
6931 p_task_type_id,
6932 p_task_status_name,
6933 p_task_status_id,
6934 p_task_priority_name,
6935 p_task_priority_id,
6936 p_owner_type_code,
6937 p_owner_id,
6938 p_assigned_name,
6939 p_assigned_by_id,
6940 p_address_id,
6941 p_owner_territory_id,
6942 p_customer_id,
6943 p_customer_name,
6944 p_customer_number,
6945 p_cust_account_number,
6946 p_cust_account_id,
6947 ddp_planned_start_date,
6948 ddp_planned_end_date,
6949 ddp_scheduled_start_date,
6950 ddp_scheduled_end_date,
6951 ddp_actual_start_date,
6952 ddp_actual_end_date,
6953 p_object_type_code,
6954 p_object_name,
6955 p_source_object_id,
6956 p_percentage_complete,
6957 p_reason_code,
6958 p_private_flag,
6959 p_restrict_closure_flag,
6960 p_multi_booked_flag,
6961 p_milestone_flag,
6962 p_holiday_flag,
6963 p_workflow_process_id,
6964 p_notification_flag,
6965 p_parent_task_id,
6966 p_alarm_on,
6967 p_alarm_count,
6968 p_alarm_fired_count,
6969 p_ref_object_id,
6970 p_ref_object_type_code,
6971 ddp_sort_data,
6972 p_start_pointer,
6973 p_rec_wanted,
6974 p_show_all,
6975 p_query_or_next_code,
6976 ddx_task_table,
6977 x_total_retrieved,
6978 x_total_returned,
6979 x_return_status,
6980 x_msg_count,
6981 x_msg_data,
6982 x_object_version_number);
6983
6984 -- copy data back from the local variables to OUT or IN-OUT args, if any
6985
6986
6987
6988
6989
6990
6991
6992
6993
6994
6995
6996
6997
6998
6999
7000
7001
7002
7003
7004
7005
7006
7007
7008
7009
7010
7011
7012
7013
7014
7015
7016
7017
7018
7019
7020
7021
7022
7023
7024
7025
7026
7027
7028
7029
7030
7031
7032
7033
7034
7035
7036
7037
7038 jtf_tasks_pub_w.rosetta_table_copy_out_p31(ddx_task_table, p53_a0
7039 , p53_a1
7040 , p53_a2
7041 , p53_a3
7042 , p53_a4
7043 , p53_a5
7044 , p53_a6
7045 , p53_a7
7046 , p53_a8
7047 , p53_a9
7048 , p53_a10
7049 , p53_a11
7050 , p53_a12
7051 , p53_a13
7052 , p53_a14
7053 , p53_a15
7054 , p53_a16
7055 , p53_a17
7056 , p53_a18
7057 , p53_a19
7058 , p53_a20
7059 , p53_a21
7060 , p53_a22
7061 , p53_a23
7062 , p53_a24
7063 , p53_a25
7064 , p53_a26
7065 , p53_a27
7066 , p53_a28
7067 , p53_a29
7068 , p53_a30
7069 , p53_a31
7070 , p53_a32
7071 , p53_a33
7072 , p53_a34
7073 , p53_a35
7074 , p53_a36
7075 , p53_a37
7076 , p53_a38
7077 , p53_a39
7078 , p53_a40
7079 , p53_a41
7080 , p53_a42
7081 , p53_a43
7082 , p53_a44
7083 , p53_a45
7084 , p53_a46
7085 , p53_a47
7086 , p53_a48
7087 , p53_a49
7088 , p53_a50
7089 , p53_a51
7090 , p53_a52
7091 , p53_a53
7092 , p53_a54
7093 , p53_a55
7094 , p53_a56
7095 , p53_a57
7096 , p53_a58
7097 , p53_a59
7098 , p53_a60
7099 , p53_a61
7100 , p53_a62
7101 , p53_a63
7102 , p53_a64
7103 , p53_a65
7104 , p53_a66
7105 , p53_a67
7106 , p53_a68
7107 , p53_a69
7108 , p53_a70
7109 , p53_a71
7110 , p53_a72
7111 , p53_a73
7112 , p53_a74
7113 , p53_a75
7114 , p53_a76
7115 , p53_a77
7116 , p53_a78
7117 , p53_a79
7118 , p53_a80
7119 , p53_a81
7120 );
7121
7122
7123
7124
7125
7126
7127 end;
7128
7129 procedure query_next_task(p_api_version NUMBER
7130 , p_init_msg_list VARCHAR2
7131 , p_validate_level VARCHAR2
7132 , p_task_id NUMBER
7133 , p_query_type VARCHAR2
7134 , p_date_type VARCHAR2
7135 , p_date_start_or_end VARCHAR2
7136 , p_owner_id NUMBER
7137 , p_owner_type_code VARCHAR2
7138 , p_assigned_by NUMBER
7139 , p10_a0 JTF_VARCHAR2_TABLE_100
7140 , p10_a1 JTF_VARCHAR2_TABLE_100
7141 , p_start_pointer NUMBER
7145 , p15_a0 out nocopy JTF_NUMBER_TABLE
7142 , p_rec_wanted NUMBER
7143 , p_show_all VARCHAR2
7144 , p_query_or_next_code VARCHAR2
7146 , p15_a1 out nocopy JTF_VARCHAR2_TABLE_100
7147 , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
7148 , p15_a3 out nocopy JTF_VARCHAR2_TABLE_4000
7149 , p15_a4 out nocopy JTF_NUMBER_TABLE
7150 , p15_a5 out nocopy JTF_VARCHAR2_TABLE_100
7151 , p15_a6 out nocopy JTF_NUMBER_TABLE
7152 , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100
7153 , p15_a8 out nocopy JTF_NUMBER_TABLE
7154 , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
7155 , p15_a10 out nocopy JTF_VARCHAR2_TABLE_100
7156 , p15_a11 out nocopy JTF_NUMBER_TABLE
7157 , p15_a12 out nocopy JTF_VARCHAR2_TABLE_4000
7158 , p15_a13 out nocopy JTF_NUMBER_TABLE
7159 , p15_a14 out nocopy JTF_VARCHAR2_TABLE_4000
7160 , p15_a15 out nocopy JTF_NUMBER_TABLE
7161 , p15_a16 out nocopy JTF_VARCHAR2_TABLE_400
7162 , p15_a17 out nocopy JTF_VARCHAR2_TABLE_100
7163 , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
7164 , p15_a19 out nocopy JTF_NUMBER_TABLE
7165 , p15_a20 out nocopy JTF_NUMBER_TABLE
7166 , p15_a21 out nocopy JTF_DATE_TABLE
7167 , p15_a22 out nocopy JTF_DATE_TABLE
7168 , p15_a23 out nocopy JTF_DATE_TABLE
7169 , p15_a24 out nocopy JTF_DATE_TABLE
7170 , p15_a25 out nocopy JTF_DATE_TABLE
7171 , p15_a26 out nocopy JTF_DATE_TABLE
7172 , p15_a27 out nocopy JTF_VARCHAR2_TABLE_100
7173 , p15_a28 out nocopy JTF_NUMBER_TABLE
7174 , p15_a29 out nocopy JTF_VARCHAR2_TABLE_100
7175 , p15_a30 out nocopy JTF_NUMBER_TABLE
7176 , p15_a31 out nocopy JTF_VARCHAR2_TABLE_100
7177 , p15_a32 out nocopy JTF_NUMBER_TABLE
7178 , p15_a33 out nocopy JTF_VARCHAR2_TABLE_100
7179 , p15_a34 out nocopy JTF_NUMBER_TABLE
7180 , p15_a35 out nocopy JTF_VARCHAR2_TABLE_100
7181 , p15_a36 out nocopy JTF_NUMBER_TABLE
7182 , p15_a37 out nocopy JTF_VARCHAR2_TABLE_100
7183 , p15_a38 out nocopy JTF_VARCHAR2_TABLE_100
7184 , p15_a39 out nocopy JTF_VARCHAR2_TABLE_100
7185 , p15_a40 out nocopy JTF_VARCHAR2_TABLE_100
7186 , p15_a41 out nocopy JTF_VARCHAR2_TABLE_100
7187 , p15_a42 out nocopy JTF_VARCHAR2_TABLE_100
7188 , p15_a43 out nocopy JTF_NUMBER_TABLE
7189 , p15_a44 out nocopy JTF_VARCHAR2_TABLE_100
7190 , p15_a45 out nocopy JTF_NUMBER_TABLE
7191 , p15_a46 out nocopy JTF_VARCHAR2_TABLE_100
7192 , p15_a47 out nocopy JTF_NUMBER_TABLE
7193 , p15_a48 out nocopy JTF_NUMBER_TABLE
7194 , p15_a49 out nocopy JTF_VARCHAR2_TABLE_100
7195 , p15_a50 out nocopy JTF_VARCHAR2_TABLE_100
7196 , p15_a51 out nocopy JTF_NUMBER_TABLE
7197 , p15_a52 out nocopy JTF_NUMBER_TABLE
7198 , p15_a53 out nocopy JTF_NUMBER_TABLE
7199 , p15_a54 out nocopy JTF_VARCHAR2_TABLE_100
7200 , p15_a55 out nocopy JTF_VARCHAR2_TABLE_200
7201 , p15_a56 out nocopy JTF_VARCHAR2_TABLE_200
7202 , p15_a57 out nocopy JTF_VARCHAR2_TABLE_200
7203 , p15_a58 out nocopy JTF_VARCHAR2_TABLE_200
7204 , p15_a59 out nocopy JTF_VARCHAR2_TABLE_200
7205 , p15_a60 out nocopy JTF_VARCHAR2_TABLE_200
7206 , p15_a61 out nocopy JTF_VARCHAR2_TABLE_200
7207 , p15_a62 out nocopy JTF_VARCHAR2_TABLE_200
7208 , p15_a63 out nocopy JTF_VARCHAR2_TABLE_200
7209 , p15_a64 out nocopy JTF_VARCHAR2_TABLE_200
7210 , p15_a65 out nocopy JTF_VARCHAR2_TABLE_200
7211 , p15_a66 out nocopy JTF_VARCHAR2_TABLE_200
7212 , p15_a67 out nocopy JTF_VARCHAR2_TABLE_200
7213 , p15_a68 out nocopy JTF_VARCHAR2_TABLE_200
7214 , p15_a69 out nocopy JTF_VARCHAR2_TABLE_200
7215 , p15_a70 out nocopy JTF_VARCHAR2_TABLE_200
7216 , p15_a71 out nocopy JTF_NUMBER_TABLE
7217 , p15_a72 out nocopy JTF_DATE_TABLE
7218 , p15_a73 out nocopy JTF_VARCHAR2_TABLE_4000
7219 , p15_a74 out nocopy JTF_NUMBER_TABLE
7220 , p15_a75 out nocopy JTF_DATE_TABLE
7221 , p15_a76 out nocopy JTF_DATE_TABLE
7222 , p15_a77 out nocopy JTF_VARCHAR2_TABLE_100
7223 , p15_a78 out nocopy JTF_VARCHAR2_TABLE_100
7224 , p15_a79 out nocopy JTF_VARCHAR2_TABLE_100
7225 , p15_a80 out nocopy JTF_NUMBER_TABLE
7226 , p15_a81 out nocopy JTF_NUMBER_TABLE
7227 , x_total_retrieved out nocopy NUMBER
7228 , x_total_returned out nocopy NUMBER
7229 , x_return_status out nocopy VARCHAR2
7230 , x_msg_count out nocopy NUMBER
7231 , x_msg_data out nocopy VARCHAR2
7232 , x_object_version_number in out nocopy NUMBER
7233 )
7234
7235 as
7236 ddp_sort_data jtf_tasks_pub.sort_data;
7237 ddx_task_table jtf_tasks_pub.task_table_type;
7238 ddindx binary_integer; indx binary_integer;
7239 begin
7240
7241 -- copy data to the local IN or IN-OUT args, if any
7242
7243
7244
7245
7246
7247
7248
7249
7250
7251
7252 jtf_tasks_pub_w.rosetta_table_copy_in_p34(ddp_sort_data, p10_a0
7253 , p10_a1
7254 );
7255
7256
7257
7258
7259
7260
7261
7262
7263
7264
7265
7266
7267 -- here's the delegated call to the old PL/SQL routine
7268 jtf_tasks_pub.query_next_task(p_api_version,
7269 p_init_msg_list,
7270 p_validate_level,
7271 p_task_id,
7272 p_query_type,
7273 p_date_type,
7274 p_date_start_or_end,
7275 p_owner_id,
7276 p_owner_type_code,
7277 p_assigned_by,
7278 ddp_sort_data,
7279 p_start_pointer,
7280 p_rec_wanted,
7281 p_show_all,
7282 p_query_or_next_code,
7283 ddx_task_table,
7284 x_total_retrieved,
7285 x_total_returned,
7286 x_return_status,
7287 x_msg_count,
7288 x_msg_data,
7289 x_object_version_number);
7290
7291 -- copy data back from the local variables to OUT or IN-OUT args, if any
7295
7292
7293
7294
7296
7297
7298
7299
7300
7301
7302
7303
7304
7305
7306
7307 jtf_tasks_pub_w.rosetta_table_copy_out_p31(ddx_task_table, p15_a0
7308 , p15_a1
7309 , p15_a2
7310 , p15_a3
7311 , p15_a4
7312 , p15_a5
7313 , p15_a6
7314 , p15_a7
7315 , p15_a8
7316 , p15_a9
7317 , p15_a10
7318 , p15_a11
7319 , p15_a12
7320 , p15_a13
7321 , p15_a14
7322 , p15_a15
7323 , p15_a16
7324 , p15_a17
7325 , p15_a18
7326 , p15_a19
7327 , p15_a20
7328 , p15_a21
7329 , p15_a22
7330 , p15_a23
7331 , p15_a24
7332 , p15_a25
7333 , p15_a26
7334 , p15_a27
7335 , p15_a28
7336 , p15_a29
7337 , p15_a30
7338 , p15_a31
7339 , p15_a32
7340 , p15_a33
7341 , p15_a34
7342 , p15_a35
7343 , p15_a36
7344 , p15_a37
7345 , p15_a38
7346 , p15_a39
7347 , p15_a40
7348 , p15_a41
7349 , p15_a42
7350 , p15_a43
7351 , p15_a44
7352 , p15_a45
7353 , p15_a46
7354 , p15_a47
7355 , p15_a48
7356 , p15_a49
7357 , p15_a50
7358 , p15_a51
7359 , p15_a52
7360 , p15_a53
7361 , p15_a54
7362 , p15_a55
7363 , p15_a56
7364 , p15_a57
7365 , p15_a58
7366 , p15_a59
7367 , p15_a60
7368 , p15_a61
7369 , p15_a62
7370 , p15_a63
7371 , p15_a64
7372 , p15_a65
7373 , p15_a66
7374 , p15_a67
7375 , p15_a68
7376 , p15_a69
7377 , p15_a70
7378 , p15_a71
7379 , p15_a72
7380 , p15_a73
7381 , p15_a74
7382 , p15_a75
7383 , p15_a76
7384 , p15_a77
7385 , p15_a78
7386 , p15_a79
7387 , p15_a80
7388 , p15_a81
7389 );
7390
7391
7392
7393
7394
7395
7396 end;
7397
7398 procedure export_file(p_api_version NUMBER
7399 , p_init_msg_list VARCHAR2
7400 , p_validate_level VARCHAR2
7401 , p_file_name VARCHAR2
7402 , p4_a0 JTF_NUMBER_TABLE
7403 , p4_a1 JTF_VARCHAR2_TABLE_100
7404 , p4_a2 JTF_VARCHAR2_TABLE_100
7405 , p4_a3 JTF_VARCHAR2_TABLE_4000
7406 , p4_a4 JTF_NUMBER_TABLE
7407 , p4_a5 JTF_VARCHAR2_TABLE_100
7408 , p4_a6 JTF_NUMBER_TABLE
7409 , p4_a7 JTF_VARCHAR2_TABLE_100
7410 , p4_a8 JTF_NUMBER_TABLE
7411 , p4_a9 JTF_VARCHAR2_TABLE_100
7412 , p4_a10 JTF_VARCHAR2_TABLE_100
7413 , p4_a11 JTF_NUMBER_TABLE
7414 , p4_a12 JTF_VARCHAR2_TABLE_4000
7415 , p4_a13 JTF_NUMBER_TABLE
7416 , p4_a14 JTF_VARCHAR2_TABLE_4000
7417 , p4_a15 JTF_NUMBER_TABLE
7418 , p4_a16 JTF_VARCHAR2_TABLE_400
7419 , p4_a17 JTF_VARCHAR2_TABLE_100
7420 , p4_a18 JTF_VARCHAR2_TABLE_100
7421 , p4_a19 JTF_NUMBER_TABLE
7422 , p4_a20 JTF_NUMBER_TABLE
7423 , p4_a21 JTF_DATE_TABLE
7424 , p4_a22 JTF_DATE_TABLE
7425 , p4_a23 JTF_DATE_TABLE
7426 , p4_a24 JTF_DATE_TABLE
7427 , p4_a25 JTF_DATE_TABLE
7428 , p4_a26 JTF_DATE_TABLE
7429 , p4_a27 JTF_VARCHAR2_TABLE_100
7430 , p4_a28 JTF_NUMBER_TABLE
7431 , p4_a29 JTF_VARCHAR2_TABLE_100
7432 , p4_a30 JTF_NUMBER_TABLE
7433 , p4_a31 JTF_VARCHAR2_TABLE_100
7434 , p4_a32 JTF_NUMBER_TABLE
7435 , p4_a33 JTF_VARCHAR2_TABLE_100
7436 , p4_a34 JTF_NUMBER_TABLE
7437 , p4_a35 JTF_VARCHAR2_TABLE_100
7438 , p4_a36 JTF_NUMBER_TABLE
7439 , p4_a37 JTF_VARCHAR2_TABLE_100
7440 , p4_a38 JTF_VARCHAR2_TABLE_100
7441 , p4_a39 JTF_VARCHAR2_TABLE_100
7442 , p4_a40 JTF_VARCHAR2_TABLE_100
7443 , p4_a41 JTF_VARCHAR2_TABLE_100
7444 , p4_a42 JTF_VARCHAR2_TABLE_100
7445 , p4_a43 JTF_NUMBER_TABLE
7446 , p4_a44 JTF_VARCHAR2_TABLE_100
7447 , p4_a45 JTF_NUMBER_TABLE
7448 , p4_a46 JTF_VARCHAR2_TABLE_100
7449 , p4_a47 JTF_NUMBER_TABLE
7450 , p4_a48 JTF_NUMBER_TABLE
7451 , p4_a49 JTF_VARCHAR2_TABLE_100
7452 , p4_a50 JTF_VARCHAR2_TABLE_100
7453 , p4_a51 JTF_NUMBER_TABLE
7454 , p4_a52 JTF_NUMBER_TABLE
7455 , p4_a53 JTF_NUMBER_TABLE
7456 , p4_a54 JTF_VARCHAR2_TABLE_100
7457 , p4_a55 JTF_VARCHAR2_TABLE_200
7458 , p4_a56 JTF_VARCHAR2_TABLE_200
7459 , p4_a57 JTF_VARCHAR2_TABLE_200
7460 , p4_a58 JTF_VARCHAR2_TABLE_200
7461 , p4_a59 JTF_VARCHAR2_TABLE_200
7462 , p4_a60 JTF_VARCHAR2_TABLE_200
7463 , p4_a61 JTF_VARCHAR2_TABLE_200
7464 , p4_a62 JTF_VARCHAR2_TABLE_200
7465 , p4_a63 JTF_VARCHAR2_TABLE_200
7466 , p4_a64 JTF_VARCHAR2_TABLE_200
7467 , p4_a65 JTF_VARCHAR2_TABLE_200
7468 , p4_a66 JTF_VARCHAR2_TABLE_200
7469 , p4_a67 JTF_VARCHAR2_TABLE_200
7470 , p4_a68 JTF_VARCHAR2_TABLE_200
7471 , p4_a69 JTF_VARCHAR2_TABLE_200
7472 , p4_a70 JTF_VARCHAR2_TABLE_200
7473 , p4_a71 JTF_NUMBER_TABLE
7474 , p4_a72 JTF_DATE_TABLE
7475 , p4_a73 JTF_VARCHAR2_TABLE_4000
7476 , p4_a74 JTF_NUMBER_TABLE
7477 , p4_a75 JTF_DATE_TABLE
7478 , p4_a76 JTF_DATE_TABLE
7479 , p4_a77 JTF_VARCHAR2_TABLE_100
7480 , p4_a78 JTF_VARCHAR2_TABLE_100
7481 , p4_a79 JTF_VARCHAR2_TABLE_100
7482 , p4_a80 JTF_NUMBER_TABLE
7483 , p4_a81 JTF_NUMBER_TABLE
7484 , x_return_status out nocopy VARCHAR2
7485 , x_msg_count out nocopy NUMBER
7489
7486 , x_msg_data out nocopy VARCHAR2
7487 , x_object_version_number in out nocopy NUMBER
7488 )
7490 as
7491 ddp_task_table jtf_tasks_pub.task_table_type;
7492 ddindx binary_integer; indx binary_integer;
7493 begin
7494
7495 -- copy data to the local IN or IN-OUT args, if any
7496
7497
7498
7499
7500 jtf_tasks_pub_w.rosetta_table_copy_in_p31(ddp_task_table, p4_a0
7501 , p4_a1
7502 , p4_a2
7503 , p4_a3
7504 , p4_a4
7505 , p4_a5
7506 , p4_a6
7507 , p4_a7
7508 , p4_a8
7509 , p4_a9
7510 , p4_a10
7511 , p4_a11
7512 , p4_a12
7513 , p4_a13
7514 , p4_a14
7515 , p4_a15
7516 , p4_a16
7517 , p4_a17
7518 , p4_a18
7519 , p4_a19
7520 , p4_a20
7521 , p4_a21
7522 , p4_a22
7523 , p4_a23
7524 , p4_a24
7525 , p4_a25
7526 , p4_a26
7527 , p4_a27
7528 , p4_a28
7529 , p4_a29
7530 , p4_a30
7531 , p4_a31
7532 , p4_a32
7533 , p4_a33
7534 , p4_a34
7535 , p4_a35
7536 , p4_a36
7537 , p4_a37
7538 , p4_a38
7539 , p4_a39
7540 , p4_a40
7541 , p4_a41
7542 , p4_a42
7543 , p4_a43
7544 , p4_a44
7545 , p4_a45
7546 , p4_a46
7547 , p4_a47
7548 , p4_a48
7549 , p4_a49
7550 , p4_a50
7551 , p4_a51
7552 , p4_a52
7553 , p4_a53
7554 , p4_a54
7555 , p4_a55
7556 , p4_a56
7557 , p4_a57
7558 , p4_a58
7559 , p4_a59
7560 , p4_a60
7561 , p4_a61
7562 , p4_a62
7563 , p4_a63
7564 , p4_a64
7565 , p4_a65
7566 , p4_a66
7567 , p4_a67
7568 , p4_a68
7569 , p4_a69
7570 , p4_a70
7571 , p4_a71
7572 , p4_a72
7573 , p4_a73
7574 , p4_a74
7575 , p4_a75
7576 , p4_a76
7577 , p4_a77
7578 , p4_a78
7579 , p4_a79
7580 , p4_a80
7581 , p4_a81
7582 );
7583
7584
7585
7586
7587
7588 -- here's the delegated call to the old PL/SQL routine
7589 jtf_tasks_pub.export_file(p_api_version,
7590 p_init_msg_list,
7591 p_validate_level,
7592 p_file_name,
7593 ddp_task_table,
7594 x_return_status,
7595 x_msg_count,
7596 x_msg_data,
7597 x_object_version_number);
7598
7599 -- copy data back from the local variables to OUT or IN-OUT args, if any
7600
7601
7602
7603
7604
7605
7606
7607
7608 end;
7609
7610 procedure create_task_from_template(p_api_version NUMBER
7611 , p_init_msg_list VARCHAR2
7612 , p_commit VARCHAR2
7613 , p_task_template_group_id NUMBER
7614 , p_task_template_group_name VARCHAR2
7615 , p_owner_type_code VARCHAR2
7616 , p_owner_id NUMBER
7617 , p_source_object_id NUMBER
7618 , p_source_object_name VARCHAR2
7619 , x_return_status out nocopy VARCHAR2
7620 , x_msg_count out nocopy NUMBER
7621 , x_msg_data out nocopy VARCHAR2
7622 , p12_a0 out nocopy JTF_NUMBER_TABLE
7623 , p12_a1 out nocopy JTF_NUMBER_TABLE
7624 , p_assigned_by_id NUMBER
7625 , p_cust_account_id NUMBER
7626 , p_customer_id NUMBER
7627 , p_address_id NUMBER
7628 , p_actual_start_date date
7629 , p_actual_end_date date
7630 , p_planned_start_date date
7631 , p_planned_end_date date
7632 , p_scheduled_start_date date
7633 , p_scheduled_end_date date
7634 , p_palm_flag VARCHAR2
7635 , p_wince_flag VARCHAR2
7636 , p_laptop_flag VARCHAR2
7637 , p_device1_flag VARCHAR2
7638 , p_device2_flag VARCHAR2
7639 , p_device3_flag VARCHAR2
7640 , p_parent_task_id NUMBER
7641 , p_percentage_complete NUMBER
7642 , p_timezone_id NUMBER
7643 , p_actual_effort NUMBER
7644 , p_actual_effort_uom VARCHAR2
7645 , p_reason_code VARCHAR2
7646 , p_bound_mode_code VARCHAR2
7647 , p_soft_bound_flag VARCHAR2
7648 , p_workflow_process_id NUMBER
7649 , p_owner_territory_id NUMBER
7650 , p_costs NUMBER
7651 , p_currency_code VARCHAR2
7652 , p_attribute1 VARCHAR2
7653 , p_attribute2 VARCHAR2
7654 , p_attribute3 VARCHAR2
7655 , p_attribute4 VARCHAR2
7656 , p_attribute5 VARCHAR2
7657 , p_attribute6 VARCHAR2
7658 , p_attribute7 VARCHAR2
7659 , p_attribute8 VARCHAR2
7660 , p_attribute9 VARCHAR2
7661 , p_attribute10 VARCHAR2
7662 , p_attribute11 VARCHAR2
7663 , p_attribute12 VARCHAR2
7664 , p_attribute13 VARCHAR2
7665 , p_attribute14 VARCHAR2
7666 , p_attribute15 VARCHAR2
7667 , p_attribute_category VARCHAR2
7668 , p_date_selected VARCHAR2
7669 , p_location_id NUMBER
7670 )
7671
7672 as
7673 ddx_task_details_tbl jtf_tasks_pub.task_details_tbl;
7674 ddp_actual_start_date date;
7675 ddp_actual_end_date date;
7676 ddp_planned_start_date date;
7677 ddp_planned_end_date date;
7678 ddp_scheduled_start_date date;
7679 ddp_scheduled_end_date date;
7680 ddindx binary_integer; indx binary_integer;
7681 begin
7682
7683 -- copy data to the local IN or IN-OUT args, if any
7684
7685
7686
7687
7688
7689
7690
7691
7692
7693
7694
7695
7696
7697
7698
7699
7700
7701 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
7702
7703 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
7704
7705 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
7706
7707 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
7708
7709 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
7710
7711 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
7712
7713
7714
7715
7716
7717
7718
7719
7720
7721
7722
7723
7724
7725
7726
7727
7728
7729
7730
7731
7732
7733
7734
7735
7736
7737
7738
7739
7740
7741
7742
7743
7744
7745
7746
7747
7748
7749 -- here's the delegated call to the old PL/SQL routine
7750 jtf_tasks_pub.create_task_from_template(p_api_version,
7751 p_init_msg_list,
7752 p_commit,
7753 p_task_template_group_id,
7754 p_task_template_group_name,
7755 p_owner_type_code,
7756 p_owner_id,
7757 p_source_object_id,
7761 x_msg_data,
7758 p_source_object_name,
7759 x_return_status,
7760 x_msg_count,
7762 ddx_task_details_tbl,
7763 p_assigned_by_id,
7764 p_cust_account_id,
7765 p_customer_id,
7766 p_address_id,
7767 ddp_actual_start_date,
7768 ddp_actual_end_date,
7769 ddp_planned_start_date,
7770 ddp_planned_end_date,
7771 ddp_scheduled_start_date,
7772 ddp_scheduled_end_date,
7773 p_palm_flag,
7774 p_wince_flag,
7775 p_laptop_flag,
7776 p_device1_flag,
7777 p_device2_flag,
7778 p_device3_flag,
7779 p_parent_task_id,
7780 p_percentage_complete,
7781 p_timezone_id,
7782 p_actual_effort,
7783 p_actual_effort_uom,
7784 p_reason_code,
7785 p_bound_mode_code,
7786 p_soft_bound_flag,
7787 p_workflow_process_id,
7788 p_owner_territory_id,
7789 p_costs,
7790 p_currency_code,
7791 p_attribute1,
7792 p_attribute2,
7793 p_attribute3,
7794 p_attribute4,
7795 p_attribute5,
7796 p_attribute6,
7797 p_attribute7,
7798 p_attribute8,
7799 p_attribute9,
7800 p_attribute10,
7801 p_attribute11,
7802 p_attribute12,
7803 p_attribute13,
7804 p_attribute14,
7805 p_attribute15,
7806 p_attribute_category,
7807 p_date_selected,
7808 p_location_id);
7809
7810 -- copy data back from the local variables to OUT or IN-OUT args, if any
7811
7812
7813
7814
7815
7816
7817
7818
7819
7820
7821
7822
7823 jtf_tasks_pub_w.rosetta_table_copy_out_p53(ddx_task_details_tbl, p12_a0
7824 , p12_a1
7825 );
7826
7827
7828
7829
7830
7831
7832
7833
7834
7835
7836
7837
7838
7839
7840
7841
7842
7843
7844
7845
7846
7847
7848
7849
7850
7851
7852
7853
7854
7855
7856
7857
7858
7859
7860
7861
7862
7863
7864
7865
7866
7867
7868
7869
7870
7871
7872 end;
7873
7874 procedure create_task_from_template(p_api_version NUMBER
7875 , p_init_msg_list VARCHAR2
7876 , p_commit VARCHAR2
7877 , p_task_template_group_id NUMBER
7878 , p_task_template_group_name VARCHAR2
7879 , p_owner_type_code VARCHAR2
7880 , p_owner_id NUMBER
7881 , p_source_object_id NUMBER
7882 , p_source_object_name VARCHAR2
7883 , x_return_status out nocopy VARCHAR2
7884 , x_msg_count out nocopy NUMBER
7885 , x_msg_data out nocopy VARCHAR2
7886 , p12_a0 out nocopy JTF_NUMBER_TABLE
7887 , p12_a1 out nocopy JTF_NUMBER_TABLE
7888 , p_assigned_by_id NUMBER
7889 , p_cust_account_id NUMBER
7890 , p_customer_id NUMBER
7891 , p_address_id NUMBER
7892 , p_actual_start_date date
7893 , p_actual_end_date date
7894 , p_planned_start_date date
7895 , p_planned_end_date date
7896 , p_scheduled_start_date date
7897 , p_scheduled_end_date date
7898 , p_palm_flag VARCHAR2
7899 , p_wince_flag VARCHAR2
7900 , p_laptop_flag VARCHAR2
7901 , p_device1_flag VARCHAR2
7902 , p_device2_flag VARCHAR2
7903 , p_device3_flag VARCHAR2
7904 , p_parent_task_id NUMBER
7905 , p_percentage_complete NUMBER
7906 , p_timezone_id NUMBER
7907 , p_actual_effort NUMBER
7908 , p_actual_effort_uom VARCHAR2
7909 , p_reason_code VARCHAR2
7910 , p_bound_mode_code VARCHAR2
7911 , p_soft_bound_flag VARCHAR2
7912 , p_workflow_process_id NUMBER
7913 , p_owner_territory_id NUMBER
7914 , p_costs NUMBER
7915 , p_currency_code VARCHAR2
7916 , p_attribute1 VARCHAR2
7917 , p_attribute2 VARCHAR2
7918 , p_attribute3 VARCHAR2
7919 , p_attribute4 VARCHAR2
7920 , p_attribute5 VARCHAR2
7921 , p_attribute6 VARCHAR2
7922 , p_attribute7 VARCHAR2
7923 , p_attribute8 VARCHAR2
7924 , p_attribute9 VARCHAR2
7925 , p_attribute10 VARCHAR2
7926 , p_attribute11 VARCHAR2
7927 , p_attribute12 VARCHAR2
7928 , p_attribute13 VARCHAR2
7929 , p_attribute14 VARCHAR2
7930 , p_attribute15 VARCHAR2
7931 , p_attribute_category VARCHAR2
7932 , p_date_selected VARCHAR2
7933 )
7934
7935 as
7936 ddx_task_details_tbl jtf_tasks_pub.task_details_tbl;
7937 ddp_actual_start_date date;
7938 ddp_actual_end_date date;
7939 ddp_planned_start_date date;
7940 ddp_planned_end_date date;
7941 ddp_scheduled_start_date date;
7942 ddp_scheduled_end_date date;
7943 ddindx binary_integer; indx binary_integer;
7944 begin
7945
7946 -- copy data to the local IN or IN-OUT args, if any
7947
7948
7949
7950
7951
7952
7953
7954
7955
7956
7957
7958
7959
7960
7961
7962
7963
7964 ddp_actual_start_date := rosetta_g_miss_date_in_map(p_actual_start_date);
7965
7966 ddp_actual_end_date := rosetta_g_miss_date_in_map(p_actual_end_date);
7967
7968 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
7969
7970 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
7971
7972 ddp_scheduled_start_date := rosetta_g_miss_date_in_map(p_scheduled_start_date);
7973
7974 ddp_scheduled_end_date := rosetta_g_miss_date_in_map(p_scheduled_end_date);
7975
7976
7977
7978
7979
7980
7981
7982
7983
7984
7985
7986
7987
7988
7989
7990
7991
7992
7993
7994
7995
7996
7997
7998
7999
8000
8001
8002
8003
8004
8005
8006
8007
8008
8009
8010
8011 -- here's the delegated call to the old PL/SQL routine
8012 jtf_tasks_pub.create_task_from_template(p_api_version,
8013 p_init_msg_list,
8014 p_commit,
8015 p_task_template_group_id,
8016 p_task_template_group_name,
8017 p_owner_type_code,
8018 p_owner_id,
8019 p_source_object_id,
8020 p_source_object_name,
8021 x_return_status,
8022 x_msg_count,
8023 x_msg_data,
8024 ddx_task_details_tbl,
8025 p_assigned_by_id,
8026 p_cust_account_id,
8027 p_customer_id,
8028 p_address_id,
8029 ddp_actual_start_date,
8030 ddp_actual_end_date,
8031 ddp_planned_start_date,
8032 ddp_planned_end_date,
8033 ddp_scheduled_start_date,
8034 ddp_scheduled_end_date,
8035 p_palm_flag,
8036 p_wince_flag,
8037 p_laptop_flag,
8038 p_device1_flag,
8039 p_device2_flag,
8040 p_device3_flag,
8041 p_parent_task_id,
8042 p_percentage_complete,
8043 p_timezone_id,
8044 p_actual_effort,
8045 p_actual_effort_uom,
8046 p_reason_code,
8047 p_bound_mode_code,
8048 p_soft_bound_flag,
8049 p_workflow_process_id,
8050 p_owner_territory_id,
8051 p_costs,
8052 p_currency_code,
8053 p_attribute1,
8054 p_attribute2,
8055 p_attribute3,
8056 p_attribute4,
8057 p_attribute5,
8058 p_attribute6,
8059 p_attribute7,
8060 p_attribute8,
8061 p_attribute9,
8062 p_attribute10,
8063 p_attribute11,
8064 p_attribute12,
8065 p_attribute13,
8066 p_attribute14,
8067 p_attribute15,
8068 p_attribute_category,
8069 p_date_selected);
8070
8071 -- copy data back from the local variables to OUT or IN-OUT args, if any
8072
8073
8074
8075
8076
8077
8078
8079
8080
8081
8082
8083
8084 jtf_tasks_pub_w.rosetta_table_copy_out_p53(ddx_task_details_tbl, p12_a0
8085 , p12_a1
8086 );
8087
8088
8089
8090
8091
8092
8093
8094
8095
8096
8097
8098
8099
8100
8101
8102
8103
8104
8105
8106
8107
8108
8109
8110
8111
8112
8113
8114
8115
8116
8117
8118
8119
8120
8121
8122
8123
8124
8125
8126
8127
8128
8129
8130
8131
8132 end;
8133
8134 end jtf_tasks_pub_w;