[Home] [Help]
PACKAGE: APPS.OKL_VP_ASSOCIATIONS_PVT_W
Source
1 package okl_vp_associations_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLEVASS.pls 120.1 2005/10/30 04:58:07 appldev noship $ */
3 procedure create_vp_associations(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , x_return_status out nocopy VARCHAR2
6 , x_msg_count out nocopy NUMBER
7 , x_msg_data out nocopy VARCHAR2
8 , p5_a0 NUMBER
9 , p5_a1 NUMBER
10 , p5_a2 NUMBER
11 , p5_a3 NUMBER
12 , p5_a4 DATE
13 , p5_a5 DATE
14 , p5_a6 VARCHAR2
15 , p5_a7 VARCHAR2
16 , p5_a8 NUMBER
17 , p5_a9 NUMBER
18 , p5_a10 VARCHAR2
19 , p5_a11 VARCHAR2
20 , p5_a12 VARCHAR2
21 , p5_a13 VARCHAR2
22 , p5_a14 VARCHAR2
23 , p5_a15 VARCHAR2
24 , p5_a16 VARCHAR2
25 , p5_a17 VARCHAR2
26 , p5_a18 VARCHAR2
27 , p5_a19 VARCHAR2
28 , p5_a20 VARCHAR2
29 , p5_a21 VARCHAR2
30 , p5_a22 VARCHAR2
31 , p5_a23 VARCHAR2
32 , p5_a24 VARCHAR2
33 , p5_a25 VARCHAR2
34 , p5_a26 NUMBER
35 , p5_a27 NUMBER
36 , p5_a28 NUMBER
37 , p5_a29 DATE
38 , p5_a30 NUMBER
39 , p5_a31 DATE
40 , p5_a32 NUMBER
41 , p5_a33 DATE
42 , p5_a34 NUMBER
43 , p6_a0 out nocopy NUMBER
44 , p6_a1 out nocopy NUMBER
45 , p6_a2 out nocopy NUMBER
46 , p6_a3 out nocopy NUMBER
47 , p6_a4 out nocopy DATE
48 , p6_a5 out nocopy DATE
49 , p6_a6 out nocopy VARCHAR2
50 , p6_a7 out nocopy VARCHAR2
51 , p6_a8 out nocopy NUMBER
52 , p6_a9 out nocopy NUMBER
53 , p6_a10 out nocopy VARCHAR2
54 , p6_a11 out nocopy VARCHAR2
55 , p6_a12 out nocopy VARCHAR2
56 , p6_a13 out nocopy VARCHAR2
57 , p6_a14 out nocopy VARCHAR2
58 , p6_a15 out nocopy VARCHAR2
59 , p6_a16 out nocopy VARCHAR2
60 , p6_a17 out nocopy VARCHAR2
61 , p6_a18 out nocopy VARCHAR2
62 , p6_a19 out nocopy VARCHAR2
63 , p6_a20 out nocopy VARCHAR2
64 , p6_a21 out nocopy VARCHAR2
65 , p6_a22 out nocopy VARCHAR2
66 , p6_a23 out nocopy VARCHAR2
67 , p6_a24 out nocopy VARCHAR2
68 , p6_a25 out nocopy VARCHAR2
69 , p6_a26 out nocopy NUMBER
70 , p6_a27 out nocopy NUMBER
71 , p6_a28 out nocopy NUMBER
72 , p6_a29 out nocopy DATE
73 , p6_a30 out nocopy NUMBER
74 , p6_a31 out nocopy DATE
75 , p6_a32 out nocopy NUMBER
76 , p6_a33 out nocopy DATE
77 , p6_a34 out nocopy NUMBER
78 );
79 procedure create_vp_associations(p_api_version NUMBER
80 , p_init_msg_list VARCHAR2
81 , x_return_status out nocopy VARCHAR2
82 , x_msg_count out nocopy NUMBER
83 , x_msg_data out nocopy VARCHAR2
84 , p5_a0 JTF_NUMBER_TABLE
85 , p5_a1 JTF_NUMBER_TABLE
86 , p5_a2 JTF_NUMBER_TABLE
87 , p5_a3 JTF_NUMBER_TABLE
88 , p5_a4 JTF_DATE_TABLE
89 , p5_a5 JTF_DATE_TABLE
90 , p5_a6 JTF_VARCHAR2_TABLE_2000
91 , p5_a7 JTF_VARCHAR2_TABLE_100
92 , p5_a8 JTF_NUMBER_TABLE
93 , p5_a9 JTF_NUMBER_TABLE
94 , p5_a10 JTF_VARCHAR2_TABLE_100
95 , p5_a11 JTF_VARCHAR2_TABLE_500
96 , p5_a12 JTF_VARCHAR2_TABLE_500
97 , p5_a13 JTF_VARCHAR2_TABLE_500
98 , p5_a14 JTF_VARCHAR2_TABLE_500
99 , p5_a15 JTF_VARCHAR2_TABLE_500
100 , p5_a16 JTF_VARCHAR2_TABLE_500
101 , p5_a17 JTF_VARCHAR2_TABLE_500
102 , p5_a18 JTF_VARCHAR2_TABLE_500
103 , p5_a19 JTF_VARCHAR2_TABLE_500
104 , p5_a20 JTF_VARCHAR2_TABLE_500
105 , p5_a21 JTF_VARCHAR2_TABLE_500
106 , p5_a22 JTF_VARCHAR2_TABLE_500
107 , p5_a23 JTF_VARCHAR2_TABLE_500
108 , p5_a24 JTF_VARCHAR2_TABLE_500
109 , p5_a25 JTF_VARCHAR2_TABLE_500
110 , p5_a26 JTF_NUMBER_TABLE
111 , p5_a27 JTF_NUMBER_TABLE
112 , p5_a28 JTF_NUMBER_TABLE
113 , p5_a29 JTF_DATE_TABLE
114 , p5_a30 JTF_NUMBER_TABLE
115 , p5_a31 JTF_DATE_TABLE
116 , p5_a32 JTF_NUMBER_TABLE
117 , p5_a33 JTF_DATE_TABLE
118 , p5_a34 JTF_NUMBER_TABLE
119 , p6_a0 out nocopy JTF_NUMBER_TABLE
120 , p6_a1 out nocopy JTF_NUMBER_TABLE
121 , p6_a2 out nocopy JTF_NUMBER_TABLE
122 , p6_a3 out nocopy JTF_NUMBER_TABLE
123 , p6_a4 out nocopy JTF_DATE_TABLE
124 , p6_a5 out nocopy JTF_DATE_TABLE
125 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
126 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
127 , p6_a8 out nocopy JTF_NUMBER_TABLE
128 , p6_a9 out nocopy JTF_NUMBER_TABLE
129 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
130 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
131 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
132 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
133 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
134 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
135 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
136 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
137 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
138 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
139 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
140 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
141 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
142 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
143 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
144 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
145 , p6_a26 out nocopy JTF_NUMBER_TABLE
146 , p6_a27 out nocopy JTF_NUMBER_TABLE
147 , p6_a28 out nocopy JTF_NUMBER_TABLE
148 , p6_a29 out nocopy JTF_DATE_TABLE
149 , p6_a30 out nocopy JTF_NUMBER_TABLE
150 , p6_a31 out nocopy JTF_DATE_TABLE
151 , p6_a32 out nocopy JTF_NUMBER_TABLE
152 , p6_a33 out nocopy JTF_DATE_TABLE
153 , p6_a34 out nocopy JTF_NUMBER_TABLE
154 );
155 procedure lock_vp_associations(p_api_version NUMBER
156 , p_init_msg_list VARCHAR2
157 , x_return_status out nocopy VARCHAR2
158 , x_msg_count out nocopy NUMBER
159 , x_msg_data out nocopy VARCHAR2
160 , p5_a0 NUMBER
161 , p5_a1 NUMBER
162 , p5_a2 NUMBER
163 , p5_a3 NUMBER
164 , p5_a4 DATE
165 , p5_a5 DATE
166 , p5_a6 VARCHAR2
167 , p5_a7 VARCHAR2
168 , p5_a8 NUMBER
169 , p5_a9 NUMBER
170 , p5_a10 VARCHAR2
171 , p5_a11 VARCHAR2
172 , p5_a12 VARCHAR2
173 , p5_a13 VARCHAR2
174 , p5_a14 VARCHAR2
175 , p5_a15 VARCHAR2
176 , p5_a16 VARCHAR2
177 , p5_a17 VARCHAR2
178 , p5_a18 VARCHAR2
179 , p5_a19 VARCHAR2
180 , p5_a20 VARCHAR2
181 , p5_a21 VARCHAR2
182 , p5_a22 VARCHAR2
183 , p5_a23 VARCHAR2
184 , p5_a24 VARCHAR2
185 , p5_a25 VARCHAR2
186 , p5_a26 NUMBER
187 , p5_a27 NUMBER
188 , p5_a28 NUMBER
189 , p5_a29 DATE
190 , p5_a30 NUMBER
191 , p5_a31 DATE
192 , p5_a32 NUMBER
193 , p5_a33 DATE
194 , p5_a34 NUMBER
195 );
196 procedure lock_vp_associations(p_api_version NUMBER
197 , p_init_msg_list VARCHAR2
198 , x_return_status out nocopy VARCHAR2
199 , x_msg_count out nocopy NUMBER
200 , x_msg_data out nocopy VARCHAR2
201 , p5_a0 JTF_NUMBER_TABLE
202 , p5_a1 JTF_NUMBER_TABLE
203 , p5_a2 JTF_NUMBER_TABLE
204 , p5_a3 JTF_NUMBER_TABLE
205 , p5_a4 JTF_DATE_TABLE
206 , p5_a5 JTF_DATE_TABLE
207 , p5_a6 JTF_VARCHAR2_TABLE_2000
208 , p5_a7 JTF_VARCHAR2_TABLE_100
209 , p5_a8 JTF_NUMBER_TABLE
210 , p5_a9 JTF_NUMBER_TABLE
211 , p5_a10 JTF_VARCHAR2_TABLE_100
212 , p5_a11 JTF_VARCHAR2_TABLE_500
213 , p5_a12 JTF_VARCHAR2_TABLE_500
214 , p5_a13 JTF_VARCHAR2_TABLE_500
215 , p5_a14 JTF_VARCHAR2_TABLE_500
216 , p5_a15 JTF_VARCHAR2_TABLE_500
217 , p5_a16 JTF_VARCHAR2_TABLE_500
218 , p5_a17 JTF_VARCHAR2_TABLE_500
219 , p5_a18 JTF_VARCHAR2_TABLE_500
220 , p5_a19 JTF_VARCHAR2_TABLE_500
221 , p5_a20 JTF_VARCHAR2_TABLE_500
222 , p5_a21 JTF_VARCHAR2_TABLE_500
223 , p5_a22 JTF_VARCHAR2_TABLE_500
224 , p5_a23 JTF_VARCHAR2_TABLE_500
225 , p5_a24 JTF_VARCHAR2_TABLE_500
226 , p5_a25 JTF_VARCHAR2_TABLE_500
227 , p5_a26 JTF_NUMBER_TABLE
228 , p5_a27 JTF_NUMBER_TABLE
229 , p5_a28 JTF_NUMBER_TABLE
230 , p5_a29 JTF_DATE_TABLE
231 , p5_a30 JTF_NUMBER_TABLE
232 , p5_a31 JTF_DATE_TABLE
233 , p5_a32 JTF_NUMBER_TABLE
234 , p5_a33 JTF_DATE_TABLE
235 , p5_a34 JTF_NUMBER_TABLE
236 );
237 procedure update_vp_associations(p_api_version NUMBER
238 , p_init_msg_list VARCHAR2
239 , x_return_status out nocopy VARCHAR2
240 , x_msg_count out nocopy NUMBER
241 , x_msg_data out nocopy VARCHAR2
242 , p5_a0 NUMBER
243 , p5_a1 NUMBER
244 , p5_a2 NUMBER
245 , p5_a3 NUMBER
246 , p5_a4 DATE
247 , p5_a5 DATE
248 , p5_a6 VARCHAR2
249 , p5_a7 VARCHAR2
250 , p5_a8 NUMBER
251 , p5_a9 NUMBER
252 , p5_a10 VARCHAR2
253 , p5_a11 VARCHAR2
254 , p5_a12 VARCHAR2
255 , p5_a13 VARCHAR2
256 , p5_a14 VARCHAR2
257 , p5_a15 VARCHAR2
258 , p5_a16 VARCHAR2
259 , p5_a17 VARCHAR2
260 , p5_a18 VARCHAR2
261 , p5_a19 VARCHAR2
262 , p5_a20 VARCHAR2
263 , p5_a21 VARCHAR2
264 , p5_a22 VARCHAR2
265 , p5_a23 VARCHAR2
266 , p5_a24 VARCHAR2
267 , p5_a25 VARCHAR2
268 , p5_a26 NUMBER
269 , p5_a27 NUMBER
270 , p5_a28 NUMBER
271 , p5_a29 DATE
272 , p5_a30 NUMBER
273 , p5_a31 DATE
274 , p5_a32 NUMBER
275 , p5_a33 DATE
276 , p5_a34 NUMBER
277 , p6_a0 out nocopy NUMBER
278 , p6_a1 out nocopy NUMBER
279 , p6_a2 out nocopy NUMBER
280 , p6_a3 out nocopy NUMBER
281 , p6_a4 out nocopy DATE
282 , p6_a5 out nocopy DATE
283 , p6_a6 out nocopy VARCHAR2
284 , p6_a7 out nocopy VARCHAR2
285 , p6_a8 out nocopy NUMBER
286 , p6_a9 out nocopy NUMBER
287 , p6_a10 out nocopy VARCHAR2
288 , p6_a11 out nocopy VARCHAR2
289 , p6_a12 out nocopy VARCHAR2
290 , p6_a13 out nocopy VARCHAR2
291 , p6_a14 out nocopy VARCHAR2
292 , p6_a15 out nocopy VARCHAR2
293 , p6_a16 out nocopy VARCHAR2
294 , p6_a17 out nocopy VARCHAR2
295 , p6_a18 out nocopy VARCHAR2
296 , p6_a19 out nocopy VARCHAR2
297 , p6_a20 out nocopy VARCHAR2
298 , p6_a21 out nocopy VARCHAR2
299 , p6_a22 out nocopy VARCHAR2
300 , p6_a23 out nocopy VARCHAR2
301 , p6_a24 out nocopy VARCHAR2
302 , p6_a25 out nocopy VARCHAR2
303 , p6_a26 out nocopy NUMBER
304 , p6_a27 out nocopy NUMBER
305 , p6_a28 out nocopy NUMBER
306 , p6_a29 out nocopy DATE
307 , p6_a30 out nocopy NUMBER
308 , p6_a31 out nocopy DATE
309 , p6_a32 out nocopy NUMBER
310 , p6_a33 out nocopy DATE
311 , p6_a34 out nocopy NUMBER
312 );
313 procedure update_vp_associations(p_api_version NUMBER
314 , p_init_msg_list VARCHAR2
315 , x_return_status out nocopy VARCHAR2
316 , x_msg_count out nocopy NUMBER
317 , x_msg_data out nocopy VARCHAR2
318 , p5_a0 JTF_NUMBER_TABLE
319 , p5_a1 JTF_NUMBER_TABLE
320 , p5_a2 JTF_NUMBER_TABLE
321 , p5_a3 JTF_NUMBER_TABLE
322 , p5_a4 JTF_DATE_TABLE
323 , p5_a5 JTF_DATE_TABLE
324 , p5_a6 JTF_VARCHAR2_TABLE_2000
325 , p5_a7 JTF_VARCHAR2_TABLE_100
326 , p5_a8 JTF_NUMBER_TABLE
327 , p5_a9 JTF_NUMBER_TABLE
328 , p5_a10 JTF_VARCHAR2_TABLE_100
329 , p5_a11 JTF_VARCHAR2_TABLE_500
330 , p5_a12 JTF_VARCHAR2_TABLE_500
331 , p5_a13 JTF_VARCHAR2_TABLE_500
332 , p5_a14 JTF_VARCHAR2_TABLE_500
333 , p5_a15 JTF_VARCHAR2_TABLE_500
334 , p5_a16 JTF_VARCHAR2_TABLE_500
335 , p5_a17 JTF_VARCHAR2_TABLE_500
336 , p5_a18 JTF_VARCHAR2_TABLE_500
337 , p5_a19 JTF_VARCHAR2_TABLE_500
338 , p5_a20 JTF_VARCHAR2_TABLE_500
339 , p5_a21 JTF_VARCHAR2_TABLE_500
340 , p5_a22 JTF_VARCHAR2_TABLE_500
341 , p5_a23 JTF_VARCHAR2_TABLE_500
342 , p5_a24 JTF_VARCHAR2_TABLE_500
343 , p5_a25 JTF_VARCHAR2_TABLE_500
344 , p5_a26 JTF_NUMBER_TABLE
345 , p5_a27 JTF_NUMBER_TABLE
346 , p5_a28 JTF_NUMBER_TABLE
347 , p5_a29 JTF_DATE_TABLE
348 , p5_a30 JTF_NUMBER_TABLE
349 , p5_a31 JTF_DATE_TABLE
350 , p5_a32 JTF_NUMBER_TABLE
351 , p5_a33 JTF_DATE_TABLE
352 , p5_a34 JTF_NUMBER_TABLE
353 , p6_a0 out nocopy JTF_NUMBER_TABLE
354 , p6_a1 out nocopy JTF_NUMBER_TABLE
355 , p6_a2 out nocopy JTF_NUMBER_TABLE
356 , p6_a3 out nocopy JTF_NUMBER_TABLE
357 , p6_a4 out nocopy JTF_DATE_TABLE
358 , p6_a5 out nocopy JTF_DATE_TABLE
359 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
360 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
361 , p6_a8 out nocopy JTF_NUMBER_TABLE
362 , p6_a9 out nocopy JTF_NUMBER_TABLE
363 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
364 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
365 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
366 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
367 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
368 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
369 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
370 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
371 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
372 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
373 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
374 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
375 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
376 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
377 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
378 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
379 , p6_a26 out nocopy JTF_NUMBER_TABLE
380 , p6_a27 out nocopy JTF_NUMBER_TABLE
381 , p6_a28 out nocopy JTF_NUMBER_TABLE
382 , p6_a29 out nocopy JTF_DATE_TABLE
383 , p6_a30 out nocopy JTF_NUMBER_TABLE
384 , p6_a31 out nocopy JTF_DATE_TABLE
385 , p6_a32 out nocopy JTF_NUMBER_TABLE
386 , p6_a33 out nocopy JTF_DATE_TABLE
387 , p6_a34 out nocopy JTF_NUMBER_TABLE
388 );
389 procedure delete_vp_associations(p_api_version NUMBER
390 , p_init_msg_list VARCHAR2
391 , x_return_status out nocopy VARCHAR2
392 , x_msg_count out nocopy NUMBER
393 , x_msg_data out nocopy VARCHAR2
394 , p5_a0 NUMBER
395 , p5_a1 NUMBER
396 , p5_a2 NUMBER
397 , p5_a3 NUMBER
398 , p5_a4 DATE
399 , p5_a5 DATE
400 , p5_a6 VARCHAR2
401 , p5_a7 VARCHAR2
402 , p5_a8 NUMBER
403 , p5_a9 NUMBER
404 , p5_a10 VARCHAR2
405 , p5_a11 VARCHAR2
406 , p5_a12 VARCHAR2
407 , p5_a13 VARCHAR2
408 , p5_a14 VARCHAR2
409 , p5_a15 VARCHAR2
410 , p5_a16 VARCHAR2
411 , p5_a17 VARCHAR2
412 , p5_a18 VARCHAR2
413 , p5_a19 VARCHAR2
414 , p5_a20 VARCHAR2
415 , p5_a21 VARCHAR2
416 , p5_a22 VARCHAR2
417 , p5_a23 VARCHAR2
418 , p5_a24 VARCHAR2
419 , p5_a25 VARCHAR2
420 , p5_a26 NUMBER
421 , p5_a27 NUMBER
422 , p5_a28 NUMBER
423 , p5_a29 DATE
424 , p5_a30 NUMBER
425 , p5_a31 DATE
426 , p5_a32 NUMBER
427 , p5_a33 DATE
428 , p5_a34 NUMBER
429 );
430 procedure delete_vp_associations(p_api_version NUMBER
431 , p_init_msg_list VARCHAR2
432 , x_return_status out nocopy VARCHAR2
433 , x_msg_count out nocopy NUMBER
434 , x_msg_data out nocopy VARCHAR2
435 , p5_a0 JTF_NUMBER_TABLE
436 , p5_a1 JTF_NUMBER_TABLE
437 , p5_a2 JTF_NUMBER_TABLE
438 , p5_a3 JTF_NUMBER_TABLE
439 , p5_a4 JTF_DATE_TABLE
440 , p5_a5 JTF_DATE_TABLE
441 , p5_a6 JTF_VARCHAR2_TABLE_2000
442 , p5_a7 JTF_VARCHAR2_TABLE_100
443 , p5_a8 JTF_NUMBER_TABLE
444 , p5_a9 JTF_NUMBER_TABLE
445 , p5_a10 JTF_VARCHAR2_TABLE_100
446 , p5_a11 JTF_VARCHAR2_TABLE_500
447 , p5_a12 JTF_VARCHAR2_TABLE_500
448 , p5_a13 JTF_VARCHAR2_TABLE_500
449 , p5_a14 JTF_VARCHAR2_TABLE_500
450 , p5_a15 JTF_VARCHAR2_TABLE_500
451 , p5_a16 JTF_VARCHAR2_TABLE_500
452 , p5_a17 JTF_VARCHAR2_TABLE_500
453 , p5_a18 JTF_VARCHAR2_TABLE_500
454 , p5_a19 JTF_VARCHAR2_TABLE_500
455 , p5_a20 JTF_VARCHAR2_TABLE_500
456 , p5_a21 JTF_VARCHAR2_TABLE_500
457 , p5_a22 JTF_VARCHAR2_TABLE_500
458 , p5_a23 JTF_VARCHAR2_TABLE_500
459 , p5_a24 JTF_VARCHAR2_TABLE_500
460 , p5_a25 JTF_VARCHAR2_TABLE_500
461 , p5_a26 JTF_NUMBER_TABLE
462 , p5_a27 JTF_NUMBER_TABLE
463 , p5_a28 JTF_NUMBER_TABLE
464 , p5_a29 JTF_DATE_TABLE
465 , p5_a30 JTF_NUMBER_TABLE
466 , p5_a31 JTF_DATE_TABLE
467 , p5_a32 JTF_NUMBER_TABLE
468 , p5_a33 JTF_DATE_TABLE
469 , p5_a34 JTF_NUMBER_TABLE
470 );
471 procedure validate_vp_associations(p_api_version NUMBER
472 , p_init_msg_list VARCHAR2
473 , x_return_status out nocopy VARCHAR2
474 , x_msg_count out nocopy NUMBER
475 , x_msg_data out nocopy VARCHAR2
476 , p5_a0 NUMBER
477 , p5_a1 NUMBER
478 , p5_a2 NUMBER
479 , p5_a3 NUMBER
480 , p5_a4 DATE
481 , p5_a5 DATE
482 , p5_a6 VARCHAR2
483 , p5_a7 VARCHAR2
484 , p5_a8 NUMBER
485 , p5_a9 NUMBER
486 , p5_a10 VARCHAR2
487 , p5_a11 VARCHAR2
488 , p5_a12 VARCHAR2
489 , p5_a13 VARCHAR2
490 , p5_a14 VARCHAR2
491 , p5_a15 VARCHAR2
492 , p5_a16 VARCHAR2
493 , p5_a17 VARCHAR2
494 , p5_a18 VARCHAR2
495 , p5_a19 VARCHAR2
496 , p5_a20 VARCHAR2
497 , p5_a21 VARCHAR2
498 , p5_a22 VARCHAR2
499 , p5_a23 VARCHAR2
500 , p5_a24 VARCHAR2
501 , p5_a25 VARCHAR2
502 , p5_a26 NUMBER
503 , p5_a27 NUMBER
504 , p5_a28 NUMBER
505 , p5_a29 DATE
506 , p5_a30 NUMBER
507 , p5_a31 DATE
508 , p5_a32 NUMBER
509 , p5_a33 DATE
510 , p5_a34 NUMBER
511 );
512 procedure validate_vp_associations(p_api_version NUMBER
513 , p_init_msg_list VARCHAR2
514 , x_return_status out nocopy VARCHAR2
515 , x_msg_count out nocopy NUMBER
516 , x_msg_data out nocopy VARCHAR2
517 , p5_a0 JTF_NUMBER_TABLE
518 , p5_a1 JTF_NUMBER_TABLE
519 , p5_a2 JTF_NUMBER_TABLE
520 , p5_a3 JTF_NUMBER_TABLE
521 , p5_a4 JTF_DATE_TABLE
522 , p5_a5 JTF_DATE_TABLE
523 , p5_a6 JTF_VARCHAR2_TABLE_2000
524 , p5_a7 JTF_VARCHAR2_TABLE_100
525 , p5_a8 JTF_NUMBER_TABLE
526 , p5_a9 JTF_NUMBER_TABLE
527 , p5_a10 JTF_VARCHAR2_TABLE_100
528 , p5_a11 JTF_VARCHAR2_TABLE_500
529 , p5_a12 JTF_VARCHAR2_TABLE_500
530 , p5_a13 JTF_VARCHAR2_TABLE_500
531 , p5_a14 JTF_VARCHAR2_TABLE_500
532 , p5_a15 JTF_VARCHAR2_TABLE_500
533 , p5_a16 JTF_VARCHAR2_TABLE_500
534 , p5_a17 JTF_VARCHAR2_TABLE_500
535 , p5_a18 JTF_VARCHAR2_TABLE_500
536 , p5_a19 JTF_VARCHAR2_TABLE_500
537 , p5_a20 JTF_VARCHAR2_TABLE_500
538 , p5_a21 JTF_VARCHAR2_TABLE_500
539 , p5_a22 JTF_VARCHAR2_TABLE_500
540 , p5_a23 JTF_VARCHAR2_TABLE_500
541 , p5_a24 JTF_VARCHAR2_TABLE_500
542 , p5_a25 JTF_VARCHAR2_TABLE_500
543 , p5_a26 JTF_NUMBER_TABLE
544 , p5_a27 JTF_NUMBER_TABLE
545 , p5_a28 JTF_NUMBER_TABLE
546 , p5_a29 JTF_DATE_TABLE
547 , p5_a30 JTF_NUMBER_TABLE
548 , p5_a31 JTF_DATE_TABLE
549 , p5_a32 JTF_NUMBER_TABLE
550 , p5_a33 JTF_DATE_TABLE
551 , p5_a34 JTF_NUMBER_TABLE
552 );
553 procedure copy_vp_associations(p_api_version NUMBER
554 , p_init_msg_list VARCHAR2
555 , x_return_status out nocopy VARCHAR2
556 , x_msg_count out nocopy NUMBER
557 , x_msg_data out nocopy VARCHAR2
558 , p5_a0 NUMBER
559 , p5_a1 NUMBER
560 , p5_a2 NUMBER
561 , p5_a3 NUMBER
562 , p5_a4 DATE
563 , p5_a5 DATE
564 , p5_a6 VARCHAR2
565 , p5_a7 VARCHAR2
566 , p5_a8 NUMBER
567 , p5_a9 NUMBER
568 , p5_a10 VARCHAR2
569 , p5_a11 VARCHAR2
570 , p5_a12 VARCHAR2
571 , p5_a13 VARCHAR2
572 , p5_a14 VARCHAR2
573 , p5_a15 VARCHAR2
574 , p5_a16 VARCHAR2
575 , p5_a17 VARCHAR2
576 , p5_a18 VARCHAR2
577 , p5_a19 VARCHAR2
578 , p5_a20 VARCHAR2
579 , p5_a21 VARCHAR2
580 , p5_a22 VARCHAR2
581 , p5_a23 VARCHAR2
582 , p5_a24 VARCHAR2
583 , p5_a25 VARCHAR2
584 , p5_a26 NUMBER
585 , p5_a27 NUMBER
586 , p5_a28 NUMBER
587 , p5_a29 DATE
588 , p5_a30 NUMBER
589 , p5_a31 DATE
590 , p5_a32 NUMBER
591 , p5_a33 DATE
592 , p5_a34 NUMBER
593 , p6_a0 out nocopy NUMBER
594 , p6_a1 out nocopy NUMBER
595 , p6_a2 out nocopy NUMBER
596 , p6_a3 out nocopy NUMBER
597 , p6_a4 out nocopy DATE
598 , p6_a5 out nocopy DATE
599 , p6_a6 out nocopy VARCHAR2
600 , p6_a7 out nocopy VARCHAR2
601 , p6_a8 out nocopy NUMBER
602 , p6_a9 out nocopy NUMBER
603 , p6_a10 out nocopy VARCHAR2
604 , p6_a11 out nocopy VARCHAR2
605 , p6_a12 out nocopy VARCHAR2
606 , p6_a13 out nocopy VARCHAR2
607 , p6_a14 out nocopy VARCHAR2
608 , p6_a15 out nocopy VARCHAR2
609 , p6_a16 out nocopy VARCHAR2
610 , p6_a17 out nocopy VARCHAR2
611 , p6_a18 out nocopy VARCHAR2
612 , p6_a19 out nocopy VARCHAR2
613 , p6_a20 out nocopy VARCHAR2
614 , p6_a21 out nocopy VARCHAR2
615 , p6_a22 out nocopy VARCHAR2
616 , p6_a23 out nocopy VARCHAR2
617 , p6_a24 out nocopy VARCHAR2
618 , p6_a25 out nocopy VARCHAR2
619 , p6_a26 out nocopy NUMBER
620 , p6_a27 out nocopy NUMBER
621 , p6_a28 out nocopy NUMBER
622 , p6_a29 out nocopy DATE
623 , p6_a30 out nocopy NUMBER
624 , p6_a31 out nocopy DATE
625 , p6_a32 out nocopy NUMBER
626 , p6_a33 out nocopy DATE
627 , p6_a34 out nocopy NUMBER
628 );
629 procedure copy_vp_associations(p_api_version NUMBER
630 , p_init_msg_list VARCHAR2
631 , x_return_status out nocopy VARCHAR2
632 , x_msg_count out nocopy NUMBER
633 , x_msg_data out nocopy VARCHAR2
634 , p5_a0 JTF_NUMBER_TABLE
635 , p5_a1 JTF_NUMBER_TABLE
636 , p5_a2 JTF_NUMBER_TABLE
637 , p5_a3 JTF_NUMBER_TABLE
638 , p5_a4 JTF_DATE_TABLE
639 , p5_a5 JTF_DATE_TABLE
640 , p5_a6 JTF_VARCHAR2_TABLE_2000
641 , p5_a7 JTF_VARCHAR2_TABLE_100
642 , p5_a8 JTF_NUMBER_TABLE
643 , p5_a9 JTF_NUMBER_TABLE
644 , p5_a10 JTF_VARCHAR2_TABLE_100
645 , p5_a11 JTF_VARCHAR2_TABLE_500
646 , p5_a12 JTF_VARCHAR2_TABLE_500
647 , p5_a13 JTF_VARCHAR2_TABLE_500
648 , p5_a14 JTF_VARCHAR2_TABLE_500
649 , p5_a15 JTF_VARCHAR2_TABLE_500
650 , p5_a16 JTF_VARCHAR2_TABLE_500
651 , p5_a17 JTF_VARCHAR2_TABLE_500
652 , p5_a18 JTF_VARCHAR2_TABLE_500
653 , p5_a19 JTF_VARCHAR2_TABLE_500
654 , p5_a20 JTF_VARCHAR2_TABLE_500
655 , p5_a21 JTF_VARCHAR2_TABLE_500
656 , p5_a22 JTF_VARCHAR2_TABLE_500
657 , p5_a23 JTF_VARCHAR2_TABLE_500
658 , p5_a24 JTF_VARCHAR2_TABLE_500
659 , p5_a25 JTF_VARCHAR2_TABLE_500
660 , p5_a26 JTF_NUMBER_TABLE
661 , p5_a27 JTF_NUMBER_TABLE
662 , p5_a28 JTF_NUMBER_TABLE
663 , p5_a29 JTF_DATE_TABLE
664 , p5_a30 JTF_NUMBER_TABLE
665 , p5_a31 JTF_DATE_TABLE
666 , p5_a32 JTF_NUMBER_TABLE
667 , p5_a33 JTF_DATE_TABLE
668 , p5_a34 JTF_NUMBER_TABLE
669 , p6_a0 out nocopy JTF_NUMBER_TABLE
670 , p6_a1 out nocopy JTF_NUMBER_TABLE
671 , p6_a2 out nocopy JTF_NUMBER_TABLE
672 , p6_a3 out nocopy JTF_NUMBER_TABLE
673 , p6_a4 out nocopy JTF_DATE_TABLE
674 , p6_a5 out nocopy JTF_DATE_TABLE
675 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
676 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
677 , p6_a8 out nocopy JTF_NUMBER_TABLE
678 , p6_a9 out nocopy JTF_NUMBER_TABLE
679 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
680 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
681 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
682 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
683 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
684 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
685 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
686 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
687 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
688 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
689 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
690 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
691 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
692 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
693 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
694 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
695 , p6_a26 out nocopy JTF_NUMBER_TABLE
696 , p6_a27 out nocopy JTF_NUMBER_TABLE
697 , p6_a28 out nocopy JTF_NUMBER_TABLE
698 , p6_a29 out nocopy JTF_DATE_TABLE
699 , p6_a30 out nocopy JTF_NUMBER_TABLE
700 , p6_a31 out nocopy JTF_DATE_TABLE
701 , p6_a32 out nocopy JTF_NUMBER_TABLE
702 , p6_a33 out nocopy JTF_DATE_TABLE
703 , p6_a34 out nocopy JTF_NUMBER_TABLE
704 );
705 end okl_vp_associations_pvt_w;