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