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