eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OKL_STRM_TYPE_EXEMPT_PUB_W

Source


1 package okl_strm_type_exempt_pub_w as
2   /* $Header: OKLUSLXS.pls 120.1 2005/07/19 09:46:59 viselvar noship $ */
3   procedure insert_strm_type_exempt(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     , p5_a0 JTF_NUMBER_TABLE
9     , p5_a1 JTF_NUMBER_TABLE
10     , p5_a2 JTF_NUMBER_TABLE
11     , p5_a3 JTF_NUMBER_TABLE
12     , p5_a4 JTF_VARCHAR2_TABLE_100
13     , p5_a5 JTF_VARCHAR2_TABLE_100
14     , p5_a6 JTF_VARCHAR2_TABLE_500
15     , p5_a7 JTF_VARCHAR2_TABLE_500
16     , p5_a8 JTF_VARCHAR2_TABLE_500
17     , p5_a9 JTF_VARCHAR2_TABLE_500
18     , p5_a10 JTF_VARCHAR2_TABLE_500
19     , p5_a11 JTF_VARCHAR2_TABLE_500
20     , p5_a12 JTF_VARCHAR2_TABLE_500
21     , p5_a13 JTF_VARCHAR2_TABLE_500
22     , p5_a14 JTF_VARCHAR2_TABLE_500
23     , p5_a15 JTF_VARCHAR2_TABLE_500
24     , p5_a16 JTF_VARCHAR2_TABLE_500
25     , p5_a17 JTF_VARCHAR2_TABLE_500
26     , p5_a18 JTF_VARCHAR2_TABLE_500
27     , p5_a19 JTF_VARCHAR2_TABLE_500
28     , p5_a20 JTF_VARCHAR2_TABLE_500
29     , p5_a21 JTF_NUMBER_TABLE
30     , p5_a22 JTF_DATE_TABLE
31     , p5_a23 JTF_NUMBER_TABLE
32     , p5_a24 JTF_DATE_TABLE
33     , p5_a25 JTF_NUMBER_TABLE
34     , p6_a0 out nocopy JTF_NUMBER_TABLE
35     , p6_a1 out nocopy JTF_NUMBER_TABLE
36     , p6_a2 out nocopy JTF_NUMBER_TABLE
37     , p6_a3 out nocopy JTF_NUMBER_TABLE
38     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
39     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
40     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
41     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
42     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
43     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
44     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
45     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
46     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
47     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
48     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
49     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
50     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
51     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
52     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
53     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
54     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
55     , p6_a21 out nocopy JTF_NUMBER_TABLE
56     , p6_a22 out nocopy JTF_DATE_TABLE
57     , p6_a23 out nocopy JTF_NUMBER_TABLE
58     , p6_a24 out nocopy JTF_DATE_TABLE
59     , p6_a25 out nocopy JTF_NUMBER_TABLE
60   );
61   procedure insert_strm_type_exempt(p_api_version  NUMBER
62     , p_init_msg_list  VARCHAR2
63     , x_return_status out nocopy  VARCHAR2
64     , x_msg_count out nocopy  NUMBER
65     , x_msg_data out nocopy  VARCHAR2
66     , p6_a0 out nocopy  NUMBER
67     , p6_a1 out nocopy  NUMBER
68     , p6_a2 out nocopy  NUMBER
69     , p6_a3 out nocopy  NUMBER
70     , p6_a4 out nocopy  VARCHAR2
71     , p6_a5 out nocopy  VARCHAR2
72     , p6_a6 out nocopy  VARCHAR2
73     , p6_a7 out nocopy  VARCHAR2
74     , p6_a8 out nocopy  VARCHAR2
75     , p6_a9 out nocopy  VARCHAR2
76     , p6_a10 out nocopy  VARCHAR2
77     , p6_a11 out nocopy  VARCHAR2
78     , p6_a12 out nocopy  VARCHAR2
79     , p6_a13 out nocopy  VARCHAR2
80     , p6_a14 out nocopy  VARCHAR2
81     , p6_a15 out nocopy  VARCHAR2
82     , p6_a16 out nocopy  VARCHAR2
83     , p6_a17 out nocopy  VARCHAR2
84     , p6_a18 out nocopy  VARCHAR2
85     , p6_a19 out nocopy  VARCHAR2
86     , p6_a20 out nocopy  VARCHAR2
87     , p6_a21 out nocopy  NUMBER
88     , p6_a22 out nocopy  DATE
89     , p6_a23 out nocopy  NUMBER
90     , p6_a24 out nocopy  DATE
91     , p6_a25 out nocopy  NUMBER
92     , p5_a0  NUMBER := 0-1962.0724
93     , p5_a1  NUMBER := 0-1962.0724
94     , p5_a2  NUMBER := 0-1962.0724
95     , p5_a3  NUMBER := 0-1962.0724
96     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
97     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
98     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
99     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
100     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
101     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
102     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
103     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
104     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
105     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
106     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
107     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
108     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
109     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
110     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
111     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
112     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
113     , p5_a21  NUMBER := 0-1962.0724
114     , p5_a22  DATE := fnd_api.g_miss_date
115     , p5_a23  NUMBER := 0-1962.0724
116     , p5_a24  DATE := fnd_api.g_miss_date
117     , p5_a25  NUMBER := 0-1962.0724
118   );
119   procedure lock_strm_type_exempt(p_api_version  NUMBER
120     , p_init_msg_list  VARCHAR2
121     , x_return_status out nocopy  VARCHAR2
122     , x_msg_count out nocopy  NUMBER
123     , x_msg_data out nocopy  VARCHAR2
124     , p5_a0 JTF_NUMBER_TABLE
125     , p5_a1 JTF_NUMBER_TABLE
126     , p5_a2 JTF_NUMBER_TABLE
127     , p5_a3 JTF_NUMBER_TABLE
128     , p5_a4 JTF_VARCHAR2_TABLE_100
129     , p5_a5 JTF_VARCHAR2_TABLE_100
130     , p5_a6 JTF_VARCHAR2_TABLE_500
131     , p5_a7 JTF_VARCHAR2_TABLE_500
132     , p5_a8 JTF_VARCHAR2_TABLE_500
133     , p5_a9 JTF_VARCHAR2_TABLE_500
134     , p5_a10 JTF_VARCHAR2_TABLE_500
135     , p5_a11 JTF_VARCHAR2_TABLE_500
136     , p5_a12 JTF_VARCHAR2_TABLE_500
137     , p5_a13 JTF_VARCHAR2_TABLE_500
138     , p5_a14 JTF_VARCHAR2_TABLE_500
139     , p5_a15 JTF_VARCHAR2_TABLE_500
140     , p5_a16 JTF_VARCHAR2_TABLE_500
141     , p5_a17 JTF_VARCHAR2_TABLE_500
142     , p5_a18 JTF_VARCHAR2_TABLE_500
143     , p5_a19 JTF_VARCHAR2_TABLE_500
144     , p5_a20 JTF_VARCHAR2_TABLE_500
145     , p5_a21 JTF_NUMBER_TABLE
146     , p5_a22 JTF_DATE_TABLE
147     , p5_a23 JTF_NUMBER_TABLE
148     , p5_a24 JTF_DATE_TABLE
149     , p5_a25 JTF_NUMBER_TABLE
150   );
151   procedure lock_strm_type_exempt(p_api_version  NUMBER
152     , p_init_msg_list  VARCHAR2
153     , x_return_status out nocopy  VARCHAR2
154     , x_msg_count out nocopy  NUMBER
155     , x_msg_data out nocopy  VARCHAR2
156     , p5_a0  NUMBER := 0-1962.0724
157     , p5_a1  NUMBER := 0-1962.0724
158     , p5_a2  NUMBER := 0-1962.0724
159     , p5_a3  NUMBER := 0-1962.0724
160     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
161     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
162     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
163     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
164     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
165     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
166     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
167     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
168     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
169     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
170     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
171     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
172     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
173     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
174     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
175     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
176     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
177     , p5_a21  NUMBER := 0-1962.0724
178     , p5_a22  DATE := fnd_api.g_miss_date
179     , p5_a23  NUMBER := 0-1962.0724
180     , p5_a24  DATE := fnd_api.g_miss_date
181     , p5_a25  NUMBER := 0-1962.0724
182   );
183   procedure update_strm_type_exempt(p_api_version  NUMBER
184     , p_init_msg_list  VARCHAR2
185     , x_return_status out nocopy  VARCHAR2
186     , x_msg_count out nocopy  NUMBER
187     , x_msg_data out nocopy  VARCHAR2
188     , p5_a0 JTF_NUMBER_TABLE
189     , p5_a1 JTF_NUMBER_TABLE
190     , p5_a2 JTF_NUMBER_TABLE
191     , p5_a3 JTF_NUMBER_TABLE
192     , p5_a4 JTF_VARCHAR2_TABLE_100
193     , p5_a5 JTF_VARCHAR2_TABLE_100
194     , p5_a6 JTF_VARCHAR2_TABLE_500
195     , p5_a7 JTF_VARCHAR2_TABLE_500
196     , p5_a8 JTF_VARCHAR2_TABLE_500
197     , p5_a9 JTF_VARCHAR2_TABLE_500
198     , p5_a10 JTF_VARCHAR2_TABLE_500
199     , p5_a11 JTF_VARCHAR2_TABLE_500
200     , p5_a12 JTF_VARCHAR2_TABLE_500
201     , p5_a13 JTF_VARCHAR2_TABLE_500
202     , p5_a14 JTF_VARCHAR2_TABLE_500
203     , p5_a15 JTF_VARCHAR2_TABLE_500
204     , p5_a16 JTF_VARCHAR2_TABLE_500
205     , p5_a17 JTF_VARCHAR2_TABLE_500
206     , p5_a18 JTF_VARCHAR2_TABLE_500
207     , p5_a19 JTF_VARCHAR2_TABLE_500
208     , p5_a20 JTF_VARCHAR2_TABLE_500
209     , p5_a21 JTF_NUMBER_TABLE
210     , p5_a22 JTF_DATE_TABLE
211     , p5_a23 JTF_NUMBER_TABLE
212     , p5_a24 JTF_DATE_TABLE
213     , p5_a25 JTF_NUMBER_TABLE
214     , p6_a0 out nocopy JTF_NUMBER_TABLE
215     , p6_a1 out nocopy JTF_NUMBER_TABLE
216     , p6_a2 out nocopy JTF_NUMBER_TABLE
217     , p6_a3 out nocopy JTF_NUMBER_TABLE
218     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
219     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
220     , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
221     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
222     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
223     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
224     , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
225     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
226     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
227     , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
228     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
229     , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
230     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
231     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
232     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
233     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
234     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
235     , p6_a21 out nocopy JTF_NUMBER_TABLE
236     , p6_a22 out nocopy JTF_DATE_TABLE
237     , p6_a23 out nocopy JTF_NUMBER_TABLE
238     , p6_a24 out nocopy JTF_DATE_TABLE
239     , p6_a25 out nocopy JTF_NUMBER_TABLE
240   );
241   procedure update_strm_type_exempt(p_api_version  NUMBER
242     , p_init_msg_list  VARCHAR2
243     , x_return_status out nocopy  VARCHAR2
244     , x_msg_count out nocopy  NUMBER
245     , x_msg_data out nocopy  VARCHAR2
246     , p6_a0 out nocopy  NUMBER
247     , p6_a1 out nocopy  NUMBER
248     , p6_a2 out nocopy  NUMBER
249     , p6_a3 out nocopy  NUMBER
250     , p6_a4 out nocopy  VARCHAR2
251     , p6_a5 out nocopy  VARCHAR2
252     , p6_a6 out nocopy  VARCHAR2
253     , p6_a7 out nocopy  VARCHAR2
254     , p6_a8 out nocopy  VARCHAR2
255     , p6_a9 out nocopy  VARCHAR2
256     , p6_a10 out nocopy  VARCHAR2
257     , p6_a11 out nocopy  VARCHAR2
258     , p6_a12 out nocopy  VARCHAR2
259     , p6_a13 out nocopy  VARCHAR2
260     , p6_a14 out nocopy  VARCHAR2
261     , p6_a15 out nocopy  VARCHAR2
262     , p6_a16 out nocopy  VARCHAR2
263     , p6_a17 out nocopy  VARCHAR2
264     , p6_a18 out nocopy  VARCHAR2
265     , p6_a19 out nocopy  VARCHAR2
266     , p6_a20 out nocopy  VARCHAR2
267     , p6_a21 out nocopy  NUMBER
268     , p6_a22 out nocopy  DATE
269     , p6_a23 out nocopy  NUMBER
270     , p6_a24 out nocopy  DATE
271     , p6_a25 out nocopy  NUMBER
272     , p5_a0  NUMBER := 0-1962.0724
273     , p5_a1  NUMBER := 0-1962.0724
274     , p5_a2  NUMBER := 0-1962.0724
275     , p5_a3  NUMBER := 0-1962.0724
276     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
277     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
278     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
279     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
280     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
281     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
282     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
283     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
284     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
285     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
286     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
287     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
288     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
289     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
290     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
291     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
292     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
293     , p5_a21  NUMBER := 0-1962.0724
294     , p5_a22  DATE := fnd_api.g_miss_date
295     , p5_a23  NUMBER := 0-1962.0724
296     , p5_a24  DATE := fnd_api.g_miss_date
297     , p5_a25  NUMBER := 0-1962.0724
298   );
299   procedure delete_strm_type_exempt(p_api_version  NUMBER
300     , p_init_msg_list  VARCHAR2
301     , x_return_status out nocopy  VARCHAR2
302     , x_msg_count out nocopy  NUMBER
303     , x_msg_data out nocopy  VARCHAR2
304     , p5_a0 JTF_NUMBER_TABLE
305     , p5_a1 JTF_NUMBER_TABLE
306     , p5_a2 JTF_NUMBER_TABLE
307     , p5_a3 JTF_NUMBER_TABLE
308     , p5_a4 JTF_VARCHAR2_TABLE_100
309     , p5_a5 JTF_VARCHAR2_TABLE_100
310     , p5_a6 JTF_VARCHAR2_TABLE_500
311     , p5_a7 JTF_VARCHAR2_TABLE_500
312     , p5_a8 JTF_VARCHAR2_TABLE_500
313     , p5_a9 JTF_VARCHAR2_TABLE_500
314     , p5_a10 JTF_VARCHAR2_TABLE_500
315     , p5_a11 JTF_VARCHAR2_TABLE_500
316     , p5_a12 JTF_VARCHAR2_TABLE_500
317     , p5_a13 JTF_VARCHAR2_TABLE_500
318     , p5_a14 JTF_VARCHAR2_TABLE_500
319     , p5_a15 JTF_VARCHAR2_TABLE_500
320     , p5_a16 JTF_VARCHAR2_TABLE_500
321     , p5_a17 JTF_VARCHAR2_TABLE_500
322     , p5_a18 JTF_VARCHAR2_TABLE_500
323     , p5_a19 JTF_VARCHAR2_TABLE_500
324     , p5_a20 JTF_VARCHAR2_TABLE_500
325     , p5_a21 JTF_NUMBER_TABLE
326     , p5_a22 JTF_DATE_TABLE
327     , p5_a23 JTF_NUMBER_TABLE
328     , p5_a24 JTF_DATE_TABLE
329     , p5_a25 JTF_NUMBER_TABLE
330   );
331   procedure delete_strm_type_exempt(p_api_version  NUMBER
332     , p_init_msg_list  VARCHAR2
333     , x_return_status out nocopy  VARCHAR2
334     , x_msg_count out nocopy  NUMBER
335     , x_msg_data out nocopy  VARCHAR2
336     , p5_a0  NUMBER := 0-1962.0724
337     , p5_a1  NUMBER := 0-1962.0724
338     , p5_a2  NUMBER := 0-1962.0724
339     , p5_a3  NUMBER := 0-1962.0724
340     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
341     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
342     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
343     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
344     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
345     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
346     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
347     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
348     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
349     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
350     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
351     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
352     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
353     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
354     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
355     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
356     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
357     , p5_a21  NUMBER := 0-1962.0724
358     , p5_a22  DATE := fnd_api.g_miss_date
359     , p5_a23  NUMBER := 0-1962.0724
360     , p5_a24  DATE := fnd_api.g_miss_date
361     , p5_a25  NUMBER := 0-1962.0724
362   );
363   procedure validate_strm_type_exempt(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_VARCHAR2_TABLE_100
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_NUMBER_TABLE
390     , p5_a22 JTF_DATE_TABLE
391     , p5_a23 JTF_NUMBER_TABLE
392     , p5_a24 JTF_DATE_TABLE
393     , p5_a25 JTF_NUMBER_TABLE
394   );
395   procedure validate_strm_type_exempt(p_api_version  NUMBER
396     , p_init_msg_list  VARCHAR2
397     , x_return_status out nocopy  VARCHAR2
398     , x_msg_count out nocopy  NUMBER
399     , x_msg_data out nocopy  VARCHAR2
400     , p5_a0  NUMBER := 0-1962.0724
401     , p5_a1  NUMBER := 0-1962.0724
402     , p5_a2  NUMBER := 0-1962.0724
403     , p5_a3  NUMBER := 0-1962.0724
404     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
405     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
406     , p5_a6  VARCHAR2 := fnd_api.g_miss_char
407     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
408     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
409     , p5_a9  VARCHAR2 := fnd_api.g_miss_char
410     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
411     , p5_a11  VARCHAR2 := fnd_api.g_miss_char
412     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
413     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
414     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
415     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
416     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
417     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
418     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
419     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
420     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
421     , p5_a21  NUMBER := 0-1962.0724
422     , p5_a22  DATE := fnd_api.g_miss_date
423     , p5_a23  NUMBER := 0-1962.0724
424     , p5_a24  DATE := fnd_api.g_miss_date
425     , p5_a25  NUMBER := 0-1962.0724
426   );
427 end okl_strm_type_exempt_pub_w;