[Home] [Help]
PACKAGE: APPS.IBE_PARTY_V2PVT_W
Source
1 package ibe_party_v2pvt_w as
2 /* $Header: IBEWPARS.pls 120.1 2005/06/20 09:27:34 appldev ship $ */
3 procedure create_individual_user(p_username VARCHAR2
4 , p_password VARCHAR2
5 , p2_a0 VARCHAR2
6 , p2_a1 VARCHAR2
7 , p2_a2 VARCHAR2
8 , p2_a3 VARCHAR2
9 , p2_a4 VARCHAR2
10 , p2_a5 VARCHAR2
11 , p2_a6 VARCHAR2
12 , p2_a7 VARCHAR2
13 , p2_a8 VARCHAR2
14 , p2_a9 VARCHAR2
15 , p2_a10 VARCHAR2
16 , p2_a11 VARCHAR2
17 , p2_a12 VARCHAR2
18 , p2_a13 VARCHAR2
19 , p2_a14 VARCHAR2
20 , p2_a15 VARCHAR2
21 , p2_a16 VARCHAR2
22 , p2_a17 VARCHAR2
23 , p2_a18 VARCHAR2
24 , p2_a19 VARCHAR2
25 , p2_a20 VARCHAR2
26 , p2_a21 VARCHAR2
27 , p2_a22 DATE
28 , p2_a23 VARCHAR2
29 , p2_a24 DATE
30 , p2_a25 VARCHAR2
31 , p2_a26 VARCHAR2
32 , p2_a27 VARCHAR2
33 , p2_a28 DATE
34 , p2_a29 NUMBER
35 , p2_a30 VARCHAR2
36 , p2_a31 NUMBER
37 , p2_a32 NUMBER
38 , p2_a33 VARCHAR2
39 , p2_a34 VARCHAR2
40 , p2_a35 VARCHAR2
41 , p2_a36 VARCHAR2
42 , p2_a37 VARCHAR2
43 , p2_a38 VARCHAR2
44 , p2_a39 VARCHAR2
45 , p2_a40 VARCHAR2
46 , p2_a41 VARCHAR2
47 , p2_a42 VARCHAR2
48 , p2_a43 VARCHAR2
49 , p2_a44 VARCHAR2
50 , p2_a45 VARCHAR2
51 , p2_a46 VARCHAR2
52 , p2_a47 VARCHAR2
53 , p2_a48 VARCHAR2
54 , p2_a49 VARCHAR2
55 , p2_a50 VARCHAR2
56 , p2_a51 VARCHAR2
57 , p2_a52 VARCHAR2
58 , p2_a53 VARCHAR2
59 , p2_a54 VARCHAR2
60 , p2_a55 VARCHAR2
61 , p2_a56 VARCHAR2
62 , p2_a57 VARCHAR2
63 , p2_a58 VARCHAR2
64 , p2_a59 NUMBER
65 , p2_a60 VARCHAR2
66 , p2_a61 NUMBER
67 , p2_a62 VARCHAR2
68 , p2_a63 VARCHAR2
69 , p2_a64 VARCHAR2
70 , p2_a65 VARCHAR2
71 , p2_a66 VARCHAR2
72 , p2_a67 VARCHAR2
73 , p2_a68 VARCHAR2
74 , p2_a69 VARCHAR2
75 , p2_a70 VARCHAR2
76 , p2_a71 VARCHAR2
77 , p2_a72 VARCHAR2
78 , p2_a73 VARCHAR2
79 , p2_a74 VARCHAR2
80 , p2_a75 VARCHAR2
81 , p2_a76 VARCHAR2
82 , p2_a77 VARCHAR2
83 , p2_a78 VARCHAR2
84 , p2_a79 VARCHAR2
85 , p2_a80 VARCHAR2
86 , p2_a81 VARCHAR2
87 , p2_a82 VARCHAR2
88 , p2_a83 VARCHAR2
89 , p2_a84 VARCHAR2
90 , p2_a85 VARCHAR2
91 , p2_a86 VARCHAR2
92 , p2_a87 VARCHAR2
93 , p2_a88 VARCHAR2
94 , p2_a89 VARCHAR2
95 , p2_a90 VARCHAR2
96 , p2_a91 VARCHAR2
97 , p2_a92 VARCHAR2
98 , p3_a0 VARCHAR2
99 , p3_a1 VARCHAR2
100 , p4_a0 VARCHAR2
101 , p4_a1 DATE
102 , p4_a2 NUMBER
103 , p4_a3 VARCHAR2
104 , p4_a4 VARCHAR2
105 , p4_a5 VARCHAR2
106 , p4_a6 VARCHAR2
107 , p4_a7 VARCHAR2
108 , p4_a8 VARCHAR2
109 , p5_a0 VARCHAR2
110 , p5_a1 DATE
111 , p5_a2 NUMBER
112 , p5_a3 VARCHAR2
113 , p5_a4 VARCHAR2
114 , p5_a5 VARCHAR2
115 , p5_a6 VARCHAR2
116 , p5_a7 VARCHAR2
117 , p5_a8 VARCHAR2
118 , p6_a0 VARCHAR2
119 , p6_a1 DATE
120 , p6_a2 NUMBER
121 , p6_a3 VARCHAR2
122 , p6_a4 VARCHAR2
123 , p6_a5 VARCHAR2
124 , p6_a6 VARCHAR2
125 , p6_a7 VARCHAR2
126 , p6_a8 VARCHAR2
127 , p_contact_preference VARCHAR2
128 , x_person_party_id out nocopy NUMBER
129 , x_user_id out nocopy NUMBER
130 , x_return_status out nocopy VARCHAR2
131 , x_msg_count out nocopy NUMBER
132 , x_msg_data out nocopy VARCHAR2
133 );
134 procedure create_business_user(p_username VARCHAR2
135 , p_password VARCHAR2
136 , p2_a0 VARCHAR2
137 , p2_a1 VARCHAR2
138 , p2_a2 VARCHAR2
139 , p2_a3 VARCHAR2
140 , p2_a4 VARCHAR2
141 , p2_a5 VARCHAR2
142 , p2_a6 VARCHAR2
143 , p2_a7 VARCHAR2
144 , p2_a8 VARCHAR2
145 , p2_a9 VARCHAR2
146 , p2_a10 VARCHAR2
147 , p2_a11 VARCHAR2
148 , p2_a12 VARCHAR2
149 , p2_a13 VARCHAR2
150 , p2_a14 VARCHAR2
151 , p2_a15 VARCHAR2
152 , p2_a16 VARCHAR2
153 , p2_a17 VARCHAR2
154 , p2_a18 VARCHAR2
155 , p2_a19 VARCHAR2
156 , p2_a20 VARCHAR2
157 , p2_a21 VARCHAR2
158 , p2_a22 DATE
159 , p2_a23 VARCHAR2
160 , p2_a24 DATE
161 , p2_a25 VARCHAR2
162 , p2_a26 VARCHAR2
163 , p2_a27 VARCHAR2
164 , p2_a28 DATE
165 , p2_a29 NUMBER
166 , p2_a30 VARCHAR2
167 , p2_a31 NUMBER
168 , p2_a32 NUMBER
169 , p2_a33 VARCHAR2
170 , p2_a34 VARCHAR2
171 , p2_a35 VARCHAR2
172 , p2_a36 VARCHAR2
173 , p2_a37 VARCHAR2
174 , p2_a38 VARCHAR2
175 , p2_a39 VARCHAR2
176 , p2_a40 VARCHAR2
177 , p2_a41 VARCHAR2
178 , p2_a42 VARCHAR2
179 , p2_a43 VARCHAR2
180 , p2_a44 VARCHAR2
181 , p2_a45 VARCHAR2
182 , p2_a46 VARCHAR2
183 , p2_a47 VARCHAR2
184 , p2_a48 VARCHAR2
185 , p2_a49 VARCHAR2
186 , p2_a50 VARCHAR2
187 , p2_a51 VARCHAR2
188 , p2_a52 VARCHAR2
189 , p2_a53 VARCHAR2
190 , p2_a54 VARCHAR2
191 , p2_a55 VARCHAR2
192 , p2_a56 VARCHAR2
193 , p2_a57 VARCHAR2
194 , p2_a58 VARCHAR2
195 , p2_a59 NUMBER
196 , p2_a60 VARCHAR2
197 , p2_a61 NUMBER
198 , p2_a62 VARCHAR2
199 , p2_a63 VARCHAR2
200 , p2_a64 VARCHAR2
201 , p2_a65 VARCHAR2
202 , p2_a66 VARCHAR2
203 , p2_a67 VARCHAR2
204 , p2_a68 VARCHAR2
205 , p2_a69 VARCHAR2
206 , p2_a70 VARCHAR2
207 , p2_a71 VARCHAR2
208 , p2_a72 VARCHAR2
209 , p2_a73 VARCHAR2
210 , p2_a74 VARCHAR2
211 , p2_a75 VARCHAR2
212 , p2_a76 VARCHAR2
213 , p2_a77 VARCHAR2
214 , p2_a78 VARCHAR2
215 , p2_a79 VARCHAR2
216 , p2_a80 VARCHAR2
217 , p2_a81 VARCHAR2
218 , p2_a82 VARCHAR2
219 , p2_a83 VARCHAR2
220 , p2_a84 VARCHAR2
221 , p2_a85 VARCHAR2
222 , p2_a86 VARCHAR2
223 , p2_a87 VARCHAR2
224 , p2_a88 VARCHAR2
225 , p2_a89 VARCHAR2
226 , p2_a90 VARCHAR2
227 , p2_a91 VARCHAR2
228 , p2_a92 VARCHAR2
229 , p3_a0 VARCHAR2
230 , p3_a1 VARCHAR2
231 , p3_a2 VARCHAR2
232 , p3_a3 VARCHAR2
233 , p3_a4 VARCHAR2
234 , p3_a5 VARCHAR2
235 , p3_a6 VARCHAR2
236 , p3_a7 VARCHAR2
237 , p3_a8 NUMBER
238 , p3_a9 NUMBER
239 , p3_a10 VARCHAR2
240 , p3_a11 VARCHAR2
241 , p3_a12 VARCHAR2
242 , p3_a13 VARCHAR2
243 , p3_a14 VARCHAR2
244 , p3_a15 VARCHAR2
245 , p3_a16 VARCHAR2
246 , p3_a17 VARCHAR2
247 , p3_a18 VARCHAR2
248 , p3_a19 VARCHAR2
249 , p3_a20 VARCHAR2
250 , p3_a21 VARCHAR2
251 , p3_a22 VARCHAR2
252 , p3_a23 VARCHAR2
253 , p3_a24 VARCHAR2
254 , p3_a25 VARCHAR2
255 , p3_a26 NUMBER
256 , p3_a27 DATE
257 , p3_a28 VARCHAR2
258 , p3_a29 NUMBER
259 , p3_a30 VARCHAR2
260 , p3_a31 VARCHAR2
261 , p3_a32 VARCHAR2
262 , p3_a33 VARCHAR2
263 , p3_a34 VARCHAR2
264 , p3_a35 VARCHAR2
265 , p3_a36 VARCHAR2
266 , p3_a37 VARCHAR2
267 , p3_a38 VARCHAR2
268 , p3_a39 DATE
269 , p3_a40 DATE
270 , p3_a41 VARCHAR2
271 , p3_a42 VARCHAR2
272 , p3_a43 VARCHAR2
273 , p3_a44 VARCHAR2
274 , p3_a45 VARCHAR2
275 , p3_a46 VARCHAR2
276 , p3_a47 NUMBER
277 , p3_a48 NUMBER
278 , p3_a49 NUMBER
279 , p3_a50 VARCHAR2
280 , p3_a51 VARCHAR2
281 , p3_a52 VARCHAR2
282 , p3_a53 VARCHAR2
283 , p3_a54 VARCHAR2
284 , p3_a55 VARCHAR2
285 , p3_a56 VARCHAR2
286 , p3_a57 VARCHAR2
287 , p3_a58 VARCHAR2
288 , p3_a59 VARCHAR2
289 , p3_a60 VARCHAR2
290 , p3_a61 VARCHAR2
291 , p3_a62 VARCHAR2
292 , p3_a63 VARCHAR2
293 , p3_a64 VARCHAR2
294 , p3_a65 VARCHAR2
295 , p3_a66 VARCHAR2
296 , p3_a67 VARCHAR2
297 , p3_a68 NUMBER
298 , p3_a69 VARCHAR2
299 , p3_a70 VARCHAR2
300 , p3_a71 VARCHAR2
301 , p3_a72 VARCHAR2
302 , p3_a73 VARCHAR2
303 , p3_a74 VARCHAR2
304 , p3_a75 VARCHAR2
305 , p3_a76 VARCHAR2
306 , p3_a77 VARCHAR2
307 , p3_a78 NUMBER
308 , p3_a79 NUMBER
309 , p3_a80 NUMBER
310 , p3_a81 NUMBER
311 , p3_a82 NUMBER
312 , p3_a83 NUMBER
313 , p3_a84 NUMBER
314 , p3_a85 DATE
315 , p3_a86 VARCHAR2
316 , p3_a87 VARCHAR2
317 , p3_a88 VARCHAR2
318 , p3_a89 VARCHAR2
319 , p3_a90 VARCHAR2
320 , p3_a91 VARCHAR2
321 , p3_a92 VARCHAR2
322 , p3_a93 VARCHAR2
323 , p3_a94 VARCHAR2
324 , p3_a95 NUMBER
325 , p3_a96 NUMBER
326 , p3_a97 NUMBER
327 , p3_a98 DATE
328 , p3_a99 VARCHAR2
329 , p3_a100 VARCHAR2
330 , p3_a101 VARCHAR2
331 , p3_a102 VARCHAR2
332 , p3_a103 VARCHAR2
333 , p3_a104 VARCHAR2
334 , p3_a105 VARCHAR2
335 , p3_a106 VARCHAR2
336 , p3_a107 VARCHAR2
337 , p3_a108 NUMBER
338 , p3_a109 VARCHAR2
339 , p3_a110 NUMBER
340 , p3_a111 VARCHAR2
341 , p3_a112 VARCHAR2
342 , p3_a113 VARCHAR2
343 , p3_a114 VARCHAR2
344 , p3_a115 VARCHAR2
345 , p3_a116 VARCHAR2
346 , p3_a117 VARCHAR2
347 , p3_a118 VARCHAR2
348 , p3_a119 VARCHAR2
349 , p3_a120 VARCHAR2
350 , p3_a121 VARCHAR2
351 , p3_a122 VARCHAR2
352 , p3_a123 VARCHAR2
353 , p3_a124 VARCHAR2
354 , p3_a125 VARCHAR2
355 , p3_a126 VARCHAR2
356 , p3_a127 VARCHAR2
357 , p3_a128 VARCHAR2
358 , p3_a129 VARCHAR2
359 , p3_a130 VARCHAR2
360 , p3_a131 VARCHAR2
361 , p3_a132 VARCHAR2
362 , p3_a133 VARCHAR2
363 , p3_a134 VARCHAR2
364 , p3_a135 NUMBER
365 , p3_a136 VARCHAR2
366 , p3_a137 VARCHAR2
367 , p3_a138 NUMBER
368 , p3_a139 VARCHAR2
369 , p3_a140 VARCHAR2
370 , p3_a141 VARCHAR2
371 , p3_a142 VARCHAR2
372 , p3_a143 VARCHAR2
373 , p3_a144 VARCHAR2
374 , p3_a145 VARCHAR2
375 , p3_a146 VARCHAR2
376 , p3_a147 VARCHAR2
377 , p3_a148 VARCHAR2
378 , p3_a149 VARCHAR2
379 , p3_a150 VARCHAR2
380 , p3_a151 VARCHAR2
381 , p3_a152 VARCHAR2
382 , p3_a153 VARCHAR2
383 , p3_a154 VARCHAR2
384 , p3_a155 VARCHAR2
385 , p3_a156 VARCHAR2
386 , p3_a157 VARCHAR2
387 , p3_a158 VARCHAR2
388 , p3_a159 VARCHAR2
389 , p3_a160 VARCHAR2
390 , p3_a161 VARCHAR2
391 , p3_a162 VARCHAR2
392 , p3_a163 VARCHAR2
393 , p3_a164 VARCHAR2
394 , p3_a165 VARCHAR2
395 , p3_a166 VARCHAR2
396 , p3_a167 VARCHAR2
397 , p3_a168 VARCHAR2
398 , p3_a169 VARCHAR2
399 , p4_a0 NUMBER
400 , p4_a1 VARCHAR2
401 , p4_a2 VARCHAR2
402 , p4_a3 VARCHAR2
403 , p4_a4 VARCHAR2
404 , p4_a5 VARCHAR2
405 , p4_a6 VARCHAR2
406 , p4_a7 VARCHAR2
407 , p4_a8 VARCHAR2
408 , p4_a9 VARCHAR2
409 , p4_a10 VARCHAR2
410 , p4_a11 VARCHAR2
411 , p4_a12 VARCHAR2
412 , p4_a13 VARCHAR2
413 , p4_a14 VARCHAR2
414 , p4_a15 VARCHAR2
415 , p4_a16 VARCHAR2
416 , p4_a17 VARCHAR2
417 , p4_a18 VARCHAR2
418 , p4_a19 VARCHAR2
419 , p4_a20 VARCHAR2
420 , p4_a21 VARCHAR2
421 , p4_a22 VARCHAR2
422 , p4_a23 VARCHAR2
423 , p4_a24 VARCHAR2
424 , p4_a25 VARCHAR2
425 , p4_a26 DATE
426 , p4_a27 VARCHAR2
427 , p4_a28 VARCHAR2
428 , p4_a29 VARCHAR2
429 , p4_a30 VARCHAR2
430 , p4_a31 NUMBER
431 , p4_a32 VARCHAR2
432 , p4_a33 VARCHAR2
433 , p4_a34 NUMBER
434 , p4_a35 VARCHAR2
435 , p4_a36 VARCHAR2
436 , p4_a37 VARCHAR2
437 , p4_a38 VARCHAR2
438 , p4_a39 VARCHAR2
439 , p4_a40 VARCHAR2
440 , p4_a41 VARCHAR2
441 , p4_a42 VARCHAR2
442 , p4_a43 VARCHAR2
443 , p4_a44 VARCHAR2
444 , p4_a45 VARCHAR2
445 , p4_a46 VARCHAR2
446 , p4_a47 VARCHAR2
447 , p4_a48 VARCHAR2
448 , p4_a49 VARCHAR2
449 , p4_a50 VARCHAR2
450 , p4_a51 VARCHAR2
451 , p4_a52 VARCHAR2
452 , p4_a53 VARCHAR2
453 , p4_a54 VARCHAR2
454 , p4_a55 VARCHAR2
455 , p4_a56 VARCHAR2
456 , p4_a57 NUMBER
457 , p4_a58 VARCHAR2
458 , p4_a59 NUMBER
459 , p4_a60 VARCHAR2
460 , p5_a0 VARCHAR2
461 , p5_a1 DATE
462 , p5_a2 NUMBER
463 , p5_a3 VARCHAR2
464 , p5_a4 VARCHAR2
465 , p5_a5 VARCHAR2
466 , p5_a6 VARCHAR2
467 , p5_a7 VARCHAR2
468 , p5_a8 VARCHAR2
469 , p6_a0 VARCHAR2
470 , p6_a1 DATE
471 , p6_a2 NUMBER
472 , p6_a3 VARCHAR2
473 , p6_a4 VARCHAR2
474 , p6_a5 VARCHAR2
475 , p6_a6 VARCHAR2
476 , p6_a7 VARCHAR2
477 , p6_a8 VARCHAR2
478 , p7_a0 VARCHAR2
479 , p7_a1 DATE
480 , p7_a2 NUMBER
481 , p7_a3 VARCHAR2
482 , p7_a4 VARCHAR2
483 , p7_a5 VARCHAR2
484 , p7_a6 VARCHAR2
485 , p7_a7 VARCHAR2
486 , p7_a8 VARCHAR2
487 , p8_a0 VARCHAR2
488 , p8_a1 DATE
489 , p8_a2 NUMBER
490 , p8_a3 VARCHAR2
491 , p8_a4 VARCHAR2
492 , p8_a5 VARCHAR2
493 , p8_a6 VARCHAR2
494 , p8_a7 VARCHAR2
495 , p8_a8 VARCHAR2
496 , p9_a0 VARCHAR2
497 , p9_a1 DATE
498 , p9_a2 NUMBER
499 , p9_a3 VARCHAR2
500 , p9_a4 VARCHAR2
501 , p9_a5 VARCHAR2
502 , p9_a6 VARCHAR2
503 , p9_a7 VARCHAR2
504 , p9_a8 VARCHAR2
505 , p10_a0 VARCHAR2
506 , p10_a1 VARCHAR2
507 , p_rel_contact_preference VARCHAR2
508 , x_person_party_id out nocopy NUMBER
509 , x_rel_party_id out nocopy NUMBER
510 , x_org_party_id out nocopy NUMBER
511 , x_user_id out nocopy NUMBER
512 , x_return_status out nocopy VARCHAR2
513 , x_msg_count out nocopy NUMBER
514 , x_msg_data out nocopy VARCHAR2
515 );
516 procedure create_org_contact(p0_a0 VARCHAR2
517 , p0_a1 VARCHAR2
518 , p0_a2 VARCHAR2
519 , p0_a3 VARCHAR2
520 , p0_a4 VARCHAR2
521 , p0_a5 VARCHAR2
522 , p0_a6 VARCHAR2
523 , p0_a7 VARCHAR2
524 , p0_a8 VARCHAR2
525 , p0_a9 VARCHAR2
526 , p0_a10 VARCHAR2
527 , p0_a11 VARCHAR2
528 , p0_a12 VARCHAR2
529 , p0_a13 VARCHAR2
530 , p0_a14 VARCHAR2
531 , p0_a15 VARCHAR2
532 , p0_a16 VARCHAR2
533 , p0_a17 VARCHAR2
534 , p0_a18 VARCHAR2
535 , p0_a19 VARCHAR2
536 , p0_a20 VARCHAR2
537 , p0_a21 VARCHAR2
538 , p0_a22 DATE
539 , p0_a23 VARCHAR2
540 , p0_a24 DATE
541 , p0_a25 VARCHAR2
542 , p0_a26 VARCHAR2
543 , p0_a27 VARCHAR2
544 , p0_a28 DATE
545 , p0_a29 NUMBER
546 , p0_a30 VARCHAR2
547 , p0_a31 NUMBER
548 , p0_a32 NUMBER
549 , p0_a33 VARCHAR2
550 , p0_a34 VARCHAR2
551 , p0_a35 VARCHAR2
552 , p0_a36 VARCHAR2
553 , p0_a37 VARCHAR2
554 , p0_a38 VARCHAR2
555 , p0_a39 VARCHAR2
556 , p0_a40 VARCHAR2
557 , p0_a41 VARCHAR2
558 , p0_a42 VARCHAR2
559 , p0_a43 VARCHAR2
560 , p0_a44 VARCHAR2
561 , p0_a45 VARCHAR2
562 , p0_a46 VARCHAR2
563 , p0_a47 VARCHAR2
564 , p0_a48 VARCHAR2
565 , p0_a49 VARCHAR2
566 , p0_a50 VARCHAR2
567 , p0_a51 VARCHAR2
568 , p0_a52 VARCHAR2
569 , p0_a53 VARCHAR2
570 , p0_a54 VARCHAR2
571 , p0_a55 VARCHAR2
572 , p0_a56 VARCHAR2
573 , p0_a57 VARCHAR2
574 , p0_a58 VARCHAR2
575 , p0_a59 NUMBER
576 , p0_a60 VARCHAR2
577 , p0_a61 NUMBER
578 , p0_a62 VARCHAR2
579 , p0_a63 VARCHAR2
580 , p0_a64 VARCHAR2
581 , p0_a65 VARCHAR2
582 , p0_a66 VARCHAR2
583 , p0_a67 VARCHAR2
584 , p0_a68 VARCHAR2
585 , p0_a69 VARCHAR2
586 , p0_a70 VARCHAR2
587 , p0_a71 VARCHAR2
588 , p0_a72 VARCHAR2
589 , p0_a73 VARCHAR2
590 , p0_a74 VARCHAR2
591 , p0_a75 VARCHAR2
592 , p0_a76 VARCHAR2
593 , p0_a77 VARCHAR2
594 , p0_a78 VARCHAR2
595 , p0_a79 VARCHAR2
596 , p0_a80 VARCHAR2
597 , p0_a81 VARCHAR2
598 , p0_a82 VARCHAR2
599 , p0_a83 VARCHAR2
600 , p0_a84 VARCHAR2
601 , p0_a85 VARCHAR2
602 , p0_a86 VARCHAR2
603 , p0_a87 VARCHAR2
604 , p0_a88 VARCHAR2
605 , p0_a89 VARCHAR2
606 , p0_a90 VARCHAR2
607 , p0_a91 VARCHAR2
608 , p0_a92 VARCHAR2
609 , p_relationship_type VARCHAR2
610 , p_org_party_id NUMBER
614 , p3_a3 VARCHAR2
611 , p3_a0 VARCHAR2
612 , p3_a1 DATE
613 , p3_a2 NUMBER
615 , p3_a4 VARCHAR2
616 , p3_a5 VARCHAR2
617 , p3_a6 VARCHAR2
618 , p3_a7 VARCHAR2
619 , p3_a8 VARCHAR2
620 , p4_a0 VARCHAR2
621 , p4_a1 DATE
622 , p4_a2 NUMBER
623 , p4_a3 VARCHAR2
624 , p4_a4 VARCHAR2
625 , p4_a5 VARCHAR2
626 , p4_a6 VARCHAR2
627 , p4_a7 VARCHAR2
628 , p4_a8 VARCHAR2
629 , p5_a0 VARCHAR2
630 , p5_a1 DATE
631 , p5_a2 NUMBER
632 , p5_a3 VARCHAR2
633 , p5_a4 VARCHAR2
634 , p5_a5 VARCHAR2
635 , p5_a6 VARCHAR2
636 , p5_a7 VARCHAR2
637 , p5_a8 VARCHAR2
638 , p6_a0 VARCHAR2
639 , p6_a1 VARCHAR2
640 , p_created_by_module VARCHAR2
641 , x_person_party_id out nocopy NUMBER
642 , x_rel_party_id out nocopy NUMBER
643 , x_return_status out nocopy VARCHAR2
644 , x_msg_count out nocopy NUMBER
645 , x_msg_data out nocopy VARCHAR2
646 );
647 procedure create_person(p0_a0 VARCHAR2
648 , p0_a1 VARCHAR2
649 , p0_a2 VARCHAR2
650 , p0_a3 VARCHAR2
651 , p0_a4 VARCHAR2
652 , p0_a5 VARCHAR2
653 , p0_a6 VARCHAR2
654 , p0_a7 VARCHAR2
655 , p0_a8 VARCHAR2
656 , p0_a9 VARCHAR2
657 , p0_a10 VARCHAR2
658 , p0_a11 VARCHAR2
659 , p0_a12 VARCHAR2
660 , p0_a13 VARCHAR2
661 , p0_a14 VARCHAR2
662 , p0_a15 VARCHAR2
663 , p0_a16 VARCHAR2
664 , p0_a17 VARCHAR2
665 , p0_a18 VARCHAR2
666 , p0_a19 VARCHAR2
667 , p0_a20 VARCHAR2
668 , p0_a21 VARCHAR2
669 , p0_a22 DATE
670 , p0_a23 VARCHAR2
671 , p0_a24 DATE
672 , p0_a25 VARCHAR2
673 , p0_a26 VARCHAR2
674 , p0_a27 VARCHAR2
675 , p0_a28 DATE
676 , p0_a29 NUMBER
677 , p0_a30 VARCHAR2
678 , p0_a31 NUMBER
679 , p0_a32 NUMBER
680 , p0_a33 VARCHAR2
681 , p0_a34 VARCHAR2
682 , p0_a35 VARCHAR2
683 , p0_a36 VARCHAR2
684 , p0_a37 VARCHAR2
685 , p0_a38 VARCHAR2
686 , p0_a39 VARCHAR2
687 , p0_a40 VARCHAR2
688 , p0_a41 VARCHAR2
689 , p0_a42 VARCHAR2
690 , p0_a43 VARCHAR2
691 , p0_a44 VARCHAR2
692 , p0_a45 VARCHAR2
693 , p0_a46 VARCHAR2
694 , p0_a47 VARCHAR2
695 , p0_a48 VARCHAR2
696 , p0_a49 VARCHAR2
697 , p0_a50 VARCHAR2
698 , p0_a51 VARCHAR2
699 , p0_a52 VARCHAR2
700 , p0_a53 VARCHAR2
701 , p0_a54 VARCHAR2
702 , p0_a55 VARCHAR2
703 , p0_a56 VARCHAR2
704 , p0_a57 VARCHAR2
708 , p0_a61 NUMBER
705 , p0_a58 VARCHAR2
706 , p0_a59 NUMBER
707 , p0_a60 VARCHAR2
709 , p0_a62 VARCHAR2
710 , p0_a63 VARCHAR2
711 , p0_a64 VARCHAR2
712 , p0_a65 VARCHAR2
713 , p0_a66 VARCHAR2
714 , p0_a67 VARCHAR2
715 , p0_a68 VARCHAR2
716 , p0_a69 VARCHAR2
717 , p0_a70 VARCHAR2
718 , p0_a71 VARCHAR2
719 , p0_a72 VARCHAR2
720 , p0_a73 VARCHAR2
721 , p0_a74 VARCHAR2
722 , p0_a75 VARCHAR2
723 , p0_a76 VARCHAR2
724 , p0_a77 VARCHAR2
725 , p0_a78 VARCHAR2
726 , p0_a79 VARCHAR2
727 , p0_a80 VARCHAR2
728 , p0_a81 VARCHAR2
729 , p0_a82 VARCHAR2
730 , p0_a83 VARCHAR2
731 , p0_a84 VARCHAR2
732 , p0_a85 VARCHAR2
733 , p0_a86 VARCHAR2
734 , p0_a87 VARCHAR2
735 , p0_a88 VARCHAR2
736 , p0_a89 VARCHAR2
737 , p0_a90 VARCHAR2
738 , p0_a91 VARCHAR2
739 , p0_a92 VARCHAR2
740 , p1_a0 VARCHAR2
741 , p1_a1 VARCHAR2
742 , p2_a0 VARCHAR2
743 , p2_a1 DATE
744 , p2_a2 NUMBER
745 , p2_a3 VARCHAR2
746 , p2_a4 VARCHAR2
747 , p2_a5 VARCHAR2
748 , p2_a6 VARCHAR2
749 , p2_a7 VARCHAR2
750 , p2_a8 VARCHAR2
751 , p3_a0 VARCHAR2
752 , p3_a1 DATE
753 , p3_a2 NUMBER
754 , p3_a3 VARCHAR2
755 , p3_a4 VARCHAR2
756 , p3_a5 VARCHAR2
757 , p3_a6 VARCHAR2
758 , p3_a7 VARCHAR2
759 , p3_a8 VARCHAR2
760 , p4_a0 VARCHAR2
761 , p4_a1 DATE
762 , p4_a2 NUMBER
763 , p4_a3 VARCHAR2
764 , p4_a4 VARCHAR2
765 , p4_a5 VARCHAR2
766 , p4_a6 VARCHAR2
767 , p4_a7 VARCHAR2
768 , p4_a8 VARCHAR2
769 , p_created_by_module VARCHAR2
770 , p_account VARCHAR2
771 , x_person_party_id out nocopy NUMBER
772 , x_account_id out nocopy NUMBER
773 , x_return_status out nocopy VARCHAR2
774 , x_msg_count out nocopy NUMBER
775 , x_msg_data out nocopy VARCHAR2
776 );
777 procedure create_organization(p0_a0 VARCHAR2
778 , p0_a1 VARCHAR2
779 , p0_a2 VARCHAR2
780 , p0_a3 VARCHAR2
781 , p0_a4 VARCHAR2
782 , p0_a5 VARCHAR2
783 , p0_a6 VARCHAR2
784 , p0_a7 VARCHAR2
785 , p0_a8 NUMBER
786 , p0_a9 NUMBER
787 , p0_a10 VARCHAR2
788 , p0_a11 VARCHAR2
789 , p0_a12 VARCHAR2
790 , p0_a13 VARCHAR2
791 , p0_a14 VARCHAR2
792 , p0_a15 VARCHAR2
793 , p0_a16 VARCHAR2
794 , p0_a17 VARCHAR2
795 , p0_a18 VARCHAR2
796 , p0_a19 VARCHAR2
797 , p0_a20 VARCHAR2
798 , p0_a21 VARCHAR2
799 , p0_a22 VARCHAR2
800 , p0_a23 VARCHAR2
801 , p0_a24 VARCHAR2
802 , p0_a25 VARCHAR2
803 , p0_a26 NUMBER
804 , p0_a27 DATE
805 , p0_a28 VARCHAR2
806 , p0_a29 NUMBER
807 , p0_a30 VARCHAR2
808 , p0_a31 VARCHAR2
809 , p0_a32 VARCHAR2
810 , p0_a33 VARCHAR2
811 , p0_a34 VARCHAR2
812 , p0_a35 VARCHAR2
813 , p0_a36 VARCHAR2
814 , p0_a37 VARCHAR2
815 , p0_a38 VARCHAR2
816 , p0_a39 DATE
817 , p0_a40 DATE
818 , p0_a41 VARCHAR2
819 , p0_a42 VARCHAR2
820 , p0_a43 VARCHAR2
821 , p0_a44 VARCHAR2
822 , p0_a45 VARCHAR2
823 , p0_a46 VARCHAR2
824 , p0_a47 NUMBER
825 , p0_a48 NUMBER
826 , p0_a49 NUMBER
827 , p0_a50 VARCHAR2
828 , p0_a51 VARCHAR2
829 , p0_a52 VARCHAR2
830 , p0_a53 VARCHAR2
831 , p0_a54 VARCHAR2
832 , p0_a55 VARCHAR2
833 , p0_a56 VARCHAR2
834 , p0_a57 VARCHAR2
835 , p0_a58 VARCHAR2
836 , p0_a59 VARCHAR2
837 , p0_a60 VARCHAR2
838 , p0_a61 VARCHAR2
839 , p0_a62 VARCHAR2
840 , p0_a63 VARCHAR2
841 , p0_a64 VARCHAR2
842 , p0_a65 VARCHAR2
843 , p0_a66 VARCHAR2
844 , p0_a67 VARCHAR2
845 , p0_a68 NUMBER
846 , p0_a69 VARCHAR2
847 , p0_a70 VARCHAR2
848 , p0_a71 VARCHAR2
849 , p0_a72 VARCHAR2
850 , p0_a73 VARCHAR2
851 , p0_a74 VARCHAR2
852 , p0_a75 VARCHAR2
853 , p0_a76 VARCHAR2
854 , p0_a77 VARCHAR2
855 , p0_a78 NUMBER
856 , p0_a79 NUMBER
857 , p0_a80 NUMBER
858 , p0_a81 NUMBER
859 , p0_a82 NUMBER
860 , p0_a83 NUMBER
861 , p0_a84 NUMBER
862 , p0_a85 DATE
863 , p0_a86 VARCHAR2
864 , p0_a87 VARCHAR2
865 , p0_a88 VARCHAR2
866 , p0_a89 VARCHAR2
867 , p0_a90 VARCHAR2
868 , p0_a91 VARCHAR2
869 , p0_a92 VARCHAR2
870 , p0_a93 VARCHAR2
871 , p0_a94 VARCHAR2
872 , p0_a95 NUMBER
873 , p0_a96 NUMBER
874 , p0_a97 NUMBER
875 , p0_a98 DATE
876 , p0_a99 VARCHAR2
877 , p0_a100 VARCHAR2
878 , p0_a101 VARCHAR2
879 , p0_a102 VARCHAR2
880 , p0_a103 VARCHAR2
881 , p0_a104 VARCHAR2
882 , p0_a105 VARCHAR2
883 , p0_a106 VARCHAR2
884 , p0_a107 VARCHAR2
885 , p0_a108 NUMBER
886 , p0_a109 VARCHAR2
887 , p0_a110 NUMBER
888 , p0_a111 VARCHAR2
889 , p0_a112 VARCHAR2
893 , p0_a116 VARCHAR2
890 , p0_a113 VARCHAR2
891 , p0_a114 VARCHAR2
892 , p0_a115 VARCHAR2
894 , p0_a117 VARCHAR2
895 , p0_a118 VARCHAR2
896 , p0_a119 VARCHAR2
897 , p0_a120 VARCHAR2
898 , p0_a121 VARCHAR2
899 , p0_a122 VARCHAR2
900 , p0_a123 VARCHAR2
901 , p0_a124 VARCHAR2
902 , p0_a125 VARCHAR2
903 , p0_a126 VARCHAR2
904 , p0_a127 VARCHAR2
905 , p0_a128 VARCHAR2
906 , p0_a129 VARCHAR2
907 , p0_a130 VARCHAR2
908 , p0_a131 VARCHAR2
909 , p0_a132 VARCHAR2
910 , p0_a133 VARCHAR2
911 , p0_a134 VARCHAR2
912 , p0_a135 NUMBER
913 , p0_a136 VARCHAR2
914 , p0_a137 VARCHAR2
915 , p0_a138 NUMBER
916 , p0_a139 VARCHAR2
917 , p0_a140 VARCHAR2
918 , p0_a141 VARCHAR2
919 , p0_a142 VARCHAR2
920 , p0_a143 VARCHAR2
921 , p0_a144 VARCHAR2
922 , p0_a145 VARCHAR2
923 , p0_a146 VARCHAR2
924 , p0_a147 VARCHAR2
925 , p0_a148 VARCHAR2
926 , p0_a149 VARCHAR2
927 , p0_a150 VARCHAR2
928 , p0_a151 VARCHAR2
929 , p0_a152 VARCHAR2
930 , p0_a153 VARCHAR2
931 , p0_a154 VARCHAR2
932 , p0_a155 VARCHAR2
933 , p0_a156 VARCHAR2
934 , p0_a157 VARCHAR2
935 , p0_a158 VARCHAR2
936 , p0_a159 VARCHAR2
937 , p0_a160 VARCHAR2
938 , p0_a161 VARCHAR2
939 , p0_a162 VARCHAR2
940 , p0_a163 VARCHAR2
941 , p0_a164 VARCHAR2
942 , p0_a165 VARCHAR2
943 , p0_a166 VARCHAR2
944 , p0_a167 VARCHAR2
945 , p0_a168 VARCHAR2
946 , p0_a169 VARCHAR2
947 , p1_a0 VARCHAR2
948 , p1_a1 DATE
949 , p1_a2 NUMBER
950 , p1_a3 VARCHAR2
951 , p1_a4 VARCHAR2
952 , p1_a5 VARCHAR2
953 , p1_a6 VARCHAR2
954 , p1_a7 VARCHAR2
955 , p1_a8 VARCHAR2
956 , p2_a0 VARCHAR2
957 , p2_a1 DATE
958 , p2_a2 NUMBER
959 , p2_a3 VARCHAR2
960 , p2_a4 VARCHAR2
961 , p2_a5 VARCHAR2
962 , p2_a6 VARCHAR2
963 , p2_a7 VARCHAR2
964 , p2_a8 VARCHAR2
965 , p3_a0 NUMBER
966 , p3_a1 VARCHAR2
967 , p3_a2 VARCHAR2
968 , p3_a3 VARCHAR2
969 , p3_a4 VARCHAR2
970 , p3_a5 VARCHAR2
971 , p3_a6 VARCHAR2
972 , p3_a7 VARCHAR2
973 , p3_a8 VARCHAR2
974 , p3_a9 VARCHAR2
975 , p3_a10 VARCHAR2
976 , p3_a11 VARCHAR2
977 , p3_a12 VARCHAR2
978 , p3_a13 VARCHAR2
979 , p3_a14 VARCHAR2
980 , p3_a15 VARCHAR2
981 , p3_a16 VARCHAR2
982 , p3_a17 VARCHAR2
983 , p3_a18 VARCHAR2
984 , p3_a19 VARCHAR2
985 , p3_a20 VARCHAR2
986 , p3_a21 VARCHAR2
987 , p3_a22 VARCHAR2
988 , p3_a23 VARCHAR2
989 , p3_a24 VARCHAR2
990 , p3_a25 VARCHAR2
991 , p3_a26 DATE
992 , p3_a27 VARCHAR2
993 , p3_a28 VARCHAR2
994 , p3_a29 VARCHAR2
995 , p3_a30 VARCHAR2
996 , p3_a31 NUMBER
997 , p3_a32 VARCHAR2
998 , p3_a33 VARCHAR2
999 , p3_a34 NUMBER
1000 , p3_a35 VARCHAR2
1001 , p3_a36 VARCHAR2
1002 , p3_a37 VARCHAR2
1003 , p3_a38 VARCHAR2
1004 , p3_a39 VARCHAR2
1005 , p3_a40 VARCHAR2
1006 , p3_a41 VARCHAR2
1007 , p3_a42 VARCHAR2
1008 , p3_a43 VARCHAR2
1009 , p3_a44 VARCHAR2
1010 , p3_a45 VARCHAR2
1011 , p3_a46 VARCHAR2
1012 , p3_a47 VARCHAR2
1013 , p3_a48 VARCHAR2
1014 , p3_a49 VARCHAR2
1015 , p3_a50 VARCHAR2
1016 , p3_a51 VARCHAR2
1017 , p3_a52 VARCHAR2
1018 , p3_a53 VARCHAR2
1019 , p3_a54 VARCHAR2
1020 , p3_a55 VARCHAR2
1021 , p3_a56 VARCHAR2
1022 , p3_a57 NUMBER
1023 , p3_a58 VARCHAR2
1024 , p3_a59 NUMBER
1025 , p3_a60 VARCHAR2
1026 , p4_a0 NUMBER
1027 , p4_a1 NUMBER
1028 , p4_a2 NUMBER
1029 , p4_a3 VARCHAR2
1030 , p4_a4 VARCHAR2
1031 , p4_a5 VARCHAR2
1032 , p4_a6 VARCHAR2
1033 , p4_a7 VARCHAR2
1034 , p4_a8 VARCHAR2
1038 , p4_a12 VARCHAR2
1035 , p4_a9 VARCHAR2
1036 , p4_a10 VARCHAR2
1037 , p4_a11 VARCHAR2
1039 , p4_a13 VARCHAR2
1040 , p4_a14 VARCHAR2
1041 , p4_a15 VARCHAR2
1042 , p4_a16 VARCHAR2
1043 , p4_a17 VARCHAR2
1044 , p4_a18 VARCHAR2
1045 , p4_a19 VARCHAR2
1046 , p4_a20 VARCHAR2
1047 , p4_a21 VARCHAR2
1048 , p4_a22 VARCHAR2
1049 , p4_a23 VARCHAR2
1050 , p4_a24 VARCHAR2
1051 , p4_a25 VARCHAR2
1052 , p4_a26 VARCHAR2
1053 , p4_a27 VARCHAR2
1054 , p4_a28 VARCHAR2
1055 , p4_a29 VARCHAR2
1056 , p4_a30 VARCHAR2
1057 , p4_a31 VARCHAR2
1058 , p4_a32 VARCHAR2
1059 , p4_a33 NUMBER
1060 , p_primary_billto VARCHAR2
1061 , p_primary_shipto VARCHAR2
1062 , p_billto VARCHAR2
1063 , p_shipto VARCHAR2
1064 , p_default_primary VARCHAR2
1065 , p_created_by_module VARCHAR2
1066 , p_account VARCHAR2
1067 , x_org_party_id out nocopy NUMBER
1068 , x_account_id out nocopy NUMBER
1069 , x_party_site_id out nocopy NUMBER
1070 , x_return_status out nocopy VARCHAR2
1071 , x_msg_count out nocopy NUMBER
1072 , x_msg_data out nocopy VARCHAR2
1073 );
1074 procedure create_contact_points(p_owner_table_id NUMBER
1075 , p1_a0 VARCHAR2
1076 , p1_a1 DATE
1077 , p1_a2 NUMBER
1078 , p1_a3 VARCHAR2
1079 , p1_a4 VARCHAR2
1080 , p1_a5 VARCHAR2
1081 , p1_a6 VARCHAR2
1082 , p1_a7 VARCHAR2
1083 , p1_a8 VARCHAR2
1084 , p2_a0 VARCHAR2
1085 , p2_a1 DATE
1086 , p2_a2 NUMBER
1087 , p2_a3 VARCHAR2
1088 , p2_a4 VARCHAR2
1089 , p2_a5 VARCHAR2
1090 , p2_a6 VARCHAR2
1091 , p2_a7 VARCHAR2
1092 , p2_a8 VARCHAR2
1093 , p3_a0 VARCHAR2
1094 , p3_a1 DATE
1095 , p3_a2 NUMBER
1096 , p3_a3 VARCHAR2
1097 , p3_a4 VARCHAR2
1098 , p3_a5 VARCHAR2
1099 , p3_a6 VARCHAR2
1100 , p3_a7 VARCHAR2
1101 , p3_a8 VARCHAR2
1102 , p4_a0 VARCHAR2
1103 , p4_a1 VARCHAR2
1104 , p_contact_point_purpose number
1105 , p_created_by_module VARCHAR2
1106 , x_return_status out nocopy VARCHAR2
1107 , x_msg_count out nocopy NUMBER
1108 , x_msg_data out nocopy VARCHAR2
1109 );
1110 procedure find_organization(x_org_id in out nocopy NUMBER
1111 , x_org_num in out nocopy VARCHAR2
1112 , x_org_name in out nocopy VARCHAR2
1113 , ddrosetta_retval_bool OUT NOCOPY NUMBER
1114 );
1115
1116
1117 procedure Save_Tca_Entities(p1_a0 VARCHAR2 := FND_API.G_MISS_CHAR
1118 , p1_a1 VARCHAR2 := FND_API.G_MISS_CHAR
1119 , p1_a2 VARCHAR2 := FND_API.G_MISS_CHAR
1120 , p1_a3 VARCHAR2 := FND_API.G_MISS_CHAR
1121 , p1_a4 VARCHAR2 := FND_API.G_MISS_CHAR
1122 , p1_a5 VARCHAR2 := FND_API.G_MISS_CHAR
1123 , p1_a6 VARCHAR2 := FND_API.G_MISS_CHAR
1124 , p1_a7 VARCHAR2 := FND_API.G_MISS_CHAR
1125 , p1_a8 VARCHAR2 := FND_API.G_MISS_CHAR
1126 , p1_a9 VARCHAR2 := FND_API.G_MISS_CHAR
1127 , p1_a10 VARCHAR2 := FND_API.G_MISS_CHAR
1128 , p1_a11 VARCHAR2 := FND_API.G_MISS_CHAR
1129 , p1_a12 VARCHAR2 := FND_API.G_MISS_CHAR
1130 , p1_a13 VARCHAR2 := FND_API.G_MISS_CHAR
1131 , p1_a14 VARCHAR2 := FND_API.G_MISS_CHAR
1132 , p1_a15 VARCHAR2 := FND_API.G_MISS_CHAR
1133 , p1_a16 VARCHAR2 := FND_API.G_MISS_CHAR
1134 , p1_a17 VARCHAR2 := FND_API.G_MISS_CHAR
1135 , p1_a18 VARCHAR2 := FND_API.G_MISS_CHAR
1136 , p1_a19 VARCHAR2 := FND_API.G_MISS_CHAR
1137 , p1_a20 VARCHAR2 := FND_API.G_MISS_CHAR
1138 , p1_a21 VARCHAR2 := FND_API.G_MISS_CHAR
1139 , p1_a22 DATE := FND_API.G_MISS_DATE
1140 , p1_a23 VARCHAR2 := FND_API.G_MISS_CHAR
1141 , p1_a24 DATE := FND_API.G_MISS_DATE
1142 , p1_a25 VARCHAR2 := FND_API.G_MISS_CHAR
1143 , p1_a26 VARCHAR2 := FND_API.G_MISS_CHAR
1144 , p1_a27 VARCHAR2 := FND_API.G_MISS_CHAR
1145 , p1_a28 DATE := FND_API.G_MISS_DATE
1146 , p1_a29 NUMBER := FND_API.G_MISS_NUM
1147 , p1_a30 VARCHAR2 := FND_API.G_MISS_CHAR
1148 , p1_a31 NUMBER := FND_API.G_MISS_NUM
1149 , p1_a32 NUMBER := FND_API.G_MISS_NUM
1150 , p1_a33 VARCHAR2 := FND_API.G_MISS_CHAR
1151 , p1_a34 VARCHAR2 := FND_API.G_MISS_CHAR
1152 , p1_a35 VARCHAR2 := FND_API.G_MISS_CHAR
1153 , p1_a36 VARCHAR2 := FND_API.G_MISS_CHAR
1154 , p1_a37 VARCHAR2 := FND_API.G_MISS_CHAR
1155 , p1_a38 VARCHAR2 := FND_API.G_MISS_CHAR
1156 , p1_a39 VARCHAR2 := FND_API.G_MISS_CHAR
1157 , p1_a40 VARCHAR2 := FND_API.G_MISS_CHAR
1158 , p1_a41 VARCHAR2 := FND_API.G_MISS_CHAR
1159 , p1_a42 VARCHAR2 := FND_API.G_MISS_CHAR
1160 , p1_a43 VARCHAR2 := FND_API.G_MISS_CHAR
1161 , p1_a44 VARCHAR2 := FND_API.G_MISS_CHAR
1162 , p1_a45 VARCHAR2 := FND_API.G_MISS_CHAR
1163 , p1_a46 VARCHAR2 := FND_API.G_MISS_CHAR
1164 , p1_a47 VARCHAR2 := FND_API.G_MISS_CHAR
1165 , p1_a48 VARCHAR2 := FND_API.G_MISS_CHAR
1166 , p1_a49 VARCHAR2 := FND_API.G_MISS_CHAR
1167 , p1_a50 VARCHAR2 := FND_API.G_MISS_CHAR
1168 , p1_a51 VARCHAR2 := FND_API.G_MISS_CHAR
1169 , p1_a52 VARCHAR2 := FND_API.G_MISS_CHAR
1170 , p1_a53 VARCHAR2 := FND_API.G_MISS_CHAR
1171 , p1_a54 VARCHAR2 := FND_API.G_MISS_CHAR
1172 , p1_a55 VARCHAR2 := FND_API.G_MISS_CHAR
1173 , p1_a56 VARCHAR2 := FND_API.G_MISS_CHAR
1174 , p1_a57 VARCHAR2 := FND_API.G_MISS_CHAR
1175 , p1_a58 VARCHAR2 := FND_API.G_MISS_CHAR
1176 , p1_a59 NUMBER := FND_API.G_MISS_NUM
1177 , p1_a60 VARCHAR2 := FND_API.G_MISS_CHAR
1178 , p1_a61 NUMBER := FND_API.G_MISS_NUM
1179 , p1_a62 VARCHAR2 := FND_API.G_MISS_CHAR
1180 , p1_a63 VARCHAR2 := FND_API.G_MISS_CHAR
1184 , p1_a67 VARCHAR2 := FND_API.G_MISS_CHAR
1181 , p1_a64 VARCHAR2 := FND_API.G_MISS_CHAR
1182 , p1_a65 VARCHAR2 := FND_API.G_MISS_CHAR
1183 , p1_a66 VARCHAR2 := FND_API.G_MISS_CHAR
1185 , p1_a68 VARCHAR2 := FND_API.G_MISS_CHAR
1186 , p1_a69 VARCHAR2 := FND_API.G_MISS_CHAR
1187 , p1_a70 VARCHAR2 := FND_API.G_MISS_CHAR
1188 , p1_a71 VARCHAR2 := FND_API.G_MISS_CHAR
1189 , p1_a72 VARCHAR2 := FND_API.G_MISS_CHAR
1190 , p1_a73 VARCHAR2 := FND_API.G_MISS_CHAR
1191 , p1_a74 VARCHAR2 := FND_API.G_MISS_CHAR
1192 , p1_a75 VARCHAR2 := FND_API.G_MISS_CHAR
1193 , p1_a76 VARCHAR2 := FND_API.G_MISS_CHAR
1194 , p1_a77 VARCHAR2 := FND_API.G_MISS_CHAR
1195 , p1_a78 VARCHAR2 := FND_API.G_MISS_CHAR
1196 , p1_a79 VARCHAR2 := FND_API.G_MISS_CHAR
1197 , p1_a80 VARCHAR2 := FND_API.G_MISS_CHAR
1198 , p1_a81 VARCHAR2 := FND_API.G_MISS_CHAR
1199 , p1_a82 VARCHAR2 := FND_API.G_MISS_CHAR
1200 , p1_a83 VARCHAR2 := FND_API.G_MISS_CHAR
1201 , p1_a84 VARCHAR2 := FND_API.G_MISS_CHAR
1202 , p1_a85 VARCHAR2 := FND_API.G_MISS_CHAR
1203 , p1_a86 VARCHAR2 := FND_API.G_MISS_CHAR
1204 , p1_a87 VARCHAR2 := FND_API.G_MISS_CHAR
1205 , p1_a88 VARCHAR2 := FND_API.G_MISS_CHAR
1206 , p1_a89 VARCHAR2 := FND_API.G_MISS_CHAR
1207 , p1_a90 VARCHAR2 := FND_API.G_MISS_CHAR
1208 , p1_a91 VARCHAR2 := FND_API.G_MISS_CHAR
1209 , p1_a92 VARCHAR2 := FND_API.G_MISS_CHAR
1210 , p_person_object_version_number NUMBER := FND_API.G_MISS_NUM
1211 , p_email_contact_point_id NUMBER := FND_API.G_MISS_NUM
1212 , p2_a0 VARCHAR2 := FND_API.G_MISS_CHAR
1213 , p2_a1 VARCHAR2 := FND_API.G_MISS_CHAR
1214 , p_email_object_version_number NUMBER := FND_API.G_MISS_NUM
1215 , p_workph_contact_point_id NUMBER := FND_API.G_MISS_NUM
1216 , p3_a0 VARCHAR2 := FND_API.G_MISS_CHAR
1217 , p3_a1 DATE := FND_API.G_MISS_DATE
1218 , p3_a2 NUMBER := FND_API.G_MISS_NUM
1219 , p3_a3 VARCHAR2 := FND_API.G_MISS_CHAR
1220 , p3_a4 VARCHAR2 := FND_API.G_MISS_CHAR
1221 , p3_a5 VARCHAR2 := FND_API.G_MISS_CHAR
1222 , p3_a6 VARCHAR2 := FND_API.G_MISS_CHAR
1223 , p3_a7 VARCHAR2 := FND_API.G_MISS_CHAR
1224 , p3_a8 VARCHAR2 := FND_API.G_MISS_CHAR
1225 , p_workph_object_version_number NUMBER := FND_API.G_MISS_NUM
1226 , p_homeph_contact_point_id NUMBER := FND_API.G_MISS_NUM
1227 , p4_a0 VARCHAR2 := FND_API.G_MISS_CHAR
1228 , p4_a1 DATE := FND_API.G_MISS_DATE
1229 , p4_a2 NUMBER := FND_API.G_MISS_NUM
1230 , p4_a3 VARCHAR2 := FND_API.G_MISS_CHAR
1231 , p4_a4 VARCHAR2 := FND_API.G_MISS_CHAR
1232 , p4_a5 VARCHAR2 := FND_API.G_MISS_CHAR
1233 , p4_a6 VARCHAR2 := FND_API.G_MISS_CHAR
1234 , p4_a7 VARCHAR2 := FND_API.G_MISS_CHAR
1235 , p4_a8 VARCHAR2 := FND_API.G_MISS_CHAR
1236 , p_homeph_object_version_number NUMBER := FND_API.G_MISS_NUM
1237 , p_fax_contact_point_id NUMBER := FND_API.G_MISS_NUM
1238 , p5_a0 VARCHAR2 := FND_API.G_MISS_CHAR
1239 , p5_a1 DATE := FND_API.G_MISS_DATE
1240 , p5_a2 NUMBER := FND_API.G_MISS_NUM
1241 , p5_a3 VARCHAR2 := FND_API.G_MISS_CHAR
1242 , p5_a4 VARCHAR2 := FND_API.G_MISS_CHAR
1243 , p5_a5 VARCHAR2 := FND_API.G_MISS_CHAR
1244 , p5_a6 VARCHAR2 := FND_API.G_MISS_CHAR
1245 , p5_a7 VARCHAR2 := FND_API.G_MISS_CHAR
1246 , p5_a8 VARCHAR2 := FND_API.G_MISS_CHAR
1247 , p_fax_object_version_number NUMBER := FND_API.G_MISS_NUM
1251 , p_cntct_level_table_id NUMBER := FND_API.G_MISS_NUM
1248 , p_contact_preference_id NUMBER := FND_API.G_MISS_NUM
1249 , p_contact_preference VARCHAR2 := FND_API.G_MISS_CHAR
1250 , p_cntct_pref_object_ver_num NUMBER := FND_API.G_MISS_NUM
1252 , p_cntct_level_table_name VARCHAR2 := FND_API.G_MISS_CHAR
1253 , p6_a0 VARCHAR2 := FND_API.G_MISS_CHAR
1254 , p6_a1 VARCHAR2 := FND_API.G_MISS_CHAR
1255 , p6_a2 VARCHAR2 := FND_API.G_MISS_CHAR
1256 , p6_a3 VARCHAR2 := FND_API.G_MISS_CHAR
1257 , p6_a4 VARCHAR2 := FND_API.G_MISS_CHAR
1258 , p6_a5 VARCHAR2 := FND_API.G_MISS_CHAR
1259 , p6_a6 VARCHAR2 := FND_API.G_MISS_CHAR
1260 , p6_a7 VARCHAR2 := FND_API.G_MISS_CHAR
1261 , p6_a8 NUMBER := FND_API.G_MISS_NUM
1262 , p6_a9 NUMBER := FND_API.G_MISS_NUM
1263 , p6_a10 VARCHAR2 := FND_API.G_MISS_CHAR
1264 , p6_a11 VARCHAR2 := FND_API.G_MISS_CHAR
1265 , p6_a12 VARCHAR2 := FND_API.G_MISS_CHAR
1266 , p6_a13 VARCHAR2 := FND_API.G_MISS_CHAR
1267 , p6_a14 VARCHAR2 := FND_API.G_MISS_CHAR
1268 , p6_a15 VARCHAR2 := FND_API.G_MISS_CHAR
1269 , p6_a16 VARCHAR2 := FND_API.G_MISS_CHAR
1270 , p6_a17 VARCHAR2 := FND_API.G_MISS_CHAR
1271 , p6_a18 VARCHAR2 := FND_API.G_MISS_CHAR
1272 , p6_a19 VARCHAR2 := FND_API.G_MISS_CHAR
1273 , p6_a20 VARCHAR2 := FND_API.G_MISS_CHAR
1274 , p6_a21 VARCHAR2 := FND_API.G_MISS_CHAR
1275 , p6_a22 VARCHAR2 := FND_API.G_MISS_CHAR
1276 , p6_a23 VARCHAR2 := FND_API.G_MISS_CHAR
1277 , p6_a24 VARCHAR2 := FND_API.G_MISS_CHAR
1278 , p6_a25 VARCHAR2 := FND_API.G_MISS_CHAR
1279 , p6_a26 NUMBER := FND_API.G_MISS_NUM
1280 , p6_a27 DATE := FND_API.G_MISS_DATE
1281 , p6_a28 VARCHAR2 := FND_API.G_MISS_CHAR
1282 , p6_a29 NUMBER := FND_API.G_MISS_NUM
1283 , p6_a30 VARCHAR2 := FND_API.G_MISS_CHAR
1284 , p6_a31 VARCHAR2 := FND_API.G_MISS_CHAR
1285 , p6_a32 VARCHAR2 := FND_API.G_MISS_CHAR
1286 , p6_a33 VARCHAR2 := FND_API.G_MISS_CHAR
1287 , p6_a34 VARCHAR2 := FND_API.G_MISS_CHAR
1288 , p6_a35 VARCHAR2 := FND_API.G_MISS_CHAR
1289 , p6_a36 VARCHAR2 := FND_API.G_MISS_CHAR
1290 , p6_a37 VARCHAR2 := FND_API.G_MISS_CHAR
1291 , p6_a38 VARCHAR2 := FND_API.G_MISS_CHAR
1292 , p6_a39 DATE := FND_API.G_MISS_DATE
1293 , p6_a40 DATE := FND_API.G_MISS_DATE
1294 , p6_a41 VARCHAR2 := FND_API.G_MISS_CHAR
1295 , p6_a42 VARCHAR2 := FND_API.G_MISS_CHAR
1296 , p6_a43 VARCHAR2 := FND_API.G_MISS_CHAR
1297 , p6_a44 VARCHAR2 := FND_API.G_MISS_CHAR
1298 , p6_a45 VARCHAR2 := FND_API.G_MISS_CHAR
1299 , p6_a46 VARCHAR2 := FND_API.G_MISS_CHAR
1300 , p6_a47 NUMBER := FND_API.G_MISS_NUM
1301 , p6_a48 NUMBER := FND_API.G_MISS_NUM
1302 , p6_a49 NUMBER := FND_API.G_MISS_NUM
1303 , p6_a50 VARCHAR2 := FND_API.G_MISS_CHAR
1304 , p6_a51 VARCHAR2 := FND_API.G_MISS_CHAR
1305 , p6_a52 VARCHAR2 := FND_API.G_MISS_CHAR
1306 , p6_a53 VARCHAR2 := FND_API.G_MISS_CHAR
1307 , p6_a54 VARCHAR2 := FND_API.G_MISS_CHAR
1308 , p6_a55 VARCHAR2 := FND_API.G_MISS_CHAR
1309 , p6_a56 VARCHAR2 := FND_API.G_MISS_CHAR
1310 , p6_a57 VARCHAR2 := FND_API.G_MISS_CHAR
1311 , p6_a58 VARCHAR2 := FND_API.G_MISS_CHAR
1312 , p6_a59 VARCHAR2 := FND_API.G_MISS_CHAR
1313 , p6_a60 VARCHAR2 := FND_API.G_MISS_CHAR
1314 , p6_a61 VARCHAR2 := FND_API.G_MISS_CHAR
1318 , p6_a65 VARCHAR2 := FND_API.G_MISS_CHAR
1315 , p6_a62 VARCHAR2 := FND_API.G_MISS_CHAR
1316 , p6_a63 VARCHAR2 := FND_API.G_MISS_CHAR
1317 , p6_a64 VARCHAR2 := FND_API.G_MISS_CHAR
1319 , p6_a66 VARCHAR2 := FND_API.G_MISS_CHAR
1320 , p6_a67 VARCHAR2 := FND_API.G_MISS_CHAR
1321 , p6_a68 NUMBER := FND_API.G_MISS_NUM
1322 , p6_a69 VARCHAR2 := FND_API.G_MISS_CHAR
1323 , p6_a70 VARCHAR2 := FND_API.G_MISS_CHAR
1324 , p6_a71 VARCHAR2 := FND_API.G_MISS_CHAR
1325 , p6_a72 VARCHAR2 := FND_API.G_MISS_CHAR
1326 , p6_a73 VARCHAR2 := FND_API.G_MISS_CHAR
1327 , p6_a74 VARCHAR2 := FND_API.G_MISS_CHAR
1328 , p6_a75 VARCHAR2 := FND_API.G_MISS_CHAR
1329 , p6_a76 VARCHAR2 := FND_API.G_MISS_CHAR
1330 , p6_a77 VARCHAR2 := FND_API.G_MISS_CHAR
1331 , p6_a78 NUMBER := FND_API.G_MISS_NUM
1332 , p6_a79 NUMBER := FND_API.G_MISS_NUM
1333 , p6_a80 NUMBER := FND_API.G_MISS_NUM
1334 , p6_a81 NUMBER := FND_API.G_MISS_NUM
1335 , p6_a82 NUMBER := FND_API.G_MISS_NUM
1336 , p6_a83 NUMBER := FND_API.G_MISS_NUM
1337 , p6_a84 NUMBER := FND_API.G_MISS_NUM
1338 , p6_a85 DATE := FND_API.G_MISS_DATE
1339 , p6_a86 VARCHAR2 := FND_API.G_MISS_CHAR
1340 , p6_a87 VARCHAR2 := FND_API.G_MISS_CHAR
1341 , p6_a88 VARCHAR2 := FND_API.G_MISS_CHAR
1342 , p6_a89 VARCHAR2 := FND_API.G_MISS_CHAR
1343 , p6_a90 VARCHAR2 := FND_API.G_MISS_CHAR
1344 , p6_a91 VARCHAR2 := FND_API.G_MISS_CHAR
1345 , p6_a92 VARCHAR2 := FND_API.G_MISS_CHAR
1346 , p6_a93 VARCHAR2 := FND_API.G_MISS_CHAR
1347 , p6_a94 VARCHAR2 := FND_API.G_MISS_CHAR
1348 , p6_a95 NUMBER := FND_API.G_MISS_NUM
1349 , p6_a96 NUMBER := FND_API.G_MISS_NUM
1350 , p6_a97 NUMBER := FND_API.G_MISS_NUM
1351 , p6_a98 DATE := FND_API.G_MISS_DATE
1352 , p6_a99 VARCHAR2 := FND_API.G_MISS_CHAR
1353 , p6_a100 VARCHAR2 := FND_API.G_MISS_CHAR
1354 , p6_a101 VARCHAR2 := FND_API.G_MISS_CHAR
1355 , p6_a102 VARCHAR2 := FND_API.G_MISS_CHAR
1356 , p6_a103 VARCHAR2 := FND_API.G_MISS_CHAR
1357 , p6_a104 VARCHAR2 := FND_API.G_MISS_CHAR
1358 , p6_a105 VARCHAR2 := FND_API.G_MISS_CHAR
1359 , p6_a106 VARCHAR2 := FND_API.G_MISS_CHAR
1360 , p6_a107 VARCHAR2 := FND_API.G_MISS_CHAR
1361 , p6_a108 NUMBER := FND_API.G_MISS_NUM
1362 , p6_a109 VARCHAR2 := FND_API.G_MISS_CHAR
1363 , p6_a110 NUMBER := FND_API.G_MISS_NUM
1364 , p6_a111 VARCHAR2 := FND_API.G_MISS_CHAR
1365 , p6_a112 VARCHAR2 := FND_API.G_MISS_CHAR
1366 , p6_a113 VARCHAR2 := FND_API.G_MISS_CHAR
1367 , p6_a114 VARCHAR2 := FND_API.G_MISS_CHAR
1368 , p6_a115 VARCHAR2 := FND_API.G_MISS_CHAR
1369 , p6_a116 VARCHAR2 := FND_API.G_MISS_CHAR
1370 , p6_a117 VARCHAR2 := FND_API.G_MISS_CHAR
1371 , p6_a118 VARCHAR2 := FND_API.G_MISS_CHAR
1372 , p6_a119 VARCHAR2 := FND_API.G_MISS_CHAR
1373 , p6_a120 VARCHAR2 := FND_API.G_MISS_CHAR
1374 , p6_a121 VARCHAR2 := FND_API.G_MISS_CHAR
1375 , p6_a122 VARCHAR2 := FND_API.G_MISS_CHAR
1376 , p6_a123 VARCHAR2 := FND_API.G_MISS_CHAR
1377 , p6_a124 VARCHAR2 := FND_API.G_MISS_CHAR
1378 , p6_a125 VARCHAR2 := FND_API.G_MISS_CHAR
1379 , p6_a126 VARCHAR2 := FND_API.G_MISS_CHAR
1380 , p6_a127 VARCHAR2 := FND_API.G_MISS_CHAR
1381 , p6_a128 VARCHAR2 := FND_API.G_MISS_CHAR
1382 , p6_a129 VARCHAR2 := FND_API.G_MISS_CHAR
1383 , p6_a130 VARCHAR2 := FND_API.G_MISS_CHAR
1384 , p6_a131 VARCHAR2 := FND_API.G_MISS_CHAR
1385 , p6_a132 VARCHAR2 := FND_API.G_MISS_CHAR
1386 , p6_a133 VARCHAR2 := FND_API.G_MISS_CHAR
1387 , p6_a134 VARCHAR2 := FND_API.G_MISS_CHAR
1388 , p6_a135 NUMBER := FND_API.G_MISS_NUM
1389 , p6_a136 VARCHAR2 := FND_API.G_MISS_CHAR
1390 , p6_a137 VARCHAR2 := FND_API.G_MISS_CHAR
1391 , p6_a138 NUMBER := FND_API.G_MISS_NUM
1392 , p6_a139 VARCHAR2 := FND_API.G_MISS_CHAR
1393 , p6_a140 VARCHAR2 := FND_API.G_MISS_CHAR
1394 , p6_a141 VARCHAR2 := FND_API.G_MISS_CHAR
1395 , p6_a142 VARCHAR2 := FND_API.G_MISS_CHAR
1396 , p6_a143 VARCHAR2 := FND_API.G_MISS_CHAR
1397 , p6_a144 VARCHAR2 := FND_API.G_MISS_CHAR
1398 , p6_a145 VARCHAR2 := FND_API.G_MISS_CHAR
1399 , p6_a146 VARCHAR2 := FND_API.G_MISS_CHAR
1400 , p6_a147 VARCHAR2 := FND_API.G_MISS_CHAR
1401 , p6_a148 VARCHAR2 := FND_API.G_MISS_CHAR
1402 , p6_a149 VARCHAR2 := FND_API.G_MISS_CHAR
1403 , p6_a150 VARCHAR2 := FND_API.G_MISS_CHAR
1404 , p6_a151 VARCHAR2 := FND_API.G_MISS_CHAR
1405 , p6_a152 VARCHAR2 := FND_API.G_MISS_CHAR
1406 , p6_a153 VARCHAR2 := FND_API.G_MISS_CHAR
1407 , p6_a154 VARCHAR2 := FND_API.G_MISS_CHAR
1408 , p6_a155 VARCHAR2 := FND_API.G_MISS_CHAR
1409 , p6_a156 VARCHAR2 := FND_API.G_MISS_CHAR
1410 , p6_a157 VARCHAR2 := FND_API.G_MISS_CHAR
1411 , p6_a158 VARCHAR2 := FND_API.G_MISS_CHAR
1412 , p6_a159 VARCHAR2 := FND_API.G_MISS_CHAR
1413 , p6_a160 VARCHAR2 := FND_API.G_MISS_CHAR
1414 , p6_a161 VARCHAR2 := FND_API.G_MISS_CHAR
1415 , p6_a162 VARCHAR2 := FND_API.G_MISS_CHAR
1416 , p6_a163 VARCHAR2 := FND_API.G_MISS_CHAR
1417 , p6_a164 VARCHAR2 := FND_API.G_MISS_CHAR
1418 , p6_a165 VARCHAR2 := FND_API.G_MISS_CHAR
1419 , p6_a166 VARCHAR2 := FND_API.G_MISS_CHAR
1420 , p6_a167 VARCHAR2 := FND_API.G_MISS_CHAR
1421 , p6_a168 VARCHAR2 := FND_API.G_MISS_CHAR
1422 , p6_a169 VARCHAR2 := FND_API.G_MISS_CHAR
1423 , p_org_object_version_number NUMBER := FND_API.G_MISS_NUM
1424 , p7_a0 NUMBER := FND_API.G_MISS_NUM
1425 , p7_a1 VARCHAR2 := FND_API.G_MISS_CHAR
1426 , p7_a2 VARCHAR2 := FND_API.G_MISS_CHAR
1427 , p7_a3 VARCHAR2 := FND_API.G_MISS_CHAR
1428 , p7_a4 VARCHAR2 := FND_API.G_MISS_CHAR
1429 , p7_a5 VARCHAR2 := FND_API.G_MISS_CHAR
1430 , p7_a6 VARCHAR2 := FND_API.G_MISS_CHAR
1431 , p7_a7 VARCHAR2 := FND_API.G_MISS_CHAR
1432 , p7_a8 VARCHAR2 := FND_API.G_MISS_CHAR
1433 , p7_a9 VARCHAR2 := FND_API.G_MISS_CHAR
1434 , p7_a10 VARCHAR2 := FND_API.G_MISS_CHAR
1435 , p7_a11 VARCHAR2 := FND_API.G_MISS_CHAR
1436 , p7_a12 VARCHAR2 := FND_API.G_MISS_CHAR
1437 , p7_a13 VARCHAR2 := FND_API.G_MISS_CHAR
1438 , p7_a14 VARCHAR2 := FND_API.G_MISS_CHAR
1439 , p7_a15 VARCHAR2 := FND_API.G_MISS_CHAR
1440 , p7_a16 VARCHAR2 := FND_API.G_MISS_CHAR
1441 , p7_a17 VARCHAR2 := FND_API.G_MISS_CHAR
1442 , p7_a18 VARCHAR2 := FND_API.G_MISS_CHAR
1443 , p7_a19 VARCHAR2 := FND_API.G_MISS_CHAR
1444 , p7_a20 VARCHAR2 := FND_API.G_MISS_CHAR
1445 , p7_a21 VARCHAR2 := FND_API.G_MISS_CHAR
1446 , p7_a22 VARCHAR2 := FND_API.G_MISS_CHAR
1447 , p7_a23 VARCHAR2 := FND_API.G_MISS_CHAR
1448 , p7_a24 VARCHAR2 := FND_API.G_MISS_CHAR
1449 , p7_a25 VARCHAR2 := FND_API.G_MISS_CHAR
1450 , p7_a26 DATE := FND_API.G_MISS_DATE
1451 , p7_a27 VARCHAR2 := FND_API.G_MISS_CHAR
1452 , p7_a28 VARCHAR2 := FND_API.G_MISS_CHAR
1453 , p7_a29 VARCHAR2 := FND_API.G_MISS_CHAR
1454 , p7_a30 VARCHAR2 := FND_API.G_MISS_CHAR
1455 , p7_a31 NUMBER := FND_API.G_MISS_NUM
1456 , p7_a32 VARCHAR2 := FND_API.G_MISS_CHAR
1457 , p7_a33 VARCHAR2 := FND_API.G_MISS_CHAR
1458 , p7_a34 NUMBER := FND_API.G_MISS_NUM
1459 , p7_a35 VARCHAR2 := FND_API.G_MISS_CHAR
1460 , p7_a36 VARCHAR2 := FND_API.G_MISS_CHAR
1461 , p7_a37 VARCHAR2 := FND_API.G_MISS_CHAR
1462 , p7_a38 VARCHAR2 := FND_API.G_MISS_CHAR
1463 , p7_a39 VARCHAR2 := FND_API.G_MISS_CHAR
1464 , p7_a40 VARCHAR2 := FND_API.G_MISS_CHAR
1465 , p7_a41 VARCHAR2 := FND_API.G_MISS_CHAR
1466 , p7_a42 VARCHAR2 := FND_API.G_MISS_CHAR
1467 , p7_a43 VARCHAR2 := FND_API.G_MISS_CHAR
1468 , p7_a44 VARCHAR2 := FND_API.G_MISS_CHAR
1469 , p7_a45 VARCHAR2 := FND_API.G_MISS_CHAR
1470 , p7_a46 VARCHAR2 := FND_API.G_MISS_CHAR
1471 , p7_a47 VARCHAR2 := FND_API.G_MISS_CHAR
1472 , p7_a48 VARCHAR2 := FND_API.G_MISS_CHAR
1473 , p7_a49 VARCHAR2 := FND_API.G_MISS_CHAR
1474 , p7_a50 VARCHAR2 := FND_API.G_MISS_CHAR
1475 , p7_a51 VARCHAR2 := FND_API.G_MISS_CHAR
1476 , p7_a52 VARCHAR2 := FND_API.G_MISS_CHAR
1477 , p7_a53 VARCHAR2 := FND_API.G_MISS_CHAR
1478 , p7_a54 VARCHAR2 := FND_API.G_MISS_CHAR
1479 , p7_a55 VARCHAR2 := FND_API.G_MISS_CHAR
1480 , p7_a56 VARCHAR2 := FND_API.G_MISS_CHAR
1481 , p7_a57 NUMBER := FND_API.G_MISS_NUM
1482 , p7_a58 VARCHAR2 := FND_API.G_MISS_CHAR
1483 , p7_a59 NUMBER := FND_API.G_MISS_NUM
1484 , p7_a60 VARCHAR2 := FND_API.G_MISS_CHAR
1485 , p_loc_object_version_number NUMBER := FND_API.G_MISS_NUM
1486 , p_orgph_contact_point_id NUMBER := FND_API.G_MISS_NUM
1487 , p8_a0 VARCHAR2 := FND_API.G_MISS_CHAR
1488 , p8_a1 DATE := FND_API.G_MISS_DATE
1489 , p8_a2 NUMBER := FND_API.G_MISS_NUM
1490 , p8_a3 VARCHAR2 := FND_API.G_MISS_CHAR
1491 , p8_a4 VARCHAR2 := FND_API.G_MISS_CHAR
1492 , p8_a5 VARCHAR2 := FND_API.G_MISS_CHAR
1493 , p8_a6 VARCHAR2 := FND_API.G_MISS_CHAR
1494 , p8_a7 VARCHAR2 := FND_API.G_MISS_CHAR
1495 , p8_a8 VARCHAR2 := FND_API.G_MISS_CHAR
1496 , p_orgph_object_version_number NUMBER := FND_API.G_MISS_NUM
1497 , p_orgfax_contact_point_id NUMBER := FND_API.G_MISS_NUM
1498 , p9_a0 VARCHAR2 := FND_API.G_MISS_CHAR
1499 , p9_a1 DATE := FND_API.G_MISS_DATE
1500 , p9_a2 NUMBER := FND_API.G_MISS_NUM
1501 , p9_a3 VARCHAR2 := FND_API.G_MISS_CHAR
1502 , p9_a4 VARCHAR2 := FND_API.G_MISS_CHAR
1503 , p9_a5 VARCHAR2 := FND_API.G_MISS_CHAR
1504 , p9_a6 VARCHAR2 := FND_API.G_MISS_CHAR
1505 , p9_a7 VARCHAR2 := FND_API.G_MISS_CHAR
1506 , p9_a8 VARCHAR2 := FND_API.G_MISS_CHAR
1507 , p_orgfax_object_version_number NUMBER := FND_API.G_MISS_NUM
1508 , p_create_party_rel VARCHAR2 := FND_API.G_MISS_CHAR
1509 , p_created_by_module VARCHAR2 := FND_API.G_MISS_CHAR
1510 , x_person_party_id out nocopy NUMBER
1511 , x_rel_party_id out nocopy NUMBER
1512 , x_org_party_id out nocopy NUMBER
1513 , x_return_status out nocopy VARCHAR2
1514 , x_msg_count out nocopy NUMBER
1515 , x_msg_data out nocopy VARCHAR2
1516 );
1517
1518 end ibe_party_v2pvt_w;