[Home] [Help]
PACKAGE: APPS.OKL_LRV_PVT_W
Source
1 package okl_lrv_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLILRVS.pls 120.1 2005/09/30 11:00:39 asawanka noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy okl_lrv_pvt.okl_lrvv_tbl, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_DATE_TABLE
7 , a4 JTF_DATE_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_VARCHAR2_TABLE_100
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_NUMBER_TABLE
18 , a15 JTF_VARCHAR2_TABLE_100
19 , a16 JTF_NUMBER_TABLE
20 , a17 JTF_DATE_TABLE
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_DATE_TABLE
23 , a20 JTF_NUMBER_TABLE
24 , a21 JTF_VARCHAR2_TABLE_100
25 , a22 JTF_VARCHAR2_TABLE_500
26 , a23 JTF_VARCHAR2_TABLE_500
27 , a24 JTF_VARCHAR2_TABLE_500
28 , a25 JTF_VARCHAR2_TABLE_500
29 , a26 JTF_VARCHAR2_TABLE_500
30 , a27 JTF_VARCHAR2_TABLE_500
31 , a28 JTF_VARCHAR2_TABLE_500
32 , a29 JTF_VARCHAR2_TABLE_500
33 , a30 JTF_VARCHAR2_TABLE_500
34 , a31 JTF_VARCHAR2_TABLE_500
35 , a32 JTF_VARCHAR2_TABLE_500
36 , a33 JTF_VARCHAR2_TABLE_500
37 , a34 JTF_VARCHAR2_TABLE_500
38 , a35 JTF_VARCHAR2_TABLE_500
39 , a36 JTF_VARCHAR2_TABLE_500
40 , a37 JTF_NUMBER_TABLE
41 );
42 procedure rosetta_table_copy_out_p1(t okl_lrv_pvt.okl_lrvv_tbl, a0 out nocopy JTF_NUMBER_TABLE
43 , a1 out nocopy JTF_NUMBER_TABLE
44 , a2 out nocopy JTF_VARCHAR2_TABLE_100
45 , a3 out nocopy JTF_DATE_TABLE
46 , a4 out nocopy JTF_DATE_TABLE
47 , a5 out nocopy JTF_NUMBER_TABLE
48 , a6 out nocopy JTF_NUMBER_TABLE
49 , a7 out nocopy JTF_NUMBER_TABLE
50 , a8 out nocopy JTF_NUMBER_TABLE
51 , a9 out nocopy JTF_VARCHAR2_TABLE_100
52 , a10 out nocopy JTF_NUMBER_TABLE
53 , a11 out nocopy JTF_NUMBER_TABLE
54 , a12 out nocopy JTF_NUMBER_TABLE
55 , a13 out nocopy JTF_NUMBER_TABLE
56 , a14 out nocopy JTF_NUMBER_TABLE
57 , a15 out nocopy JTF_VARCHAR2_TABLE_100
58 , a16 out nocopy JTF_NUMBER_TABLE
59 , a17 out nocopy JTF_DATE_TABLE
60 , a18 out nocopy JTF_NUMBER_TABLE
61 , a19 out nocopy JTF_DATE_TABLE
62 , a20 out nocopy JTF_NUMBER_TABLE
63 , a21 out nocopy JTF_VARCHAR2_TABLE_100
64 , a22 out nocopy JTF_VARCHAR2_TABLE_500
65 , a23 out nocopy JTF_VARCHAR2_TABLE_500
66 , a24 out nocopy JTF_VARCHAR2_TABLE_500
67 , a25 out nocopy JTF_VARCHAR2_TABLE_500
68 , a26 out nocopy JTF_VARCHAR2_TABLE_500
69 , a27 out nocopy JTF_VARCHAR2_TABLE_500
70 , a28 out nocopy JTF_VARCHAR2_TABLE_500
71 , a29 out nocopy JTF_VARCHAR2_TABLE_500
72 , a30 out nocopy JTF_VARCHAR2_TABLE_500
73 , a31 out nocopy JTF_VARCHAR2_TABLE_500
74 , a32 out nocopy JTF_VARCHAR2_TABLE_500
75 , a33 out nocopy JTF_VARCHAR2_TABLE_500
76 , a34 out nocopy JTF_VARCHAR2_TABLE_500
77 , a35 out nocopy JTF_VARCHAR2_TABLE_500
78 , a36 out nocopy JTF_VARCHAR2_TABLE_500
79 , a37 out nocopy JTF_NUMBER_TABLE
80 );
81
82 procedure rosetta_table_copy_in_p3(t out nocopy okl_lrv_pvt.okl_lrv_tbl, a0 JTF_NUMBER_TABLE
83 , a1 JTF_NUMBER_TABLE
84 , a2 JTF_VARCHAR2_TABLE_100
85 , a3 JTF_DATE_TABLE
86 , a4 JTF_DATE_TABLE
87 , a5 JTF_NUMBER_TABLE
88 , a6 JTF_NUMBER_TABLE
89 , a7 JTF_NUMBER_TABLE
90 , a8 JTF_NUMBER_TABLE
91 , a9 JTF_VARCHAR2_TABLE_100
92 , a10 JTF_NUMBER_TABLE
93 , a11 JTF_NUMBER_TABLE
94 , a12 JTF_NUMBER_TABLE
95 , a13 JTF_NUMBER_TABLE
96 , a14 JTF_NUMBER_TABLE
97 , a15 JTF_VARCHAR2_TABLE_100
98 , a16 JTF_NUMBER_TABLE
99 , a17 JTF_DATE_TABLE
100 , a18 JTF_NUMBER_TABLE
101 , a19 JTF_DATE_TABLE
102 , a20 JTF_NUMBER_TABLE
103 , a21 JTF_VARCHAR2_TABLE_100
104 , a22 JTF_VARCHAR2_TABLE_500
105 , a23 JTF_VARCHAR2_TABLE_500
106 , a24 JTF_VARCHAR2_TABLE_500
107 , a25 JTF_VARCHAR2_TABLE_500
108 , a26 JTF_VARCHAR2_TABLE_500
109 , a27 JTF_VARCHAR2_TABLE_500
110 , a28 JTF_VARCHAR2_TABLE_500
111 , a29 JTF_VARCHAR2_TABLE_500
112 , a30 JTF_VARCHAR2_TABLE_500
113 , a31 JTF_VARCHAR2_TABLE_500
114 , a32 JTF_VARCHAR2_TABLE_500
115 , a33 JTF_VARCHAR2_TABLE_500
116 , a34 JTF_VARCHAR2_TABLE_500
117 , a35 JTF_VARCHAR2_TABLE_500
118 , a36 JTF_VARCHAR2_TABLE_500
119 , a37 JTF_NUMBER_TABLE
120 );
121 procedure rosetta_table_copy_out_p3(t okl_lrv_pvt.okl_lrv_tbl, a0 out nocopy JTF_NUMBER_TABLE
122 , a1 out nocopy JTF_NUMBER_TABLE
123 , a2 out nocopy JTF_VARCHAR2_TABLE_100
124 , a3 out nocopy JTF_DATE_TABLE
125 , a4 out nocopy JTF_DATE_TABLE
126 , a5 out nocopy JTF_NUMBER_TABLE
127 , a6 out nocopy JTF_NUMBER_TABLE
128 , a7 out nocopy JTF_NUMBER_TABLE
129 , a8 out nocopy JTF_NUMBER_TABLE
130 , a9 out nocopy JTF_VARCHAR2_TABLE_100
131 , a10 out nocopy JTF_NUMBER_TABLE
132 , a11 out nocopy JTF_NUMBER_TABLE
133 , a12 out nocopy JTF_NUMBER_TABLE
134 , a13 out nocopy JTF_NUMBER_TABLE
135 , a14 out nocopy JTF_NUMBER_TABLE
136 , a15 out nocopy JTF_VARCHAR2_TABLE_100
137 , a16 out nocopy JTF_NUMBER_TABLE
138 , a17 out nocopy JTF_DATE_TABLE
139 , a18 out nocopy JTF_NUMBER_TABLE
140 , a19 out nocopy JTF_DATE_TABLE
141 , a20 out nocopy JTF_NUMBER_TABLE
142 , a21 out nocopy JTF_VARCHAR2_TABLE_100
143 , a22 out nocopy JTF_VARCHAR2_TABLE_500
144 , a23 out nocopy JTF_VARCHAR2_TABLE_500
145 , a24 out nocopy JTF_VARCHAR2_TABLE_500
146 , a25 out nocopy JTF_VARCHAR2_TABLE_500
147 , a26 out nocopy JTF_VARCHAR2_TABLE_500
148 , a27 out nocopy JTF_VARCHAR2_TABLE_500
149 , a28 out nocopy JTF_VARCHAR2_TABLE_500
150 , a29 out nocopy JTF_VARCHAR2_TABLE_500
151 , a30 out nocopy JTF_VARCHAR2_TABLE_500
152 , a31 out nocopy JTF_VARCHAR2_TABLE_500
153 , a32 out nocopy JTF_VARCHAR2_TABLE_500
154 , a33 out nocopy JTF_VARCHAR2_TABLE_500
155 , a34 out nocopy JTF_VARCHAR2_TABLE_500
156 , a35 out nocopy JTF_VARCHAR2_TABLE_500
157 , a36 out nocopy JTF_VARCHAR2_TABLE_500
158 , a37 out nocopy JTF_NUMBER_TABLE
159 );
160
161 procedure insert_row(p_api_version NUMBER
162 , p_init_msg_list VARCHAR2
163 , x_return_status out nocopy VARCHAR2
164 , x_msg_count out nocopy NUMBER
165 , x_msg_data out nocopy VARCHAR2
166 , p5_a0 NUMBER
167 , p5_a1 NUMBER
168 , p5_a2 VARCHAR2
169 , p5_a3 DATE
170 , p5_a4 DATE
171 , p5_a5 NUMBER
172 , p5_a6 NUMBER
173 , p5_a7 NUMBER
174 , p5_a8 NUMBER
175 , p5_a9 VARCHAR2
176 , p5_a10 NUMBER
177 , p5_a11 NUMBER
178 , p5_a12 NUMBER
179 , p5_a13 NUMBER
180 , p5_a14 NUMBER
181 , p5_a15 VARCHAR2
182 , p5_a16 NUMBER
183 , p5_a17 DATE
184 , p5_a18 NUMBER
185 , p5_a19 DATE
186 , p5_a20 NUMBER
187 , p5_a21 VARCHAR2
188 , p5_a22 VARCHAR2
189 , p5_a23 VARCHAR2
190 , p5_a24 VARCHAR2
191 , p5_a25 VARCHAR2
192 , p5_a26 VARCHAR2
193 , p5_a27 VARCHAR2
194 , p5_a28 VARCHAR2
195 , p5_a29 VARCHAR2
196 , p5_a30 VARCHAR2
197 , p5_a31 VARCHAR2
198 , p5_a32 VARCHAR2
199 , p5_a33 VARCHAR2
200 , p5_a34 VARCHAR2
201 , p5_a35 VARCHAR2
202 , p5_a36 VARCHAR2
203 , p5_a37 NUMBER
204 , p6_a0 out nocopy NUMBER
205 , p6_a1 out nocopy NUMBER
206 , p6_a2 out nocopy VARCHAR2
207 , p6_a3 out nocopy DATE
208 , p6_a4 out nocopy DATE
209 , p6_a5 out nocopy NUMBER
210 , p6_a6 out nocopy NUMBER
211 , p6_a7 out nocopy NUMBER
212 , p6_a8 out nocopy NUMBER
213 , p6_a9 out nocopy VARCHAR2
214 , p6_a10 out nocopy NUMBER
215 , p6_a11 out nocopy NUMBER
216 , p6_a12 out nocopy NUMBER
217 , p6_a13 out nocopy NUMBER
218 , p6_a14 out nocopy NUMBER
219 , p6_a15 out nocopy VARCHAR2
220 , p6_a16 out nocopy NUMBER
221 , p6_a17 out nocopy DATE
222 , p6_a18 out nocopy NUMBER
223 , p6_a19 out nocopy DATE
224 , p6_a20 out nocopy NUMBER
225 , p6_a21 out nocopy VARCHAR2
226 , p6_a22 out nocopy VARCHAR2
227 , p6_a23 out nocopy VARCHAR2
228 , p6_a24 out nocopy VARCHAR2
229 , p6_a25 out nocopy VARCHAR2
230 , p6_a26 out nocopy VARCHAR2
231 , p6_a27 out nocopy VARCHAR2
232 , p6_a28 out nocopy VARCHAR2
233 , p6_a29 out nocopy VARCHAR2
234 , p6_a30 out nocopy VARCHAR2
235 , p6_a31 out nocopy VARCHAR2
236 , p6_a32 out nocopy VARCHAR2
237 , p6_a33 out nocopy VARCHAR2
238 , p6_a34 out nocopy VARCHAR2
239 , p6_a35 out nocopy VARCHAR2
240 , p6_a36 out nocopy VARCHAR2
241 , p6_a37 out nocopy NUMBER
242 );
243 procedure insert_row(p_api_version NUMBER
244 , p_init_msg_list VARCHAR2
245 , x_return_status out nocopy VARCHAR2
246 , x_msg_count out nocopy NUMBER
247 , x_msg_data out nocopy VARCHAR2
248 , p5_a0 JTF_NUMBER_TABLE
249 , p5_a1 JTF_NUMBER_TABLE
250 , p5_a2 JTF_VARCHAR2_TABLE_100
251 , p5_a3 JTF_DATE_TABLE
252 , p5_a4 JTF_DATE_TABLE
253 , p5_a5 JTF_NUMBER_TABLE
254 , p5_a6 JTF_NUMBER_TABLE
255 , p5_a7 JTF_NUMBER_TABLE
256 , p5_a8 JTF_NUMBER_TABLE
257 , p5_a9 JTF_VARCHAR2_TABLE_100
258 , p5_a10 JTF_NUMBER_TABLE
259 , p5_a11 JTF_NUMBER_TABLE
260 , p5_a12 JTF_NUMBER_TABLE
261 , p5_a13 JTF_NUMBER_TABLE
262 , p5_a14 JTF_NUMBER_TABLE
263 , p5_a15 JTF_VARCHAR2_TABLE_100
264 , p5_a16 JTF_NUMBER_TABLE
265 , p5_a17 JTF_DATE_TABLE
266 , p5_a18 JTF_NUMBER_TABLE
267 , p5_a19 JTF_DATE_TABLE
268 , p5_a20 JTF_NUMBER_TABLE
269 , p5_a21 JTF_VARCHAR2_TABLE_100
270 , p5_a22 JTF_VARCHAR2_TABLE_500
271 , p5_a23 JTF_VARCHAR2_TABLE_500
272 , p5_a24 JTF_VARCHAR2_TABLE_500
273 , p5_a25 JTF_VARCHAR2_TABLE_500
274 , p5_a26 JTF_VARCHAR2_TABLE_500
275 , p5_a27 JTF_VARCHAR2_TABLE_500
276 , p5_a28 JTF_VARCHAR2_TABLE_500
277 , p5_a29 JTF_VARCHAR2_TABLE_500
278 , p5_a30 JTF_VARCHAR2_TABLE_500
279 , p5_a31 JTF_VARCHAR2_TABLE_500
280 , p5_a32 JTF_VARCHAR2_TABLE_500
281 , p5_a33 JTF_VARCHAR2_TABLE_500
282 , p5_a34 JTF_VARCHAR2_TABLE_500
283 , p5_a35 JTF_VARCHAR2_TABLE_500
284 , p5_a36 JTF_VARCHAR2_TABLE_500
285 , p5_a37 JTF_NUMBER_TABLE
286 , p6_a0 out nocopy JTF_NUMBER_TABLE
287 , p6_a1 out nocopy JTF_NUMBER_TABLE
288 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
289 , p6_a3 out nocopy JTF_DATE_TABLE
290 , p6_a4 out nocopy JTF_DATE_TABLE
291 , p6_a5 out nocopy JTF_NUMBER_TABLE
292 , p6_a6 out nocopy JTF_NUMBER_TABLE
293 , p6_a7 out nocopy JTF_NUMBER_TABLE
294 , p6_a8 out nocopy JTF_NUMBER_TABLE
295 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
296 , p6_a10 out nocopy JTF_NUMBER_TABLE
297 , p6_a11 out nocopy JTF_NUMBER_TABLE
298 , p6_a12 out nocopy JTF_NUMBER_TABLE
299 , p6_a13 out nocopy JTF_NUMBER_TABLE
300 , p6_a14 out nocopy JTF_NUMBER_TABLE
301 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
302 , p6_a16 out nocopy JTF_NUMBER_TABLE
303 , p6_a17 out nocopy JTF_DATE_TABLE
304 , p6_a18 out nocopy JTF_NUMBER_TABLE
305 , p6_a19 out nocopy JTF_DATE_TABLE
306 , p6_a20 out nocopy JTF_NUMBER_TABLE
307 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
308 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
309 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
310 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
311 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
312 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
313 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
314 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
315 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
316 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
317 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
318 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
319 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
320 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
321 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
322 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
323 , p6_a37 out nocopy JTF_NUMBER_TABLE
324 );
325 procedure update_row(p_api_version NUMBER
326 , p_init_msg_list VARCHAR2
327 , x_return_status out nocopy VARCHAR2
328 , x_msg_count out nocopy NUMBER
329 , x_msg_data out nocopy VARCHAR2
330 , p5_a0 NUMBER
331 , p5_a1 NUMBER
332 , p5_a2 VARCHAR2
333 , p5_a3 DATE
334 , p5_a4 DATE
335 , p5_a5 NUMBER
336 , p5_a6 NUMBER
337 , p5_a7 NUMBER
338 , p5_a8 NUMBER
339 , p5_a9 VARCHAR2
340 , p5_a10 NUMBER
341 , p5_a11 NUMBER
342 , p5_a12 NUMBER
343 , p5_a13 NUMBER
344 , p5_a14 NUMBER
345 , p5_a15 VARCHAR2
346 , p5_a16 NUMBER
347 , p5_a17 DATE
348 , p5_a18 NUMBER
349 , p5_a19 DATE
350 , p5_a20 NUMBER
351 , p5_a21 VARCHAR2
352 , p5_a22 VARCHAR2
353 , p5_a23 VARCHAR2
354 , p5_a24 VARCHAR2
355 , p5_a25 VARCHAR2
356 , p5_a26 VARCHAR2
357 , p5_a27 VARCHAR2
358 , p5_a28 VARCHAR2
359 , p5_a29 VARCHAR2
360 , p5_a30 VARCHAR2
361 , p5_a31 VARCHAR2
362 , p5_a32 VARCHAR2
363 , p5_a33 VARCHAR2
364 , p5_a34 VARCHAR2
365 , p5_a35 VARCHAR2
366 , p5_a36 VARCHAR2
367 , p5_a37 NUMBER
368 , p6_a0 out nocopy NUMBER
369 , p6_a1 out nocopy NUMBER
370 , p6_a2 out nocopy VARCHAR2
371 , p6_a3 out nocopy DATE
372 , p6_a4 out nocopy DATE
373 , p6_a5 out nocopy NUMBER
374 , p6_a6 out nocopy NUMBER
375 , p6_a7 out nocopy NUMBER
376 , p6_a8 out nocopy NUMBER
377 , p6_a9 out nocopy VARCHAR2
378 , p6_a10 out nocopy NUMBER
379 , p6_a11 out nocopy NUMBER
380 , p6_a12 out nocopy NUMBER
381 , p6_a13 out nocopy NUMBER
382 , p6_a14 out nocopy NUMBER
383 , p6_a15 out nocopy VARCHAR2
384 , p6_a16 out nocopy NUMBER
385 , p6_a17 out nocopy DATE
386 , p6_a18 out nocopy NUMBER
387 , p6_a19 out nocopy DATE
388 , p6_a20 out nocopy NUMBER
389 , p6_a21 out nocopy VARCHAR2
390 , p6_a22 out nocopy VARCHAR2
391 , p6_a23 out nocopy VARCHAR2
392 , p6_a24 out nocopy VARCHAR2
393 , p6_a25 out nocopy VARCHAR2
394 , p6_a26 out nocopy VARCHAR2
395 , p6_a27 out nocopy VARCHAR2
396 , p6_a28 out nocopy VARCHAR2
397 , p6_a29 out nocopy VARCHAR2
398 , p6_a30 out nocopy VARCHAR2
399 , p6_a31 out nocopy VARCHAR2
400 , p6_a32 out nocopy VARCHAR2
401 , p6_a33 out nocopy VARCHAR2
402 , p6_a34 out nocopy VARCHAR2
403 , p6_a35 out nocopy VARCHAR2
404 , p6_a36 out nocopy VARCHAR2
405 , p6_a37 out nocopy NUMBER
406 );
407 procedure update_row(p_api_version NUMBER
408 , p_init_msg_list VARCHAR2
409 , x_return_status out nocopy VARCHAR2
410 , x_msg_count out nocopy NUMBER
411 , x_msg_data out nocopy VARCHAR2
412 , p5_a0 JTF_NUMBER_TABLE
413 , p5_a1 JTF_NUMBER_TABLE
414 , p5_a2 JTF_VARCHAR2_TABLE_100
415 , p5_a3 JTF_DATE_TABLE
416 , p5_a4 JTF_DATE_TABLE
417 , p5_a5 JTF_NUMBER_TABLE
418 , p5_a6 JTF_NUMBER_TABLE
419 , p5_a7 JTF_NUMBER_TABLE
420 , p5_a8 JTF_NUMBER_TABLE
421 , p5_a9 JTF_VARCHAR2_TABLE_100
422 , p5_a10 JTF_NUMBER_TABLE
423 , p5_a11 JTF_NUMBER_TABLE
424 , p5_a12 JTF_NUMBER_TABLE
425 , p5_a13 JTF_NUMBER_TABLE
426 , p5_a14 JTF_NUMBER_TABLE
427 , p5_a15 JTF_VARCHAR2_TABLE_100
428 , p5_a16 JTF_NUMBER_TABLE
429 , p5_a17 JTF_DATE_TABLE
430 , p5_a18 JTF_NUMBER_TABLE
431 , p5_a19 JTF_DATE_TABLE
432 , p5_a20 JTF_NUMBER_TABLE
433 , p5_a21 JTF_VARCHAR2_TABLE_100
434 , p5_a22 JTF_VARCHAR2_TABLE_500
435 , p5_a23 JTF_VARCHAR2_TABLE_500
436 , p5_a24 JTF_VARCHAR2_TABLE_500
437 , p5_a25 JTF_VARCHAR2_TABLE_500
438 , p5_a26 JTF_VARCHAR2_TABLE_500
439 , p5_a27 JTF_VARCHAR2_TABLE_500
440 , p5_a28 JTF_VARCHAR2_TABLE_500
441 , p5_a29 JTF_VARCHAR2_TABLE_500
442 , p5_a30 JTF_VARCHAR2_TABLE_500
443 , p5_a31 JTF_VARCHAR2_TABLE_500
444 , p5_a32 JTF_VARCHAR2_TABLE_500
445 , p5_a33 JTF_VARCHAR2_TABLE_500
446 , p5_a34 JTF_VARCHAR2_TABLE_500
447 , p5_a35 JTF_VARCHAR2_TABLE_500
448 , p5_a36 JTF_VARCHAR2_TABLE_500
449 , p5_a37 JTF_NUMBER_TABLE
450 , p6_a0 out nocopy JTF_NUMBER_TABLE
451 , p6_a1 out nocopy JTF_NUMBER_TABLE
452 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
453 , p6_a3 out nocopy JTF_DATE_TABLE
454 , p6_a4 out nocopy JTF_DATE_TABLE
455 , p6_a5 out nocopy JTF_NUMBER_TABLE
456 , p6_a6 out nocopy JTF_NUMBER_TABLE
457 , p6_a7 out nocopy JTF_NUMBER_TABLE
458 , p6_a8 out nocopy JTF_NUMBER_TABLE
459 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
460 , p6_a10 out nocopy JTF_NUMBER_TABLE
461 , p6_a11 out nocopy JTF_NUMBER_TABLE
462 , p6_a12 out nocopy JTF_NUMBER_TABLE
463 , p6_a13 out nocopy JTF_NUMBER_TABLE
464 , p6_a14 out nocopy JTF_NUMBER_TABLE
465 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
466 , p6_a16 out nocopy JTF_NUMBER_TABLE
467 , p6_a17 out nocopy JTF_DATE_TABLE
468 , p6_a18 out nocopy JTF_NUMBER_TABLE
469 , p6_a19 out nocopy JTF_DATE_TABLE
470 , p6_a20 out nocopy JTF_NUMBER_TABLE
471 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
472 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
473 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
474 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
475 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
476 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
477 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
478 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
479 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
480 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
481 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
482 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
483 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
484 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
485 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
486 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
487 , p6_a37 out nocopy JTF_NUMBER_TABLE
488 );
489 procedure delete_row(p_api_version NUMBER
490 , p_init_msg_list VARCHAR2
491 , x_return_status out nocopy VARCHAR2
492 , x_msg_count out nocopy NUMBER
493 , x_msg_data out nocopy VARCHAR2
494 , p5_a0 NUMBER
495 , p5_a1 NUMBER
496 , p5_a2 VARCHAR2
497 , p5_a3 DATE
498 , p5_a4 DATE
499 , p5_a5 NUMBER
500 , p5_a6 NUMBER
501 , p5_a7 NUMBER
502 , p5_a8 NUMBER
503 , p5_a9 VARCHAR2
504 , p5_a10 NUMBER
505 , p5_a11 NUMBER
506 , p5_a12 NUMBER
507 , p5_a13 NUMBER
508 , p5_a14 NUMBER
509 , p5_a15 VARCHAR2
510 , p5_a16 NUMBER
511 , p5_a17 DATE
512 , p5_a18 NUMBER
513 , p5_a19 DATE
514 , p5_a20 NUMBER
515 , p5_a21 VARCHAR2
516 , p5_a22 VARCHAR2
517 , p5_a23 VARCHAR2
518 , p5_a24 VARCHAR2
519 , p5_a25 VARCHAR2
520 , p5_a26 VARCHAR2
521 , p5_a27 VARCHAR2
522 , p5_a28 VARCHAR2
523 , p5_a29 VARCHAR2
524 , p5_a30 VARCHAR2
525 , p5_a31 VARCHAR2
526 , p5_a32 VARCHAR2
527 , p5_a33 VARCHAR2
528 , p5_a34 VARCHAR2
529 , p5_a35 VARCHAR2
530 , p5_a36 VARCHAR2
531 , p5_a37 NUMBER
532 );
533 procedure delete_row(p_api_version NUMBER
534 , p_init_msg_list VARCHAR2
535 , x_return_status out nocopy VARCHAR2
536 , x_msg_count out nocopy NUMBER
537 , x_msg_data out nocopy VARCHAR2
538 , p5_a0 JTF_NUMBER_TABLE
539 , p5_a1 JTF_NUMBER_TABLE
540 , p5_a2 JTF_VARCHAR2_TABLE_100
541 , p5_a3 JTF_DATE_TABLE
542 , p5_a4 JTF_DATE_TABLE
543 , p5_a5 JTF_NUMBER_TABLE
544 , p5_a6 JTF_NUMBER_TABLE
545 , p5_a7 JTF_NUMBER_TABLE
546 , p5_a8 JTF_NUMBER_TABLE
547 , p5_a9 JTF_VARCHAR2_TABLE_100
548 , p5_a10 JTF_NUMBER_TABLE
549 , p5_a11 JTF_NUMBER_TABLE
550 , p5_a12 JTF_NUMBER_TABLE
551 , p5_a13 JTF_NUMBER_TABLE
552 , p5_a14 JTF_NUMBER_TABLE
553 , p5_a15 JTF_VARCHAR2_TABLE_100
554 , p5_a16 JTF_NUMBER_TABLE
555 , p5_a17 JTF_DATE_TABLE
556 , p5_a18 JTF_NUMBER_TABLE
557 , p5_a19 JTF_DATE_TABLE
558 , p5_a20 JTF_NUMBER_TABLE
559 , p5_a21 JTF_VARCHAR2_TABLE_100
560 , p5_a22 JTF_VARCHAR2_TABLE_500
561 , p5_a23 JTF_VARCHAR2_TABLE_500
562 , p5_a24 JTF_VARCHAR2_TABLE_500
563 , p5_a25 JTF_VARCHAR2_TABLE_500
564 , p5_a26 JTF_VARCHAR2_TABLE_500
565 , p5_a27 JTF_VARCHAR2_TABLE_500
566 , p5_a28 JTF_VARCHAR2_TABLE_500
567 , p5_a29 JTF_VARCHAR2_TABLE_500
568 , p5_a30 JTF_VARCHAR2_TABLE_500
569 , p5_a31 JTF_VARCHAR2_TABLE_500
570 , p5_a32 JTF_VARCHAR2_TABLE_500
571 , p5_a33 JTF_VARCHAR2_TABLE_500
572 , p5_a34 JTF_VARCHAR2_TABLE_500
573 , p5_a35 JTF_VARCHAR2_TABLE_500
574 , p5_a36 JTF_VARCHAR2_TABLE_500
575 , p5_a37 JTF_NUMBER_TABLE
576 );
577 end okl_lrv_pvt_w;