[Home] [Help]
PACKAGE: APPS.OKL_TIL_PVT_W
Source
1 package okl_til_pvt_w as
2 /* $Header: OKLITILS.pls 120.4 2007/07/20 09:41:34 akrangan ship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy okl_til_pvt.til_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
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_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_NUMBER_TABLE
17 , a14 JTF_DATE_TABLE
18 , a15 JTF_DATE_TABLE
19 , a16 JTF_NUMBER_TABLE
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_DATE_TABLE
23 , a20 JTF_NUMBER_TABLE
24 , a21 JTF_NUMBER_TABLE
25 , a22 JTF_NUMBER_TABLE
26 , a23 JTF_NUMBER_TABLE
27 , a24 JTF_NUMBER_TABLE
28 , a25 JTF_NUMBER_TABLE
29 , a26 JTF_NUMBER_TABLE
30 , a27 JTF_NUMBER_TABLE
31 , a28 JTF_NUMBER_TABLE
32 , a29 JTF_NUMBER_TABLE
33 , a30 JTF_VARCHAR2_TABLE_100
34 , a31 JTF_VARCHAR2_TABLE_500
35 , a32 JTF_VARCHAR2_TABLE_500
36 , a33 JTF_VARCHAR2_TABLE_500
37 , a34 JTF_VARCHAR2_TABLE_500
38 , a35 JTF_VARCHAR2_TABLE_500
39 , a36 JTF_VARCHAR2_TABLE_500
40 , a37 JTF_VARCHAR2_TABLE_500
41 , a38 JTF_VARCHAR2_TABLE_500
42 , a39 JTF_VARCHAR2_TABLE_500
43 , a40 JTF_VARCHAR2_TABLE_500
44 , a41 JTF_VARCHAR2_TABLE_500
45 , a42 JTF_VARCHAR2_TABLE_500
46 , a43 JTF_VARCHAR2_TABLE_500
47 , a44 JTF_VARCHAR2_TABLE_500
48 , a45 JTF_VARCHAR2_TABLE_500
49 , a46 JTF_NUMBER_TABLE
50 , a47 JTF_DATE_TABLE
51 , a48 JTF_NUMBER_TABLE
52 , a49 JTF_DATE_TABLE
53 , a50 JTF_NUMBER_TABLE
54 , a51 JTF_NUMBER_TABLE
55 , a52 JTF_NUMBER_TABLE
56 );
57 procedure rosetta_table_copy_out_p2(t okl_til_pvt.til_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58 , a1 out nocopy JTF_VARCHAR2_TABLE_100
59 , a2 out nocopy JTF_NUMBER_TABLE
60 , a3 out nocopy JTF_NUMBER_TABLE
61 , a4 out nocopy JTF_NUMBER_TABLE
62 , a5 out nocopy JTF_NUMBER_TABLE
63 , a6 out nocopy JTF_NUMBER_TABLE
64 , a7 out nocopy JTF_NUMBER_TABLE
65 , a8 out nocopy JTF_NUMBER_TABLE
66 , a9 out nocopy JTF_NUMBER_TABLE
67 , a10 out nocopy JTF_NUMBER_TABLE
68 , a11 out nocopy JTF_NUMBER_TABLE
69 , a12 out nocopy JTF_NUMBER_TABLE
70 , a13 out nocopy JTF_NUMBER_TABLE
71 , a14 out nocopy JTF_DATE_TABLE
72 , a15 out nocopy JTF_DATE_TABLE
73 , a16 out nocopy JTF_NUMBER_TABLE
74 , a17 out nocopy JTF_NUMBER_TABLE
75 , a18 out nocopy JTF_NUMBER_TABLE
76 , a19 out nocopy JTF_DATE_TABLE
77 , a20 out nocopy JTF_NUMBER_TABLE
78 , a21 out nocopy JTF_NUMBER_TABLE
79 , a22 out nocopy JTF_NUMBER_TABLE
80 , a23 out nocopy JTF_NUMBER_TABLE
81 , a24 out nocopy JTF_NUMBER_TABLE
82 , a25 out nocopy JTF_NUMBER_TABLE
83 , a26 out nocopy JTF_NUMBER_TABLE
84 , a27 out nocopy JTF_NUMBER_TABLE
85 , a28 out nocopy JTF_NUMBER_TABLE
86 , a29 out nocopy JTF_NUMBER_TABLE
87 , a30 out nocopy JTF_VARCHAR2_TABLE_100
88 , a31 out nocopy JTF_VARCHAR2_TABLE_500
89 , a32 out nocopy JTF_VARCHAR2_TABLE_500
90 , a33 out nocopy JTF_VARCHAR2_TABLE_500
91 , a34 out nocopy JTF_VARCHAR2_TABLE_500
92 , a35 out nocopy JTF_VARCHAR2_TABLE_500
93 , a36 out nocopy JTF_VARCHAR2_TABLE_500
94 , a37 out nocopy JTF_VARCHAR2_TABLE_500
95 , a38 out nocopy JTF_VARCHAR2_TABLE_500
96 , a39 out nocopy JTF_VARCHAR2_TABLE_500
97 , a40 out nocopy JTF_VARCHAR2_TABLE_500
98 , a41 out nocopy JTF_VARCHAR2_TABLE_500
99 , a42 out nocopy JTF_VARCHAR2_TABLE_500
100 , a43 out nocopy JTF_VARCHAR2_TABLE_500
101 , a44 out nocopy JTF_VARCHAR2_TABLE_500
102 , a45 out nocopy JTF_VARCHAR2_TABLE_500
103 , a46 out nocopy JTF_NUMBER_TABLE
104 , a47 out nocopy JTF_DATE_TABLE
105 , a48 out nocopy JTF_NUMBER_TABLE
106 , a49 out nocopy JTF_DATE_TABLE
107 , a50 out nocopy JTF_NUMBER_TABLE
108 , a51 out nocopy JTF_NUMBER_TABLE
109 , a52 out nocopy JTF_NUMBER_TABLE
110 );
111
112 procedure rosetta_table_copy_in_p5(t out nocopy okl_til_pvt.okl_txl_ar_inv_lns_tl_tbl_type, a0 JTF_NUMBER_TABLE
113 , a1 JTF_VARCHAR2_TABLE_100
114 , a2 JTF_VARCHAR2_TABLE_100
115 , a3 JTF_VARCHAR2_TABLE_3000
116 , a4 JTF_VARCHAR2_TABLE_100
117 , a5 JTF_VARCHAR2_TABLE_2000
118 , a6 JTF_NUMBER_TABLE
119 , a7 JTF_DATE_TABLE
120 , a8 JTF_NUMBER_TABLE
121 , a9 JTF_DATE_TABLE
122 , a10 JTF_NUMBER_TABLE
123 );
124 procedure rosetta_table_copy_out_p5(t okl_til_pvt.okl_txl_ar_inv_lns_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
125 , a1 out nocopy JTF_VARCHAR2_TABLE_100
126 , a2 out nocopy JTF_VARCHAR2_TABLE_100
127 , a3 out nocopy JTF_VARCHAR2_TABLE_3000
128 , a4 out nocopy JTF_VARCHAR2_TABLE_100
129 , a5 out nocopy JTF_VARCHAR2_TABLE_2000
130 , a6 out nocopy JTF_NUMBER_TABLE
131 , a7 out nocopy JTF_DATE_TABLE
132 , a8 out nocopy JTF_NUMBER_TABLE
133 , a9 out nocopy JTF_DATE_TABLE
134 , a10 out nocopy JTF_NUMBER_TABLE
135 );
136
137 procedure rosetta_table_copy_in_p8(t out nocopy okl_til_pvt.tilv_tbl_type, a0 JTF_NUMBER_TABLE
138 , a1 JTF_NUMBER_TABLE
139 , a2 JTF_VARCHAR2_TABLE_3000
140 , a3 JTF_VARCHAR2_TABLE_100
141 , a4 JTF_NUMBER_TABLE
142 , a5 JTF_NUMBER_TABLE
143 , a6 JTF_NUMBER_TABLE
144 , a7 JTF_VARCHAR2_TABLE_100
145 , a8 JTF_NUMBER_TABLE
146 , a9 JTF_NUMBER_TABLE
147 , a10 JTF_NUMBER_TABLE
148 , a11 JTF_NUMBER_TABLE
149 , a12 JTF_NUMBER_TABLE
150 , a13 JTF_NUMBER_TABLE
151 , a14 JTF_VARCHAR2_TABLE_2000
152 , a15 JTF_NUMBER_TABLE
153 , a16 JTF_DATE_TABLE
154 , a17 JTF_NUMBER_TABLE
155 , a18 JTF_DATE_TABLE
156 , a19 JTF_NUMBER_TABLE
157 , a20 JTF_NUMBER_TABLE
158 , a21 JTF_NUMBER_TABLE
159 , a22 JTF_NUMBER_TABLE
160 , a23 JTF_NUMBER_TABLE
161 , a24 JTF_NUMBER_TABLE
162 , a25 JTF_NUMBER_TABLE
163 , a26 JTF_NUMBER_TABLE
164 , a27 JTF_VARCHAR2_TABLE_100
165 , a28 JTF_VARCHAR2_TABLE_500
166 , a29 JTF_VARCHAR2_TABLE_500
167 , a30 JTF_VARCHAR2_TABLE_500
168 , a31 JTF_VARCHAR2_TABLE_500
169 , a32 JTF_VARCHAR2_TABLE_500
170 , a33 JTF_VARCHAR2_TABLE_500
171 , a34 JTF_VARCHAR2_TABLE_500
172 , a35 JTF_VARCHAR2_TABLE_500
173 , a36 JTF_VARCHAR2_TABLE_500
174 , a37 JTF_VARCHAR2_TABLE_500
175 , a38 JTF_VARCHAR2_TABLE_500
176 , a39 JTF_VARCHAR2_TABLE_500
177 , a40 JTF_VARCHAR2_TABLE_500
178 , a41 JTF_VARCHAR2_TABLE_500
179 , a42 JTF_VARCHAR2_TABLE_500
180 , a43 JTF_NUMBER_TABLE
181 , a44 JTF_NUMBER_TABLE
182 , a45 JTF_NUMBER_TABLE
183 , a46 JTF_DATE_TABLE
184 , a47 JTF_NUMBER_TABLE
185 , a48 JTF_NUMBER_TABLE
186 , a49 JTF_NUMBER_TABLE
187 , a50 JTF_DATE_TABLE
188 , a51 JTF_NUMBER_TABLE
189 , a52 JTF_DATE_TABLE
190 , a53 JTF_NUMBER_TABLE
191 , a54 JTF_NUMBER_TABLE
192 , a55 JTF_NUMBER_TABLE
193 );
194 procedure rosetta_table_copy_out_p8(t okl_til_pvt.tilv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
195 , a1 out nocopy JTF_NUMBER_TABLE
196 , a2 out nocopy JTF_VARCHAR2_TABLE_3000
197 , a3 out nocopy JTF_VARCHAR2_TABLE_100
198 , a4 out nocopy JTF_NUMBER_TABLE
199 , a5 out nocopy JTF_NUMBER_TABLE
200 , a6 out nocopy JTF_NUMBER_TABLE
201 , a7 out nocopy JTF_VARCHAR2_TABLE_100
202 , a8 out nocopy JTF_NUMBER_TABLE
203 , a9 out nocopy JTF_NUMBER_TABLE
204 , a10 out nocopy JTF_NUMBER_TABLE
205 , a11 out nocopy JTF_NUMBER_TABLE
206 , a12 out nocopy JTF_NUMBER_TABLE
207 , a13 out nocopy JTF_NUMBER_TABLE
208 , a14 out nocopy JTF_VARCHAR2_TABLE_2000
209 , a15 out nocopy JTF_NUMBER_TABLE
210 , a16 out nocopy JTF_DATE_TABLE
211 , a17 out nocopy JTF_NUMBER_TABLE
212 , a18 out nocopy JTF_DATE_TABLE
213 , a19 out nocopy JTF_NUMBER_TABLE
214 , a20 out nocopy JTF_NUMBER_TABLE
215 , a21 out nocopy JTF_NUMBER_TABLE
216 , a22 out nocopy JTF_NUMBER_TABLE
217 , a23 out nocopy JTF_NUMBER_TABLE
218 , a24 out nocopy JTF_NUMBER_TABLE
219 , a25 out nocopy JTF_NUMBER_TABLE
220 , a26 out nocopy JTF_NUMBER_TABLE
221 , a27 out nocopy JTF_VARCHAR2_TABLE_100
222 , a28 out nocopy JTF_VARCHAR2_TABLE_500
223 , a29 out nocopy JTF_VARCHAR2_TABLE_500
224 , a30 out nocopy JTF_VARCHAR2_TABLE_500
225 , a31 out nocopy JTF_VARCHAR2_TABLE_500
226 , a32 out nocopy JTF_VARCHAR2_TABLE_500
227 , a33 out nocopy JTF_VARCHAR2_TABLE_500
228 , a34 out nocopy JTF_VARCHAR2_TABLE_500
229 , a35 out nocopy JTF_VARCHAR2_TABLE_500
230 , a36 out nocopy JTF_VARCHAR2_TABLE_500
231 , a37 out nocopy JTF_VARCHAR2_TABLE_500
232 , a38 out nocopy JTF_VARCHAR2_TABLE_500
233 , a39 out nocopy JTF_VARCHAR2_TABLE_500
234 , a40 out nocopy JTF_VARCHAR2_TABLE_500
235 , a41 out nocopy JTF_VARCHAR2_TABLE_500
236 , a42 out nocopy JTF_VARCHAR2_TABLE_500
237 , a43 out nocopy JTF_NUMBER_TABLE
238 , a44 out nocopy JTF_NUMBER_TABLE
239 , a45 out nocopy JTF_NUMBER_TABLE
240 , a46 out nocopy JTF_DATE_TABLE
241 , a47 out nocopy JTF_NUMBER_TABLE
242 , a48 out nocopy JTF_NUMBER_TABLE
243 , a49 out nocopy JTF_NUMBER_TABLE
244 , a50 out nocopy JTF_DATE_TABLE
245 , a51 out nocopy JTF_NUMBER_TABLE
246 , a52 out nocopy JTF_DATE_TABLE
247 , a53 out nocopy JTF_NUMBER_TABLE
248 , a54 out nocopy JTF_NUMBER_TABLE
249 , a55 out nocopy JTF_NUMBER_TABLE
250 );
251
252 procedure insert_row(p_api_version NUMBER
253 , p_init_msg_list VARCHAR2
254 , x_return_status out nocopy VARCHAR2
255 , x_msg_count out nocopy NUMBER
256 , x_msg_data out nocopy VARCHAR2
257 , p6_a0 out nocopy NUMBER
258 , p6_a1 out nocopy NUMBER
259 , p6_a2 out nocopy VARCHAR2
260 , p6_a3 out nocopy VARCHAR2
261 , p6_a4 out nocopy NUMBER
262 , p6_a5 out nocopy NUMBER
263 , p6_a6 out nocopy NUMBER
264 , p6_a7 out nocopy VARCHAR2
265 , p6_a8 out nocopy NUMBER
266 , p6_a9 out nocopy NUMBER
267 , p6_a10 out nocopy NUMBER
268 , p6_a11 out nocopy NUMBER
269 , p6_a12 out nocopy NUMBER
270 , p6_a13 out nocopy NUMBER
271 , p6_a14 out nocopy VARCHAR2
272 , p6_a15 out nocopy NUMBER
273 , p6_a16 out nocopy DATE
274 , p6_a17 out nocopy NUMBER
275 , p6_a18 out nocopy DATE
276 , p6_a19 out nocopy NUMBER
277 , p6_a20 out nocopy NUMBER
278 , p6_a21 out nocopy NUMBER
279 , p6_a22 out nocopy NUMBER
280 , p6_a23 out nocopy NUMBER
281 , p6_a24 out nocopy NUMBER
282 , p6_a25 out nocopy NUMBER
283 , p6_a26 out nocopy NUMBER
284 , p6_a27 out nocopy VARCHAR2
285 , p6_a28 out nocopy VARCHAR2
286 , p6_a29 out nocopy VARCHAR2
287 , p6_a30 out nocopy VARCHAR2
288 , p6_a31 out nocopy VARCHAR2
289 , p6_a32 out nocopy VARCHAR2
290 , p6_a33 out nocopy VARCHAR2
291 , p6_a34 out nocopy VARCHAR2
292 , p6_a35 out nocopy VARCHAR2
293 , p6_a36 out nocopy VARCHAR2
294 , p6_a37 out nocopy VARCHAR2
295 , p6_a38 out nocopy VARCHAR2
296 , p6_a39 out nocopy VARCHAR2
297 , p6_a40 out nocopy VARCHAR2
298 , p6_a41 out nocopy VARCHAR2
299 , p6_a42 out nocopy VARCHAR2
300 , p6_a43 out nocopy NUMBER
301 , p6_a44 out nocopy NUMBER
302 , p6_a45 out nocopy NUMBER
303 , p6_a46 out nocopy DATE
304 , p6_a47 out nocopy NUMBER
305 , p6_a48 out nocopy NUMBER
306 , p6_a49 out nocopy NUMBER
307 , p6_a50 out nocopy DATE
308 , p6_a51 out nocopy NUMBER
309 , p6_a52 out nocopy DATE
310 , p6_a53 out nocopy NUMBER
311 , p6_a54 out nocopy NUMBER
312 , p6_a55 out nocopy NUMBER
313 , p5_a0 NUMBER := 0-1962.0724
314 , p5_a1 NUMBER := 0-1962.0724
315 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
316 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
317 , p5_a4 NUMBER := 0-1962.0724
318 , p5_a5 NUMBER := 0-1962.0724
319 , p5_a6 NUMBER := 0-1962.0724
320 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
321 , p5_a8 NUMBER := 0-1962.0724
322 , p5_a9 NUMBER := 0-1962.0724
323 , p5_a10 NUMBER := 0-1962.0724
324 , p5_a11 NUMBER := 0-1962.0724
325 , p5_a12 NUMBER := 0-1962.0724
326 , p5_a13 NUMBER := 0-1962.0724
327 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
328 , p5_a15 NUMBER := 0-1962.0724
329 , p5_a16 DATE := fnd_api.g_miss_date
330 , p5_a17 NUMBER := 0-1962.0724
331 , p5_a18 DATE := fnd_api.g_miss_date
332 , p5_a19 NUMBER := 0-1962.0724
333 , p5_a20 NUMBER := 0-1962.0724
334 , p5_a21 NUMBER := 0-1962.0724
335 , p5_a22 NUMBER := 0-1962.0724
336 , p5_a23 NUMBER := 0-1962.0724
337 , p5_a24 NUMBER := 0-1962.0724
338 , p5_a25 NUMBER := 0-1962.0724
339 , p5_a26 NUMBER := 0-1962.0724
340 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
341 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
342 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
343 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
344 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
345 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
346 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
347 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
348 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
349 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
350 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
351 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
352 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
353 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
354 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
355 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
356 , p5_a43 NUMBER := 0-1962.0724
357 , p5_a44 NUMBER := 0-1962.0724
358 , p5_a45 NUMBER := 0-1962.0724
359 , p5_a46 DATE := fnd_api.g_miss_date
360 , p5_a47 NUMBER := 0-1962.0724
361 , p5_a48 NUMBER := 0-1962.0724
362 , p5_a49 NUMBER := 0-1962.0724
363 , p5_a50 DATE := fnd_api.g_miss_date
364 , p5_a51 NUMBER := 0-1962.0724
365 , p5_a52 DATE := fnd_api.g_miss_date
366 , p5_a53 NUMBER := 0-1962.0724
367 , p5_a54 NUMBER := 0-1962.0724
368 , p5_a55 NUMBER := 0-1962.0724
369 );
370 procedure insert_row(p_api_version NUMBER
371 , p_init_msg_list VARCHAR2
372 , x_return_status out nocopy VARCHAR2
373 , x_msg_count out nocopy NUMBER
374 , x_msg_data out nocopy VARCHAR2
375 , p5_a0 JTF_NUMBER_TABLE
376 , p5_a1 JTF_NUMBER_TABLE
377 , p5_a2 JTF_VARCHAR2_TABLE_3000
378 , p5_a3 JTF_VARCHAR2_TABLE_100
379 , p5_a4 JTF_NUMBER_TABLE
380 , p5_a5 JTF_NUMBER_TABLE
381 , p5_a6 JTF_NUMBER_TABLE
382 , p5_a7 JTF_VARCHAR2_TABLE_100
383 , p5_a8 JTF_NUMBER_TABLE
384 , p5_a9 JTF_NUMBER_TABLE
385 , p5_a10 JTF_NUMBER_TABLE
386 , p5_a11 JTF_NUMBER_TABLE
387 , p5_a12 JTF_NUMBER_TABLE
388 , p5_a13 JTF_NUMBER_TABLE
389 , p5_a14 JTF_VARCHAR2_TABLE_2000
390 , p5_a15 JTF_NUMBER_TABLE
391 , p5_a16 JTF_DATE_TABLE
392 , p5_a17 JTF_NUMBER_TABLE
393 , p5_a18 JTF_DATE_TABLE
394 , p5_a19 JTF_NUMBER_TABLE
395 , p5_a20 JTF_NUMBER_TABLE
396 , p5_a21 JTF_NUMBER_TABLE
397 , p5_a22 JTF_NUMBER_TABLE
398 , p5_a23 JTF_NUMBER_TABLE
399 , p5_a24 JTF_NUMBER_TABLE
400 , p5_a25 JTF_NUMBER_TABLE
401 , p5_a26 JTF_NUMBER_TABLE
402 , p5_a27 JTF_VARCHAR2_TABLE_100
403 , p5_a28 JTF_VARCHAR2_TABLE_500
404 , p5_a29 JTF_VARCHAR2_TABLE_500
405 , p5_a30 JTF_VARCHAR2_TABLE_500
406 , p5_a31 JTF_VARCHAR2_TABLE_500
407 , p5_a32 JTF_VARCHAR2_TABLE_500
408 , p5_a33 JTF_VARCHAR2_TABLE_500
409 , p5_a34 JTF_VARCHAR2_TABLE_500
410 , p5_a35 JTF_VARCHAR2_TABLE_500
411 , p5_a36 JTF_VARCHAR2_TABLE_500
412 , p5_a37 JTF_VARCHAR2_TABLE_500
413 , p5_a38 JTF_VARCHAR2_TABLE_500
414 , p5_a39 JTF_VARCHAR2_TABLE_500
415 , p5_a40 JTF_VARCHAR2_TABLE_500
416 , p5_a41 JTF_VARCHAR2_TABLE_500
417 , p5_a42 JTF_VARCHAR2_TABLE_500
418 , p5_a43 JTF_NUMBER_TABLE
419 , p5_a44 JTF_NUMBER_TABLE
420 , p5_a45 JTF_NUMBER_TABLE
421 , p5_a46 JTF_DATE_TABLE
422 , p5_a47 JTF_NUMBER_TABLE
423 , p5_a48 JTF_NUMBER_TABLE
424 , p5_a49 JTF_NUMBER_TABLE
425 , p5_a50 JTF_DATE_TABLE
426 , p5_a51 JTF_NUMBER_TABLE
427 , p5_a52 JTF_DATE_TABLE
428 , p5_a53 JTF_NUMBER_TABLE
429 , p5_a54 JTF_NUMBER_TABLE
430 , p5_a55 JTF_NUMBER_TABLE
431 , p6_a0 out nocopy JTF_NUMBER_TABLE
432 , p6_a1 out nocopy JTF_NUMBER_TABLE
433 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_3000
434 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
435 , p6_a4 out nocopy JTF_NUMBER_TABLE
436 , p6_a5 out nocopy JTF_NUMBER_TABLE
437 , p6_a6 out nocopy JTF_NUMBER_TABLE
438 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
439 , p6_a8 out nocopy JTF_NUMBER_TABLE
440 , p6_a9 out nocopy JTF_NUMBER_TABLE
441 , p6_a10 out nocopy JTF_NUMBER_TABLE
442 , p6_a11 out nocopy JTF_NUMBER_TABLE
443 , p6_a12 out nocopy JTF_NUMBER_TABLE
444 , p6_a13 out nocopy JTF_NUMBER_TABLE
445 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
446 , p6_a15 out nocopy JTF_NUMBER_TABLE
447 , p6_a16 out nocopy JTF_DATE_TABLE
448 , p6_a17 out nocopy JTF_NUMBER_TABLE
449 , p6_a18 out nocopy JTF_DATE_TABLE
450 , p6_a19 out nocopy JTF_NUMBER_TABLE
451 , p6_a20 out nocopy JTF_NUMBER_TABLE
452 , p6_a21 out nocopy JTF_NUMBER_TABLE
453 , p6_a22 out nocopy JTF_NUMBER_TABLE
454 , p6_a23 out nocopy JTF_NUMBER_TABLE
455 , p6_a24 out nocopy JTF_NUMBER_TABLE
456 , p6_a25 out nocopy JTF_NUMBER_TABLE
457 , p6_a26 out nocopy JTF_NUMBER_TABLE
458 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
459 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
460 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
461 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
462 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
463 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
464 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
465 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
466 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
467 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
468 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
469 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
470 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
471 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
472 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
473 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
474 , p6_a43 out nocopy JTF_NUMBER_TABLE
475 , p6_a44 out nocopy JTF_NUMBER_TABLE
476 , p6_a45 out nocopy JTF_NUMBER_TABLE
477 , p6_a46 out nocopy JTF_DATE_TABLE
478 , p6_a47 out nocopy JTF_NUMBER_TABLE
479 , p6_a48 out nocopy JTF_NUMBER_TABLE
480 , p6_a49 out nocopy JTF_NUMBER_TABLE
481 , p6_a50 out nocopy JTF_DATE_TABLE
482 , p6_a51 out nocopy JTF_NUMBER_TABLE
483 , p6_a52 out nocopy JTF_DATE_TABLE
484 , p6_a53 out nocopy JTF_NUMBER_TABLE
485 , p6_a54 out nocopy JTF_NUMBER_TABLE
486 , p6_a55 out nocopy JTF_NUMBER_TABLE
487 );
488 procedure lock_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 VARCHAR2 := fnd_api.g_miss_char
496 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
497 , p5_a4 NUMBER := 0-1962.0724
498 , p5_a5 NUMBER := 0-1962.0724
499 , p5_a6 NUMBER := 0-1962.0724
500 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
501 , p5_a8 NUMBER := 0-1962.0724
502 , p5_a9 NUMBER := 0-1962.0724
503 , p5_a10 NUMBER := 0-1962.0724
504 , p5_a11 NUMBER := 0-1962.0724
505 , p5_a12 NUMBER := 0-1962.0724
506 , p5_a13 NUMBER := 0-1962.0724
507 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
508 , p5_a15 NUMBER := 0-1962.0724
509 , p5_a16 DATE := fnd_api.g_miss_date
510 , p5_a17 NUMBER := 0-1962.0724
511 , p5_a18 DATE := fnd_api.g_miss_date
512 , p5_a19 NUMBER := 0-1962.0724
513 , p5_a20 NUMBER := 0-1962.0724
514 , p5_a21 NUMBER := 0-1962.0724
515 , p5_a22 NUMBER := 0-1962.0724
516 , p5_a23 NUMBER := 0-1962.0724
517 , p5_a24 NUMBER := 0-1962.0724
518 , p5_a25 NUMBER := 0-1962.0724
519 , p5_a26 NUMBER := 0-1962.0724
520 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
521 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
522 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
523 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
524 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
525 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
526 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
527 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
528 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
529 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
530 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
531 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
532 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
533 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
534 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
535 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
536 , p5_a43 NUMBER := 0-1962.0724
537 , p5_a44 NUMBER := 0-1962.0724
538 , p5_a45 NUMBER := 0-1962.0724
539 , p5_a46 DATE := fnd_api.g_miss_date
540 , p5_a47 NUMBER := 0-1962.0724
541 , p5_a48 NUMBER := 0-1962.0724
542 , p5_a49 NUMBER := 0-1962.0724
543 , p5_a50 DATE := fnd_api.g_miss_date
544 , p5_a51 NUMBER := 0-1962.0724
545 , p5_a52 DATE := fnd_api.g_miss_date
546 , p5_a53 NUMBER := 0-1962.0724
547 , p5_a54 NUMBER := 0-1962.0724
548 , p5_a55 NUMBER := 0-1962.0724
549 );
550 procedure lock_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_3000
558 , p5_a3 JTF_VARCHAR2_TABLE_100
559 , p5_a4 JTF_NUMBER_TABLE
560 , p5_a5 JTF_NUMBER_TABLE
561 , p5_a6 JTF_NUMBER_TABLE
562 , p5_a7 JTF_VARCHAR2_TABLE_100
563 , p5_a8 JTF_NUMBER_TABLE
564 , p5_a9 JTF_NUMBER_TABLE
565 , p5_a10 JTF_NUMBER_TABLE
566 , p5_a11 JTF_NUMBER_TABLE
567 , p5_a12 JTF_NUMBER_TABLE
568 , p5_a13 JTF_NUMBER_TABLE
569 , p5_a14 JTF_VARCHAR2_TABLE_2000
570 , p5_a15 JTF_NUMBER_TABLE
571 , p5_a16 JTF_DATE_TABLE
572 , p5_a17 JTF_NUMBER_TABLE
573 , p5_a18 JTF_DATE_TABLE
574 , p5_a19 JTF_NUMBER_TABLE
575 , p5_a20 JTF_NUMBER_TABLE
576 , p5_a21 JTF_NUMBER_TABLE
577 , p5_a22 JTF_NUMBER_TABLE
578 , p5_a23 JTF_NUMBER_TABLE
579 , p5_a24 JTF_NUMBER_TABLE
580 , p5_a25 JTF_NUMBER_TABLE
581 , p5_a26 JTF_NUMBER_TABLE
582 , p5_a27 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_500
587 , p5_a32 JTF_VARCHAR2_TABLE_500
588 , p5_a33 JTF_VARCHAR2_TABLE_500
589 , p5_a34 JTF_VARCHAR2_TABLE_500
590 , p5_a35 JTF_VARCHAR2_TABLE_500
591 , p5_a36 JTF_VARCHAR2_TABLE_500
592 , p5_a37 JTF_VARCHAR2_TABLE_500
593 , p5_a38 JTF_VARCHAR2_TABLE_500
594 , p5_a39 JTF_VARCHAR2_TABLE_500
595 , p5_a40 JTF_VARCHAR2_TABLE_500
596 , p5_a41 JTF_VARCHAR2_TABLE_500
597 , p5_a42 JTF_VARCHAR2_TABLE_500
598 , p5_a43 JTF_NUMBER_TABLE
599 , p5_a44 JTF_NUMBER_TABLE
600 , p5_a45 JTF_NUMBER_TABLE
601 , p5_a46 JTF_DATE_TABLE
602 , p5_a47 JTF_NUMBER_TABLE
603 , p5_a48 JTF_NUMBER_TABLE
604 , p5_a49 JTF_NUMBER_TABLE
605 , p5_a50 JTF_DATE_TABLE
606 , p5_a51 JTF_NUMBER_TABLE
607 , p5_a52 JTF_DATE_TABLE
608 , p5_a53 JTF_NUMBER_TABLE
609 , p5_a54 JTF_NUMBER_TABLE
610 , p5_a55 JTF_NUMBER_TABLE
611 );
612 procedure update_row(p_api_version NUMBER
613 , p_init_msg_list VARCHAR2
614 , x_return_status out nocopy VARCHAR2
615 , x_msg_count out nocopy NUMBER
616 , x_msg_data out nocopy VARCHAR2
617 , p6_a0 out nocopy NUMBER
618 , p6_a1 out nocopy NUMBER
619 , p6_a2 out nocopy VARCHAR2
620 , p6_a3 out nocopy VARCHAR2
621 , p6_a4 out nocopy NUMBER
622 , p6_a5 out nocopy NUMBER
623 , p6_a6 out nocopy NUMBER
624 , p6_a7 out nocopy VARCHAR2
625 , p6_a8 out nocopy NUMBER
626 , p6_a9 out nocopy NUMBER
627 , p6_a10 out nocopy NUMBER
628 , p6_a11 out nocopy NUMBER
629 , p6_a12 out nocopy NUMBER
630 , p6_a13 out nocopy NUMBER
631 , p6_a14 out nocopy VARCHAR2
632 , p6_a15 out nocopy NUMBER
633 , p6_a16 out nocopy DATE
634 , p6_a17 out nocopy NUMBER
635 , p6_a18 out nocopy DATE
636 , p6_a19 out nocopy NUMBER
637 , p6_a20 out nocopy NUMBER
638 , p6_a21 out nocopy NUMBER
639 , p6_a22 out nocopy NUMBER
640 , p6_a23 out nocopy NUMBER
641 , p6_a24 out nocopy NUMBER
642 , p6_a25 out nocopy NUMBER
643 , p6_a26 out nocopy NUMBER
644 , p6_a27 out nocopy VARCHAR2
645 , p6_a28 out nocopy VARCHAR2
646 , p6_a29 out nocopy VARCHAR2
647 , p6_a30 out nocopy VARCHAR2
648 , p6_a31 out nocopy VARCHAR2
649 , p6_a32 out nocopy VARCHAR2
650 , p6_a33 out nocopy VARCHAR2
651 , p6_a34 out nocopy VARCHAR2
652 , p6_a35 out nocopy VARCHAR2
653 , p6_a36 out nocopy VARCHAR2
654 , p6_a37 out nocopy VARCHAR2
655 , p6_a38 out nocopy VARCHAR2
656 , p6_a39 out nocopy VARCHAR2
657 , p6_a40 out nocopy VARCHAR2
658 , p6_a41 out nocopy VARCHAR2
659 , p6_a42 out nocopy VARCHAR2
660 , p6_a43 out nocopy NUMBER
661 , p6_a44 out nocopy NUMBER
662 , p6_a45 out nocopy NUMBER
663 , p6_a46 out nocopy DATE
664 , p6_a47 out nocopy NUMBER
665 , p6_a48 out nocopy NUMBER
666 , p6_a49 out nocopy NUMBER
667 , p6_a50 out nocopy DATE
668 , p6_a51 out nocopy NUMBER
669 , p6_a52 out nocopy DATE
670 , p6_a53 out nocopy NUMBER
671 , p6_a54 out nocopy NUMBER
672 , p6_a55 out nocopy NUMBER
673 , p5_a0 NUMBER := 0-1962.0724
674 , p5_a1 NUMBER := 0-1962.0724
675 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
676 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
677 , p5_a4 NUMBER := 0-1962.0724
678 , p5_a5 NUMBER := 0-1962.0724
679 , p5_a6 NUMBER := 0-1962.0724
680 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
681 , p5_a8 NUMBER := 0-1962.0724
682 , p5_a9 NUMBER := 0-1962.0724
683 , p5_a10 NUMBER := 0-1962.0724
684 , p5_a11 NUMBER := 0-1962.0724
685 , p5_a12 NUMBER := 0-1962.0724
686 , p5_a13 NUMBER := 0-1962.0724
687 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
688 , p5_a15 NUMBER := 0-1962.0724
689 , p5_a16 DATE := fnd_api.g_miss_date
690 , p5_a17 NUMBER := 0-1962.0724
691 , p5_a18 DATE := fnd_api.g_miss_date
692 , p5_a19 NUMBER := 0-1962.0724
693 , p5_a20 NUMBER := 0-1962.0724
694 , p5_a21 NUMBER := 0-1962.0724
695 , p5_a22 NUMBER := 0-1962.0724
696 , p5_a23 NUMBER := 0-1962.0724
697 , p5_a24 NUMBER := 0-1962.0724
698 , p5_a25 NUMBER := 0-1962.0724
699 , p5_a26 NUMBER := 0-1962.0724
700 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
701 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
702 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
703 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
704 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
705 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
706 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
707 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
708 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
709 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
710 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
711 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
712 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
713 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
714 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
715 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
716 , p5_a43 NUMBER := 0-1962.0724
717 , p5_a44 NUMBER := 0-1962.0724
718 , p5_a45 NUMBER := 0-1962.0724
719 , p5_a46 DATE := fnd_api.g_miss_date
720 , p5_a47 NUMBER := 0-1962.0724
721 , p5_a48 NUMBER := 0-1962.0724
722 , p5_a49 NUMBER := 0-1962.0724
723 , p5_a50 DATE := fnd_api.g_miss_date
724 , p5_a51 NUMBER := 0-1962.0724
725 , p5_a52 DATE := fnd_api.g_miss_date
726 , p5_a53 NUMBER := 0-1962.0724
727 , p5_a54 NUMBER := 0-1962.0724
728 , p5_a55 NUMBER := 0-1962.0724
729 );
730 procedure update_row(p_api_version NUMBER
731 , p_init_msg_list VARCHAR2
732 , x_return_status out nocopy VARCHAR2
733 , x_msg_count out nocopy NUMBER
734 , x_msg_data out nocopy VARCHAR2
735 , p5_a0 JTF_NUMBER_TABLE
736 , p5_a1 JTF_NUMBER_TABLE
737 , p5_a2 JTF_VARCHAR2_TABLE_3000
738 , p5_a3 JTF_VARCHAR2_TABLE_100
739 , p5_a4 JTF_NUMBER_TABLE
740 , p5_a5 JTF_NUMBER_TABLE
741 , p5_a6 JTF_NUMBER_TABLE
742 , p5_a7 JTF_VARCHAR2_TABLE_100
743 , p5_a8 JTF_NUMBER_TABLE
744 , p5_a9 JTF_NUMBER_TABLE
745 , p5_a10 JTF_NUMBER_TABLE
746 , p5_a11 JTF_NUMBER_TABLE
747 , p5_a12 JTF_NUMBER_TABLE
748 , p5_a13 JTF_NUMBER_TABLE
749 , p5_a14 JTF_VARCHAR2_TABLE_2000
750 , p5_a15 JTF_NUMBER_TABLE
751 , p5_a16 JTF_DATE_TABLE
752 , p5_a17 JTF_NUMBER_TABLE
753 , p5_a18 JTF_DATE_TABLE
754 , p5_a19 JTF_NUMBER_TABLE
755 , p5_a20 JTF_NUMBER_TABLE
756 , p5_a21 JTF_NUMBER_TABLE
757 , p5_a22 JTF_NUMBER_TABLE
758 , p5_a23 JTF_NUMBER_TABLE
759 , p5_a24 JTF_NUMBER_TABLE
760 , p5_a25 JTF_NUMBER_TABLE
761 , p5_a26 JTF_NUMBER_TABLE
762 , p5_a27 JTF_VARCHAR2_TABLE_100
763 , p5_a28 JTF_VARCHAR2_TABLE_500
764 , p5_a29 JTF_VARCHAR2_TABLE_500
765 , p5_a30 JTF_VARCHAR2_TABLE_500
766 , p5_a31 JTF_VARCHAR2_TABLE_500
767 , p5_a32 JTF_VARCHAR2_TABLE_500
768 , p5_a33 JTF_VARCHAR2_TABLE_500
769 , p5_a34 JTF_VARCHAR2_TABLE_500
770 , p5_a35 JTF_VARCHAR2_TABLE_500
771 , p5_a36 JTF_VARCHAR2_TABLE_500
772 , p5_a37 JTF_VARCHAR2_TABLE_500
773 , p5_a38 JTF_VARCHAR2_TABLE_500
774 , p5_a39 JTF_VARCHAR2_TABLE_500
775 , p5_a40 JTF_VARCHAR2_TABLE_500
776 , p5_a41 JTF_VARCHAR2_TABLE_500
777 , p5_a42 JTF_VARCHAR2_TABLE_500
778 , p5_a43 JTF_NUMBER_TABLE
779 , p5_a44 JTF_NUMBER_TABLE
780 , p5_a45 JTF_NUMBER_TABLE
781 , p5_a46 JTF_DATE_TABLE
782 , p5_a47 JTF_NUMBER_TABLE
783 , p5_a48 JTF_NUMBER_TABLE
784 , p5_a49 JTF_NUMBER_TABLE
785 , p5_a50 JTF_DATE_TABLE
786 , p5_a51 JTF_NUMBER_TABLE
787 , p5_a52 JTF_DATE_TABLE
788 , p5_a53 JTF_NUMBER_TABLE
789 , p5_a54 JTF_NUMBER_TABLE
790 , p5_a55 JTF_NUMBER_TABLE
791 , p6_a0 out nocopy JTF_NUMBER_TABLE
792 , p6_a1 out nocopy JTF_NUMBER_TABLE
793 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_3000
794 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
795 , p6_a4 out nocopy JTF_NUMBER_TABLE
796 , p6_a5 out nocopy JTF_NUMBER_TABLE
797 , p6_a6 out nocopy JTF_NUMBER_TABLE
798 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
799 , p6_a8 out nocopy JTF_NUMBER_TABLE
800 , p6_a9 out nocopy JTF_NUMBER_TABLE
801 , p6_a10 out nocopy JTF_NUMBER_TABLE
802 , p6_a11 out nocopy JTF_NUMBER_TABLE
803 , p6_a12 out nocopy JTF_NUMBER_TABLE
804 , p6_a13 out nocopy JTF_NUMBER_TABLE
805 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_2000
806 , p6_a15 out nocopy JTF_NUMBER_TABLE
807 , p6_a16 out nocopy JTF_DATE_TABLE
808 , p6_a17 out nocopy JTF_NUMBER_TABLE
809 , p6_a18 out nocopy JTF_DATE_TABLE
810 , p6_a19 out nocopy JTF_NUMBER_TABLE
811 , p6_a20 out nocopy JTF_NUMBER_TABLE
812 , p6_a21 out nocopy JTF_NUMBER_TABLE
813 , p6_a22 out nocopy JTF_NUMBER_TABLE
814 , p6_a23 out nocopy JTF_NUMBER_TABLE
815 , p6_a24 out nocopy JTF_NUMBER_TABLE
816 , p6_a25 out nocopy JTF_NUMBER_TABLE
817 , p6_a26 out nocopy JTF_NUMBER_TABLE
818 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
819 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
820 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
821 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
822 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
823 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
824 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
825 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
826 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
827 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
828 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
829 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_500
830 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_500
831 , p6_a40 out nocopy JTF_VARCHAR2_TABLE_500
832 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
833 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
834 , p6_a43 out nocopy JTF_NUMBER_TABLE
835 , p6_a44 out nocopy JTF_NUMBER_TABLE
836 , p6_a45 out nocopy JTF_NUMBER_TABLE
837 , p6_a46 out nocopy JTF_DATE_TABLE
838 , p6_a47 out nocopy JTF_NUMBER_TABLE
839 , p6_a48 out nocopy JTF_NUMBER_TABLE
840 , p6_a49 out nocopy JTF_NUMBER_TABLE
841 , p6_a50 out nocopy JTF_DATE_TABLE
842 , p6_a51 out nocopy JTF_NUMBER_TABLE
843 , p6_a52 out nocopy JTF_DATE_TABLE
844 , p6_a53 out nocopy JTF_NUMBER_TABLE
845 , p6_a54 out nocopy JTF_NUMBER_TABLE
846 , p6_a55 out nocopy JTF_NUMBER_TABLE
847 );
848 procedure delete_row(p_api_version NUMBER
849 , p_init_msg_list VARCHAR2
850 , x_return_status out nocopy VARCHAR2
851 , x_msg_count out nocopy NUMBER
852 , x_msg_data out nocopy VARCHAR2
853 , p5_a0 NUMBER := 0-1962.0724
854 , p5_a1 NUMBER := 0-1962.0724
855 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
856 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
857 , p5_a4 NUMBER := 0-1962.0724
858 , p5_a5 NUMBER := 0-1962.0724
859 , p5_a6 NUMBER := 0-1962.0724
860 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
861 , p5_a8 NUMBER := 0-1962.0724
862 , p5_a9 NUMBER := 0-1962.0724
863 , p5_a10 NUMBER := 0-1962.0724
864 , p5_a11 NUMBER := 0-1962.0724
865 , p5_a12 NUMBER := 0-1962.0724
866 , p5_a13 NUMBER := 0-1962.0724
867 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
868 , p5_a15 NUMBER := 0-1962.0724
869 , p5_a16 DATE := fnd_api.g_miss_date
870 , p5_a17 NUMBER := 0-1962.0724
871 , p5_a18 DATE := fnd_api.g_miss_date
872 , p5_a19 NUMBER := 0-1962.0724
873 , p5_a20 NUMBER := 0-1962.0724
874 , p5_a21 NUMBER := 0-1962.0724
875 , p5_a22 NUMBER := 0-1962.0724
876 , p5_a23 NUMBER := 0-1962.0724
877 , p5_a24 NUMBER := 0-1962.0724
878 , p5_a25 NUMBER := 0-1962.0724
879 , p5_a26 NUMBER := 0-1962.0724
880 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
881 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
882 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
883 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
884 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
885 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
886 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
887 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
888 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
889 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
890 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
891 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
892 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
893 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
894 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
895 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
896 , p5_a43 NUMBER := 0-1962.0724
897 , p5_a44 NUMBER := 0-1962.0724
898 , p5_a45 NUMBER := 0-1962.0724
899 , p5_a46 DATE := fnd_api.g_miss_date
900 , p5_a47 NUMBER := 0-1962.0724
901 , p5_a48 NUMBER := 0-1962.0724
902 , p5_a49 NUMBER := 0-1962.0724
903 , p5_a50 DATE := fnd_api.g_miss_date
904 , p5_a51 NUMBER := 0-1962.0724
905 , p5_a52 DATE := fnd_api.g_miss_date
906 , p5_a53 NUMBER := 0-1962.0724
907 , p5_a54 NUMBER := 0-1962.0724
908 , p5_a55 NUMBER := 0-1962.0724
909 );
910 procedure delete_row(p_api_version NUMBER
911 , p_init_msg_list VARCHAR2
912 , x_return_status out nocopy VARCHAR2
913 , x_msg_count out nocopy NUMBER
914 , x_msg_data out nocopy VARCHAR2
915 , p5_a0 JTF_NUMBER_TABLE
916 , p5_a1 JTF_NUMBER_TABLE
917 , p5_a2 JTF_VARCHAR2_TABLE_3000
918 , p5_a3 JTF_VARCHAR2_TABLE_100
919 , p5_a4 JTF_NUMBER_TABLE
920 , p5_a5 JTF_NUMBER_TABLE
921 , p5_a6 JTF_NUMBER_TABLE
922 , p5_a7 JTF_VARCHAR2_TABLE_100
923 , p5_a8 JTF_NUMBER_TABLE
924 , p5_a9 JTF_NUMBER_TABLE
925 , p5_a10 JTF_NUMBER_TABLE
926 , p5_a11 JTF_NUMBER_TABLE
927 , p5_a12 JTF_NUMBER_TABLE
928 , p5_a13 JTF_NUMBER_TABLE
929 , p5_a14 JTF_VARCHAR2_TABLE_2000
930 , p5_a15 JTF_NUMBER_TABLE
931 , p5_a16 JTF_DATE_TABLE
932 , p5_a17 JTF_NUMBER_TABLE
933 , p5_a18 JTF_DATE_TABLE
934 , p5_a19 JTF_NUMBER_TABLE
935 , p5_a20 JTF_NUMBER_TABLE
936 , p5_a21 JTF_NUMBER_TABLE
937 , p5_a22 JTF_NUMBER_TABLE
938 , p5_a23 JTF_NUMBER_TABLE
939 , p5_a24 JTF_NUMBER_TABLE
940 , p5_a25 JTF_NUMBER_TABLE
941 , p5_a26 JTF_NUMBER_TABLE
942 , p5_a27 JTF_VARCHAR2_TABLE_100
943 , p5_a28 JTF_VARCHAR2_TABLE_500
944 , p5_a29 JTF_VARCHAR2_TABLE_500
945 , p5_a30 JTF_VARCHAR2_TABLE_500
946 , p5_a31 JTF_VARCHAR2_TABLE_500
947 , p5_a32 JTF_VARCHAR2_TABLE_500
948 , p5_a33 JTF_VARCHAR2_TABLE_500
949 , p5_a34 JTF_VARCHAR2_TABLE_500
950 , p5_a35 JTF_VARCHAR2_TABLE_500
951 , p5_a36 JTF_VARCHAR2_TABLE_500
952 , p5_a37 JTF_VARCHAR2_TABLE_500
953 , p5_a38 JTF_VARCHAR2_TABLE_500
954 , p5_a39 JTF_VARCHAR2_TABLE_500
955 , p5_a40 JTF_VARCHAR2_TABLE_500
956 , p5_a41 JTF_VARCHAR2_TABLE_500
957 , p5_a42 JTF_VARCHAR2_TABLE_500
958 , p5_a43 JTF_NUMBER_TABLE
959 , p5_a44 JTF_NUMBER_TABLE
960 , p5_a45 JTF_NUMBER_TABLE
961 , p5_a46 JTF_DATE_TABLE
962 , p5_a47 JTF_NUMBER_TABLE
963 , p5_a48 JTF_NUMBER_TABLE
964 , p5_a49 JTF_NUMBER_TABLE
965 , p5_a50 JTF_DATE_TABLE
966 , p5_a51 JTF_NUMBER_TABLE
967 , p5_a52 JTF_DATE_TABLE
968 , p5_a53 JTF_NUMBER_TABLE
969 , p5_a54 JTF_NUMBER_TABLE
970 , p5_a55 JTF_NUMBER_TABLE
971 );
972 procedure validate_row(p_api_version NUMBER
973 , p_init_msg_list VARCHAR2
974 , x_return_status out nocopy VARCHAR2
975 , x_msg_count out nocopy NUMBER
976 , x_msg_data out nocopy VARCHAR2
977 , p5_a0 NUMBER := 0-1962.0724
978 , p5_a1 NUMBER := 0-1962.0724
979 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
980 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
981 , p5_a4 NUMBER := 0-1962.0724
982 , p5_a5 NUMBER := 0-1962.0724
983 , p5_a6 NUMBER := 0-1962.0724
984 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
985 , p5_a8 NUMBER := 0-1962.0724
986 , p5_a9 NUMBER := 0-1962.0724
987 , p5_a10 NUMBER := 0-1962.0724
988 , p5_a11 NUMBER := 0-1962.0724
989 , p5_a12 NUMBER := 0-1962.0724
990 , p5_a13 NUMBER := 0-1962.0724
991 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
992 , p5_a15 NUMBER := 0-1962.0724
993 , p5_a16 DATE := fnd_api.g_miss_date
994 , p5_a17 NUMBER := 0-1962.0724
995 , p5_a18 DATE := fnd_api.g_miss_date
996 , p5_a19 NUMBER := 0-1962.0724
997 , p5_a20 NUMBER := 0-1962.0724
998 , p5_a21 NUMBER := 0-1962.0724
999 , p5_a22 NUMBER := 0-1962.0724
1000 , p5_a23 NUMBER := 0-1962.0724
1001 , p5_a24 NUMBER := 0-1962.0724
1002 , p5_a25 NUMBER := 0-1962.0724
1003 , p5_a26 NUMBER := 0-1962.0724
1004 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1005 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1006 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1007 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1008 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1009 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1010 , p5_a33 VARCHAR2 := fnd_api.g_miss_char
1011 , p5_a34 VARCHAR2 := fnd_api.g_miss_char
1012 , p5_a35 VARCHAR2 := fnd_api.g_miss_char
1013 , p5_a36 VARCHAR2 := fnd_api.g_miss_char
1014 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1015 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1016 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1017 , p5_a40 VARCHAR2 := fnd_api.g_miss_char
1018 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1019 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1020 , p5_a43 NUMBER := 0-1962.0724
1021 , p5_a44 NUMBER := 0-1962.0724
1022 , p5_a45 NUMBER := 0-1962.0724
1023 , p5_a46 DATE := fnd_api.g_miss_date
1024 , p5_a47 NUMBER := 0-1962.0724
1025 , p5_a48 NUMBER := 0-1962.0724
1026 , p5_a49 NUMBER := 0-1962.0724
1027 , p5_a50 DATE := fnd_api.g_miss_date
1028 , p5_a51 NUMBER := 0-1962.0724
1029 , p5_a52 DATE := fnd_api.g_miss_date
1030 , p5_a53 NUMBER := 0-1962.0724
1031 , p5_a54 NUMBER := 0-1962.0724
1032 , p5_a55 NUMBER := 0-1962.0724
1033 );
1034 procedure validate_row(p_api_version NUMBER
1035 , p_init_msg_list VARCHAR2
1036 , x_return_status out nocopy VARCHAR2
1037 , x_msg_count out nocopy NUMBER
1038 , x_msg_data out nocopy VARCHAR2
1039 , p5_a0 JTF_NUMBER_TABLE
1040 , p5_a1 JTF_NUMBER_TABLE
1041 , p5_a2 JTF_VARCHAR2_TABLE_3000
1042 , p5_a3 JTF_VARCHAR2_TABLE_100
1043 , p5_a4 JTF_NUMBER_TABLE
1044 , p5_a5 JTF_NUMBER_TABLE
1045 , p5_a6 JTF_NUMBER_TABLE
1046 , p5_a7 JTF_VARCHAR2_TABLE_100
1047 , p5_a8 JTF_NUMBER_TABLE
1048 , p5_a9 JTF_NUMBER_TABLE
1049 , p5_a10 JTF_NUMBER_TABLE
1050 , p5_a11 JTF_NUMBER_TABLE
1051 , p5_a12 JTF_NUMBER_TABLE
1052 , p5_a13 JTF_NUMBER_TABLE
1053 , p5_a14 JTF_VARCHAR2_TABLE_2000
1054 , p5_a15 JTF_NUMBER_TABLE
1055 , p5_a16 JTF_DATE_TABLE
1056 , p5_a17 JTF_NUMBER_TABLE
1057 , p5_a18 JTF_DATE_TABLE
1058 , p5_a19 JTF_NUMBER_TABLE
1059 , p5_a20 JTF_NUMBER_TABLE
1060 , p5_a21 JTF_NUMBER_TABLE
1061 , p5_a22 JTF_NUMBER_TABLE
1062 , p5_a23 JTF_NUMBER_TABLE
1063 , p5_a24 JTF_NUMBER_TABLE
1064 , p5_a25 JTF_NUMBER_TABLE
1065 , p5_a26 JTF_NUMBER_TABLE
1066 , p5_a27 JTF_VARCHAR2_TABLE_100
1067 , p5_a28 JTF_VARCHAR2_TABLE_500
1068 , p5_a29 JTF_VARCHAR2_TABLE_500
1069 , p5_a30 JTF_VARCHAR2_TABLE_500
1070 , p5_a31 JTF_VARCHAR2_TABLE_500
1071 , p5_a32 JTF_VARCHAR2_TABLE_500
1072 , p5_a33 JTF_VARCHAR2_TABLE_500
1073 , p5_a34 JTF_VARCHAR2_TABLE_500
1074 , p5_a35 JTF_VARCHAR2_TABLE_500
1075 , p5_a36 JTF_VARCHAR2_TABLE_500
1076 , p5_a37 JTF_VARCHAR2_TABLE_500
1077 , p5_a38 JTF_VARCHAR2_TABLE_500
1078 , p5_a39 JTF_VARCHAR2_TABLE_500
1079 , p5_a40 JTF_VARCHAR2_TABLE_500
1080 , p5_a41 JTF_VARCHAR2_TABLE_500
1081 , p5_a42 JTF_VARCHAR2_TABLE_500
1082 , p5_a43 JTF_NUMBER_TABLE
1083 , p5_a44 JTF_NUMBER_TABLE
1084 , p5_a45 JTF_NUMBER_TABLE
1085 , p5_a46 JTF_DATE_TABLE
1086 , p5_a47 JTF_NUMBER_TABLE
1087 , p5_a48 JTF_NUMBER_TABLE
1088 , p5_a49 JTF_NUMBER_TABLE
1089 , p5_a50 JTF_DATE_TABLE
1090 , p5_a51 JTF_NUMBER_TABLE
1091 , p5_a52 JTF_DATE_TABLE
1092 , p5_a53 JTF_NUMBER_TABLE
1093 , p5_a54 JTF_NUMBER_TABLE
1094 , p5_a55 JTF_NUMBER_TABLE
1095 );
1096 end okl_til_pvt_w;