[Home] [Help]
PACKAGE: APPS.OKL_SIF_RET_ERRORS_PUB_W
Source
1 package okl_sif_ret_errors_pub_w as
2 /* $Header: OKLUSRMS.pls 120.1 2005/07/19 09:43:55 viselvar noship $ */
3 procedure insert_sif_ret_errors(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 VARCHAR2
11 , p6_a3 out nocopy VARCHAR2
12 , p6_a4 out nocopy VARCHAR2
13 , p6_a5 out nocopy NUMBER
14 , p6_a6 out nocopy VARCHAR2
15 , p6_a7 out nocopy VARCHAR2
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 VARCHAR2 := fnd_api.g_miss_char
40 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
41 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
42 , p5_a5 NUMBER := 0-1962.0724
43 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
44 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
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_errors(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 , p5_a0 JTF_NUMBER_TABLE
73 , p5_a1 JTF_VARCHAR2_TABLE_100
74 , p5_a2 JTF_VARCHAR2_TABLE_2000
75 , p5_a3 JTF_VARCHAR2_TABLE_200
76 , p5_a4 JTF_VARCHAR2_TABLE_1000
77 , p5_a5 JTF_NUMBER_TABLE
78 , p5_a6 JTF_VARCHAR2_TABLE_300
79 , p5_a7 JTF_VARCHAR2_TABLE_100
80 , p5_a8 JTF_VARCHAR2_TABLE_500
81 , p5_a9 JTF_VARCHAR2_TABLE_500
82 , p5_a10 JTF_VARCHAR2_TABLE_500
83 , p5_a11 JTF_VARCHAR2_TABLE_500
84 , p5_a12 JTF_VARCHAR2_TABLE_500
85 , p5_a13 JTF_VARCHAR2_TABLE_500
86 , p5_a14 JTF_VARCHAR2_TABLE_500
87 , p5_a15 JTF_VARCHAR2_TABLE_500
88 , p5_a16 JTF_VARCHAR2_TABLE_500
89 , p5_a17 JTF_VARCHAR2_TABLE_500
90 , p5_a18 JTF_VARCHAR2_TABLE_500
91 , p5_a19 JTF_VARCHAR2_TABLE_500
92 , p5_a20 JTF_VARCHAR2_TABLE_500
93 , p5_a21 JTF_VARCHAR2_TABLE_500
94 , p5_a22 JTF_VARCHAR2_TABLE_500
95 , p5_a23 JTF_NUMBER_TABLE
96 , p5_a24 JTF_NUMBER_TABLE
97 , p5_a25 JTF_NUMBER_TABLE
98 , p5_a26 JTF_DATE_TABLE
99 , p5_a27 JTF_DATE_TABLE
100 , p5_a28 JTF_NUMBER_TABLE
101 , p6_a0 out nocopy JTF_NUMBER_TABLE
102 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
103 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
104 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
105 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000
106 , p6_a5 out nocopy JTF_NUMBER_TABLE
107 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
108 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
109 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
110 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
111 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
112 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
113 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
114 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
115 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
116 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
117 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
118 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
119 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
120 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
121 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
122 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
123 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
124 , p6_a23 out nocopy JTF_NUMBER_TABLE
125 , p6_a24 out nocopy JTF_NUMBER_TABLE
126 , p6_a25 out nocopy JTF_NUMBER_TABLE
127 , p6_a26 out nocopy JTF_DATE_TABLE
128 , p6_a27 out nocopy JTF_DATE_TABLE
129 , p6_a28 out nocopy JTF_NUMBER_TABLE
130 );
131 procedure lock_sif_ret_errors(p_api_version NUMBER
132 , p_init_msg_list VARCHAR2
133 , x_return_status out nocopy VARCHAR2
134 , x_msg_count out nocopy NUMBER
135 , x_msg_data out nocopy VARCHAR2
136 , p5_a0 NUMBER := 0-1962.0724
137 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
138 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
139 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
140 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
141 , p5_a5 NUMBER := 0-1962.0724
142 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
143 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
144 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
145 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
146 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
147 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
148 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
149 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
150 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
151 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
152 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
153 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
154 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
155 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
156 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
157 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
158 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
159 , p5_a23 NUMBER := 0-1962.0724
160 , p5_a24 NUMBER := 0-1962.0724
161 , p5_a25 NUMBER := 0-1962.0724
162 , p5_a26 DATE := fnd_api.g_miss_date
163 , p5_a27 DATE := fnd_api.g_miss_date
164 , p5_a28 NUMBER := 0-1962.0724
165 );
166 procedure lock_sif_ret_errors(p_api_version NUMBER
167 , p_init_msg_list VARCHAR2
168 , x_return_status out nocopy VARCHAR2
169 , x_msg_count out nocopy NUMBER
170 , x_msg_data out nocopy VARCHAR2
171 , p5_a0 JTF_NUMBER_TABLE
172 , p5_a1 JTF_VARCHAR2_TABLE_100
173 , p5_a2 JTF_VARCHAR2_TABLE_2000
174 , p5_a3 JTF_VARCHAR2_TABLE_200
175 , p5_a4 JTF_VARCHAR2_TABLE_1000
176 , p5_a5 JTF_NUMBER_TABLE
177 , p5_a6 JTF_VARCHAR2_TABLE_300
178 , p5_a7 JTF_VARCHAR2_TABLE_100
179 , p5_a8 JTF_VARCHAR2_TABLE_500
180 , p5_a9 JTF_VARCHAR2_TABLE_500
181 , p5_a10 JTF_VARCHAR2_TABLE_500
182 , p5_a11 JTF_VARCHAR2_TABLE_500
183 , p5_a12 JTF_VARCHAR2_TABLE_500
184 , p5_a13 JTF_VARCHAR2_TABLE_500
185 , p5_a14 JTF_VARCHAR2_TABLE_500
186 , p5_a15 JTF_VARCHAR2_TABLE_500
187 , p5_a16 JTF_VARCHAR2_TABLE_500
188 , p5_a17 JTF_VARCHAR2_TABLE_500
189 , p5_a18 JTF_VARCHAR2_TABLE_500
190 , p5_a19 JTF_VARCHAR2_TABLE_500
191 , p5_a20 JTF_VARCHAR2_TABLE_500
192 , p5_a21 JTF_VARCHAR2_TABLE_500
193 , p5_a22 JTF_VARCHAR2_TABLE_500
194 , p5_a23 JTF_NUMBER_TABLE
195 , p5_a24 JTF_NUMBER_TABLE
196 , p5_a25 JTF_NUMBER_TABLE
197 , p5_a26 JTF_DATE_TABLE
198 , p5_a27 JTF_DATE_TABLE
199 , p5_a28 JTF_NUMBER_TABLE
200 );
201 procedure update_sif_ret_errors(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 , p6_a0 out nocopy NUMBER
207 , p6_a1 out nocopy VARCHAR2
208 , p6_a2 out nocopy VARCHAR2
209 , p6_a3 out nocopy VARCHAR2
210 , p6_a4 out nocopy VARCHAR2
211 , p6_a5 out nocopy NUMBER
212 , p6_a6 out nocopy VARCHAR2
213 , p6_a7 out nocopy VARCHAR2
214 , p6_a8 out nocopy VARCHAR2
215 , p6_a9 out nocopy VARCHAR2
216 , p6_a10 out nocopy VARCHAR2
217 , p6_a11 out nocopy VARCHAR2
218 , p6_a12 out nocopy VARCHAR2
219 , p6_a13 out nocopy VARCHAR2
220 , p6_a14 out nocopy VARCHAR2
221 , p6_a15 out nocopy VARCHAR2
222 , p6_a16 out nocopy VARCHAR2
223 , p6_a17 out nocopy VARCHAR2
224 , p6_a18 out nocopy VARCHAR2
225 , p6_a19 out nocopy VARCHAR2
226 , p6_a20 out nocopy VARCHAR2
227 , p6_a21 out nocopy VARCHAR2
228 , p6_a22 out nocopy VARCHAR2
229 , p6_a23 out nocopy NUMBER
230 , p6_a24 out nocopy NUMBER
231 , p6_a25 out nocopy NUMBER
232 , p6_a26 out nocopy DATE
233 , p6_a27 out nocopy DATE
234 , p6_a28 out nocopy NUMBER
235 , p5_a0 NUMBER := 0-1962.0724
236 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
237 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
238 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
239 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
240 , p5_a5 NUMBER := 0-1962.0724
241 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
242 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
243 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
244 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
245 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
246 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
247 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
248 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
249 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
250 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
251 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
252 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
253 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
254 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
255 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
256 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
257 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
258 , p5_a23 NUMBER := 0-1962.0724
259 , p5_a24 NUMBER := 0-1962.0724
260 , p5_a25 NUMBER := 0-1962.0724
261 , p5_a26 DATE := fnd_api.g_miss_date
262 , p5_a27 DATE := fnd_api.g_miss_date
263 , p5_a28 NUMBER := 0-1962.0724
264 );
265 procedure update_sif_ret_errors(p_api_version NUMBER
266 , p_init_msg_list VARCHAR2
267 , x_return_status out nocopy VARCHAR2
268 , x_msg_count out nocopy NUMBER
269 , x_msg_data out nocopy VARCHAR2
270 , p5_a0 JTF_NUMBER_TABLE
271 , p5_a1 JTF_VARCHAR2_TABLE_100
272 , p5_a2 JTF_VARCHAR2_TABLE_2000
273 , p5_a3 JTF_VARCHAR2_TABLE_200
274 , p5_a4 JTF_VARCHAR2_TABLE_1000
275 , p5_a5 JTF_NUMBER_TABLE
276 , p5_a6 JTF_VARCHAR2_TABLE_300
277 , p5_a7 JTF_VARCHAR2_TABLE_100
278 , p5_a8 JTF_VARCHAR2_TABLE_500
279 , p5_a9 JTF_VARCHAR2_TABLE_500
280 , p5_a10 JTF_VARCHAR2_TABLE_500
281 , p5_a11 JTF_VARCHAR2_TABLE_500
282 , p5_a12 JTF_VARCHAR2_TABLE_500
283 , p5_a13 JTF_VARCHAR2_TABLE_500
284 , p5_a14 JTF_VARCHAR2_TABLE_500
285 , p5_a15 JTF_VARCHAR2_TABLE_500
286 , p5_a16 JTF_VARCHAR2_TABLE_500
287 , p5_a17 JTF_VARCHAR2_TABLE_500
288 , p5_a18 JTF_VARCHAR2_TABLE_500
289 , p5_a19 JTF_VARCHAR2_TABLE_500
290 , p5_a20 JTF_VARCHAR2_TABLE_500
291 , p5_a21 JTF_VARCHAR2_TABLE_500
292 , p5_a22 JTF_VARCHAR2_TABLE_500
293 , p5_a23 JTF_NUMBER_TABLE
294 , p5_a24 JTF_NUMBER_TABLE
295 , p5_a25 JTF_NUMBER_TABLE
296 , p5_a26 JTF_DATE_TABLE
297 , p5_a27 JTF_DATE_TABLE
298 , p5_a28 JTF_NUMBER_TABLE
299 , p6_a0 out nocopy JTF_NUMBER_TABLE
300 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
301 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
302 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
303 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000
304 , p6_a5 out nocopy JTF_NUMBER_TABLE
305 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
306 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
307 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
308 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
309 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
310 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
311 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
312 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
313 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
314 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
315 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
316 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
317 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
318 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
319 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
320 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
321 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
322 , p6_a23 out nocopy JTF_NUMBER_TABLE
323 , p6_a24 out nocopy JTF_NUMBER_TABLE
324 , p6_a25 out nocopy JTF_NUMBER_TABLE
325 , p6_a26 out nocopy JTF_DATE_TABLE
326 , p6_a27 out nocopy JTF_DATE_TABLE
327 , p6_a28 out nocopy JTF_NUMBER_TABLE
328 );
329 procedure delete_sif_ret_errors(p_api_version NUMBER
330 , p_init_msg_list VARCHAR2
331 , x_return_status out nocopy VARCHAR2
332 , x_msg_count out nocopy NUMBER
333 , x_msg_data out nocopy VARCHAR2
334 , p6_a0 out nocopy NUMBER
335 , p6_a1 out nocopy VARCHAR2
336 , p6_a2 out nocopy VARCHAR2
337 , p6_a3 out nocopy VARCHAR2
338 , p6_a4 out nocopy VARCHAR2
339 , p6_a5 out nocopy NUMBER
340 , p6_a6 out nocopy VARCHAR2
341 , p6_a7 out nocopy VARCHAR2
342 , p6_a8 out nocopy VARCHAR2
343 , p6_a9 out nocopy VARCHAR2
344 , p6_a10 out nocopy VARCHAR2
345 , p6_a11 out nocopy VARCHAR2
346 , p6_a12 out nocopy VARCHAR2
347 , p6_a13 out nocopy VARCHAR2
348 , p6_a14 out nocopy VARCHAR2
349 , p6_a15 out nocopy VARCHAR2
350 , p6_a16 out nocopy VARCHAR2
351 , p6_a17 out nocopy VARCHAR2
352 , p6_a18 out nocopy VARCHAR2
353 , p6_a19 out nocopy VARCHAR2
354 , p6_a20 out nocopy VARCHAR2
355 , p6_a21 out nocopy VARCHAR2
356 , p6_a22 out nocopy VARCHAR2
357 , p6_a23 out nocopy NUMBER
358 , p6_a24 out nocopy NUMBER
359 , p6_a25 out nocopy NUMBER
360 , p6_a26 out nocopy DATE
361 , p6_a27 out nocopy DATE
362 , p6_a28 out nocopy NUMBER
363 , p5_a0 NUMBER := 0-1962.0724
364 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
365 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
366 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
367 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
368 , p5_a5 NUMBER := 0-1962.0724
369 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
370 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
371 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
372 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
373 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
374 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
375 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
376 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
377 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
378 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
379 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
380 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
381 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
382 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
383 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
384 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
385 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
386 , p5_a23 NUMBER := 0-1962.0724
387 , p5_a24 NUMBER := 0-1962.0724
388 , p5_a25 NUMBER := 0-1962.0724
389 , p5_a26 DATE := fnd_api.g_miss_date
390 , p5_a27 DATE := fnd_api.g_miss_date
391 , p5_a28 NUMBER := 0-1962.0724
392 );
393 procedure delete_sif_ret_errors(p_api_version NUMBER
394 , p_init_msg_list VARCHAR2
395 , x_return_status out nocopy VARCHAR2
396 , x_msg_count out nocopy NUMBER
397 , x_msg_data out nocopy VARCHAR2
398 , p5_a0 JTF_NUMBER_TABLE
399 , p5_a1 JTF_VARCHAR2_TABLE_100
400 , p5_a2 JTF_VARCHAR2_TABLE_2000
401 , p5_a3 JTF_VARCHAR2_TABLE_200
402 , p5_a4 JTF_VARCHAR2_TABLE_1000
403 , p5_a5 JTF_NUMBER_TABLE
404 , p5_a6 JTF_VARCHAR2_TABLE_300
405 , p5_a7 JTF_VARCHAR2_TABLE_100
406 , p5_a8 JTF_VARCHAR2_TABLE_500
407 , p5_a9 JTF_VARCHAR2_TABLE_500
408 , p5_a10 JTF_VARCHAR2_TABLE_500
409 , p5_a11 JTF_VARCHAR2_TABLE_500
410 , p5_a12 JTF_VARCHAR2_TABLE_500
411 , p5_a13 JTF_VARCHAR2_TABLE_500
412 , p5_a14 JTF_VARCHAR2_TABLE_500
413 , p5_a15 JTF_VARCHAR2_TABLE_500
414 , p5_a16 JTF_VARCHAR2_TABLE_500
415 , p5_a17 JTF_VARCHAR2_TABLE_500
416 , p5_a18 JTF_VARCHAR2_TABLE_500
417 , p5_a19 JTF_VARCHAR2_TABLE_500
418 , p5_a20 JTF_VARCHAR2_TABLE_500
419 , p5_a21 JTF_VARCHAR2_TABLE_500
420 , p5_a22 JTF_VARCHAR2_TABLE_500
421 , p5_a23 JTF_NUMBER_TABLE
422 , p5_a24 JTF_NUMBER_TABLE
423 , p5_a25 JTF_NUMBER_TABLE
424 , p5_a26 JTF_DATE_TABLE
425 , p5_a27 JTF_DATE_TABLE
426 , p5_a28 JTF_NUMBER_TABLE
427 , p6_a0 out nocopy JTF_NUMBER_TABLE
428 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
429 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
430 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
431 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000
432 , p6_a5 out nocopy JTF_NUMBER_TABLE
433 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
434 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
435 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
436 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
437 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
438 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
439 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
440 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
441 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
442 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
443 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
444 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
445 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
446 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
447 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
448 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
449 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
450 , p6_a23 out nocopy JTF_NUMBER_TABLE
451 , p6_a24 out nocopy JTF_NUMBER_TABLE
452 , p6_a25 out nocopy JTF_NUMBER_TABLE
453 , p6_a26 out nocopy JTF_DATE_TABLE
454 , p6_a27 out nocopy JTF_DATE_TABLE
455 , p6_a28 out nocopy JTF_NUMBER_TABLE
456 );
457 procedure validate_sif_ret_errors(p_api_version NUMBER
458 , p_init_msg_list VARCHAR2
459 , x_return_status out nocopy VARCHAR2
460 , x_msg_count out nocopy NUMBER
461 , x_msg_data out nocopy VARCHAR2
462 , p6_a0 out nocopy NUMBER
463 , p6_a1 out nocopy VARCHAR2
464 , p6_a2 out nocopy VARCHAR2
465 , p6_a3 out nocopy VARCHAR2
466 , p6_a4 out nocopy VARCHAR2
467 , p6_a5 out nocopy NUMBER
468 , p6_a6 out nocopy VARCHAR2
469 , p6_a7 out nocopy VARCHAR2
470 , p6_a8 out nocopy VARCHAR2
471 , p6_a9 out nocopy VARCHAR2
472 , p6_a10 out nocopy VARCHAR2
473 , p6_a11 out nocopy VARCHAR2
474 , p6_a12 out nocopy VARCHAR2
475 , p6_a13 out nocopy VARCHAR2
476 , p6_a14 out nocopy VARCHAR2
477 , p6_a15 out nocopy VARCHAR2
478 , p6_a16 out nocopy VARCHAR2
479 , p6_a17 out nocopy VARCHAR2
480 , p6_a18 out nocopy VARCHAR2
481 , p6_a19 out nocopy VARCHAR2
482 , p6_a20 out nocopy VARCHAR2
483 , p6_a21 out nocopy VARCHAR2
484 , p6_a22 out nocopy VARCHAR2
485 , p6_a23 out nocopy NUMBER
486 , p6_a24 out nocopy NUMBER
487 , p6_a25 out nocopy NUMBER
488 , p6_a26 out nocopy DATE
489 , p6_a27 out nocopy DATE
490 , p6_a28 out nocopy NUMBER
491 , p5_a0 NUMBER := 0-1962.0724
492 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
493 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
494 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
495 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
496 , p5_a5 NUMBER := 0-1962.0724
497 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
498 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
499 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
500 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
501 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
502 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
503 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
504 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
505 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
506 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
507 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
508 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
509 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
510 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
511 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
512 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
513 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
514 , p5_a23 NUMBER := 0-1962.0724
515 , p5_a24 NUMBER := 0-1962.0724
516 , p5_a25 NUMBER := 0-1962.0724
517 , p5_a26 DATE := fnd_api.g_miss_date
518 , p5_a27 DATE := fnd_api.g_miss_date
519 , p5_a28 NUMBER := 0-1962.0724
520 );
521 procedure validate_sif_ret_errors(p_api_version NUMBER
522 , p_init_msg_list VARCHAR2
523 , x_return_status out nocopy VARCHAR2
524 , x_msg_count out nocopy NUMBER
525 , x_msg_data out nocopy VARCHAR2
526 , p5_a0 JTF_NUMBER_TABLE
527 , p5_a1 JTF_VARCHAR2_TABLE_100
528 , p5_a2 JTF_VARCHAR2_TABLE_2000
529 , p5_a3 JTF_VARCHAR2_TABLE_200
530 , p5_a4 JTF_VARCHAR2_TABLE_1000
531 , p5_a5 JTF_NUMBER_TABLE
532 , p5_a6 JTF_VARCHAR2_TABLE_300
533 , p5_a7 JTF_VARCHAR2_TABLE_100
534 , p5_a8 JTF_VARCHAR2_TABLE_500
535 , p5_a9 JTF_VARCHAR2_TABLE_500
536 , p5_a10 JTF_VARCHAR2_TABLE_500
537 , p5_a11 JTF_VARCHAR2_TABLE_500
538 , p5_a12 JTF_VARCHAR2_TABLE_500
539 , p5_a13 JTF_VARCHAR2_TABLE_500
540 , p5_a14 JTF_VARCHAR2_TABLE_500
541 , p5_a15 JTF_VARCHAR2_TABLE_500
542 , p5_a16 JTF_VARCHAR2_TABLE_500
543 , p5_a17 JTF_VARCHAR2_TABLE_500
544 , p5_a18 JTF_VARCHAR2_TABLE_500
545 , p5_a19 JTF_VARCHAR2_TABLE_500
546 , p5_a20 JTF_VARCHAR2_TABLE_500
547 , p5_a21 JTF_VARCHAR2_TABLE_500
548 , p5_a22 JTF_VARCHAR2_TABLE_500
549 , p5_a23 JTF_NUMBER_TABLE
550 , p5_a24 JTF_NUMBER_TABLE
551 , p5_a25 JTF_NUMBER_TABLE
552 , p5_a26 JTF_DATE_TABLE
553 , p5_a27 JTF_DATE_TABLE
554 , p5_a28 JTF_NUMBER_TABLE
555 , p6_a0 out nocopy JTF_NUMBER_TABLE
556 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
557 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
558 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
559 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000
560 , p6_a5 out nocopy JTF_NUMBER_TABLE
561 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
562 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
563 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
564 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
565 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
566 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
567 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
568 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
569 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
570 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
571 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
572 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
573 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
574 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
575 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
576 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
577 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
578 , p6_a23 out nocopy JTF_NUMBER_TABLE
579 , p6_a24 out nocopy JTF_NUMBER_TABLE
580 , p6_a25 out nocopy JTF_NUMBER_TABLE
581 , p6_a26 out nocopy JTF_DATE_TABLE
582 , p6_a27 out nocopy JTF_DATE_TABLE
583 , p6_a28 out nocopy JTF_NUMBER_TABLE
584 );
585 end okl_sif_ret_errors_pub_w;