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