[Home] [Help]
PACKAGE BODY: APPS.AS_OPPORTUNITY_PUB_W3
Source
1 package body as_opportunity_pub_w3 as
2 /* $Header: asxwop3b.pls 120.1 2005/08/04 03:06 appldev 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 update_competitors(p_api_version_number NUMBER
23 , p_init_msg_list VARCHAR2
24 , p_commit VARCHAR2
25 , p_validation_level NUMBER
26 , p_identity_salesforce_id NUMBER
27 , p5_a0 JTF_DATE_TABLE
28 , p5_a1 JTF_NUMBER_TABLE
29 , p5_a2 JTF_DATE_TABLE
30 , p5_a3 JTF_NUMBER_TABLE
31 , p5_a4 JTF_NUMBER_TABLE
32 , p5_a5 JTF_NUMBER_TABLE
33 , p5_a6 JTF_NUMBER_TABLE
34 , p5_a7 JTF_NUMBER_TABLE
35 , p5_a8 JTF_DATE_TABLE
36 , p5_a9 JTF_NUMBER_TABLE
37 , p5_a10 JTF_VARCHAR2_TABLE_100
38 , p5_a11 JTF_NUMBER_TABLE
39 , p5_a12 JTF_NUMBER_TABLE
40 , p5_a13 JTF_NUMBER_TABLE
41 , p5_a14 JTF_VARCHAR2_TABLE_100
42 , p5_a15 JTF_VARCHAR2_TABLE_300
43 , p5_a16 JTF_NUMBER_TABLE
44 , p5_a17 JTF_VARCHAR2_TABLE_100
45 , p5_a18 JTF_VARCHAR2_TABLE_100
46 , p5_a19 JTF_VARCHAR2_TABLE_300
47 , p5_a20 JTF_VARCHAR2_TABLE_100
48 , p5_a21 JTF_VARCHAR2_TABLE_100
49 , p5_a22 JTF_NUMBER_TABLE
50 , p5_a23 JTF_VARCHAR2_TABLE_100
51 , p5_a24 JTF_VARCHAR2_TABLE_200
52 , p5_a25 JTF_VARCHAR2_TABLE_200
53 , p5_a26 JTF_VARCHAR2_TABLE_200
54 , p5_a27 JTF_VARCHAR2_TABLE_200
55 , p5_a28 JTF_VARCHAR2_TABLE_200
56 , p5_a29 JTF_VARCHAR2_TABLE_200
57 , p5_a30 JTF_VARCHAR2_TABLE_200
58 , p5_a31 JTF_VARCHAR2_TABLE_200
59 , p5_a32 JTF_VARCHAR2_TABLE_200
60 , p5_a33 JTF_VARCHAR2_TABLE_200
61 , p5_a34 JTF_VARCHAR2_TABLE_200
62 , p5_a35 JTF_VARCHAR2_TABLE_200
63 , p5_a36 JTF_VARCHAR2_TABLE_200
64 , p5_a37 JTF_VARCHAR2_TABLE_200
65 , p5_a38 JTF_VARCHAR2_TABLE_200
66 , p_check_access_flag VARCHAR2
67 , p_admin_flag VARCHAR2
68 , p_admin_group_id NUMBER
69 , p_partner_cont_party_id NUMBER
70 , p10_a0 JTF_VARCHAR2_TABLE_100
71 , p10_a1 JTF_VARCHAR2_TABLE_300
72 , p11_a0 out nocopy JTF_NUMBER_TABLE
73 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
74 , x_return_status out nocopy VARCHAR2
75 , x_msg_count out nocopy NUMBER
76 , x_msg_data out nocopy VARCHAR2
77 )
78
79 as
80 ddp_competitor_tbl as_opportunity_pub.competitor_tbl_type;
81 ddp_profile_tbl as_utility_pub.profile_tbl_type;
82 ddx_competitor_out_tbl as_opportunity_pub.competitor_out_tbl_type;
83 ddindx binary_integer; indx binary_integer;
84 begin
85
86 -- copy data to the local IN or IN-OUT args, if any
87
88
89
90
91
92 as_opportunity_pub_w.rosetta_table_copy_in_p26(ddp_competitor_tbl, p5_a0
93 , p5_a1
94 , p5_a2
95 , p5_a3
96 , p5_a4
97 , p5_a5
98 , p5_a6
99 , p5_a7
100 , p5_a8
101 , p5_a9
102 , p5_a10
103 , p5_a11
104 , p5_a12
105 , p5_a13
106 , p5_a14
107 , p5_a15
108 , p5_a16
109 , p5_a17
110 , p5_a18
111 , p5_a19
112 , p5_a20
113 , p5_a21
114 , p5_a22
115 , p5_a23
116 , p5_a24
117 , p5_a25
118 , p5_a26
119 , p5_a27
120 , p5_a28
121 , p5_a29
122 , p5_a30
123 , p5_a31
124 , p5_a32
125 , p5_a33
126 , p5_a34
127 , p5_a35
128 , p5_a36
129 , p5_a37
130 , p5_a38
131 );
132
133
134
135
136
137 as_utility_pub_w.rosetta_table_copy_in_p6(ddp_profile_tbl, p10_a0
138 , p10_a1
139 );
140
141
142
143
144
145 -- here's the delegated call to the old PL/SQL routine
146 as_opportunity_pub.update_competitors(p_api_version_number,
147 p_init_msg_list,
148 p_commit,
149 p_validation_level,
150 p_identity_salesforce_id,
151 ddp_competitor_tbl,
152 p_check_access_flag,
153 p_admin_flag,
154 p_admin_group_id,
155 p_partner_cont_party_id,
156 ddp_profile_tbl,
157 ddx_competitor_out_tbl,
158 x_return_status,
159 x_msg_count,
160 x_msg_data);
161
162 -- copy data back from the local variables to OUT or IN-OUT args, if any
163
164
165
166
167
168
169
170
171
172
173
174 as_opportunity_pub_w.rosetta_table_copy_out_p29(ddx_competitor_out_tbl, p11_a0
175 , p11_a1
176 );
177
178
179
180 end;
181
182 procedure delete_competitors(p_api_version_number NUMBER
183 , p_init_msg_list VARCHAR2
184 , p_commit VARCHAR2
185 , p_validation_level NUMBER
186 , p_identity_salesforce_id NUMBER
187 , p5_a0 JTF_DATE_TABLE
188 , p5_a1 JTF_NUMBER_TABLE
189 , p5_a2 JTF_DATE_TABLE
190 , p5_a3 JTF_NUMBER_TABLE
191 , p5_a4 JTF_NUMBER_TABLE
192 , p5_a5 JTF_NUMBER_TABLE
193 , p5_a6 JTF_NUMBER_TABLE
194 , p5_a7 JTF_NUMBER_TABLE
195 , p5_a8 JTF_DATE_TABLE
196 , p5_a9 JTF_NUMBER_TABLE
197 , p5_a10 JTF_VARCHAR2_TABLE_100
198 , p5_a11 JTF_NUMBER_TABLE
199 , p5_a12 JTF_NUMBER_TABLE
200 , p5_a13 JTF_NUMBER_TABLE
201 , p5_a14 JTF_VARCHAR2_TABLE_100
202 , p5_a15 JTF_VARCHAR2_TABLE_300
203 , p5_a16 JTF_NUMBER_TABLE
204 , p5_a17 JTF_VARCHAR2_TABLE_100
205 , p5_a18 JTF_VARCHAR2_TABLE_100
206 , p5_a19 JTF_VARCHAR2_TABLE_300
207 , p5_a20 JTF_VARCHAR2_TABLE_100
208 , p5_a21 JTF_VARCHAR2_TABLE_100
209 , p5_a22 JTF_NUMBER_TABLE
210 , p5_a23 JTF_VARCHAR2_TABLE_100
211 , p5_a24 JTF_VARCHAR2_TABLE_200
212 , p5_a25 JTF_VARCHAR2_TABLE_200
213 , p5_a26 JTF_VARCHAR2_TABLE_200
214 , p5_a27 JTF_VARCHAR2_TABLE_200
215 , p5_a28 JTF_VARCHAR2_TABLE_200
216 , p5_a29 JTF_VARCHAR2_TABLE_200
217 , p5_a30 JTF_VARCHAR2_TABLE_200
218 , p5_a31 JTF_VARCHAR2_TABLE_200
219 , p5_a32 JTF_VARCHAR2_TABLE_200
220 , p5_a33 JTF_VARCHAR2_TABLE_200
221 , p5_a34 JTF_VARCHAR2_TABLE_200
222 , p5_a35 JTF_VARCHAR2_TABLE_200
223 , p5_a36 JTF_VARCHAR2_TABLE_200
224 , p5_a37 JTF_VARCHAR2_TABLE_200
225 , p5_a38 JTF_VARCHAR2_TABLE_200
226 , p_check_access_flag VARCHAR2
227 , p_admin_flag VARCHAR2
228 , p_admin_group_id NUMBER
229 , p_partner_cont_party_id NUMBER
230 , p10_a0 JTF_VARCHAR2_TABLE_100
231 , p10_a1 JTF_VARCHAR2_TABLE_300
232 , p11_a0 out nocopy JTF_NUMBER_TABLE
233 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
234 , x_return_status out nocopy VARCHAR2
235 , x_msg_count out nocopy NUMBER
236 , x_msg_data out nocopy VARCHAR2
237 )
238
239 as
240 ddp_competitor_tbl as_opportunity_pub.competitor_tbl_type;
241 ddp_profile_tbl as_utility_pub.profile_tbl_type;
242 ddx_competitor_out_tbl as_opportunity_pub.competitor_out_tbl_type;
243 ddindx binary_integer; indx binary_integer;
244 begin
245
246 -- copy data to the local IN or IN-OUT args, if any
247
248
249
250
251
252 as_opportunity_pub_w.rosetta_table_copy_in_p26(ddp_competitor_tbl, p5_a0
253 , p5_a1
254 , p5_a2
255 , p5_a3
256 , p5_a4
257 , p5_a5
258 , p5_a6
259 , p5_a7
260 , p5_a8
261 , p5_a9
262 , p5_a10
263 , p5_a11
264 , p5_a12
265 , p5_a13
266 , p5_a14
267 , p5_a15
268 , p5_a16
269 , p5_a17
270 , p5_a18
271 , p5_a19
272 , p5_a20
273 , p5_a21
274 , p5_a22
275 , p5_a23
276 , p5_a24
277 , p5_a25
278 , p5_a26
279 , p5_a27
280 , p5_a28
281 , p5_a29
282 , p5_a30
283 , p5_a31
284 , p5_a32
285 , p5_a33
286 , p5_a34
287 , p5_a35
288 , p5_a36
289 , p5_a37
290 , p5_a38
291 );
292
293
294
295
296
297 as_utility_pub_w.rosetta_table_copy_in_p6(ddp_profile_tbl, p10_a0
298 , p10_a1
299 );
300
301
302
303
304
305 -- here's the delegated call to the old PL/SQL routine
306 as_opportunity_pub.delete_competitors(p_api_version_number,
307 p_init_msg_list,
308 p_commit,
309 p_validation_level,
310 p_identity_salesforce_id,
311 ddp_competitor_tbl,
312 p_check_access_flag,
313 p_admin_flag,
314 p_admin_group_id,
315 p_partner_cont_party_id,
316 ddp_profile_tbl,
317 ddx_competitor_out_tbl,
318 x_return_status,
319 x_msg_count,
320 x_msg_data);
321
322 -- copy data back from the local variables to OUT or IN-OUT args, if any
323
324
325
326
327
328
329
330
331
332
333
334 as_opportunity_pub_w.rosetta_table_copy_out_p29(ddx_competitor_out_tbl, p11_a0
335 , p11_a1
336 );
337
338
339
340 end;
341
342 procedure create_competitor_prods(p_api_version_number NUMBER
343 , p_init_msg_list VARCHAR2
344 , p_commit VARCHAR2
345 , p_validation_level NUMBER
346 , p_identity_salesforce_id NUMBER
347 , p5_a0 JTF_VARCHAR2_TABLE_200
348 , p5_a1 JTF_VARCHAR2_TABLE_200
349 , p5_a2 JTF_VARCHAR2_TABLE_200
350 , p5_a3 JTF_VARCHAR2_TABLE_200
351 , p5_a4 JTF_VARCHAR2_TABLE_200
352 , p5_a5 JTF_VARCHAR2_TABLE_200
353 , p5_a6 JTF_VARCHAR2_TABLE_200
354 , p5_a7 JTF_VARCHAR2_TABLE_200
355 , p5_a8 JTF_VARCHAR2_TABLE_200
356 , p5_a9 JTF_VARCHAR2_TABLE_200
357 , p5_a10 JTF_VARCHAR2_TABLE_200
358 , p5_a11 JTF_VARCHAR2_TABLE_200
359 , p5_a12 JTF_VARCHAR2_TABLE_200
360 , p5_a13 JTF_VARCHAR2_TABLE_200
361 , p5_a14 JTF_VARCHAR2_TABLE_200
362 , p5_a15 JTF_VARCHAR2_TABLE_100
363 , p5_a16 JTF_NUMBER_TABLE
364 , p5_a17 JTF_DATE_TABLE
365 , p5_a18 JTF_NUMBER_TABLE
366 , p5_a19 JTF_NUMBER_TABLE
367 , p5_a20 JTF_VARCHAR2_TABLE_100
368 , p5_a21 JTF_NUMBER_TABLE
369 , p5_a22 JTF_NUMBER_TABLE
370 , p5_a23 JTF_NUMBER_TABLE
371 , p5_a24 JTF_NUMBER_TABLE
372 , p5_a25 JTF_NUMBER_TABLE
373 , p5_a26 JTF_NUMBER_TABLE
374 , p5_a27 JTF_DATE_TABLE
375 , p5_a28 JTF_NUMBER_TABLE
376 , p5_a29 JTF_DATE_TABLE
377 , p_check_access_flag VARCHAR2
378 , p_admin_flag VARCHAR2
379 , p_admin_group_id NUMBER
380 , p_partner_cont_party_id NUMBER
381 , p10_a0 JTF_VARCHAR2_TABLE_100
382 , p10_a1 JTF_VARCHAR2_TABLE_300
383 , p11_a0 out nocopy JTF_NUMBER_TABLE
384 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
385 , x_return_status out nocopy VARCHAR2
386 , x_msg_count out nocopy NUMBER
387 , x_msg_data out nocopy VARCHAR2
388 )
389
390 as
391 ddp_competitor_prod_tbl as_opportunity_pub.competitor_prod_tbl_type;
392 ddp_profile_tbl as_utility_pub.profile_tbl_type;
393 ddx_competitor_prod_out_tbl as_opportunity_pub.competitor_prod_out_tbl_type;
394 ddindx binary_integer; indx binary_integer;
395 begin
396
397 -- copy data to the local IN or IN-OUT args, if any
398
399
400
401
402
403 as_opportunity_pub_w.rosetta_table_copy_in_p44(ddp_competitor_prod_tbl, p5_a0
404 , p5_a1
405 , p5_a2
406 , p5_a3
407 , p5_a4
408 , p5_a5
409 , p5_a6
410 , p5_a7
411 , p5_a8
412 , p5_a9
413 , p5_a10
414 , p5_a11
415 , p5_a12
416 , p5_a13
417 , p5_a14
418 , p5_a15
419 , p5_a16
420 , p5_a17
421 , p5_a18
422 , p5_a19
423 , p5_a20
424 , p5_a21
425 , p5_a22
426 , p5_a23
427 , p5_a24
428 , p5_a25
429 , p5_a26
430 , p5_a27
431 , p5_a28
432 , p5_a29
433 );
434
435
436
437
438
439 as_utility_pub_w.rosetta_table_copy_in_p6(ddp_profile_tbl, p10_a0
440 , p10_a1
441 );
442
443
444
445
446
447 -- here's the delegated call to the old PL/SQL routine
448 as_opportunity_pub.create_competitor_prods(p_api_version_number,
449 p_init_msg_list,
450 p_commit,
451 p_validation_level,
452 p_identity_salesforce_id,
453 ddp_competitor_prod_tbl,
454 p_check_access_flag,
455 p_admin_flag,
456 p_admin_group_id,
457 p_partner_cont_party_id,
458 ddp_profile_tbl,
459 ddx_competitor_prod_out_tbl,
460 x_return_status,
461 x_msg_count,
462 x_msg_data);
463
464 -- copy data back from the local variables to OUT or IN-OUT args, if any
465
466
467
468
469
470
471
472
473
474
475
476 as_opportunity_pub_w.rosetta_table_copy_out_p47(ddx_competitor_prod_out_tbl, p11_a0
477 , p11_a1
478 );
479
480
481
482 end;
483
484 procedure update_competitor_prods(p_api_version_number NUMBER
485 , p_init_msg_list VARCHAR2
486 , p_commit VARCHAR2
487 , p_validation_level NUMBER
488 , p_identity_salesforce_id NUMBER
489 , p5_a0 JTF_VARCHAR2_TABLE_200
490 , p5_a1 JTF_VARCHAR2_TABLE_200
491 , p5_a2 JTF_VARCHAR2_TABLE_200
492 , p5_a3 JTF_VARCHAR2_TABLE_200
493 , p5_a4 JTF_VARCHAR2_TABLE_200
494 , p5_a5 JTF_VARCHAR2_TABLE_200
495 , p5_a6 JTF_VARCHAR2_TABLE_200
496 , p5_a7 JTF_VARCHAR2_TABLE_200
497 , p5_a8 JTF_VARCHAR2_TABLE_200
498 , p5_a9 JTF_VARCHAR2_TABLE_200
499 , p5_a10 JTF_VARCHAR2_TABLE_200
500 , p5_a11 JTF_VARCHAR2_TABLE_200
501 , p5_a12 JTF_VARCHAR2_TABLE_200
502 , p5_a13 JTF_VARCHAR2_TABLE_200
503 , p5_a14 JTF_VARCHAR2_TABLE_200
504 , p5_a15 JTF_VARCHAR2_TABLE_100
505 , p5_a16 JTF_NUMBER_TABLE
506 , p5_a17 JTF_DATE_TABLE
507 , p5_a18 JTF_NUMBER_TABLE
508 , p5_a19 JTF_NUMBER_TABLE
509 , p5_a20 JTF_VARCHAR2_TABLE_100
510 , p5_a21 JTF_NUMBER_TABLE
511 , p5_a22 JTF_NUMBER_TABLE
512 , p5_a23 JTF_NUMBER_TABLE
513 , p5_a24 JTF_NUMBER_TABLE
514 , p5_a25 JTF_NUMBER_TABLE
515 , p5_a26 JTF_NUMBER_TABLE
516 , p5_a27 JTF_DATE_TABLE
517 , p5_a28 JTF_NUMBER_TABLE
518 , p5_a29 JTF_DATE_TABLE
519 , p_check_access_flag VARCHAR2
520 , p_admin_flag VARCHAR2
521 , p_admin_group_id NUMBER
522 , p_partner_cont_party_id NUMBER
523 , p10_a0 JTF_VARCHAR2_TABLE_100
524 , p10_a1 JTF_VARCHAR2_TABLE_300
525 , p11_a0 out nocopy JTF_NUMBER_TABLE
526 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
527 , x_return_status out nocopy VARCHAR2
528 , x_msg_count out nocopy NUMBER
529 , x_msg_data out nocopy VARCHAR2
530 )
531
532 as
533 ddp_competitor_prod_tbl as_opportunity_pub.competitor_prod_tbl_type;
534 ddp_profile_tbl as_utility_pub.profile_tbl_type;
535 ddx_competitor_prod_out_tbl as_opportunity_pub.competitor_prod_out_tbl_type;
536 ddindx binary_integer; indx binary_integer;
537 begin
538
539 -- copy data to the local IN or IN-OUT args, if any
540
541
542
543
544
545 as_opportunity_pub_w.rosetta_table_copy_in_p44(ddp_competitor_prod_tbl, p5_a0
546 , p5_a1
547 , p5_a2
548 , p5_a3
549 , p5_a4
550 , p5_a5
551 , p5_a6
552 , p5_a7
553 , p5_a8
554 , p5_a9
555 , p5_a10
556 , p5_a11
557 , p5_a12
558 , p5_a13
559 , p5_a14
560 , p5_a15
561 , p5_a16
562 , p5_a17
563 , p5_a18
564 , p5_a19
565 , p5_a20
566 , p5_a21
567 , p5_a22
568 , p5_a23
569 , p5_a24
570 , p5_a25
571 , p5_a26
572 , p5_a27
573 , p5_a28
574 , p5_a29
575 );
576
577
578
579
580
581 as_utility_pub_w.rosetta_table_copy_in_p6(ddp_profile_tbl, p10_a0
582 , p10_a1
583 );
584
585
586
587
588
589 -- here's the delegated call to the old PL/SQL routine
590 as_opportunity_pub.update_competitor_prods(p_api_version_number,
591 p_init_msg_list,
592 p_commit,
593 p_validation_level,
594 p_identity_salesforce_id,
595 ddp_competitor_prod_tbl,
596 p_check_access_flag,
597 p_admin_flag,
598 p_admin_group_id,
599 p_partner_cont_party_id,
600 ddp_profile_tbl,
601 ddx_competitor_prod_out_tbl,
602 x_return_status,
603 x_msg_count,
604 x_msg_data);
605
606 -- copy data back from the local variables to OUT or IN-OUT args, if any
607
608
609
610
611
612
613
614
615
616
617
618 as_opportunity_pub_w.rosetta_table_copy_out_p47(ddx_competitor_prod_out_tbl, p11_a0
619 , p11_a1
620 );
621
622
623
624 end;
625
626 procedure delete_competitor_prods(p_api_version_number NUMBER
627 , p_init_msg_list VARCHAR2
628 , p_commit VARCHAR2
629 , p_validation_level NUMBER
630 , p_identity_salesforce_id NUMBER
631 , p5_a0 JTF_VARCHAR2_TABLE_200
632 , p5_a1 JTF_VARCHAR2_TABLE_200
633 , p5_a2 JTF_VARCHAR2_TABLE_200
634 , p5_a3 JTF_VARCHAR2_TABLE_200
635 , p5_a4 JTF_VARCHAR2_TABLE_200
636 , p5_a5 JTF_VARCHAR2_TABLE_200
637 , p5_a6 JTF_VARCHAR2_TABLE_200
638 , p5_a7 JTF_VARCHAR2_TABLE_200
639 , p5_a8 JTF_VARCHAR2_TABLE_200
640 , p5_a9 JTF_VARCHAR2_TABLE_200
641 , p5_a10 JTF_VARCHAR2_TABLE_200
642 , p5_a11 JTF_VARCHAR2_TABLE_200
643 , p5_a12 JTF_VARCHAR2_TABLE_200
644 , p5_a13 JTF_VARCHAR2_TABLE_200
645 , p5_a14 JTF_VARCHAR2_TABLE_200
646 , p5_a15 JTF_VARCHAR2_TABLE_100
647 , p5_a16 JTF_NUMBER_TABLE
648 , p5_a17 JTF_DATE_TABLE
649 , p5_a18 JTF_NUMBER_TABLE
650 , p5_a19 JTF_NUMBER_TABLE
651 , p5_a20 JTF_VARCHAR2_TABLE_100
652 , p5_a21 JTF_NUMBER_TABLE
653 , p5_a22 JTF_NUMBER_TABLE
654 , p5_a23 JTF_NUMBER_TABLE
655 , p5_a24 JTF_NUMBER_TABLE
656 , p5_a25 JTF_NUMBER_TABLE
657 , p5_a26 JTF_NUMBER_TABLE
658 , p5_a27 JTF_DATE_TABLE
659 , p5_a28 JTF_NUMBER_TABLE
660 , p5_a29 JTF_DATE_TABLE
661 , p_check_access_flag VARCHAR2
662 , p_admin_flag VARCHAR2
663 , p_admin_group_id NUMBER
664 , p_partner_cont_party_id NUMBER
665 , p10_a0 JTF_VARCHAR2_TABLE_100
666 , p10_a1 JTF_VARCHAR2_TABLE_300
667 , p11_a0 out nocopy JTF_NUMBER_TABLE
668 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
669 , x_return_status out nocopy VARCHAR2
670 , x_msg_count out nocopy NUMBER
671 , x_msg_data out nocopy VARCHAR2
672 )
673
674 as
675 ddp_competitor_prod_tbl as_opportunity_pub.competitor_prod_tbl_type;
676 ddp_profile_tbl as_utility_pub.profile_tbl_type;
677 ddx_competitor_prod_out_tbl as_opportunity_pub.competitor_prod_out_tbl_type;
678 ddindx binary_integer; indx binary_integer;
679 begin
680
681 -- copy data to the local IN or IN-OUT args, if any
682
683
684
685
686
687 as_opportunity_pub_w.rosetta_table_copy_in_p44(ddp_competitor_prod_tbl, p5_a0
688 , p5_a1
689 , p5_a2
690 , p5_a3
691 , p5_a4
692 , p5_a5
693 , p5_a6
694 , p5_a7
695 , p5_a8
696 , p5_a9
697 , p5_a10
698 , p5_a11
699 , p5_a12
700 , p5_a13
701 , p5_a14
702 , p5_a15
703 , p5_a16
704 , p5_a17
705 , p5_a18
706 , p5_a19
707 , p5_a20
708 , p5_a21
709 , p5_a22
710 , p5_a23
711 , p5_a24
712 , p5_a25
713 , p5_a26
714 , p5_a27
715 , p5_a28
716 , p5_a29
717 );
718
719
720
721
722
723 as_utility_pub_w.rosetta_table_copy_in_p6(ddp_profile_tbl, p10_a0
724 , p10_a1
725 );
726
727
728
729
730
731 -- here's the delegated call to the old PL/SQL routine
732 as_opportunity_pub.delete_competitor_prods(p_api_version_number,
733 p_init_msg_list,
734 p_commit,
735 p_validation_level,
736 p_identity_salesforce_id,
737 ddp_competitor_prod_tbl,
738 p_check_access_flag,
739 p_admin_flag,
740 p_admin_group_id,
741 p_partner_cont_party_id,
742 ddp_profile_tbl,
743 ddx_competitor_prod_out_tbl,
744 x_return_status,
745 x_msg_count,
746 x_msg_data);
747
748 -- copy data back from the local variables to OUT or IN-OUT args, if any
749
750
751
752
753
754
755
756
757
758
759
760 as_opportunity_pub_w.rosetta_table_copy_out_p47(ddx_competitor_prod_out_tbl, p11_a0
761 , p11_a1
762 );
763
764
765
766 end;
767
768 procedure create_decision_factors(p_api_version_number NUMBER
769 , p_init_msg_list VARCHAR2
770 , p_commit VARCHAR2
771 , p_validation_level NUMBER
772 , p_identity_salesforce_id NUMBER
773 , p5_a0 JTF_VARCHAR2_TABLE_200
774 , p5_a1 JTF_VARCHAR2_TABLE_200
775 , p5_a2 JTF_VARCHAR2_TABLE_200
776 , p5_a3 JTF_VARCHAR2_TABLE_200
777 , p5_a4 JTF_VARCHAR2_TABLE_200
778 , p5_a5 JTF_VARCHAR2_TABLE_200
779 , p5_a6 JTF_VARCHAR2_TABLE_200
780 , p5_a7 JTF_VARCHAR2_TABLE_200
781 , p5_a8 JTF_VARCHAR2_TABLE_200
782 , p5_a9 JTF_VARCHAR2_TABLE_200
783 , p5_a10 JTF_VARCHAR2_TABLE_200
784 , p5_a11 JTF_VARCHAR2_TABLE_200
785 , p5_a12 JTF_VARCHAR2_TABLE_200
786 , p5_a13 JTF_VARCHAR2_TABLE_200
787 , p5_a14 JTF_VARCHAR2_TABLE_200
788 , p5_a15 JTF_VARCHAR2_TABLE_100
789 , p5_a16 JTF_DATE_TABLE
790 , p5_a17 JTF_NUMBER_TABLE
791 , p5_a18 JTF_NUMBER_TABLE
792 , p5_a19 JTF_NUMBER_TABLE
793 , p5_a20 JTF_NUMBER_TABLE
794 , p5_a21 JTF_VARCHAR2_TABLE_300
795 , p5_a22 JTF_VARCHAR2_TABLE_100
796 , p5_a23 JTF_NUMBER_TABLE
797 , p5_a24 JTF_NUMBER_TABLE
798 , p5_a25 JTF_NUMBER_TABLE
799 , p5_a26 JTF_NUMBER_TABLE
800 , p5_a27 JTF_DATE_TABLE
801 , p5_a28 JTF_NUMBER_TABLE
802 , p5_a29 JTF_DATE_TABLE
803 , p_check_access_flag VARCHAR2
804 , p_admin_flag VARCHAR2
805 , p_admin_group_id NUMBER
806 , p_partner_cont_party_id NUMBER
807 , p10_a0 JTF_VARCHAR2_TABLE_100
808 , p10_a1 JTF_VARCHAR2_TABLE_300
809 , p11_a0 out nocopy JTF_NUMBER_TABLE
810 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
811 , x_return_status out nocopy VARCHAR2
812 , x_msg_count out nocopy NUMBER
813 , x_msg_data out nocopy VARCHAR2
814 )
815
816 as
817 ddp_decision_factor_tbl as_opportunity_pub.decision_factor_tbl_type;
818 ddp_profile_tbl as_utility_pub.profile_tbl_type;
819 ddx_decision_factor_out_tbl as_opportunity_pub.decision_factor_out_tbl_type;
820 ddindx binary_integer; indx binary_integer;
821 begin
822
823 -- copy data to the local IN or IN-OUT args, if any
824
825
826
827
828
829 as_opportunity_pub_w.rosetta_table_copy_in_p50(ddp_decision_factor_tbl, p5_a0
830 , p5_a1
831 , p5_a2
832 , p5_a3
833 , p5_a4
834 , p5_a5
835 , p5_a6
836 , p5_a7
837 , p5_a8
838 , p5_a9
839 , p5_a10
840 , p5_a11
841 , p5_a12
842 , p5_a13
843 , p5_a14
844 , p5_a15
845 , p5_a16
846 , p5_a17
847 , p5_a18
848 , p5_a19
849 , p5_a20
850 , p5_a21
851 , p5_a22
852 , p5_a23
853 , p5_a24
854 , p5_a25
855 , p5_a26
856 , p5_a27
857 , p5_a28
858 , p5_a29
859 );
860
861
862
863
864
865 as_utility_pub_w.rosetta_table_copy_in_p6(ddp_profile_tbl, p10_a0
866 , p10_a1
867 );
868
869
870
871
872
873 -- here's the delegated call to the old PL/SQL routine
874 as_opportunity_pub.create_decision_factors(p_api_version_number,
875 p_init_msg_list,
876 p_commit,
877 p_validation_level,
878 p_identity_salesforce_id,
879 ddp_decision_factor_tbl,
880 p_check_access_flag,
881 p_admin_flag,
882 p_admin_group_id,
883 p_partner_cont_party_id,
884 ddp_profile_tbl,
885 ddx_decision_factor_out_tbl,
886 x_return_status,
887 x_msg_count,
888 x_msg_data);
889
890 -- copy data back from the local variables to OUT or IN-OUT args, if any
891
892
893
894
895
896
897
898
899
900
901
902 as_opportunity_pub_w.rosetta_table_copy_out_p53(ddx_decision_factor_out_tbl, p11_a0
903 , p11_a1
904 );
905
906
907
908 end;
909
910 procedure update_decision_factors(p_api_version_number NUMBER
911 , p_init_msg_list VARCHAR2
912 , p_commit VARCHAR2
913 , p_validation_level NUMBER
914 , p_identity_salesforce_id NUMBER
915 , p5_a0 JTF_VARCHAR2_TABLE_200
916 , p5_a1 JTF_VARCHAR2_TABLE_200
917 , p5_a2 JTF_VARCHAR2_TABLE_200
918 , p5_a3 JTF_VARCHAR2_TABLE_200
919 , p5_a4 JTF_VARCHAR2_TABLE_200
920 , p5_a5 JTF_VARCHAR2_TABLE_200
921 , p5_a6 JTF_VARCHAR2_TABLE_200
922 , p5_a7 JTF_VARCHAR2_TABLE_200
923 , p5_a8 JTF_VARCHAR2_TABLE_200
924 , p5_a9 JTF_VARCHAR2_TABLE_200
925 , p5_a10 JTF_VARCHAR2_TABLE_200
926 , p5_a11 JTF_VARCHAR2_TABLE_200
927 , p5_a12 JTF_VARCHAR2_TABLE_200
928 , p5_a13 JTF_VARCHAR2_TABLE_200
929 , p5_a14 JTF_VARCHAR2_TABLE_200
930 , p5_a15 JTF_VARCHAR2_TABLE_100
931 , p5_a16 JTF_DATE_TABLE
932 , p5_a17 JTF_NUMBER_TABLE
933 , p5_a18 JTF_NUMBER_TABLE
934 , p5_a19 JTF_NUMBER_TABLE
935 , p5_a20 JTF_NUMBER_TABLE
936 , p5_a21 JTF_VARCHAR2_TABLE_300
937 , p5_a22 JTF_VARCHAR2_TABLE_100
938 , p5_a23 JTF_NUMBER_TABLE
939 , p5_a24 JTF_NUMBER_TABLE
940 , p5_a25 JTF_NUMBER_TABLE
941 , p5_a26 JTF_NUMBER_TABLE
942 , p5_a27 JTF_DATE_TABLE
943 , p5_a28 JTF_NUMBER_TABLE
944 , p5_a29 JTF_DATE_TABLE
945 , p_check_access_flag VARCHAR2
946 , p_admin_flag VARCHAR2
947 , p_admin_group_id NUMBER
948 , p_partner_cont_party_id NUMBER
949 , p10_a0 JTF_VARCHAR2_TABLE_100
950 , p10_a1 JTF_VARCHAR2_TABLE_300
951 , p11_a0 out nocopy JTF_NUMBER_TABLE
952 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
953 , x_return_status out nocopy VARCHAR2
954 , x_msg_count out nocopy NUMBER
955 , x_msg_data out nocopy VARCHAR2
956 )
957
958 as
959 ddp_decision_factor_tbl as_opportunity_pub.decision_factor_tbl_type;
960 ddp_profile_tbl as_utility_pub.profile_tbl_type;
961 ddx_decision_factor_out_tbl as_opportunity_pub.decision_factor_out_tbl_type;
962 ddindx binary_integer; indx binary_integer;
963 begin
964
965 -- copy data to the local IN or IN-OUT args, if any
966
967
968
969
970
971 as_opportunity_pub_w.rosetta_table_copy_in_p50(ddp_decision_factor_tbl, p5_a0
972 , p5_a1
973 , p5_a2
974 , p5_a3
975 , p5_a4
976 , p5_a5
977 , p5_a6
978 , p5_a7
979 , p5_a8
980 , p5_a9
981 , p5_a10
982 , p5_a11
983 , p5_a12
984 , p5_a13
985 , p5_a14
986 , p5_a15
987 , p5_a16
988 , p5_a17
989 , p5_a18
990 , p5_a19
991 , p5_a20
992 , p5_a21
993 , p5_a22
994 , p5_a23
995 , p5_a24
996 , p5_a25
997 , p5_a26
998 , p5_a27
999 , p5_a28
1000 , p5_a29
1001 );
1002
1003
1004
1005
1006
1007 as_utility_pub_w.rosetta_table_copy_in_p6(ddp_profile_tbl, p10_a0
1008 , p10_a1
1009 );
1010
1011
1012
1013
1014
1015 -- here's the delegated call to the old PL/SQL routine
1016 as_opportunity_pub.update_decision_factors(p_api_version_number,
1017 p_init_msg_list,
1018 p_commit,
1019 p_validation_level,
1020 p_identity_salesforce_id,
1021 ddp_decision_factor_tbl,
1022 p_check_access_flag,
1023 p_admin_flag,
1024 p_admin_group_id,
1025 p_partner_cont_party_id,
1026 ddp_profile_tbl,
1027 ddx_decision_factor_out_tbl,
1028 x_return_status,
1029 x_msg_count,
1030 x_msg_data);
1031
1032 -- copy data back from the local variables to OUT or IN-OUT args, if any
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044 as_opportunity_pub_w.rosetta_table_copy_out_p53(ddx_decision_factor_out_tbl, p11_a0
1045 , p11_a1
1046 );
1047
1048
1049
1050 end;
1051
1052 procedure delete_decision_factors(p_api_version_number NUMBER
1053 , p_init_msg_list VARCHAR2
1054 , p_commit VARCHAR2
1055 , p_validation_level NUMBER
1056 , p_identity_salesforce_id NUMBER
1057 , p5_a0 JTF_VARCHAR2_TABLE_200
1058 , p5_a1 JTF_VARCHAR2_TABLE_200
1059 , p5_a2 JTF_VARCHAR2_TABLE_200
1060 , p5_a3 JTF_VARCHAR2_TABLE_200
1061 , p5_a4 JTF_VARCHAR2_TABLE_200
1062 , p5_a5 JTF_VARCHAR2_TABLE_200
1063 , p5_a6 JTF_VARCHAR2_TABLE_200
1064 , p5_a7 JTF_VARCHAR2_TABLE_200
1065 , p5_a8 JTF_VARCHAR2_TABLE_200
1066 , p5_a9 JTF_VARCHAR2_TABLE_200
1067 , p5_a10 JTF_VARCHAR2_TABLE_200
1068 , p5_a11 JTF_VARCHAR2_TABLE_200
1069 , p5_a12 JTF_VARCHAR2_TABLE_200
1070 , p5_a13 JTF_VARCHAR2_TABLE_200
1071 , p5_a14 JTF_VARCHAR2_TABLE_200
1072 , p5_a15 JTF_VARCHAR2_TABLE_100
1073 , p5_a16 JTF_DATE_TABLE
1074 , p5_a17 JTF_NUMBER_TABLE
1075 , p5_a18 JTF_NUMBER_TABLE
1076 , p5_a19 JTF_NUMBER_TABLE
1077 , p5_a20 JTF_NUMBER_TABLE
1078 , p5_a21 JTF_VARCHAR2_TABLE_300
1079 , p5_a22 JTF_VARCHAR2_TABLE_100
1080 , p5_a23 JTF_NUMBER_TABLE
1081 , p5_a24 JTF_NUMBER_TABLE
1082 , p5_a25 JTF_NUMBER_TABLE
1083 , p5_a26 JTF_NUMBER_TABLE
1084 , p5_a27 JTF_DATE_TABLE
1085 , p5_a28 JTF_NUMBER_TABLE
1086 , p5_a29 JTF_DATE_TABLE
1087 , p_check_access_flag VARCHAR2
1088 , p_admin_flag VARCHAR2
1089 , p_admin_group_id NUMBER
1090 , p_partner_cont_party_id NUMBER
1091 , p10_a0 JTF_VARCHAR2_TABLE_100
1092 , p10_a1 JTF_VARCHAR2_TABLE_300
1093 , p11_a0 out nocopy JTF_NUMBER_TABLE
1094 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_100
1095 , x_return_status out nocopy VARCHAR2
1096 , x_msg_count out nocopy NUMBER
1097 , x_msg_data out nocopy VARCHAR2
1098 )
1099
1100 as
1101 ddp_decision_factor_tbl as_opportunity_pub.decision_factor_tbl_type;
1102 ddp_profile_tbl as_utility_pub.profile_tbl_type;
1103 ddx_decision_factor_out_tbl as_opportunity_pub.decision_factor_out_tbl_type;
1104 ddindx binary_integer; indx binary_integer;
1105 begin
1106
1107 -- copy data to the local IN or IN-OUT args, if any
1108
1109
1110
1111
1112
1113 as_opportunity_pub_w.rosetta_table_copy_in_p50(ddp_decision_factor_tbl, p5_a0
1114 , p5_a1
1115 , p5_a2
1116 , p5_a3
1117 , p5_a4
1118 , p5_a5
1119 , p5_a6
1120 , p5_a7
1121 , p5_a8
1122 , p5_a9
1123 , p5_a10
1124 , p5_a11
1125 , p5_a12
1126 , p5_a13
1127 , p5_a14
1128 , p5_a15
1129 , p5_a16
1130 , p5_a17
1131 , p5_a18
1132 , p5_a19
1133 , p5_a20
1134 , p5_a21
1135 , p5_a22
1136 , p5_a23
1137 , p5_a24
1138 , p5_a25
1139 , p5_a26
1140 , p5_a27
1141 , p5_a28
1142 , p5_a29
1143 );
1144
1145
1146
1147
1148
1149 as_utility_pub_w.rosetta_table_copy_in_p6(ddp_profile_tbl, p10_a0
1150 , p10_a1
1151 );
1152
1153
1154
1155
1156
1157 -- here's the delegated call to the old PL/SQL routine
1158 as_opportunity_pub.delete_decision_factors(p_api_version_number,
1159 p_init_msg_list,
1160 p_commit,
1161 p_validation_level,
1162 p_identity_salesforce_id,
1163 ddp_decision_factor_tbl,
1164 p_check_access_flag,
1165 p_admin_flag,
1166 p_admin_group_id,
1167 p_partner_cont_party_id,
1168 ddp_profile_tbl,
1169 ddx_decision_factor_out_tbl,
1170 x_return_status,
1171 x_msg_count,
1172 x_msg_data);
1173
1174 -- copy data back from the local variables to OUT or IN-OUT args, if any
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186 as_opportunity_pub_w.rosetta_table_copy_out_p53(ddx_decision_factor_out_tbl, p11_a0
1187 , p11_a1
1188 );
1189
1190
1191
1192 end;
1193
1194 end as_opportunity_pub_w3;