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