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