[Home] [Help]
PACKAGE BODY: APPS.OKC_CONTRACT_PVT_W
Source
1 package body okc_contract_pvt_w as
2 /* $Header: OKCECHRB.pls 120.0 2005/05/26 09:53:13 appldev noship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 function rosetta_g_miss_num_map(n number) return number as
7 a number := fnd_api.g_miss_num;
8 b number := 0-1962.0724;
9 begin
10 if n=a then return b; end if;
11 if n=b then return a; end if;
12 return n;
13 end;
14
15 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16 function rosetta_g_miss_date_in_map(d date) return date as
17 begin
18 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19 return d;
20 end;
21
22 procedure create_contract_header(p_api_version NUMBER
23 , p_init_msg_list VARCHAR2
24 , x_return_status out nocopy VARCHAR2
25 , x_msg_count out nocopy NUMBER
26 , x_msg_data out nocopy VARCHAR2
27 , p5_a0 NUMBER
28 , p5_a1 NUMBER
29 , p5_a2 VARCHAR2
30 , p5_a3 NUMBER
31 , p5_a4 NUMBER
32 , p5_a5 NUMBER
33 , p5_a6 NUMBER
34 , p5_a7 VARCHAR2
35 , p5_a8 NUMBER
36 , p5_a9 VARCHAR2
37 , p5_a10 VARCHAR2
38 , p5_a11 VARCHAR2
39 , p5_a12 VARCHAR2
40 , p5_a13 VARCHAR2
41 , p5_a14 VARCHAR2
42 , p5_a15 VARCHAR2
43 , p5_a16 VARCHAR2
44 , p5_a17 VARCHAR2
45 , p5_a18 VARCHAR2
46 , p5_a19 VARCHAR2
47 , p5_a20 VARCHAR2
48 , p5_a21 VARCHAR2
49 , p5_a22 VARCHAR2
50 , p5_a23 VARCHAR2
51 , p5_a24 VARCHAR2
52 , p5_a25 DATE
53 , p5_a26 DATE
54 , p5_a27 NUMBER
55 , p5_a28 DATE
56 , p5_a29 DATE
57 , p5_a30 VARCHAR2
58 , p5_a31 VARCHAR2
59 , p5_a32 VARCHAR2
60 , p5_a33 VARCHAR2
61 , p5_a34 VARCHAR2
62 , p5_a35 VARCHAR2
63 , p5_a36 NUMBER
64 , p5_a37 NUMBER
65 , p5_a38 DATE
66 , p5_a39 DATE
67 , p5_a40 DATE
68 , p5_a41 DATE
69 , p5_a42 DATE
70 , p5_a43 VARCHAR2
71 , p5_a44 DATE
72 , p5_a45 DATE
73 , p5_a46 NUMBER
74 , p5_a47 VARCHAR2
75 , p5_a48 VARCHAR2
76 , p5_a49 NUMBER
77 , p5_a50 NUMBER
78 , p5_a51 NUMBER
79 , p5_a52 VARCHAR2
80 , p5_a53 VARCHAR2
81 , p5_a54 NUMBER
82 , p5_a55 VARCHAR2
83 , p5_a56 VARCHAR2
84 , p5_a57 VARCHAR2
85 , p5_a58 VARCHAR2
86 , p5_a59 VARCHAR2
87 , p5_a60 VARCHAR2
88 , p5_a61 VARCHAR2
89 , p5_a62 VARCHAR2
90 , p5_a63 VARCHAR2
91 , p5_a64 VARCHAR2
92 , p5_a65 VARCHAR2
93 , p5_a66 VARCHAR2
94 , p5_a67 VARCHAR2
95 , p5_a68 VARCHAR2
96 , p5_a69 VARCHAR2
97 , p5_a70 VARCHAR2
98 , p5_a71 NUMBER
99 , p5_a72 DATE
100 , p5_a73 NUMBER
101 , p5_a74 DATE
102 , p5_a75 NUMBER
103 , p6_a0 out nocopy NUMBER
104 , p6_a1 out nocopy NUMBER
105 , p6_a2 out nocopy VARCHAR2
106 , p6_a3 out nocopy NUMBER
107 , p6_a4 out nocopy NUMBER
108 , p6_a5 out nocopy NUMBER
109 , p6_a6 out nocopy NUMBER
110 , p6_a7 out nocopy VARCHAR2
111 , p6_a8 out nocopy NUMBER
112 , p6_a9 out nocopy VARCHAR2
113 , p6_a10 out nocopy VARCHAR2
114 , p6_a11 out nocopy VARCHAR2
115 , p6_a12 out nocopy VARCHAR2
116 , p6_a13 out nocopy VARCHAR2
117 , p6_a14 out nocopy VARCHAR2
118 , p6_a15 out nocopy VARCHAR2
119 , p6_a16 out nocopy VARCHAR2
120 , p6_a17 out nocopy VARCHAR2
121 , p6_a18 out nocopy VARCHAR2
122 , p6_a19 out nocopy VARCHAR2
123 , p6_a20 out nocopy VARCHAR2
124 , p6_a21 out nocopy VARCHAR2
125 , p6_a22 out nocopy VARCHAR2
126 , p6_a23 out nocopy VARCHAR2
127 , p6_a24 out nocopy VARCHAR2
128 , p6_a25 out nocopy DATE
129 , p6_a26 out nocopy DATE
130 , p6_a27 out nocopy NUMBER
131 , p6_a28 out nocopy DATE
132 , p6_a29 out nocopy DATE
133 , p6_a30 out nocopy VARCHAR2
134 , p6_a31 out nocopy VARCHAR2
135 , p6_a32 out nocopy VARCHAR2
136 , p6_a33 out nocopy VARCHAR2
137 , p6_a34 out nocopy VARCHAR2
138 , p6_a35 out nocopy VARCHAR2
139 , p6_a36 out nocopy NUMBER
140 , p6_a37 out nocopy NUMBER
141 , p6_a38 out nocopy DATE
142 , p6_a39 out nocopy DATE
143 , p6_a40 out nocopy DATE
144 , p6_a41 out nocopy DATE
145 , p6_a42 out nocopy DATE
146 , p6_a43 out nocopy VARCHAR2
147 , p6_a44 out nocopy DATE
148 , p6_a45 out nocopy DATE
149 , p6_a46 out nocopy NUMBER
150 , p6_a47 out nocopy VARCHAR2
151 , p6_a48 out nocopy VARCHAR2
152 , p6_a49 out nocopy NUMBER
153 , p6_a50 out nocopy NUMBER
154 , p6_a51 out nocopy NUMBER
155 , p6_a52 out nocopy VARCHAR2
156 , p6_a53 out nocopy VARCHAR2
157 , p6_a54 out nocopy NUMBER
158 , p6_a55 out nocopy VARCHAR2
159 , p6_a56 out nocopy VARCHAR2
160 , p6_a57 out nocopy VARCHAR2
161 , p6_a58 out nocopy VARCHAR2
162 , p6_a59 out nocopy VARCHAR2
163 , p6_a60 out nocopy VARCHAR2
164 , p6_a61 out nocopy VARCHAR2
165 , p6_a62 out nocopy VARCHAR2
166 , p6_a63 out nocopy VARCHAR2
167 , p6_a64 out nocopy VARCHAR2
168 , p6_a65 out nocopy VARCHAR2
169 , p6_a66 out nocopy VARCHAR2
170 , p6_a67 out nocopy VARCHAR2
171 , p6_a68 out nocopy VARCHAR2
172 , p6_a69 out nocopy VARCHAR2
173 , p6_a70 out nocopy VARCHAR2
174 , p6_a71 out nocopy NUMBER
175 , p6_a72 out nocopy DATE
176 , p6_a73 out nocopy NUMBER
177 , p6_a74 out nocopy DATE
178 , p6_a75 out nocopy NUMBER
179 )
180 as
181 ddp_chrv_rec okc_chr_pvt.chrv_rec_type;
182 ddx_chrv_rec okc_chr_pvt.chrv_rec_type;
183 ddindx binary_integer; indx binary_integer;
184 begin
185 null;
186 end;
187
188 procedure create_contract_header(p_api_version NUMBER
189 , p_init_msg_list VARCHAR2
190 , x_return_status out nocopy VARCHAR2
191 , x_msg_count out nocopy NUMBER
192 , x_msg_data out nocopy VARCHAR2
193 , p5_a0 JTF_NUMBER_TABLE
194 , p5_a1 JTF_NUMBER_TABLE
195 , p5_a2 JTF_VARCHAR2_TABLE_100
196 , p5_a3 JTF_NUMBER_TABLE
197 , p5_a4 JTF_NUMBER_TABLE
198 , p5_a5 JTF_NUMBER_TABLE
199 , p5_a6 JTF_NUMBER_TABLE
200 , p5_a7 JTF_VARCHAR2_TABLE_100
201 , p5_a8 JTF_NUMBER_TABLE
202 , p5_a9 JTF_VARCHAR2_TABLE_100
203 , p5_a10 JTF_VARCHAR2_TABLE_200
204 , p5_a11 JTF_VARCHAR2_TABLE_100
205 , p5_a12 JTF_VARCHAR2_TABLE_200
206 , p5_a13 JTF_VARCHAR2_TABLE_100
207 , p5_a14 JTF_VARCHAR2_TABLE_100
208 , p5_a15 JTF_VARCHAR2_TABLE_100
209 , p5_a16 JTF_VARCHAR2_TABLE_100
210 , p5_a17 JTF_VARCHAR2_TABLE_200
211 , p5_a18 JTF_VARCHAR2_TABLE_600
212 , p5_a19 JTF_VARCHAR2_TABLE_2000
213 , p5_a20 JTF_VARCHAR2_TABLE_2000
214 , p5_a21 JTF_VARCHAR2_TABLE_100
215 , p5_a22 JTF_VARCHAR2_TABLE_300
216 , p5_a23 JTF_VARCHAR2_TABLE_100
217 , p5_a24 JTF_VARCHAR2_TABLE_200
218 , p5_a25 JTF_DATE_TABLE
219 , p5_a26 JTF_DATE_TABLE
220 , p5_a27 JTF_NUMBER_TABLE
221 , p5_a28 JTF_DATE_TABLE
222 , p5_a29 JTF_DATE_TABLE
223 , p5_a30 JTF_VARCHAR2_TABLE_100
224 , p5_a31 JTF_VARCHAR2_TABLE_2000
225 , p5_a32 JTF_VARCHAR2_TABLE_100
226 , p5_a33 JTF_VARCHAR2_TABLE_100
227 , p5_a34 JTF_VARCHAR2_TABLE_100
228 , p5_a35 JTF_VARCHAR2_TABLE_100
229 , p5_a36 JTF_NUMBER_TABLE
230 , p5_a37 JTF_NUMBER_TABLE
231 , p5_a38 JTF_DATE_TABLE
232 , p5_a39 JTF_DATE_TABLE
233 , p5_a40 JTF_DATE_TABLE
234 , p5_a41 JTF_DATE_TABLE
235 , p5_a42 JTF_DATE_TABLE
236 , p5_a43 JTF_VARCHAR2_TABLE_100
237 , p5_a44 JTF_DATE_TABLE
238 , p5_a45 JTF_DATE_TABLE
239 , p5_a46 JTF_NUMBER_TABLE
240 , p5_a47 JTF_VARCHAR2_TABLE_100
241 , p5_a48 JTF_VARCHAR2_TABLE_100
242 , p5_a49 JTF_NUMBER_TABLE
243 , p5_a50 JTF_NUMBER_TABLE
244 , p5_a51 JTF_NUMBER_TABLE
245 , p5_a52 JTF_VARCHAR2_TABLE_100
246 , p5_a53 JTF_VARCHAR2_TABLE_100
247 , p5_a54 JTF_NUMBER_TABLE
248 , p5_a55 JTF_VARCHAR2_TABLE_100
249 , p5_a56 JTF_VARCHAR2_TABLE_500
250 , p5_a57 JTF_VARCHAR2_TABLE_500
251 , p5_a58 JTF_VARCHAR2_TABLE_500
252 , p5_a59 JTF_VARCHAR2_TABLE_500
253 , p5_a60 JTF_VARCHAR2_TABLE_500
254 , p5_a61 JTF_VARCHAR2_TABLE_500
255 , p5_a62 JTF_VARCHAR2_TABLE_500
256 , p5_a63 JTF_VARCHAR2_TABLE_500
257 , p5_a64 JTF_VARCHAR2_TABLE_500
258 , p5_a65 JTF_VARCHAR2_TABLE_500
259 , p5_a66 JTF_VARCHAR2_TABLE_500
260 , p5_a67 JTF_VARCHAR2_TABLE_500
261 , p5_a68 JTF_VARCHAR2_TABLE_500
262 , p5_a69 JTF_VARCHAR2_TABLE_500
263 , p5_a70 JTF_VARCHAR2_TABLE_500
264 , p5_a71 JTF_NUMBER_TABLE
265 , p5_a72 JTF_DATE_TABLE
266 , p5_a73 JTF_NUMBER_TABLE
267 , p5_a74 JTF_DATE_TABLE
268 , p5_a75 JTF_NUMBER_TABLE
269 , p6_a0 out nocopy JTF_NUMBER_TABLE
270 , p6_a1 out nocopy JTF_NUMBER_TABLE
271 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
272 , p6_a3 out nocopy JTF_NUMBER_TABLE
273 , p6_a4 out nocopy JTF_NUMBER_TABLE
274 , p6_a5 out nocopy JTF_NUMBER_TABLE
275 , p6_a6 out nocopy JTF_NUMBER_TABLE
276 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
277 , p6_a8 out nocopy JTF_NUMBER_TABLE
278 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
279 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
280 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
281 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
282 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
283 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
284 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
285 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
286 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
287 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_600
288 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_2000
289 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
290 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
291 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
292 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
293 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_200
294 , p6_a25 out nocopy JTF_DATE_TABLE
295 , p6_a26 out nocopy JTF_DATE_TABLE
296 , p6_a27 out nocopy JTF_NUMBER_TABLE
297 , p6_a28 out nocopy JTF_DATE_TABLE
298 , p6_a29 out nocopy JTF_DATE_TABLE
299 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
300 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_2000
301 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_100
302 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
303 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
304 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
305 , p6_a36 out nocopy JTF_NUMBER_TABLE
306 , p6_a37 out nocopy JTF_NUMBER_TABLE
307 , p6_a38 out nocopy JTF_DATE_TABLE
308 , p6_a39 out nocopy JTF_DATE_TABLE
309 , p6_a40 out nocopy JTF_DATE_TABLE
310 , p6_a41 out nocopy JTF_DATE_TABLE
311 , p6_a42 out nocopy JTF_DATE_TABLE
312 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_100
313 , p6_a44 out nocopy JTF_DATE_TABLE
314 , p6_a45 out nocopy JTF_DATE_TABLE
315 , p6_a46 out nocopy JTF_NUMBER_TABLE
316 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_100
317 , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
318 , p6_a49 out nocopy JTF_NUMBER_TABLE
319 , p6_a50 out nocopy JTF_NUMBER_TABLE
320 , p6_a51 out nocopy JTF_NUMBER_TABLE
321 , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100
322 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
323 , p6_a54 out nocopy JTF_NUMBER_TABLE
324 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_100
325 , p6_a56 out nocopy JTF_VARCHAR2_TABLE_500
326 , p6_a57 out nocopy JTF_VARCHAR2_TABLE_500
327 , p6_a58 out nocopy JTF_VARCHAR2_TABLE_500
328 , p6_a59 out nocopy JTF_VARCHAR2_TABLE_500
329 , p6_a60 out nocopy JTF_VARCHAR2_TABLE_500
330 , p6_a61 out nocopy JTF_VARCHAR2_TABLE_500
331 , p6_a62 out nocopy JTF_VARCHAR2_TABLE_500
332 , p6_a63 out nocopy JTF_VARCHAR2_TABLE_500
333 , p6_a64 out nocopy JTF_VARCHAR2_TABLE_500
334 , p6_a65 out nocopy JTF_VARCHAR2_TABLE_500
335 , p6_a66 out nocopy JTF_VARCHAR2_TABLE_500
336 , p6_a67 out nocopy JTF_VARCHAR2_TABLE_500
337 , p6_a68 out nocopy JTF_VARCHAR2_TABLE_500
338 , p6_a69 out nocopy JTF_VARCHAR2_TABLE_500
339 , p6_a70 out nocopy JTF_VARCHAR2_TABLE_500
340 , p6_a71 out nocopy JTF_NUMBER_TABLE
341 , p6_a72 out nocopy JTF_DATE_TABLE
342 , p6_a73 out nocopy JTF_NUMBER_TABLE
343 , p6_a74 out nocopy JTF_DATE_TABLE
344 , p6_a75 out nocopy JTF_NUMBER_TABLE
345 )
346 as
347 ddp_chrv_tbl okc_chr_pvt.chrv_tbl_type;
348 ddx_chrv_tbl okc_chr_pvt.chrv_tbl_type;
349 ddindx binary_integer; indx binary_integer;
350 begin
351 null;
352 end;
353
354 procedure update_contract_header(p_api_version NUMBER
355 , p_init_msg_list VARCHAR2
356 , x_return_status out nocopy VARCHAR2
357 , x_msg_count out nocopy NUMBER
358 , x_msg_data out nocopy VARCHAR2
359 , p_restricted_update VARCHAR2
360 , p6_a0 NUMBER
361 , p6_a1 NUMBER
362 , p6_a2 VARCHAR2
363 , p6_a3 NUMBER
364 , p6_a4 NUMBER
365 , p6_a5 NUMBER
366 , p6_a6 NUMBER
367 , p6_a7 VARCHAR2
368 , p6_a8 NUMBER
369 , p6_a9 VARCHAR2
370 , p6_a10 VARCHAR2
371 , p6_a11 VARCHAR2
372 , p6_a12 VARCHAR2
373 , p6_a13 VARCHAR2
374 , p6_a14 VARCHAR2
375 , p6_a15 VARCHAR2
376 , p6_a16 VARCHAR2
377 , p6_a17 VARCHAR2
378 , p6_a18 VARCHAR2
379 , p6_a19 VARCHAR2
380 , p6_a20 VARCHAR2
381 , p6_a21 VARCHAR2
382 , p6_a22 VARCHAR2
383 , p6_a23 VARCHAR2
384 , p6_a24 VARCHAR2
385 , p6_a25 DATE
386 , p6_a26 DATE
387 , p6_a27 NUMBER
388 , p6_a28 DATE
389 , p6_a29 DATE
390 , p6_a30 VARCHAR2
391 , p6_a31 VARCHAR2
392 , p6_a32 VARCHAR2
393 , p6_a33 VARCHAR2
394 , p6_a34 VARCHAR2
395 , p6_a35 VARCHAR2
396 , p6_a36 NUMBER
397 , p6_a37 NUMBER
398 , p6_a38 DATE
399 , p6_a39 DATE
400 , p6_a40 DATE
401 , p6_a41 DATE
402 , p6_a42 DATE
403 , p6_a43 VARCHAR2
404 , p6_a44 DATE
405 , p6_a45 DATE
406 , p6_a46 NUMBER
407 , p6_a47 VARCHAR2
408 , p6_a48 VARCHAR2
409 , p6_a49 NUMBER
410 , p6_a50 NUMBER
411 , p6_a51 NUMBER
412 , p6_a52 VARCHAR2
413 , p6_a53 VARCHAR2
414 , p6_a54 NUMBER
415 , p6_a55 VARCHAR2
416 , p6_a56 VARCHAR2
417 , p6_a57 VARCHAR2
418 , p6_a58 VARCHAR2
419 , p6_a59 VARCHAR2
420 , p6_a60 VARCHAR2
421 , p6_a61 VARCHAR2
422 , p6_a62 VARCHAR2
423 , p6_a63 VARCHAR2
424 , p6_a64 VARCHAR2
425 , p6_a65 VARCHAR2
426 , p6_a66 VARCHAR2
427 , p6_a67 VARCHAR2
428 , p6_a68 VARCHAR2
429 , p6_a69 VARCHAR2
430 , p6_a70 VARCHAR2
431 , p6_a71 NUMBER
432 , p6_a72 DATE
433 , p6_a73 NUMBER
434 , p6_a74 DATE
435 , p6_a75 NUMBER
436 , p7_a0 out nocopy NUMBER
437 , p7_a1 out nocopy NUMBER
438 , p7_a2 out nocopy VARCHAR2
439 , p7_a3 out nocopy NUMBER
440 , p7_a4 out nocopy NUMBER
441 , p7_a5 out nocopy NUMBER
442 , p7_a6 out nocopy NUMBER
443 , p7_a7 out nocopy VARCHAR2
444 , p7_a8 out nocopy NUMBER
445 , p7_a9 out nocopy VARCHAR2
446 , p7_a10 out nocopy VARCHAR2
447 , p7_a11 out nocopy VARCHAR2
448 , p7_a12 out nocopy VARCHAR2
449 , p7_a13 out nocopy VARCHAR2
450 , p7_a14 out nocopy VARCHAR2
451 , p7_a15 out nocopy VARCHAR2
452 , p7_a16 out nocopy VARCHAR2
453 , p7_a17 out nocopy VARCHAR2
454 , p7_a18 out nocopy VARCHAR2
455 , p7_a19 out nocopy VARCHAR2
456 , p7_a20 out nocopy VARCHAR2
457 , p7_a21 out nocopy VARCHAR2
458 , p7_a22 out nocopy VARCHAR2
459 , p7_a23 out nocopy VARCHAR2
460 , p7_a24 out nocopy VARCHAR2
461 , p7_a25 out nocopy DATE
462 , p7_a26 out nocopy DATE
463 , p7_a27 out nocopy NUMBER
464 , p7_a28 out nocopy DATE
465 , p7_a29 out nocopy DATE
466 , p7_a30 out nocopy VARCHAR2
467 , p7_a31 out nocopy VARCHAR2
468 , p7_a32 out nocopy VARCHAR2
469 , p7_a33 out nocopy VARCHAR2
470 , p7_a34 out nocopy VARCHAR2
471 , p7_a35 out nocopy VARCHAR2
472 , p7_a36 out nocopy NUMBER
473 , p7_a37 out nocopy NUMBER
474 , p7_a38 out nocopy DATE
475 , p7_a39 out nocopy DATE
476 , p7_a40 out nocopy DATE
477 , p7_a41 out nocopy DATE
478 , p7_a42 out nocopy DATE
479 , p7_a43 out nocopy VARCHAR2
480 , p7_a44 out nocopy DATE
481 , p7_a45 out nocopy DATE
482 , p7_a46 out nocopy NUMBER
483 , p7_a47 out nocopy VARCHAR2
484 , p7_a48 out nocopy VARCHAR2
485 , p7_a49 out nocopy NUMBER
486 , p7_a50 out nocopy NUMBER
487 , p7_a51 out nocopy NUMBER
488 , p7_a52 out nocopy VARCHAR2
489 , p7_a53 out nocopy VARCHAR2
490 , p7_a54 out nocopy NUMBER
491 , p7_a55 out nocopy VARCHAR2
492 , p7_a56 out nocopy VARCHAR2
493 , p7_a57 out nocopy VARCHAR2
494 , p7_a58 out nocopy VARCHAR2
495 , p7_a59 out nocopy VARCHAR2
496 , p7_a60 out nocopy VARCHAR2
497 , p7_a61 out nocopy VARCHAR2
498 , p7_a62 out nocopy VARCHAR2
499 , p7_a63 out nocopy VARCHAR2
500 , p7_a64 out nocopy VARCHAR2
501 , p7_a65 out nocopy VARCHAR2
502 , p7_a66 out nocopy VARCHAR2
503 , p7_a67 out nocopy VARCHAR2
504 , p7_a68 out nocopy VARCHAR2
505 , p7_a69 out nocopy VARCHAR2
506 , p7_a70 out nocopy VARCHAR2
507 , p7_a71 out nocopy NUMBER
508 , p7_a72 out nocopy DATE
509 , p7_a73 out nocopy NUMBER
510 , p7_a74 out nocopy DATE
511 , p7_a75 out nocopy NUMBER
512 )
513 as
514 ddp_chrv_rec okc_chr_pvt.chrv_rec_type;
515 ddx_chrv_rec okc_chr_pvt.chrv_rec_type;
516 ddindx binary_integer; indx binary_integer;
517 begin
518
519 null;
520 end;
521
522 procedure update_contract_header(p_api_version NUMBER
523 , p_init_msg_list VARCHAR2
524 , x_return_status out nocopy VARCHAR2
525 , x_msg_count out nocopy NUMBER
526 , x_msg_data out nocopy VARCHAR2
527 , p_restricted_update VARCHAR2
528 , p6_a0 JTF_NUMBER_TABLE
529 , p6_a1 JTF_NUMBER_TABLE
530 , p6_a2 JTF_VARCHAR2_TABLE_100
531 , p6_a3 JTF_NUMBER_TABLE
532 , p6_a4 JTF_NUMBER_TABLE
533 , p6_a5 JTF_NUMBER_TABLE
534 , p6_a6 JTF_NUMBER_TABLE
535 , p6_a7 JTF_VARCHAR2_TABLE_100
536 , p6_a8 JTF_NUMBER_TABLE
537 , p6_a9 JTF_VARCHAR2_TABLE_100
538 , p6_a10 JTF_VARCHAR2_TABLE_200
539 , p6_a11 JTF_VARCHAR2_TABLE_100
540 , p6_a12 JTF_VARCHAR2_TABLE_200
541 , p6_a13 JTF_VARCHAR2_TABLE_100
542 , p6_a14 JTF_VARCHAR2_TABLE_100
543 , p6_a15 JTF_VARCHAR2_TABLE_100
544 , p6_a16 JTF_VARCHAR2_TABLE_100
545 , p6_a17 JTF_VARCHAR2_TABLE_200
546 , p6_a18 JTF_VARCHAR2_TABLE_600
547 , p6_a19 JTF_VARCHAR2_TABLE_2000
548 , p6_a20 JTF_VARCHAR2_TABLE_2000
549 , p6_a21 JTF_VARCHAR2_TABLE_100
550 , p6_a22 JTF_VARCHAR2_TABLE_300
551 , p6_a23 JTF_VARCHAR2_TABLE_100
552 , p6_a24 JTF_VARCHAR2_TABLE_200
553 , p6_a25 JTF_DATE_TABLE
554 , p6_a26 JTF_DATE_TABLE
555 , p6_a27 JTF_NUMBER_TABLE
556 , p6_a28 JTF_DATE_TABLE
557 , p6_a29 JTF_DATE_TABLE
558 , p6_a30 JTF_VARCHAR2_TABLE_100
559 , p6_a31 JTF_VARCHAR2_TABLE_2000
560 , p6_a32 JTF_VARCHAR2_TABLE_100
561 , p6_a33 JTF_VARCHAR2_TABLE_100
562 , p6_a34 JTF_VARCHAR2_TABLE_100
563 , p6_a35 JTF_VARCHAR2_TABLE_100
564 , p6_a36 JTF_NUMBER_TABLE
565 , p6_a37 JTF_NUMBER_TABLE
566 , p6_a38 JTF_DATE_TABLE
567 , p6_a39 JTF_DATE_TABLE
568 , p6_a40 JTF_DATE_TABLE
569 , p6_a41 JTF_DATE_TABLE
570 , p6_a42 JTF_DATE_TABLE
571 , p6_a43 JTF_VARCHAR2_TABLE_100
572 , p6_a44 JTF_DATE_TABLE
573 , p6_a45 JTF_DATE_TABLE
574 , p6_a46 JTF_NUMBER_TABLE
575 , p6_a47 JTF_VARCHAR2_TABLE_100
576 , p6_a48 JTF_VARCHAR2_TABLE_100
577 , p6_a49 JTF_NUMBER_TABLE
578 , p6_a50 JTF_NUMBER_TABLE
579 , p6_a51 JTF_NUMBER_TABLE
580 , p6_a52 JTF_VARCHAR2_TABLE_100
581 , p6_a53 JTF_VARCHAR2_TABLE_100
582 , p6_a54 JTF_NUMBER_TABLE
583 , p6_a55 JTF_VARCHAR2_TABLE_100
584 , p6_a56 JTF_VARCHAR2_TABLE_500
585 , p6_a57 JTF_VARCHAR2_TABLE_500
586 , p6_a58 JTF_VARCHAR2_TABLE_500
587 , p6_a59 JTF_VARCHAR2_TABLE_500
588 , p6_a60 JTF_VARCHAR2_TABLE_500
589 , p6_a61 JTF_VARCHAR2_TABLE_500
590 , p6_a62 JTF_VARCHAR2_TABLE_500
591 , p6_a63 JTF_VARCHAR2_TABLE_500
592 , p6_a64 JTF_VARCHAR2_TABLE_500
593 , p6_a65 JTF_VARCHAR2_TABLE_500
594 , p6_a66 JTF_VARCHAR2_TABLE_500
595 , p6_a67 JTF_VARCHAR2_TABLE_500
596 , p6_a68 JTF_VARCHAR2_TABLE_500
597 , p6_a69 JTF_VARCHAR2_TABLE_500
598 , p6_a70 JTF_VARCHAR2_TABLE_500
599 , p6_a71 JTF_NUMBER_TABLE
600 , p6_a72 JTF_DATE_TABLE
601 , p6_a73 JTF_NUMBER_TABLE
602 , p6_a74 JTF_DATE_TABLE
603 , p6_a75 JTF_NUMBER_TABLE
604 , p7_a0 out nocopy JTF_NUMBER_TABLE
605 , p7_a1 out nocopy JTF_NUMBER_TABLE
606 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
607 , p7_a3 out nocopy JTF_NUMBER_TABLE
608 , p7_a4 out nocopy JTF_NUMBER_TABLE
609 , p7_a5 out nocopy JTF_NUMBER_TABLE
610 , p7_a6 out nocopy JTF_NUMBER_TABLE
611 , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
612 , p7_a8 out nocopy JTF_NUMBER_TABLE
613 , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
614 , p7_a10 out nocopy JTF_VARCHAR2_TABLE_200
615 , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
616 , p7_a12 out nocopy JTF_VARCHAR2_TABLE_200
617 , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
618 , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
619 , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
620 , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
621 , p7_a17 out nocopy JTF_VARCHAR2_TABLE_200
622 , p7_a18 out nocopy JTF_VARCHAR2_TABLE_600
623 , p7_a19 out nocopy JTF_VARCHAR2_TABLE_2000
624 , p7_a20 out nocopy JTF_VARCHAR2_TABLE_2000
625 , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
626 , p7_a22 out nocopy JTF_VARCHAR2_TABLE_300
627 , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
628 , p7_a24 out nocopy JTF_VARCHAR2_TABLE_200
629 , p7_a25 out nocopy JTF_DATE_TABLE
630 , p7_a26 out nocopy JTF_DATE_TABLE
631 , p7_a27 out nocopy JTF_NUMBER_TABLE
632 , p7_a28 out nocopy JTF_DATE_TABLE
633 , p7_a29 out nocopy JTF_DATE_TABLE
634 , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
635 , p7_a31 out nocopy JTF_VARCHAR2_TABLE_2000
636 , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
637 , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
638 , p7_a34 out nocopy JTF_VARCHAR2_TABLE_100
639 , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
640 , p7_a36 out nocopy JTF_NUMBER_TABLE
641 , p7_a37 out nocopy JTF_NUMBER_TABLE
642 , p7_a38 out nocopy JTF_DATE_TABLE
643 , p7_a39 out nocopy JTF_DATE_TABLE
644 , p7_a40 out nocopy JTF_DATE_TABLE
645 , p7_a41 out nocopy JTF_DATE_TABLE
646 , p7_a42 out nocopy JTF_DATE_TABLE
647 , p7_a43 out nocopy JTF_VARCHAR2_TABLE_100
648 , p7_a44 out nocopy JTF_DATE_TABLE
649 , p7_a45 out nocopy JTF_DATE_TABLE
650 , p7_a46 out nocopy JTF_NUMBER_TABLE
651 , p7_a47 out nocopy JTF_VARCHAR2_TABLE_100
652 , p7_a48 out nocopy JTF_VARCHAR2_TABLE_100
653 , p7_a49 out nocopy JTF_NUMBER_TABLE
654 , p7_a50 out nocopy JTF_NUMBER_TABLE
655 , p7_a51 out nocopy JTF_NUMBER_TABLE
656 , p7_a52 out nocopy JTF_VARCHAR2_TABLE_100
657 , p7_a53 out nocopy JTF_VARCHAR2_TABLE_100
658 , p7_a54 out nocopy JTF_NUMBER_TABLE
659 , p7_a55 out nocopy JTF_VARCHAR2_TABLE_100
660 , p7_a56 out nocopy JTF_VARCHAR2_TABLE_500
661 , p7_a57 out nocopy JTF_VARCHAR2_TABLE_500
662 , p7_a58 out nocopy JTF_VARCHAR2_TABLE_500
663 , p7_a59 out nocopy JTF_VARCHAR2_TABLE_500
664 , p7_a60 out nocopy JTF_VARCHAR2_TABLE_500
665 , p7_a61 out nocopy JTF_VARCHAR2_TABLE_500
666 , p7_a62 out nocopy JTF_VARCHAR2_TABLE_500
667 , p7_a63 out nocopy JTF_VARCHAR2_TABLE_500
668 , p7_a64 out nocopy JTF_VARCHAR2_TABLE_500
669 , p7_a65 out nocopy JTF_VARCHAR2_TABLE_500
670 , p7_a66 out nocopy JTF_VARCHAR2_TABLE_500
671 , p7_a67 out nocopy JTF_VARCHAR2_TABLE_500
672 , p7_a68 out nocopy JTF_VARCHAR2_TABLE_500
673 , p7_a69 out nocopy JTF_VARCHAR2_TABLE_500
674 , p7_a70 out nocopy JTF_VARCHAR2_TABLE_500
675 , p7_a71 out nocopy JTF_NUMBER_TABLE
676 , p7_a72 out nocopy JTF_DATE_TABLE
677 , p7_a73 out nocopy JTF_NUMBER_TABLE
678 , p7_a74 out nocopy JTF_DATE_TABLE
679 , p7_a75 out nocopy JTF_NUMBER_TABLE
680 )
681 as
682 ddp_chrv_tbl okc_chr_pvt.chrv_tbl_type;
683 ddx_chrv_tbl okc_chr_pvt.chrv_tbl_type;
684 ddindx binary_integer; indx binary_integer;
685 begin
686 null;
687 end;
688
689 procedure delete_contract_header(p_api_version NUMBER
690 , p_init_msg_list VARCHAR2
691 , x_return_status out nocopy VARCHAR2
692 , x_msg_count out nocopy NUMBER
693 , x_msg_data out nocopy VARCHAR2
694 , p5_a0 NUMBER := 0-1962.0724
695 , p5_a1 NUMBER := 0-1962.0724
696 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
697 , p5_a3 NUMBER := 0-1962.0724
698 , p5_a4 NUMBER := 0-1962.0724
699 , p5_a5 NUMBER := 0-1962.0724
700 , p5_a6 NUMBER := 0-1962.0724
701 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
702 , p5_a8 NUMBER := 0-1962.0724
703 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
704 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
705 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
706 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
707 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
708 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
709 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
710 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
711 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
712 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
713 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
714 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
715 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
716 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
717 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
718 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
719 , p5_a25 DATE := fnd_api.g_miss_date
720 , p5_a26 DATE := fnd_api.g_miss_date
721 , p5_a27 NUMBER := 0-1962.0724
722 , p5_a28 DATE := fnd_api.g_miss_date
723 , p5_a29 DATE := fnd_api.g_miss_date
724 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
725 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
726 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
727 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
728 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
729 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
730 , p5_a36 NUMBER := 0-1962.0724
731 , p5_a37 NUMBER := 0-1962.0724
732 , p5_a38 DATE := fnd_api.g_miss_date
733 , p5_a39 DATE := fnd_api.g_miss_date
734 , p5_a40 DATE := fnd_api.g_miss_date
735 , p5_a41 DATE := fnd_api.g_miss_date
736 , p5_a42 DATE := fnd_api.g_miss_date
737 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
738 , p5_a44 DATE := fnd_api.g_miss_date
739 , p5_a45 DATE := fnd_api.g_miss_date
740 , p5_a46 NUMBER := 0-1962.0724
741 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
742 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
743 , p5_a49 NUMBER := 0-1962.0724
744 , p5_a50 NUMBER := 0-1962.0724
745 , p5_a51 NUMBER := 0-1962.0724
746 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
747 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
748 , p5_a54 NUMBER := 0-1962.0724
749 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
750 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
751 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
752 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
753 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
754 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
755 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
756 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
757 , p5_a63 VARCHAR2 := fnd_api.g_miss_char
758 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
759 , p5_a65 VARCHAR2 := fnd_api.g_miss_char
760 , p5_a66 VARCHAR2 := fnd_api.g_miss_char
761 , p5_a67 VARCHAR2 := fnd_api.g_miss_char
762 , p5_a68 VARCHAR2 := fnd_api.g_miss_char
763 , p5_a69 VARCHAR2 := fnd_api.g_miss_char
764 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
765 , p5_a71 NUMBER := 0-1962.0724
766 , p5_a72 DATE := fnd_api.g_miss_date
767 , p5_a73 NUMBER := 0-1962.0724
768 , p5_a74 DATE := fnd_api.g_miss_date
769 , p5_a75 NUMBER := 0-1962.0724
770 )
771 as
772 ddp_chrv_rec okc_chr_pvt.chrv_rec_type;
773 ddindx binary_integer; indx binary_integer;
774 begin
775 null;
776 end;
777
778 procedure delete_contract_header(p_api_version NUMBER
779 , p_init_msg_list VARCHAR2
780 , x_return_status out nocopy VARCHAR2
781 , x_msg_count out nocopy NUMBER
782 , x_msg_data out nocopy VARCHAR2
783 , p5_a0 JTF_NUMBER_TABLE
784 , p5_a1 JTF_NUMBER_TABLE
785 , p5_a2 JTF_VARCHAR2_TABLE_100
786 , p5_a3 JTF_NUMBER_TABLE
787 , p5_a4 JTF_NUMBER_TABLE
788 , p5_a5 JTF_NUMBER_TABLE
789 , p5_a6 JTF_NUMBER_TABLE
790 , p5_a7 JTF_VARCHAR2_TABLE_100
791 , p5_a8 JTF_NUMBER_TABLE
792 , p5_a9 JTF_VARCHAR2_TABLE_100
793 , p5_a10 JTF_VARCHAR2_TABLE_200
794 , p5_a11 JTF_VARCHAR2_TABLE_100
795 , p5_a12 JTF_VARCHAR2_TABLE_200
796 , p5_a13 JTF_VARCHAR2_TABLE_100
797 , p5_a14 JTF_VARCHAR2_TABLE_100
798 , p5_a15 JTF_VARCHAR2_TABLE_100
799 , p5_a16 JTF_VARCHAR2_TABLE_100
800 , p5_a17 JTF_VARCHAR2_TABLE_200
801 , p5_a18 JTF_VARCHAR2_TABLE_600
802 , p5_a19 JTF_VARCHAR2_TABLE_2000
803 , p5_a20 JTF_VARCHAR2_TABLE_2000
804 , p5_a21 JTF_VARCHAR2_TABLE_100
805 , p5_a22 JTF_VARCHAR2_TABLE_300
806 , p5_a23 JTF_VARCHAR2_TABLE_100
807 , p5_a24 JTF_VARCHAR2_TABLE_200
808 , p5_a25 JTF_DATE_TABLE
809 , p5_a26 JTF_DATE_TABLE
810 , p5_a27 JTF_NUMBER_TABLE
811 , p5_a28 JTF_DATE_TABLE
812 , p5_a29 JTF_DATE_TABLE
813 , p5_a30 JTF_VARCHAR2_TABLE_100
814 , p5_a31 JTF_VARCHAR2_TABLE_2000
815 , p5_a32 JTF_VARCHAR2_TABLE_100
816 , p5_a33 JTF_VARCHAR2_TABLE_100
817 , p5_a34 JTF_VARCHAR2_TABLE_100
818 , p5_a35 JTF_VARCHAR2_TABLE_100
819 , p5_a36 JTF_NUMBER_TABLE
820 , p5_a37 JTF_NUMBER_TABLE
821 , p5_a38 JTF_DATE_TABLE
822 , p5_a39 JTF_DATE_TABLE
823 , p5_a40 JTF_DATE_TABLE
824 , p5_a41 JTF_DATE_TABLE
825 , p5_a42 JTF_DATE_TABLE
826 , p5_a43 JTF_VARCHAR2_TABLE_100
827 , p5_a44 JTF_DATE_TABLE
828 , p5_a45 JTF_DATE_TABLE
829 , p5_a46 JTF_NUMBER_TABLE
830 , p5_a47 JTF_VARCHAR2_TABLE_100
831 , p5_a48 JTF_VARCHAR2_TABLE_100
832 , p5_a49 JTF_NUMBER_TABLE
833 , p5_a50 JTF_NUMBER_TABLE
834 , p5_a51 JTF_NUMBER_TABLE
835 , p5_a52 JTF_VARCHAR2_TABLE_100
836 , p5_a53 JTF_VARCHAR2_TABLE_100
837 , p5_a54 JTF_NUMBER_TABLE
838 , p5_a55 JTF_VARCHAR2_TABLE_100
839 , p5_a56 JTF_VARCHAR2_TABLE_500
840 , p5_a57 JTF_VARCHAR2_TABLE_500
841 , p5_a58 JTF_VARCHAR2_TABLE_500
842 , p5_a59 JTF_VARCHAR2_TABLE_500
843 , p5_a60 JTF_VARCHAR2_TABLE_500
844 , p5_a61 JTF_VARCHAR2_TABLE_500
845 , p5_a62 JTF_VARCHAR2_TABLE_500
846 , p5_a63 JTF_VARCHAR2_TABLE_500
847 , p5_a64 JTF_VARCHAR2_TABLE_500
848 , p5_a65 JTF_VARCHAR2_TABLE_500
849 , p5_a66 JTF_VARCHAR2_TABLE_500
850 , p5_a67 JTF_VARCHAR2_TABLE_500
851 , p5_a68 JTF_VARCHAR2_TABLE_500
852 , p5_a69 JTF_VARCHAR2_TABLE_500
853 , p5_a70 JTF_VARCHAR2_TABLE_500
854 , p5_a71 JTF_NUMBER_TABLE
855 , p5_a72 JTF_DATE_TABLE
856 , p5_a73 JTF_NUMBER_TABLE
857 , p5_a74 JTF_DATE_TABLE
858 , p5_a75 JTF_NUMBER_TABLE
859 )
860 as
861 ddp_chrv_tbl okc_chr_pvt.chrv_tbl_type;
862 ddindx binary_integer; indx binary_integer;
863 begin
864 null;
865 end;
866
867 procedure lock_contract_header(p_api_version NUMBER
868 , p_init_msg_list VARCHAR2
869 , x_return_status out nocopy VARCHAR2
870 , x_msg_count out nocopy NUMBER
871 , x_msg_data out nocopy VARCHAR2
872 , p5_a0 NUMBER := 0-1962.0724
873 , p5_a1 NUMBER := 0-1962.0724
874 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
875 , p5_a3 NUMBER := 0-1962.0724
876 , p5_a4 NUMBER := 0-1962.0724
877 , p5_a5 NUMBER := 0-1962.0724
878 , p5_a6 NUMBER := 0-1962.0724
879 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
880 , p5_a8 NUMBER := 0-1962.0724
881 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
882 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
883 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
884 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
885 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
886 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
887 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
888 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
889 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
890 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
891 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
892 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
893 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
894 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
895 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
896 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
897 , p5_a25 DATE := fnd_api.g_miss_date
898 , p5_a26 DATE := fnd_api.g_miss_date
899 , p5_a27 NUMBER := 0-1962.0724
900 , p5_a28 DATE := fnd_api.g_miss_date
901 , p5_a29 DATE := fnd_api.g_miss_date
902 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
903 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
904 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
905 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
906 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
907 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
908 , p5_a36 NUMBER := 0-1962.0724
909 , p5_a37 NUMBER := 0-1962.0724
910 , p5_a38 DATE := fnd_api.g_miss_date
911 , p5_a39 DATE := fnd_api.g_miss_date
912 , p5_a40 DATE := fnd_api.g_miss_date
913 , p5_a41 DATE := fnd_api.g_miss_date
914 , p5_a42 DATE := fnd_api.g_miss_date
915 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
916 , p5_a44 DATE := fnd_api.g_miss_date
917 , p5_a45 DATE := fnd_api.g_miss_date
918 , p5_a46 NUMBER := 0-1962.0724
919 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
920 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
921 , p5_a49 NUMBER := 0-1962.0724
922 , p5_a50 NUMBER := 0-1962.0724
923 , p5_a51 NUMBER := 0-1962.0724
924 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
925 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
926 , p5_a54 NUMBER := 0-1962.0724
927 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
928 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
929 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
930 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
931 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
932 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
933 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
934 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
935 , p5_a63 VARCHAR2 := fnd_api.g_miss_char
936 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
937 , p5_a65 VARCHAR2 := fnd_api.g_miss_char
938 , p5_a66 VARCHAR2 := fnd_api.g_miss_char
939 , p5_a67 VARCHAR2 := fnd_api.g_miss_char
940 , p5_a68 VARCHAR2 := fnd_api.g_miss_char
941 , p5_a69 VARCHAR2 := fnd_api.g_miss_char
942 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
943 , p5_a71 NUMBER := 0-1962.0724
944 , p5_a72 DATE := fnd_api.g_miss_date
945 , p5_a73 NUMBER := 0-1962.0724
946 , p5_a74 DATE := fnd_api.g_miss_date
947 , p5_a75 NUMBER := 0-1962.0724
948 )
949 as
950 ddp_chrv_rec okc_chr_pvt.chrv_rec_type;
951 ddindx binary_integer; indx binary_integer;
952 begin
953 null;
954 end;
955
956 procedure lock_contract_header(p_api_version NUMBER
957 , p_init_msg_list VARCHAR2
958 , x_return_status out nocopy VARCHAR2
959 , x_msg_count out nocopy NUMBER
960 , x_msg_data out nocopy VARCHAR2
961 , p5_a0 JTF_NUMBER_TABLE
962 , p5_a1 JTF_NUMBER_TABLE
963 , p5_a2 JTF_VARCHAR2_TABLE_100
964 , p5_a3 JTF_NUMBER_TABLE
965 , p5_a4 JTF_NUMBER_TABLE
966 , p5_a5 JTF_NUMBER_TABLE
967 , p5_a6 JTF_NUMBER_TABLE
968 , p5_a7 JTF_VARCHAR2_TABLE_100
969 , p5_a8 JTF_NUMBER_TABLE
970 , p5_a9 JTF_VARCHAR2_TABLE_100
971 , p5_a10 JTF_VARCHAR2_TABLE_200
972 , p5_a11 JTF_VARCHAR2_TABLE_100
973 , p5_a12 JTF_VARCHAR2_TABLE_200
974 , p5_a13 JTF_VARCHAR2_TABLE_100
975 , p5_a14 JTF_VARCHAR2_TABLE_100
976 , p5_a15 JTF_VARCHAR2_TABLE_100
977 , p5_a16 JTF_VARCHAR2_TABLE_100
978 , p5_a17 JTF_VARCHAR2_TABLE_200
979 , p5_a18 JTF_VARCHAR2_TABLE_600
980 , p5_a19 JTF_VARCHAR2_TABLE_2000
981 , p5_a20 JTF_VARCHAR2_TABLE_2000
982 , p5_a21 JTF_VARCHAR2_TABLE_100
983 , p5_a22 JTF_VARCHAR2_TABLE_300
984 , p5_a23 JTF_VARCHAR2_TABLE_100
985 , p5_a24 JTF_VARCHAR2_TABLE_200
986 , p5_a25 JTF_DATE_TABLE
987 , p5_a26 JTF_DATE_TABLE
988 , p5_a27 JTF_NUMBER_TABLE
989 , p5_a28 JTF_DATE_TABLE
990 , p5_a29 JTF_DATE_TABLE
991 , p5_a30 JTF_VARCHAR2_TABLE_100
992 , p5_a31 JTF_VARCHAR2_TABLE_2000
993 , p5_a32 JTF_VARCHAR2_TABLE_100
994 , p5_a33 JTF_VARCHAR2_TABLE_100
995 , p5_a34 JTF_VARCHAR2_TABLE_100
996 , p5_a35 JTF_VARCHAR2_TABLE_100
997 , p5_a36 JTF_NUMBER_TABLE
998 , p5_a37 JTF_NUMBER_TABLE
999 , p5_a38 JTF_DATE_TABLE
1000 , p5_a39 JTF_DATE_TABLE
1001 , p5_a40 JTF_DATE_TABLE
1002 , p5_a41 JTF_DATE_TABLE
1003 , p5_a42 JTF_DATE_TABLE
1004 , p5_a43 JTF_VARCHAR2_TABLE_100
1005 , p5_a44 JTF_DATE_TABLE
1006 , p5_a45 JTF_DATE_TABLE
1007 , p5_a46 JTF_NUMBER_TABLE
1008 , p5_a47 JTF_VARCHAR2_TABLE_100
1009 , p5_a48 JTF_VARCHAR2_TABLE_100
1010 , p5_a49 JTF_NUMBER_TABLE
1011 , p5_a50 JTF_NUMBER_TABLE
1012 , p5_a51 JTF_NUMBER_TABLE
1013 , p5_a52 JTF_VARCHAR2_TABLE_100
1014 , p5_a53 JTF_VARCHAR2_TABLE_100
1015 , p5_a54 JTF_NUMBER_TABLE
1016 , p5_a55 JTF_VARCHAR2_TABLE_100
1017 , p5_a56 JTF_VARCHAR2_TABLE_500
1018 , p5_a57 JTF_VARCHAR2_TABLE_500
1019 , p5_a58 JTF_VARCHAR2_TABLE_500
1020 , p5_a59 JTF_VARCHAR2_TABLE_500
1021 , p5_a60 JTF_VARCHAR2_TABLE_500
1022 , p5_a61 JTF_VARCHAR2_TABLE_500
1023 , p5_a62 JTF_VARCHAR2_TABLE_500
1024 , p5_a63 JTF_VARCHAR2_TABLE_500
1025 , p5_a64 JTF_VARCHAR2_TABLE_500
1026 , p5_a65 JTF_VARCHAR2_TABLE_500
1027 , p5_a66 JTF_VARCHAR2_TABLE_500
1028 , p5_a67 JTF_VARCHAR2_TABLE_500
1029 , p5_a68 JTF_VARCHAR2_TABLE_500
1030 , p5_a69 JTF_VARCHAR2_TABLE_500
1031 , p5_a70 JTF_VARCHAR2_TABLE_500
1032 , p5_a71 JTF_NUMBER_TABLE
1033 , p5_a72 JTF_DATE_TABLE
1034 , p5_a73 JTF_NUMBER_TABLE
1035 , p5_a74 JTF_DATE_TABLE
1036 , p5_a75 JTF_NUMBER_TABLE
1037 )
1038 as
1039 ddp_chrv_tbl okc_chr_pvt.chrv_tbl_type;
1040 ddindx binary_integer; indx binary_integer;
1041 begin
1042 null;
1043 end;
1044
1045 procedure validate_contract_header(p_api_version NUMBER
1046 , p_init_msg_list VARCHAR2
1047 , x_return_status out nocopy VARCHAR2
1048 , x_msg_count out nocopy NUMBER
1049 , x_msg_data out nocopy VARCHAR2
1050 , p5_a0 NUMBER := 0-1962.0724
1051 , p5_a1 NUMBER := 0-1962.0724
1052 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1053 , p5_a3 NUMBER := 0-1962.0724
1054 , p5_a4 NUMBER := 0-1962.0724
1055 , p5_a5 NUMBER := 0-1962.0724
1056 , p5_a6 NUMBER := 0-1962.0724
1057 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1058 , p5_a8 NUMBER := 0-1962.0724
1059 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1060 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1061 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1062 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1063 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1064 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1065 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1066 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1067 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1068 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1069 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1070 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1071 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1072 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1073 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1074 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1075 , p5_a25 DATE := fnd_api.g_miss_date
1076 , p5_a26 DATE := fnd_api.g_miss_date
1077 , p5_a27 NUMBER := 0-1962.0724
1078 , p5_a28 DATE := fnd_api.g_miss_date
1079 , p5_a29 DATE := fnd_api.g_miss_date
1080 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1081 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1082 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1083 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1084 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1085 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1086 , p5_a36 NUMBER := 0-1962.0724
1087 , p5_a37 NUMBER := 0-1962.0724
1088 , p5_a38 DATE := fnd_api.g_miss_date
1089 , p5_a39 DATE := fnd_api.g_miss_date
1090 , p5_a40 DATE := fnd_api.g_miss_date
1091 , p5_a41 DATE := fnd_api.g_miss_date
1092 , p5_a42 DATE := fnd_api.g_miss_date
1093 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1094 , p5_a44 DATE := fnd_api.g_miss_date
1095 , p5_a45 DATE := fnd_api.g_miss_date
1096 , p5_a46 NUMBER := 0-1962.0724
1097 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1098 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1099 , p5_a49 NUMBER := 0-1962.0724
1100 , p5_a50 NUMBER := 0-1962.0724
1101 , p5_a51 NUMBER := 0-1962.0724
1102 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1103 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1104 , p5_a54 NUMBER := 0-1962.0724
1105 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
1106 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
1107 , p5_a57 VARCHAR2 := fnd_api.g_miss_char
1108 , p5_a58 VARCHAR2 := fnd_api.g_miss_char
1109 , p5_a59 VARCHAR2 := fnd_api.g_miss_char
1110 , p5_a60 VARCHAR2 := fnd_api.g_miss_char
1111 , p5_a61 VARCHAR2 := fnd_api.g_miss_char
1112 , p5_a62 VARCHAR2 := fnd_api.g_miss_char
1113 , p5_a63 VARCHAR2 := fnd_api.g_miss_char
1114 , p5_a64 VARCHAR2 := fnd_api.g_miss_char
1115 , p5_a65 VARCHAR2 := fnd_api.g_miss_char
1116 , p5_a66 VARCHAR2 := fnd_api.g_miss_char
1117 , p5_a67 VARCHAR2 := fnd_api.g_miss_char
1118 , p5_a68 VARCHAR2 := fnd_api.g_miss_char
1119 , p5_a69 VARCHAR2 := fnd_api.g_miss_char
1120 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
1121 , p5_a71 NUMBER := 0-1962.0724
1122 , p5_a72 DATE := fnd_api.g_miss_date
1123 , p5_a73 NUMBER := 0-1962.0724
1124 , p5_a74 DATE := fnd_api.g_miss_date
1125 , p5_a75 NUMBER := 0-1962.0724
1126 )
1127 as
1128 ddp_chrv_rec okc_chr_pvt.chrv_rec_type;
1129 ddindx binary_integer; indx binary_integer;
1130 begin
1131 null;
1132 end;
1133
1134 procedure validate_contract_header(p_api_version NUMBER
1135 , p_init_msg_list VARCHAR2
1136 , x_return_status out nocopy VARCHAR2
1137 , x_msg_count out nocopy NUMBER
1138 , x_msg_data out nocopy VARCHAR2
1139 , p5_a0 JTF_NUMBER_TABLE
1140 , p5_a1 JTF_NUMBER_TABLE
1141 , p5_a2 JTF_VARCHAR2_TABLE_100
1142 , p5_a3 JTF_NUMBER_TABLE
1143 , p5_a4 JTF_NUMBER_TABLE
1144 , p5_a5 JTF_NUMBER_TABLE
1145 , p5_a6 JTF_NUMBER_TABLE
1146 , p5_a7 JTF_VARCHAR2_TABLE_100
1147 , p5_a8 JTF_NUMBER_TABLE
1148 , p5_a9 JTF_VARCHAR2_TABLE_100
1149 , p5_a10 JTF_VARCHAR2_TABLE_200
1150 , p5_a11 JTF_VARCHAR2_TABLE_100
1151 , p5_a12 JTF_VARCHAR2_TABLE_200
1152 , p5_a13 JTF_VARCHAR2_TABLE_100
1153 , p5_a14 JTF_VARCHAR2_TABLE_100
1154 , p5_a15 JTF_VARCHAR2_TABLE_100
1155 , p5_a16 JTF_VARCHAR2_TABLE_100
1156 , p5_a17 JTF_VARCHAR2_TABLE_200
1157 , p5_a18 JTF_VARCHAR2_TABLE_600
1158 , p5_a19 JTF_VARCHAR2_TABLE_2000
1159 , p5_a20 JTF_VARCHAR2_TABLE_2000
1160 , p5_a21 JTF_VARCHAR2_TABLE_100
1161 , p5_a22 JTF_VARCHAR2_TABLE_300
1162 , p5_a23 JTF_VARCHAR2_TABLE_100
1163 , p5_a24 JTF_VARCHAR2_TABLE_200
1164 , p5_a25 JTF_DATE_TABLE
1165 , p5_a26 JTF_DATE_TABLE
1166 , p5_a27 JTF_NUMBER_TABLE
1167 , p5_a28 JTF_DATE_TABLE
1168 , p5_a29 JTF_DATE_TABLE
1169 , p5_a30 JTF_VARCHAR2_TABLE_100
1170 , p5_a31 JTF_VARCHAR2_TABLE_2000
1171 , p5_a32 JTF_VARCHAR2_TABLE_100
1172 , p5_a33 JTF_VARCHAR2_TABLE_100
1173 , p5_a34 JTF_VARCHAR2_TABLE_100
1174 , p5_a35 JTF_VARCHAR2_TABLE_100
1175 , p5_a36 JTF_NUMBER_TABLE
1176 , p5_a37 JTF_NUMBER_TABLE
1177 , p5_a38 JTF_DATE_TABLE
1178 , p5_a39 JTF_DATE_TABLE
1179 , p5_a40 JTF_DATE_TABLE
1180 , p5_a41 JTF_DATE_TABLE
1181 , p5_a42 JTF_DATE_TABLE
1182 , p5_a43 JTF_VARCHAR2_TABLE_100
1183 , p5_a44 JTF_DATE_TABLE
1184 , p5_a45 JTF_DATE_TABLE
1185 , p5_a46 JTF_NUMBER_TABLE
1186 , p5_a47 JTF_VARCHAR2_TABLE_100
1187 , p5_a48 JTF_VARCHAR2_TABLE_100
1188 , p5_a49 JTF_NUMBER_TABLE
1189 , p5_a50 JTF_NUMBER_TABLE
1190 , p5_a51 JTF_NUMBER_TABLE
1191 , p5_a52 JTF_VARCHAR2_TABLE_100
1192 , p5_a53 JTF_VARCHAR2_TABLE_100
1193 , p5_a54 JTF_NUMBER_TABLE
1194 , p5_a55 JTF_VARCHAR2_TABLE_100
1195 , p5_a56 JTF_VARCHAR2_TABLE_500
1196 , p5_a57 JTF_VARCHAR2_TABLE_500
1197 , p5_a58 JTF_VARCHAR2_TABLE_500
1198 , p5_a59 JTF_VARCHAR2_TABLE_500
1199 , p5_a60 JTF_VARCHAR2_TABLE_500
1200 , p5_a61 JTF_VARCHAR2_TABLE_500
1201 , p5_a62 JTF_VARCHAR2_TABLE_500
1202 , p5_a63 JTF_VARCHAR2_TABLE_500
1203 , p5_a64 JTF_VARCHAR2_TABLE_500
1204 , p5_a65 JTF_VARCHAR2_TABLE_500
1205 , p5_a66 JTF_VARCHAR2_TABLE_500
1206 , p5_a67 JTF_VARCHAR2_TABLE_500
1207 , p5_a68 JTF_VARCHAR2_TABLE_500
1208 , p5_a69 JTF_VARCHAR2_TABLE_500
1209 , p5_a70 JTF_VARCHAR2_TABLE_500
1210 , p5_a71 JTF_NUMBER_TABLE
1211 , p5_a72 JTF_DATE_TABLE
1212 , p5_a73 JTF_NUMBER_TABLE
1213 , p5_a74 JTF_DATE_TABLE
1214 , p5_a75 JTF_NUMBER_TABLE
1215 )
1216 as
1217 ddp_chrv_tbl okc_chr_pvt.chrv_tbl_type;
1218 ddindx binary_integer; indx binary_integer;
1219 begin
1220 null;
1221 end;
1222
1223 procedure create_ancestry(p_api_version NUMBER
1224 , p_init_msg_list VARCHAR2
1225 , x_return_status out nocopy VARCHAR2
1226 , x_msg_count out nocopy NUMBER
1227 , x_msg_data out nocopy VARCHAR2
1228 , p5_a0 NUMBER := 0-1962.0724
1229 , p5_a1 NUMBER := 0-1962.0724
1230 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1231 , p5_a3 NUMBER := 0-1962.0724
1232 , p5_a4 NUMBER := 0-1962.0724
1233 , p5_a5 NUMBER := 0-1962.0724
1234 , p5_a6 NUMBER := 0-1962.0724
1235 , p5_a7 NUMBER := 0-1962.0724
1236 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1237 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1238 , p5_a10 NUMBER := 0-1962.0724
1239 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1240 , p5_a12 NUMBER := 0-1962.0724
1241 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1242 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1243 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1244 , p5_a16 NUMBER := 0-1962.0724
1245 , p5_a17 NUMBER := 0-1962.0724
1246 , p5_a18 NUMBER := 0-1962.0724
1247 , p5_a19 NUMBER := 0-1962.0724
1248 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1249 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1250 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1251 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1252 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1253 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1254 , p5_a26 DATE := fnd_api.g_miss_date
1255 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1256 , p5_a28 DATE := fnd_api.g_miss_date
1257 , p5_a29 DATE := fnd_api.g_miss_date
1258 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1259 , p5_a31 NUMBER := 0-1962.0724
1260 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1261 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1262 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1263 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1264 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1265 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1266 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1267 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1268 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1269 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1270 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1271 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1272 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1273 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1274 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1275 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1276 , p5_a48 NUMBER := 0-1962.0724
1277 , p5_a49 DATE := fnd_api.g_miss_date
1278 , p5_a50 NUMBER := 0-1962.0724
1279 , p5_a51 DATE := fnd_api.g_miss_date
1280 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1281 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1282 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
1283 , p5_a55 NUMBER := 0-1962.0724
1284 )
1285 as
1286 ddp_clev_rec okc_cle_pvt.clev_rec_type;
1287 ddindx binary_integer; indx binary_integer;
1288 begin
1289 null;
1290 end;
1291
1292 procedure create_contract_line(p_api_version NUMBER
1293 , p_init_msg_list VARCHAR2
1294 , x_return_status out nocopy VARCHAR2
1295 , x_msg_count out nocopy NUMBER
1296 , x_msg_data out nocopy VARCHAR2
1297 , p5_a0 NUMBER
1298 , p5_a1 NUMBER
1299 , p5_a2 VARCHAR2
1300 , p5_a3 NUMBER
1301 , p5_a4 NUMBER
1302 , p5_a5 NUMBER
1303 , p5_a6 NUMBER
1304 , p5_a7 NUMBER
1305 , p5_a8 VARCHAR2
1306 , p5_a9 VARCHAR2
1307 , p5_a10 NUMBER
1308 , p5_a11 VARCHAR2
1309 , p5_a12 NUMBER
1310 , p5_a13 VARCHAR2
1311 , p5_a14 VARCHAR2
1312 , p5_a15 VARCHAR2
1313 , p5_a16 NUMBER
1314 , p5_a17 NUMBER
1315 , p5_a18 NUMBER
1316 , p5_a19 NUMBER
1317 , p5_a20 VARCHAR2
1318 , p5_a21 VARCHAR2
1319 , p5_a22 VARCHAR2
1320 , p5_a23 VARCHAR2
1321 , p5_a24 VARCHAR2
1322 , p5_a25 VARCHAR2
1323 , p5_a26 DATE
1324 , p5_a27 VARCHAR2
1325 , p5_a28 DATE
1326 , p5_a29 DATE
1327 , p5_a30 VARCHAR2
1328 , p5_a31 NUMBER
1329 , p5_a32 VARCHAR2
1330 , p5_a33 VARCHAR2
1331 , p5_a34 VARCHAR2
1332 , p5_a35 VARCHAR2
1333 , p5_a36 VARCHAR2
1334 , p5_a37 VARCHAR2
1335 , p5_a38 VARCHAR2
1336 , p5_a39 VARCHAR2
1337 , p5_a40 VARCHAR2
1338 , p5_a41 VARCHAR2
1339 , p5_a42 VARCHAR2
1340 , p5_a43 VARCHAR2
1341 , p5_a44 VARCHAR2
1342 , p5_a45 VARCHAR2
1343 , p5_a46 VARCHAR2
1344 , p5_a47 VARCHAR2
1345 , p5_a48 NUMBER
1346 , p5_a49 DATE
1347 , p5_a50 NUMBER
1348 , p5_a51 DATE
1349 , p5_a52 VARCHAR2
1350 , p5_a53 VARCHAR2
1351 , p5_a54 VARCHAR2
1352 , p5_a55 NUMBER
1353 , p6_a0 out nocopy NUMBER
1354 , p6_a1 out nocopy NUMBER
1355 , p6_a2 out nocopy VARCHAR2
1356 , p6_a3 out nocopy NUMBER
1357 , p6_a4 out nocopy NUMBER
1358 , p6_a5 out nocopy NUMBER
1359 , p6_a6 out nocopy NUMBER
1360 , p6_a7 out nocopy NUMBER
1361 , p6_a8 out nocopy VARCHAR2
1362 , p6_a9 out nocopy VARCHAR2
1363 , p6_a10 out nocopy NUMBER
1364 , p6_a11 out nocopy VARCHAR2
1365 , p6_a12 out nocopy NUMBER
1366 , p6_a13 out nocopy VARCHAR2
1367 , p6_a14 out nocopy VARCHAR2
1368 , p6_a15 out nocopy VARCHAR2
1369 , p6_a16 out nocopy NUMBER
1370 , p6_a17 out nocopy NUMBER
1371 , p6_a18 out nocopy NUMBER
1372 , p6_a19 out nocopy NUMBER
1373 , p6_a20 out nocopy VARCHAR2
1374 , p6_a21 out nocopy VARCHAR2
1375 , p6_a22 out nocopy VARCHAR2
1376 , p6_a23 out nocopy VARCHAR2
1377 , p6_a24 out nocopy VARCHAR2
1378 , p6_a25 out nocopy VARCHAR2
1379 , p6_a26 out nocopy DATE
1380 , p6_a27 out nocopy VARCHAR2
1381 , p6_a28 out nocopy DATE
1382 , p6_a29 out nocopy DATE
1383 , p6_a30 out nocopy VARCHAR2
1384 , p6_a31 out nocopy NUMBER
1385 , p6_a32 out nocopy VARCHAR2
1386 , p6_a33 out nocopy VARCHAR2
1387 , p6_a34 out nocopy VARCHAR2
1388 , p6_a35 out nocopy VARCHAR2
1389 , p6_a36 out nocopy VARCHAR2
1390 , p6_a37 out nocopy VARCHAR2
1391 , p6_a38 out nocopy VARCHAR2
1392 , p6_a39 out nocopy VARCHAR2
1393 , p6_a40 out nocopy VARCHAR2
1394 , p6_a41 out nocopy VARCHAR2
1395 , p6_a42 out nocopy VARCHAR2
1396 , p6_a43 out nocopy VARCHAR2
1397 , p6_a44 out nocopy VARCHAR2
1398 , p6_a45 out nocopy VARCHAR2
1399 , p6_a46 out nocopy VARCHAR2
1400 , p6_a47 out nocopy VARCHAR2
1401 , p6_a48 out nocopy NUMBER
1402 , p6_a49 out nocopy DATE
1403 , p6_a50 out nocopy NUMBER
1404 , p6_a51 out nocopy DATE
1405 , p6_a52 out nocopy VARCHAR2
1406 , p6_a53 out nocopy VARCHAR2
1407 , p6_a54 out nocopy VARCHAR2
1408 , p6_a55 out nocopy NUMBER
1409 )
1410 as
1411 ddp_clev_rec okc_cle_pvt.clev_rec_type;
1412 ddx_clev_rec okc_cle_pvt.clev_rec_type;
1413 ddindx binary_integer; indx binary_integer;
1414 begin
1415 null;
1416 end;
1417
1418 procedure create_contract_line(p_api_version NUMBER
1419 , p_init_msg_list VARCHAR2
1420 , x_return_status out nocopy VARCHAR2
1421 , x_msg_count out nocopy NUMBER
1422 , x_msg_data out nocopy VARCHAR2
1423 , p5_a0 JTF_NUMBER_TABLE
1424 , p5_a1 JTF_NUMBER_TABLE
1425 , p5_a2 JTF_VARCHAR2_TABLE_100
1426 , p5_a3 JTF_NUMBER_TABLE
1427 , p5_a4 JTF_NUMBER_TABLE
1428 , p5_a5 JTF_NUMBER_TABLE
1429 , p5_a6 JTF_NUMBER_TABLE
1430 , p5_a7 JTF_NUMBER_TABLE
1431 , p5_a8 JTF_VARCHAR2_TABLE_200
1432 , p5_a9 JTF_VARCHAR2_TABLE_100
1433 , p5_a10 JTF_NUMBER_TABLE
1434 , p5_a11 JTF_VARCHAR2_TABLE_100
1435 , p5_a12 JTF_NUMBER_TABLE
1436 , p5_a13 JTF_VARCHAR2_TABLE_2000
1437 , p5_a14 JTF_VARCHAR2_TABLE_2000
1438 , p5_a15 JTF_VARCHAR2_TABLE_100
1439 , p5_a16 JTF_NUMBER_TABLE
1440 , p5_a17 JTF_NUMBER_TABLE
1441 , p5_a18 JTF_NUMBER_TABLE
1442 , p5_a19 JTF_NUMBER_TABLE
1443 , p5_a20 JTF_VARCHAR2_TABLE_100
1444 , p5_a21 JTF_VARCHAR2_TABLE_100
1445 , p5_a22 JTF_VARCHAR2_TABLE_100
1446 , p5_a23 JTF_VARCHAR2_TABLE_2000
1447 , p5_a24 JTF_VARCHAR2_TABLE_100
1448 , p5_a25 JTF_VARCHAR2_TABLE_200
1449 , p5_a26 JTF_DATE_TABLE
1450 , p5_a27 JTF_VARCHAR2_TABLE_200
1451 , p5_a28 JTF_DATE_TABLE
1452 , p5_a29 JTF_DATE_TABLE
1453 , p5_a30 JTF_VARCHAR2_TABLE_100
1454 , p5_a31 JTF_NUMBER_TABLE
1455 , p5_a32 JTF_VARCHAR2_TABLE_100
1456 , p5_a33 JTF_VARCHAR2_TABLE_500
1457 , p5_a34 JTF_VARCHAR2_TABLE_500
1458 , p5_a35 JTF_VARCHAR2_TABLE_500
1459 , p5_a36 JTF_VARCHAR2_TABLE_500
1460 , p5_a37 JTF_VARCHAR2_TABLE_500
1461 , p5_a38 JTF_VARCHAR2_TABLE_500
1462 , p5_a39 JTF_VARCHAR2_TABLE_500
1463 , p5_a40 JTF_VARCHAR2_TABLE_500
1464 , p5_a41 JTF_VARCHAR2_TABLE_500
1465 , p5_a42 JTF_VARCHAR2_TABLE_500
1466 , p5_a43 JTF_VARCHAR2_TABLE_500
1467 , p5_a44 JTF_VARCHAR2_TABLE_500
1468 , p5_a45 JTF_VARCHAR2_TABLE_500
1469 , p5_a46 JTF_VARCHAR2_TABLE_500
1470 , p5_a47 JTF_VARCHAR2_TABLE_500
1471 , p5_a48 JTF_NUMBER_TABLE
1472 , p5_a49 JTF_DATE_TABLE
1473 , p5_a50 JTF_NUMBER_TABLE
1474 , p5_a51 JTF_DATE_TABLE
1475 , p5_a52 JTF_VARCHAR2_TABLE_100
1476 , p5_a53 JTF_VARCHAR2_TABLE_100
1477 , p5_a54 JTF_VARCHAR2_TABLE_100
1478 , p5_a55 JTF_NUMBER_TABLE
1479 , p6_a0 out nocopy JTF_NUMBER_TABLE
1480 , p6_a1 out nocopy JTF_NUMBER_TABLE
1481 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1482 , p6_a3 out nocopy JTF_NUMBER_TABLE
1483 , p6_a4 out nocopy JTF_NUMBER_TABLE
1484 , p6_a5 out nocopy JTF_NUMBER_TABLE
1485 , p6_a6 out nocopy JTF_NUMBER_TABLE
1486 , p6_a7 out nocopy JTF_NUMBER_TABLE
1487 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
1488 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1489 , p6_a10 out nocopy JTF_NUMBER_TABLE
1490 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1491 , p6_a12 out nocopy JTF_NUMBER_TABLE
1492 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_2000
1493 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
1494 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1495 , p6_a16 out nocopy JTF_NUMBER_TABLE
1496 , p6_a17 out nocopy JTF_NUMBER_TABLE
1497 , p6_a18 out nocopy JTF_NUMBER_TABLE
1498 , p6_a19 out nocopy JTF_NUMBER_TABLE
1499 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1500 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1501 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
1502 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_2000
1503 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
1504 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_200
1505 , p6_a26 out nocopy JTF_DATE_TABLE
1506 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_200
1507 , p6_a28 out nocopy JTF_DATE_TABLE
1508 , p6_a29 out nocopy JTF_DATE_TABLE
1509 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1510 , p6_a31 out nocopy JTF_NUMBER_TABLE
1511 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_100
1512 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1513 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
1514 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
1515 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
1516 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
1517 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
1518 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
1519 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
1520 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
1521 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
1522 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
1523 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
1524 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
1525 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
1526 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
1527 , p6_a48 out nocopy JTF_NUMBER_TABLE
1528 , p6_a49 out nocopy JTF_DATE_TABLE
1529 , p6_a50 out nocopy JTF_NUMBER_TABLE
1530 , p6_a51 out nocopy JTF_DATE_TABLE
1531 , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100
1532 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
1533 , p6_a54 out nocopy JTF_VARCHAR2_TABLE_100
1534 , p6_a55 out nocopy JTF_NUMBER_TABLE
1535 )
1536 as
1537 ddp_clev_tbl okc_cle_pvt.clev_tbl_type;
1538 ddx_clev_tbl okc_cle_pvt.clev_tbl_type;
1539 ddindx binary_integer; indx binary_integer;
1540 begin
1541 null;
1542 end;
1543
1544 procedure update_contract_line(p_api_version NUMBER
1545 , p_init_msg_list VARCHAR2
1546 , x_return_status out nocopy VARCHAR2
1547 , x_msg_count out nocopy NUMBER
1548 , x_msg_data out nocopy VARCHAR2
1549 , p_restricted_update VARCHAR2
1550 , p6_a0 NUMBER
1551 , p6_a1 NUMBER
1552 , p6_a2 VARCHAR2
1553 , p6_a3 NUMBER
1554 , p6_a4 NUMBER
1555 , p6_a5 NUMBER
1556 , p6_a6 NUMBER
1557 , p6_a7 NUMBER
1558 , p6_a8 VARCHAR2
1559 , p6_a9 VARCHAR2
1560 , p6_a10 NUMBER
1561 , p6_a11 VARCHAR2
1562 , p6_a12 NUMBER
1563 , p6_a13 VARCHAR2
1564 , p6_a14 VARCHAR2
1565 , p6_a15 VARCHAR2
1566 , p6_a16 NUMBER
1567 , p6_a17 NUMBER
1568 , p6_a18 NUMBER
1569 , p6_a19 NUMBER
1570 , p6_a20 VARCHAR2
1571 , p6_a21 VARCHAR2
1572 , p6_a22 VARCHAR2
1573 , p6_a23 VARCHAR2
1574 , p6_a24 VARCHAR2
1575 , p6_a25 VARCHAR2
1576 , p6_a26 DATE
1577 , p6_a27 VARCHAR2
1578 , p6_a28 DATE
1579 , p6_a29 DATE
1580 , p6_a30 VARCHAR2
1581 , p6_a31 NUMBER
1582 , p6_a32 VARCHAR2
1583 , p6_a33 VARCHAR2
1584 , p6_a34 VARCHAR2
1585 , p6_a35 VARCHAR2
1586 , p6_a36 VARCHAR2
1587 , p6_a37 VARCHAR2
1588 , p6_a38 VARCHAR2
1589 , p6_a39 VARCHAR2
1590 , p6_a40 VARCHAR2
1591 , p6_a41 VARCHAR2
1592 , p6_a42 VARCHAR2
1593 , p6_a43 VARCHAR2
1594 , p6_a44 VARCHAR2
1595 , p6_a45 VARCHAR2
1596 , p6_a46 VARCHAR2
1597 , p6_a47 VARCHAR2
1598 , p6_a48 NUMBER
1599 , p6_a49 DATE
1600 , p6_a50 NUMBER
1601 , p6_a51 DATE
1602 , p6_a52 VARCHAR2
1603 , p6_a53 VARCHAR2
1604 , p6_a54 VARCHAR2
1605 , p6_a55 NUMBER
1606 , p7_a0 out nocopy NUMBER
1607 , p7_a1 out nocopy NUMBER
1608 , p7_a2 out nocopy VARCHAR2
1609 , p7_a3 out nocopy NUMBER
1610 , p7_a4 out nocopy NUMBER
1611 , p7_a5 out nocopy NUMBER
1612 , p7_a6 out nocopy NUMBER
1613 , p7_a7 out nocopy NUMBER
1614 , p7_a8 out nocopy VARCHAR2
1615 , p7_a9 out nocopy VARCHAR2
1616 , p7_a10 out nocopy NUMBER
1617 , p7_a11 out nocopy VARCHAR2
1618 , p7_a12 out nocopy NUMBER
1619 , p7_a13 out nocopy VARCHAR2
1620 , p7_a14 out nocopy VARCHAR2
1621 , p7_a15 out nocopy VARCHAR2
1622 , p7_a16 out nocopy NUMBER
1623 , p7_a17 out nocopy NUMBER
1624 , p7_a18 out nocopy NUMBER
1625 , p7_a19 out nocopy NUMBER
1626 , p7_a20 out nocopy VARCHAR2
1627 , p7_a21 out nocopy VARCHAR2
1628 , p7_a22 out nocopy VARCHAR2
1629 , p7_a23 out nocopy VARCHAR2
1630 , p7_a24 out nocopy VARCHAR2
1631 , p7_a25 out nocopy VARCHAR2
1632 , p7_a26 out nocopy DATE
1633 , p7_a27 out nocopy VARCHAR2
1634 , p7_a28 out nocopy DATE
1635 , p7_a29 out nocopy DATE
1636 , p7_a30 out nocopy VARCHAR2
1637 , p7_a31 out nocopy NUMBER
1638 , p7_a32 out nocopy VARCHAR2
1639 , p7_a33 out nocopy VARCHAR2
1640 , p7_a34 out nocopy VARCHAR2
1641 , p7_a35 out nocopy VARCHAR2
1642 , p7_a36 out nocopy VARCHAR2
1643 , p7_a37 out nocopy VARCHAR2
1644 , p7_a38 out nocopy VARCHAR2
1645 , p7_a39 out nocopy VARCHAR2
1646 , p7_a40 out nocopy VARCHAR2
1647 , p7_a41 out nocopy VARCHAR2
1648 , p7_a42 out nocopy VARCHAR2
1649 , p7_a43 out nocopy VARCHAR2
1650 , p7_a44 out nocopy VARCHAR2
1651 , p7_a45 out nocopy VARCHAR2
1652 , p7_a46 out nocopy VARCHAR2
1653 , p7_a47 out nocopy VARCHAR2
1654 , p7_a48 out nocopy NUMBER
1655 , p7_a49 out nocopy DATE
1656 , p7_a50 out nocopy NUMBER
1657 , p7_a51 out nocopy DATE
1658 , p7_a52 out nocopy VARCHAR2
1659 , p7_a53 out nocopy VARCHAR2
1660 , p7_a54 out nocopy VARCHAR2
1661 , p7_a55 out nocopy NUMBER
1662 )
1663 as
1664 ddp_clev_rec okc_cle_pvt.clev_rec_type;
1665 ddx_clev_rec okc_cle_pvt.clev_rec_type;
1666 ddindx binary_integer; indx binary_integer;
1667 begin
1668 null;
1669 end;
1670
1671 procedure update_contract_line(p_api_version NUMBER
1672 , p_init_msg_list VARCHAR2
1673 , x_return_status out nocopy VARCHAR2
1674 , x_msg_count out nocopy NUMBER
1675 , x_msg_data out nocopy VARCHAR2
1676 , p_restricted_update VARCHAR2
1677 , p6_a0 JTF_NUMBER_TABLE
1678 , p6_a1 JTF_NUMBER_TABLE
1679 , p6_a2 JTF_VARCHAR2_TABLE_100
1680 , p6_a3 JTF_NUMBER_TABLE
1681 , p6_a4 JTF_NUMBER_TABLE
1682 , p6_a5 JTF_NUMBER_TABLE
1683 , p6_a6 JTF_NUMBER_TABLE
1684 , p6_a7 JTF_NUMBER_TABLE
1685 , p6_a8 JTF_VARCHAR2_TABLE_200
1686 , p6_a9 JTF_VARCHAR2_TABLE_100
1687 , p6_a10 JTF_NUMBER_TABLE
1688 , p6_a11 JTF_VARCHAR2_TABLE_100
1689 , p6_a12 JTF_NUMBER_TABLE
1690 , p6_a13 JTF_VARCHAR2_TABLE_2000
1691 , p6_a14 JTF_VARCHAR2_TABLE_2000
1692 , p6_a15 JTF_VARCHAR2_TABLE_100
1693 , p6_a16 JTF_NUMBER_TABLE
1694 , p6_a17 JTF_NUMBER_TABLE
1695 , p6_a18 JTF_NUMBER_TABLE
1696 , p6_a19 JTF_NUMBER_TABLE
1697 , p6_a20 JTF_VARCHAR2_TABLE_100
1698 , p6_a21 JTF_VARCHAR2_TABLE_100
1699 , p6_a22 JTF_VARCHAR2_TABLE_100
1700 , p6_a23 JTF_VARCHAR2_TABLE_2000
1701 , p6_a24 JTF_VARCHAR2_TABLE_100
1702 , p6_a25 JTF_VARCHAR2_TABLE_200
1703 , p6_a26 JTF_DATE_TABLE
1704 , p6_a27 JTF_VARCHAR2_TABLE_200
1705 , p6_a28 JTF_DATE_TABLE
1706 , p6_a29 JTF_DATE_TABLE
1707 , p6_a30 JTF_VARCHAR2_TABLE_100
1708 , p6_a31 JTF_NUMBER_TABLE
1709 , p6_a32 JTF_VARCHAR2_TABLE_100
1710 , p6_a33 JTF_VARCHAR2_TABLE_500
1711 , p6_a34 JTF_VARCHAR2_TABLE_500
1712 , p6_a35 JTF_VARCHAR2_TABLE_500
1713 , p6_a36 JTF_VARCHAR2_TABLE_500
1714 , p6_a37 JTF_VARCHAR2_TABLE_500
1715 , p6_a38 JTF_VARCHAR2_TABLE_500
1716 , p6_a39 JTF_VARCHAR2_TABLE_500
1717 , p6_a40 JTF_VARCHAR2_TABLE_500
1718 , p6_a41 JTF_VARCHAR2_TABLE_500
1719 , p6_a42 JTF_VARCHAR2_TABLE_500
1720 , p6_a43 JTF_VARCHAR2_TABLE_500
1721 , p6_a44 JTF_VARCHAR2_TABLE_500
1722 , p6_a45 JTF_VARCHAR2_TABLE_500
1723 , p6_a46 JTF_VARCHAR2_TABLE_500
1724 , p6_a47 JTF_VARCHAR2_TABLE_500
1725 , p6_a48 JTF_NUMBER_TABLE
1726 , p6_a49 JTF_DATE_TABLE
1727 , p6_a50 JTF_NUMBER_TABLE
1728 , p6_a51 JTF_DATE_TABLE
1729 , p6_a52 JTF_VARCHAR2_TABLE_100
1730 , p6_a53 JTF_VARCHAR2_TABLE_100
1731 , p6_a54 JTF_VARCHAR2_TABLE_100
1732 , p6_a55 JTF_NUMBER_TABLE
1733 , p7_a0 out nocopy JTF_NUMBER_TABLE
1734 , p7_a1 out nocopy JTF_NUMBER_TABLE
1735 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
1736 , p7_a3 out nocopy JTF_NUMBER_TABLE
1737 , p7_a4 out nocopy JTF_NUMBER_TABLE
1738 , p7_a5 out nocopy JTF_NUMBER_TABLE
1739 , p7_a6 out nocopy JTF_NUMBER_TABLE
1740 , p7_a7 out nocopy JTF_NUMBER_TABLE
1741 , p7_a8 out nocopy JTF_VARCHAR2_TABLE_200
1742 , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
1743 , p7_a10 out nocopy JTF_NUMBER_TABLE
1744 , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
1745 , p7_a12 out nocopy JTF_NUMBER_TABLE
1746 , p7_a13 out nocopy JTF_VARCHAR2_TABLE_2000
1747 , p7_a14 out nocopy JTF_VARCHAR2_TABLE_2000
1748 , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
1749 , p7_a16 out nocopy JTF_NUMBER_TABLE
1750 , p7_a17 out nocopy JTF_NUMBER_TABLE
1751 , p7_a18 out nocopy JTF_NUMBER_TABLE
1752 , p7_a19 out nocopy JTF_NUMBER_TABLE
1753 , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
1754 , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
1755 , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
1756 , p7_a23 out nocopy JTF_VARCHAR2_TABLE_2000
1757 , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
1758 , p7_a25 out nocopy JTF_VARCHAR2_TABLE_200
1759 , p7_a26 out nocopy JTF_DATE_TABLE
1760 , p7_a27 out nocopy JTF_VARCHAR2_TABLE_200
1761 , p7_a28 out nocopy JTF_DATE_TABLE
1762 , p7_a29 out nocopy JTF_DATE_TABLE
1763 , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
1764 , p7_a31 out nocopy JTF_NUMBER_TABLE
1765 , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
1766 , p7_a33 out nocopy JTF_VARCHAR2_TABLE_500
1767 , p7_a34 out nocopy JTF_VARCHAR2_TABLE_500
1768 , p7_a35 out nocopy JTF_VARCHAR2_TABLE_500
1769 , p7_a36 out nocopy JTF_VARCHAR2_TABLE_500
1770 , p7_a37 out nocopy JTF_VARCHAR2_TABLE_500
1771 , p7_a38 out nocopy JTF_VARCHAR2_TABLE_500
1772 , p7_a39 out nocopy JTF_VARCHAR2_TABLE_500
1773 , p7_a40 out nocopy JTF_VARCHAR2_TABLE_500
1774 , p7_a41 out nocopy JTF_VARCHAR2_TABLE_500
1775 , p7_a42 out nocopy JTF_VARCHAR2_TABLE_500
1776 , p7_a43 out nocopy JTF_VARCHAR2_TABLE_500
1777 , p7_a44 out nocopy JTF_VARCHAR2_TABLE_500
1778 , p7_a45 out nocopy JTF_VARCHAR2_TABLE_500
1779 , p7_a46 out nocopy JTF_VARCHAR2_TABLE_500
1780 , p7_a47 out nocopy JTF_VARCHAR2_TABLE_500
1781 , p7_a48 out nocopy JTF_NUMBER_TABLE
1782 , p7_a49 out nocopy JTF_DATE_TABLE
1783 , p7_a50 out nocopy JTF_NUMBER_TABLE
1784 , p7_a51 out nocopy JTF_DATE_TABLE
1785 , p7_a52 out nocopy JTF_VARCHAR2_TABLE_100
1786 , p7_a53 out nocopy JTF_VARCHAR2_TABLE_100
1787 , p7_a54 out nocopy JTF_VARCHAR2_TABLE_100
1788 , p7_a55 out nocopy JTF_NUMBER_TABLE
1789 )
1790 as
1791 ddp_clev_tbl okc_cle_pvt.clev_tbl_type;
1792 ddx_clev_tbl okc_cle_pvt.clev_tbl_type;
1793 ddindx binary_integer; indx binary_integer;
1794 begin
1795 null;
1796 end;
1797
1798 procedure delete_contract_line(p_api_version NUMBER
1799 , p_init_msg_list VARCHAR2
1800 , x_return_status out nocopy VARCHAR2
1801 , x_msg_count out nocopy NUMBER
1802 , x_msg_data out nocopy VARCHAR2
1803 , p5_a0 JTF_NUMBER_TABLE
1804 , p5_a1 JTF_NUMBER_TABLE
1805 , p5_a2 JTF_VARCHAR2_TABLE_100
1806 , p5_a3 JTF_NUMBER_TABLE
1807 , p5_a4 JTF_NUMBER_TABLE
1808 , p5_a5 JTF_NUMBER_TABLE
1809 , p5_a6 JTF_NUMBER_TABLE
1810 , p5_a7 JTF_NUMBER_TABLE
1811 , p5_a8 JTF_VARCHAR2_TABLE_200
1812 , p5_a9 JTF_VARCHAR2_TABLE_100
1813 , p5_a10 JTF_NUMBER_TABLE
1814 , p5_a11 JTF_VARCHAR2_TABLE_100
1815 , p5_a12 JTF_NUMBER_TABLE
1816 , p5_a13 JTF_VARCHAR2_TABLE_2000
1817 , p5_a14 JTF_VARCHAR2_TABLE_2000
1818 , p5_a15 JTF_VARCHAR2_TABLE_100
1819 , p5_a16 JTF_NUMBER_TABLE
1820 , p5_a17 JTF_NUMBER_TABLE
1821 , p5_a18 JTF_NUMBER_TABLE
1822 , p5_a19 JTF_NUMBER_TABLE
1823 , p5_a20 JTF_VARCHAR2_TABLE_100
1824 , p5_a21 JTF_VARCHAR2_TABLE_100
1825 , p5_a22 JTF_VARCHAR2_TABLE_100
1826 , p5_a23 JTF_VARCHAR2_TABLE_2000
1827 , p5_a24 JTF_VARCHAR2_TABLE_100
1828 , p5_a25 JTF_VARCHAR2_TABLE_200
1829 , p5_a26 JTF_DATE_TABLE
1830 , p5_a27 JTF_VARCHAR2_TABLE_200
1831 , p5_a28 JTF_DATE_TABLE
1832 , p5_a29 JTF_DATE_TABLE
1833 , p5_a30 JTF_VARCHAR2_TABLE_100
1834 , p5_a31 JTF_NUMBER_TABLE
1835 , p5_a32 JTF_VARCHAR2_TABLE_100
1836 , p5_a33 JTF_VARCHAR2_TABLE_500
1837 , p5_a34 JTF_VARCHAR2_TABLE_500
1838 , p5_a35 JTF_VARCHAR2_TABLE_500
1839 , p5_a36 JTF_VARCHAR2_TABLE_500
1840 , p5_a37 JTF_VARCHAR2_TABLE_500
1841 , p5_a38 JTF_VARCHAR2_TABLE_500
1842 , p5_a39 JTF_VARCHAR2_TABLE_500
1843 , p5_a40 JTF_VARCHAR2_TABLE_500
1844 , p5_a41 JTF_VARCHAR2_TABLE_500
1845 , p5_a42 JTF_VARCHAR2_TABLE_500
1846 , p5_a43 JTF_VARCHAR2_TABLE_500
1847 , p5_a44 JTF_VARCHAR2_TABLE_500
1848 , p5_a45 JTF_VARCHAR2_TABLE_500
1849 , p5_a46 JTF_VARCHAR2_TABLE_500
1850 , p5_a47 JTF_VARCHAR2_TABLE_500
1851 , p5_a48 JTF_NUMBER_TABLE
1852 , p5_a49 JTF_DATE_TABLE
1853 , p5_a50 JTF_NUMBER_TABLE
1854 , p5_a51 JTF_DATE_TABLE
1855 , p5_a52 JTF_VARCHAR2_TABLE_100
1856 , p5_a53 JTF_VARCHAR2_TABLE_100
1857 , p5_a54 JTF_VARCHAR2_TABLE_100
1858 , p5_a55 JTF_NUMBER_TABLE
1859 )
1860 as
1861 ddp_clev_tbl okc_cle_pvt.clev_tbl_type;
1862 ddindx binary_integer; indx binary_integer;
1863 begin
1864 null;
1865 end;
1866
1867 procedure delete_contract_line(p_api_version NUMBER
1868 , p_init_msg_list VARCHAR2
1869 , x_return_status out nocopy VARCHAR2
1870 , x_msg_count out nocopy NUMBER
1871 , x_msg_data out nocopy VARCHAR2
1872 , p5_a0 NUMBER := 0-1962.0724
1873 , p5_a1 NUMBER := 0-1962.0724
1874 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1875 , p5_a3 NUMBER := 0-1962.0724
1876 , p5_a4 NUMBER := 0-1962.0724
1877 , p5_a5 NUMBER := 0-1962.0724
1878 , p5_a6 NUMBER := 0-1962.0724
1879 , p5_a7 NUMBER := 0-1962.0724
1880 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1881 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1882 , p5_a10 NUMBER := 0-1962.0724
1883 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1884 , p5_a12 NUMBER := 0-1962.0724
1885 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1886 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1887 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1888 , p5_a16 NUMBER := 0-1962.0724
1889 , p5_a17 NUMBER := 0-1962.0724
1890 , p5_a18 NUMBER := 0-1962.0724
1891 , p5_a19 NUMBER := 0-1962.0724
1892 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1893 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1894 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1895 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1896 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1897 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1898 , p5_a26 DATE := fnd_api.g_miss_date
1899 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1900 , p5_a28 DATE := fnd_api.g_miss_date
1901 , p5_a29 DATE := fnd_api.g_miss_date
1902 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1903 , p5_a31 NUMBER := 0-1962.0724
1904 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1905 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1906 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1907 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1908 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1909 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1910 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1911 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1912 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1913 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1914 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1915 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1916 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1917 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1918 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1919 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1920 , p5_a48 NUMBER := 0-1962.0724
1921 , p5_a49 DATE := fnd_api.g_miss_date
1922 , p5_a50 NUMBER := 0-1962.0724
1923 , p5_a51 DATE := fnd_api.g_miss_date
1924 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1925 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1926 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
1927 , p5_a55 NUMBER := 0-1962.0724
1928 )
1929 as
1930 ddp_clev_rec okc_cle_pvt.clev_rec_type;
1931 ddindx binary_integer; indx binary_integer;
1932 begin
1933 null;
1934 end;
1935
1936 procedure lock_contract_line(p_api_version NUMBER
1937 , p_init_msg_list VARCHAR2
1938 , x_return_status out nocopy VARCHAR2
1939 , x_msg_count out nocopy NUMBER
1940 , x_msg_data out nocopy VARCHAR2
1941 , p5_a0 NUMBER := 0-1962.0724
1942 , p5_a1 NUMBER := 0-1962.0724
1943 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1944 , p5_a3 NUMBER := 0-1962.0724
1945 , p5_a4 NUMBER := 0-1962.0724
1946 , p5_a5 NUMBER := 0-1962.0724
1947 , p5_a6 NUMBER := 0-1962.0724
1948 , p5_a7 NUMBER := 0-1962.0724
1949 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1950 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1951 , p5_a10 NUMBER := 0-1962.0724
1952 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1953 , p5_a12 NUMBER := 0-1962.0724
1954 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1955 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1956 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1957 , p5_a16 NUMBER := 0-1962.0724
1958 , p5_a17 NUMBER := 0-1962.0724
1959 , p5_a18 NUMBER := 0-1962.0724
1960 , p5_a19 NUMBER := 0-1962.0724
1961 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1962 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1963 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1964 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1965 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1966 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1967 , p5_a26 DATE := fnd_api.g_miss_date
1968 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1969 , p5_a28 DATE := fnd_api.g_miss_date
1970 , p5_a29 DATE := fnd_api.g_miss_date
1971 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1972 , p5_a31 NUMBER := 0-1962.0724
1973 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1974 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1975 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1976 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1977 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1978 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1979 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1980 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1981 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1982 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1983 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1984 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1985 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1986 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1987 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1988 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1989 , p5_a48 NUMBER := 0-1962.0724
1990 , p5_a49 DATE := fnd_api.g_miss_date
1991 , p5_a50 NUMBER := 0-1962.0724
1992 , p5_a51 DATE := fnd_api.g_miss_date
1993 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1994 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1995 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
1996 , p5_a55 NUMBER := 0-1962.0724
1997 )
1998 as
1999 ddp_clev_rec okc_cle_pvt.clev_rec_type;
2000 ddindx binary_integer; indx binary_integer;
2001 begin
2002 null;
2003 end;
2004
2005 procedure lock_contract_line(p_api_version NUMBER
2006 , p_init_msg_list VARCHAR2
2007 , x_return_status out nocopy VARCHAR2
2008 , x_msg_count out nocopy NUMBER
2009 , x_msg_data out nocopy VARCHAR2
2010 , p5_a0 JTF_NUMBER_TABLE
2011 , p5_a1 JTF_NUMBER_TABLE
2012 , p5_a2 JTF_VARCHAR2_TABLE_100
2013 , p5_a3 JTF_NUMBER_TABLE
2014 , p5_a4 JTF_NUMBER_TABLE
2015 , p5_a5 JTF_NUMBER_TABLE
2016 , p5_a6 JTF_NUMBER_TABLE
2017 , p5_a7 JTF_NUMBER_TABLE
2018 , p5_a8 JTF_VARCHAR2_TABLE_200
2019 , p5_a9 JTF_VARCHAR2_TABLE_100
2020 , p5_a10 JTF_NUMBER_TABLE
2021 , p5_a11 JTF_VARCHAR2_TABLE_100
2022 , p5_a12 JTF_NUMBER_TABLE
2023 , p5_a13 JTF_VARCHAR2_TABLE_2000
2024 , p5_a14 JTF_VARCHAR2_TABLE_2000
2025 , p5_a15 JTF_VARCHAR2_TABLE_100
2026 , p5_a16 JTF_NUMBER_TABLE
2027 , p5_a17 JTF_NUMBER_TABLE
2028 , p5_a18 JTF_NUMBER_TABLE
2029 , p5_a19 JTF_NUMBER_TABLE
2030 , p5_a20 JTF_VARCHAR2_TABLE_100
2031 , p5_a21 JTF_VARCHAR2_TABLE_100
2032 , p5_a22 JTF_VARCHAR2_TABLE_100
2033 , p5_a23 JTF_VARCHAR2_TABLE_2000
2034 , p5_a24 JTF_VARCHAR2_TABLE_100
2035 , p5_a25 JTF_VARCHAR2_TABLE_200
2036 , p5_a26 JTF_DATE_TABLE
2037 , p5_a27 JTF_VARCHAR2_TABLE_200
2038 , p5_a28 JTF_DATE_TABLE
2039 , p5_a29 JTF_DATE_TABLE
2040 , p5_a30 JTF_VARCHAR2_TABLE_100
2041 , p5_a31 JTF_NUMBER_TABLE
2042 , p5_a32 JTF_VARCHAR2_TABLE_100
2043 , p5_a33 JTF_VARCHAR2_TABLE_500
2044 , p5_a34 JTF_VARCHAR2_TABLE_500
2045 , p5_a35 JTF_VARCHAR2_TABLE_500
2046 , p5_a36 JTF_VARCHAR2_TABLE_500
2047 , p5_a37 JTF_VARCHAR2_TABLE_500
2048 , p5_a38 JTF_VARCHAR2_TABLE_500
2049 , p5_a39 JTF_VARCHAR2_TABLE_500
2050 , p5_a40 JTF_VARCHAR2_TABLE_500
2051 , p5_a41 JTF_VARCHAR2_TABLE_500
2052 , p5_a42 JTF_VARCHAR2_TABLE_500
2053 , p5_a43 JTF_VARCHAR2_TABLE_500
2054 , p5_a44 JTF_VARCHAR2_TABLE_500
2055 , p5_a45 JTF_VARCHAR2_TABLE_500
2056 , p5_a46 JTF_VARCHAR2_TABLE_500
2057 , p5_a47 JTF_VARCHAR2_TABLE_500
2058 , p5_a48 JTF_NUMBER_TABLE
2059 , p5_a49 JTF_DATE_TABLE
2060 , p5_a50 JTF_NUMBER_TABLE
2061 , p5_a51 JTF_DATE_TABLE
2062 , p5_a52 JTF_VARCHAR2_TABLE_100
2063 , p5_a53 JTF_VARCHAR2_TABLE_100
2064 , p5_a54 JTF_VARCHAR2_TABLE_100
2065 , p5_a55 JTF_NUMBER_TABLE
2066 )
2067 as
2068 ddp_clev_tbl okc_cle_pvt.clev_tbl_type;
2069 ddindx binary_integer; indx binary_integer;
2070 begin
2071 null;
2072 end;
2073
2074 procedure validate_contract_line(p_api_version NUMBER
2075 , p_init_msg_list VARCHAR2
2076 , x_return_status out nocopy VARCHAR2
2077 , x_msg_count out nocopy NUMBER
2078 , x_msg_data out nocopy VARCHAR2
2079 , p5_a0 NUMBER := 0-1962.0724
2080 , p5_a1 NUMBER := 0-1962.0724
2081 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2082 , p5_a3 NUMBER := 0-1962.0724
2083 , p5_a4 NUMBER := 0-1962.0724
2084 , p5_a5 NUMBER := 0-1962.0724
2085 , p5_a6 NUMBER := 0-1962.0724
2086 , p5_a7 NUMBER := 0-1962.0724
2087 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2088 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2089 , p5_a10 NUMBER := 0-1962.0724
2090 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2091 , p5_a12 NUMBER := 0-1962.0724
2092 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2093 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2094 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2095 , p5_a16 NUMBER := 0-1962.0724
2096 , p5_a17 NUMBER := 0-1962.0724
2097 , p5_a18 NUMBER := 0-1962.0724
2098 , p5_a19 NUMBER := 0-1962.0724
2099 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2100 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2101 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2102 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2103 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
2104 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
2105 , p5_a26 DATE := fnd_api.g_miss_date
2106 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
2107 , p5_a28 DATE := fnd_api.g_miss_date
2108 , p5_a29 DATE := fnd_api.g_miss_date
2109 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2110 , p5_a31 NUMBER := 0-1962.0724
2111 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2112 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
2113 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
2114 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
2115 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
2116 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2117 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2118 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2119 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
2120 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
2121 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2122 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
2123 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
2124 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
2125 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
2126 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
2127 , p5_a48 NUMBER := 0-1962.0724
2128 , p5_a49 DATE := fnd_api.g_miss_date
2129 , p5_a50 NUMBER := 0-1962.0724
2130 , p5_a51 DATE := fnd_api.g_miss_date
2131 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
2132 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
2133 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
2134 , p5_a55 NUMBER := 0-1962.0724
2135 )
2136 as
2137 ddp_clev_rec okc_cle_pvt.clev_rec_type;
2138 ddindx binary_integer; indx binary_integer;
2139 begin
2140 null;
2141 end;
2142
2143 procedure validate_contract_line(p_api_version NUMBER
2144 , p_init_msg_list VARCHAR2
2145 , x_return_status out nocopy VARCHAR2
2146 , x_msg_count out nocopy NUMBER
2147 , x_msg_data out nocopy VARCHAR2
2148 , p5_a0 JTF_NUMBER_TABLE
2149 , p5_a1 JTF_NUMBER_TABLE
2150 , p5_a2 JTF_VARCHAR2_TABLE_100
2151 , p5_a3 JTF_NUMBER_TABLE
2152 , p5_a4 JTF_NUMBER_TABLE
2153 , p5_a5 JTF_NUMBER_TABLE
2154 , p5_a6 JTF_NUMBER_TABLE
2155 , p5_a7 JTF_NUMBER_TABLE
2156 , p5_a8 JTF_VARCHAR2_TABLE_200
2157 , p5_a9 JTF_VARCHAR2_TABLE_100
2158 , p5_a10 JTF_NUMBER_TABLE
2159 , p5_a11 JTF_VARCHAR2_TABLE_100
2160 , p5_a12 JTF_NUMBER_TABLE
2161 , p5_a13 JTF_VARCHAR2_TABLE_2000
2162 , p5_a14 JTF_VARCHAR2_TABLE_2000
2163 , p5_a15 JTF_VARCHAR2_TABLE_100
2164 , p5_a16 JTF_NUMBER_TABLE
2165 , p5_a17 JTF_NUMBER_TABLE
2166 , p5_a18 JTF_NUMBER_TABLE
2167 , p5_a19 JTF_NUMBER_TABLE
2168 , p5_a20 JTF_VARCHAR2_TABLE_100
2169 , p5_a21 JTF_VARCHAR2_TABLE_100
2170 , p5_a22 JTF_VARCHAR2_TABLE_100
2171 , p5_a23 JTF_VARCHAR2_TABLE_2000
2172 , p5_a24 JTF_VARCHAR2_TABLE_100
2173 , p5_a25 JTF_VARCHAR2_TABLE_200
2174 , p5_a26 JTF_DATE_TABLE
2175 , p5_a27 JTF_VARCHAR2_TABLE_200
2176 , p5_a28 JTF_DATE_TABLE
2177 , p5_a29 JTF_DATE_TABLE
2178 , p5_a30 JTF_VARCHAR2_TABLE_100
2179 , p5_a31 JTF_NUMBER_TABLE
2180 , p5_a32 JTF_VARCHAR2_TABLE_100
2181 , p5_a33 JTF_VARCHAR2_TABLE_500
2182 , p5_a34 JTF_VARCHAR2_TABLE_500
2183 , p5_a35 JTF_VARCHAR2_TABLE_500
2184 , p5_a36 JTF_VARCHAR2_TABLE_500
2185 , p5_a37 JTF_VARCHAR2_TABLE_500
2186 , p5_a38 JTF_VARCHAR2_TABLE_500
2187 , p5_a39 JTF_VARCHAR2_TABLE_500
2188 , p5_a40 JTF_VARCHAR2_TABLE_500
2189 , p5_a41 JTF_VARCHAR2_TABLE_500
2190 , p5_a42 JTF_VARCHAR2_TABLE_500
2191 , p5_a43 JTF_VARCHAR2_TABLE_500
2192 , p5_a44 JTF_VARCHAR2_TABLE_500
2193 , p5_a45 JTF_VARCHAR2_TABLE_500
2194 , p5_a46 JTF_VARCHAR2_TABLE_500
2195 , p5_a47 JTF_VARCHAR2_TABLE_500
2196 , p5_a48 JTF_NUMBER_TABLE
2197 , p5_a49 JTF_DATE_TABLE
2198 , p5_a50 JTF_NUMBER_TABLE
2199 , p5_a51 JTF_DATE_TABLE
2200 , p5_a52 JTF_VARCHAR2_TABLE_100
2201 , p5_a53 JTF_VARCHAR2_TABLE_100
2202 , p5_a54 JTF_VARCHAR2_TABLE_100
2203 , p5_a55 JTF_NUMBER_TABLE
2204 )
2205 as
2206 ddp_clev_tbl okc_cle_pvt.clev_tbl_type;
2207 ddindx binary_integer; indx binary_integer;
2208 begin
2209 null;
2210 end;
2211
2212 procedure create_governance(p_api_version NUMBER
2213 , p_init_msg_list VARCHAR2
2214 , x_return_status out nocopy VARCHAR2
2215 , x_msg_count out nocopy NUMBER
2216 , x_msg_data out nocopy VARCHAR2
2217 , p5_a0 NUMBER
2218 , p5_a1 NUMBER
2219 , p5_a2 NUMBER
2220 , p5_a3 NUMBER
2221 , p5_a4 NUMBER
2222 , p5_a5 NUMBER
2223 , p5_a6 NUMBER
2224 , p5_a7 NUMBER
2225 , p5_a8 VARCHAR2
2226 , p5_a9 NUMBER
2227 , p5_a10 DATE
2228 , p5_a11 NUMBER
2229 , p5_a12 DATE
2230 , p5_a13 NUMBER
2231 , p6_a0 out nocopy NUMBER
2232 , p6_a1 out nocopy NUMBER
2233 , p6_a2 out nocopy NUMBER
2234 , p6_a3 out nocopy NUMBER
2235 , p6_a4 out nocopy NUMBER
2236 , p6_a5 out nocopy NUMBER
2237 , p6_a6 out nocopy NUMBER
2238 , p6_a7 out nocopy NUMBER
2239 , p6_a8 out nocopy VARCHAR2
2240 , p6_a9 out nocopy NUMBER
2241 , p6_a10 out nocopy DATE
2242 , p6_a11 out nocopy NUMBER
2243 , p6_a12 out nocopy DATE
2244 , p6_a13 out nocopy NUMBER
2245 )
2246 as
2247 ddp_gvev_rec okc_gve_pvt.gvev_rec_type;
2248 ddx_gvev_rec okc_gve_pvt.gvev_rec_type;
2249 ddindx binary_integer; indx binary_integer;
2250 begin
2251 null;
2252 end;
2253
2254 procedure create_governance(p_api_version NUMBER
2255 , p_init_msg_list VARCHAR2
2256 , x_return_status out nocopy VARCHAR2
2257 , x_msg_count out nocopy NUMBER
2258 , x_msg_data out nocopy VARCHAR2
2259 , p5_a0 JTF_NUMBER_TABLE
2260 , p5_a1 JTF_NUMBER_TABLE
2261 , p5_a2 JTF_NUMBER_TABLE
2262 , p5_a3 JTF_NUMBER_TABLE
2263 , p5_a4 JTF_NUMBER_TABLE
2264 , p5_a5 JTF_NUMBER_TABLE
2265 , p5_a6 JTF_NUMBER_TABLE
2266 , p5_a7 JTF_NUMBER_TABLE
2267 , p5_a8 JTF_VARCHAR2_TABLE_100
2268 , p5_a9 JTF_NUMBER_TABLE
2269 , p5_a10 JTF_DATE_TABLE
2270 , p5_a11 JTF_NUMBER_TABLE
2271 , p5_a12 JTF_DATE_TABLE
2272 , p5_a13 JTF_NUMBER_TABLE
2273 , p6_a0 out nocopy JTF_NUMBER_TABLE
2274 , p6_a1 out nocopy JTF_NUMBER_TABLE
2275 , p6_a2 out nocopy JTF_NUMBER_TABLE
2276 , p6_a3 out nocopy JTF_NUMBER_TABLE
2277 , p6_a4 out nocopy JTF_NUMBER_TABLE
2278 , p6_a5 out nocopy JTF_NUMBER_TABLE
2279 , p6_a6 out nocopy JTF_NUMBER_TABLE
2280 , p6_a7 out nocopy JTF_NUMBER_TABLE
2281 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2282 , p6_a9 out nocopy JTF_NUMBER_TABLE
2283 , p6_a10 out nocopy JTF_DATE_TABLE
2284 , p6_a11 out nocopy JTF_NUMBER_TABLE
2285 , p6_a12 out nocopy JTF_DATE_TABLE
2286 , p6_a13 out nocopy JTF_NUMBER_TABLE
2287 )
2288 as
2289 ddp_gvev_tbl okc_gve_pvt.gvev_tbl_type;
2290 ddx_gvev_tbl okc_gve_pvt.gvev_tbl_type;
2291 ddindx binary_integer; indx binary_integer;
2292 begin
2293 null;
2294 end;
2295
2296 procedure update_governance(p_api_version NUMBER
2297 , p_init_msg_list VARCHAR2
2298 , x_return_status out nocopy VARCHAR2
2299 , x_msg_count out nocopy NUMBER
2300 , x_msg_data out nocopy VARCHAR2
2301 , p5_a0 NUMBER
2302 , p5_a1 NUMBER
2303 , p5_a2 NUMBER
2304 , p5_a3 NUMBER
2305 , p5_a4 NUMBER
2306 , p5_a5 NUMBER
2307 , p5_a6 NUMBER
2308 , p5_a7 NUMBER
2309 , p5_a8 VARCHAR2
2310 , p5_a9 NUMBER
2311 , p5_a10 DATE
2312 , p5_a11 NUMBER
2313 , p5_a12 DATE
2314 , p5_a13 NUMBER
2315 , p6_a0 out nocopy NUMBER
2316 , p6_a1 out nocopy NUMBER
2317 , p6_a2 out nocopy NUMBER
2318 , p6_a3 out nocopy NUMBER
2319 , p6_a4 out nocopy NUMBER
2320 , p6_a5 out nocopy NUMBER
2321 , p6_a6 out nocopy NUMBER
2322 , p6_a7 out nocopy NUMBER
2323 , p6_a8 out nocopy VARCHAR2
2324 , p6_a9 out nocopy NUMBER
2325 , p6_a10 out nocopy DATE
2326 , p6_a11 out nocopy NUMBER
2327 , p6_a12 out nocopy DATE
2328 , p6_a13 out nocopy NUMBER
2329 )
2330 as
2331 ddp_gvev_rec okc_gve_pvt.gvev_rec_type;
2332 ddx_gvev_rec okc_gve_pvt.gvev_rec_type;
2333 ddindx binary_integer; indx binary_integer;
2334 begin
2335 null;
2336 end;
2337
2338 procedure update_governance(p_api_version NUMBER
2339 , p_init_msg_list VARCHAR2
2340 , x_return_status out nocopy VARCHAR2
2341 , x_msg_count out nocopy NUMBER
2342 , x_msg_data out nocopy VARCHAR2
2343 , p5_a0 JTF_NUMBER_TABLE
2344 , p5_a1 JTF_NUMBER_TABLE
2345 , p5_a2 JTF_NUMBER_TABLE
2346 , p5_a3 JTF_NUMBER_TABLE
2347 , p5_a4 JTF_NUMBER_TABLE
2348 , p5_a5 JTF_NUMBER_TABLE
2349 , p5_a6 JTF_NUMBER_TABLE
2350 , p5_a7 JTF_NUMBER_TABLE
2351 , p5_a8 JTF_VARCHAR2_TABLE_100
2352 , p5_a9 JTF_NUMBER_TABLE
2353 , p5_a10 JTF_DATE_TABLE
2354 , p5_a11 JTF_NUMBER_TABLE
2355 , p5_a12 JTF_DATE_TABLE
2356 , p5_a13 JTF_NUMBER_TABLE
2357 , p6_a0 out nocopy JTF_NUMBER_TABLE
2358 , p6_a1 out nocopy JTF_NUMBER_TABLE
2359 , p6_a2 out nocopy JTF_NUMBER_TABLE
2360 , p6_a3 out nocopy JTF_NUMBER_TABLE
2361 , p6_a4 out nocopy JTF_NUMBER_TABLE
2362 , p6_a5 out nocopy JTF_NUMBER_TABLE
2363 , p6_a6 out nocopy JTF_NUMBER_TABLE
2364 , p6_a7 out nocopy JTF_NUMBER_TABLE
2365 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2366 , p6_a9 out nocopy JTF_NUMBER_TABLE
2367 , p6_a10 out nocopy JTF_DATE_TABLE
2368 , p6_a11 out nocopy JTF_NUMBER_TABLE
2369 , p6_a12 out nocopy JTF_DATE_TABLE
2370 , p6_a13 out nocopy JTF_NUMBER_TABLE
2371 )
2372 as
2373 ddp_gvev_tbl okc_gve_pvt.gvev_tbl_type;
2374 ddx_gvev_tbl okc_gve_pvt.gvev_tbl_type;
2375 ddindx binary_integer; indx binary_integer;
2376 begin
2377 null;
2378 end;
2379
2380 procedure delete_governance(p_api_version NUMBER
2381 , p_init_msg_list VARCHAR2
2382 , x_return_status out nocopy VARCHAR2
2383 , x_msg_count out nocopy NUMBER
2384 , x_msg_data out nocopy VARCHAR2
2385 , p5_a0 NUMBER := 0-1962.0724
2386 , p5_a1 NUMBER := 0-1962.0724
2387 , p5_a2 NUMBER := 0-1962.0724
2388 , p5_a3 NUMBER := 0-1962.0724
2389 , p5_a4 NUMBER := 0-1962.0724
2390 , p5_a5 NUMBER := 0-1962.0724
2391 , p5_a6 NUMBER := 0-1962.0724
2392 , p5_a7 NUMBER := 0-1962.0724
2393 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2394 , p5_a9 NUMBER := 0-1962.0724
2395 , p5_a10 DATE := fnd_api.g_miss_date
2396 , p5_a11 NUMBER := 0-1962.0724
2397 , p5_a12 DATE := fnd_api.g_miss_date
2398 , p5_a13 NUMBER := 0-1962.0724
2399 )
2400 as
2401 ddp_gvev_rec okc_gve_pvt.gvev_rec_type;
2402 ddindx binary_integer; indx binary_integer;
2403 begin
2404 null;
2405 end;
2406
2407 procedure delete_governance(p_api_version NUMBER
2408 , p_init_msg_list VARCHAR2
2409 , x_return_status out nocopy VARCHAR2
2410 , x_msg_count out nocopy NUMBER
2411 , x_msg_data out nocopy VARCHAR2
2412 , p5_a0 JTF_NUMBER_TABLE
2413 , p5_a1 JTF_NUMBER_TABLE
2414 , p5_a2 JTF_NUMBER_TABLE
2415 , p5_a3 JTF_NUMBER_TABLE
2416 , p5_a4 JTF_NUMBER_TABLE
2417 , p5_a5 JTF_NUMBER_TABLE
2418 , p5_a6 JTF_NUMBER_TABLE
2419 , p5_a7 JTF_NUMBER_TABLE
2420 , p5_a8 JTF_VARCHAR2_TABLE_100
2421 , p5_a9 JTF_NUMBER_TABLE
2422 , p5_a10 JTF_DATE_TABLE
2423 , p5_a11 JTF_NUMBER_TABLE
2424 , p5_a12 JTF_DATE_TABLE
2425 , p5_a13 JTF_NUMBER_TABLE
2426 )
2427 as
2428 ddp_gvev_tbl okc_gve_pvt.gvev_tbl_type;
2429 ddindx binary_integer; indx binary_integer;
2430 begin
2431 null;
2432 end;
2433
2434 procedure lock_governance(p_api_version NUMBER
2435 , p_init_msg_list VARCHAR2
2436 , x_return_status out nocopy VARCHAR2
2437 , x_msg_count out nocopy NUMBER
2438 , x_msg_data out nocopy VARCHAR2
2439 , p5_a0 NUMBER := 0-1962.0724
2440 , p5_a1 NUMBER := 0-1962.0724
2441 , p5_a2 NUMBER := 0-1962.0724
2442 , p5_a3 NUMBER := 0-1962.0724
2443 , p5_a4 NUMBER := 0-1962.0724
2444 , p5_a5 NUMBER := 0-1962.0724
2445 , p5_a6 NUMBER := 0-1962.0724
2446 , p5_a7 NUMBER := 0-1962.0724
2447 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2448 , p5_a9 NUMBER := 0-1962.0724
2449 , p5_a10 DATE := fnd_api.g_miss_date
2450 , p5_a11 NUMBER := 0-1962.0724
2451 , p5_a12 DATE := fnd_api.g_miss_date
2452 , p5_a13 NUMBER := 0-1962.0724
2453 )
2454 as
2455 ddp_gvev_rec okc_gve_pvt.gvev_rec_type;
2456 ddindx binary_integer; indx binary_integer;
2457 begin
2458 null;
2459 end;
2460
2461 procedure lock_governance(p_api_version NUMBER
2462 , p_init_msg_list VARCHAR2
2463 , x_return_status out nocopy VARCHAR2
2464 , x_msg_count out nocopy NUMBER
2465 , x_msg_data out nocopy VARCHAR2
2466 , p5_a0 JTF_NUMBER_TABLE
2467 , p5_a1 JTF_NUMBER_TABLE
2468 , p5_a2 JTF_NUMBER_TABLE
2469 , p5_a3 JTF_NUMBER_TABLE
2470 , p5_a4 JTF_NUMBER_TABLE
2471 , p5_a5 JTF_NUMBER_TABLE
2472 , p5_a6 JTF_NUMBER_TABLE
2473 , p5_a7 JTF_NUMBER_TABLE
2474 , p5_a8 JTF_VARCHAR2_TABLE_100
2475 , p5_a9 JTF_NUMBER_TABLE
2476 , p5_a10 JTF_DATE_TABLE
2477 , p5_a11 JTF_NUMBER_TABLE
2478 , p5_a12 JTF_DATE_TABLE
2479 , p5_a13 JTF_NUMBER_TABLE
2480 )
2481 as
2482 ddp_gvev_tbl okc_gve_pvt.gvev_tbl_type;
2483 ddindx binary_integer; indx binary_integer;
2484 begin
2485 null;
2486 end;
2487
2488 procedure validate_governance(p_api_version NUMBER
2489 , p_init_msg_list VARCHAR2
2490 , x_return_status out nocopy VARCHAR2
2491 , x_msg_count out nocopy NUMBER
2492 , x_msg_data out nocopy VARCHAR2
2493 , p5_a0 NUMBER := 0-1962.0724
2494 , p5_a1 NUMBER := 0-1962.0724
2495 , p5_a2 NUMBER := 0-1962.0724
2496 , p5_a3 NUMBER := 0-1962.0724
2497 , p5_a4 NUMBER := 0-1962.0724
2498 , p5_a5 NUMBER := 0-1962.0724
2499 , p5_a6 NUMBER := 0-1962.0724
2500 , p5_a7 NUMBER := 0-1962.0724
2501 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2502 , p5_a9 NUMBER := 0-1962.0724
2503 , p5_a10 DATE := fnd_api.g_miss_date
2504 , p5_a11 NUMBER := 0-1962.0724
2505 , p5_a12 DATE := fnd_api.g_miss_date
2506 , p5_a13 NUMBER := 0-1962.0724
2507 )
2508 as
2509 ddp_gvev_rec okc_gve_pvt.gvev_rec_type;
2510 ddindx binary_integer; indx binary_integer;
2511 begin
2512 null;
2513 end;
2514
2515 procedure validate_governance(p_api_version NUMBER
2516 , p_init_msg_list VARCHAR2
2517 , x_return_status out nocopy VARCHAR2
2518 , x_msg_count out nocopy NUMBER
2519 , x_msg_data out nocopy VARCHAR2
2520 , p5_a0 JTF_NUMBER_TABLE
2521 , p5_a1 JTF_NUMBER_TABLE
2522 , p5_a2 JTF_NUMBER_TABLE
2523 , p5_a3 JTF_NUMBER_TABLE
2524 , p5_a4 JTF_NUMBER_TABLE
2525 , p5_a5 JTF_NUMBER_TABLE
2526 , p5_a6 JTF_NUMBER_TABLE
2527 , p5_a7 JTF_NUMBER_TABLE
2528 , p5_a8 JTF_VARCHAR2_TABLE_100
2529 , p5_a9 JTF_NUMBER_TABLE
2530 , p5_a10 JTF_DATE_TABLE
2531 , p5_a11 JTF_NUMBER_TABLE
2532 , p5_a12 JTF_DATE_TABLE
2533 , p5_a13 JTF_NUMBER_TABLE
2534 )
2535 as
2536 ddp_gvev_tbl okc_gve_pvt.gvev_tbl_type;
2537 ddindx binary_integer; indx binary_integer;
2538 begin
2539 null;
2540 end;
2541
2542 procedure create_contract_process(p_api_version NUMBER
2543 , p_init_msg_list VARCHAR2
2544 , x_return_status out nocopy VARCHAR2
2545 , x_msg_count out nocopy NUMBER
2546 , x_msg_data out nocopy VARCHAR2
2547 , p5_a0 NUMBER
2548 , p5_a1 NUMBER
2549 , p5_a2 NUMBER
2550 , p5_a3 NUMBER
2551 , p5_a4 NUMBER
2552 , p5_a5 NUMBER
2553 , p5_a6 VARCHAR2
2554 , p5_a7 VARCHAR2
2555 , p5_a8 VARCHAR2
2556 , p5_a9 VARCHAR2
2557 , p5_a10 VARCHAR2
2558 , p5_a11 VARCHAR2
2559 , p5_a12 VARCHAR2
2560 , p5_a13 VARCHAR2
2561 , p5_a14 VARCHAR2
2562 , p5_a15 VARCHAR2
2563 , p5_a16 VARCHAR2
2564 , p5_a17 VARCHAR2
2565 , p5_a18 VARCHAR2
2566 , p5_a19 VARCHAR2
2567 , p5_a20 VARCHAR2
2568 , p5_a21 VARCHAR2
2569 , p5_a22 VARCHAR2
2570 , p5_a23 VARCHAR2
2571 , p5_a24 NUMBER
2572 , p5_a25 DATE
2573 , p5_a26 NUMBER
2574 , p5_a27 DATE
2575 , p5_a28 NUMBER
2576 , p6_a0 out nocopy NUMBER
2577 , p6_a1 out nocopy NUMBER
2578 , p6_a2 out nocopy NUMBER
2579 , p6_a3 out nocopy NUMBER
2580 , p6_a4 out nocopy NUMBER
2581 , p6_a5 out nocopy NUMBER
2582 , p6_a6 out nocopy VARCHAR2
2583 , p6_a7 out nocopy VARCHAR2
2584 , p6_a8 out nocopy VARCHAR2
2585 , p6_a9 out nocopy VARCHAR2
2586 , p6_a10 out nocopy VARCHAR2
2587 , p6_a11 out nocopy VARCHAR2
2588 , p6_a12 out nocopy VARCHAR2
2589 , p6_a13 out nocopy VARCHAR2
2590 , p6_a14 out nocopy VARCHAR2
2591 , p6_a15 out nocopy VARCHAR2
2592 , p6_a16 out nocopy VARCHAR2
2593 , p6_a17 out nocopy VARCHAR2
2594 , p6_a18 out nocopy VARCHAR2
2595 , p6_a19 out nocopy VARCHAR2
2596 , p6_a20 out nocopy VARCHAR2
2597 , p6_a21 out nocopy VARCHAR2
2598 , p6_a22 out nocopy VARCHAR2
2599 , p6_a23 out nocopy VARCHAR2
2600 , p6_a24 out nocopy NUMBER
2601 , p6_a25 out nocopy DATE
2602 , p6_a26 out nocopy NUMBER
2603 , p6_a27 out nocopy DATE
2604 , p6_a28 out nocopy NUMBER
2605 )
2606 as
2607 ddp_cpsv_rec okc_cps_pvt.cpsv_rec_type;
2608 ddx_cpsv_rec okc_cps_pvt.cpsv_rec_type;
2609 ddindx binary_integer; indx binary_integer;
2610 begin
2611 null;
2612 end;
2613
2614 procedure create_contract_process(p_api_version NUMBER
2615 , p_init_msg_list VARCHAR2
2616 , x_return_status out nocopy VARCHAR2
2617 , x_msg_count out nocopy NUMBER
2618 , x_msg_data out nocopy VARCHAR2
2619 , p5_a0 JTF_NUMBER_TABLE
2620 , p5_a1 JTF_NUMBER_TABLE
2621 , p5_a2 JTF_NUMBER_TABLE
2622 , p5_a3 JTF_NUMBER_TABLE
2623 , p5_a4 JTF_NUMBER_TABLE
2624 , p5_a5 JTF_NUMBER_TABLE
2625 , p5_a6 JTF_VARCHAR2_TABLE_300
2626 , p5_a7 JTF_VARCHAR2_TABLE_100
2627 , p5_a8 JTF_VARCHAR2_TABLE_100
2628 , p5_a9 JTF_VARCHAR2_TABLE_500
2629 , p5_a10 JTF_VARCHAR2_TABLE_500
2630 , p5_a11 JTF_VARCHAR2_TABLE_500
2631 , p5_a12 JTF_VARCHAR2_TABLE_500
2632 , p5_a13 JTF_VARCHAR2_TABLE_500
2633 , p5_a14 JTF_VARCHAR2_TABLE_500
2634 , p5_a15 JTF_VARCHAR2_TABLE_500
2635 , p5_a16 JTF_VARCHAR2_TABLE_500
2636 , p5_a17 JTF_VARCHAR2_TABLE_500
2637 , p5_a18 JTF_VARCHAR2_TABLE_500
2638 , p5_a19 JTF_VARCHAR2_TABLE_500
2639 , p5_a20 JTF_VARCHAR2_TABLE_500
2640 , p5_a21 JTF_VARCHAR2_TABLE_500
2641 , p5_a22 JTF_VARCHAR2_TABLE_500
2642 , p5_a23 JTF_VARCHAR2_TABLE_500
2643 , p5_a24 JTF_NUMBER_TABLE
2644 , p5_a25 JTF_DATE_TABLE
2645 , p5_a26 JTF_NUMBER_TABLE
2646 , p5_a27 JTF_DATE_TABLE
2647 , p5_a28 JTF_NUMBER_TABLE
2648 , p6_a0 out nocopy JTF_NUMBER_TABLE
2649 , p6_a1 out nocopy JTF_NUMBER_TABLE
2650 , p6_a2 out nocopy JTF_NUMBER_TABLE
2651 , p6_a3 out nocopy JTF_NUMBER_TABLE
2652 , p6_a4 out nocopy JTF_NUMBER_TABLE
2653 , p6_a5 out nocopy JTF_NUMBER_TABLE
2654 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
2655 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2656 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2657 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
2658 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
2659 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
2660 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
2661 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
2662 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
2663 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
2664 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
2665 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
2666 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
2667 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
2668 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
2669 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
2670 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
2671 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
2672 , p6_a24 out nocopy JTF_NUMBER_TABLE
2673 , p6_a25 out nocopy JTF_DATE_TABLE
2674 , p6_a26 out nocopy JTF_NUMBER_TABLE
2675 , p6_a27 out nocopy JTF_DATE_TABLE
2676 , p6_a28 out nocopy JTF_NUMBER_TABLE
2677 )
2678 as
2679 ddp_cpsv_tbl okc_cps_pvt.cpsv_tbl_type;
2680 ddx_cpsv_tbl okc_cps_pvt.cpsv_tbl_type;
2681 ddindx binary_integer; indx binary_integer;
2682 begin
2683 null;
2684 end;
2685
2686 procedure update_contract_process(p_api_version NUMBER
2687 , p_init_msg_list VARCHAR2
2688 , x_return_status out nocopy VARCHAR2
2689 , x_msg_count out nocopy NUMBER
2690 , x_msg_data out nocopy VARCHAR2
2691 , p5_a0 NUMBER
2692 , p5_a1 NUMBER
2693 , p5_a2 NUMBER
2694 , p5_a3 NUMBER
2695 , p5_a4 NUMBER
2696 , p5_a5 NUMBER
2697 , p5_a6 VARCHAR2
2698 , p5_a7 VARCHAR2
2699 , p5_a8 VARCHAR2
2700 , p5_a9 VARCHAR2
2701 , p5_a10 VARCHAR2
2702 , p5_a11 VARCHAR2
2703 , p5_a12 VARCHAR2
2704 , p5_a13 VARCHAR2
2705 , p5_a14 VARCHAR2
2706 , p5_a15 VARCHAR2
2707 , p5_a16 VARCHAR2
2708 , p5_a17 VARCHAR2
2709 , p5_a18 VARCHAR2
2710 , p5_a19 VARCHAR2
2711 , p5_a20 VARCHAR2
2712 , p5_a21 VARCHAR2
2713 , p5_a22 VARCHAR2
2714 , p5_a23 VARCHAR2
2715 , p5_a24 NUMBER
2716 , p5_a25 DATE
2717 , p5_a26 NUMBER
2718 , p5_a27 DATE
2719 , p5_a28 NUMBER
2720 , p6_a0 out nocopy NUMBER
2721 , p6_a1 out nocopy NUMBER
2722 , p6_a2 out nocopy NUMBER
2723 , p6_a3 out nocopy NUMBER
2724 , p6_a4 out nocopy NUMBER
2725 , p6_a5 out nocopy NUMBER
2726 , p6_a6 out nocopy VARCHAR2
2727 , p6_a7 out nocopy VARCHAR2
2728 , p6_a8 out nocopy VARCHAR2
2729 , p6_a9 out nocopy VARCHAR2
2730 , p6_a10 out nocopy VARCHAR2
2731 , p6_a11 out nocopy VARCHAR2
2732 , p6_a12 out nocopy VARCHAR2
2733 , p6_a13 out nocopy VARCHAR2
2734 , p6_a14 out nocopy VARCHAR2
2735 , p6_a15 out nocopy VARCHAR2
2736 , p6_a16 out nocopy VARCHAR2
2737 , p6_a17 out nocopy VARCHAR2
2738 , p6_a18 out nocopy VARCHAR2
2739 , p6_a19 out nocopy VARCHAR2
2740 , p6_a20 out nocopy VARCHAR2
2741 , p6_a21 out nocopy VARCHAR2
2742 , p6_a22 out nocopy VARCHAR2
2743 , p6_a23 out nocopy VARCHAR2
2744 , p6_a24 out nocopy NUMBER
2745 , p6_a25 out nocopy DATE
2746 , p6_a26 out nocopy NUMBER
2747 , p6_a27 out nocopy DATE
2748 , p6_a28 out nocopy NUMBER
2749 )
2750 as
2751 ddp_cpsv_rec okc_cps_pvt.cpsv_rec_type;
2752 ddx_cpsv_rec okc_cps_pvt.cpsv_rec_type;
2753 ddindx binary_integer; indx binary_integer;
2754 begin
2755 null;
2756 end;
2757
2758 procedure update_contract_process(p_api_version NUMBER
2759 , p_init_msg_list VARCHAR2
2760 , x_return_status out nocopy VARCHAR2
2761 , x_msg_count out nocopy NUMBER
2762 , x_msg_data out nocopy VARCHAR2
2763 , p5_a0 JTF_NUMBER_TABLE
2764 , p5_a1 JTF_NUMBER_TABLE
2765 , p5_a2 JTF_NUMBER_TABLE
2766 , p5_a3 JTF_NUMBER_TABLE
2767 , p5_a4 JTF_NUMBER_TABLE
2768 , p5_a5 JTF_NUMBER_TABLE
2769 , p5_a6 JTF_VARCHAR2_TABLE_300
2770 , p5_a7 JTF_VARCHAR2_TABLE_100
2771 , p5_a8 JTF_VARCHAR2_TABLE_100
2772 , p5_a9 JTF_VARCHAR2_TABLE_500
2773 , p5_a10 JTF_VARCHAR2_TABLE_500
2774 , p5_a11 JTF_VARCHAR2_TABLE_500
2775 , p5_a12 JTF_VARCHAR2_TABLE_500
2776 , p5_a13 JTF_VARCHAR2_TABLE_500
2777 , p5_a14 JTF_VARCHAR2_TABLE_500
2778 , p5_a15 JTF_VARCHAR2_TABLE_500
2779 , p5_a16 JTF_VARCHAR2_TABLE_500
2780 , p5_a17 JTF_VARCHAR2_TABLE_500
2781 , p5_a18 JTF_VARCHAR2_TABLE_500
2782 , p5_a19 JTF_VARCHAR2_TABLE_500
2783 , p5_a20 JTF_VARCHAR2_TABLE_500
2784 , p5_a21 JTF_VARCHAR2_TABLE_500
2785 , p5_a22 JTF_VARCHAR2_TABLE_500
2786 , p5_a23 JTF_VARCHAR2_TABLE_500
2787 , p5_a24 JTF_NUMBER_TABLE
2788 , p5_a25 JTF_DATE_TABLE
2789 , p5_a26 JTF_NUMBER_TABLE
2790 , p5_a27 JTF_DATE_TABLE
2791 , p5_a28 JTF_NUMBER_TABLE
2792 , p6_a0 out nocopy JTF_NUMBER_TABLE
2793 , p6_a1 out nocopy JTF_NUMBER_TABLE
2794 , p6_a2 out nocopy JTF_NUMBER_TABLE
2795 , p6_a3 out nocopy JTF_NUMBER_TABLE
2796 , p6_a4 out nocopy JTF_NUMBER_TABLE
2797 , p6_a5 out nocopy JTF_NUMBER_TABLE
2798 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
2799 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
2800 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
2801 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
2802 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
2803 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
2804 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
2805 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
2806 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
2807 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
2808 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
2809 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
2810 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
2811 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
2812 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
2813 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
2814 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
2815 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
2816 , p6_a24 out nocopy JTF_NUMBER_TABLE
2817 , p6_a25 out nocopy JTF_DATE_TABLE
2818 , p6_a26 out nocopy JTF_NUMBER_TABLE
2819 , p6_a27 out nocopy JTF_DATE_TABLE
2820 , p6_a28 out nocopy JTF_NUMBER_TABLE
2821 )
2822 as
2823 ddp_cpsv_tbl okc_cps_pvt.cpsv_tbl_type;
2824 ddx_cpsv_tbl okc_cps_pvt.cpsv_tbl_type;
2825 ddindx binary_integer; indx binary_integer;
2826 begin
2827 null;
2828 end;
2829
2830 procedure delete_contract_process(p_api_version NUMBER
2831 , p_init_msg_list VARCHAR2
2832 , x_return_status out nocopy VARCHAR2
2833 , x_msg_count out nocopy NUMBER
2834 , x_msg_data out nocopy VARCHAR2
2835 , p5_a0 NUMBER := 0-1962.0724
2836 , p5_a1 NUMBER := 0-1962.0724
2837 , p5_a2 NUMBER := 0-1962.0724
2838 , p5_a3 NUMBER := 0-1962.0724
2839 , p5_a4 NUMBER := 0-1962.0724
2840 , p5_a5 NUMBER := 0-1962.0724
2841 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2842 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2843 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2844 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2845 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2846 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2847 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2848 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2849 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2850 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2851 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2852 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2853 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2854 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2855 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2856 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2857 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2858 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2859 , p5_a24 NUMBER := 0-1962.0724
2860 , p5_a25 DATE := fnd_api.g_miss_date
2861 , p5_a26 NUMBER := 0-1962.0724
2862 , p5_a27 DATE := fnd_api.g_miss_date
2863 , p5_a28 NUMBER := 0-1962.0724
2864 )
2865 as
2866 ddp_cpsv_rec okc_cps_pvt.cpsv_rec_type;
2867 ddindx binary_integer; indx binary_integer;
2868 begin
2869 null;
2870 end;
2871
2872 procedure delete_contract_process(p_api_version NUMBER
2873 , p_init_msg_list VARCHAR2
2874 , x_return_status out nocopy VARCHAR2
2875 , x_msg_count out nocopy NUMBER
2876 , x_msg_data out nocopy VARCHAR2
2877 , p5_a0 JTF_NUMBER_TABLE
2878 , p5_a1 JTF_NUMBER_TABLE
2879 , p5_a2 JTF_NUMBER_TABLE
2880 , p5_a3 JTF_NUMBER_TABLE
2881 , p5_a4 JTF_NUMBER_TABLE
2882 , p5_a5 JTF_NUMBER_TABLE
2883 , p5_a6 JTF_VARCHAR2_TABLE_300
2884 , p5_a7 JTF_VARCHAR2_TABLE_100
2885 , p5_a8 JTF_VARCHAR2_TABLE_100
2886 , p5_a9 JTF_VARCHAR2_TABLE_500
2887 , p5_a10 JTF_VARCHAR2_TABLE_500
2888 , p5_a11 JTF_VARCHAR2_TABLE_500
2889 , p5_a12 JTF_VARCHAR2_TABLE_500
2890 , p5_a13 JTF_VARCHAR2_TABLE_500
2891 , p5_a14 JTF_VARCHAR2_TABLE_500
2892 , p5_a15 JTF_VARCHAR2_TABLE_500
2893 , p5_a16 JTF_VARCHAR2_TABLE_500
2894 , p5_a17 JTF_VARCHAR2_TABLE_500
2895 , p5_a18 JTF_VARCHAR2_TABLE_500
2896 , p5_a19 JTF_VARCHAR2_TABLE_500
2897 , p5_a20 JTF_VARCHAR2_TABLE_500
2898 , p5_a21 JTF_VARCHAR2_TABLE_500
2899 , p5_a22 JTF_VARCHAR2_TABLE_500
2900 , p5_a23 JTF_VARCHAR2_TABLE_500
2901 , p5_a24 JTF_NUMBER_TABLE
2902 , p5_a25 JTF_DATE_TABLE
2903 , p5_a26 JTF_NUMBER_TABLE
2904 , p5_a27 JTF_DATE_TABLE
2905 , p5_a28 JTF_NUMBER_TABLE
2906 )
2907 as
2908 ddp_cpsv_tbl okc_cps_pvt.cpsv_tbl_type;
2909 ddindx binary_integer; indx binary_integer;
2910 begin
2911 null;
2912 end;
2913
2914 procedure lock_contract_process(p_api_version NUMBER
2915 , p_init_msg_list VARCHAR2
2916 , x_return_status out nocopy VARCHAR2
2917 , x_msg_count out nocopy NUMBER
2918 , x_msg_data out nocopy VARCHAR2
2919 , p5_a0 NUMBER := 0-1962.0724
2920 , p5_a1 NUMBER := 0-1962.0724
2921 , p5_a2 NUMBER := 0-1962.0724
2922 , p5_a3 NUMBER := 0-1962.0724
2923 , p5_a4 NUMBER := 0-1962.0724
2924 , p5_a5 NUMBER := 0-1962.0724
2925 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2926 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2927 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2928 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
2929 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
2930 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
2931 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
2932 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2933 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2934 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2935 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
2936 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
2937 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
2938 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
2939 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2940 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2941 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
2942 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
2943 , p5_a24 NUMBER := 0-1962.0724
2944 , p5_a25 DATE := fnd_api.g_miss_date
2945 , p5_a26 NUMBER := 0-1962.0724
2946 , p5_a27 DATE := fnd_api.g_miss_date
2947 , p5_a28 NUMBER := 0-1962.0724
2948 )
2949 as
2950 ddp_cpsv_rec okc_cps_pvt.cpsv_rec_type;
2951 ddindx binary_integer; indx binary_integer;
2952 begin
2953 null;
2954 end;
2955
2956 procedure lock_contract_process(p_api_version NUMBER
2957 , p_init_msg_list VARCHAR2
2958 , x_return_status out nocopy VARCHAR2
2959 , x_msg_count out nocopy NUMBER
2960 , x_msg_data out nocopy VARCHAR2
2961 , p5_a0 JTF_NUMBER_TABLE
2962 , p5_a1 JTF_NUMBER_TABLE
2963 , p5_a2 JTF_NUMBER_TABLE
2964 , p5_a3 JTF_NUMBER_TABLE
2965 , p5_a4 JTF_NUMBER_TABLE
2966 , p5_a5 JTF_NUMBER_TABLE
2967 , p5_a6 JTF_VARCHAR2_TABLE_300
2968 , p5_a7 JTF_VARCHAR2_TABLE_100
2969 , p5_a8 JTF_VARCHAR2_TABLE_100
2970 , p5_a9 JTF_VARCHAR2_TABLE_500
2971 , p5_a10 JTF_VARCHAR2_TABLE_500
2972 , p5_a11 JTF_VARCHAR2_TABLE_500
2973 , p5_a12 JTF_VARCHAR2_TABLE_500
2974 , p5_a13 JTF_VARCHAR2_TABLE_500
2975 , p5_a14 JTF_VARCHAR2_TABLE_500
2976 , p5_a15 JTF_VARCHAR2_TABLE_500
2977 , p5_a16 JTF_VARCHAR2_TABLE_500
2978 , p5_a17 JTF_VARCHAR2_TABLE_500
2979 , p5_a18 JTF_VARCHAR2_TABLE_500
2980 , p5_a19 JTF_VARCHAR2_TABLE_500
2981 , p5_a20 JTF_VARCHAR2_TABLE_500
2982 , p5_a21 JTF_VARCHAR2_TABLE_500
2983 , p5_a22 JTF_VARCHAR2_TABLE_500
2984 , p5_a23 JTF_VARCHAR2_TABLE_500
2985 , p5_a24 JTF_NUMBER_TABLE
2986 , p5_a25 JTF_DATE_TABLE
2987 , p5_a26 JTF_NUMBER_TABLE
2988 , p5_a27 JTF_DATE_TABLE
2989 , p5_a28 JTF_NUMBER_TABLE
2990 )
2991 as
2992 ddp_cpsv_tbl okc_cps_pvt.cpsv_tbl_type;
2993 ddindx binary_integer; indx binary_integer;
2994 begin
2995 null;
2996 end;
2997
2998 procedure validate_contract_process(p_api_version NUMBER
2999 , p_init_msg_list VARCHAR2
3000 , x_return_status out nocopy VARCHAR2
3001 , x_msg_count out nocopy NUMBER
3002 , x_msg_data out nocopy VARCHAR2
3003 , p5_a0 NUMBER := 0-1962.0724
3004 , p5_a1 NUMBER := 0-1962.0724
3005 , p5_a2 NUMBER := 0-1962.0724
3006 , p5_a3 NUMBER := 0-1962.0724
3007 , p5_a4 NUMBER := 0-1962.0724
3008 , p5_a5 NUMBER := 0-1962.0724
3009 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
3010 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
3011 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
3012 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
3013 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
3014 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
3015 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
3016 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
3017 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
3018 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
3019 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
3020 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
3021 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
3022 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
3023 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
3024 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
3025 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
3026 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
3027 , p5_a24 NUMBER := 0-1962.0724
3028 , p5_a25 DATE := fnd_api.g_miss_date
3029 , p5_a26 NUMBER := 0-1962.0724
3030 , p5_a27 DATE := fnd_api.g_miss_date
3031 , p5_a28 NUMBER := 0-1962.0724
3032 )
3033 as
3034 ddp_cpsv_rec okc_cps_pvt.cpsv_rec_type;
3035 ddindx binary_integer; indx binary_integer;
3036 begin
3037 null;
3038 end;
3039
3040 procedure validate_contract_process(p_api_version NUMBER
3041 , p_init_msg_list VARCHAR2
3042 , x_return_status out nocopy VARCHAR2
3043 , x_msg_count out nocopy NUMBER
3044 , x_msg_data out nocopy VARCHAR2
3045 , p5_a0 JTF_NUMBER_TABLE
3046 , p5_a1 JTF_NUMBER_TABLE
3047 , p5_a2 JTF_NUMBER_TABLE
3048 , p5_a3 JTF_NUMBER_TABLE
3049 , p5_a4 JTF_NUMBER_TABLE
3050 , p5_a5 JTF_NUMBER_TABLE
3051 , p5_a6 JTF_VARCHAR2_TABLE_300
3052 , p5_a7 JTF_VARCHAR2_TABLE_100
3053 , p5_a8 JTF_VARCHAR2_TABLE_100
3054 , p5_a9 JTF_VARCHAR2_TABLE_500
3055 , p5_a10 JTF_VARCHAR2_TABLE_500
3056 , p5_a11 JTF_VARCHAR2_TABLE_500
3057 , p5_a12 JTF_VARCHAR2_TABLE_500
3058 , p5_a13 JTF_VARCHAR2_TABLE_500
3059 , p5_a14 JTF_VARCHAR2_TABLE_500
3060 , p5_a15 JTF_VARCHAR2_TABLE_500
3061 , p5_a16 JTF_VARCHAR2_TABLE_500
3062 , p5_a17 JTF_VARCHAR2_TABLE_500
3063 , p5_a18 JTF_VARCHAR2_TABLE_500
3064 , p5_a19 JTF_VARCHAR2_TABLE_500
3065 , p5_a20 JTF_VARCHAR2_TABLE_500
3066 , p5_a21 JTF_VARCHAR2_TABLE_500
3067 , p5_a22 JTF_VARCHAR2_TABLE_500
3068 , p5_a23 JTF_VARCHAR2_TABLE_500
3069 , p5_a24 JTF_NUMBER_TABLE
3070 , p5_a25 JTF_DATE_TABLE
3071 , p5_a26 JTF_NUMBER_TABLE
3072 , p5_a27 JTF_DATE_TABLE
3073 , p5_a28 JTF_NUMBER_TABLE
3074 )
3075 as
3076 ddp_cpsv_tbl okc_cps_pvt.cpsv_tbl_type;
3077 ddindx binary_integer; indx binary_integer;
3078 begin
3079 null;
3080 end;
3081
3082 procedure create_contract_access(p_api_version NUMBER
3083 , p_init_msg_list VARCHAR2
3084 , x_return_status out nocopy VARCHAR2
3085 , x_msg_count out nocopy NUMBER
3086 , x_msg_data out nocopy VARCHAR2
3087 , p5_a0 NUMBER
3088 , p5_a1 NUMBER
3089 , p5_a2 NUMBER
3090 , p5_a3 NUMBER
3091 , p5_a4 NUMBER
3092 , p5_a5 VARCHAR2
3093 , p5_a6 NUMBER
3094 , p5_a7 DATE
3095 , p5_a8 NUMBER
3096 , p5_a9 DATE
3097 , p5_a10 NUMBER
3098 , p6_a0 out nocopy NUMBER
3099 , p6_a1 out nocopy NUMBER
3100 , p6_a2 out nocopy NUMBER
3101 , p6_a3 out nocopy NUMBER
3102 , p6_a4 out nocopy NUMBER
3103 , p6_a5 out nocopy VARCHAR2
3104 , p6_a6 out nocopy NUMBER
3105 , p6_a7 out nocopy DATE
3106 , p6_a8 out nocopy NUMBER
3107 , p6_a9 out nocopy DATE
3108 , p6_a10 out nocopy NUMBER
3109 )
3110 as
3111 ddp_cacv_rec okc_cac_pvt.cacv_rec_type;
3112 ddx_cacv_rec okc_cac_pvt.cacv_rec_type;
3113 ddindx binary_integer; indx binary_integer;
3114 begin
3115 null;
3116 end;
3117
3118 procedure create_contract_access(p_api_version NUMBER
3119 , p_init_msg_list VARCHAR2
3120 , x_return_status out nocopy VARCHAR2
3121 , x_msg_count out nocopy NUMBER
3122 , x_msg_data out nocopy VARCHAR2
3123 , p5_a0 JTF_NUMBER_TABLE
3124 , p5_a1 JTF_NUMBER_TABLE
3125 , p5_a2 JTF_NUMBER_TABLE
3126 , p5_a3 JTF_NUMBER_TABLE
3127 , p5_a4 JTF_NUMBER_TABLE
3128 , p5_a5 JTF_VARCHAR2_TABLE_100
3129 , p5_a6 JTF_NUMBER_TABLE
3130 , p5_a7 JTF_DATE_TABLE
3131 , p5_a8 JTF_NUMBER_TABLE
3132 , p5_a9 JTF_DATE_TABLE
3133 , p5_a10 JTF_NUMBER_TABLE
3134 , p6_a0 out nocopy JTF_NUMBER_TABLE
3135 , p6_a1 out nocopy JTF_NUMBER_TABLE
3136 , p6_a2 out nocopy JTF_NUMBER_TABLE
3137 , p6_a3 out nocopy JTF_NUMBER_TABLE
3138 , p6_a4 out nocopy JTF_NUMBER_TABLE
3139 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
3140 , p6_a6 out nocopy JTF_NUMBER_TABLE
3141 , p6_a7 out nocopy JTF_DATE_TABLE
3142 , p6_a8 out nocopy JTF_NUMBER_TABLE
3143 , p6_a9 out nocopy JTF_DATE_TABLE
3144 , p6_a10 out nocopy JTF_NUMBER_TABLE
3145 )
3146 as
3147 ddp_cacv_tbl okc_cac_pvt.cacv_tbl_type;
3148 ddx_cacv_tbl okc_cac_pvt.cacv_tbl_type;
3149 ddindx binary_integer; indx binary_integer;
3150 begin
3151 null;
3152 end;
3153
3154 procedure update_contract_access(p_api_version NUMBER
3155 , p_init_msg_list VARCHAR2
3156 , x_return_status out nocopy VARCHAR2
3157 , x_msg_count out nocopy NUMBER
3158 , x_msg_data out nocopy VARCHAR2
3159 , p5_a0 NUMBER
3160 , p5_a1 NUMBER
3161 , p5_a2 NUMBER
3162 , p5_a3 NUMBER
3163 , p5_a4 NUMBER
3164 , p5_a5 VARCHAR2
3165 , p5_a6 NUMBER
3166 , p5_a7 DATE
3167 , p5_a8 NUMBER
3168 , p5_a9 DATE
3169 , p5_a10 NUMBER
3170 , p6_a0 out nocopy NUMBER
3171 , p6_a1 out nocopy NUMBER
3172 , p6_a2 out nocopy NUMBER
3173 , p6_a3 out nocopy NUMBER
3174 , p6_a4 out nocopy NUMBER
3175 , p6_a5 out nocopy VARCHAR2
3176 , p6_a6 out nocopy NUMBER
3177 , p6_a7 out nocopy DATE
3178 , p6_a8 out nocopy NUMBER
3179 , p6_a9 out nocopy DATE
3180 , p6_a10 out nocopy NUMBER
3181 )
3182 as
3183 ddp_cacv_rec okc_cac_pvt.cacv_rec_type;
3184 ddx_cacv_rec okc_cac_pvt.cacv_rec_type;
3185 ddindx binary_integer; indx binary_integer;
3186 begin
3187 null;
3188 end;
3189
3190 procedure update_contract_access(p_api_version NUMBER
3191 , p_init_msg_list VARCHAR2
3192 , x_return_status out nocopy VARCHAR2
3193 , x_msg_count out nocopy NUMBER
3194 , x_msg_data out nocopy VARCHAR2
3195 , p5_a0 JTF_NUMBER_TABLE
3196 , p5_a1 JTF_NUMBER_TABLE
3197 , p5_a2 JTF_NUMBER_TABLE
3198 , p5_a3 JTF_NUMBER_TABLE
3199 , p5_a4 JTF_NUMBER_TABLE
3200 , p5_a5 JTF_VARCHAR2_TABLE_100
3201 , p5_a6 JTF_NUMBER_TABLE
3202 , p5_a7 JTF_DATE_TABLE
3203 , p5_a8 JTF_NUMBER_TABLE
3204 , p5_a9 JTF_DATE_TABLE
3205 , p5_a10 JTF_NUMBER_TABLE
3206 , p6_a0 out nocopy JTF_NUMBER_TABLE
3207 , p6_a1 out nocopy JTF_NUMBER_TABLE
3208 , p6_a2 out nocopy JTF_NUMBER_TABLE
3209 , p6_a3 out nocopy JTF_NUMBER_TABLE
3210 , p6_a4 out nocopy JTF_NUMBER_TABLE
3211 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
3212 , p6_a6 out nocopy JTF_NUMBER_TABLE
3213 , p6_a7 out nocopy JTF_DATE_TABLE
3214 , p6_a8 out nocopy JTF_NUMBER_TABLE
3215 , p6_a9 out nocopy JTF_DATE_TABLE
3216 , p6_a10 out nocopy JTF_NUMBER_TABLE
3217 )
3218 as
3219 ddp_cacv_tbl okc_cac_pvt.cacv_tbl_type;
3220 ddx_cacv_tbl okc_cac_pvt.cacv_tbl_type;
3221 ddindx binary_integer; indx binary_integer;
3222 begin
3223 null;
3224 end;
3225
3226 procedure delete_contract_access(p_api_version NUMBER
3227 , p_init_msg_list VARCHAR2
3228 , x_return_status out nocopy VARCHAR2
3229 , x_msg_count out nocopy NUMBER
3230 , x_msg_data out nocopy VARCHAR2
3231 , p5_a0 NUMBER := 0-1962.0724
3232 , p5_a1 NUMBER := 0-1962.0724
3233 , p5_a2 NUMBER := 0-1962.0724
3234 , p5_a3 NUMBER := 0-1962.0724
3235 , p5_a4 NUMBER := 0-1962.0724
3236 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
3237 , p5_a6 NUMBER := 0-1962.0724
3238 , p5_a7 DATE := fnd_api.g_miss_date
3239 , p5_a8 NUMBER := 0-1962.0724
3240 , p5_a9 DATE := fnd_api.g_miss_date
3241 , p5_a10 NUMBER := 0-1962.0724
3242 )
3243 as
3244 ddp_cacv_rec okc_cac_pvt.cacv_rec_type;
3245 ddindx binary_integer; indx binary_integer;
3246 begin
3247 null;
3248 end;
3249
3250 procedure delete_contract_access(p_api_version NUMBER
3251 , p_init_msg_list VARCHAR2
3252 , x_return_status out nocopy VARCHAR2
3253 , x_msg_count out nocopy NUMBER
3254 , x_msg_data out nocopy VARCHAR2
3255 , p5_a0 JTF_NUMBER_TABLE
3256 , p5_a1 JTF_NUMBER_TABLE
3257 , p5_a2 JTF_NUMBER_TABLE
3258 , p5_a3 JTF_NUMBER_TABLE
3259 , p5_a4 JTF_NUMBER_TABLE
3260 , p5_a5 JTF_VARCHAR2_TABLE_100
3261 , p5_a6 JTF_NUMBER_TABLE
3262 , p5_a7 JTF_DATE_TABLE
3263 , p5_a8 JTF_NUMBER_TABLE
3264 , p5_a9 JTF_DATE_TABLE
3265 , p5_a10 JTF_NUMBER_TABLE
3266 )
3267 as
3268 ddp_cacv_tbl okc_cac_pvt.cacv_tbl_type;
3269 ddindx binary_integer; indx binary_integer;
3270 begin
3271 null;
3272 end;
3273
3274 procedure lock_contract_access(p_api_version NUMBER
3275 , p_init_msg_list VARCHAR2
3276 , x_return_status out nocopy VARCHAR2
3277 , x_msg_count out nocopy NUMBER
3278 , x_msg_data out nocopy VARCHAR2
3279 , p5_a0 NUMBER := 0-1962.0724
3280 , p5_a1 NUMBER := 0-1962.0724
3281 , p5_a2 NUMBER := 0-1962.0724
3282 , p5_a3 NUMBER := 0-1962.0724
3283 , p5_a4 NUMBER := 0-1962.0724
3284 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
3285 , p5_a6 NUMBER := 0-1962.0724
3286 , p5_a7 DATE := fnd_api.g_miss_date
3287 , p5_a8 NUMBER := 0-1962.0724
3288 , p5_a9 DATE := fnd_api.g_miss_date
3289 , p5_a10 NUMBER := 0-1962.0724
3290 )
3291 as
3292 ddp_cacv_rec okc_cac_pvt.cacv_rec_type;
3293 ddindx binary_integer; indx binary_integer;
3294 begin
3295 null;
3296 end;
3297
3298 procedure lock_contract_access(p_api_version NUMBER
3299 , p_init_msg_list VARCHAR2
3300 , x_return_status out nocopy VARCHAR2
3301 , x_msg_count out nocopy NUMBER
3302 , x_msg_data out nocopy VARCHAR2
3303 , p5_a0 JTF_NUMBER_TABLE
3304 , p5_a1 JTF_NUMBER_TABLE
3305 , p5_a2 JTF_NUMBER_TABLE
3306 , p5_a3 JTF_NUMBER_TABLE
3307 , p5_a4 JTF_NUMBER_TABLE
3308 , p5_a5 JTF_VARCHAR2_TABLE_100
3309 , p5_a6 JTF_NUMBER_TABLE
3310 , p5_a7 JTF_DATE_TABLE
3311 , p5_a8 JTF_NUMBER_TABLE
3312 , p5_a9 JTF_DATE_TABLE
3313 , p5_a10 JTF_NUMBER_TABLE
3314 )
3315 as
3316 ddp_cacv_tbl okc_cac_pvt.cacv_tbl_type;
3317 ddindx binary_integer; indx binary_integer;
3318 begin
3319 null;
3320 end;
3321
3322 procedure validate_contract_access(p_api_version NUMBER
3323 , p_init_msg_list VARCHAR2
3324 , x_return_status out nocopy VARCHAR2
3325 , x_msg_count out nocopy NUMBER
3326 , x_msg_data out nocopy VARCHAR2
3327 , p5_a0 NUMBER := 0-1962.0724
3328 , p5_a1 NUMBER := 0-1962.0724
3329 , p5_a2 NUMBER := 0-1962.0724
3330 , p5_a3 NUMBER := 0-1962.0724
3331 , p5_a4 NUMBER := 0-1962.0724
3332 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
3333 , p5_a6 NUMBER := 0-1962.0724
3334 , p5_a7 DATE := fnd_api.g_miss_date
3335 , p5_a8 NUMBER := 0-1962.0724
3336 , p5_a9 DATE := fnd_api.g_miss_date
3337 , p5_a10 NUMBER := 0-1962.0724
3338 )
3339 as
3340 ddp_cacv_rec okc_cac_pvt.cacv_rec_type;
3341 ddindx binary_integer; indx binary_integer;
3342 begin
3343 null;
3344 end;
3345
3346 procedure validate_contract_access(p_api_version NUMBER
3347 , p_init_msg_list VARCHAR2
3348 , x_return_status out nocopy VARCHAR2
3349 , x_msg_count out nocopy NUMBER
3350 , x_msg_data out nocopy VARCHAR2
3351 , p5_a0 JTF_NUMBER_TABLE
3352 , p5_a1 JTF_NUMBER_TABLE
3353 , p5_a2 JTF_NUMBER_TABLE
3354 , p5_a3 JTF_NUMBER_TABLE
3355 , p5_a4 JTF_NUMBER_TABLE
3356 , p5_a5 JTF_VARCHAR2_TABLE_100
3357 , p5_a6 JTF_NUMBER_TABLE
3358 , p5_a7 JTF_DATE_TABLE
3359 , p5_a8 JTF_NUMBER_TABLE
3360 , p5_a9 JTF_DATE_TABLE
3361 , p5_a10 JTF_NUMBER_TABLE
3362 )
3363 as
3364 ddp_cacv_tbl okc_cac_pvt.cacv_tbl_type;
3365 ddindx binary_integer; indx binary_integer;
3366 begin
3367 null;
3368 end;
3369
3370 end okc_contract_pvt_w;