[Home] [Help]
PACKAGE: APPS.FUN_VENDOR_PVT_PKG_W
Source
1 package fun_vendor_pvt_pkg_w AUTHID CURRENT_USER as
2 /* $Header: fun_vendor_pvt_pkg_w_s.pls 120.0 2006/02/15 14:30:49 ashikuma noship $ */
3 procedure create_vendor(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_validation_level NUMBER
7 , x_return_status out nocopy VARCHAR2
8 , x_msg_count out nocopy NUMBER
9 , x_msg_data out nocopy VARCHAR2
10 , p7_a0 NUMBER
11 , p7_a1 VARCHAR2
12 , p7_a2 VARCHAR2
13 , p7_a3 VARCHAR2
14 , p7_a4 VARCHAR2
15 , p7_a5 VARCHAR2
16 , p7_a6 VARCHAR2
17 , p7_a7 VARCHAR2
18 , p7_a8 VARCHAR2
19 , p7_a9 VARCHAR2
20 , p7_a10 NUMBER
21 , p7_a11 VARCHAR2
22 , p7_a12 VARCHAR2
23 , p7_a13 VARCHAR2
24 , p7_a14 NUMBER
25 , p7_a15 NUMBER
26 , p7_a16 NUMBER
27 , p7_a17 NUMBER
28 , p7_a18 VARCHAR2
29 , p7_a19 VARCHAR2
30 , p7_a20 VARCHAR2
31 , p7_a21 NUMBER
32 , p7_a22 VARCHAR2
33 , p7_a23 VARCHAR2
34 , p7_a24 NUMBER
35 , p7_a25 VARCHAR2
36 , p7_a26 VARCHAR2
37 , p7_a27 VARCHAR2
38 , p7_a28 VARCHAR2
39 , p7_a29 VARCHAR2
40 , p7_a30 DATE
41 , p7_a31 VARCHAR2
42 , p7_a32 DATE
43 , p7_a33 DATE
44 , p7_a34 VARCHAR2
45 , p7_a35 VARCHAR2
46 , p7_a36 VARCHAR2
47 , p7_a37 VARCHAR2
48 , p7_a38 VARCHAR2
49 , p7_a39 NUMBER
50 , p7_a40 DATE
51 , p7_a41 VARCHAR2
52 , p7_a42 VARCHAR2
53 , p7_a43 VARCHAR2
54 , p7_a44 NUMBER
55 , p7_a45 VARCHAR2
56 , p7_a46 VARCHAR2
57 , p7_a47 NUMBER
58 , p7_a48 NUMBER
59 , p7_a49 VARCHAR2
60 , p7_a50 NUMBER
61 , p7_a51 VARCHAR2
62 , p7_a52 VARCHAR2
63 , p7_a53 VARCHAR2
64 , p7_a54 DATE
65 , p7_a55 VARCHAR2
66 , p7_a56 VARCHAR2
67 , p7_a57 VARCHAR2
68 , p7_a58 VARCHAR2
69 , p7_a59 VARCHAR2
70 , p7_a60 VARCHAR2
71 , p7_a61 VARCHAR2
72 , p7_a62 VARCHAR2
73 , p7_a63 VARCHAR2
74 , p7_a64 VARCHAR2
75 , p7_a65 VARCHAR2
76 , p7_a66 VARCHAR2
77 , p7_a67 VARCHAR2
78 , p7_a68 VARCHAR2
79 , p7_a69 VARCHAR2
80 , p7_a70 VARCHAR2
81 , p7_a71 VARCHAR2
82 , p7_a72 VARCHAR2
83 , p7_a73 VARCHAR2
84 , p7_a74 VARCHAR2
85 , p7_a75 NUMBER
86 , p7_a76 VARCHAR2
87 , p7_a77 VARCHAR2
88 , p7_a78 VARCHAR2
89 , p7_a79 VARCHAR2
90 , p7_a80 NUMBER
91 , p7_a81 VARCHAR2
92 , p7_a82 VARCHAR2
93 , p7_a83 VARCHAR2
94 , p7_a84 VARCHAR2
95 , p7_a85 VARCHAR2
96 , p7_a86 VARCHAR2
97 , p7_a87 VARCHAR2
98 , p7_a88 VARCHAR2
99 , p7_a89 VARCHAR2
100 , p7_a90 VARCHAR2
101 , p7_a91 VARCHAR2
102 , p7_a92 VARCHAR2
103 , p7_a93 VARCHAR2
104 , p7_a94 VARCHAR2
105 , p7_a95 VARCHAR2
106 , p7_a96 VARCHAR2
107 , p7_a97 VARCHAR2
108 , p7_a98 VARCHAR2
109 , p7_a99 VARCHAR2
110 , p7_a100 VARCHAR2
111 , p7_a101 VARCHAR2
112 , p7_a102 VARCHAR2
113 , p7_a103 VARCHAR2
114 , p7_a104 VARCHAR2
115 , p7_a105 VARCHAR2
116 , p7_a106 NUMBER
117 , p7_a107 NUMBER
118 , p7_a108 VARCHAR2
119 , p7_a109 VARCHAR2
120 , p7_a110 VARCHAR2
121 , p7_a111 NUMBER
122 , p7_a112 VARCHAR2
123 , p7_a113 NUMBER
124 , p7_a114 NUMBER
125 , p7_a115 VARCHAR2
126 , p7_a116 NUMBER
127 , p7_a117 VARCHAR2
128 , p7_a118 VARCHAR2
129 , p7_a119 NUMBER
130 , p7_a120 NUMBER
131 , p7_a121 NUMBER
132 , p7_a122 VARCHAR2
133 , p7_a123 VARCHAR2
134 , p7_a124 VARCHAR2
135 , p7_a125 VARCHAR2
136 , p7_a126 VARCHAR2
137 , p7_a127 VARCHAR2
138 , p7_a128 VARCHAR2
139 , p7_a129 VARCHAR2
140 , p7_a130 VARCHAR2
141 , p7_a131 DATE
142 , p7_a132 VARCHAR2
143 , p7_a133 VARCHAR2
144 , p7_a134 VARCHAR2
145 , p7_a135 VARCHAR2
146 , p7_a136 VARCHAR2
147 , p7_a137 VARCHAR2
148 , x_vendor_id out nocopy NUMBER
149 , x_party_id out nocopy NUMBER
150 );
151 procedure update_vendor(p_api_version NUMBER
152 , p_init_msg_list VARCHAR2
153 , p_commit VARCHAR2
154 , p_validation_level NUMBER
155 , x_return_status out nocopy VARCHAR2
156 , x_msg_count out nocopy NUMBER
157 , x_msg_data out nocopy VARCHAR2
158 , p7_a0 NUMBER
159 , p7_a1 VARCHAR2
160 , p7_a2 VARCHAR2
161 , p7_a3 VARCHAR2
162 , p7_a4 VARCHAR2
163 , p7_a5 VARCHAR2
164 , p7_a6 VARCHAR2
165 , p7_a7 VARCHAR2
166 , p7_a8 VARCHAR2
167 , p7_a9 VARCHAR2
168 , p7_a10 NUMBER
169 , p7_a11 VARCHAR2
170 , p7_a12 VARCHAR2
171 , p7_a13 VARCHAR2
172 , p7_a14 NUMBER
173 , p7_a15 NUMBER
174 , p7_a16 NUMBER
175 , p7_a17 NUMBER
176 , p7_a18 VARCHAR2
177 , p7_a19 VARCHAR2
178 , p7_a20 VARCHAR2
179 , p7_a21 NUMBER
180 , p7_a22 VARCHAR2
181 , p7_a23 VARCHAR2
182 , p7_a24 NUMBER
183 , p7_a25 VARCHAR2
184 , p7_a26 VARCHAR2
185 , p7_a27 VARCHAR2
186 , p7_a28 VARCHAR2
187 , p7_a29 VARCHAR2
188 , p7_a30 DATE
189 , p7_a31 VARCHAR2
190 , p7_a32 DATE
191 , p7_a33 DATE
192 , p7_a34 VARCHAR2
193 , p7_a35 VARCHAR2
194 , p7_a36 VARCHAR2
195 , p7_a37 VARCHAR2
196 , p7_a38 VARCHAR2
197 , p7_a39 NUMBER
198 , p7_a40 DATE
199 , p7_a41 VARCHAR2
200 , p7_a42 VARCHAR2
201 , p7_a43 VARCHAR2
202 , p7_a44 NUMBER
203 , p7_a45 VARCHAR2
204 , p7_a46 VARCHAR2
205 , p7_a47 NUMBER
206 , p7_a48 NUMBER
207 , p7_a49 VARCHAR2
208 , p7_a50 NUMBER
209 , p7_a51 VARCHAR2
210 , p7_a52 VARCHAR2
211 , p7_a53 VARCHAR2
212 , p7_a54 DATE
213 , p7_a55 VARCHAR2
214 , p7_a56 VARCHAR2
215 , p7_a57 VARCHAR2
216 , p7_a58 VARCHAR2
217 , p7_a59 VARCHAR2
218 , p7_a60 VARCHAR2
219 , p7_a61 VARCHAR2
220 , p7_a62 VARCHAR2
221 , p7_a63 VARCHAR2
222 , p7_a64 VARCHAR2
223 , p7_a65 VARCHAR2
224 , p7_a66 VARCHAR2
225 , p7_a67 VARCHAR2
226 , p7_a68 VARCHAR2
227 , p7_a69 VARCHAR2
228 , p7_a70 VARCHAR2
229 , p7_a71 VARCHAR2
230 , p7_a72 VARCHAR2
231 , p7_a73 VARCHAR2
232 , p7_a74 VARCHAR2
233 , p7_a75 NUMBER
234 , p7_a76 VARCHAR2
235 , p7_a77 VARCHAR2
236 , p7_a78 VARCHAR2
237 , p7_a79 VARCHAR2
238 , p7_a80 NUMBER
239 , p7_a81 VARCHAR2
240 , p7_a82 VARCHAR2
241 , p7_a83 VARCHAR2
242 , p7_a84 VARCHAR2
243 , p7_a85 VARCHAR2
244 , p7_a86 VARCHAR2
245 , p7_a87 VARCHAR2
246 , p7_a88 VARCHAR2
247 , p7_a89 VARCHAR2
248 , p7_a90 VARCHAR2
249 , p7_a91 VARCHAR2
250 , p7_a92 VARCHAR2
251 , p7_a93 VARCHAR2
252 , p7_a94 VARCHAR2
253 , p7_a95 VARCHAR2
254 , p7_a96 VARCHAR2
255 , p7_a97 VARCHAR2
256 , p7_a98 VARCHAR2
257 , p7_a99 VARCHAR2
258 , p7_a100 VARCHAR2
259 , p7_a101 VARCHAR2
260 , p7_a102 VARCHAR2
261 , p7_a103 VARCHAR2
262 , p7_a104 VARCHAR2
263 , p7_a105 VARCHAR2
264 , p7_a106 NUMBER
265 , p7_a107 NUMBER
266 , p7_a108 VARCHAR2
267 , p7_a109 VARCHAR2
268 , p7_a110 VARCHAR2
269 , p7_a111 NUMBER
270 , p7_a112 VARCHAR2
271 , p7_a113 NUMBER
272 , p7_a114 NUMBER
273 , p7_a115 VARCHAR2
274 , p7_a116 NUMBER
275 , p7_a117 VARCHAR2
276 , p7_a118 VARCHAR2
277 , p7_a119 NUMBER
278 , p7_a120 NUMBER
279 , p7_a121 NUMBER
280 , p7_a122 VARCHAR2
281 , p7_a123 VARCHAR2
282 , p7_a124 VARCHAR2
283 , p7_a125 VARCHAR2
284 , p7_a126 VARCHAR2
285 , p7_a127 VARCHAR2
286 , p7_a128 VARCHAR2
287 , p7_a129 VARCHAR2
288 , p7_a130 VARCHAR2
289 , p7_a131 DATE
290 , p7_a132 VARCHAR2
291 , p7_a133 VARCHAR2
292 , p7_a134 VARCHAR2
293 , p7_a135 VARCHAR2
294 , p7_a136 VARCHAR2
295 , p7_a137 VARCHAR2
296 , p_vendor_id NUMBER
297 );
298 procedure create_vendor_site(p_api_version NUMBER
299 , p_init_msg_list VARCHAR2
300 , p_commit VARCHAR2
301 , p_validation_level NUMBER
302 , x_return_status out nocopy VARCHAR2
303 , x_msg_count out nocopy NUMBER
304 , x_msg_data out nocopy VARCHAR2
305 , p7_a0 VARCHAR2
306 , p7_a1 VARCHAR2
307 , p7_a2 VARCHAR2
308 , p7_a3 NUMBER
309 , p7_a4 NUMBER
310 , p7_a5 VARCHAR2
311 , p7_a6 VARCHAR2
312 , p7_a7 VARCHAR2
313 , p7_a8 DATE
314 , p7_a9 VARCHAR2
315 , p7_a10 VARCHAR2
316 , p7_a11 VARCHAR2
317 , p7_a12 VARCHAR2
318 , p7_a13 NUMBER
319 , p7_a14 NUMBER
320 , p7_a15 NUMBER
321 , p7_a16 VARCHAR2
322 , p7_a17 NUMBER
323 , p7_a18 NUMBER
324 , p7_a19 NUMBER
325 , p7_a20 VARCHAR2
326 , p7_a21 VARCHAR2
327 , p7_a22 VARCHAR2
328 , p7_a23 VARCHAR2
329 , p7_a24 NUMBER
330 , p7_a25 DATE
331 , p7_a26 NUMBER
332 , p7_a27 NUMBER
333 , p7_a28 VARCHAR2
334 , p7_a29 VARCHAR2
335 , p7_a30 VARCHAR2
336 , p7_a31 VARCHAR2
337 , p7_a32 VARCHAR2
338 , p7_a33 VARCHAR2
339 , p7_a34 VARCHAR2
340 , p7_a35 VARCHAR2
341 , p7_a36 VARCHAR2
342 , p7_a37 VARCHAR2
343 , p7_a38 VARCHAR2
344 , p7_a39 VARCHAR2
345 , p7_a40 VARCHAR2
346 , p7_a41 VARCHAR2
347 , p7_a42 VARCHAR2
348 , p7_a43 VARCHAR2
349 , p7_a44 VARCHAR2
350 , p7_a45 VARCHAR2
351 , p7_a46 VARCHAR2
352 , p7_a47 VARCHAR2
353 , p7_a48 VARCHAR2
354 , p7_a49 VARCHAR2
355 , p7_a50 VARCHAR2
356 , p7_a51 VARCHAR2
357 , p7_a52 VARCHAR2
358 , p7_a53 VARCHAR2
359 , p7_a54 VARCHAR2
360 , p7_a55 NUMBER
361 , p7_a56 VARCHAR2
362 , p7_a57 VARCHAR2
363 , p7_a58 NUMBER
364 , p7_a59 VARCHAR2
365 , p7_a60 VARCHAR2
366 , p7_a61 NUMBER
367 , p7_a62 NUMBER
368 , p7_a63 VARCHAR2
369 , p7_a64 VARCHAR2
370 , p7_a65 VARCHAR2
371 , p7_a66 VARCHAR2
372 , p7_a67 VARCHAR2
373 , p7_a68 VARCHAR2
374 , p7_a69 VARCHAR2
375 , p7_a70 VARCHAR2
376 , p7_a71 VARCHAR2
377 , p7_a72 VARCHAR2
378 , p7_a73 VARCHAR2
379 , p7_a74 VARCHAR2
380 , p7_a75 VARCHAR2
381 , p7_a76 VARCHAR2
382 , p7_a77 VARCHAR2
383 , p7_a78 VARCHAR2
384 , p7_a79 VARCHAR2
385 , p7_a80 VARCHAR2
386 , p7_a81 VARCHAR2
387 , p7_a82 VARCHAR2
388 , p7_a83 VARCHAR2
389 , p7_a84 VARCHAR2
390 , p7_a85 VARCHAR2
391 , p7_a86 NUMBER
392 , p7_a87 VARCHAR2
393 , p7_a88 VARCHAR2
394 , p7_a89 VARCHAR2
395 , p7_a90 VARCHAR2
396 , p7_a91 NUMBER
397 , p7_a92 VARCHAR2
398 , p7_a93 VARCHAR2
399 , p7_a94 VARCHAR2
400 , p7_a95 VARCHAR2
401 , p7_a96 VARCHAR2
402 , p7_a97 VARCHAR2
403 , p7_a98 VARCHAR2
404 , p7_a99 NUMBER
405 , p7_a100 NUMBER
406 , p7_a101 VARCHAR2
407 , p7_a102 VARCHAR2
408 , p7_a103 VARCHAR2
409 , p7_a104 VARCHAR2
410 , p7_a105 VARCHAR2
411 , p7_a106 VARCHAR2
412 , p7_a107 VARCHAR2
413 , p7_a108 VARCHAR2
414 , p7_a109 VARCHAR2
415 , p7_a110 VARCHAR2
416 , p7_a111 VARCHAR2
417 , p7_a112 VARCHAR2
418 , p7_a113 VARCHAR2
419 , p7_a114 VARCHAR2
420 , p7_a115 VARCHAR2
421 , p7_a116 VARCHAR2
422 , p7_a117 NUMBER
423 , p7_a118 VARCHAR2
424 , p7_a119 VARCHAR2
425 , p7_a120 VARCHAR2
426 , p7_a121 VARCHAR2
427 , p7_a122 NUMBER
428 , p7_a123 NUMBER
429 , p7_a124 NUMBER
430 , p7_a125 NUMBER
431 , p7_a126 VARCHAR2
432 , p7_a127 NUMBER
433 , p7_a128 NUMBER
434 , p7_a129 NUMBER
435 , p7_a130 VARCHAR2
436 , p7_a131 VARCHAR2
437 , p7_a132 NUMBER
438 , p7_a133 NUMBER
439 , p7_a134 NUMBER
440 , p7_a135 VARCHAR2
441 , p7_a136 VARCHAR2
442 , p7_a137 VARCHAR2
443 , p7_a138 VARCHAR2
444 , p7_a139 VARCHAR2
445 , p7_a140 VARCHAR2
446 , p7_a141 VARCHAR2
447 , p7_a142 VARCHAR2
448 , p7_a143 VARCHAR2
449 , p7_a144 DATE
450 , p7_a145 VARCHAR2
451 , p7_a146 VARCHAR2
452 , p7_a147 VARCHAR2
453 , p7_a148 VARCHAR2
454 , p7_a149 VARCHAR2
455 , p7_a150 VARCHAR2
456 , p7_a151 NUMBER
457 , x_vendor_site_id out nocopy NUMBER
458 , x_party_site_id out nocopy NUMBER
459 , x_location_id out nocopy NUMBER
460 );
461 procedure update_vendor_site(p_api_version NUMBER
462 , p_init_msg_list VARCHAR2
463 , p_commit VARCHAR2
464 , p_validation_level NUMBER
465 , x_return_status out nocopy VARCHAR2
466 , x_msg_count out nocopy NUMBER
467 , x_msg_data out nocopy VARCHAR2
468 , p7_a0 VARCHAR2
469 , p7_a1 VARCHAR2
470 , p7_a2 VARCHAR2
471 , p7_a3 NUMBER
472 , p7_a4 NUMBER
473 , p7_a5 VARCHAR2
474 , p7_a6 VARCHAR2
475 , p7_a7 VARCHAR2
476 , p7_a8 DATE
477 , p7_a9 VARCHAR2
478 , p7_a10 VARCHAR2
479 , p7_a11 VARCHAR2
480 , p7_a12 VARCHAR2
481 , p7_a13 NUMBER
482 , p7_a14 NUMBER
483 , p7_a15 NUMBER
484 , p7_a16 VARCHAR2
485 , p7_a17 NUMBER
486 , p7_a18 NUMBER
487 , p7_a19 NUMBER
488 , p7_a20 VARCHAR2
489 , p7_a21 VARCHAR2
490 , p7_a22 VARCHAR2
491 , p7_a23 VARCHAR2
492 , p7_a24 NUMBER
493 , p7_a25 DATE
494 , p7_a26 NUMBER
495 , p7_a27 NUMBER
496 , p7_a28 VARCHAR2
497 , p7_a29 VARCHAR2
498 , p7_a30 VARCHAR2
499 , p7_a31 VARCHAR2
500 , p7_a32 VARCHAR2
501 , p7_a33 VARCHAR2
502 , p7_a34 VARCHAR2
503 , p7_a35 VARCHAR2
504 , p7_a36 VARCHAR2
508 , p7_a40 VARCHAR2
505 , p7_a37 VARCHAR2
506 , p7_a38 VARCHAR2
507 , p7_a39 VARCHAR2
509 , p7_a41 VARCHAR2
510 , p7_a42 VARCHAR2
511 , p7_a43 VARCHAR2
512 , p7_a44 VARCHAR2
513 , p7_a45 VARCHAR2
514 , p7_a46 VARCHAR2
515 , p7_a47 VARCHAR2
516 , p7_a48 VARCHAR2
517 , p7_a49 VARCHAR2
518 , p7_a50 VARCHAR2
519 , p7_a51 VARCHAR2
520 , p7_a52 VARCHAR2
521 , p7_a53 VARCHAR2
522 , p7_a54 VARCHAR2
523 , p7_a55 NUMBER
524 , p7_a56 VARCHAR2
525 , p7_a57 VARCHAR2
526 , p7_a58 NUMBER
527 , p7_a59 VARCHAR2
528 , p7_a60 VARCHAR2
529 , p7_a61 NUMBER
530 , p7_a62 NUMBER
531 , p7_a63 VARCHAR2
532 , p7_a64 VARCHAR2
533 , p7_a65 VARCHAR2
534 , p7_a66 VARCHAR2
535 , p7_a67 VARCHAR2
536 , p7_a68 VARCHAR2
537 , p7_a69 VARCHAR2
538 , p7_a70 VARCHAR2
539 , p7_a71 VARCHAR2
540 , p7_a72 VARCHAR2
541 , p7_a73 VARCHAR2
542 , p7_a74 VARCHAR2
543 , p7_a75 VARCHAR2
544 , p7_a76 VARCHAR2
545 , p7_a77 VARCHAR2
546 , p7_a78 VARCHAR2
547 , p7_a79 VARCHAR2
548 , p7_a80 VARCHAR2
549 , p7_a81 VARCHAR2
550 , p7_a82 VARCHAR2
551 , p7_a83 VARCHAR2
555 , p7_a87 VARCHAR2
552 , p7_a84 VARCHAR2
553 , p7_a85 VARCHAR2
554 , p7_a86 NUMBER
556 , p7_a88 VARCHAR2
557 , p7_a89 VARCHAR2
558 , p7_a90 VARCHAR2
559 , p7_a91 NUMBER
560 , p7_a92 VARCHAR2
561 , p7_a93 VARCHAR2
562 , p7_a94 VARCHAR2
563 , p7_a95 VARCHAR2
564 , p7_a96 VARCHAR2
565 , p7_a97 VARCHAR2
566 , p7_a98 VARCHAR2
567 , p7_a99 NUMBER
568 , p7_a100 NUMBER
569 , p7_a101 VARCHAR2
570 , p7_a102 VARCHAR2
571 , p7_a103 VARCHAR2
572 , p7_a104 VARCHAR2
573 , p7_a105 VARCHAR2
574 , p7_a106 VARCHAR2
575 , p7_a107 VARCHAR2
576 , p7_a108 VARCHAR2
577 , p7_a109 VARCHAR2
578 , p7_a110 VARCHAR2
579 , p7_a111 VARCHAR2
580 , p7_a112 VARCHAR2
581 , p7_a113 VARCHAR2
582 , p7_a114 VARCHAR2
583 , p7_a115 VARCHAR2
584 , p7_a116 VARCHAR2
585 , p7_a117 NUMBER
586 , p7_a118 VARCHAR2
587 , p7_a119 VARCHAR2
588 , p7_a120 VARCHAR2
589 , p7_a121 VARCHAR2
590 , p7_a122 NUMBER
591 , p7_a123 NUMBER
592 , p7_a124 NUMBER
593 , p7_a125 NUMBER
594 , p7_a126 VARCHAR2
595 , p7_a127 NUMBER
596 , p7_a128 NUMBER
597 , p7_a129 NUMBER
598 , p7_a130 VARCHAR2
599 , p7_a131 VARCHAR2
600 , p7_a132 NUMBER
601 , p7_a133 NUMBER
602 , p7_a134 NUMBER
603 , p7_a135 VARCHAR2
604 , p7_a136 VARCHAR2
605 , p7_a137 VARCHAR2
606 , p7_a138 VARCHAR2
607 , p7_a139 VARCHAR2
608 , p7_a140 VARCHAR2
609 , p7_a141 VARCHAR2
610 , p7_a142 VARCHAR2
611 , p7_a143 VARCHAR2
612 , p7_a144 DATE
613 , p7_a145 VARCHAR2
614 , p7_a146 VARCHAR2
615 , p7_a147 VARCHAR2
616 , p7_a148 VARCHAR2
617 , p7_a149 VARCHAR2
618 , p7_a150 VARCHAR2
619 , p7_a151 NUMBER
620 , p_vendor_site_id NUMBER
621 );
622 end fun_vendor_pvt_pkg_w;