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_PUB_W

Source


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