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