[Home] [Help]
PACKAGE: APPS.OKL_CRT_PVT_W
Source
1 package okl_crt_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLICRTS.pls 115.2 2003/10/07 17:58:10 pdevaraj noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy okl_crt_pvt.crtv_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_200
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_DATE_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_2000
12 , a9 JTF_DATE_TABLE
13 , a10 JTF_VARCHAR2_TABLE_100
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_NUMBER_TABLE
18 , a15 JTF_NUMBER_TABLE
19 , a16 JTF_DATE_TABLE
20 , a17 JTF_VARCHAR2_TABLE_300
21 , a18 JTF_VARCHAR2_TABLE_300
22 , a19 JTF_VARCHAR2_TABLE_300
23 , a20 JTF_VARCHAR2_TABLE_300
24 , a21 JTF_VARCHAR2_TABLE_300
25 , a22 JTF_VARCHAR2_TABLE_300
26 , a23 JTF_VARCHAR2_TABLE_300
27 , a24 JTF_VARCHAR2_TABLE_300
28 , a25 JTF_VARCHAR2_TABLE_300
29 , a26 JTF_VARCHAR2_TABLE_300
30 , a27 JTF_VARCHAR2_TABLE_300
31 , a28 JTF_VARCHAR2_TABLE_300
32 , a29 JTF_VARCHAR2_TABLE_300
33 , a30 JTF_VARCHAR2_TABLE_300
34 , a31 JTF_VARCHAR2_TABLE_300
35 , a32 JTF_VARCHAR2_TABLE_300
36 , a33 JTF_NUMBER_TABLE
37 , a34 JTF_DATE_TABLE
38 , a35 JTF_NUMBER_TABLE
39 , a36 JTF_DATE_TABLE
40 , a37 JTF_NUMBER_TABLE
41 );
42 procedure rosetta_table_copy_out_p2(t okl_crt_pvt.crtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43 , a1 out nocopy JTF_VARCHAR2_TABLE_200
44 , a2 out nocopy JTF_VARCHAR2_TABLE_100
45 , a3 out nocopy JTF_DATE_TABLE
46 , a4 out nocopy JTF_NUMBER_TABLE
47 , a5 out nocopy JTF_NUMBER_TABLE
48 , a6 out nocopy JTF_NUMBER_TABLE
49 , a7 out nocopy JTF_VARCHAR2_TABLE_100
50 , a8 out nocopy JTF_VARCHAR2_TABLE_2000
51 , a9 out nocopy JTF_DATE_TABLE
52 , a10 out nocopy JTF_VARCHAR2_TABLE_100
53 , a11 out nocopy JTF_NUMBER_TABLE
54 , a12 out nocopy JTF_NUMBER_TABLE
55 , a13 out nocopy JTF_NUMBER_TABLE
56 , a14 out nocopy JTF_NUMBER_TABLE
57 , a15 out nocopy JTF_NUMBER_TABLE
58 , a16 out nocopy JTF_DATE_TABLE
59 , a17 out nocopy JTF_VARCHAR2_TABLE_300
60 , a18 out nocopy JTF_VARCHAR2_TABLE_300
61 , a19 out nocopy JTF_VARCHAR2_TABLE_300
62 , a20 out nocopy JTF_VARCHAR2_TABLE_300
63 , a21 out nocopy JTF_VARCHAR2_TABLE_300
64 , a22 out nocopy JTF_VARCHAR2_TABLE_300
65 , a23 out nocopy JTF_VARCHAR2_TABLE_300
66 , a24 out nocopy JTF_VARCHAR2_TABLE_300
67 , a25 out nocopy JTF_VARCHAR2_TABLE_300
68 , a26 out nocopy JTF_VARCHAR2_TABLE_300
69 , a27 out nocopy JTF_VARCHAR2_TABLE_300
70 , a28 out nocopy JTF_VARCHAR2_TABLE_300
71 , a29 out nocopy JTF_VARCHAR2_TABLE_300
72 , a30 out nocopy JTF_VARCHAR2_TABLE_300
73 , a31 out nocopy JTF_VARCHAR2_TABLE_300
74 , a32 out nocopy JTF_VARCHAR2_TABLE_300
75 , a33 out nocopy JTF_NUMBER_TABLE
76 , a34 out nocopy JTF_DATE_TABLE
77 , a35 out nocopy JTF_NUMBER_TABLE
78 , a36 out nocopy JTF_DATE_TABLE
79 , a37 out nocopy JTF_NUMBER_TABLE
80 );
81
82 procedure rosetta_table_copy_in_p5(t out nocopy okl_crt_pvt.crt_tbl_type, a0 JTF_NUMBER_TABLE
83 , a1 JTF_VARCHAR2_TABLE_200
84 , a2 JTF_VARCHAR2_TABLE_100
85 , a3 JTF_DATE_TABLE
86 , a4 JTF_NUMBER_TABLE
87 , a5 JTF_NUMBER_TABLE
88 , a6 JTF_NUMBER_TABLE
89 , a7 JTF_VARCHAR2_TABLE_100
90 , a8 JTF_VARCHAR2_TABLE_2000
91 , a9 JTF_DATE_TABLE
92 , a10 JTF_NUMBER_TABLE
93 , a11 JTF_NUMBER_TABLE
94 , a12 JTF_NUMBER_TABLE
95 , a13 JTF_NUMBER_TABLE
96 , a14 JTF_NUMBER_TABLE
97 , a15 JTF_VARCHAR2_TABLE_100
98 , a16 JTF_DATE_TABLE
99 , a17 JTF_VARCHAR2_TABLE_300
100 , a18 JTF_VARCHAR2_TABLE_300
101 , a19 JTF_VARCHAR2_TABLE_300
102 , a20 JTF_VARCHAR2_TABLE_300
103 , a21 JTF_VARCHAR2_TABLE_300
104 , a22 JTF_VARCHAR2_TABLE_300
105 , a23 JTF_VARCHAR2_TABLE_300
106 , a24 JTF_VARCHAR2_TABLE_300
107 , a25 JTF_VARCHAR2_TABLE_300
108 , a26 JTF_VARCHAR2_TABLE_300
109 , a27 JTF_VARCHAR2_TABLE_300
110 , a28 JTF_VARCHAR2_TABLE_300
111 , a29 JTF_VARCHAR2_TABLE_300
112 , a30 JTF_VARCHAR2_TABLE_300
113 , a31 JTF_VARCHAR2_TABLE_300
114 , a32 JTF_VARCHAR2_TABLE_300
115 , a33 JTF_NUMBER_TABLE
116 , a34 JTF_DATE_TABLE
117 , a35 JTF_NUMBER_TABLE
118 , a36 JTF_DATE_TABLE
119 , a37 JTF_NUMBER_TABLE
120 );
121 procedure rosetta_table_copy_out_p5(t okl_crt_pvt.crt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
122 , a1 out nocopy JTF_VARCHAR2_TABLE_200
123 , a2 out nocopy JTF_VARCHAR2_TABLE_100
124 , a3 out nocopy JTF_DATE_TABLE
125 , a4 out nocopy JTF_NUMBER_TABLE
126 , a5 out nocopy JTF_NUMBER_TABLE
127 , a6 out nocopy JTF_NUMBER_TABLE
128 , a7 out nocopy JTF_VARCHAR2_TABLE_100
129 , a8 out nocopy JTF_VARCHAR2_TABLE_2000
130 , a9 out nocopy JTF_DATE_TABLE
131 , a10 out nocopy JTF_NUMBER_TABLE
132 , a11 out nocopy JTF_NUMBER_TABLE
133 , a12 out nocopy JTF_NUMBER_TABLE
134 , a13 out nocopy JTF_NUMBER_TABLE
135 , a14 out nocopy JTF_NUMBER_TABLE
136 , a15 out nocopy JTF_VARCHAR2_TABLE_100
137 , a16 out nocopy JTF_DATE_TABLE
138 , a17 out nocopy JTF_VARCHAR2_TABLE_300
139 , a18 out nocopy JTF_VARCHAR2_TABLE_300
140 , a19 out nocopy JTF_VARCHAR2_TABLE_300
141 , a20 out nocopy JTF_VARCHAR2_TABLE_300
142 , a21 out nocopy JTF_VARCHAR2_TABLE_300
143 , a22 out nocopy JTF_VARCHAR2_TABLE_300
144 , a23 out nocopy JTF_VARCHAR2_TABLE_300
145 , a24 out nocopy JTF_VARCHAR2_TABLE_300
146 , a25 out nocopy JTF_VARCHAR2_TABLE_300
147 , a26 out nocopy JTF_VARCHAR2_TABLE_300
148 , a27 out nocopy JTF_VARCHAR2_TABLE_300
149 , a28 out nocopy JTF_VARCHAR2_TABLE_300
150 , a29 out nocopy JTF_VARCHAR2_TABLE_300
151 , a30 out nocopy JTF_VARCHAR2_TABLE_300
152 , a31 out nocopy JTF_VARCHAR2_TABLE_300
153 , a32 out nocopy JTF_VARCHAR2_TABLE_300
154 , a33 out nocopy JTF_NUMBER_TABLE
155 , a34 out nocopy JTF_DATE_TABLE
156 , a35 out nocopy JTF_NUMBER_TABLE
157 , a36 out nocopy JTF_DATE_TABLE
158 , a37 out nocopy JTF_NUMBER_TABLE
159 );
160
161 procedure insert_row(p_api_version NUMBER
162 , p_init_msg_list VARCHAR2
163 , x_return_status out nocopy VARCHAR2
164 , x_msg_count out nocopy NUMBER
165 , x_msg_data out nocopy VARCHAR2
166 , p6_a0 out nocopy NUMBER
167 , p6_a1 out nocopy VARCHAR2
168 , p6_a2 out nocopy VARCHAR2
169 , p6_a3 out nocopy DATE
170 , p6_a4 out nocopy NUMBER
171 , p6_a5 out nocopy NUMBER
172 , p6_a6 out nocopy NUMBER
173 , p6_a7 out nocopy VARCHAR2
174 , p6_a8 out nocopy VARCHAR2
175 , p6_a9 out nocopy DATE
176 , p6_a10 out nocopy VARCHAR2
177 , p6_a11 out nocopy NUMBER
178 , p6_a12 out nocopy NUMBER
179 , p6_a13 out nocopy NUMBER
180 , p6_a14 out nocopy NUMBER
181 , p6_a15 out nocopy NUMBER
182 , p6_a16 out nocopy DATE
183 , p6_a17 out nocopy VARCHAR2
184 , p6_a18 out nocopy VARCHAR2
185 , p6_a19 out nocopy VARCHAR2
186 , p6_a20 out nocopy VARCHAR2
187 , p6_a21 out nocopy VARCHAR2
188 , p6_a22 out nocopy VARCHAR2
189 , p6_a23 out nocopy VARCHAR2
190 , p6_a24 out nocopy VARCHAR2
191 , p6_a25 out nocopy VARCHAR2
192 , p6_a26 out nocopy VARCHAR2
193 , p6_a27 out nocopy VARCHAR2
194 , p6_a28 out nocopy VARCHAR2
195 , p6_a29 out nocopy VARCHAR2
196 , p6_a30 out nocopy VARCHAR2
197 , p6_a31 out nocopy VARCHAR2
198 , p6_a32 out nocopy VARCHAR2
199 , p6_a33 out nocopy NUMBER
200 , p6_a34 out nocopy DATE
201 , p6_a35 out nocopy NUMBER
202 , p6_a36 out nocopy DATE
203 , p6_a37 out nocopy NUMBER
204 , p5_a0 NUMBER := 0-1962.0724
205 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
206 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
207 , p5_a3 DATE := fnd_api.g_miss_date
208 , p5_a4 NUMBER := 0-1962.0724
209 , p5_a5 NUMBER := 0-1962.0724
210 , p5_a6 NUMBER := 0-1962.0724
211 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
212 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
213 , p5_a9 DATE := fnd_api.g_miss_date
214 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
215 , p5_a11 NUMBER := 0-1962.0724
216 , p5_a12 NUMBER := 0-1962.0724
217 , p5_a13 NUMBER := 0-1962.0724
218 , p5_a14 NUMBER := 0-1962.0724
219 , p5_a15 NUMBER := 0-1962.0724
220 , p5_a16 DATE := fnd_api.g_miss_date
221 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
222 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
223 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
224 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
225 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
226 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
227 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
228 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
229 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
230 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
231 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
232 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
233 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
234 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
235 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
236 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
237 , p5_a33 NUMBER := 0-1962.0724
238 , p5_a34 DATE := fnd_api.g_miss_date
239 , p5_a35 NUMBER := 0-1962.0724
240 , p5_a36 DATE := fnd_api.g_miss_date
241 , p5_a37 NUMBER := 0-1962.0724
242 );
243 procedure insert_row(p_api_version NUMBER
244 , p_init_msg_list VARCHAR2
245 , x_return_status out nocopy VARCHAR2
246 , x_msg_count out nocopy NUMBER
247 , x_msg_data out nocopy VARCHAR2
248 , p5_a0 JTF_NUMBER_TABLE
249 , p5_a1 JTF_VARCHAR2_TABLE_200
250 , p5_a2 JTF_VARCHAR2_TABLE_100
251 , p5_a3 JTF_DATE_TABLE
252 , p5_a4 JTF_NUMBER_TABLE
253 , p5_a5 JTF_NUMBER_TABLE
254 , p5_a6 JTF_NUMBER_TABLE
255 , p5_a7 JTF_VARCHAR2_TABLE_100
256 , p5_a8 JTF_VARCHAR2_TABLE_2000
257 , p5_a9 JTF_DATE_TABLE
258 , p5_a10 JTF_VARCHAR2_TABLE_100
259 , p5_a11 JTF_NUMBER_TABLE
260 , p5_a12 JTF_NUMBER_TABLE
261 , p5_a13 JTF_NUMBER_TABLE
262 , p5_a14 JTF_NUMBER_TABLE
263 , p5_a15 JTF_NUMBER_TABLE
264 , p5_a16 JTF_DATE_TABLE
265 , p5_a17 JTF_VARCHAR2_TABLE_300
266 , p5_a18 JTF_VARCHAR2_TABLE_300
267 , p5_a19 JTF_VARCHAR2_TABLE_300
268 , p5_a20 JTF_VARCHAR2_TABLE_300
269 , p5_a21 JTF_VARCHAR2_TABLE_300
270 , p5_a22 JTF_VARCHAR2_TABLE_300
271 , p5_a23 JTF_VARCHAR2_TABLE_300
272 , p5_a24 JTF_VARCHAR2_TABLE_300
273 , p5_a25 JTF_VARCHAR2_TABLE_300
274 , p5_a26 JTF_VARCHAR2_TABLE_300
275 , p5_a27 JTF_VARCHAR2_TABLE_300
276 , p5_a28 JTF_VARCHAR2_TABLE_300
277 , p5_a29 JTF_VARCHAR2_TABLE_300
278 , p5_a30 JTF_VARCHAR2_TABLE_300
279 , p5_a31 JTF_VARCHAR2_TABLE_300
280 , p5_a32 JTF_VARCHAR2_TABLE_300
281 , p5_a33 JTF_NUMBER_TABLE
282 , p5_a34 JTF_DATE_TABLE
283 , p5_a35 JTF_NUMBER_TABLE
284 , p5_a36 JTF_DATE_TABLE
285 , p5_a37 JTF_NUMBER_TABLE
286 , p6_a0 out nocopy JTF_NUMBER_TABLE
287 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
288 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
289 , p6_a3 out nocopy JTF_DATE_TABLE
290 , p6_a4 out nocopy JTF_NUMBER_TABLE
291 , p6_a5 out nocopy JTF_NUMBER_TABLE
292 , p6_a6 out nocopy JTF_NUMBER_TABLE
293 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
294 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
295 , p6_a9 out nocopy JTF_DATE_TABLE
296 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
297 , p6_a11 out nocopy JTF_NUMBER_TABLE
298 , p6_a12 out nocopy JTF_NUMBER_TABLE
299 , p6_a13 out nocopy JTF_NUMBER_TABLE
300 , p6_a14 out nocopy JTF_NUMBER_TABLE
301 , p6_a15 out nocopy JTF_NUMBER_TABLE
302 , p6_a16 out nocopy JTF_DATE_TABLE
303 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_300
304 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
305 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_300
306 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300
307 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_300
308 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
309 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_300
310 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
311 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
312 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
313 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_300
314 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_300
315 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_300
316 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
317 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
318 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
319 , p6_a33 out nocopy JTF_NUMBER_TABLE
320 , p6_a34 out nocopy JTF_DATE_TABLE
321 , p6_a35 out nocopy JTF_NUMBER_TABLE
322 , p6_a36 out nocopy JTF_DATE_TABLE
323 , p6_a37 out nocopy JTF_NUMBER_TABLE
324 );
325 procedure lock_row(p_api_version NUMBER
326 , p_init_msg_list VARCHAR2
327 , x_return_status out nocopy VARCHAR2
328 , x_msg_count out nocopy NUMBER
329 , x_msg_data out nocopy VARCHAR2
330 , p5_a0 NUMBER := 0-1962.0724
331 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
332 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
333 , p5_a3 DATE := fnd_api.g_miss_date
334 , p5_a4 NUMBER := 0-1962.0724
335 , p5_a5 NUMBER := 0-1962.0724
336 , p5_a6 NUMBER := 0-1962.0724
337 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
338 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
339 , p5_a9 DATE := fnd_api.g_miss_date
340 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
341 , p5_a11 NUMBER := 0-1962.0724
342 , p5_a12 NUMBER := 0-1962.0724
343 , p5_a13 NUMBER := 0-1962.0724
344 , p5_a14 NUMBER := 0-1962.0724
345 , p5_a15 NUMBER := 0-1962.0724
346 , p5_a16 DATE := fnd_api.g_miss_date
347 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
348 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
349 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
350 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
351 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
352 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
353 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
354 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
355 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
356 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
357 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
358 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
359 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
360 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
361 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
362 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
363 , p5_a33 NUMBER := 0-1962.0724
364 , p5_a34 DATE := fnd_api.g_miss_date
365 , p5_a35 NUMBER := 0-1962.0724
366 , p5_a36 DATE := fnd_api.g_miss_date
367 , p5_a37 NUMBER := 0-1962.0724
368 );
369 procedure lock_row(p_api_version NUMBER
370 , p_init_msg_list VARCHAR2
371 , x_return_status out nocopy VARCHAR2
372 , x_msg_count out nocopy NUMBER
373 , x_msg_data out nocopy VARCHAR2
374 , p5_a0 JTF_NUMBER_TABLE
375 , p5_a1 JTF_VARCHAR2_TABLE_200
376 , p5_a2 JTF_VARCHAR2_TABLE_100
377 , p5_a3 JTF_DATE_TABLE
378 , p5_a4 JTF_NUMBER_TABLE
379 , p5_a5 JTF_NUMBER_TABLE
380 , p5_a6 JTF_NUMBER_TABLE
381 , p5_a7 JTF_VARCHAR2_TABLE_100
382 , p5_a8 JTF_VARCHAR2_TABLE_2000
383 , p5_a9 JTF_DATE_TABLE
384 , p5_a10 JTF_VARCHAR2_TABLE_100
385 , p5_a11 JTF_NUMBER_TABLE
386 , p5_a12 JTF_NUMBER_TABLE
387 , p5_a13 JTF_NUMBER_TABLE
388 , p5_a14 JTF_NUMBER_TABLE
389 , p5_a15 JTF_NUMBER_TABLE
390 , p5_a16 JTF_DATE_TABLE
391 , p5_a17 JTF_VARCHAR2_TABLE_300
392 , p5_a18 JTF_VARCHAR2_TABLE_300
393 , p5_a19 JTF_VARCHAR2_TABLE_300
394 , p5_a20 JTF_VARCHAR2_TABLE_300
395 , p5_a21 JTF_VARCHAR2_TABLE_300
396 , p5_a22 JTF_VARCHAR2_TABLE_300
397 , p5_a23 JTF_VARCHAR2_TABLE_300
398 , p5_a24 JTF_VARCHAR2_TABLE_300
399 , p5_a25 JTF_VARCHAR2_TABLE_300
400 , p5_a26 JTF_VARCHAR2_TABLE_300
401 , p5_a27 JTF_VARCHAR2_TABLE_300
402 , p5_a28 JTF_VARCHAR2_TABLE_300
403 , p5_a29 JTF_VARCHAR2_TABLE_300
404 , p5_a30 JTF_VARCHAR2_TABLE_300
405 , p5_a31 JTF_VARCHAR2_TABLE_300
406 , p5_a32 JTF_VARCHAR2_TABLE_300
407 , p5_a33 JTF_NUMBER_TABLE
408 , p5_a34 JTF_DATE_TABLE
409 , p5_a35 JTF_NUMBER_TABLE
410 , p5_a36 JTF_DATE_TABLE
411 , p5_a37 JTF_NUMBER_TABLE
412 );
413 procedure update_row(p_api_version NUMBER
414 , p_init_msg_list VARCHAR2
415 , x_return_status out nocopy VARCHAR2
416 , x_msg_count out nocopy NUMBER
417 , x_msg_data out nocopy VARCHAR2
418 , p6_a0 out nocopy NUMBER
419 , p6_a1 out nocopy VARCHAR2
420 , p6_a2 out nocopy VARCHAR2
421 , p6_a3 out nocopy DATE
422 , p6_a4 out nocopy NUMBER
423 , p6_a5 out nocopy NUMBER
424 , p6_a6 out nocopy NUMBER
425 , p6_a7 out nocopy VARCHAR2
426 , p6_a8 out nocopy VARCHAR2
427 , p6_a9 out nocopy DATE
428 , p6_a10 out nocopy VARCHAR2
429 , p6_a11 out nocopy NUMBER
430 , p6_a12 out nocopy NUMBER
431 , p6_a13 out nocopy NUMBER
432 , p6_a14 out nocopy NUMBER
433 , p6_a15 out nocopy NUMBER
434 , p6_a16 out nocopy DATE
435 , p6_a17 out nocopy VARCHAR2
436 , p6_a18 out nocopy VARCHAR2
437 , p6_a19 out nocopy VARCHAR2
438 , p6_a20 out nocopy VARCHAR2
439 , p6_a21 out nocopy VARCHAR2
440 , p6_a22 out nocopy VARCHAR2
441 , p6_a23 out nocopy VARCHAR2
442 , p6_a24 out nocopy VARCHAR2
443 , p6_a25 out nocopy VARCHAR2
444 , p6_a26 out nocopy VARCHAR2
445 , p6_a27 out nocopy VARCHAR2
446 , p6_a28 out nocopy VARCHAR2
447 , p6_a29 out nocopy VARCHAR2
448 , p6_a30 out nocopy VARCHAR2
449 , p6_a31 out nocopy VARCHAR2
450 , p6_a32 out nocopy VARCHAR2
451 , p6_a33 out nocopy NUMBER
452 , p6_a34 out nocopy DATE
453 , p6_a35 out nocopy NUMBER
454 , p6_a36 out nocopy DATE
455 , p6_a37 out nocopy NUMBER
456 , p5_a0 NUMBER := 0-1962.0724
457 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
458 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
459 , p5_a3 DATE := fnd_api.g_miss_date
460 , p5_a4 NUMBER := 0-1962.0724
461 , p5_a5 NUMBER := 0-1962.0724
462 , p5_a6 NUMBER := 0-1962.0724
463 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
464 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
465 , p5_a9 DATE := fnd_api.g_miss_date
466 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
467 , p5_a11 NUMBER := 0-1962.0724
468 , p5_a12 NUMBER := 0-1962.0724
469 , p5_a13 NUMBER := 0-1962.0724
470 , p5_a14 NUMBER := 0-1962.0724
471 , p5_a15 NUMBER := 0-1962.0724
472 , p5_a16 DATE := fnd_api.g_miss_date
473 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
474 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
475 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
476 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
477 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
478 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
479 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
480 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
481 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
482 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
483 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
484 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
485 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
486 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
487 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
488 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
489 , p5_a33 NUMBER := 0-1962.0724
490 , p5_a34 DATE := fnd_api.g_miss_date
491 , p5_a35 NUMBER := 0-1962.0724
492 , p5_a36 DATE := fnd_api.g_miss_date
493 , p5_a37 NUMBER := 0-1962.0724
494 );
495 procedure update_row(p_api_version NUMBER
496 , p_init_msg_list VARCHAR2
497 , x_return_status out nocopy VARCHAR2
498 , x_msg_count out nocopy NUMBER
499 , x_msg_data out nocopy VARCHAR2
500 , p5_a0 JTF_NUMBER_TABLE
501 , p5_a1 JTF_VARCHAR2_TABLE_200
502 , p5_a2 JTF_VARCHAR2_TABLE_100
503 , p5_a3 JTF_DATE_TABLE
504 , p5_a4 JTF_NUMBER_TABLE
505 , p5_a5 JTF_NUMBER_TABLE
506 , p5_a6 JTF_NUMBER_TABLE
507 , p5_a7 JTF_VARCHAR2_TABLE_100
508 , p5_a8 JTF_VARCHAR2_TABLE_2000
509 , p5_a9 JTF_DATE_TABLE
510 , p5_a10 JTF_VARCHAR2_TABLE_100
511 , p5_a11 JTF_NUMBER_TABLE
512 , p5_a12 JTF_NUMBER_TABLE
513 , p5_a13 JTF_NUMBER_TABLE
514 , p5_a14 JTF_NUMBER_TABLE
515 , p5_a15 JTF_NUMBER_TABLE
516 , p5_a16 JTF_DATE_TABLE
517 , p5_a17 JTF_VARCHAR2_TABLE_300
518 , p5_a18 JTF_VARCHAR2_TABLE_300
519 , p5_a19 JTF_VARCHAR2_TABLE_300
520 , p5_a20 JTF_VARCHAR2_TABLE_300
521 , p5_a21 JTF_VARCHAR2_TABLE_300
522 , p5_a22 JTF_VARCHAR2_TABLE_300
523 , p5_a23 JTF_VARCHAR2_TABLE_300
524 , p5_a24 JTF_VARCHAR2_TABLE_300
525 , p5_a25 JTF_VARCHAR2_TABLE_300
526 , p5_a26 JTF_VARCHAR2_TABLE_300
527 , p5_a27 JTF_VARCHAR2_TABLE_300
528 , p5_a28 JTF_VARCHAR2_TABLE_300
529 , p5_a29 JTF_VARCHAR2_TABLE_300
530 , p5_a30 JTF_VARCHAR2_TABLE_300
531 , p5_a31 JTF_VARCHAR2_TABLE_300
532 , p5_a32 JTF_VARCHAR2_TABLE_300
533 , p5_a33 JTF_NUMBER_TABLE
534 , p5_a34 JTF_DATE_TABLE
535 , p5_a35 JTF_NUMBER_TABLE
536 , p5_a36 JTF_DATE_TABLE
537 , p5_a37 JTF_NUMBER_TABLE
538 , p6_a0 out nocopy JTF_NUMBER_TABLE
539 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
540 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
541 , p6_a3 out nocopy JTF_DATE_TABLE
542 , p6_a4 out nocopy JTF_NUMBER_TABLE
543 , p6_a5 out nocopy JTF_NUMBER_TABLE
544 , p6_a6 out nocopy JTF_NUMBER_TABLE
545 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
546 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
547 , p6_a9 out nocopy JTF_DATE_TABLE
548 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
549 , p6_a11 out nocopy JTF_NUMBER_TABLE
550 , p6_a12 out nocopy JTF_NUMBER_TABLE
551 , p6_a13 out nocopy JTF_NUMBER_TABLE
552 , p6_a14 out nocopy JTF_NUMBER_TABLE
553 , p6_a15 out nocopy JTF_NUMBER_TABLE
554 , p6_a16 out nocopy JTF_DATE_TABLE
555 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_300
556 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
557 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_300
558 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300
559 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_300
560 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
561 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_300
562 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
563 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
564 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
565 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_300
566 , p6_a28 out nocopy JTF_VARCHAR2_TABLE_300
567 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_300
568 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
569 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
570 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
571 , p6_a33 out nocopy JTF_NUMBER_TABLE
572 , p6_a34 out nocopy JTF_DATE_TABLE
573 , p6_a35 out nocopy JTF_NUMBER_TABLE
574 , p6_a36 out nocopy JTF_DATE_TABLE
575 , p6_a37 out nocopy JTF_NUMBER_TABLE
576 );
577 procedure delete_row(p_api_version NUMBER
578 , p_init_msg_list VARCHAR2
579 , x_return_status out nocopy VARCHAR2
580 , x_msg_count out nocopy NUMBER
581 , x_msg_data out nocopy VARCHAR2
582 , p5_a0 NUMBER := 0-1962.0724
583 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
584 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
585 , p5_a3 DATE := fnd_api.g_miss_date
586 , p5_a4 NUMBER := 0-1962.0724
587 , p5_a5 NUMBER := 0-1962.0724
588 , p5_a6 NUMBER := 0-1962.0724
589 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
590 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
591 , p5_a9 DATE := fnd_api.g_miss_date
592 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
593 , p5_a11 NUMBER := 0-1962.0724
594 , p5_a12 NUMBER := 0-1962.0724
595 , p5_a13 NUMBER := 0-1962.0724
596 , p5_a14 NUMBER := 0-1962.0724
597 , p5_a15 NUMBER := 0-1962.0724
598 , p5_a16 DATE := fnd_api.g_miss_date
599 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
600 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
601 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
602 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
603 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
604 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
605 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
606 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
607 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
608 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
609 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
610 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
611 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
612 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
613 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
614 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
615 , p5_a33 NUMBER := 0-1962.0724
616 , p5_a34 DATE := fnd_api.g_miss_date
617 , p5_a35 NUMBER := 0-1962.0724
618 , p5_a36 DATE := fnd_api.g_miss_date
619 , p5_a37 NUMBER := 0-1962.0724
620 );
621 procedure delete_row(p_api_version NUMBER
622 , p_init_msg_list VARCHAR2
623 , x_return_status out nocopy VARCHAR2
624 , x_msg_count out nocopy NUMBER
625 , x_msg_data out nocopy VARCHAR2
626 , p5_a0 JTF_NUMBER_TABLE
627 , p5_a1 JTF_VARCHAR2_TABLE_200
628 , p5_a2 JTF_VARCHAR2_TABLE_100
629 , p5_a3 JTF_DATE_TABLE
630 , p5_a4 JTF_NUMBER_TABLE
631 , p5_a5 JTF_NUMBER_TABLE
632 , p5_a6 JTF_NUMBER_TABLE
633 , p5_a7 JTF_VARCHAR2_TABLE_100
634 , p5_a8 JTF_VARCHAR2_TABLE_2000
635 , p5_a9 JTF_DATE_TABLE
636 , p5_a10 JTF_VARCHAR2_TABLE_100
637 , p5_a11 JTF_NUMBER_TABLE
638 , p5_a12 JTF_NUMBER_TABLE
639 , p5_a13 JTF_NUMBER_TABLE
640 , p5_a14 JTF_NUMBER_TABLE
641 , p5_a15 JTF_NUMBER_TABLE
642 , p5_a16 JTF_DATE_TABLE
643 , p5_a17 JTF_VARCHAR2_TABLE_300
644 , p5_a18 JTF_VARCHAR2_TABLE_300
645 , p5_a19 JTF_VARCHAR2_TABLE_300
646 , p5_a20 JTF_VARCHAR2_TABLE_300
647 , p5_a21 JTF_VARCHAR2_TABLE_300
648 , p5_a22 JTF_VARCHAR2_TABLE_300
649 , p5_a23 JTF_VARCHAR2_TABLE_300
650 , p5_a24 JTF_VARCHAR2_TABLE_300
651 , p5_a25 JTF_VARCHAR2_TABLE_300
652 , p5_a26 JTF_VARCHAR2_TABLE_300
653 , p5_a27 JTF_VARCHAR2_TABLE_300
654 , p5_a28 JTF_VARCHAR2_TABLE_300
655 , p5_a29 JTF_VARCHAR2_TABLE_300
656 , p5_a30 JTF_VARCHAR2_TABLE_300
657 , p5_a31 JTF_VARCHAR2_TABLE_300
658 , p5_a32 JTF_VARCHAR2_TABLE_300
659 , p5_a33 JTF_NUMBER_TABLE
660 , p5_a34 JTF_DATE_TABLE
661 , p5_a35 JTF_NUMBER_TABLE
662 , p5_a36 JTF_DATE_TABLE
663 , p5_a37 JTF_NUMBER_TABLE
664 );
665 procedure validate_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 NUMBER := 0-1962.0724
671 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
672 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
673 , p5_a3 DATE := fnd_api.g_miss_date
674 , p5_a4 NUMBER := 0-1962.0724
675 , p5_a5 NUMBER := 0-1962.0724
676 , p5_a6 NUMBER := 0-1962.0724
677 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
678 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
679 , p5_a9 DATE := fnd_api.g_miss_date
680 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
681 , p5_a11 NUMBER := 0-1962.0724
682 , p5_a12 NUMBER := 0-1962.0724
683 , p5_a13 NUMBER := 0-1962.0724
684 , p5_a14 NUMBER := 0-1962.0724
685 , p5_a15 NUMBER := 0-1962.0724
686 , p5_a16 DATE := fnd_api.g_miss_date
687 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
688 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
689 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
690 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
691 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
692 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
693 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
694 , p5_a24 VARCHAR2 := fnd_api.g_miss_char
695 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
696 , p5_a26 VARCHAR2 := fnd_api.g_miss_char
697 , p5_a27 VARCHAR2 := fnd_api.g_miss_char
698 , p5_a28 VARCHAR2 := fnd_api.g_miss_char
699 , p5_a29 VARCHAR2 := fnd_api.g_miss_char
700 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
701 , p5_a31 VARCHAR2 := fnd_api.g_miss_char
702 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
703 , p5_a33 NUMBER := 0-1962.0724
704 , p5_a34 DATE := fnd_api.g_miss_date
705 , p5_a35 NUMBER := 0-1962.0724
706 , p5_a36 DATE := fnd_api.g_miss_date
707 , p5_a37 NUMBER := 0-1962.0724
708 );
709 procedure validate_row(p_api_version NUMBER
710 , p_init_msg_list VARCHAR2
711 , x_return_status out nocopy VARCHAR2
712 , x_msg_count out nocopy NUMBER
713 , x_msg_data out nocopy VARCHAR2
714 , p5_a0 JTF_NUMBER_TABLE
715 , p5_a1 JTF_VARCHAR2_TABLE_200
716 , p5_a2 JTF_VARCHAR2_TABLE_100
717 , p5_a3 JTF_DATE_TABLE
718 , p5_a4 JTF_NUMBER_TABLE
719 , p5_a5 JTF_NUMBER_TABLE
720 , p5_a6 JTF_NUMBER_TABLE
721 , p5_a7 JTF_VARCHAR2_TABLE_100
722 , p5_a8 JTF_VARCHAR2_TABLE_2000
723 , p5_a9 JTF_DATE_TABLE
724 , p5_a10 JTF_VARCHAR2_TABLE_100
725 , p5_a11 JTF_NUMBER_TABLE
726 , p5_a12 JTF_NUMBER_TABLE
727 , p5_a13 JTF_NUMBER_TABLE
728 , p5_a14 JTF_NUMBER_TABLE
729 , p5_a15 JTF_NUMBER_TABLE
730 , p5_a16 JTF_DATE_TABLE
731 , p5_a17 JTF_VARCHAR2_TABLE_300
732 , p5_a18 JTF_VARCHAR2_TABLE_300
733 , p5_a19 JTF_VARCHAR2_TABLE_300
734 , p5_a20 JTF_VARCHAR2_TABLE_300
735 , p5_a21 JTF_VARCHAR2_TABLE_300
736 , p5_a22 JTF_VARCHAR2_TABLE_300
737 , p5_a23 JTF_VARCHAR2_TABLE_300
738 , p5_a24 JTF_VARCHAR2_TABLE_300
739 , p5_a25 JTF_VARCHAR2_TABLE_300
740 , p5_a26 JTF_VARCHAR2_TABLE_300
741 , p5_a27 JTF_VARCHAR2_TABLE_300
742 , p5_a28 JTF_VARCHAR2_TABLE_300
743 , p5_a29 JTF_VARCHAR2_TABLE_300
744 , p5_a30 JTF_VARCHAR2_TABLE_300
745 , p5_a31 JTF_VARCHAR2_TABLE_300
746 , p5_a32 JTF_VARCHAR2_TABLE_300
747 , p5_a33 JTF_NUMBER_TABLE
748 , p5_a34 JTF_DATE_TABLE
749 , p5_a35 JTF_NUMBER_TABLE
750 , p5_a36 JTF_DATE_TABLE
751 , p5_a37 JTF_NUMBER_TABLE
752 );
753 end okl_crt_pvt_w;