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