[Home] [Help]
PACKAGE BODY: APPS.JTF_ASSIGN_PUB_W
Source
1 package body jtf_assign_pub_w as
2 /* $Header: jtfampwb.pls 120.2 2006/06/27 12:01:42 abraina 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
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure rosetta_table_copy_in_p8(t out nocopy jtf_assign_pub.avail_tbl_type, a0 JTF_NUMBER_TABLE
23 , a1 JTF_VARCHAR2_TABLE_100
24 , a2 JTF_DATE_TABLE
25 , a3 JTF_DATE_TABLE
26 , a4 JTF_NUMBER_TABLE
27 ) as
28 ddindx binary_integer; indx binary_integer;
29 begin
30 if a0 is not null and a0.count > 0 then
31 if a0.count > 0 then
32 indx := a0.first;
33 ddindx := 1;
34 while true loop
35 t(ddindx).resource_id := rosetta_g_miss_num_map(a0(indx));
36 t(ddindx).resource_type := a1(indx);
37 t(ddindx).start_date := rosetta_g_miss_date_in_map(a2(indx));
38 t(ddindx).end_date := rosetta_g_miss_date_in_map(a3(indx));
39 t(ddindx).shift_construct_id := rosetta_g_miss_num_map(a4(indx));
40 ddindx := ddindx+1;
41 if a0.last =indx
42 then exit;
43 end if;
44 indx := a0.next(indx);
45 end loop;
46 end if;
47 end if;
48 end rosetta_table_copy_in_p8;
49 procedure rosetta_table_copy_out_p8(t jtf_assign_pub.avail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50 , a1 out nocopy JTF_VARCHAR2_TABLE_100
51 , a2 out nocopy JTF_DATE_TABLE
52 , a3 out nocopy JTF_DATE_TABLE
53 , a4 out nocopy JTF_NUMBER_TABLE
54 ) as
55 ddindx binary_integer; indx binary_integer;
56 begin
57 if t is null or t.count = 0 then
58 a0 := JTF_NUMBER_TABLE();
59 a1 := JTF_VARCHAR2_TABLE_100();
60 a2 := JTF_DATE_TABLE();
61 a3 := JTF_DATE_TABLE();
62 a4 := JTF_NUMBER_TABLE();
63 else
64 a0 := JTF_NUMBER_TABLE();
65 a1 := JTF_VARCHAR2_TABLE_100();
66 a2 := JTF_DATE_TABLE();
67 a3 := JTF_DATE_TABLE();
68 a4 := JTF_NUMBER_TABLE();
69 if t.count > 0 then
70 a0.extend(t.count);
71 a1.extend(t.count);
72 a2.extend(t.count);
73 a3.extend(t.count);
74 a4.extend(t.count);
75 ddindx := t.first;
76 indx := 1;
77 while true loop
78 a0(indx) := rosetta_g_miss_num_map(t(ddindx).resource_id);
79 a1(indx) := t(ddindx).resource_type;
80 a2(indx) := t(ddindx).start_date;
81 a3(indx) := t(ddindx).end_date;
82 a4(indx) := rosetta_g_miss_num_map(t(ddindx).shift_construct_id);
83 indx := indx+1;
84 if t.last =ddindx
85 then exit;
86 end if;
87 ddindx := t.next(ddindx);
88 end loop;
89 end if;
90 end if;
91 end rosetta_table_copy_out_p8;
92
93 procedure rosetta_table_copy_in_p11(t out nocopy jtf_assign_pub.assignresources_tbl_type, a0 JTF_NUMBER_TABLE
94 , a1 JTF_NUMBER_TABLE
95 , a2 JTF_VARCHAR2_TABLE_100
96 , a3 JTF_VARCHAR2_TABLE_100
97 , a4 JTF_DATE_TABLE
98 , a5 JTF_DATE_TABLE
99 , a6 JTF_NUMBER_TABLE
100 , a7 JTF_NUMBER_TABLE
101 , a8 JTF_VARCHAR2_TABLE_300
102 , a9 JTF_NUMBER_TABLE
103 , a10 JTF_NUMBER_TABLE
104 , a11 JTF_VARCHAR2_TABLE_100
105 , a12 JTF_VARCHAR2_TABLE_100
106 , a13 JTF_VARCHAR2_TABLE_100
107 , a14 JTF_VARCHAR2_TABLE_100
108 , a15 JTF_NUMBER_TABLE
109 , a16 JTF_VARCHAR2_TABLE_100
110 , a17 JTF_NUMBER_TABLE
111 , a18 JTF_VARCHAR2_TABLE_100
112 , a19 JTF_DATE_TABLE
113 , a20 JTF_DATE_TABLE
114 , a21 JTF_NUMBER_TABLE
115 , a22 JTF_VARCHAR2_TABLE_200
116 , a23 JTF_VARCHAR2_TABLE_100
117 , a24 JTF_NUMBER_TABLE
118 , a25 JTF_VARCHAR2_TABLE_100
119 , a26 JTF_VARCHAR2_TABLE_100
120 ) as
121 ddindx binary_integer; indx binary_integer;
122 begin
123 if a0 is not null and a0.count > 0 then
124 if a0.count > 0 then
125 indx := a0.first;
126 ddindx := 1;
127 while true loop
128 t(ddindx).terr_rsc_id := rosetta_g_miss_num_map(a0(indx));
129 t(ddindx).resource_id := rosetta_g_miss_num_map(a1(indx));
130 t(ddindx).resource_type := a2(indx);
131 t(ddindx).role := a3(indx);
132 t(ddindx).start_date := rosetta_g_miss_date_in_map(a4(indx));
133 t(ddindx).end_date := rosetta_g_miss_date_in_map(a5(indx));
134 t(ddindx).shift_construct_id := rosetta_g_miss_num_map(a6(indx));
135 t(ddindx).terr_id := rosetta_g_miss_num_map(a7(indx));
136 t(ddindx).terr_name := a8(indx);
137 t(ddindx).terr_rank := rosetta_g_miss_num_map(a9(indx));
138 t(ddindx).travel_time := rosetta_g_miss_num_map(a10(indx));
139 t(ddindx).travel_uom := a11(indx);
140 t(ddindx).preference_type := a12(indx);
141 t(ddindx).primary_contact_flag := a13(indx);
142 t(ddindx).full_access_flag := a14(indx);
143 t(ddindx).group_id := rosetta_g_miss_num_map(a15(indx));
144 t(ddindx).location := a16(indx);
145 t(ddindx).trans_object_id := rosetta_g_miss_num_map(a17(indx));
146 t(ddindx).resource_source := a18(indx);
147 t(ddindx).source_start_date := rosetta_g_miss_date_in_map(a19(indx));
148 t(ddindx).source_end_date := rosetta_g_miss_date_in_map(a20(indx));
149 t(ddindx).support_site_id := rosetta_g_miss_num_map(a21(indx));
150 t(ddindx).support_site_name := a22(indx);
151 t(ddindx).web_availability_flag := a23(indx);
152 t(ddindx).skill_level := rosetta_g_miss_num_map(a24(indx));
153 t(ddindx).skill_name := a25(indx);
154 t(ddindx).primary_flag := a26(indx);
155 ddindx := ddindx+1;
156 if a0.last =indx
157 then exit;
158 end if;
159 indx := a0.next(indx);
160 end loop;
161 end if;
162 end if;
163 end rosetta_table_copy_in_p11;
164 procedure rosetta_table_copy_out_p11(t jtf_assign_pub.assignresources_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
165 , a1 out nocopy JTF_NUMBER_TABLE
166 , a2 out nocopy JTF_VARCHAR2_TABLE_100
167 , a3 out nocopy JTF_VARCHAR2_TABLE_100
168 , a4 out nocopy JTF_DATE_TABLE
169 , a5 out nocopy JTF_DATE_TABLE
170 , a6 out nocopy JTF_NUMBER_TABLE
171 , a7 out nocopy JTF_NUMBER_TABLE
172 , a8 out nocopy JTF_VARCHAR2_TABLE_300
173 , a9 out nocopy JTF_NUMBER_TABLE
174 , a10 out nocopy JTF_NUMBER_TABLE
175 , a11 out nocopy JTF_VARCHAR2_TABLE_100
176 , a12 out nocopy JTF_VARCHAR2_TABLE_100
177 , a13 out nocopy JTF_VARCHAR2_TABLE_100
178 , a14 out nocopy JTF_VARCHAR2_TABLE_100
179 , a15 out nocopy JTF_NUMBER_TABLE
180 , a16 out nocopy JTF_VARCHAR2_TABLE_100
181 , a17 out nocopy JTF_NUMBER_TABLE
182 , a18 out nocopy JTF_VARCHAR2_TABLE_100
183 , a19 out nocopy JTF_DATE_TABLE
184 , a20 out nocopy JTF_DATE_TABLE
185 , a21 out nocopy JTF_NUMBER_TABLE
186 , a22 out nocopy JTF_VARCHAR2_TABLE_200
187 , a23 out nocopy JTF_VARCHAR2_TABLE_100
188 , a24 out nocopy JTF_NUMBER_TABLE
189 , a25 out nocopy JTF_VARCHAR2_TABLE_100
190 , a26 out nocopy JTF_VARCHAR2_TABLE_100
191 ) as
192 ddindx binary_integer; indx binary_integer;
193 begin
194 if t is null or t.count = 0 then
195 a0 := JTF_NUMBER_TABLE();
196 a1 := JTF_NUMBER_TABLE();
197 a2 := JTF_VARCHAR2_TABLE_100();
198 a3 := JTF_VARCHAR2_TABLE_100();
199 a4 := JTF_DATE_TABLE();
200 a5 := JTF_DATE_TABLE();
201 a6 := JTF_NUMBER_TABLE();
202 a7 := JTF_NUMBER_TABLE();
203 a8 := JTF_VARCHAR2_TABLE_300();
204 a9 := JTF_NUMBER_TABLE();
205 a10 := JTF_NUMBER_TABLE();
206 a11 := JTF_VARCHAR2_TABLE_100();
207 a12 := JTF_VARCHAR2_TABLE_100();
208 a13 := JTF_VARCHAR2_TABLE_100();
209 a14 := JTF_VARCHAR2_TABLE_100();
210 a15 := JTF_NUMBER_TABLE();
211 a16 := JTF_VARCHAR2_TABLE_100();
212 a17 := JTF_NUMBER_TABLE();
213 a18 := JTF_VARCHAR2_TABLE_100();
214 a19 := JTF_DATE_TABLE();
215 a20 := JTF_DATE_TABLE();
216 a21 := JTF_NUMBER_TABLE();
217 a22 := JTF_VARCHAR2_TABLE_200();
218 a23 := JTF_VARCHAR2_TABLE_100();
219 a24 := JTF_NUMBER_TABLE();
220 a25 := JTF_VARCHAR2_TABLE_100();
221 a26 := JTF_VARCHAR2_TABLE_100();
222 else
223 a0 := JTF_NUMBER_TABLE();
224 a1 := JTF_NUMBER_TABLE();
225 a2 := JTF_VARCHAR2_TABLE_100();
226 a3 := JTF_VARCHAR2_TABLE_100();
227 a4 := JTF_DATE_TABLE();
228 a5 := JTF_DATE_TABLE();
229 a6 := JTF_NUMBER_TABLE();
230 a7 := JTF_NUMBER_TABLE();
231 a8 := JTF_VARCHAR2_TABLE_300();
232 a9 := JTF_NUMBER_TABLE();
233 a10 := JTF_NUMBER_TABLE();
234 a11 := JTF_VARCHAR2_TABLE_100();
235 a12 := JTF_VARCHAR2_TABLE_100();
236 a13 := JTF_VARCHAR2_TABLE_100();
237 a14 := JTF_VARCHAR2_TABLE_100();
238 a15 := JTF_NUMBER_TABLE();
239 a16 := JTF_VARCHAR2_TABLE_100();
240 a17 := JTF_NUMBER_TABLE();
241 a18 := JTF_VARCHAR2_TABLE_100();
242 a19 := JTF_DATE_TABLE();
243 a20 := JTF_DATE_TABLE();
244 a21 := JTF_NUMBER_TABLE();
245 a22 := JTF_VARCHAR2_TABLE_200();
246 a23 := JTF_VARCHAR2_TABLE_100();
247 a24 := JTF_NUMBER_TABLE();
248 a25 := JTF_VARCHAR2_TABLE_100();
249 a26 := JTF_VARCHAR2_TABLE_100();
250 if t.count > 0 then
251 a0.extend(t.count);
252 a1.extend(t.count);
253 a2.extend(t.count);
254 a3.extend(t.count);
255 a4.extend(t.count);
256 a5.extend(t.count);
257 a6.extend(t.count);
258 a7.extend(t.count);
259 a8.extend(t.count);
260 a9.extend(t.count);
261 a10.extend(t.count);
262 a11.extend(t.count);
263 a12.extend(t.count);
264 a13.extend(t.count);
265 a14.extend(t.count);
266 a15.extend(t.count);
267 a16.extend(t.count);
268 a17.extend(t.count);
269 a18.extend(t.count);
270 a19.extend(t.count);
271 a20.extend(t.count);
272 a21.extend(t.count);
273 a22.extend(t.count);
274 a23.extend(t.count);
275 a24.extend(t.count);
276 a25.extend(t.count);
277 a26.extend(t.count);
278 ddindx := t.first;
279 indx := 1;
280 while true loop
281 a0(indx) := rosetta_g_miss_num_map(t(ddindx).terr_rsc_id);
282 a1(indx) := rosetta_g_miss_num_map(t(ddindx).resource_id);
283 a2(indx) := t(ddindx).resource_type;
284 a3(indx) := t(ddindx).role;
285 a4(indx) := t(ddindx).start_date;
286 a5(indx) := t(ddindx).end_date;
287 a6(indx) := rosetta_g_miss_num_map(t(ddindx).shift_construct_id);
288 a7(indx) := rosetta_g_miss_num_map(t(ddindx).terr_id);
289 a8(indx) := t(ddindx).terr_name;
290 a9(indx) := rosetta_g_miss_num_map(t(ddindx).terr_rank);
291 a10(indx) := rosetta_g_miss_num_map(t(ddindx).travel_time);
292 a11(indx) := t(ddindx).travel_uom;
293 a12(indx) := t(ddindx).preference_type;
294 a13(indx) := t(ddindx).primary_contact_flag;
295 a14(indx) := t(ddindx).full_access_flag;
296 a15(indx) := rosetta_g_miss_num_map(t(ddindx).group_id);
297 a16(indx) := t(ddindx).location;
298 a17(indx) := rosetta_g_miss_num_map(t(ddindx).trans_object_id);
299 a18(indx) := t(ddindx).resource_source;
300 a19(indx) := t(ddindx).source_start_date;
301 a20(indx) := t(ddindx).source_end_date;
302 a21(indx) := rosetta_g_miss_num_map(t(ddindx).support_site_id);
303 a22(indx) := t(ddindx).support_site_name;
304 a23(indx) := t(ddindx).web_availability_flag;
305 a24(indx) := rosetta_g_miss_num_map(t(ddindx).skill_level);
306 a25(indx) := t(ddindx).skill_name;
307 a26(indx) := t(ddindx).primary_flag;
308 indx := indx+1;
309 if t.last =ddindx
310 then exit;
311 end if;
312 ddindx := t.next(ddindx);
313 end loop;
314 end if;
315 end if;
316 end rosetta_table_copy_out_p11;
317
318 procedure rosetta_table_copy_in_p24(t out nocopy jtf_assign_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
319 , a1 JTF_VARCHAR2_TABLE_100
320 , a2 JTF_VARCHAR2_TABLE_100
321 , a3 JTF_VARCHAR2_TABLE_100
322 , a4 JTF_VARCHAR2_TABLE_100
323 ) as
324 ddindx binary_integer; indx binary_integer;
325 begin
326 if a0 is not null and a0.count > 0 then
327 if a0.count > 0 then
328 indx := a0.first;
329 ddindx := 1;
330 while true loop
331 t(ddindx).engineer_id := rosetta_g_miss_num_map(a0(indx));
332 t(ddindx).resource_type := a1(indx);
333 t(ddindx).primary_flag := a2(indx);
334 t(ddindx).preferred_flag := a3(indx);
335 t(ddindx).resource_class := a4(indx);
336 ddindx := ddindx+1;
337 if a0.last =indx
338 then exit;
339 end if;
340 indx := a0.next(indx);
341 end loop;
342 end if;
343 end if;
344 end rosetta_table_copy_in_p24;
345 procedure rosetta_table_copy_out_p24(t jtf_assign_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
346 , a1 out nocopy JTF_VARCHAR2_TABLE_100
347 , a2 out nocopy JTF_VARCHAR2_TABLE_100
348 , a3 out nocopy JTF_VARCHAR2_TABLE_100
349 , a4 out nocopy JTF_VARCHAR2_TABLE_100
350 ) as
351 ddindx binary_integer; indx binary_integer;
352 begin
353 if t is null or t.count = 0 then
354 a0 := JTF_NUMBER_TABLE();
355 a1 := JTF_VARCHAR2_TABLE_100();
356 a2 := JTF_VARCHAR2_TABLE_100();
357 a3 := JTF_VARCHAR2_TABLE_100();
358 a4 := JTF_VARCHAR2_TABLE_100();
359 else
360 a0 := JTF_NUMBER_TABLE();
361 a1 := JTF_VARCHAR2_TABLE_100();
362 a2 := JTF_VARCHAR2_TABLE_100();
363 a3 := JTF_VARCHAR2_TABLE_100();
364 a4 := JTF_VARCHAR2_TABLE_100();
365 if t.count > 0 then
366 a0.extend(t.count);
367 a1.extend(t.count);
368 a2.extend(t.count);
369 a3.extend(t.count);
370 a4.extend(t.count);
371 ddindx := t.first;
372 indx := 1;
373 while true loop
374 a0(indx) := rosetta_g_miss_num_map(t(ddindx).engineer_id);
375 a1(indx) := t(ddindx).resource_type;
376 a2(indx) := t(ddindx).primary_flag;
377 a3(indx) := t(ddindx).preferred_flag;
378 a4(indx) := t(ddindx).resource_class;
379 indx := indx+1;
380 if t.last =ddindx
381 then exit;
382 end if;
383 ddindx := t.next(ddindx);
387 end rosetta_table_copy_out_p24;
384 end loop;
385 end if;
386 end if;
388
389 procedure rosetta_table_copy_in_p26(t out nocopy jtf_assign_pub.preferred_engineers_tbl_type, a0 JTF_NUMBER_TABLE
390 , a1 JTF_VARCHAR2_TABLE_100
391 , a2 JTF_VARCHAR2_TABLE_100
392 , a3 JTF_VARCHAR2_TABLE_100
393 ) as
394 ddindx binary_integer; indx binary_integer;
395 begin
396 if a0 is not null and a0.count > 0 then
397 if a0.count > 0 then
398 indx := a0.first;
399 ddindx := 1;
400 while true loop
401 t(ddindx).engineer_id := rosetta_g_miss_num_map(a0(indx));
402 t(ddindx).resource_type := a1(indx);
403 t(ddindx).preference_type := a2(indx);
404 t(ddindx).primary_flag := a3(indx);
405 ddindx := ddindx+1;
406 if a0.last =indx
407 then exit;
408 end if;
409 indx := a0.next(indx);
410 end loop;
411 end if;
412 end if;
413 end rosetta_table_copy_in_p26;
414 procedure rosetta_table_copy_out_p26(t jtf_assign_pub.preferred_engineers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
415 , a1 out nocopy JTF_VARCHAR2_TABLE_100
416 , a2 out nocopy JTF_VARCHAR2_TABLE_100
417 , a3 out nocopy JTF_VARCHAR2_TABLE_100
418 ) as
419 ddindx binary_integer; indx binary_integer;
420 begin
421 if t is null or t.count = 0 then
422 a0 := JTF_NUMBER_TABLE();
423 a1 := JTF_VARCHAR2_TABLE_100();
424 a2 := JTF_VARCHAR2_TABLE_100();
425 a3 := JTF_VARCHAR2_TABLE_100();
426 else
427 a0 := JTF_NUMBER_TABLE();
428 a1 := JTF_VARCHAR2_TABLE_100();
429 a2 := JTF_VARCHAR2_TABLE_100();
430 a3 := JTF_VARCHAR2_TABLE_100();
431 if t.count > 0 then
432 a0.extend(t.count);
433 a1.extend(t.count);
434 a2.extend(t.count);
435 a3.extend(t.count);
436 ddindx := t.first;
437 indx := 1;
438 while true loop
439 a0(indx) := rosetta_g_miss_num_map(t(ddindx).engineer_id);
440 a1(indx) := t(ddindx).resource_type;
441 a2(indx) := t(ddindx).preference_type;
442 a3(indx) := t(ddindx).primary_flag;
443 indx := indx+1;
444 if t.last =ddindx
445 then exit;
446 end if;
447 ddindx := t.next(ddindx);
448 end loop;
449 end if;
450 end if;
451 end rosetta_table_copy_out_p26;
452
453 procedure rosetta_table_copy_in_p28(t out nocopy jtf_assign_pub.escalations_tbl_type, a0 JTF_NUMBER_TABLE
454 , a1 JTF_VARCHAR2_TABLE_100
455 ) as
456 ddindx binary_integer; indx binary_integer;
457 begin
458 if a0 is not null and a0.count > 0 then
459 if a0.count > 0 then
460 indx := a0.first;
461 ddindx := 1;
462 while true loop
463 t(ddindx).source_object_id := rosetta_g_miss_num_map(a0(indx));
464 t(ddindx).source_object_type := a1(indx);
465 ddindx := ddindx+1;
466 if a0.last =indx
467 then exit;
468 end if;
469 indx := a0.next(indx);
470 end loop;
471 end if;
472 end if;
473 end rosetta_table_copy_in_p28;
474 procedure rosetta_table_copy_out_p28(t jtf_assign_pub.escalations_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
475 , a1 out nocopy JTF_VARCHAR2_TABLE_100
476 ) as
477 ddindx binary_integer; indx binary_integer;
478 begin
479 if t is null or t.count = 0 then
480 a0 := JTF_NUMBER_TABLE();
481 a1 := JTF_VARCHAR2_TABLE_100();
482 else
483 a0 := JTF_NUMBER_TABLE();
484 a1 := JTF_VARCHAR2_TABLE_100();
485 if t.count > 0 then
486 a0.extend(t.count);
487 a1.extend(t.count);
488 ddindx := t.first;
489 indx := 1;
490 while true loop
491 a0(indx) := rosetta_g_miss_num_map(t(ddindx).source_object_id);
492 a1(indx) := t(ddindx).source_object_type;
493 indx := indx+1;
494 if t.last =ddindx
495 then exit;
496 end if;
497 ddindx := t.next(ddindx);
498 end loop;
499 end if;
500 end if;
501 end rosetta_table_copy_out_p28;
502
503 procedure rosetta_table_copy_in_p30(t out nocopy jtf_assign_pub.excluded_tbl_type, a0 JTF_NUMBER_TABLE
504 , a1 JTF_VARCHAR2_TABLE_100
505 ) as
506 ddindx binary_integer; indx binary_integer;
507 begin
508 if a0 is not null and a0.count > 0 then
509 if a0.count > 0 then
510 indx := a0.first;
511 ddindx := 1;
512 while true loop
513 t(ddindx).resource_id := rosetta_g_miss_num_map(a0(indx));
514 t(ddindx).resource_type := a1(indx);
515 ddindx := ddindx+1;
516 if a0.last =indx
517 then exit;
518 end if;
519 indx := a0.next(indx);
520 end loop;
521 end if;
522 end if;
523 end rosetta_table_copy_in_p30;
524 procedure rosetta_table_copy_out_p30(t jtf_assign_pub.excluded_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
528 begin
525 , a1 out nocopy JTF_VARCHAR2_TABLE_100
526 ) as
527 ddindx binary_integer; indx binary_integer;
529 if t is null or t.count = 0 then
530 a0 := JTF_NUMBER_TABLE();
531 a1 := JTF_VARCHAR2_TABLE_100();
532 else
533 a0 := JTF_NUMBER_TABLE();
534 a1 := JTF_VARCHAR2_TABLE_100();
535 if t.count > 0 then
536 a0.extend(t.count);
537 a1.extend(t.count);
538 ddindx := t.first;
539 indx := 1;
540 while true loop
541 a0(indx) := rosetta_g_miss_num_map(t(ddindx).resource_id);
542 a1(indx) := t(ddindx).resource_type;
543 indx := indx+1;
544 if t.last =ddindx
545 then exit;
546 end if;
547 ddindx := t.next(ddindx);
548 end loop;
549 end if;
550 end if;
551 end rosetta_table_copy_out_p30;
552
553 procedure get_assign_resources(p_api_version NUMBER
554 , p_init_msg_list VARCHAR2
555 , p_commit VARCHAR2
556 , p_resource_id NUMBER
557 , p_resource_type VARCHAR2
558 , p_role VARCHAR2
559 , p_no_of_resources NUMBER
560 , p_auto_select_flag VARCHAR2
561 , p_contracts_preferred_engineer VARCHAR2
562 , p_ib_preferred_engineer VARCHAR2
563 , p_contract_id NUMBER
564 , p_customer_product_id NUMBER
565 , p_effort_duration NUMBER
566 , p_effort_uom VARCHAR2
567 , p_start_date date
568 , p_end_date date
569 , p_territory_flag VARCHAR2
570 , p_calendar_flag VARCHAR2
571 , p_web_availability_flag VARCHAR2
572 , p_category_id NUMBER
573 , p_inventory_item_id NUMBER
574 , p_inventory_org_id NUMBER
575 , p_problem_code VARCHAR2
576 , p_calling_doc_id NUMBER
577 , p_calling_doc_type VARCHAR2
578 , p_column_list VARCHAR2
579 , p_business_process_id NUMBER
580 , p_business_process_date date
581 , p_filter_excluded_resource VARCHAR2
582 , p32_a0 out nocopy JTF_NUMBER_TABLE
583 , p32_a1 out nocopy JTF_NUMBER_TABLE
584 , p32_a2 out nocopy JTF_VARCHAR2_TABLE_100
585 , p32_a3 out nocopy JTF_VARCHAR2_TABLE_100
586 , p32_a4 out nocopy JTF_DATE_TABLE
587 , p32_a5 out nocopy JTF_DATE_TABLE
588 , p32_a6 out nocopy JTF_NUMBER_TABLE
589 , p32_a7 out nocopy JTF_NUMBER_TABLE
590 , p32_a8 out nocopy JTF_VARCHAR2_TABLE_300
591 , p32_a9 out nocopy JTF_NUMBER_TABLE
592 , p32_a10 out nocopy JTF_NUMBER_TABLE
593 , p32_a11 out nocopy JTF_VARCHAR2_TABLE_100
594 , p32_a12 out nocopy JTF_VARCHAR2_TABLE_100
595 , p32_a13 out nocopy JTF_VARCHAR2_TABLE_100
596 , p32_a14 out nocopy JTF_VARCHAR2_TABLE_100
597 , p32_a15 out nocopy JTF_NUMBER_TABLE
598 , p32_a16 out nocopy JTF_VARCHAR2_TABLE_100
599 , p32_a17 out nocopy JTF_NUMBER_TABLE
600 , p32_a18 out nocopy JTF_VARCHAR2_TABLE_100
601 , p32_a19 out nocopy JTF_DATE_TABLE
602 , p32_a20 out nocopy JTF_DATE_TABLE
603 , p32_a21 out nocopy JTF_NUMBER_TABLE
604 , p32_a22 out nocopy JTF_VARCHAR2_TABLE_200
605 , p32_a23 out nocopy JTF_VARCHAR2_TABLE_100
606 , p32_a24 out nocopy JTF_NUMBER_TABLE
607 , p32_a25 out nocopy JTF_VARCHAR2_TABLE_100
608 , p32_a26 out nocopy JTF_VARCHAR2_TABLE_100
609 , x_return_status out nocopy VARCHAR2
610 , x_msg_count out nocopy NUMBER
611 , x_msg_data out nocopy VARCHAR2
612 , p26_a0 NUMBER := 0-1962.0724
613 , p26_a1 NUMBER := 0-1962.0724
614 , p26_a2 VARCHAR2 := fnd_api.g_miss_char
615 , p26_a3 NUMBER := 0-1962.0724
616 , p26_a4 VARCHAR2 := fnd_api.g_miss_char
617 , p26_a5 VARCHAR2 := fnd_api.g_miss_char
618 , p26_a6 VARCHAR2 := fnd_api.g_miss_char
619 , p26_a7 VARCHAR2 := fnd_api.g_miss_char
620 , p26_a8 VARCHAR2 := fnd_api.g_miss_char
621 , p26_a9 VARCHAR2 := fnd_api.g_miss_char
622 , p26_a10 VARCHAR2 := fnd_api.g_miss_char
623 , p26_a11 NUMBER := 0-1962.0724
624 , p26_a12 NUMBER := 0-1962.0724
625 , p26_a13 NUMBER := 0-1962.0724
626 , p26_a14 NUMBER := 0-1962.0724
627 , p26_a15 VARCHAR2 := fnd_api.g_miss_char
628 , p26_a16 NUMBER := 0-1962.0724
629 , p26_a17 NUMBER := 0-1962.0724
630 , p26_a18 NUMBER := 0-1962.0724
631 , p26_a19 NUMBER := 0-1962.0724
632 , p26_a20 VARCHAR2 := fnd_api.g_miss_char
633 , p26_a21 NUMBER := 0-1962.0724
634 , p26_a22 VARCHAR2 := fnd_api.g_miss_char
635 , p26_a23 VARCHAR2 := fnd_api.g_miss_char
636 , p26_a24 VARCHAR2 := fnd_api.g_miss_char
637 , p26_a25 VARCHAR2 := fnd_api.g_miss_char
638 , p26_a26 VARCHAR2 := fnd_api.g_miss_char
639 , p26_a27 VARCHAR2 := fnd_api.g_miss_char
640 , p26_a28 VARCHAR2 := fnd_api.g_miss_char
641 , p26_a29 VARCHAR2 := fnd_api.g_miss_char
642 , p26_a30 VARCHAR2 := fnd_api.g_miss_char
643 , p26_a31 VARCHAR2 := fnd_api.g_miss_char
644 , p26_a32 VARCHAR2 := fnd_api.g_miss_char
645 , p26_a33 VARCHAR2 := fnd_api.g_miss_char
646 , p26_a34 VARCHAR2 := fnd_api.g_miss_char
647 , p26_a35 VARCHAR2 := fnd_api.g_miss_char
648 , p26_a36 VARCHAR2 := fnd_api.g_miss_char
652 , p26_a40 NUMBER := 0-1962.0724
649 , p26_a37 NUMBER := 0-1962.0724
650 , p26_a38 NUMBER := 0-1962.0724
651 , p26_a39 NUMBER := 0-1962.0724
653 , p26_a41 NUMBER := 0-1962.0724
654 , p26_a42 NUMBER := 0-1962.0724
655 , p26_a43 NUMBER := 0-1962.0724
656 , p26_a44 NUMBER := 0-1962.0724
657 , p26_a45 NUMBER := 0-1962.0724
658 , p26_a46 NUMBER := 0-1962.0724
659 , p26_a47 VARCHAR2 := fnd_api.g_miss_char
660 , p26_a48 VARCHAR2 := fnd_api.g_miss_char
661 , p26_a49 VARCHAR2 := fnd_api.g_miss_char
662 , p26_a50 VARCHAR2 := fnd_api.g_miss_char
663 , p26_a51 VARCHAR2 := fnd_api.g_miss_char
664 , p26_a52 NUMBER := 0-1962.0724
665 , p26_a53 NUMBER := 0-1962.0724
666 , p27_a0 NUMBER := 0-1962.0724
667 , p27_a1 NUMBER := 0-1962.0724
668 , p27_a2 NUMBER := 0-1962.0724
669 , p27_a3 VARCHAR2 := fnd_api.g_miss_char
670 , p27_a4 NUMBER := 0-1962.0724
671 , p27_a5 VARCHAR2 := fnd_api.g_miss_char
672 , p27_a6 VARCHAR2 := fnd_api.g_miss_char
673 , p27_a7 VARCHAR2 := fnd_api.g_miss_char
674 , p27_a8 VARCHAR2 := fnd_api.g_miss_char
675 , p27_a9 VARCHAR2 := fnd_api.g_miss_char
676 , p27_a10 VARCHAR2 := fnd_api.g_miss_char
677 , p27_a11 VARCHAR2 := fnd_api.g_miss_char
678 , p27_a12 NUMBER := 0-1962.0724
679 , p27_a13 NUMBER := 0-1962.0724
680 , p27_a14 NUMBER := 0-1962.0724
681 , p27_a15 NUMBER := 0-1962.0724
682 , p27_a16 NUMBER := 0-1962.0724
683 , p27_a17 NUMBER := 0-1962.0724
684 , p27_a18 NUMBER := 0-1962.0724
685 , p27_a19 VARCHAR2 := fnd_api.g_miss_char
686 , p27_a20 NUMBER := 0-1962.0724
687 , p27_a21 NUMBER := 0-1962.0724
688 , p27_a22 NUMBER := 0-1962.0724
689 , p27_a23 NUMBER := 0-1962.0724
690 , p27_a24 VARCHAR2 := fnd_api.g_miss_char
691 , p27_a25 NUMBER := 0-1962.0724
692 , p27_a26 VARCHAR2 := fnd_api.g_miss_char
693 , p27_a27 VARCHAR2 := fnd_api.g_miss_char
694 , p27_a28 VARCHAR2 := fnd_api.g_miss_char
695 , p27_a29 VARCHAR2 := fnd_api.g_miss_char
696 , p27_a30 VARCHAR2 := fnd_api.g_miss_char
697 , p27_a31 VARCHAR2 := fnd_api.g_miss_char
698 , p27_a32 VARCHAR2 := fnd_api.g_miss_char
699 , p27_a33 VARCHAR2 := fnd_api.g_miss_char
700 , p27_a34 VARCHAR2 := fnd_api.g_miss_char
701 , p27_a35 VARCHAR2 := fnd_api.g_miss_char
702 , p27_a36 VARCHAR2 := fnd_api.g_miss_char
703 , p27_a37 VARCHAR2 := fnd_api.g_miss_char
704 , p27_a38 VARCHAR2 := fnd_api.g_miss_char
705 , p27_a39 VARCHAR2 := fnd_api.g_miss_char
706 , p27_a40 VARCHAR2 := fnd_api.g_miss_char
707 , p27_a41 NUMBER := 0-1962.0724
708 , p27_a42 NUMBER := 0-1962.0724
709 , p27_a43 NUMBER := 0-1962.0724
710 , p27_a44 NUMBER := 0-1962.0724
711 , p27_a45 NUMBER := 0-1962.0724
712 , p27_a46 NUMBER := 0-1962.0724
713 , p27_a47 NUMBER := 0-1962.0724
714 , p27_a48 NUMBER := 0-1962.0724
715 , p27_a49 NUMBER := 0-1962.0724
716 , p27_a50 NUMBER := 0-1962.0724
717 , p27_a51 VARCHAR2 := fnd_api.g_miss_char
718 , p27_a52 VARCHAR2 := fnd_api.g_miss_char
719 , p27_a53 VARCHAR2 := fnd_api.g_miss_char
720 , p27_a54 VARCHAR2 := fnd_api.g_miss_char
721 , p27_a55 VARCHAR2 := fnd_api.g_miss_char
722 , p27_a56 NUMBER := 0-1962.0724
723 , p27_a57 NUMBER := 0-1962.0724
724 , p28_a0 VARCHAR2 := fnd_api.g_miss_char
725 , p28_a1 VARCHAR2 := fnd_api.g_miss_char
726 , p28_a2 VARCHAR2 := fnd_api.g_miss_char
727 , p28_a3 VARCHAR2 := fnd_api.g_miss_char
728 , p28_a4 VARCHAR2 := fnd_api.g_miss_char
729 , p28_a5 VARCHAR2 := fnd_api.g_miss_char
730 , p28_a6 VARCHAR2 := fnd_api.g_miss_char
731 , p28_a7 VARCHAR2 := fnd_api.g_miss_char
732 , p28_a8 VARCHAR2 := fnd_api.g_miss_char
733 , p28_a9 VARCHAR2 := fnd_api.g_miss_char
734 , p28_a10 VARCHAR2 := fnd_api.g_miss_char
735 , p28_a11 VARCHAR2 := fnd_api.g_miss_char
736 , p28_a12 VARCHAR2 := fnd_api.g_miss_char
737 , p28_a13 VARCHAR2 := fnd_api.g_miss_char
738 , p28_a14 VARCHAR2 := fnd_api.g_miss_char
739 , p28_a15 VARCHAR2 := fnd_api.g_miss_char
740 , p28_a16 VARCHAR2 := fnd_api.g_miss_char
741 , p28_a17 VARCHAR2 := fnd_api.g_miss_char
742 , p28_a18 VARCHAR2 := fnd_api.g_miss_char
743 , p28_a19 VARCHAR2 := fnd_api.g_miss_char
744 , p28_a20 VARCHAR2 := fnd_api.g_miss_char
745 , p28_a21 VARCHAR2 := fnd_api.g_miss_char
746 , p28_a22 VARCHAR2 := fnd_api.g_miss_char
747 , p28_a23 VARCHAR2 := fnd_api.g_miss_char
748 , p28_a24 VARCHAR2 := fnd_api.g_miss_char
749 , p28_a25 NUMBER := 0-1962.0724
750 , p28_a26 NUMBER := 0-1962.0724
751 , p28_a27 NUMBER := 0-1962.0724
752 , p28_a28 NUMBER := 0-1962.0724
753 , p28_a29 NUMBER := 0-1962.0724
754 , p28_a30 NUMBER := 0-1962.0724
755 , p28_a31 NUMBER := 0-1962.0724
756 , p28_a32 NUMBER := 0-1962.0724
757 , p28_a33 NUMBER := 0-1962.0724
758 , p28_a34 NUMBER := 0-1962.0724
759 , p28_a35 NUMBER := 0-1962.0724
760 , p28_a36 NUMBER := 0-1962.0724
764 , p28_a40 NUMBER := 0-1962.0724
761 , p28_a37 NUMBER := 0-1962.0724
762 , p28_a38 NUMBER := 0-1962.0724
763 , p28_a39 NUMBER := 0-1962.0724
765 , p28_a41 NUMBER := 0-1962.0724
766 , p28_a42 NUMBER := 0-1962.0724
767 , p28_a43 NUMBER := 0-1962.0724
768 , p28_a44 NUMBER := 0-1962.0724
769 , p28_a45 NUMBER := 0-1962.0724
770 , p28_a46 NUMBER := 0-1962.0724
771 , p28_a47 NUMBER := 0-1962.0724
772 , p28_a48 NUMBER := 0-1962.0724
773 , p28_a49 NUMBER := 0-1962.0724
774 , p28_a50 VARCHAR2 := fnd_api.g_miss_char
775 , p28_a51 VARCHAR2 := fnd_api.g_miss_char
776 , p28_a52 VARCHAR2 := fnd_api.g_miss_char
777 , p28_a53 VARCHAR2 := fnd_api.g_miss_char
778 , p28_a54 VARCHAR2 := fnd_api.g_miss_char
779 , p28_a55 VARCHAR2 := fnd_api.g_miss_char
780 , p28_a56 VARCHAR2 := fnd_api.g_miss_char
781 , p28_a57 VARCHAR2 := fnd_api.g_miss_char
782 , p28_a58 VARCHAR2 := fnd_api.g_miss_char
783 , p28_a59 VARCHAR2 := fnd_api.g_miss_char
784 , p28_a60 VARCHAR2 := fnd_api.g_miss_char
785 , p28_a61 VARCHAR2 := fnd_api.g_miss_char
786 , p28_a62 VARCHAR2 := fnd_api.g_miss_char
787 , p28_a63 VARCHAR2 := fnd_api.g_miss_char
788 , p28_a64 VARCHAR2 := fnd_api.g_miss_char
789 )
790
791 as
792 ddp_start_date date;
793 ddp_end_date date;
794 ddp_sr_rec jtf_assign_pub.jtf_serv_req_rec_type;
795 ddp_sr_task_rec jtf_assign_pub.jtf_srv_task_rec_type;
796 ddp_defect_rec jtf_assign_pub.jtf_def_mgmt_rec_type;
797 ddp_business_process_date date;
798 ddx_assign_resources_tbl jtf_assign_pub.assignresources_tbl_type;
799 ddindx binary_integer; indx binary_integer;
800 begin
801
802 -- copy data to the local IN or IN-OUT args, if any
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817 ddp_start_date := rosetta_g_miss_date_in_map(p_start_date);
818
819 ddp_end_date := rosetta_g_miss_date_in_map(p_end_date);
820
821
822
823
824
825
826
827
828
829
830
831 ddp_sr_rec.service_request_id := rosetta_g_miss_num_map(p26_a0);
832 ddp_sr_rec.party_id := rosetta_g_miss_num_map(p26_a1);
833 ddp_sr_rec.country := p26_a2;
834 ddp_sr_rec.party_site_id := rosetta_g_miss_num_map(p26_a3);
835 ddp_sr_rec.city := p26_a4;
836 ddp_sr_rec.postal_code := p26_a5;
837 ddp_sr_rec.state := p26_a6;
838 ddp_sr_rec.area_code := p26_a7;
839 ddp_sr_rec.county := p26_a8;
840 ddp_sr_rec.comp_name_range := p26_a9;
841 ddp_sr_rec.province := p26_a10;
842 ddp_sr_rec.num_of_employees := rosetta_g_miss_num_map(p26_a11);
843 ddp_sr_rec.incident_type_id := rosetta_g_miss_num_map(p26_a12);
844 ddp_sr_rec.incident_severity_id := rosetta_g_miss_num_map(p26_a13);
845 ddp_sr_rec.incident_urgency_id := rosetta_g_miss_num_map(p26_a14);
846 ddp_sr_rec.problem_code := p26_a15;
847 ddp_sr_rec.incident_status_id := rosetta_g_miss_num_map(p26_a16);
848 ddp_sr_rec.platform_id := rosetta_g_miss_num_map(p26_a17);
849 ddp_sr_rec.support_site_id := rosetta_g_miss_num_map(p26_a18);
850 ddp_sr_rec.customer_site_id := rosetta_g_miss_num_map(p26_a19);
851 ddp_sr_rec.sr_creation_channel := p26_a20;
852 ddp_sr_rec.inventory_item_id := rosetta_g_miss_num_map(p26_a21);
853 ddp_sr_rec.attribute1 := p26_a22;
854 ddp_sr_rec.attribute2 := p26_a23;
855 ddp_sr_rec.attribute3 := p26_a24;
856 ddp_sr_rec.attribute4 := p26_a25;
857 ddp_sr_rec.attribute5 := p26_a26;
858 ddp_sr_rec.attribute6 := p26_a27;
859 ddp_sr_rec.attribute7 := p26_a28;
860 ddp_sr_rec.attribute8 := p26_a29;
861 ddp_sr_rec.attribute9 := p26_a30;
862 ddp_sr_rec.attribute10 := p26_a31;
863 ddp_sr_rec.attribute11 := p26_a32;
864 ddp_sr_rec.attribute12 := p26_a33;
865 ddp_sr_rec.attribute13 := p26_a34;
866 ddp_sr_rec.attribute14 := p26_a35;
867 ddp_sr_rec.attribute15 := p26_a36;
868 ddp_sr_rec.organization_id := rosetta_g_miss_num_map(p26_a37);
869 ddp_sr_rec.squal_num12 := rosetta_g_miss_num_map(p26_a38);
870 ddp_sr_rec.squal_num13 := rosetta_g_miss_num_map(p26_a39);
871 ddp_sr_rec.squal_num14 := rosetta_g_miss_num_map(p26_a40);
872 ddp_sr_rec.squal_num15 := rosetta_g_miss_num_map(p26_a41);
873 ddp_sr_rec.squal_num16 := rosetta_g_miss_num_map(p26_a42);
874 ddp_sr_rec.squal_num17 := rosetta_g_miss_num_map(p26_a43);
875 ddp_sr_rec.squal_num18 := rosetta_g_miss_num_map(p26_a44);
876 ddp_sr_rec.squal_num19 := rosetta_g_miss_num_map(p26_a45);
877 ddp_sr_rec.squal_num30 := rosetta_g_miss_num_map(p26_a46);
878 ddp_sr_rec.squal_char11 := p26_a47;
879 ddp_sr_rec.squal_char12 := p26_a48;
880 ddp_sr_rec.squal_char13 := p26_a49;
881 ddp_sr_rec.squal_char20 := p26_a50;
882 ddp_sr_rec.squal_char21 := p26_a51;
883 ddp_sr_rec.item_component := rosetta_g_miss_num_map(p26_a52);
884 ddp_sr_rec.item_subcomponent := rosetta_g_miss_num_map(p26_a53);
885
886 ddp_sr_task_rec.task_id := rosetta_g_miss_num_map(p27_a0);
887 ddp_sr_task_rec.service_request_id := rosetta_g_miss_num_map(p27_a1);
888 ddp_sr_task_rec.party_id := rosetta_g_miss_num_map(p27_a2);
889 ddp_sr_task_rec.country := p27_a3;
890 ddp_sr_task_rec.party_site_id := rosetta_g_miss_num_map(p27_a4);
894 ddp_sr_task_rec.area_code := p27_a8;
891 ddp_sr_task_rec.city := p27_a5;
892 ddp_sr_task_rec.postal_code := p27_a6;
893 ddp_sr_task_rec.state := p27_a7;
895 ddp_sr_task_rec.county := p27_a9;
896 ddp_sr_task_rec.comp_name_range := p27_a10;
897 ddp_sr_task_rec.province := p27_a11;
898 ddp_sr_task_rec.num_of_employees := rosetta_g_miss_num_map(p27_a12);
899 ddp_sr_task_rec.task_type_id := rosetta_g_miss_num_map(p27_a13);
900 ddp_sr_task_rec.task_status_id := rosetta_g_miss_num_map(p27_a14);
901 ddp_sr_task_rec.task_priority_id := rosetta_g_miss_num_map(p27_a15);
902 ddp_sr_task_rec.incident_type_id := rosetta_g_miss_num_map(p27_a16);
903 ddp_sr_task_rec.incident_severity_id := rosetta_g_miss_num_map(p27_a17);
904 ddp_sr_task_rec.incident_urgency_id := rosetta_g_miss_num_map(p27_a18);
905 ddp_sr_task_rec.problem_code := p27_a19;
906 ddp_sr_task_rec.incident_status_id := rosetta_g_miss_num_map(p27_a20);
907 ddp_sr_task_rec.platform_id := rosetta_g_miss_num_map(p27_a21);
908 ddp_sr_task_rec.support_site_id := rosetta_g_miss_num_map(p27_a22);
909 ddp_sr_task_rec.customer_site_id := rosetta_g_miss_num_map(p27_a23);
910 ddp_sr_task_rec.sr_creation_channel := p27_a24;
911 ddp_sr_task_rec.inventory_item_id := rosetta_g_miss_num_map(p27_a25);
912 ddp_sr_task_rec.attribute1 := p27_a26;
913 ddp_sr_task_rec.attribute2 := p27_a27;
914 ddp_sr_task_rec.attribute3 := p27_a28;
915 ddp_sr_task_rec.attribute4 := p27_a29;
916 ddp_sr_task_rec.attribute5 := p27_a30;
917 ddp_sr_task_rec.attribute6 := p27_a31;
918 ddp_sr_task_rec.attribute7 := p27_a32;
919 ddp_sr_task_rec.attribute8 := p27_a33;
920 ddp_sr_task_rec.attribute9 := p27_a34;
921 ddp_sr_task_rec.attribute10 := p27_a35;
922 ddp_sr_task_rec.attribute11 := p27_a36;
923 ddp_sr_task_rec.attribute12 := p27_a37;
924 ddp_sr_task_rec.attribute13 := p27_a38;
925 ddp_sr_task_rec.attribute14 := p27_a39;
926 ddp_sr_task_rec.attribute15 := p27_a40;
927 ddp_sr_task_rec.organization_id := rosetta_g_miss_num_map(p27_a41);
928 ddp_sr_task_rec.squal_num12 := rosetta_g_miss_num_map(p27_a42);
929 ddp_sr_task_rec.squal_num13 := rosetta_g_miss_num_map(p27_a43);
930 ddp_sr_task_rec.squal_num14 := rosetta_g_miss_num_map(p27_a44);
931 ddp_sr_task_rec.squal_num15 := rosetta_g_miss_num_map(p27_a45);
932 ddp_sr_task_rec.squal_num16 := rosetta_g_miss_num_map(p27_a46);
933 ddp_sr_task_rec.squal_num17 := rosetta_g_miss_num_map(p27_a47);
934 ddp_sr_task_rec.squal_num18 := rosetta_g_miss_num_map(p27_a48);
935 ddp_sr_task_rec.squal_num19 := rosetta_g_miss_num_map(p27_a49);
936 ddp_sr_task_rec.squal_num30 := rosetta_g_miss_num_map(p27_a50);
937 ddp_sr_task_rec.squal_char11 := p27_a51;
938 ddp_sr_task_rec.squal_char12 := p27_a52;
939 ddp_sr_task_rec.squal_char13 := p27_a53;
940 ddp_sr_task_rec.squal_char20 := p27_a54;
941 ddp_sr_task_rec.squal_char21 := p27_a55;
942 ddp_sr_task_rec.item_component := rosetta_g_miss_num_map(p27_a56);
943 ddp_sr_task_rec.item_subcomponent := rosetta_g_miss_num_map(p27_a57);
944
945 ddp_defect_rec.squal_char01 := p28_a0;
946 ddp_defect_rec.squal_char02 := p28_a1;
947 ddp_defect_rec.squal_char03 := p28_a2;
948 ddp_defect_rec.squal_char04 := p28_a3;
949 ddp_defect_rec.squal_char05 := p28_a4;
950 ddp_defect_rec.squal_char06 := p28_a5;
951 ddp_defect_rec.squal_char07 := p28_a6;
952 ddp_defect_rec.squal_char08 := p28_a7;
953 ddp_defect_rec.squal_char09 := p28_a8;
954 ddp_defect_rec.squal_char10 := p28_a9;
955 ddp_defect_rec.squal_char11 := p28_a10;
956 ddp_defect_rec.squal_char12 := p28_a11;
957 ddp_defect_rec.squal_char13 := p28_a12;
958 ddp_defect_rec.squal_char14 := p28_a13;
959 ddp_defect_rec.squal_char15 := p28_a14;
960 ddp_defect_rec.squal_char16 := p28_a15;
961 ddp_defect_rec.squal_char17 := p28_a16;
962 ddp_defect_rec.squal_char18 := p28_a17;
963 ddp_defect_rec.squal_char19 := p28_a18;
964 ddp_defect_rec.squal_char20 := p28_a19;
965 ddp_defect_rec.squal_char21 := p28_a20;
966 ddp_defect_rec.squal_char22 := p28_a21;
967 ddp_defect_rec.squal_char23 := p28_a22;
968 ddp_defect_rec.squal_char24 := p28_a23;
969 ddp_defect_rec.squal_char25 := p28_a24;
970 ddp_defect_rec.squal_num01 := rosetta_g_miss_num_map(p28_a25);
971 ddp_defect_rec.squal_num02 := rosetta_g_miss_num_map(p28_a26);
972 ddp_defect_rec.squal_num03 := rosetta_g_miss_num_map(p28_a27);
973 ddp_defect_rec.squal_num04 := rosetta_g_miss_num_map(p28_a28);
974 ddp_defect_rec.squal_num05 := rosetta_g_miss_num_map(p28_a29);
975 ddp_defect_rec.squal_num06 := rosetta_g_miss_num_map(p28_a30);
976 ddp_defect_rec.squal_num07 := rosetta_g_miss_num_map(p28_a31);
977 ddp_defect_rec.squal_num08 := rosetta_g_miss_num_map(p28_a32);
978 ddp_defect_rec.squal_num09 := rosetta_g_miss_num_map(p28_a33);
979 ddp_defect_rec.squal_num10 := rosetta_g_miss_num_map(p28_a34);
980 ddp_defect_rec.squal_num11 := rosetta_g_miss_num_map(p28_a35);
981 ddp_defect_rec.squal_num12 := rosetta_g_miss_num_map(p28_a36);
982 ddp_defect_rec.squal_num13 := rosetta_g_miss_num_map(p28_a37);
983 ddp_defect_rec.squal_num14 := rosetta_g_miss_num_map(p28_a38);
987 ddp_defect_rec.squal_num18 := rosetta_g_miss_num_map(p28_a42);
984 ddp_defect_rec.squal_num15 := rosetta_g_miss_num_map(p28_a39);
985 ddp_defect_rec.squal_num16 := rosetta_g_miss_num_map(p28_a40);
986 ddp_defect_rec.squal_num17 := rosetta_g_miss_num_map(p28_a41);
988 ddp_defect_rec.squal_num19 := rosetta_g_miss_num_map(p28_a43);
989 ddp_defect_rec.squal_num20 := rosetta_g_miss_num_map(p28_a44);
990 ddp_defect_rec.squal_num21 := rosetta_g_miss_num_map(p28_a45);
991 ddp_defect_rec.squal_num22 := rosetta_g_miss_num_map(p28_a46);
992 ddp_defect_rec.squal_num23 := rosetta_g_miss_num_map(p28_a47);
993 ddp_defect_rec.squal_num24 := rosetta_g_miss_num_map(p28_a48);
994 ddp_defect_rec.squal_num25 := rosetta_g_miss_num_map(p28_a49);
995 ddp_defect_rec.attribute1 := p28_a50;
996 ddp_defect_rec.attribute2 := p28_a51;
997 ddp_defect_rec.attribute3 := p28_a52;
998 ddp_defect_rec.attribute4 := p28_a53;
999 ddp_defect_rec.attribute5 := p28_a54;
1000 ddp_defect_rec.attribute6 := p28_a55;
1001 ddp_defect_rec.attribute7 := p28_a56;
1002 ddp_defect_rec.attribute8 := p28_a57;
1003 ddp_defect_rec.attribute9 := p28_a58;
1004 ddp_defect_rec.attribute10 := p28_a59;
1005 ddp_defect_rec.attribute11 := p28_a60;
1006 ddp_defect_rec.attribute12 := p28_a61;
1007 ddp_defect_rec.attribute13 := p28_a62;
1008 ddp_defect_rec.attribute14 := p28_a63;
1009 ddp_defect_rec.attribute15 := p28_a64;
1010
1011
1012 ddp_business_process_date := rosetta_g_miss_date_in_map(p_business_process_date);
1013
1014
1015
1016
1017
1018
1019 -- here's the delegated call to the old PL/SQL routine
1020 jtf_assign_pub.get_assign_resources(p_api_version,
1021 p_init_msg_list,
1022 p_commit,
1023 p_resource_id,
1024 p_resource_type,
1025 p_role,
1026 p_no_of_resources,
1027 p_auto_select_flag,
1028 p_contracts_preferred_engineer,
1029 p_ib_preferred_engineer,
1030 p_contract_id,
1031 p_customer_product_id,
1032 p_effort_duration,
1033 p_effort_uom,
1034 ddp_start_date,
1035 ddp_end_date,
1036 p_territory_flag,
1037 p_calendar_flag,
1038 p_web_availability_flag,
1039 p_category_id,
1040 p_inventory_item_id,
1041 p_inventory_org_id,
1042 p_problem_code,
1043 p_calling_doc_id,
1044 p_calling_doc_type,
1045 p_column_list,
1046 ddp_sr_rec,
1047 ddp_sr_task_rec,
1048 ddp_defect_rec,
1049 p_business_process_id,
1050 ddp_business_process_date,
1051 p_filter_excluded_resource,
1052 ddx_assign_resources_tbl,
1053 x_return_status,
1054 x_msg_count,
1055 x_msg_data);
1056
1057 -- copy data back from the local variables to OUT or IN-OUT args, if any
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090 jtf_assign_pub_w.rosetta_table_copy_out_p11(ddx_assign_resources_tbl, p32_a0
1091 , p32_a1
1092 , p32_a2
1093 , p32_a3
1094 , p32_a4
1095 , p32_a5
1096 , p32_a6
1097 , p32_a7
1098 , p32_a8
1099 , p32_a9
1100 , p32_a10
1101 , p32_a11
1102 , p32_a12
1103 , p32_a13
1104 , p32_a14
1105 , p32_a15
1106 , p32_a16
1107 , p32_a17
1108 , p32_a18
1109 , p32_a19
1110 , p32_a20
1111 , p32_a21
1112 , p32_a22
1113 , p32_a23
1114 , p32_a24
1115 , p32_a25
1116 , p32_a26
1117 );
1118
1119
1120
1121 end;
1122
1123 procedure get_assign_task_resources(p_api_version NUMBER
1124 , p_init_msg_list VARCHAR2
1125 , p_resource_type VARCHAR2
1126 , p_role VARCHAR2
1127 , p_no_of_resources NUMBER
1128 , p_auto_select_flag VARCHAR2
1129 , p_contracts_preferred_engineer VARCHAR2
1130 , p_ib_preferred_engineer VARCHAR2
1131 , p_effort_duration NUMBER
1132 , p_effort_uom VARCHAR2
1133 , p_start_date date
1134 , p_end_date date
1135 , p_territory_flag VARCHAR2
1136 , p_calendar_flag VARCHAR2
1137 , p_web_availability_flag VARCHAR2
1138 , p_task_id NUMBER
1139 , p_column_list VARCHAR2
1140 , p_business_process_id NUMBER
1141 , p_business_process_date date
1142 , p_filter_excluded_resource VARCHAR2
1143 , p20_a0 out nocopy JTF_NUMBER_TABLE
1144 , p20_a1 out nocopy JTF_NUMBER_TABLE
1145 , p20_a2 out nocopy JTF_VARCHAR2_TABLE_100
1146 , p20_a3 out nocopy JTF_VARCHAR2_TABLE_100
1147 , p20_a4 out nocopy JTF_DATE_TABLE
1148 , p20_a5 out nocopy JTF_DATE_TABLE
1149 , p20_a6 out nocopy JTF_NUMBER_TABLE
1150 , p20_a7 out nocopy JTF_NUMBER_TABLE
1151 , p20_a8 out nocopy JTF_VARCHAR2_TABLE_300
1152 , p20_a9 out nocopy JTF_NUMBER_TABLE
1156 , p20_a13 out nocopy JTF_VARCHAR2_TABLE_100
1153 , p20_a10 out nocopy JTF_NUMBER_TABLE
1154 , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100
1155 , p20_a12 out nocopy JTF_VARCHAR2_TABLE_100
1157 , p20_a14 out nocopy JTF_VARCHAR2_TABLE_100
1158 , p20_a15 out nocopy JTF_NUMBER_TABLE
1159 , p20_a16 out nocopy JTF_VARCHAR2_TABLE_100
1160 , p20_a17 out nocopy JTF_NUMBER_TABLE
1161 , p20_a18 out nocopy JTF_VARCHAR2_TABLE_100
1162 , p20_a19 out nocopy JTF_DATE_TABLE
1163 , p20_a20 out nocopy JTF_DATE_TABLE
1164 , p20_a21 out nocopy JTF_NUMBER_TABLE
1165 , p20_a22 out nocopy JTF_VARCHAR2_TABLE_200
1166 , p20_a23 out nocopy JTF_VARCHAR2_TABLE_100
1167 , p20_a24 out nocopy JTF_NUMBER_TABLE
1168 , p20_a25 out nocopy JTF_VARCHAR2_TABLE_100
1169 , p20_a26 out nocopy JTF_VARCHAR2_TABLE_100
1170 , x_return_status out nocopy VARCHAR2
1171 , x_msg_count out nocopy NUMBER
1172 , x_msg_data out nocopy VARCHAR2
1173 )
1174
1175 as
1176 ddp_start_date date;
1177 ddp_end_date date;
1178 ddp_business_process_date date;
1179 ddx_assign_resources_tbl jtf_assign_pub.assignresources_tbl_type;
1180 ddindx binary_integer; indx binary_integer;
1181 begin
1182
1183 -- copy data to the local IN or IN-OUT args, if any
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194 ddp_start_date := rosetta_g_miss_date_in_map(p_start_date);
1195
1196 ddp_end_date := rosetta_g_miss_date_in_map(p_end_date);
1197
1198
1199
1200
1201
1202
1203
1204 ddp_business_process_date := rosetta_g_miss_date_in_map(p_business_process_date);
1205
1206
1207
1208
1209
1210
1211 -- here's the delegated call to the old PL/SQL routine
1212 jtf_assign_pub.get_assign_task_resources(p_api_version,
1213 p_init_msg_list,
1214 p_resource_type,
1215 p_role,
1216 p_no_of_resources,
1217 p_auto_select_flag,
1218 p_contracts_preferred_engineer,
1219 p_ib_preferred_engineer,
1220 p_effort_duration,
1221 p_effort_uom,
1222 ddp_start_date,
1223 ddp_end_date,
1224 p_territory_flag,
1225 p_calendar_flag,
1226 p_web_availability_flag,
1227 p_task_id,
1228 p_column_list,
1229 p_business_process_id,
1230 ddp_business_process_date,
1231 p_filter_excluded_resource,
1232 ddx_assign_resources_tbl,
1233 x_return_status,
1234 x_msg_count,
1235 x_msg_data);
1236
1237 -- copy data back from the local variables to OUT or IN-OUT args, if any
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258 jtf_assign_pub_w.rosetta_table_copy_out_p11(ddx_assign_resources_tbl, p20_a0
1259 , p20_a1
1260 , p20_a2
1261 , p20_a3
1262 , p20_a4
1263 , p20_a5
1264 , p20_a6
1265 , p20_a7
1266 , p20_a8
1267 , p20_a9
1268 , p20_a10
1269 , p20_a11
1270 , p20_a12
1271 , p20_a13
1272 , p20_a14
1273 , p20_a15
1274 , p20_a16
1275 , p20_a17
1276 , p20_a18
1277 , p20_a19
1278 , p20_a20
1279 , p20_a21
1280 , p20_a22
1281 , p20_a23
1282 , p20_a24
1283 , p20_a25
1284 , p20_a26
1285 );
1286
1287
1288
1289 end;
1290
1291 procedure get_assign_dr_resources(p_api_version NUMBER
1292 , p_init_msg_list VARCHAR2
1293 , p_resource_type VARCHAR2
1294 , p_role VARCHAR2
1295 , p_no_of_resources NUMBER
1296 , p_auto_select_flag VARCHAR2
1297 , p_contracts_preferred_engineer VARCHAR2
1298 , p_ib_preferred_engineer VARCHAR2
1299 , p_contract_id NUMBER
1300 , p_customer_product_id NUMBER
1301 , p_effort_duration NUMBER
1302 , p_effort_uom VARCHAR2
1303 , p_start_date date
1304 , p_end_date date
1305 , p_territory_flag VARCHAR2
1306 , p_calendar_flag VARCHAR2
1307 , p_web_availability_flag VARCHAR2
1308 , p_category_id NUMBER
1309 , p_inventory_item_id NUMBER
1310 , p_inventory_org_id NUMBER
1311 , p_problem_code VARCHAR2
1312 , p_dr_id NUMBER
1313 , p_column_list VARCHAR2
1314 , p_business_process_id NUMBER
1315 , p_business_process_date date
1316 , p_filter_excluded_resource VARCHAR2
1317 , p27_a0 out nocopy JTF_NUMBER_TABLE
1318 , p27_a1 out nocopy JTF_NUMBER_TABLE
1319 , p27_a2 out nocopy JTF_VARCHAR2_TABLE_100
1320 , p27_a3 out nocopy JTF_VARCHAR2_TABLE_100
1321 , p27_a4 out nocopy JTF_DATE_TABLE
1322 , p27_a5 out nocopy JTF_DATE_TABLE
1323 , p27_a6 out nocopy JTF_NUMBER_TABLE
1324 , p27_a7 out nocopy JTF_NUMBER_TABLE
1325 , p27_a8 out nocopy JTF_VARCHAR2_TABLE_300
1326 , p27_a9 out nocopy JTF_NUMBER_TABLE
1327 , p27_a10 out nocopy JTF_NUMBER_TABLE
1328 , p27_a11 out nocopy JTF_VARCHAR2_TABLE_100
1329 , p27_a12 out nocopy JTF_VARCHAR2_TABLE_100
1330 , p27_a13 out nocopy JTF_VARCHAR2_TABLE_100
1331 , p27_a14 out nocopy JTF_VARCHAR2_TABLE_100
1332 , p27_a15 out nocopy JTF_NUMBER_TABLE
1333 , p27_a16 out nocopy JTF_VARCHAR2_TABLE_100
1334 , p27_a17 out nocopy JTF_NUMBER_TABLE
1335 , p27_a18 out nocopy JTF_VARCHAR2_TABLE_100
1336 , p27_a19 out nocopy JTF_DATE_TABLE
1337 , p27_a20 out nocopy JTF_DATE_TABLE
1338 , p27_a21 out nocopy JTF_NUMBER_TABLE
1339 , p27_a22 out nocopy JTF_VARCHAR2_TABLE_200
1340 , p27_a23 out nocopy JTF_VARCHAR2_TABLE_100
1341 , p27_a24 out nocopy JTF_NUMBER_TABLE
1342 , p27_a25 out nocopy JTF_VARCHAR2_TABLE_100
1343 , p27_a26 out nocopy JTF_VARCHAR2_TABLE_100
1344 , x_return_status out nocopy VARCHAR2
1345 , x_msg_count out nocopy NUMBER
1346 , x_msg_data out nocopy VARCHAR2
1347 , p23_a0 NUMBER := 0-1962.0724
1348 , p23_a1 NUMBER := 0-1962.0724
1349 , p23_a2 NUMBER := 0-1962.0724
1350 , p23_a3 VARCHAR2 := fnd_api.g_miss_char
1351 , p23_a4 NUMBER := 0-1962.0724
1352 , p23_a5 VARCHAR2 := fnd_api.g_miss_char
1353 , p23_a6 VARCHAR2 := fnd_api.g_miss_char
1354 , p23_a7 VARCHAR2 := fnd_api.g_miss_char
1355 , p23_a8 VARCHAR2 := fnd_api.g_miss_char
1356 , p23_a9 VARCHAR2 := fnd_api.g_miss_char
1357 , p23_a10 VARCHAR2 := fnd_api.g_miss_char
1358 , p23_a11 VARCHAR2 := fnd_api.g_miss_char
1359 , p23_a12 NUMBER := 0-1962.0724
1360 , p23_a13 NUMBER := 0-1962.0724
1361 , p23_a14 NUMBER := 0-1962.0724
1362 , p23_a15 NUMBER := 0-1962.0724
1363 , p23_a16 NUMBER := 0-1962.0724
1364 , p23_a17 NUMBER := 0-1962.0724
1365 , p23_a18 NUMBER := 0-1962.0724
1366 , p23_a19 VARCHAR2 := fnd_api.g_miss_char
1367 , p23_a20 NUMBER := 0-1962.0724
1368 , p23_a21 NUMBER := 0-1962.0724
1369 , p23_a22 NUMBER := 0-1962.0724
1370 , p23_a23 NUMBER := 0-1962.0724
1371 , p23_a24 VARCHAR2 := fnd_api.g_miss_char
1372 , p23_a25 NUMBER := 0-1962.0724
1373 , p23_a26 VARCHAR2 := fnd_api.g_miss_char
1374 , p23_a27 VARCHAR2 := fnd_api.g_miss_char
1375 , p23_a28 VARCHAR2 := fnd_api.g_miss_char
1376 , p23_a29 VARCHAR2 := fnd_api.g_miss_char
1377 , p23_a30 VARCHAR2 := fnd_api.g_miss_char
1378 , p23_a31 VARCHAR2 := fnd_api.g_miss_char
1379 , p23_a32 VARCHAR2 := fnd_api.g_miss_char
1380 , p23_a33 VARCHAR2 := fnd_api.g_miss_char
1381 , p23_a34 VARCHAR2 := fnd_api.g_miss_char
1382 , p23_a35 VARCHAR2 := fnd_api.g_miss_char
1383 , p23_a36 VARCHAR2 := fnd_api.g_miss_char
1384 , p23_a37 VARCHAR2 := fnd_api.g_miss_char
1385 , p23_a38 VARCHAR2 := fnd_api.g_miss_char
1386 , p23_a39 VARCHAR2 := fnd_api.g_miss_char
1387 , p23_a40 VARCHAR2 := fnd_api.g_miss_char
1388 , p23_a41 NUMBER := 0-1962.0724
1392 , p23_a45 NUMBER := 0-1962.0724
1389 , p23_a42 NUMBER := 0-1962.0724
1390 , p23_a43 NUMBER := 0-1962.0724
1391 , p23_a44 NUMBER := 0-1962.0724
1393 , p23_a46 NUMBER := 0-1962.0724
1394 , p23_a47 NUMBER := 0-1962.0724
1395 , p23_a48 NUMBER := 0-1962.0724
1396 , p23_a49 NUMBER := 0-1962.0724
1397 , p23_a50 NUMBER := 0-1962.0724
1398 , p23_a51 VARCHAR2 := fnd_api.g_miss_char
1399 , p23_a52 VARCHAR2 := fnd_api.g_miss_char
1400 , p23_a53 VARCHAR2 := fnd_api.g_miss_char
1401 , p23_a54 VARCHAR2 := fnd_api.g_miss_char
1402 , p23_a55 VARCHAR2 := fnd_api.g_miss_char
1403 )
1404
1405 as
1406 ddp_start_date date;
1407 ddp_end_date date;
1408 ddp_dr_rec jtf_assign_pub.jtf_dr_rec_type;
1409 ddp_business_process_date date;
1410 ddx_assign_resources_tbl jtf_assign_pub.assignresources_tbl_type;
1411 ddindx binary_integer; indx binary_integer;
1412 begin
1413
1414 -- copy data to the local IN or IN-OUT args, if any
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427 ddp_start_date := rosetta_g_miss_date_in_map(p_start_date);
1428
1429 ddp_end_date := rosetta_g_miss_date_in_map(p_end_date);
1430
1431
1432
1433
1434
1435
1436
1437
1438
1439
1440 ddp_dr_rec.task_id := rosetta_g_miss_num_map(p23_a0);
1441 ddp_dr_rec.service_request_id := rosetta_g_miss_num_map(p23_a1);
1442 ddp_dr_rec.party_id := rosetta_g_miss_num_map(p23_a2);
1443 ddp_dr_rec.country := p23_a3;
1444 ddp_dr_rec.party_site_id := rosetta_g_miss_num_map(p23_a4);
1445 ddp_dr_rec.city := p23_a5;
1446 ddp_dr_rec.postal_code := p23_a6;
1447 ddp_dr_rec.state := p23_a7;
1448 ddp_dr_rec.area_code := p23_a8;
1449 ddp_dr_rec.county := p23_a9;
1450 ddp_dr_rec.comp_name_range := p23_a10;
1451 ddp_dr_rec.province := p23_a11;
1452 ddp_dr_rec.num_of_employees := rosetta_g_miss_num_map(p23_a12);
1453 ddp_dr_rec.task_type_id := rosetta_g_miss_num_map(p23_a13);
1454 ddp_dr_rec.task_status_id := rosetta_g_miss_num_map(p23_a14);
1455 ddp_dr_rec.task_priority_id := rosetta_g_miss_num_map(p23_a15);
1456 ddp_dr_rec.incident_type_id := rosetta_g_miss_num_map(p23_a16);
1457 ddp_dr_rec.incident_severity_id := rosetta_g_miss_num_map(p23_a17);
1458 ddp_dr_rec.incident_urgency_id := rosetta_g_miss_num_map(p23_a18);
1459 ddp_dr_rec.problem_code := p23_a19;
1460 ddp_dr_rec.incident_status_id := rosetta_g_miss_num_map(p23_a20);
1461 ddp_dr_rec.platform_id := rosetta_g_miss_num_map(p23_a21);
1462 ddp_dr_rec.support_site_id := rosetta_g_miss_num_map(p23_a22);
1463 ddp_dr_rec.customer_site_id := rosetta_g_miss_num_map(p23_a23);
1464 ddp_dr_rec.sr_creation_channel := p23_a24;
1465 ddp_dr_rec.inventory_item_id := rosetta_g_miss_num_map(p23_a25);
1466 ddp_dr_rec.attribute1 := p23_a26;
1467 ddp_dr_rec.attribute2 := p23_a27;
1468 ddp_dr_rec.attribute3 := p23_a28;
1469 ddp_dr_rec.attribute4 := p23_a29;
1470 ddp_dr_rec.attribute5 := p23_a30;
1471 ddp_dr_rec.attribute6 := p23_a31;
1472 ddp_dr_rec.attribute7 := p23_a32;
1473 ddp_dr_rec.attribute8 := p23_a33;
1474 ddp_dr_rec.attribute9 := p23_a34;
1475 ddp_dr_rec.attribute10 := p23_a35;
1476 ddp_dr_rec.attribute11 := p23_a36;
1477 ddp_dr_rec.attribute12 := p23_a37;
1478 ddp_dr_rec.attribute13 := p23_a38;
1479 ddp_dr_rec.attribute14 := p23_a39;
1480 ddp_dr_rec.attribute15 := p23_a40;
1481 ddp_dr_rec.organization_id := rosetta_g_miss_num_map(p23_a41);
1482 ddp_dr_rec.squal_num12 := rosetta_g_miss_num_map(p23_a42);
1483 ddp_dr_rec.squal_num13 := rosetta_g_miss_num_map(p23_a43);
1484 ddp_dr_rec.squal_num14 := rosetta_g_miss_num_map(p23_a44);
1485 ddp_dr_rec.squal_num15 := rosetta_g_miss_num_map(p23_a45);
1486 ddp_dr_rec.squal_num16 := rosetta_g_miss_num_map(p23_a46);
1487 ddp_dr_rec.squal_num17 := rosetta_g_miss_num_map(p23_a47);
1488 ddp_dr_rec.squal_num18 := rosetta_g_miss_num_map(p23_a48);
1489 ddp_dr_rec.squal_num19 := rosetta_g_miss_num_map(p23_a49);
1490 ddp_dr_rec.squal_num30 := rosetta_g_miss_num_map(p23_a50);
1491 ddp_dr_rec.squal_char11 := p23_a51;
1492 ddp_dr_rec.squal_char12 := p23_a52;
1493 ddp_dr_rec.squal_char13 := p23_a53;
1494 ddp_dr_rec.squal_char20 := p23_a54;
1495 ddp_dr_rec.squal_char21 := p23_a55;
1496
1497
1498 ddp_business_process_date := rosetta_g_miss_date_in_map(p_business_process_date);
1499
1500
1501
1502
1503
1504
1505 -- here's the delegated call to the old PL/SQL routine
1506 jtf_assign_pub.get_assign_dr_resources(p_api_version,
1507 p_init_msg_list,
1508 p_resource_type,
1509 p_role,
1510 p_no_of_resources,
1511 p_auto_select_flag,
1512 p_contracts_preferred_engineer,
1513 p_ib_preferred_engineer,
1514 p_contract_id,
1515 p_customer_product_id,
1516 p_effort_duration,
1517 p_effort_uom,
1518 ddp_start_date,
1519 ddp_end_date,
1520 p_territory_flag,
1521 p_calendar_flag,
1522 p_web_availability_flag,
1523 p_category_id,
1524 p_inventory_item_id,
1525 p_inventory_org_id,
1526 p_problem_code,
1527 p_dr_id,
1528 p_column_list,
1529 ddp_dr_rec,
1530 p_business_process_id,
1531 ddp_business_process_date,
1532 p_filter_excluded_resource,
1533 ddx_assign_resources_tbl,
1534 x_return_status,
1535 x_msg_count,
1536 x_msg_data);
1537
1538 -- copy data back from the local variables to OUT or IN-OUT args, if any
1539
1540
1541
1542
1543
1544
1545
1549
1546
1547
1548
1550
1551
1552
1553
1554
1555
1556
1557
1558
1559
1560
1561
1562
1563
1564
1565
1566 jtf_assign_pub_w.rosetta_table_copy_out_p11(ddx_assign_resources_tbl, p27_a0
1567 , p27_a1
1568 , p27_a2
1569 , p27_a3
1570 , p27_a4
1571 , p27_a5
1572 , p27_a6
1573 , p27_a7
1574 , p27_a8
1575 , p27_a9
1576 , p27_a10
1577 , p27_a11
1578 , p27_a12
1579 , p27_a13
1580 , p27_a14
1581 , p27_a15
1582 , p27_a16
1583 , p27_a17
1584 , p27_a18
1585 , p27_a19
1586 , p27_a20
1587 , p27_a21
1588 , p27_a22
1589 , p27_a23
1590 , p27_a24
1591 , p27_a25
1592 , p27_a26
1593 );
1594
1595
1596
1597 end;
1598
1599 procedure get_assign_oppr_resources(p_api_version NUMBER
1600 , p_init_msg_list VARCHAR2
1601 , p_resource_type VARCHAR2
1602 , p_role VARCHAR2
1603 , p_no_of_resources NUMBER
1604 , p_auto_select_flag VARCHAR2
1605 , p_effort_duration NUMBER
1606 , p_effort_uom VARCHAR2
1607 , p_start_date date
1608 , p_end_date date
1609 , p_territory_flag VARCHAR2
1610 , p_calendar_flag VARCHAR2
1611 , p_business_process_id NUMBER
1612 , p_business_process_date date
1613 , p15_a0 out nocopy JTF_NUMBER_TABLE
1614 , p15_a1 out nocopy JTF_NUMBER_TABLE
1615 , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
1616 , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
1617 , p15_a4 out nocopy JTF_DATE_TABLE
1618 , p15_a5 out nocopy JTF_DATE_TABLE
1619 , p15_a6 out nocopy JTF_NUMBER_TABLE
1620 , p15_a7 out nocopy JTF_NUMBER_TABLE
1621 , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
1622 , p15_a9 out nocopy JTF_NUMBER_TABLE
1623 , p15_a10 out nocopy JTF_NUMBER_TABLE
1624 , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
1625 , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
1626 , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
1627 , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
1628 , p15_a15 out nocopy JTF_NUMBER_TABLE
1629 , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
1630 , p15_a17 out nocopy JTF_NUMBER_TABLE
1631 , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
1632 , p15_a19 out nocopy JTF_DATE_TABLE
1633 , p15_a20 out nocopy JTF_DATE_TABLE
1634 , p15_a21 out nocopy JTF_NUMBER_TABLE
1635 , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
1636 , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
1637 , p15_a24 out nocopy JTF_NUMBER_TABLE
1638 , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
1639 , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
1640 , x_return_status out nocopy VARCHAR2
1641 , x_msg_count out nocopy NUMBER
1642 , x_msg_data out nocopy VARCHAR2
1643 , p12_a0 NUMBER := 0-1962.0724
1644 , p12_a1 NUMBER := 0-1962.0724
1645 , p12_a2 VARCHAR2 := fnd_api.g_miss_char
1646 , p12_a3 VARCHAR2 := fnd_api.g_miss_char
1647 , p12_a4 VARCHAR2 := fnd_api.g_miss_char
1648 , p12_a5 VARCHAR2 := fnd_api.g_miss_char
1649 , p12_a6 VARCHAR2 := fnd_api.g_miss_char
1650 , p12_a7 VARCHAR2 := fnd_api.g_miss_char
1651 , p12_a8 NUMBER := 0-1962.0724
1652 , p12_a9 NUMBER := 0-1962.0724
1653 , p12_a10 NUMBER := 0-1962.0724
1654 , p12_a11 NUMBER := 0-1962.0724
1655 , p12_a12 NUMBER := 0-1962.0724
1656 , p12_a13 NUMBER := 0-1962.0724
1657 , p12_a14 NUMBER := 0-1962.0724
1658 , p12_a15 VARCHAR2 := fnd_api.g_miss_char
1659 , p12_a16 NUMBER := 0-1962.0724
1660 , p12_a17 VARCHAR2 := fnd_api.g_miss_char
1661 , p12_a18 NUMBER := 0-1962.0724
1662 , p12_a19 NUMBER := 0-1962.0724
1663 , p12_a20 VARCHAR2 := fnd_api.g_miss_char
1664 , p12_a21 NUMBER := 0-1962.0724
1665 , p12_a22 VARCHAR2 := fnd_api.g_miss_char
1666 , p12_a23 VARCHAR2 := fnd_api.g_miss_char
1667 , p12_a24 NUMBER := 0-1962.0724
1668 , p12_a25 VARCHAR2 := fnd_api.g_miss_char
1669 , p12_a26 DATE := fnd_api.g_miss_date
1670 , p12_a27 VARCHAR2 := fnd_api.g_miss_char
1671 , p12_a28 NUMBER := 0-1962.0724
1672 , p12_a29 NUMBER := 0-1962.0724
1673 , p12_a30 NUMBER := 0-1962.0724
1674 , p12_a31 NUMBER := 0-1962.0724
1675 , p12_a32 NUMBER := 0-1962.0724
1676 , p12_a33 NUMBER := 0-1962.0724
1677 , p12_a34 NUMBER := 0-1962.0724
1678 , p12_a35 VARCHAR2 := fnd_api.g_miss_char
1679 , p12_a36 VARCHAR2 := fnd_api.g_miss_char
1680 , p12_a37 VARCHAR2 := fnd_api.g_miss_char
1681 , p12_a38 VARCHAR2 := fnd_api.g_miss_char
1682 , p12_a39 VARCHAR2 := fnd_api.g_miss_char
1683 , p12_a40 VARCHAR2 := fnd_api.g_miss_char
1684 , p12_a41 VARCHAR2 := fnd_api.g_miss_char
1685 , p12_a42 VARCHAR2 := fnd_api.g_miss_char
1686 , p12_a43 VARCHAR2 := fnd_api.g_miss_char
1687 , p12_a44 VARCHAR2 := fnd_api.g_miss_char
1688 , p12_a45 VARCHAR2 := fnd_api.g_miss_char
1689 , p12_a46 VARCHAR2 := fnd_api.g_miss_char
1690 , p12_a47 VARCHAR2 := fnd_api.g_miss_char
1691 , p12_a48 VARCHAR2 := fnd_api.g_miss_char
1692 , p12_a49 VARCHAR2 := fnd_api.g_miss_char
1693 , p12_a50 NUMBER := 0-1962.0724
1694 )
1695
1696 as
1697 ddp_start_date date;
1698 ddp_end_date date;
1699 ddp_opportunity_rec jtf_assign_pub.jtf_oppor_rec_type;
1700 ddp_business_process_date date;
1701 ddx_assign_resources_tbl jtf_assign_pub.assignresources_tbl_type;
1702 ddindx binary_integer; indx binary_integer;
1703 begin
1704
1705 -- copy data to the local IN or IN-OUT args, if any
1706
1707
1708
1709
1713
1710
1711
1712
1714 ddp_start_date := rosetta_g_miss_date_in_map(p_start_date);
1715
1716 ddp_end_date := rosetta_g_miss_date_in_map(p_end_date);
1717
1718
1719
1720 ddp_opportunity_rec.lead_id := rosetta_g_miss_num_map(p12_a0);
1721 ddp_opportunity_rec.lead_line_id := rosetta_g_miss_num_map(p12_a1);
1722 ddp_opportunity_rec.city := p12_a2;
1723 ddp_opportunity_rec.postal_code := p12_a3;
1724 ddp_opportunity_rec.state := p12_a4;
1725 ddp_opportunity_rec.province := p12_a5;
1726 ddp_opportunity_rec.county := p12_a6;
1727 ddp_opportunity_rec.country := p12_a7;
1728 ddp_opportunity_rec.interest_type_id := rosetta_g_miss_num_map(p12_a8);
1729 ddp_opportunity_rec.primary_interest_id := rosetta_g_miss_num_map(p12_a9);
1730 ddp_opportunity_rec.secondary_interest_id := rosetta_g_miss_num_map(p12_a10);
1731 ddp_opportunity_rec.contact_interest_type_id := rosetta_g_miss_num_map(p12_a11);
1732 ddp_opportunity_rec.contact_primary_interest_id := rosetta_g_miss_num_map(p12_a12);
1733 ddp_opportunity_rec.contact_secondary_interest_id := rosetta_g_miss_num_map(p12_a13);
1734 ddp_opportunity_rec.party_site_id := rosetta_g_miss_num_map(p12_a14);
1735 ddp_opportunity_rec.area_code := p12_a15;
1736 ddp_opportunity_rec.party_id := rosetta_g_miss_num_map(p12_a16);
1737 ddp_opportunity_rec.comp_name_range := p12_a17;
1738 ddp_opportunity_rec.partner_id := rosetta_g_miss_num_map(p12_a18);
1739 ddp_opportunity_rec.num_of_employees := rosetta_g_miss_num_map(p12_a19);
1740 ddp_opportunity_rec.category_code := p12_a20;
1741 ddp_opportunity_rec.party_relationship_id := rosetta_g_miss_num_map(p12_a21);
1742 ddp_opportunity_rec.sic_code := p12_a22;
1743 ddp_opportunity_rec.target_segment_current := p12_a23;
1744 ddp_opportunity_rec.total_amount := rosetta_g_miss_num_map(p12_a24);
1745 ddp_opportunity_rec.currency_code := p12_a25;
1746 ddp_opportunity_rec.pricing_date := rosetta_g_miss_date_in_map(p12_a26);
1747 ddp_opportunity_rec.channel_code := p12_a27;
1748 ddp_opportunity_rec.inventory_item_id := rosetta_g_miss_num_map(p12_a28);
1749 ddp_opportunity_rec.opp_interest_type_id := rosetta_g_miss_num_map(p12_a29);
1750 ddp_opportunity_rec.opp_primary_interest_id := rosetta_g_miss_num_map(p12_a30);
1751 ddp_opportunity_rec.opp_secondary_interest_id := rosetta_g_miss_num_map(p12_a31);
1752 ddp_opportunity_rec.opclss_interest_type_id := rosetta_g_miss_num_map(p12_a32);
1753 ddp_opportunity_rec.opclss_primary_interest_id := rosetta_g_miss_num_map(p12_a33);
1754 ddp_opportunity_rec.opclss_secondary_interest_id := rosetta_g_miss_num_map(p12_a34);
1755 ddp_opportunity_rec.attribute1 := p12_a35;
1756 ddp_opportunity_rec.attribute2 := p12_a36;
1757 ddp_opportunity_rec.attribute3 := p12_a37;
1758 ddp_opportunity_rec.attribute4 := p12_a38;
1759 ddp_opportunity_rec.attribute5 := p12_a39;
1760 ddp_opportunity_rec.attribute6 := p12_a40;
1761 ddp_opportunity_rec.attribute7 := p12_a41;
1762 ddp_opportunity_rec.attribute8 := p12_a42;
1763 ddp_opportunity_rec.attribute9 := p12_a43;
1764 ddp_opportunity_rec.attribute10 := p12_a44;
1765 ddp_opportunity_rec.attribute11 := p12_a45;
1766 ddp_opportunity_rec.attribute12 := p12_a46;
1767 ddp_opportunity_rec.attribute13 := p12_a47;
1768 ddp_opportunity_rec.attribute14 := p12_a48;
1769 ddp_opportunity_rec.attribute15 := p12_a49;
1770 ddp_opportunity_rec.org_id := rosetta_g_miss_num_map(p12_a50);
1771
1772
1773 ddp_business_process_date := rosetta_g_miss_date_in_map(p_business_process_date);
1774
1775
1776
1777
1778
1779 -- here's the delegated call to the old PL/SQL routine
1780 jtf_assign_pub.get_assign_oppr_resources(p_api_version,
1781 p_init_msg_list,
1782 p_resource_type,
1783 p_role,
1784 p_no_of_resources,
1785 p_auto_select_flag,
1786 p_effort_duration,
1787 p_effort_uom,
1788 ddp_start_date,
1789 ddp_end_date,
1790 p_territory_flag,
1791 p_calendar_flag,
1792 ddp_opportunity_rec,
1793 p_business_process_id,
1794 ddp_business_process_date,
1795 ddx_assign_resources_tbl,
1796 x_return_status,
1797 x_msg_count,
1798 x_msg_data);
1799
1800 -- copy data back from the local variables to OUT or IN-OUT args, if any
1801
1802
1803
1804
1805
1806
1807
1808
1809
1810
1811
1812
1813
1814
1815
1816 jtf_assign_pub_w.rosetta_table_copy_out_p11(ddx_assign_resources_tbl, p15_a0
1817 , p15_a1
1818 , p15_a2
1819 , p15_a3
1820 , p15_a4
1821 , p15_a5
1822 , p15_a6
1823 , p15_a7
1824 , p15_a8
1825 , p15_a9
1826 , p15_a10
1827 , p15_a11
1828 , p15_a12
1829 , p15_a13
1830 , p15_a14
1831 , p15_a15
1832 , p15_a16
1833 , p15_a17
1834 , p15_a18
1835 , p15_a19
1836 , p15_a20
1837 , p15_a21
1838 , p15_a22
1839 , p15_a23
1840 , p15_a24
1841 , p15_a25
1842 , p15_a26
1843 );
1844
1845
1846
1847 end;
1848
1849 procedure get_assign_lead_resources(p_api_version NUMBER
1850 , p_init_msg_list VARCHAR2
1851 , p_resource_type VARCHAR2
1852 , p_role VARCHAR2
1853 , p_no_of_resources NUMBER
1854 , p_auto_select_flag VARCHAR2
1855 , p_effort_duration NUMBER
1856 , p_effort_uom VARCHAR2
1857 , p_start_date date
1858 , p_end_date date
1859 , p_territory_flag VARCHAR2
1860 , p_calendar_flag VARCHAR2
1861 , p_business_process_id NUMBER
1862 , p_business_process_date date
1866 , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
1863 , p15_a0 out nocopy JTF_NUMBER_TABLE
1864 , p15_a1 out nocopy JTF_NUMBER_TABLE
1865 , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
1867 , p15_a4 out nocopy JTF_DATE_TABLE
1868 , p15_a5 out nocopy JTF_DATE_TABLE
1869 , p15_a6 out nocopy JTF_NUMBER_TABLE
1870 , p15_a7 out nocopy JTF_NUMBER_TABLE
1871 , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
1872 , p15_a9 out nocopy JTF_NUMBER_TABLE
1873 , p15_a10 out nocopy JTF_NUMBER_TABLE
1874 , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
1875 , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
1876 , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
1877 , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
1878 , p15_a15 out nocopy JTF_NUMBER_TABLE
1879 , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
1880 , p15_a17 out nocopy JTF_NUMBER_TABLE
1881 , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
1882 , p15_a19 out nocopy JTF_DATE_TABLE
1883 , p15_a20 out nocopy JTF_DATE_TABLE
1884 , p15_a21 out nocopy JTF_NUMBER_TABLE
1885 , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
1886 , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
1887 , p15_a24 out nocopy JTF_NUMBER_TABLE
1888 , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
1889 , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
1890 , x_return_status out nocopy VARCHAR2
1891 , x_msg_count out nocopy NUMBER
1892 , x_msg_data out nocopy VARCHAR2
1893 , p12_a0 NUMBER := 0-1962.0724
1894 , p12_a1 NUMBER := 0-1962.0724
1895 , p12_a2 VARCHAR2 := fnd_api.g_miss_char
1896 , p12_a3 VARCHAR2 := fnd_api.g_miss_char
1897 , p12_a4 VARCHAR2 := fnd_api.g_miss_char
1898 , p12_a5 VARCHAR2 := fnd_api.g_miss_char
1899 , p12_a6 VARCHAR2 := fnd_api.g_miss_char
1900 , p12_a7 VARCHAR2 := fnd_api.g_miss_char
1901 , p12_a8 NUMBER := 0-1962.0724
1902 , p12_a9 NUMBER := 0-1962.0724
1903 , p12_a10 NUMBER := 0-1962.0724
1904 , p12_a11 NUMBER := 0-1962.0724
1905 , p12_a12 NUMBER := 0-1962.0724
1906 , p12_a13 NUMBER := 0-1962.0724
1907 , p12_a14 NUMBER := 0-1962.0724
1908 , p12_a15 VARCHAR2 := fnd_api.g_miss_char
1909 , p12_a16 NUMBER := 0-1962.0724
1910 , p12_a17 VARCHAR2 := fnd_api.g_miss_char
1911 , p12_a18 NUMBER := 0-1962.0724
1912 , p12_a19 NUMBER := 0-1962.0724
1913 , p12_a20 VARCHAR2 := fnd_api.g_miss_char
1914 , p12_a21 NUMBER := 0-1962.0724
1915 , p12_a22 VARCHAR2 := fnd_api.g_miss_char
1916 , p12_a23 NUMBER := 0-1962.0724
1917 , p12_a24 VARCHAR2 := fnd_api.g_miss_char
1918 , p12_a25 DATE := fnd_api.g_miss_date
1919 , p12_a26 NUMBER := 0-1962.0724
1920 , p12_a27 NUMBER := 0-1962.0724
1921 , p12_a28 NUMBER := 0-1962.0724
1922 , p12_a29 NUMBER := 0-1962.0724
1923 , p12_a30 NUMBER := 0-1962.0724
1924 , p12_a31 NUMBER := 0-1962.0724
1925 , p12_a32 VARCHAR2 := fnd_api.g_miss_char
1926 , p12_a33 VARCHAR2 := fnd_api.g_miss_char
1927 , p12_a34 VARCHAR2 := fnd_api.g_miss_char
1928 , p12_a35 VARCHAR2 := fnd_api.g_miss_char
1929 , p12_a36 VARCHAR2 := fnd_api.g_miss_char
1930 , p12_a37 VARCHAR2 := fnd_api.g_miss_char
1931 , p12_a38 VARCHAR2 := fnd_api.g_miss_char
1932 , p12_a39 VARCHAR2 := fnd_api.g_miss_char
1933 , p12_a40 VARCHAR2 := fnd_api.g_miss_char
1934 , p12_a41 VARCHAR2 := fnd_api.g_miss_char
1935 , p12_a42 VARCHAR2 := fnd_api.g_miss_char
1936 , p12_a43 VARCHAR2 := fnd_api.g_miss_char
1937 , p12_a44 VARCHAR2 := fnd_api.g_miss_char
1938 , p12_a45 VARCHAR2 := fnd_api.g_miss_char
1939 , p12_a46 VARCHAR2 := fnd_api.g_miss_char
1940 , p12_a47 NUMBER := 0-1962.0724
1941 )
1942
1943 as
1944 ddp_start_date date;
1945 ddp_end_date date;
1946 ddp_lead_rec jtf_assign_pub.jtf_lead_rec_type;
1947 ddp_business_process_date date;
1948 ddx_assign_resources_tbl jtf_assign_pub.assignresources_tbl_type;
1949 ddindx binary_integer; indx binary_integer;
1950 begin
1951
1952 -- copy data to the local IN or IN-OUT args, if any
1953
1954
1955
1956
1957
1958
1959
1960
1961 ddp_start_date := rosetta_g_miss_date_in_map(p_start_date);
1962
1963 ddp_end_date := rosetta_g_miss_date_in_map(p_end_date);
1964
1965
1966
1967 ddp_lead_rec.sales_lead_id := rosetta_g_miss_num_map(p12_a0);
1968 ddp_lead_rec.sales_lead_line_id := rosetta_g_miss_num_map(p12_a1);
1969 ddp_lead_rec.city := p12_a2;
1970 ddp_lead_rec.postal_code := p12_a3;
1971 ddp_lead_rec.state := p12_a4;
1972 ddp_lead_rec.province := p12_a5;
1973 ddp_lead_rec.county := p12_a6;
1974 ddp_lead_rec.country := p12_a7;
1975 ddp_lead_rec.interest_type_id := rosetta_g_miss_num_map(p12_a8);
1976 ddp_lead_rec.primary_interest_id := rosetta_g_miss_num_map(p12_a9);
1977 ddp_lead_rec.secondary_interest_id := rosetta_g_miss_num_map(p12_a10);
1978 ddp_lead_rec.contact_interest_type_id := rosetta_g_miss_num_map(p12_a11);
1979 ddp_lead_rec.contact_primary_interest_id := rosetta_g_miss_num_map(p12_a12);
1980 ddp_lead_rec.contact_secondary_interest_id := rosetta_g_miss_num_map(p12_a13);
1981 ddp_lead_rec.party_site_id := rosetta_g_miss_num_map(p12_a14);
1982 ddp_lead_rec.area_code := p12_a15;
1983 ddp_lead_rec.party_id := rosetta_g_miss_num_map(p12_a16);
1984 ddp_lead_rec.comp_name_range := p12_a17;
1985 ddp_lead_rec.partner_id := rosetta_g_miss_num_map(p12_a18);
1986 ddp_lead_rec.num_of_employees := rosetta_g_miss_num_map(p12_a19);
1987 ddp_lead_rec.category_code := p12_a20;
1988 ddp_lead_rec.party_relationship_id := rosetta_g_miss_num_map(p12_a21);
1989 ddp_lead_rec.sic_code := p12_a22;
1990 ddp_lead_rec.budget_amount := rosetta_g_miss_num_map(p12_a23);
1991 ddp_lead_rec.currency_code := p12_a24;
1992 ddp_lead_rec.pricing_date := rosetta_g_miss_date_in_map(p12_a25);
1996 ddp_lead_rec.lead_primary_interest_id := rosetta_g_miss_num_map(p12_a29);
1993 ddp_lead_rec.source_promotion_id := rosetta_g_miss_num_map(p12_a26);
1994 ddp_lead_rec.inventory_item_id := rosetta_g_miss_num_map(p12_a27);
1995 ddp_lead_rec.lead_interest_type_id := rosetta_g_miss_num_map(p12_a28);
1997 ddp_lead_rec.lead_secondary_interest_id := rosetta_g_miss_num_map(p12_a30);
1998 ddp_lead_rec.purchase_amount := rosetta_g_miss_num_map(p12_a31);
1999 ddp_lead_rec.attribute1 := p12_a32;
2000 ddp_lead_rec.attribute2 := p12_a33;
2001 ddp_lead_rec.attribute3 := p12_a34;
2002 ddp_lead_rec.attribute4 := p12_a35;
2003 ddp_lead_rec.attribute5 := p12_a36;
2004 ddp_lead_rec.attribute6 := p12_a37;
2005 ddp_lead_rec.attribute7 := p12_a38;
2006 ddp_lead_rec.attribute8 := p12_a39;
2007 ddp_lead_rec.attribute9 := p12_a40;
2008 ddp_lead_rec.attribute10 := p12_a41;
2009 ddp_lead_rec.attribute11 := p12_a42;
2010 ddp_lead_rec.attribute12 := p12_a43;
2011 ddp_lead_rec.attribute13 := p12_a44;
2012 ddp_lead_rec.attribute14 := p12_a45;
2013 ddp_lead_rec.attribute15 := p12_a46;
2014 ddp_lead_rec.org_id := rosetta_g_miss_num_map(p12_a47);
2015
2016
2017 ddp_business_process_date := rosetta_g_miss_date_in_map(p_business_process_date);
2018
2019
2020
2021
2022
2023 -- here's the delegated call to the old PL/SQL routine
2024 jtf_assign_pub.get_assign_lead_resources(p_api_version,
2025 p_init_msg_list,
2026 p_resource_type,
2027 p_role,
2028 p_no_of_resources,
2029 p_auto_select_flag,
2030 p_effort_duration,
2031 p_effort_uom,
2032 ddp_start_date,
2033 ddp_end_date,
2034 p_territory_flag,
2035 p_calendar_flag,
2036 ddp_lead_rec,
2037 p_business_process_id,
2038 ddp_business_process_date,
2039 ddx_assign_resources_tbl,
2040 x_return_status,
2041 x_msg_count,
2042 x_msg_data);
2043
2044 -- copy data back from the local variables to OUT or IN-OUT args, if any
2045
2046
2047
2048
2049
2050
2051
2052
2053
2054
2055
2056
2057
2058
2059
2060 jtf_assign_pub_w.rosetta_table_copy_out_p11(ddx_assign_resources_tbl, p15_a0
2061 , p15_a1
2062 , p15_a2
2063 , p15_a3
2064 , p15_a4
2065 , p15_a5
2066 , p15_a6
2067 , p15_a7
2068 , p15_a8
2069 , p15_a9
2070 , p15_a10
2071 , p15_a11
2072 , p15_a12
2073 , p15_a13
2074 , p15_a14
2075 , p15_a15
2076 , p15_a16
2077 , p15_a17
2078 , p15_a18
2079 , p15_a19
2080 , p15_a20
2081 , p15_a21
2082 , p15_a22
2083 , p15_a23
2084 , p15_a24
2085 , p15_a25
2086 , p15_a26
2087 );
2088
2089
2090
2091 end;
2092
2093 procedure get_assign_account_resources(p_api_version NUMBER
2094 , p_init_msg_list VARCHAR2
2095 , p_resource_type VARCHAR2
2096 , p_role VARCHAR2
2097 , p_no_of_resources NUMBER
2098 , p_auto_select_flag VARCHAR2
2099 , p_effort_duration NUMBER
2100 , p_effort_uom VARCHAR2
2101 , p_start_date date
2102 , p_end_date date
2103 , p_territory_flag VARCHAR2
2104 , p_calendar_flag VARCHAR2
2105 , p_business_process_id NUMBER
2106 , p_business_process_date date
2107 , p15_a0 out nocopy JTF_NUMBER_TABLE
2108 , p15_a1 out nocopy JTF_NUMBER_TABLE
2109 , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
2110 , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
2111 , p15_a4 out nocopy JTF_DATE_TABLE
2112 , p15_a5 out nocopy JTF_DATE_TABLE
2113 , p15_a6 out nocopy JTF_NUMBER_TABLE
2114 , p15_a7 out nocopy JTF_NUMBER_TABLE
2115 , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
2116 , p15_a9 out nocopy JTF_NUMBER_TABLE
2117 , p15_a10 out nocopy JTF_NUMBER_TABLE
2118 , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
2119 , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
2120 , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
2121 , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
2122 , p15_a15 out nocopy JTF_NUMBER_TABLE
2123 , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
2124 , p15_a17 out nocopy JTF_NUMBER_TABLE
2125 , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
2126 , p15_a19 out nocopy JTF_DATE_TABLE
2127 , p15_a20 out nocopy JTF_DATE_TABLE
2128 , p15_a21 out nocopy JTF_NUMBER_TABLE
2129 , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
2130 , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
2131 , p15_a24 out nocopy JTF_NUMBER_TABLE
2132 , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
2133 , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
2134 , x_return_status out nocopy VARCHAR2
2135 , x_msg_count out nocopy NUMBER
2136 , x_msg_data out nocopy VARCHAR2
2137 , p12_a0 VARCHAR2 := fnd_api.g_miss_char
2138 , p12_a1 VARCHAR2 := fnd_api.g_miss_char
2139 , p12_a2 VARCHAR2 := fnd_api.g_miss_char
2140 , p12_a3 VARCHAR2 := fnd_api.g_miss_char
2141 , p12_a4 VARCHAR2 := fnd_api.g_miss_char
2142 , p12_a5 VARCHAR2 := fnd_api.g_miss_char
2143 , p12_a6 NUMBER := 0-1962.0724
2144 , p12_a7 NUMBER := 0-1962.0724
2145 , p12_a8 NUMBER := 0-1962.0724
2146 , p12_a9 NUMBER := 0-1962.0724
2147 , p12_a10 NUMBER := 0-1962.0724
2148 , p12_a11 NUMBER := 0-1962.0724
2149 , p12_a12 NUMBER := 0-1962.0724
2150 , p12_a13 VARCHAR2 := fnd_api.g_miss_char
2151 , p12_a14 NUMBER := 0-1962.0724
2152 , p12_a15 VARCHAR2 := fnd_api.g_miss_char
2153 , p12_a16 NUMBER := 0-1962.0724
2157 , p12_a20 VARCHAR2 := fnd_api.g_miss_char
2154 , p12_a17 NUMBER := 0-1962.0724
2155 , p12_a18 VARCHAR2 := fnd_api.g_miss_char
2156 , p12_a19 NUMBER := 0-1962.0724
2158 , p12_a21 VARCHAR2 := fnd_api.g_miss_char
2159 , p12_a22 VARCHAR2 := fnd_api.g_miss_char
2160 , p12_a23 VARCHAR2 := fnd_api.g_miss_char
2161 , p12_a24 VARCHAR2 := fnd_api.g_miss_char
2162 , p12_a25 VARCHAR2 := fnd_api.g_miss_char
2163 , p12_a26 VARCHAR2 := fnd_api.g_miss_char
2164 , p12_a27 VARCHAR2 := fnd_api.g_miss_char
2165 , p12_a28 VARCHAR2 := fnd_api.g_miss_char
2166 , p12_a29 VARCHAR2 := fnd_api.g_miss_char
2167 , p12_a30 VARCHAR2 := fnd_api.g_miss_char
2168 , p12_a31 VARCHAR2 := fnd_api.g_miss_char
2169 , p12_a32 VARCHAR2 := fnd_api.g_miss_char
2170 , p12_a33 VARCHAR2 := fnd_api.g_miss_char
2171 , p12_a34 VARCHAR2 := fnd_api.g_miss_char
2172 , p12_a35 VARCHAR2 := fnd_api.g_miss_char
2173 , p12_a36 NUMBER := 0-1962.0724
2174 )
2175
2176 as
2177 ddp_start_date date;
2178 ddp_end_date date;
2179 ddp_account_rec jtf_assign_pub.jtf_account_rec_type;
2180 ddp_business_process_date date;
2181 ddx_assign_resources_tbl jtf_assign_pub.assignresources_tbl_type;
2182 ddindx binary_integer; indx binary_integer;
2183 begin
2184
2185 -- copy data to the local IN or IN-OUT args, if any
2186
2187
2188
2189
2190
2191
2192
2193
2194 ddp_start_date := rosetta_g_miss_date_in_map(p_start_date);
2195
2196 ddp_end_date := rosetta_g_miss_date_in_map(p_end_date);
2197
2198
2199
2200 ddp_account_rec.city := p12_a0;
2201 ddp_account_rec.postal_code := p12_a1;
2202 ddp_account_rec.state := p12_a2;
2203 ddp_account_rec.province := p12_a3;
2204 ddp_account_rec.county := p12_a4;
2205 ddp_account_rec.country := p12_a5;
2206 ddp_account_rec.interest_type_id := rosetta_g_miss_num_map(p12_a6);
2207 ddp_account_rec.primary_interest_id := rosetta_g_miss_num_map(p12_a7);
2208 ddp_account_rec.secondary_interest_id := rosetta_g_miss_num_map(p12_a8);
2209 ddp_account_rec.contact_interest_type_id := rosetta_g_miss_num_map(p12_a9);
2210 ddp_account_rec.contact_primary_interest_id := rosetta_g_miss_num_map(p12_a10);
2211 ddp_account_rec.contact_secondary_interest_id := rosetta_g_miss_num_map(p12_a11);
2212 ddp_account_rec.party_site_id := rosetta_g_miss_num_map(p12_a12);
2213 ddp_account_rec.area_code := p12_a13;
2214 ddp_account_rec.party_id := rosetta_g_miss_num_map(p12_a14);
2215 ddp_account_rec.comp_name_range := p12_a15;
2216 ddp_account_rec.partner_id := rosetta_g_miss_num_map(p12_a16);
2217 ddp_account_rec.num_of_employees := rosetta_g_miss_num_map(p12_a17);
2218 ddp_account_rec.category_code := p12_a18;
2219 ddp_account_rec.party_relationship_id := rosetta_g_miss_num_map(p12_a19);
2220 ddp_account_rec.sic_code := p12_a20;
2221 ddp_account_rec.attribute1 := p12_a21;
2222 ddp_account_rec.attribute2 := p12_a22;
2223 ddp_account_rec.attribute3 := p12_a23;
2224 ddp_account_rec.attribute4 := p12_a24;
2225 ddp_account_rec.attribute5 := p12_a25;
2226 ddp_account_rec.attribute6 := p12_a26;
2227 ddp_account_rec.attribute7 := p12_a27;
2228 ddp_account_rec.attribute8 := p12_a28;
2229 ddp_account_rec.attribute9 := p12_a29;
2230 ddp_account_rec.attribute10 := p12_a30;
2231 ddp_account_rec.attribute11 := p12_a31;
2232 ddp_account_rec.attribute12 := p12_a32;
2233 ddp_account_rec.attribute13 := p12_a33;
2234 ddp_account_rec.attribute14 := p12_a34;
2235 ddp_account_rec.attribute15 := p12_a35;
2236 ddp_account_rec.org_id := rosetta_g_miss_num_map(p12_a36);
2237
2238
2239 ddp_business_process_date := rosetta_g_miss_date_in_map(p_business_process_date);
2240
2241
2242
2243
2244
2245 -- here's the delegated call to the old PL/SQL routine
2246 jtf_assign_pub.get_assign_account_resources(p_api_version,
2247 p_init_msg_list,
2248 p_resource_type,
2249 p_role,
2250 p_no_of_resources,
2251 p_auto_select_flag,
2252 p_effort_duration,
2253 p_effort_uom,
2254 ddp_start_date,
2255 ddp_end_date,
2256 p_territory_flag,
2257 p_calendar_flag,
2258 ddp_account_rec,
2259 p_business_process_id,
2260 ddp_business_process_date,
2261 ddx_assign_resources_tbl,
2262 x_return_status,
2263 x_msg_count,
2264 x_msg_data);
2265
2266 -- copy data back from the local variables to OUT or IN-OUT args, if any
2267
2268
2269
2270
2271
2272
2273
2274
2275
2276
2277
2278
2279
2280
2281
2282 jtf_assign_pub_w.rosetta_table_copy_out_p11(ddx_assign_resources_tbl, p15_a0
2283 , p15_a1
2284 , p15_a2
2285 , p15_a3
2286 , p15_a4
2287 , p15_a5
2288 , p15_a6
2289 , p15_a7
2290 , p15_a8
2291 , p15_a9
2292 , p15_a10
2293 , p15_a11
2294 , p15_a12
2295 , p15_a13
2296 , p15_a14
2297 , p15_a15
2298 , p15_a16
2299 , p15_a17
2300 , p15_a18
2301 , p15_a19
2302 , p15_a20
2303 , p15_a21
2304 , p15_a22
2305 , p15_a23
2306 , p15_a24
2307 , p15_a25
2308 , p15_a26
2309 );
2310
2311
2312
2313 end;
2314
2315 procedure get_assign_esc_resources(p_api_version NUMBER
2316 , p_init_msg_list VARCHAR2
2317 , p_resource_type VARCHAR2
2321 , p_effort_duration NUMBER
2318 , p_role VARCHAR2
2319 , p_no_of_resources NUMBER
2320 , p_auto_select_flag VARCHAR2
2322 , p_effort_uom VARCHAR2
2323 , p_start_date date
2324 , p_end_date date
2325 , p_territory_flag VARCHAR2
2326 , p_calendar_flag VARCHAR2
2327 , p_web_availability_flag VARCHAR2
2328 , p13_a0 JTF_NUMBER_TABLE
2329 , p13_a1 JTF_VARCHAR2_TABLE_100
2330 , p_business_process_id NUMBER
2331 , p_business_process_date date
2332 , p16_a0 out nocopy JTF_NUMBER_TABLE
2333 , p16_a1 out nocopy JTF_NUMBER_TABLE
2334 , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
2335 , p16_a3 out nocopy JTF_VARCHAR2_TABLE_100
2336 , p16_a4 out nocopy JTF_DATE_TABLE
2337 , p16_a5 out nocopy JTF_DATE_TABLE
2338 , p16_a6 out nocopy JTF_NUMBER_TABLE
2339 , p16_a7 out nocopy JTF_NUMBER_TABLE
2340 , p16_a8 out nocopy JTF_VARCHAR2_TABLE_300
2341 , p16_a9 out nocopy JTF_NUMBER_TABLE
2342 , p16_a10 out nocopy JTF_NUMBER_TABLE
2343 , p16_a11 out nocopy JTF_VARCHAR2_TABLE_100
2344 , p16_a12 out nocopy JTF_VARCHAR2_TABLE_100
2345 , p16_a13 out nocopy JTF_VARCHAR2_TABLE_100
2346 , p16_a14 out nocopy JTF_VARCHAR2_TABLE_100
2347 , p16_a15 out nocopy JTF_NUMBER_TABLE
2348 , p16_a16 out nocopy JTF_VARCHAR2_TABLE_100
2349 , p16_a17 out nocopy JTF_NUMBER_TABLE
2350 , p16_a18 out nocopy JTF_VARCHAR2_TABLE_100
2351 , p16_a19 out nocopy JTF_DATE_TABLE
2352 , p16_a20 out nocopy JTF_DATE_TABLE
2353 , p16_a21 out nocopy JTF_NUMBER_TABLE
2354 , p16_a22 out nocopy JTF_VARCHAR2_TABLE_200
2355 , p16_a23 out nocopy JTF_VARCHAR2_TABLE_100
2356 , p16_a24 out nocopy JTF_NUMBER_TABLE
2357 , p16_a25 out nocopy JTF_VARCHAR2_TABLE_100
2358 , p16_a26 out nocopy JTF_VARCHAR2_TABLE_100
2359 , x_return_status out nocopy VARCHAR2
2360 , x_msg_count out nocopy NUMBER
2361 , x_msg_data out nocopy VARCHAR2
2362 )
2363
2364 as
2365 ddp_start_date date;
2366 ddp_end_date date;
2367 ddp_esc_tbl jtf_assign_pub.escalations_tbl_type;
2368 ddp_business_process_date date;
2369 ddx_assign_resources_tbl jtf_assign_pub.assignresources_tbl_type;
2370 ddindx binary_integer; indx binary_integer;
2371 begin
2372
2373 -- copy data to the local IN or IN-OUT args, if any
2374
2375
2376
2377
2378
2379
2380
2381
2382 ddp_start_date := rosetta_g_miss_date_in_map(p_start_date);
2383
2384 ddp_end_date := rosetta_g_miss_date_in_map(p_end_date);
2385
2386
2387
2388
2389 jtf_assign_pub_w.rosetta_table_copy_in_p28(ddp_esc_tbl, p13_a0
2390 , p13_a1
2391 );
2392
2393
2394 ddp_business_process_date := rosetta_g_miss_date_in_map(p_business_process_date);
2395
2396
2397
2398
2399
2400 -- here's the delegated call to the old PL/SQL routine
2401 jtf_assign_pub.get_assign_esc_resources(p_api_version,
2402 p_init_msg_list,
2403 p_resource_type,
2404 p_role,
2405 p_no_of_resources,
2406 p_auto_select_flag,
2407 p_effort_duration,
2408 p_effort_uom,
2409 ddp_start_date,
2410 ddp_end_date,
2411 p_territory_flag,
2412 p_calendar_flag,
2413 p_web_availability_flag,
2414 ddp_esc_tbl,
2415 p_business_process_id,
2416 ddp_business_process_date,
2417 ddx_assign_resources_tbl,
2418 x_return_status,
2419 x_msg_count,
2420 x_msg_data);
2421
2422 -- copy data back from the local variables to OUT or IN-OUT args, if any
2423
2424
2425
2426
2427
2428
2429
2430
2431
2432
2433
2434
2435
2436
2437
2438
2439 jtf_assign_pub_w.rosetta_table_copy_out_p11(ddx_assign_resources_tbl, p16_a0
2440 , p16_a1
2441 , p16_a2
2442 , p16_a3
2443 , p16_a4
2444 , p16_a5
2445 , p16_a6
2446 , p16_a7
2447 , p16_a8
2448 , p16_a9
2449 , p16_a10
2450 , p16_a11
2451 , p16_a12
2452 , p16_a13
2453 , p16_a14
2454 , p16_a15
2455 , p16_a16
2456 , p16_a17
2457 , p16_a18
2458 , p16_a19
2459 , p16_a20
2460 , p16_a21
2461 , p16_a22
2462 , p16_a23
2463 , p16_a24
2464 , p16_a25
2465 , p16_a26
2466 );
2467
2468
2469
2470 end;
2471
2472 procedure get_excluded_resources(p_api_version NUMBER
2473 , p_init_msg_list VARCHAR2
2474 , p_commit VARCHAR2
2475 , p_contract_id NUMBER
2476 , p_customer_product_id NUMBER
2477 , p_calling_doc_id NUMBER
2478 , p_calling_doc_type VARCHAR2
2479 , p_business_process_id NUMBER
2480 , p_business_process_date date
2481 , p12_a0 out nocopy JTF_NUMBER_TABLE
2482 , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
2483 , x_return_status out nocopy VARCHAR2
2484 , x_msg_count out nocopy NUMBER
2485 , x_msg_data out nocopy VARCHAR2
2486 , p7_a0 NUMBER := 0-1962.0724
2487 , p7_a1 NUMBER := 0-1962.0724
2488 , p7_a2 VARCHAR2 := fnd_api.g_miss_char
2489 , p7_a3 NUMBER := 0-1962.0724
2490 , p7_a4 VARCHAR2 := fnd_api.g_miss_char
2491 , p7_a5 VARCHAR2 := fnd_api.g_miss_char
2492 , p7_a6 VARCHAR2 := fnd_api.g_miss_char
2496 , p7_a10 VARCHAR2 := fnd_api.g_miss_char
2493 , p7_a7 VARCHAR2 := fnd_api.g_miss_char
2494 , p7_a8 VARCHAR2 := fnd_api.g_miss_char
2495 , p7_a9 VARCHAR2 := fnd_api.g_miss_char
2497 , p7_a11 NUMBER := 0-1962.0724
2498 , p7_a12 NUMBER := 0-1962.0724
2499 , p7_a13 NUMBER := 0-1962.0724
2500 , p7_a14 NUMBER := 0-1962.0724
2501 , p7_a15 VARCHAR2 := fnd_api.g_miss_char
2502 , p7_a16 NUMBER := 0-1962.0724
2503 , p7_a17 NUMBER := 0-1962.0724
2504 , p7_a18 NUMBER := 0-1962.0724
2505 , p7_a19 NUMBER := 0-1962.0724
2506 , p7_a20 VARCHAR2 := fnd_api.g_miss_char
2507 , p7_a21 NUMBER := 0-1962.0724
2508 , p7_a22 VARCHAR2 := fnd_api.g_miss_char
2509 , p7_a23 VARCHAR2 := fnd_api.g_miss_char
2510 , p7_a24 VARCHAR2 := fnd_api.g_miss_char
2511 , p7_a25 VARCHAR2 := fnd_api.g_miss_char
2512 , p7_a26 VARCHAR2 := fnd_api.g_miss_char
2513 , p7_a27 VARCHAR2 := fnd_api.g_miss_char
2514 , p7_a28 VARCHAR2 := fnd_api.g_miss_char
2515 , p7_a29 VARCHAR2 := fnd_api.g_miss_char
2516 , p7_a30 VARCHAR2 := fnd_api.g_miss_char
2517 , p7_a31 VARCHAR2 := fnd_api.g_miss_char
2518 , p7_a32 VARCHAR2 := fnd_api.g_miss_char
2519 , p7_a33 VARCHAR2 := fnd_api.g_miss_char
2520 , p7_a34 VARCHAR2 := fnd_api.g_miss_char
2521 , p7_a35 VARCHAR2 := fnd_api.g_miss_char
2522 , p7_a36 VARCHAR2 := fnd_api.g_miss_char
2523 , p7_a37 NUMBER := 0-1962.0724
2524 , p7_a38 NUMBER := 0-1962.0724
2525 , p7_a39 NUMBER := 0-1962.0724
2526 , p7_a40 NUMBER := 0-1962.0724
2527 , p7_a41 NUMBER := 0-1962.0724
2528 , p7_a42 NUMBER := 0-1962.0724
2529 , p7_a43 NUMBER := 0-1962.0724
2530 , p7_a44 NUMBER := 0-1962.0724
2531 , p7_a45 NUMBER := 0-1962.0724
2532 , p7_a46 NUMBER := 0-1962.0724
2533 , p7_a47 VARCHAR2 := fnd_api.g_miss_char
2534 , p7_a48 VARCHAR2 := fnd_api.g_miss_char
2535 , p7_a49 VARCHAR2 := fnd_api.g_miss_char
2536 , p7_a50 VARCHAR2 := fnd_api.g_miss_char
2537 , p7_a51 VARCHAR2 := fnd_api.g_miss_char
2538 , p7_a52 NUMBER := 0-1962.0724
2539 , p7_a53 NUMBER := 0-1962.0724
2540 , p8_a0 NUMBER := 0-1962.0724
2541 , p8_a1 NUMBER := 0-1962.0724
2542 , p8_a2 NUMBER := 0-1962.0724
2543 , p8_a3 VARCHAR2 := fnd_api.g_miss_char
2544 , p8_a4 NUMBER := 0-1962.0724
2545 , p8_a5 VARCHAR2 := fnd_api.g_miss_char
2546 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
2547 , p8_a7 VARCHAR2 := fnd_api.g_miss_char
2548 , p8_a8 VARCHAR2 := fnd_api.g_miss_char
2549 , p8_a9 VARCHAR2 := fnd_api.g_miss_char
2550 , p8_a10 VARCHAR2 := fnd_api.g_miss_char
2551 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
2552 , p8_a12 NUMBER := 0-1962.0724
2553 , p8_a13 NUMBER := 0-1962.0724
2554 , p8_a14 NUMBER := 0-1962.0724
2555 , p8_a15 NUMBER := 0-1962.0724
2556 , p8_a16 NUMBER := 0-1962.0724
2557 , p8_a17 NUMBER := 0-1962.0724
2558 , p8_a18 NUMBER := 0-1962.0724
2559 , p8_a19 VARCHAR2 := fnd_api.g_miss_char
2560 , p8_a20 NUMBER := 0-1962.0724
2561 , p8_a21 NUMBER := 0-1962.0724
2562 , p8_a22 NUMBER := 0-1962.0724
2563 , p8_a23 NUMBER := 0-1962.0724
2564 , p8_a24 VARCHAR2 := fnd_api.g_miss_char
2565 , p8_a25 NUMBER := 0-1962.0724
2566 , p8_a26 VARCHAR2 := fnd_api.g_miss_char
2567 , p8_a27 VARCHAR2 := fnd_api.g_miss_char
2568 , p8_a28 VARCHAR2 := fnd_api.g_miss_char
2569 , p8_a29 VARCHAR2 := fnd_api.g_miss_char
2570 , p8_a30 VARCHAR2 := fnd_api.g_miss_char
2571 , p8_a31 VARCHAR2 := fnd_api.g_miss_char
2572 , p8_a32 VARCHAR2 := fnd_api.g_miss_char
2573 , p8_a33 VARCHAR2 := fnd_api.g_miss_char
2574 , p8_a34 VARCHAR2 := fnd_api.g_miss_char
2575 , p8_a35 VARCHAR2 := fnd_api.g_miss_char
2576 , p8_a36 VARCHAR2 := fnd_api.g_miss_char
2577 , p8_a37 VARCHAR2 := fnd_api.g_miss_char
2578 , p8_a38 VARCHAR2 := fnd_api.g_miss_char
2579 , p8_a39 VARCHAR2 := fnd_api.g_miss_char
2580 , p8_a40 VARCHAR2 := fnd_api.g_miss_char
2581 , p8_a41 NUMBER := 0-1962.0724
2582 , p8_a42 NUMBER := 0-1962.0724
2583 , p8_a43 NUMBER := 0-1962.0724
2584 , p8_a44 NUMBER := 0-1962.0724
2585 , p8_a45 NUMBER := 0-1962.0724
2586 , p8_a46 NUMBER := 0-1962.0724
2587 , p8_a47 NUMBER := 0-1962.0724
2588 , p8_a48 NUMBER := 0-1962.0724
2589 , p8_a49 NUMBER := 0-1962.0724
2590 , p8_a50 NUMBER := 0-1962.0724
2591 , p8_a51 VARCHAR2 := fnd_api.g_miss_char
2592 , p8_a52 VARCHAR2 := fnd_api.g_miss_char
2593 , p8_a53 VARCHAR2 := fnd_api.g_miss_char
2594 , p8_a54 VARCHAR2 := fnd_api.g_miss_char
2595 , p8_a55 VARCHAR2 := fnd_api.g_miss_char
2596 , p8_a56 NUMBER := 0-1962.0724
2597 , p8_a57 NUMBER := 0-1962.0724
2598 , p9_a0 NUMBER := 0-1962.0724
2599 , p9_a1 NUMBER := 0-1962.0724
2600 , p9_a2 NUMBER := 0-1962.0724
2601 , p9_a3 VARCHAR2 := fnd_api.g_miss_char
2602 , p9_a4 NUMBER := 0-1962.0724
2603 , p9_a5 VARCHAR2 := fnd_api.g_miss_char
2604 , p9_a6 VARCHAR2 := fnd_api.g_miss_char
2605 , p9_a7 VARCHAR2 := fnd_api.g_miss_char
2606 , p9_a8 VARCHAR2 := fnd_api.g_miss_char
2607 , p9_a9 VARCHAR2 := fnd_api.g_miss_char
2608 , p9_a10 VARCHAR2 := fnd_api.g_miss_char
2609 , p9_a11 VARCHAR2 := fnd_api.g_miss_char
2610 , p9_a12 NUMBER := 0-1962.0724
2611 , p9_a13 NUMBER := 0-1962.0724
2612 , p9_a14 NUMBER := 0-1962.0724
2613 , p9_a15 NUMBER := 0-1962.0724
2614 , p9_a16 NUMBER := 0-1962.0724
2615 , p9_a17 NUMBER := 0-1962.0724
2616 , p9_a18 NUMBER := 0-1962.0724
2617 , p9_a19 VARCHAR2 := fnd_api.g_miss_char
2621 , p9_a23 NUMBER := 0-1962.0724
2618 , p9_a20 NUMBER := 0-1962.0724
2619 , p9_a21 NUMBER := 0-1962.0724
2620 , p9_a22 NUMBER := 0-1962.0724
2622 , p9_a24 VARCHAR2 := fnd_api.g_miss_char
2623 , p9_a25 NUMBER := 0-1962.0724
2624 , p9_a26 VARCHAR2 := fnd_api.g_miss_char
2625 , p9_a27 VARCHAR2 := fnd_api.g_miss_char
2626 , p9_a28 VARCHAR2 := fnd_api.g_miss_char
2627 , p9_a29 VARCHAR2 := fnd_api.g_miss_char
2628 , p9_a30 VARCHAR2 := fnd_api.g_miss_char
2629 , p9_a31 VARCHAR2 := fnd_api.g_miss_char
2630 , p9_a32 VARCHAR2 := fnd_api.g_miss_char
2631 , p9_a33 VARCHAR2 := fnd_api.g_miss_char
2632 , p9_a34 VARCHAR2 := fnd_api.g_miss_char
2633 , p9_a35 VARCHAR2 := fnd_api.g_miss_char
2634 , p9_a36 VARCHAR2 := fnd_api.g_miss_char
2635 , p9_a37 VARCHAR2 := fnd_api.g_miss_char
2636 , p9_a38 VARCHAR2 := fnd_api.g_miss_char
2637 , p9_a39 VARCHAR2 := fnd_api.g_miss_char
2638 , p9_a40 VARCHAR2 := fnd_api.g_miss_char
2639 , p9_a41 NUMBER := 0-1962.0724
2640 , p9_a42 NUMBER := 0-1962.0724
2641 , p9_a43 NUMBER := 0-1962.0724
2642 , p9_a44 NUMBER := 0-1962.0724
2643 , p9_a45 NUMBER := 0-1962.0724
2644 , p9_a46 NUMBER := 0-1962.0724
2645 , p9_a47 NUMBER := 0-1962.0724
2646 , p9_a48 NUMBER := 0-1962.0724
2647 , p9_a49 NUMBER := 0-1962.0724
2648 , p9_a50 NUMBER := 0-1962.0724
2649 , p9_a51 VARCHAR2 := fnd_api.g_miss_char
2650 , p9_a52 VARCHAR2 := fnd_api.g_miss_char
2651 , p9_a53 VARCHAR2 := fnd_api.g_miss_char
2652 , p9_a54 VARCHAR2 := fnd_api.g_miss_char
2653 , p9_a55 VARCHAR2 := fnd_api.g_miss_char
2654 )
2655
2656 as
2657 ddp_sr_rec jtf_assign_pub.jtf_serv_req_rec_type;
2658 ddp_sr_task_rec jtf_assign_pub.jtf_srv_task_rec_type;
2659 ddp_dr_rec jtf_assign_pub.jtf_dr_rec_type;
2660 ddp_business_process_date date;
2661 ddx_excluded_resouurce_tbl jtf_assign_pub.excluded_tbl_type;
2662 ddindx binary_integer; indx binary_integer;
2663 begin
2664
2665 -- copy data to the local IN or IN-OUT args, if any
2666
2667
2668
2669
2670
2671
2672
2673 ddp_sr_rec.service_request_id := rosetta_g_miss_num_map(p7_a0);
2674 ddp_sr_rec.party_id := rosetta_g_miss_num_map(p7_a1);
2675 ddp_sr_rec.country := p7_a2;
2676 ddp_sr_rec.party_site_id := rosetta_g_miss_num_map(p7_a3);
2677 ddp_sr_rec.city := p7_a4;
2678 ddp_sr_rec.postal_code := p7_a5;
2679 ddp_sr_rec.state := p7_a6;
2680 ddp_sr_rec.area_code := p7_a7;
2681 ddp_sr_rec.county := p7_a8;
2682 ddp_sr_rec.comp_name_range := p7_a9;
2683 ddp_sr_rec.province := p7_a10;
2684 ddp_sr_rec.num_of_employees := rosetta_g_miss_num_map(p7_a11);
2685 ddp_sr_rec.incident_type_id := rosetta_g_miss_num_map(p7_a12);
2686 ddp_sr_rec.incident_severity_id := rosetta_g_miss_num_map(p7_a13);
2687 ddp_sr_rec.incident_urgency_id := rosetta_g_miss_num_map(p7_a14);
2688 ddp_sr_rec.problem_code := p7_a15;
2689 ddp_sr_rec.incident_status_id := rosetta_g_miss_num_map(p7_a16);
2690 ddp_sr_rec.platform_id := rosetta_g_miss_num_map(p7_a17);
2691 ddp_sr_rec.support_site_id := rosetta_g_miss_num_map(p7_a18);
2692 ddp_sr_rec.customer_site_id := rosetta_g_miss_num_map(p7_a19);
2693 ddp_sr_rec.sr_creation_channel := p7_a20;
2694 ddp_sr_rec.inventory_item_id := rosetta_g_miss_num_map(p7_a21);
2695 ddp_sr_rec.attribute1 := p7_a22;
2696 ddp_sr_rec.attribute2 := p7_a23;
2697 ddp_sr_rec.attribute3 := p7_a24;
2698 ddp_sr_rec.attribute4 := p7_a25;
2699 ddp_sr_rec.attribute5 := p7_a26;
2700 ddp_sr_rec.attribute6 := p7_a27;
2701 ddp_sr_rec.attribute7 := p7_a28;
2702 ddp_sr_rec.attribute8 := p7_a29;
2703 ddp_sr_rec.attribute9 := p7_a30;
2704 ddp_sr_rec.attribute10 := p7_a31;
2705 ddp_sr_rec.attribute11 := p7_a32;
2706 ddp_sr_rec.attribute12 := p7_a33;
2707 ddp_sr_rec.attribute13 := p7_a34;
2708 ddp_sr_rec.attribute14 := p7_a35;
2709 ddp_sr_rec.attribute15 := p7_a36;
2710 ddp_sr_rec.organization_id := rosetta_g_miss_num_map(p7_a37);
2711 ddp_sr_rec.squal_num12 := rosetta_g_miss_num_map(p7_a38);
2712 ddp_sr_rec.squal_num13 := rosetta_g_miss_num_map(p7_a39);
2713 ddp_sr_rec.squal_num14 := rosetta_g_miss_num_map(p7_a40);
2714 ddp_sr_rec.squal_num15 := rosetta_g_miss_num_map(p7_a41);
2715 ddp_sr_rec.squal_num16 := rosetta_g_miss_num_map(p7_a42);
2716 ddp_sr_rec.squal_num17 := rosetta_g_miss_num_map(p7_a43);
2717 ddp_sr_rec.squal_num18 := rosetta_g_miss_num_map(p7_a44);
2718 ddp_sr_rec.squal_num19 := rosetta_g_miss_num_map(p7_a45);
2719 ddp_sr_rec.squal_num30 := rosetta_g_miss_num_map(p7_a46);
2720 ddp_sr_rec.squal_char11 := p7_a47;
2721 ddp_sr_rec.squal_char12 := p7_a48;
2722 ddp_sr_rec.squal_char13 := p7_a49;
2723 ddp_sr_rec.squal_char20 := p7_a50;
2724 ddp_sr_rec.squal_char21 := p7_a51;
2725 ddp_sr_rec.item_component := rosetta_g_miss_num_map(p7_a52);
2726 ddp_sr_rec.item_subcomponent := rosetta_g_miss_num_map(p7_a53);
2727
2728 ddp_sr_task_rec.task_id := rosetta_g_miss_num_map(p8_a0);
2729 ddp_sr_task_rec.service_request_id := rosetta_g_miss_num_map(p8_a1);
2730 ddp_sr_task_rec.party_id := rosetta_g_miss_num_map(p8_a2);
2731 ddp_sr_task_rec.country := p8_a3;
2732 ddp_sr_task_rec.party_site_id := rosetta_g_miss_num_map(p8_a4);
2733 ddp_sr_task_rec.city := p8_a5;
2734 ddp_sr_task_rec.postal_code := p8_a6;
2735 ddp_sr_task_rec.state := p8_a7;
2736 ddp_sr_task_rec.area_code := p8_a8;
2737 ddp_sr_task_rec.county := p8_a9;
2738 ddp_sr_task_rec.comp_name_range := p8_a10;
2739 ddp_sr_task_rec.province := p8_a11;
2740 ddp_sr_task_rec.num_of_employees := rosetta_g_miss_num_map(p8_a12);
2741 ddp_sr_task_rec.task_type_id := rosetta_g_miss_num_map(p8_a13);
2745 ddp_sr_task_rec.incident_severity_id := rosetta_g_miss_num_map(p8_a17);
2742 ddp_sr_task_rec.task_status_id := rosetta_g_miss_num_map(p8_a14);
2743 ddp_sr_task_rec.task_priority_id := rosetta_g_miss_num_map(p8_a15);
2744 ddp_sr_task_rec.incident_type_id := rosetta_g_miss_num_map(p8_a16);
2746 ddp_sr_task_rec.incident_urgency_id := rosetta_g_miss_num_map(p8_a18);
2747 ddp_sr_task_rec.problem_code := p8_a19;
2748 ddp_sr_task_rec.incident_status_id := rosetta_g_miss_num_map(p8_a20);
2749 ddp_sr_task_rec.platform_id := rosetta_g_miss_num_map(p8_a21);
2750 ddp_sr_task_rec.support_site_id := rosetta_g_miss_num_map(p8_a22);
2751 ddp_sr_task_rec.customer_site_id := rosetta_g_miss_num_map(p8_a23);
2752 ddp_sr_task_rec.sr_creation_channel := p8_a24;
2753 ddp_sr_task_rec.inventory_item_id := rosetta_g_miss_num_map(p8_a25);
2754 ddp_sr_task_rec.attribute1 := p8_a26;
2755 ddp_sr_task_rec.attribute2 := p8_a27;
2756 ddp_sr_task_rec.attribute3 := p8_a28;
2757 ddp_sr_task_rec.attribute4 := p8_a29;
2758 ddp_sr_task_rec.attribute5 := p8_a30;
2759 ddp_sr_task_rec.attribute6 := p8_a31;
2760 ddp_sr_task_rec.attribute7 := p8_a32;
2761 ddp_sr_task_rec.attribute8 := p8_a33;
2762 ddp_sr_task_rec.attribute9 := p8_a34;
2763 ddp_sr_task_rec.attribute10 := p8_a35;
2764 ddp_sr_task_rec.attribute11 := p8_a36;
2765 ddp_sr_task_rec.attribute12 := p8_a37;
2766 ddp_sr_task_rec.attribute13 := p8_a38;
2767 ddp_sr_task_rec.attribute14 := p8_a39;
2768 ddp_sr_task_rec.attribute15 := p8_a40;
2769 ddp_sr_task_rec.organization_id := rosetta_g_miss_num_map(p8_a41);
2770 ddp_sr_task_rec.squal_num12 := rosetta_g_miss_num_map(p8_a42);
2771 ddp_sr_task_rec.squal_num13 := rosetta_g_miss_num_map(p8_a43);
2772 ddp_sr_task_rec.squal_num14 := rosetta_g_miss_num_map(p8_a44);
2773 ddp_sr_task_rec.squal_num15 := rosetta_g_miss_num_map(p8_a45);
2774 ddp_sr_task_rec.squal_num16 := rosetta_g_miss_num_map(p8_a46);
2775 ddp_sr_task_rec.squal_num17 := rosetta_g_miss_num_map(p8_a47);
2776 ddp_sr_task_rec.squal_num18 := rosetta_g_miss_num_map(p8_a48);
2777 ddp_sr_task_rec.squal_num19 := rosetta_g_miss_num_map(p8_a49);
2778 ddp_sr_task_rec.squal_num30 := rosetta_g_miss_num_map(p8_a50);
2779 ddp_sr_task_rec.squal_char11 := p8_a51;
2780 ddp_sr_task_rec.squal_char12 := p8_a52;
2781 ddp_sr_task_rec.squal_char13 := p8_a53;
2782 ddp_sr_task_rec.squal_char20 := p8_a54;
2783 ddp_sr_task_rec.squal_char21 := p8_a55;
2784 ddp_sr_task_rec.item_component := rosetta_g_miss_num_map(p8_a56);
2785 ddp_sr_task_rec.item_subcomponent := rosetta_g_miss_num_map(p8_a57);
2786
2787 ddp_dr_rec.task_id := rosetta_g_miss_num_map(p9_a0);
2788 ddp_dr_rec.service_request_id := rosetta_g_miss_num_map(p9_a1);
2789 ddp_dr_rec.party_id := rosetta_g_miss_num_map(p9_a2);
2790 ddp_dr_rec.country := p9_a3;
2791 ddp_dr_rec.party_site_id := rosetta_g_miss_num_map(p9_a4);
2792 ddp_dr_rec.city := p9_a5;
2793 ddp_dr_rec.postal_code := p9_a6;
2794 ddp_dr_rec.state := p9_a7;
2795 ddp_dr_rec.area_code := p9_a8;
2796 ddp_dr_rec.county := p9_a9;
2797 ddp_dr_rec.comp_name_range := p9_a10;
2798 ddp_dr_rec.province := p9_a11;
2799 ddp_dr_rec.num_of_employees := rosetta_g_miss_num_map(p9_a12);
2800 ddp_dr_rec.task_type_id := rosetta_g_miss_num_map(p9_a13);
2801 ddp_dr_rec.task_status_id := rosetta_g_miss_num_map(p9_a14);
2802 ddp_dr_rec.task_priority_id := rosetta_g_miss_num_map(p9_a15);
2803 ddp_dr_rec.incident_type_id := rosetta_g_miss_num_map(p9_a16);
2804 ddp_dr_rec.incident_severity_id := rosetta_g_miss_num_map(p9_a17);
2805 ddp_dr_rec.incident_urgency_id := rosetta_g_miss_num_map(p9_a18);
2806 ddp_dr_rec.problem_code := p9_a19;
2807 ddp_dr_rec.incident_status_id := rosetta_g_miss_num_map(p9_a20);
2808 ddp_dr_rec.platform_id := rosetta_g_miss_num_map(p9_a21);
2809 ddp_dr_rec.support_site_id := rosetta_g_miss_num_map(p9_a22);
2810 ddp_dr_rec.customer_site_id := rosetta_g_miss_num_map(p9_a23);
2811 ddp_dr_rec.sr_creation_channel := p9_a24;
2812 ddp_dr_rec.inventory_item_id := rosetta_g_miss_num_map(p9_a25);
2813 ddp_dr_rec.attribute1 := p9_a26;
2814 ddp_dr_rec.attribute2 := p9_a27;
2815 ddp_dr_rec.attribute3 := p9_a28;
2816 ddp_dr_rec.attribute4 := p9_a29;
2817 ddp_dr_rec.attribute5 := p9_a30;
2818 ddp_dr_rec.attribute6 := p9_a31;
2819 ddp_dr_rec.attribute7 := p9_a32;
2820 ddp_dr_rec.attribute8 := p9_a33;
2821 ddp_dr_rec.attribute9 := p9_a34;
2822 ddp_dr_rec.attribute10 := p9_a35;
2823 ddp_dr_rec.attribute11 := p9_a36;
2824 ddp_dr_rec.attribute12 := p9_a37;
2825 ddp_dr_rec.attribute13 := p9_a38;
2826 ddp_dr_rec.attribute14 := p9_a39;
2827 ddp_dr_rec.attribute15 := p9_a40;
2828 ddp_dr_rec.organization_id := rosetta_g_miss_num_map(p9_a41);
2829 ddp_dr_rec.squal_num12 := rosetta_g_miss_num_map(p9_a42);
2830 ddp_dr_rec.squal_num13 := rosetta_g_miss_num_map(p9_a43);
2831 ddp_dr_rec.squal_num14 := rosetta_g_miss_num_map(p9_a44);
2832 ddp_dr_rec.squal_num15 := rosetta_g_miss_num_map(p9_a45);
2833 ddp_dr_rec.squal_num16 := rosetta_g_miss_num_map(p9_a46);
2834 ddp_dr_rec.squal_num17 := rosetta_g_miss_num_map(p9_a47);
2835 ddp_dr_rec.squal_num18 := rosetta_g_miss_num_map(p9_a48);
2836 ddp_dr_rec.squal_num19 := rosetta_g_miss_num_map(p9_a49);
2837 ddp_dr_rec.squal_num30 := rosetta_g_miss_num_map(p9_a50);
2838 ddp_dr_rec.squal_char11 := p9_a51;
2839 ddp_dr_rec.squal_char12 := p9_a52;
2840 ddp_dr_rec.squal_char13 := p9_a53;
2841 ddp_dr_rec.squal_char20 := p9_a54;
2842 ddp_dr_rec.squal_char21 := p9_a55;
2843
2844
2845 ddp_business_process_date := rosetta_g_miss_date_in_map(p_business_process_date);
2846
2847
2848
2849
2850
2851 -- here's the delegated call to the old PL/SQL routine
2852 jtf_assign_pub.get_excluded_resources(p_api_version,
2853 p_init_msg_list,
2854 p_commit,
2855 p_contract_id,
2859 ddp_sr_rec,
2856 p_customer_product_id,
2857 p_calling_doc_id,
2858 p_calling_doc_type,
2860 ddp_sr_task_rec,
2861 ddp_dr_rec,
2862 p_business_process_id,
2863 ddp_business_process_date,
2864 ddx_excluded_resouurce_tbl,
2865 x_return_status,
2866 x_msg_count,
2867 x_msg_data);
2868
2869 -- copy data back from the local variables to OUT or IN-OUT args, if any
2870
2871
2872
2873
2874
2875
2876
2877
2878
2879
2880
2881
2882 jtf_assign_pub_w.rosetta_table_copy_out_p30(ddx_excluded_resouurce_tbl, p12_a0
2883 , p12_a1
2884 );
2885
2886
2887
2888 end;
2889
2890 procedure get_resource_availability(p_api_version NUMBER
2891 , p_init_msg_list VARCHAR2
2892 , p_commit VARCHAR2
2893 , p_calendar_flag VARCHAR2
2894 , p_effort_duration NUMBER
2895 , p_effort_uom VARCHAR2
2896 , p_breakdown NUMBER
2897 , p_breakdown_uom VARCHAR2
2898 , p_planned_start_date date
2899 , p_planned_end_date date
2900 , p_continuous_task VARCHAR2
2901 , x_return_status in out nocopy VARCHAR2
2902 , x_msg_count in out nocopy NUMBER
2903 , x_msg_data in out nocopy VARCHAR2
2904 , p14_a0 in out nocopy JTF_NUMBER_TABLE
2905 , p14_a1 in out nocopy JTF_NUMBER_TABLE
2906 , p14_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2907 , p14_a3 in out nocopy JTF_VARCHAR2_TABLE_100
2908 , p14_a4 in out nocopy JTF_DATE_TABLE
2909 , p14_a5 in out nocopy JTF_DATE_TABLE
2910 , p14_a6 in out nocopy JTF_NUMBER_TABLE
2911 , p14_a7 in out nocopy JTF_NUMBER_TABLE
2912 , p14_a8 in out nocopy JTF_VARCHAR2_TABLE_300
2913 , p14_a9 in out nocopy JTF_NUMBER_TABLE
2914 , p14_a10 in out nocopy JTF_NUMBER_TABLE
2915 , p14_a11 in out nocopy JTF_VARCHAR2_TABLE_100
2916 , p14_a12 in out nocopy JTF_VARCHAR2_TABLE_100
2917 , p14_a13 in out nocopy JTF_VARCHAR2_TABLE_100
2918 , p14_a14 in out nocopy JTF_VARCHAR2_TABLE_100
2919 , p14_a15 in out nocopy JTF_NUMBER_TABLE
2920 , p14_a16 in out nocopy JTF_VARCHAR2_TABLE_100
2921 , p14_a17 in out nocopy JTF_NUMBER_TABLE
2922 , p14_a18 in out nocopy JTF_VARCHAR2_TABLE_100
2923 , p14_a19 in out nocopy JTF_DATE_TABLE
2924 , p14_a20 in out nocopy JTF_DATE_TABLE
2925 , p14_a21 in out nocopy JTF_NUMBER_TABLE
2926 , p14_a22 in out nocopy JTF_VARCHAR2_TABLE_200
2927 , p14_a23 in out nocopy JTF_VARCHAR2_TABLE_100
2928 , p14_a24 in out nocopy JTF_NUMBER_TABLE
2929 , p14_a25 in out nocopy JTF_VARCHAR2_TABLE_100
2930 , p14_a26 in out nocopy JTF_VARCHAR2_TABLE_100
2931 )
2932
2933 as
2934 ddp_planned_start_date date;
2935 ddp_planned_end_date date;
2936 ddx_assign_resources_tbl jtf_assign_pub.assignresources_tbl_type;
2937 ddindx binary_integer; indx binary_integer;
2938 begin
2939
2940 -- copy data to the local IN or IN-OUT args, if any
2941
2942
2943
2944
2945
2946
2947
2948
2949 ddp_planned_start_date := rosetta_g_miss_date_in_map(p_planned_start_date);
2950
2951 ddp_planned_end_date := rosetta_g_miss_date_in_map(p_planned_end_date);
2952
2953
2954
2955
2956
2957 jtf_assign_pub_w.rosetta_table_copy_in_p11(ddx_assign_resources_tbl, p14_a0
2958 , p14_a1
2959 , p14_a2
2960 , p14_a3
2961 , p14_a4
2962 , p14_a5
2963 , p14_a6
2964 , p14_a7
2965 , p14_a8
2966 , p14_a9
2967 , p14_a10
2968 , p14_a11
2969 , p14_a12
2970 , p14_a13
2971 , p14_a14
2972 , p14_a15
2973 , p14_a16
2974 , p14_a17
2975 , p14_a18
2976 , p14_a19
2977 , p14_a20
2978 , p14_a21
2979 , p14_a22
2980 , p14_a23
2981 , p14_a24
2982 , p14_a25
2983 , p14_a26
2984 );
2985
2986 -- here's the delegated call to the old PL/SQL routine
2987 jtf_assign_pub.get_resource_availability(p_api_version,
2988 p_init_msg_list,
2989 p_commit,
2990 p_calendar_flag,
2991 p_effort_duration,
2992 p_effort_uom,
2993 p_breakdown,
2994 p_breakdown_uom,
2995 ddp_planned_start_date,
2996 ddp_planned_end_date,
2997 p_continuous_task,
2998 x_return_status,
2999 x_msg_count,
3000 x_msg_data,
3001 ddx_assign_resources_tbl);
3002
3003 -- copy data back from the local variables to OUT or IN-OUT args, if any
3004
3005
3006
3007
3008
3009
3010
3011
3012
3013
3014
3015
3016
3017
3018 jtf_assign_pub_w.rosetta_table_copy_out_p11(ddx_assign_resources_tbl, p14_a0
3019 , p14_a1
3020 , p14_a2
3021 , p14_a3
3022 , p14_a4
3023 , p14_a5
3024 , p14_a6
3025 , p14_a7
3026 , p14_a8
3027 , p14_a9
3028 , p14_a10
3029 , p14_a11
3030 , p14_a12
3031 , p14_a13
3032 , p14_a14
3033 , p14_a15
3034 , p14_a16
3035 , p14_a17
3036 , p14_a18
3037 , p14_a19
3038 , p14_a20
3039 , p14_a21
3040 , p14_a22
3041 , p14_a23
3042 , p14_a24
3043 , p14_a25
3044 , p14_a26
3045 );
3046 end;
3047
3048 end jtf_assign_pub_w;