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