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