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