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