[Home] [Help]
PACKAGE: APPS.OKL_TRY_PVT_W
Source
1 package okl_try_pvt_w as
2 /* $Header: OKLITRYS.pls 120.2 2005/07/15 07:40:29 asawanka noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy okl_try_pvt.try_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_DATE_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_DATE_TABLE
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_VARCHAR2_TABLE_100
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_VARCHAR2_TABLE_100
19 , a16 JTF_VARCHAR2_TABLE_100
20 );
21 procedure rosetta_table_copy_out_p2(t okl_try_pvt.try_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
22 , a1 out nocopy JTF_NUMBER_TABLE
23 , a2 out nocopy JTF_NUMBER_TABLE
24 , a3 out nocopy JTF_NUMBER_TABLE
25 , a4 out nocopy JTF_VARCHAR2_TABLE_100
26 , a5 out nocopy JTF_VARCHAR2_TABLE_100
27 , a6 out nocopy JTF_NUMBER_TABLE
28 , a7 out nocopy JTF_NUMBER_TABLE
29 , a8 out nocopy JTF_NUMBER_TABLE
30 , a9 out nocopy JTF_DATE_TABLE
31 , a10 out nocopy JTF_NUMBER_TABLE
32 , a11 out nocopy JTF_DATE_TABLE
33 , a12 out nocopy JTF_NUMBER_TABLE
34 , a13 out nocopy JTF_VARCHAR2_TABLE_100
35 , a14 out nocopy JTF_VARCHAR2_TABLE_100
36 , a15 out nocopy JTF_VARCHAR2_TABLE_100
37 , a16 out nocopy JTF_VARCHAR2_TABLE_100
38 );
39
40 procedure rosetta_table_copy_in_p5(t out nocopy okl_try_pvt.okl_trx_types_tl_tbl_type, a0 JTF_NUMBER_TABLE
41 , a1 JTF_VARCHAR2_TABLE_100
42 , a2 JTF_VARCHAR2_TABLE_100
43 , a3 JTF_VARCHAR2_TABLE_100
44 , a4 JTF_VARCHAR2_TABLE_200
45 , a5 JTF_VARCHAR2_TABLE_2000
46 , a6 JTF_VARCHAR2_TABLE_100
47 , a7 JTF_VARCHAR2_TABLE_100
48 , a8 JTF_NUMBER_TABLE
49 , a9 JTF_DATE_TABLE
50 , a10 JTF_NUMBER_TABLE
51 , a11 JTF_DATE_TABLE
52 , a12 JTF_NUMBER_TABLE
53 );
54 procedure rosetta_table_copy_out_p5(t okl_try_pvt.okl_trx_types_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
55 , a1 out nocopy JTF_VARCHAR2_TABLE_100
56 , a2 out nocopy JTF_VARCHAR2_TABLE_100
57 , a3 out nocopy JTF_VARCHAR2_TABLE_100
58 , a4 out nocopy JTF_VARCHAR2_TABLE_200
59 , a5 out nocopy JTF_VARCHAR2_TABLE_2000
60 , a6 out nocopy JTF_VARCHAR2_TABLE_100
61 , a7 out nocopy JTF_VARCHAR2_TABLE_100
62 , a8 out nocopy JTF_NUMBER_TABLE
63 , a9 out nocopy JTF_DATE_TABLE
64 , a10 out nocopy JTF_NUMBER_TABLE
65 , a11 out nocopy JTF_DATE_TABLE
66 , a12 out nocopy JTF_NUMBER_TABLE
67 );
68
69 procedure rosetta_table_copy_in_p8(t out nocopy okl_try_pvt.tryv_tbl_type, a0 JTF_NUMBER_TABLE
70 , a1 JTF_NUMBER_TABLE
71 , a2 JTF_VARCHAR2_TABLE_100
72 , a3 JTF_VARCHAR2_TABLE_100
73 , a4 JTF_NUMBER_TABLE
74 , a5 JTF_NUMBER_TABLE
75 , a6 JTF_NUMBER_TABLE
76 , a7 JTF_VARCHAR2_TABLE_100
77 , a8 JTF_VARCHAR2_TABLE_200
78 , a9 JTF_VARCHAR2_TABLE_2000
79 , a10 JTF_VARCHAR2_TABLE_100
80 , a11 JTF_VARCHAR2_TABLE_100
81 , a12 JTF_NUMBER_TABLE
82 , a13 JTF_NUMBER_TABLE
83 , a14 JTF_DATE_TABLE
84 , a15 JTF_NUMBER_TABLE
85 , a16 JTF_DATE_TABLE
86 , a17 JTF_NUMBER_TABLE
87 , a18 JTF_VARCHAR2_TABLE_100
88 , a19 JTF_VARCHAR2_TABLE_100
89 , a20 JTF_VARCHAR2_TABLE_100
90 , a21 JTF_VARCHAR2_TABLE_100
91 );
92 procedure rosetta_table_copy_out_p8(t okl_try_pvt.tryv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93 , a1 out nocopy JTF_NUMBER_TABLE
94 , a2 out nocopy JTF_VARCHAR2_TABLE_100
95 , a3 out nocopy JTF_VARCHAR2_TABLE_100
96 , a4 out nocopy JTF_NUMBER_TABLE
97 , a5 out nocopy JTF_NUMBER_TABLE
98 , a6 out nocopy JTF_NUMBER_TABLE
99 , a7 out nocopy JTF_VARCHAR2_TABLE_100
100 , a8 out nocopy JTF_VARCHAR2_TABLE_200
101 , a9 out nocopy JTF_VARCHAR2_TABLE_2000
102 , a10 out nocopy JTF_VARCHAR2_TABLE_100
103 , a11 out nocopy JTF_VARCHAR2_TABLE_100
104 , a12 out nocopy JTF_NUMBER_TABLE
105 , a13 out nocopy JTF_NUMBER_TABLE
106 , a14 out nocopy JTF_DATE_TABLE
107 , a15 out nocopy JTF_NUMBER_TABLE
108 , a16 out nocopy JTF_DATE_TABLE
109 , a17 out nocopy JTF_NUMBER_TABLE
110 , a18 out nocopy JTF_VARCHAR2_TABLE_100
111 , a19 out nocopy JTF_VARCHAR2_TABLE_100
112 , a20 out nocopy JTF_VARCHAR2_TABLE_100
113 , a21 out nocopy JTF_VARCHAR2_TABLE_100
114 );
115
116 procedure insert_row(p_api_version NUMBER
117 , p_init_msg_list VARCHAR2
118 , x_return_status out nocopy VARCHAR2
119 , x_msg_count out nocopy NUMBER
120 , x_msg_data out nocopy VARCHAR2
121 , p6_a0 out nocopy NUMBER
122 , p6_a1 out nocopy NUMBER
123 , p6_a2 out nocopy VARCHAR2
124 , p6_a3 out nocopy VARCHAR2
125 , p6_a4 out nocopy NUMBER
126 , p6_a5 out nocopy NUMBER
127 , p6_a6 out nocopy NUMBER
128 , p6_a7 out nocopy VARCHAR2
129 , p6_a8 out nocopy VARCHAR2
130 , p6_a9 out nocopy VARCHAR2
131 , p6_a10 out nocopy VARCHAR2
132 , p6_a11 out nocopy VARCHAR2
133 , p6_a12 out nocopy NUMBER
134 , p6_a13 out nocopy NUMBER
135 , p6_a14 out nocopy DATE
136 , p6_a15 out nocopy NUMBER
137 , p6_a16 out nocopy DATE
138 , p6_a17 out nocopy NUMBER
139 , p6_a18 out nocopy VARCHAR2
140 , p6_a19 out nocopy VARCHAR2
141 , p6_a20 out nocopy VARCHAR2
142 , p6_a21 out nocopy VARCHAR2
143 , p5_a0 NUMBER := 0-1962.0724
144 , p5_a1 NUMBER := 0-1962.0724
145 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
146 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
147 , p5_a4 NUMBER := 0-1962.0724
148 , p5_a5 NUMBER := 0-1962.0724
149 , p5_a6 NUMBER := 0-1962.0724
150 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
151 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
152 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
153 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
154 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
155 , p5_a12 NUMBER := 0-1962.0724
156 , p5_a13 NUMBER := 0-1962.0724
157 , p5_a14 DATE := fnd_api.g_miss_date
158 , p5_a15 NUMBER := 0-1962.0724
159 , p5_a16 DATE := fnd_api.g_miss_date
160 , p5_a17 NUMBER := 0-1962.0724
161 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
162 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
163 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
164 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
165 );
166 procedure insert_row(p_api_version NUMBER
167 , p_init_msg_list VARCHAR2
168 , x_return_status out nocopy VARCHAR2
169 , x_msg_count out nocopy NUMBER
170 , x_msg_data out nocopy VARCHAR2
171 , p5_a0 JTF_NUMBER_TABLE
172 , p5_a1 JTF_NUMBER_TABLE
173 , p5_a2 JTF_VARCHAR2_TABLE_100
174 , p5_a3 JTF_VARCHAR2_TABLE_100
175 , p5_a4 JTF_NUMBER_TABLE
176 , p5_a5 JTF_NUMBER_TABLE
177 , p5_a6 JTF_NUMBER_TABLE
178 , p5_a7 JTF_VARCHAR2_TABLE_100
179 , p5_a8 JTF_VARCHAR2_TABLE_200
180 , p5_a9 JTF_VARCHAR2_TABLE_2000
181 , p5_a10 JTF_VARCHAR2_TABLE_100
182 , p5_a11 JTF_VARCHAR2_TABLE_100
183 , p5_a12 JTF_NUMBER_TABLE
184 , p5_a13 JTF_NUMBER_TABLE
185 , p5_a14 JTF_DATE_TABLE
186 , p5_a15 JTF_NUMBER_TABLE
187 , p5_a16 JTF_DATE_TABLE
188 , p5_a17 JTF_NUMBER_TABLE
189 , p5_a18 JTF_VARCHAR2_TABLE_100
190 , p5_a19 JTF_VARCHAR2_TABLE_100
191 , p5_a20 JTF_VARCHAR2_TABLE_100
192 , p5_a21 JTF_VARCHAR2_TABLE_100
193 , p6_a0 out nocopy JTF_NUMBER_TABLE
194 , p6_a1 out nocopy JTF_NUMBER_TABLE
195 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
196 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
197 , p6_a4 out nocopy JTF_NUMBER_TABLE
198 , p6_a5 out nocopy JTF_NUMBER_TABLE
199 , p6_a6 out nocopy JTF_NUMBER_TABLE
200 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
201 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
202 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
203 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
204 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
205 , p6_a12 out nocopy JTF_NUMBER_TABLE
206 , p6_a13 out nocopy JTF_NUMBER_TABLE
207 , p6_a14 out nocopy JTF_DATE_TABLE
208 , p6_a15 out nocopy JTF_NUMBER_TABLE
209 , p6_a16 out nocopy JTF_DATE_TABLE
210 , p6_a17 out nocopy JTF_NUMBER_TABLE
211 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
212 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
213 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
214 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
215 );
216 procedure lock_row(p_api_version NUMBER
217 , p_init_msg_list VARCHAR2
218 , x_return_status out nocopy VARCHAR2
219 , x_msg_count out nocopy NUMBER
220 , x_msg_data out nocopy VARCHAR2
221 , p5_a0 NUMBER := 0-1962.0724
222 , p5_a1 NUMBER := 0-1962.0724
223 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
224 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
225 , p5_a4 NUMBER := 0-1962.0724
226 , p5_a5 NUMBER := 0-1962.0724
227 , p5_a6 NUMBER := 0-1962.0724
228 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
229 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
230 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
231 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
232 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
233 , p5_a12 NUMBER := 0-1962.0724
234 , p5_a13 NUMBER := 0-1962.0724
235 , p5_a14 DATE := fnd_api.g_miss_date
236 , p5_a15 NUMBER := 0-1962.0724
237 , p5_a16 DATE := fnd_api.g_miss_date
238 , p5_a17 NUMBER := 0-1962.0724
239 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
240 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
241 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
242 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
243 );
244 procedure lock_row(p_api_version NUMBER
245 , p_init_msg_list VARCHAR2
246 , x_return_status out nocopy VARCHAR2
247 , x_msg_count out nocopy NUMBER
248 , x_msg_data out nocopy VARCHAR2
249 , p5_a0 JTF_NUMBER_TABLE
250 , p5_a1 JTF_NUMBER_TABLE
251 , p5_a2 JTF_VARCHAR2_TABLE_100
252 , p5_a3 JTF_VARCHAR2_TABLE_100
253 , p5_a4 JTF_NUMBER_TABLE
254 , p5_a5 JTF_NUMBER_TABLE
255 , p5_a6 JTF_NUMBER_TABLE
256 , p5_a7 JTF_VARCHAR2_TABLE_100
257 , p5_a8 JTF_VARCHAR2_TABLE_200
258 , p5_a9 JTF_VARCHAR2_TABLE_2000
259 , p5_a10 JTF_VARCHAR2_TABLE_100
260 , p5_a11 JTF_VARCHAR2_TABLE_100
261 , p5_a12 JTF_NUMBER_TABLE
262 , p5_a13 JTF_NUMBER_TABLE
263 , p5_a14 JTF_DATE_TABLE
264 , p5_a15 JTF_NUMBER_TABLE
265 , p5_a16 JTF_DATE_TABLE
266 , p5_a17 JTF_NUMBER_TABLE
267 , p5_a18 JTF_VARCHAR2_TABLE_100
268 , p5_a19 JTF_VARCHAR2_TABLE_100
269 , p5_a20 JTF_VARCHAR2_TABLE_100
270 , p5_a21 JTF_VARCHAR2_TABLE_100
271 );
272 procedure update_row(p_api_version NUMBER
273 , p_init_msg_list VARCHAR2
274 , x_return_status out nocopy VARCHAR2
275 , x_msg_count out nocopy NUMBER
276 , x_msg_data out nocopy VARCHAR2
277 , p6_a0 out nocopy NUMBER
278 , p6_a1 out nocopy NUMBER
279 , p6_a2 out nocopy VARCHAR2
280 , p6_a3 out nocopy VARCHAR2
281 , p6_a4 out nocopy NUMBER
282 , p6_a5 out nocopy NUMBER
283 , p6_a6 out nocopy NUMBER
284 , p6_a7 out nocopy VARCHAR2
285 , p6_a8 out nocopy VARCHAR2
286 , p6_a9 out nocopy VARCHAR2
287 , p6_a10 out nocopy VARCHAR2
288 , p6_a11 out nocopy VARCHAR2
289 , p6_a12 out nocopy NUMBER
290 , p6_a13 out nocopy NUMBER
291 , p6_a14 out nocopy DATE
292 , p6_a15 out nocopy NUMBER
293 , p6_a16 out nocopy DATE
294 , p6_a17 out nocopy NUMBER
295 , p6_a18 out nocopy VARCHAR2
296 , p6_a19 out nocopy VARCHAR2
297 , p6_a20 out nocopy VARCHAR2
298 , p6_a21 out nocopy VARCHAR2
299 , p5_a0 NUMBER := 0-1962.0724
300 , p5_a1 NUMBER := 0-1962.0724
301 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
302 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
303 , p5_a4 NUMBER := 0-1962.0724
304 , p5_a5 NUMBER := 0-1962.0724
305 , p5_a6 NUMBER := 0-1962.0724
306 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
307 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
308 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
309 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
310 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
311 , p5_a12 NUMBER := 0-1962.0724
312 , p5_a13 NUMBER := 0-1962.0724
313 , p5_a14 DATE := fnd_api.g_miss_date
314 , p5_a15 NUMBER := 0-1962.0724
315 , p5_a16 DATE := fnd_api.g_miss_date
316 , p5_a17 NUMBER := 0-1962.0724
317 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
318 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
319 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
320 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
321 );
322 procedure update_row(p_api_version NUMBER
323 , p_init_msg_list VARCHAR2
324 , x_return_status out nocopy VARCHAR2
325 , x_msg_count out nocopy NUMBER
326 , x_msg_data out nocopy VARCHAR2
327 , p5_a0 JTF_NUMBER_TABLE
328 , p5_a1 JTF_NUMBER_TABLE
329 , p5_a2 JTF_VARCHAR2_TABLE_100
330 , p5_a3 JTF_VARCHAR2_TABLE_100
331 , p5_a4 JTF_NUMBER_TABLE
332 , p5_a5 JTF_NUMBER_TABLE
333 , p5_a6 JTF_NUMBER_TABLE
334 , p5_a7 JTF_VARCHAR2_TABLE_100
335 , p5_a8 JTF_VARCHAR2_TABLE_200
336 , p5_a9 JTF_VARCHAR2_TABLE_2000
337 , p5_a10 JTF_VARCHAR2_TABLE_100
338 , p5_a11 JTF_VARCHAR2_TABLE_100
339 , p5_a12 JTF_NUMBER_TABLE
340 , p5_a13 JTF_NUMBER_TABLE
341 , p5_a14 JTF_DATE_TABLE
342 , p5_a15 JTF_NUMBER_TABLE
343 , p5_a16 JTF_DATE_TABLE
344 , p5_a17 JTF_NUMBER_TABLE
345 , p5_a18 JTF_VARCHAR2_TABLE_100
346 , p5_a19 JTF_VARCHAR2_TABLE_100
347 , p5_a20 JTF_VARCHAR2_TABLE_100
348 , p5_a21 JTF_VARCHAR2_TABLE_100
349 , p6_a0 out nocopy JTF_NUMBER_TABLE
350 , p6_a1 out nocopy JTF_NUMBER_TABLE
351 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
352 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
353 , p6_a4 out nocopy JTF_NUMBER_TABLE
354 , p6_a5 out nocopy JTF_NUMBER_TABLE
355 , p6_a6 out nocopy JTF_NUMBER_TABLE
356 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
357 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
358 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
359 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
360 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
361 , p6_a12 out nocopy JTF_NUMBER_TABLE
362 , p6_a13 out nocopy JTF_NUMBER_TABLE
363 , p6_a14 out nocopy JTF_DATE_TABLE
364 , p6_a15 out nocopy JTF_NUMBER_TABLE
365 , p6_a16 out nocopy JTF_DATE_TABLE
366 , p6_a17 out nocopy JTF_NUMBER_TABLE
367 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
368 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
369 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
370 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
371 );
372 procedure delete_row(p_api_version NUMBER
373 , p_init_msg_list VARCHAR2
374 , x_return_status out nocopy VARCHAR2
375 , x_msg_count out nocopy NUMBER
376 , x_msg_data out nocopy VARCHAR2
377 , p5_a0 NUMBER := 0-1962.0724
378 , p5_a1 NUMBER := 0-1962.0724
379 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
380 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
381 , p5_a4 NUMBER := 0-1962.0724
382 , p5_a5 NUMBER := 0-1962.0724
383 , p5_a6 NUMBER := 0-1962.0724
384 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
385 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
386 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
387 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
388 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
389 , p5_a12 NUMBER := 0-1962.0724
390 , p5_a13 NUMBER := 0-1962.0724
391 , p5_a14 DATE := fnd_api.g_miss_date
392 , p5_a15 NUMBER := 0-1962.0724
393 , p5_a16 DATE := fnd_api.g_miss_date
394 , p5_a17 NUMBER := 0-1962.0724
395 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
396 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
397 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
398 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
399 );
400 procedure delete_row(p_api_version NUMBER
401 , p_init_msg_list VARCHAR2
402 , x_return_status out nocopy VARCHAR2
403 , x_msg_count out nocopy NUMBER
404 , x_msg_data out nocopy VARCHAR2
405 , p5_a0 JTF_NUMBER_TABLE
406 , p5_a1 JTF_NUMBER_TABLE
407 , p5_a2 JTF_VARCHAR2_TABLE_100
408 , p5_a3 JTF_VARCHAR2_TABLE_100
409 , p5_a4 JTF_NUMBER_TABLE
410 , p5_a5 JTF_NUMBER_TABLE
411 , p5_a6 JTF_NUMBER_TABLE
412 , p5_a7 JTF_VARCHAR2_TABLE_100
413 , p5_a8 JTF_VARCHAR2_TABLE_200
414 , p5_a9 JTF_VARCHAR2_TABLE_2000
415 , p5_a10 JTF_VARCHAR2_TABLE_100
416 , p5_a11 JTF_VARCHAR2_TABLE_100
417 , p5_a12 JTF_NUMBER_TABLE
418 , p5_a13 JTF_NUMBER_TABLE
419 , p5_a14 JTF_DATE_TABLE
420 , p5_a15 JTF_NUMBER_TABLE
421 , p5_a16 JTF_DATE_TABLE
422 , p5_a17 JTF_NUMBER_TABLE
423 , p5_a18 JTF_VARCHAR2_TABLE_100
424 , p5_a19 JTF_VARCHAR2_TABLE_100
425 , p5_a20 JTF_VARCHAR2_TABLE_100
426 , p5_a21 JTF_VARCHAR2_TABLE_100
427 );
428 procedure validate_row(p_api_version NUMBER
429 , p_init_msg_list VARCHAR2
430 , x_return_status out nocopy VARCHAR2
431 , x_msg_count out nocopy NUMBER
432 , x_msg_data out nocopy VARCHAR2
433 , p5_a0 NUMBER := 0-1962.0724
434 , p5_a1 NUMBER := 0-1962.0724
435 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
436 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
437 , p5_a4 NUMBER := 0-1962.0724
438 , p5_a5 NUMBER := 0-1962.0724
439 , p5_a6 NUMBER := 0-1962.0724
440 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
441 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
442 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
443 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
444 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
445 , p5_a12 NUMBER := 0-1962.0724
446 , p5_a13 NUMBER := 0-1962.0724
447 , p5_a14 DATE := fnd_api.g_miss_date
448 , p5_a15 NUMBER := 0-1962.0724
449 , p5_a16 DATE := fnd_api.g_miss_date
450 , p5_a17 NUMBER := 0-1962.0724
451 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
452 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
453 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
454 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
455 );
456 procedure validate_row(p_api_version NUMBER
457 , p_init_msg_list VARCHAR2
458 , x_return_status out nocopy VARCHAR2
459 , x_msg_count out nocopy NUMBER
460 , x_msg_data out nocopy VARCHAR2
461 , p5_a0 JTF_NUMBER_TABLE
462 , p5_a1 JTF_NUMBER_TABLE
463 , p5_a2 JTF_VARCHAR2_TABLE_100
464 , p5_a3 JTF_VARCHAR2_TABLE_100
465 , p5_a4 JTF_NUMBER_TABLE
466 , p5_a5 JTF_NUMBER_TABLE
467 , p5_a6 JTF_NUMBER_TABLE
468 , p5_a7 JTF_VARCHAR2_TABLE_100
469 , p5_a8 JTF_VARCHAR2_TABLE_200
470 , p5_a9 JTF_VARCHAR2_TABLE_2000
471 , p5_a10 JTF_VARCHAR2_TABLE_100
472 , p5_a11 JTF_VARCHAR2_TABLE_100
473 , p5_a12 JTF_NUMBER_TABLE
474 , p5_a13 JTF_NUMBER_TABLE
475 , p5_a14 JTF_DATE_TABLE
476 , p5_a15 JTF_NUMBER_TABLE
477 , p5_a16 JTF_DATE_TABLE
478 , p5_a17 JTF_NUMBER_TABLE
479 , p5_a18 JTF_VARCHAR2_TABLE_100
480 , p5_a19 JTF_VARCHAR2_TABLE_100
481 , p5_a20 JTF_VARCHAR2_TABLE_100
482 , p5_a21 JTF_VARCHAR2_TABLE_100
483 );
484 end okl_try_pvt_w;