[Home] [Help]
PACKAGE: APPS.OKL_STREAMS_PVT_W
Source
1 package okl_streams_pvt_w as
2 /* $Header: OKLOSTMS.pls 120.3 2005/09/02 12:40:53 mansrini noship $ */
3 procedure create_streams(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 JTF_NUMBER_TABLE
9 , p6_a1 JTF_NUMBER_TABLE
10 , p6_a2 JTF_NUMBER_TABLE
11 , p6_a3 JTF_NUMBER_TABLE
12 , p6_a4 JTF_VARCHAR2_TABLE_2000
13 , p6_a5 JTF_VARCHAR2_TABLE_100
14 , p6_a6 JTF_DATE_TABLE
15 , p6_a7 JTF_NUMBER_TABLE
16 , p6_a8 JTF_NUMBER_TABLE
17 , p6_a9 JTF_NUMBER_TABLE
18 , p6_a10 JTF_DATE_TABLE
19 , p6_a11 JTF_NUMBER_TABLE
20 , p6_a12 JTF_DATE_TABLE
21 , p6_a13 JTF_NUMBER_TABLE
22 , p6_a14 JTF_DATE_TABLE
23 , p6_a15 JTF_NUMBER_TABLE
24 , p6_a16 JTF_DATE_TABLE
25 , p6_a17 JTF_NUMBER_TABLE
26 , p6_a18 JTF_NUMBER_TABLE
27 , p6_a19 JTF_NUMBER_TABLE
28 , p6_a20 JTF_NUMBER_TABLE
29 , p6_a21 JTF_VARCHAR2_TABLE_100
30 , p6_a22 JTF_VARCHAR2_TABLE_100
31 , p6_a23 JTF_VARCHAR2_TABLE_100
32 , p6_a24 JTF_DATE_TABLE
33 , p7_a0 out nocopy NUMBER
34 , p7_a1 out nocopy NUMBER
35 , p7_a2 out nocopy NUMBER
36 , p7_a3 out nocopy NUMBER
37 , p7_a4 out nocopy VARCHAR2
38 , p7_a5 out nocopy VARCHAR2
39 , p7_a6 out nocopy NUMBER
40 , p7_a7 out nocopy VARCHAR2
41 , p7_a8 out nocopy NUMBER
42 , p7_a9 out nocopy NUMBER
43 , p7_a10 out nocopy DATE
44 , p7_a11 out nocopy NUMBER
45 , p7_a12 out nocopy DATE
46 , p7_a13 out nocopy DATE
47 , p7_a14 out nocopy DATE
48 , p7_a15 out nocopy DATE
49 , p7_a16 out nocopy VARCHAR2
50 , p7_a17 out nocopy NUMBER
51 , p7_a18 out nocopy NUMBER
52 , p7_a19 out nocopy NUMBER
53 , p7_a20 out nocopy DATE
54 , p7_a21 out nocopy NUMBER
55 , p7_a22 out nocopy VARCHAR2
56 , p7_a23 out nocopy NUMBER
57 , p7_a24 out nocopy NUMBER
58 , p7_a25 out nocopy VARCHAR2
59 , p7_a26 out nocopy NUMBER
60 , p7_a27 out nocopy NUMBER
61 , p8_a0 out nocopy JTF_NUMBER_TABLE
62 , p8_a1 out nocopy JTF_NUMBER_TABLE
63 , p8_a2 out nocopy JTF_NUMBER_TABLE
64 , p8_a3 out nocopy JTF_NUMBER_TABLE
65 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
66 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
67 , p8_a6 out nocopy JTF_DATE_TABLE
68 , p8_a7 out nocopy JTF_NUMBER_TABLE
69 , p8_a8 out nocopy JTF_NUMBER_TABLE
70 , p8_a9 out nocopy JTF_NUMBER_TABLE
71 , p8_a10 out nocopy JTF_DATE_TABLE
72 , p8_a11 out nocopy JTF_NUMBER_TABLE
73 , p8_a12 out nocopy JTF_DATE_TABLE
74 , p8_a13 out nocopy JTF_NUMBER_TABLE
75 , p8_a14 out nocopy JTF_DATE_TABLE
76 , p8_a15 out nocopy JTF_NUMBER_TABLE
77 , p8_a16 out nocopy JTF_DATE_TABLE
78 , p8_a17 out nocopy JTF_NUMBER_TABLE
79 , p8_a18 out nocopy JTF_NUMBER_TABLE
80 , p8_a19 out nocopy JTF_NUMBER_TABLE
81 , p8_a20 out nocopy JTF_NUMBER_TABLE
82 , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
83 , p8_a22 out nocopy JTF_VARCHAR2_TABLE_100
84 , p8_a23 out nocopy JTF_VARCHAR2_TABLE_100
85 , p8_a24 out nocopy JTF_DATE_TABLE
86 , p5_a0 NUMBER := 0-1962.0724
87 , p5_a1 NUMBER := 0-1962.0724
88 , p5_a2 NUMBER := 0-1962.0724
89 , p5_a3 NUMBER := 0-1962.0724
90 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
91 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
92 , p5_a6 NUMBER := 0-1962.0724
93 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
94 , p5_a8 NUMBER := 0-1962.0724
95 , p5_a9 NUMBER := 0-1962.0724
96 , p5_a10 DATE := fnd_api.g_miss_date
97 , p5_a11 NUMBER := 0-1962.0724
98 , p5_a12 DATE := fnd_api.g_miss_date
99 , p5_a13 DATE := fnd_api.g_miss_date
100 , p5_a14 DATE := fnd_api.g_miss_date
101 , p5_a15 DATE := fnd_api.g_miss_date
102 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
103 , p5_a17 NUMBER := 0-1962.0724
104 , p5_a18 NUMBER := 0-1962.0724
105 , p5_a19 NUMBER := 0-1962.0724
106 , p5_a20 DATE := fnd_api.g_miss_date
107 , p5_a21 NUMBER := 0-1962.0724
108 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
109 , p5_a23 NUMBER := 0-1962.0724
110 , p5_a24 NUMBER := 0-1962.0724
111 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
112 , p5_a26 NUMBER := 0-1962.0724
113 , p5_a27 NUMBER := 0-1962.0724
114 );
115 procedure create_streams(p_api_version NUMBER
116 , p_init_msg_list VARCHAR2
117 , x_return_status out nocopy VARCHAR2
118 , x_msg_count out nocopy NUMBER
119 , x_msg_data out nocopy VARCHAR2
120 , p5_a0 JTF_NUMBER_TABLE
121 , p5_a1 JTF_NUMBER_TABLE
122 , p5_a2 JTF_NUMBER_TABLE
123 , p5_a3 JTF_NUMBER_TABLE
124 , p5_a4 JTF_VARCHAR2_TABLE_100
125 , p5_a5 JTF_VARCHAR2_TABLE_100
126 , p5_a6 JTF_NUMBER_TABLE
127 , p5_a7 JTF_VARCHAR2_TABLE_100
128 , p5_a8 JTF_NUMBER_TABLE
129 , p5_a9 JTF_NUMBER_TABLE
130 , p5_a10 JTF_DATE_TABLE
131 , p5_a11 JTF_NUMBER_TABLE
132 , p5_a12 JTF_DATE_TABLE
133 , p5_a13 JTF_DATE_TABLE
134 , p5_a14 JTF_DATE_TABLE
135 , p5_a15 JTF_DATE_TABLE
136 , p5_a16 JTF_VARCHAR2_TABLE_2000
137 , p5_a17 JTF_NUMBER_TABLE
138 , p5_a18 JTF_NUMBER_TABLE
139 , p5_a19 JTF_NUMBER_TABLE
140 , p5_a20 JTF_DATE_TABLE
141 , p5_a21 JTF_NUMBER_TABLE
142 , p5_a22 JTF_VARCHAR2_TABLE_100
143 , p5_a23 JTF_NUMBER_TABLE
144 , p5_a24 JTF_NUMBER_TABLE
145 , p5_a25 JTF_VARCHAR2_TABLE_100
146 , p5_a26 JTF_NUMBER_TABLE
147 , p5_a27 JTF_NUMBER_TABLE
148 , p6_a0 JTF_NUMBER_TABLE
149 , p6_a1 JTF_NUMBER_TABLE
150 , p6_a2 JTF_NUMBER_TABLE
151 , p6_a3 JTF_NUMBER_TABLE
152 , p6_a4 JTF_VARCHAR2_TABLE_2000
153 , p6_a5 JTF_VARCHAR2_TABLE_100
154 , p6_a6 JTF_DATE_TABLE
155 , p6_a7 JTF_NUMBER_TABLE
156 , p6_a8 JTF_NUMBER_TABLE
157 , p6_a9 JTF_NUMBER_TABLE
158 , p6_a10 JTF_DATE_TABLE
159 , p6_a11 JTF_NUMBER_TABLE
160 , p6_a12 JTF_DATE_TABLE
161 , p6_a13 JTF_NUMBER_TABLE
162 , p6_a14 JTF_DATE_TABLE
163 , p6_a15 JTF_NUMBER_TABLE
164 , p6_a16 JTF_DATE_TABLE
165 , p6_a17 JTF_NUMBER_TABLE
166 , p6_a18 JTF_NUMBER_TABLE
167 , p6_a19 JTF_NUMBER_TABLE
168 , p6_a20 JTF_NUMBER_TABLE
169 , p6_a21 JTF_VARCHAR2_TABLE_100
170 , p6_a22 JTF_VARCHAR2_TABLE_100
171 , p6_a23 JTF_VARCHAR2_TABLE_100
172 , p6_a24 JTF_DATE_TABLE
173 , p7_a0 out nocopy JTF_NUMBER_TABLE
174 , p7_a1 out nocopy JTF_NUMBER_TABLE
175 , p7_a2 out nocopy JTF_NUMBER_TABLE
176 , p7_a3 out nocopy JTF_NUMBER_TABLE
177 , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
178 , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
179 , p7_a6 out nocopy JTF_NUMBER_TABLE
180 , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
181 , p7_a8 out nocopy JTF_NUMBER_TABLE
182 , p7_a9 out nocopy JTF_NUMBER_TABLE
183 , p7_a10 out nocopy JTF_DATE_TABLE
184 , p7_a11 out nocopy JTF_NUMBER_TABLE
185 , p7_a12 out nocopy JTF_DATE_TABLE
186 , p7_a13 out nocopy JTF_DATE_TABLE
187 , p7_a14 out nocopy JTF_DATE_TABLE
188 , p7_a15 out nocopy JTF_DATE_TABLE
189 , p7_a16 out nocopy JTF_VARCHAR2_TABLE_2000
190 , p7_a17 out nocopy JTF_NUMBER_TABLE
191 , p7_a18 out nocopy JTF_NUMBER_TABLE
192 , p7_a19 out nocopy JTF_NUMBER_TABLE
193 , p7_a20 out nocopy JTF_DATE_TABLE
194 , p7_a21 out nocopy JTF_NUMBER_TABLE
195 , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
196 , p7_a23 out nocopy JTF_NUMBER_TABLE
197 , p7_a24 out nocopy JTF_NUMBER_TABLE
198 , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
199 , p7_a26 out nocopy JTF_NUMBER_TABLE
200 , p7_a27 out nocopy JTF_NUMBER_TABLE
201 , p8_a0 out nocopy JTF_NUMBER_TABLE
202 , p8_a1 out nocopy JTF_NUMBER_TABLE
203 , p8_a2 out nocopy JTF_NUMBER_TABLE
204 , p8_a3 out nocopy JTF_NUMBER_TABLE
205 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
206 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
207 , p8_a6 out nocopy JTF_DATE_TABLE
208 , p8_a7 out nocopy JTF_NUMBER_TABLE
209 , p8_a8 out nocopy JTF_NUMBER_TABLE
210 , p8_a9 out nocopy JTF_NUMBER_TABLE
211 , p8_a10 out nocopy JTF_DATE_TABLE
212 , p8_a11 out nocopy JTF_NUMBER_TABLE
213 , p8_a12 out nocopy JTF_DATE_TABLE
214 , p8_a13 out nocopy JTF_NUMBER_TABLE
215 , p8_a14 out nocopy JTF_DATE_TABLE
216 , p8_a15 out nocopy JTF_NUMBER_TABLE
217 , p8_a16 out nocopy JTF_DATE_TABLE
218 , p8_a17 out nocopy JTF_NUMBER_TABLE
219 , p8_a18 out nocopy JTF_NUMBER_TABLE
220 , p8_a19 out nocopy JTF_NUMBER_TABLE
221 , p8_a20 out nocopy JTF_NUMBER_TABLE
222 , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
223 , p8_a22 out nocopy JTF_VARCHAR2_TABLE_100
224 , p8_a23 out nocopy JTF_VARCHAR2_TABLE_100
225 , p8_a24 out nocopy JTF_DATE_TABLE
226 );
227 procedure create_streams_perf(p_api_version NUMBER
228 , p_init_msg_list VARCHAR2
229 , x_return_status out nocopy VARCHAR2
230 , x_msg_count out nocopy NUMBER
231 , x_msg_data out nocopy VARCHAR2
232 , p5_a0 JTF_NUMBER_TABLE
233 , p5_a1 JTF_NUMBER_TABLE
234 , p5_a2 JTF_NUMBER_TABLE
235 , p5_a3 JTF_NUMBER_TABLE
236 , p5_a4 JTF_VARCHAR2_TABLE_100
237 , p5_a5 JTF_VARCHAR2_TABLE_100
238 , p5_a6 JTF_NUMBER_TABLE
239 , p5_a7 JTF_VARCHAR2_TABLE_100
240 , p5_a8 JTF_NUMBER_TABLE
241 , p5_a9 JTF_NUMBER_TABLE
242 , p5_a10 JTF_DATE_TABLE
243 , p5_a11 JTF_NUMBER_TABLE
244 , p5_a12 JTF_DATE_TABLE
245 , p5_a13 JTF_DATE_TABLE
246 , p5_a14 JTF_DATE_TABLE
247 , p5_a15 JTF_DATE_TABLE
248 , p5_a16 JTF_VARCHAR2_TABLE_2000
249 , p5_a17 JTF_NUMBER_TABLE
250 , p5_a18 JTF_NUMBER_TABLE
251 , p5_a19 JTF_NUMBER_TABLE
252 , p5_a20 JTF_DATE_TABLE
253 , p5_a21 JTF_NUMBER_TABLE
254 , p5_a22 JTF_VARCHAR2_TABLE_100
255 , p5_a23 JTF_NUMBER_TABLE
256 , p5_a24 JTF_NUMBER_TABLE
257 , p5_a25 JTF_VARCHAR2_TABLE_100
258 , p5_a26 JTF_NUMBER_TABLE
259 , p5_a27 JTF_NUMBER_TABLE
260 , p6_a0 JTF_NUMBER_TABLE
261 , p6_a1 JTF_NUMBER_TABLE
262 , p6_a2 JTF_NUMBER_TABLE
263 , p6_a3 JTF_NUMBER_TABLE
264 , p6_a4 JTF_VARCHAR2_TABLE_2000
265 , p6_a5 JTF_VARCHAR2_TABLE_100
266 , p6_a6 JTF_DATE_TABLE
267 , p6_a7 JTF_NUMBER_TABLE
268 , p6_a8 JTF_NUMBER_TABLE
269 , p6_a9 JTF_NUMBER_TABLE
270 , p6_a10 JTF_DATE_TABLE
271 , p6_a11 JTF_NUMBER_TABLE
272 , p6_a12 JTF_DATE_TABLE
273 , p6_a13 JTF_NUMBER_TABLE
274 , p6_a14 JTF_DATE_TABLE
275 , p6_a15 JTF_NUMBER_TABLE
276 , p6_a16 JTF_DATE_TABLE
277 , p6_a17 JTF_NUMBER_TABLE
278 , p6_a18 JTF_NUMBER_TABLE
279 , p6_a19 JTF_NUMBER_TABLE
280 , p6_a20 JTF_NUMBER_TABLE
281 , p6_a21 JTF_VARCHAR2_TABLE_100
282 , p6_a22 JTF_VARCHAR2_TABLE_100
283 , p6_a23 JTF_VARCHAR2_TABLE_100
284 , p6_a24 JTF_DATE_TABLE
285 , p7_a0 out nocopy JTF_NUMBER_TABLE
286 , p7_a1 out nocopy JTF_NUMBER_TABLE
287 , p7_a2 out nocopy JTF_NUMBER_TABLE
288 , p7_a3 out nocopy JTF_NUMBER_TABLE
289 , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
290 , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
291 , p7_a6 out nocopy JTF_NUMBER_TABLE
292 , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
293 , p7_a8 out nocopy JTF_NUMBER_TABLE
294 , p7_a9 out nocopy JTF_NUMBER_TABLE
295 , p7_a10 out nocopy JTF_DATE_TABLE
296 , p7_a11 out nocopy JTF_NUMBER_TABLE
297 , p7_a12 out nocopy JTF_DATE_TABLE
298 , p7_a13 out nocopy JTF_DATE_TABLE
299 , p7_a14 out nocopy JTF_DATE_TABLE
300 , p7_a15 out nocopy JTF_DATE_TABLE
301 , p7_a16 out nocopy JTF_VARCHAR2_TABLE_2000
302 , p7_a17 out nocopy JTF_NUMBER_TABLE
303 , p7_a18 out nocopy JTF_NUMBER_TABLE
304 , p7_a19 out nocopy JTF_NUMBER_TABLE
305 , p7_a20 out nocopy JTF_DATE_TABLE
306 , p7_a21 out nocopy JTF_NUMBER_TABLE
307 , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
308 , p7_a23 out nocopy JTF_NUMBER_TABLE
309 , p7_a24 out nocopy JTF_NUMBER_TABLE
310 , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
311 , p7_a26 out nocopy JTF_NUMBER_TABLE
312 , p7_a27 out nocopy JTF_NUMBER_TABLE
313 , p8_a0 out nocopy JTF_NUMBER_TABLE
314 , p8_a1 out nocopy JTF_NUMBER_TABLE
315 , p8_a2 out nocopy JTF_NUMBER_TABLE
316 , p8_a3 out nocopy JTF_NUMBER_TABLE
317 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
318 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
319 , p8_a6 out nocopy JTF_DATE_TABLE
320 , p8_a7 out nocopy JTF_NUMBER_TABLE
321 , p8_a8 out nocopy JTF_NUMBER_TABLE
322 , p8_a9 out nocopy JTF_NUMBER_TABLE
323 , p8_a10 out nocopy JTF_DATE_TABLE
324 , p8_a11 out nocopy JTF_NUMBER_TABLE
325 , p8_a12 out nocopy JTF_DATE_TABLE
326 , p8_a13 out nocopy JTF_NUMBER_TABLE
327 , p8_a14 out nocopy JTF_DATE_TABLE
328 , p8_a15 out nocopy JTF_NUMBER_TABLE
329 , p8_a16 out nocopy JTF_DATE_TABLE
330 , p8_a17 out nocopy JTF_NUMBER_TABLE
331 , p8_a18 out nocopy JTF_NUMBER_TABLE
332 , p8_a19 out nocopy JTF_NUMBER_TABLE
333 , p8_a20 out nocopy JTF_NUMBER_TABLE
334 , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
335 , p8_a22 out nocopy JTF_VARCHAR2_TABLE_100
336 , p8_a23 out nocopy JTF_VARCHAR2_TABLE_100
337 , p8_a24 out nocopy JTF_DATE_TABLE
338 );
339 procedure update_streams(p_api_version NUMBER
340 , p_init_msg_list VARCHAR2
341 , x_return_status out nocopy VARCHAR2
342 , x_msg_count out nocopy NUMBER
343 , x_msg_data out nocopy VARCHAR2
344 , p6_a0 JTF_NUMBER_TABLE
345 , p6_a1 JTF_NUMBER_TABLE
346 , p6_a2 JTF_NUMBER_TABLE
347 , p6_a3 JTF_NUMBER_TABLE
348 , p6_a4 JTF_VARCHAR2_TABLE_2000
349 , p6_a5 JTF_VARCHAR2_TABLE_100
350 , p6_a6 JTF_DATE_TABLE
351 , p6_a7 JTF_NUMBER_TABLE
352 , p6_a8 JTF_NUMBER_TABLE
353 , p6_a9 JTF_NUMBER_TABLE
354 , p6_a10 JTF_DATE_TABLE
355 , p6_a11 JTF_NUMBER_TABLE
356 , p6_a12 JTF_DATE_TABLE
357 , p6_a13 JTF_NUMBER_TABLE
358 , p6_a14 JTF_DATE_TABLE
359 , p6_a15 JTF_NUMBER_TABLE
360 , p6_a16 JTF_DATE_TABLE
361 , p6_a17 JTF_NUMBER_TABLE
362 , p6_a18 JTF_NUMBER_TABLE
363 , p6_a19 JTF_NUMBER_TABLE
364 , p6_a20 JTF_NUMBER_TABLE
365 , p6_a21 JTF_VARCHAR2_TABLE_100
366 , p6_a22 JTF_VARCHAR2_TABLE_100
367 , p6_a23 JTF_VARCHAR2_TABLE_100
368 , p6_a24 JTF_DATE_TABLE
369 , p7_a0 out nocopy NUMBER
370 , p7_a1 out nocopy NUMBER
371 , p7_a2 out nocopy NUMBER
372 , p7_a3 out nocopy NUMBER
373 , p7_a4 out nocopy VARCHAR2
374 , p7_a5 out nocopy VARCHAR2
375 , p7_a6 out nocopy NUMBER
376 , p7_a7 out nocopy VARCHAR2
377 , p7_a8 out nocopy NUMBER
378 , p7_a9 out nocopy NUMBER
379 , p7_a10 out nocopy DATE
380 , p7_a11 out nocopy NUMBER
381 , p7_a12 out nocopy DATE
382 , p7_a13 out nocopy DATE
383 , p7_a14 out nocopy DATE
384 , p7_a15 out nocopy DATE
385 , p7_a16 out nocopy VARCHAR2
386 , p7_a17 out nocopy NUMBER
387 , p7_a18 out nocopy NUMBER
388 , p7_a19 out nocopy NUMBER
389 , p7_a20 out nocopy DATE
390 , p7_a21 out nocopy NUMBER
391 , p7_a22 out nocopy VARCHAR2
392 , p7_a23 out nocopy NUMBER
393 , p7_a24 out nocopy NUMBER
394 , p7_a25 out nocopy VARCHAR2
395 , p7_a26 out nocopy NUMBER
396 , p7_a27 out nocopy NUMBER
397 , p8_a0 out nocopy JTF_NUMBER_TABLE
398 , p8_a1 out nocopy JTF_NUMBER_TABLE
399 , p8_a2 out nocopy JTF_NUMBER_TABLE
400 , p8_a3 out nocopy JTF_NUMBER_TABLE
401 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
402 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
403 , p8_a6 out nocopy JTF_DATE_TABLE
404 , p8_a7 out nocopy JTF_NUMBER_TABLE
405 , p8_a8 out nocopy JTF_NUMBER_TABLE
406 , p8_a9 out nocopy JTF_NUMBER_TABLE
407 , p8_a10 out nocopy JTF_DATE_TABLE
408 , p8_a11 out nocopy JTF_NUMBER_TABLE
409 , p8_a12 out nocopy JTF_DATE_TABLE
410 , p8_a13 out nocopy JTF_NUMBER_TABLE
411 , p8_a14 out nocopy JTF_DATE_TABLE
412 , p8_a15 out nocopy JTF_NUMBER_TABLE
413 , p8_a16 out nocopy JTF_DATE_TABLE
414 , p8_a17 out nocopy JTF_NUMBER_TABLE
415 , p8_a18 out nocopy JTF_NUMBER_TABLE
416 , p8_a19 out nocopy JTF_NUMBER_TABLE
417 , p8_a20 out nocopy JTF_NUMBER_TABLE
418 , p8_a21 out nocopy JTF_VARCHAR2_TABLE_100
419 , p8_a22 out nocopy JTF_VARCHAR2_TABLE_100
420 , p8_a23 out nocopy JTF_VARCHAR2_TABLE_100
421 , p8_a24 out nocopy JTF_DATE_TABLE
422 , p5_a0 NUMBER := 0-1962.0724
423 , p5_a1 NUMBER := 0-1962.0724
424 , p5_a2 NUMBER := 0-1962.0724
425 , p5_a3 NUMBER := 0-1962.0724
426 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
427 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
428 , p5_a6 NUMBER := 0-1962.0724
429 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
430 , p5_a8 NUMBER := 0-1962.0724
431 , p5_a9 NUMBER := 0-1962.0724
432 , p5_a10 DATE := fnd_api.g_miss_date
433 , p5_a11 NUMBER := 0-1962.0724
434 , p5_a12 DATE := fnd_api.g_miss_date
435 , p5_a13 DATE := fnd_api.g_miss_date
436 , p5_a14 DATE := fnd_api.g_miss_date
437 , p5_a15 DATE := fnd_api.g_miss_date
438 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
439 , p5_a17 NUMBER := 0-1962.0724
440 , p5_a18 NUMBER := 0-1962.0724
441 , p5_a19 NUMBER := 0-1962.0724
442 , p5_a20 DATE := fnd_api.g_miss_date
443 , p5_a21 NUMBER := 0-1962.0724
444 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
445 , p5_a23 NUMBER := 0-1962.0724
446 , p5_a24 NUMBER := 0-1962.0724
447 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
448 , p5_a26 NUMBER := 0-1962.0724
449 , p5_a27 NUMBER := 0-1962.0724
450 );
451 procedure validate_streams(p_api_version NUMBER
452 , p_init_msg_list VARCHAR2
453 , x_return_status out nocopy VARCHAR2
454 , x_msg_count out nocopy NUMBER
455 , x_msg_data out nocopy VARCHAR2
456 , p6_a0 JTF_NUMBER_TABLE
457 , p6_a1 JTF_NUMBER_TABLE
458 , p6_a2 JTF_NUMBER_TABLE
459 , p6_a3 JTF_NUMBER_TABLE
460 , p6_a4 JTF_VARCHAR2_TABLE_2000
461 , p6_a5 JTF_VARCHAR2_TABLE_100
462 , p6_a6 JTF_DATE_TABLE
463 , p6_a7 JTF_NUMBER_TABLE
464 , p6_a8 JTF_NUMBER_TABLE
465 , p6_a9 JTF_NUMBER_TABLE
466 , p6_a10 JTF_DATE_TABLE
467 , p6_a11 JTF_NUMBER_TABLE
468 , p6_a12 JTF_DATE_TABLE
469 , p6_a13 JTF_NUMBER_TABLE
470 , p6_a14 JTF_DATE_TABLE
471 , p6_a15 JTF_NUMBER_TABLE
472 , p6_a16 JTF_DATE_TABLE
473 , p6_a17 JTF_NUMBER_TABLE
474 , p6_a18 JTF_NUMBER_TABLE
475 , p6_a19 JTF_NUMBER_TABLE
476 , p6_a20 JTF_NUMBER_TABLE
477 , p6_a21 JTF_VARCHAR2_TABLE_100
478 , p6_a22 JTF_VARCHAR2_TABLE_100
479 , p6_a23 JTF_VARCHAR2_TABLE_100
480 , p6_a24 JTF_DATE_TABLE
481 , p5_a0 NUMBER := 0-1962.0724
482 , p5_a1 NUMBER := 0-1962.0724
483 , p5_a2 NUMBER := 0-1962.0724
484 , p5_a3 NUMBER := 0-1962.0724
485 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
486 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
487 , p5_a6 NUMBER := 0-1962.0724
488 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
489 , p5_a8 NUMBER := 0-1962.0724
490 , p5_a9 NUMBER := 0-1962.0724
491 , p5_a10 DATE := fnd_api.g_miss_date
492 , p5_a11 NUMBER := 0-1962.0724
493 , p5_a12 DATE := fnd_api.g_miss_date
494 , p5_a13 DATE := fnd_api.g_miss_date
495 , p5_a14 DATE := fnd_api.g_miss_date
496 , p5_a15 DATE := fnd_api.g_miss_date
497 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
498 , p5_a17 NUMBER := 0-1962.0724
499 , p5_a18 NUMBER := 0-1962.0724
500 , p5_a19 NUMBER := 0-1962.0724
501 , p5_a20 DATE := fnd_api.g_miss_date
502 , p5_a21 NUMBER := 0-1962.0724
503 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
504 , p5_a23 NUMBER := 0-1962.0724
505 , p5_a24 NUMBER := 0-1962.0724
506 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
507 , p5_a26 NUMBER := 0-1962.0724
508 , p5_a27 NUMBER := 0-1962.0724
509 );
510 procedure create_streams(p_api_version NUMBER
511 , p_init_msg_list VARCHAR2
512 , x_return_status out nocopy VARCHAR2
513 , x_msg_count out nocopy NUMBER
514 , x_msg_data out nocopy VARCHAR2
515 , p5_a0 JTF_NUMBER_TABLE
516 , p5_a1 JTF_NUMBER_TABLE
517 , p5_a2 JTF_NUMBER_TABLE
518 , p5_a3 JTF_NUMBER_TABLE
519 , p5_a4 JTF_VARCHAR2_TABLE_100
520 , p5_a5 JTF_VARCHAR2_TABLE_100
521 , p5_a6 JTF_NUMBER_TABLE
522 , p5_a7 JTF_VARCHAR2_TABLE_100
523 , p5_a8 JTF_NUMBER_TABLE
524 , p5_a9 JTF_NUMBER_TABLE
525 , p5_a10 JTF_DATE_TABLE
526 , p5_a11 JTF_NUMBER_TABLE
527 , p5_a12 JTF_DATE_TABLE
528 , p5_a13 JTF_DATE_TABLE
529 , p5_a14 JTF_DATE_TABLE
530 , p5_a15 JTF_DATE_TABLE
531 , p5_a16 JTF_VARCHAR2_TABLE_2000
532 , p5_a17 JTF_NUMBER_TABLE
533 , p5_a18 JTF_NUMBER_TABLE
534 , p5_a19 JTF_NUMBER_TABLE
535 , p5_a20 JTF_DATE_TABLE
536 , p5_a21 JTF_NUMBER_TABLE
537 , p5_a22 JTF_VARCHAR2_TABLE_100
538 , p5_a23 JTF_NUMBER_TABLE
539 , p5_a24 JTF_NUMBER_TABLE
540 , p5_a25 JTF_VARCHAR2_TABLE_100
541 , p5_a26 JTF_NUMBER_TABLE
542 , p5_a27 JTF_NUMBER_TABLE
543 , p6_a0 out nocopy JTF_NUMBER_TABLE
544 , p6_a1 out nocopy JTF_NUMBER_TABLE
545 , p6_a2 out nocopy JTF_NUMBER_TABLE
546 , p6_a3 out nocopy JTF_NUMBER_TABLE
547 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
548 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
549 , p6_a6 out nocopy JTF_NUMBER_TABLE
550 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
551 , p6_a8 out nocopy JTF_NUMBER_TABLE
552 , p6_a9 out nocopy JTF_NUMBER_TABLE
553 , p6_a10 out nocopy JTF_DATE_TABLE
554 , p6_a11 out nocopy JTF_NUMBER_TABLE
555 , p6_a12 out nocopy JTF_DATE_TABLE
556 , p6_a13 out nocopy JTF_DATE_TABLE
557 , p6_a14 out nocopy JTF_DATE_TABLE
558 , p6_a15 out nocopy JTF_DATE_TABLE
559 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
560 , p6_a17 out nocopy JTF_NUMBER_TABLE
561 , p6_a18 out nocopy JTF_NUMBER_TABLE
562 , p6_a19 out nocopy JTF_NUMBER_TABLE
563 , p6_a20 out nocopy JTF_DATE_TABLE
564 , p6_a21 out nocopy JTF_NUMBER_TABLE
565 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
566 , p6_a23 out nocopy JTF_NUMBER_TABLE
567 , p6_a24 out nocopy JTF_NUMBER_TABLE
568 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
569 , p6_a26 out nocopy JTF_NUMBER_TABLE
570 , p6_a27 out nocopy JTF_NUMBER_TABLE
571 );
572 procedure create_streams(p_api_version NUMBER
573 , p_init_msg_list VARCHAR2
574 , x_return_status out nocopy VARCHAR2
575 , x_msg_count out nocopy NUMBER
576 , x_msg_data out nocopy VARCHAR2
577 , p6_a0 out nocopy NUMBER
578 , p6_a1 out nocopy NUMBER
579 , p6_a2 out nocopy NUMBER
580 , p6_a3 out nocopy NUMBER
581 , p6_a4 out nocopy VARCHAR2
582 , p6_a5 out nocopy VARCHAR2
583 , p6_a6 out nocopy NUMBER
584 , p6_a7 out nocopy VARCHAR2
585 , p6_a8 out nocopy NUMBER
586 , p6_a9 out nocopy NUMBER
587 , p6_a10 out nocopy DATE
588 , p6_a11 out nocopy NUMBER
589 , p6_a12 out nocopy DATE
590 , p6_a13 out nocopy DATE
591 , p6_a14 out nocopy DATE
592 , p6_a15 out nocopy DATE
593 , p6_a16 out nocopy VARCHAR2
594 , p6_a17 out nocopy NUMBER
595 , p6_a18 out nocopy NUMBER
596 , p6_a19 out nocopy NUMBER
597 , p6_a20 out nocopy DATE
598 , p6_a21 out nocopy NUMBER
599 , p6_a22 out nocopy VARCHAR2
600 , p6_a23 out nocopy NUMBER
601 , p6_a24 out nocopy NUMBER
602 , p6_a25 out nocopy VARCHAR2
603 , p6_a26 out nocopy NUMBER
604 , p6_a27 out nocopy NUMBER
605 , p5_a0 NUMBER := 0-1962.0724
606 , p5_a1 NUMBER := 0-1962.0724
607 , p5_a2 NUMBER := 0-1962.0724
608 , p5_a3 NUMBER := 0-1962.0724
609 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
610 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
611 , p5_a6 NUMBER := 0-1962.0724
612 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
613 , p5_a8 NUMBER := 0-1962.0724
614 , p5_a9 NUMBER := 0-1962.0724
615 , p5_a10 DATE := fnd_api.g_miss_date
616 , p5_a11 NUMBER := 0-1962.0724
617 , p5_a12 DATE := fnd_api.g_miss_date
618 , p5_a13 DATE := fnd_api.g_miss_date
619 , p5_a14 DATE := fnd_api.g_miss_date
620 , p5_a15 DATE := fnd_api.g_miss_date
621 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
622 , p5_a17 NUMBER := 0-1962.0724
623 , p5_a18 NUMBER := 0-1962.0724
624 , p5_a19 NUMBER := 0-1962.0724
625 , p5_a20 DATE := fnd_api.g_miss_date
626 , p5_a21 NUMBER := 0-1962.0724
627 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
628 , p5_a23 NUMBER := 0-1962.0724
629 , p5_a24 NUMBER := 0-1962.0724
630 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
631 , p5_a26 NUMBER := 0-1962.0724
632 , p5_a27 NUMBER := 0-1962.0724
633 );
634 procedure lock_streams(p_api_version NUMBER
635 , p_init_msg_list VARCHAR2
636 , x_return_status out nocopy VARCHAR2
637 , x_msg_count out nocopy NUMBER
638 , x_msg_data out nocopy VARCHAR2
639 , p5_a0 JTF_NUMBER_TABLE
640 , p5_a1 JTF_NUMBER_TABLE
641 , p5_a2 JTF_NUMBER_TABLE
642 , p5_a3 JTF_NUMBER_TABLE
643 , p5_a4 JTF_VARCHAR2_TABLE_100
644 , p5_a5 JTF_VARCHAR2_TABLE_100
645 , p5_a6 JTF_NUMBER_TABLE
646 , p5_a7 JTF_VARCHAR2_TABLE_100
647 , p5_a8 JTF_NUMBER_TABLE
648 , p5_a9 JTF_NUMBER_TABLE
649 , p5_a10 JTF_DATE_TABLE
650 , p5_a11 JTF_NUMBER_TABLE
651 , p5_a12 JTF_DATE_TABLE
652 , p5_a13 JTF_DATE_TABLE
653 , p5_a14 JTF_DATE_TABLE
654 , p5_a15 JTF_DATE_TABLE
655 , p5_a16 JTF_VARCHAR2_TABLE_2000
656 , p5_a17 JTF_NUMBER_TABLE
657 , p5_a18 JTF_NUMBER_TABLE
658 , p5_a19 JTF_NUMBER_TABLE
659 , p5_a20 JTF_DATE_TABLE
660 , p5_a21 JTF_NUMBER_TABLE
661 , p5_a22 JTF_VARCHAR2_TABLE_100
662 , p5_a23 JTF_NUMBER_TABLE
663 , p5_a24 JTF_NUMBER_TABLE
664 , p5_a25 JTF_VARCHAR2_TABLE_100
665 , p5_a26 JTF_NUMBER_TABLE
666 , p5_a27 JTF_NUMBER_TABLE
667 );
668 procedure lock_streams(p_api_version NUMBER
669 , p_init_msg_list VARCHAR2
670 , x_return_status out nocopy VARCHAR2
671 , x_msg_count out nocopy NUMBER
672 , x_msg_data out nocopy VARCHAR2
673 , p5_a0 NUMBER := 0-1962.0724
674 , p5_a1 NUMBER := 0-1962.0724
675 , p5_a2 NUMBER := 0-1962.0724
676 , p5_a3 NUMBER := 0-1962.0724
677 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
678 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
679 , p5_a6 NUMBER := 0-1962.0724
680 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
681 , p5_a8 NUMBER := 0-1962.0724
682 , p5_a9 NUMBER := 0-1962.0724
683 , p5_a10 DATE := fnd_api.g_miss_date
684 , p5_a11 NUMBER := 0-1962.0724
685 , p5_a12 DATE := fnd_api.g_miss_date
686 , p5_a13 DATE := fnd_api.g_miss_date
687 , p5_a14 DATE := fnd_api.g_miss_date
688 , p5_a15 DATE := fnd_api.g_miss_date
689 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
690 , p5_a17 NUMBER := 0-1962.0724
691 , p5_a18 NUMBER := 0-1962.0724
692 , p5_a19 NUMBER := 0-1962.0724
693 , p5_a20 DATE := fnd_api.g_miss_date
694 , p5_a21 NUMBER := 0-1962.0724
695 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
696 , p5_a23 NUMBER := 0-1962.0724
697 , p5_a24 NUMBER := 0-1962.0724
698 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
699 , p5_a26 NUMBER := 0-1962.0724
700 , p5_a27 NUMBER := 0-1962.0724
701 );
702 procedure update_streams(p_api_version NUMBER
703 , p_init_msg_list VARCHAR2
704 , x_return_status out nocopy VARCHAR2
705 , x_msg_count out nocopy NUMBER
706 , x_msg_data out nocopy VARCHAR2
707 , p5_a0 JTF_NUMBER_TABLE
708 , p5_a1 JTF_NUMBER_TABLE
709 , p5_a2 JTF_NUMBER_TABLE
710 , p5_a3 JTF_NUMBER_TABLE
711 , p5_a4 JTF_VARCHAR2_TABLE_100
712 , p5_a5 JTF_VARCHAR2_TABLE_100
713 , p5_a6 JTF_NUMBER_TABLE
714 , p5_a7 JTF_VARCHAR2_TABLE_100
715 , p5_a8 JTF_NUMBER_TABLE
716 , p5_a9 JTF_NUMBER_TABLE
717 , p5_a10 JTF_DATE_TABLE
718 , p5_a11 JTF_NUMBER_TABLE
719 , p5_a12 JTF_DATE_TABLE
720 , p5_a13 JTF_DATE_TABLE
721 , p5_a14 JTF_DATE_TABLE
722 , p5_a15 JTF_DATE_TABLE
723 , p5_a16 JTF_VARCHAR2_TABLE_2000
724 , p5_a17 JTF_NUMBER_TABLE
725 , p5_a18 JTF_NUMBER_TABLE
726 , p5_a19 JTF_NUMBER_TABLE
727 , p5_a20 JTF_DATE_TABLE
728 , p5_a21 JTF_NUMBER_TABLE
729 , p5_a22 JTF_VARCHAR2_TABLE_100
730 , p5_a23 JTF_NUMBER_TABLE
731 , p5_a24 JTF_NUMBER_TABLE
732 , p5_a25 JTF_VARCHAR2_TABLE_100
733 , p5_a26 JTF_NUMBER_TABLE
734 , p5_a27 JTF_NUMBER_TABLE
735 , p6_a0 out nocopy JTF_NUMBER_TABLE
736 , p6_a1 out nocopy JTF_NUMBER_TABLE
737 , p6_a2 out nocopy JTF_NUMBER_TABLE
738 , p6_a3 out nocopy JTF_NUMBER_TABLE
739 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
740 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
741 , p6_a6 out nocopy JTF_NUMBER_TABLE
742 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
743 , p6_a8 out nocopy JTF_NUMBER_TABLE
744 , p6_a9 out nocopy JTF_NUMBER_TABLE
745 , p6_a10 out nocopy JTF_DATE_TABLE
746 , p6_a11 out nocopy JTF_NUMBER_TABLE
747 , p6_a12 out nocopy JTF_DATE_TABLE
748 , p6_a13 out nocopy JTF_DATE_TABLE
749 , p6_a14 out nocopy JTF_DATE_TABLE
750 , p6_a15 out nocopy JTF_DATE_TABLE
751 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_2000
752 , p6_a17 out nocopy JTF_NUMBER_TABLE
753 , p6_a18 out nocopy JTF_NUMBER_TABLE
754 , p6_a19 out nocopy JTF_NUMBER_TABLE
755 , p6_a20 out nocopy JTF_DATE_TABLE
756 , p6_a21 out nocopy JTF_NUMBER_TABLE
757 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
758 , p6_a23 out nocopy JTF_NUMBER_TABLE
759 , p6_a24 out nocopy JTF_NUMBER_TABLE
760 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
761 , p6_a26 out nocopy JTF_NUMBER_TABLE
762 , p6_a27 out nocopy JTF_NUMBER_TABLE
763 );
764 procedure update_streams(p_api_version NUMBER
765 , p_init_msg_list VARCHAR2
766 , x_return_status out nocopy VARCHAR2
767 , x_msg_count out nocopy NUMBER
768 , x_msg_data out nocopy VARCHAR2
769 , p6_a0 out nocopy NUMBER
770 , p6_a1 out nocopy NUMBER
771 , p6_a2 out nocopy NUMBER
772 , p6_a3 out nocopy NUMBER
773 , p6_a4 out nocopy VARCHAR2
774 , p6_a5 out nocopy VARCHAR2
775 , p6_a6 out nocopy NUMBER
776 , p6_a7 out nocopy VARCHAR2
777 , p6_a8 out nocopy NUMBER
778 , p6_a9 out nocopy NUMBER
779 , p6_a10 out nocopy DATE
780 , p6_a11 out nocopy NUMBER
781 , p6_a12 out nocopy DATE
782 , p6_a13 out nocopy DATE
783 , p6_a14 out nocopy DATE
784 , p6_a15 out nocopy DATE
785 , p6_a16 out nocopy VARCHAR2
786 , p6_a17 out nocopy NUMBER
787 , p6_a18 out nocopy NUMBER
788 , p6_a19 out nocopy NUMBER
789 , p6_a20 out nocopy DATE
790 , p6_a21 out nocopy NUMBER
791 , p6_a22 out nocopy VARCHAR2
792 , p6_a23 out nocopy NUMBER
793 , p6_a24 out nocopy NUMBER
794 , p6_a25 out nocopy VARCHAR2
795 , p6_a26 out nocopy NUMBER
796 , p6_a27 out nocopy NUMBER
797 , p5_a0 NUMBER := 0-1962.0724
798 , p5_a1 NUMBER := 0-1962.0724
799 , p5_a2 NUMBER := 0-1962.0724
800 , p5_a3 NUMBER := 0-1962.0724
801 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
802 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
803 , p5_a6 NUMBER := 0-1962.0724
804 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
805 , p5_a8 NUMBER := 0-1962.0724
806 , p5_a9 NUMBER := 0-1962.0724
807 , p5_a10 DATE := fnd_api.g_miss_date
808 , p5_a11 NUMBER := 0-1962.0724
809 , p5_a12 DATE := fnd_api.g_miss_date
810 , p5_a13 DATE := fnd_api.g_miss_date
811 , p5_a14 DATE := fnd_api.g_miss_date
812 , p5_a15 DATE := fnd_api.g_miss_date
813 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
814 , p5_a17 NUMBER := 0-1962.0724
815 , p5_a18 NUMBER := 0-1962.0724
816 , p5_a19 NUMBER := 0-1962.0724
817 , p5_a20 DATE := fnd_api.g_miss_date
818 , p5_a21 NUMBER := 0-1962.0724
819 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
820 , p5_a23 NUMBER := 0-1962.0724
821 , p5_a24 NUMBER := 0-1962.0724
822 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
823 , p5_a26 NUMBER := 0-1962.0724
824 , p5_a27 NUMBER := 0-1962.0724
825 );
826 procedure delete_streams(p_api_version NUMBER
827 , p_init_msg_list VARCHAR2
828 , x_return_status out nocopy VARCHAR2
829 , x_msg_count out nocopy NUMBER
830 , x_msg_data out nocopy VARCHAR2
831 , p5_a0 JTF_NUMBER_TABLE
832 , p5_a1 JTF_NUMBER_TABLE
833 , p5_a2 JTF_NUMBER_TABLE
834 , p5_a3 JTF_NUMBER_TABLE
835 , p5_a4 JTF_VARCHAR2_TABLE_100
836 , p5_a5 JTF_VARCHAR2_TABLE_100
837 , p5_a6 JTF_NUMBER_TABLE
838 , p5_a7 JTF_VARCHAR2_TABLE_100
839 , p5_a8 JTF_NUMBER_TABLE
840 , p5_a9 JTF_NUMBER_TABLE
841 , p5_a10 JTF_DATE_TABLE
842 , p5_a11 JTF_NUMBER_TABLE
843 , p5_a12 JTF_DATE_TABLE
844 , p5_a13 JTF_DATE_TABLE
845 , p5_a14 JTF_DATE_TABLE
846 , p5_a15 JTF_DATE_TABLE
847 , p5_a16 JTF_VARCHAR2_TABLE_2000
848 , p5_a17 JTF_NUMBER_TABLE
849 , p5_a18 JTF_NUMBER_TABLE
850 , p5_a19 JTF_NUMBER_TABLE
851 , p5_a20 JTF_DATE_TABLE
852 , p5_a21 JTF_NUMBER_TABLE
853 , p5_a22 JTF_VARCHAR2_TABLE_100
854 , p5_a23 JTF_NUMBER_TABLE
855 , p5_a24 JTF_NUMBER_TABLE
856 , p5_a25 JTF_VARCHAR2_TABLE_100
857 , p5_a26 JTF_NUMBER_TABLE
858 , p5_a27 JTF_NUMBER_TABLE
859 );
860 procedure delete_streams(p_api_version NUMBER
861 , p_init_msg_list VARCHAR2
862 , x_return_status out nocopy VARCHAR2
863 , x_msg_count out nocopy NUMBER
864 , x_msg_data out nocopy VARCHAR2
865 , p5_a0 NUMBER := 0-1962.0724
866 , p5_a1 NUMBER := 0-1962.0724
867 , p5_a2 NUMBER := 0-1962.0724
868 , p5_a3 NUMBER := 0-1962.0724
869 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
870 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
871 , p5_a6 NUMBER := 0-1962.0724
872 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
873 , p5_a8 NUMBER := 0-1962.0724
874 , p5_a9 NUMBER := 0-1962.0724
875 , p5_a10 DATE := fnd_api.g_miss_date
876 , p5_a11 NUMBER := 0-1962.0724
877 , p5_a12 DATE := fnd_api.g_miss_date
878 , p5_a13 DATE := fnd_api.g_miss_date
879 , p5_a14 DATE := fnd_api.g_miss_date
880 , p5_a15 DATE := fnd_api.g_miss_date
881 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
882 , p5_a17 NUMBER := 0-1962.0724
883 , p5_a18 NUMBER := 0-1962.0724
884 , p5_a19 NUMBER := 0-1962.0724
885 , p5_a20 DATE := fnd_api.g_miss_date
886 , p5_a21 NUMBER := 0-1962.0724
887 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
888 , p5_a23 NUMBER := 0-1962.0724
889 , p5_a24 NUMBER := 0-1962.0724
890 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
891 , p5_a26 NUMBER := 0-1962.0724
892 , p5_a27 NUMBER := 0-1962.0724
893 );
894 procedure validate_streams(p_api_version NUMBER
895 , p_init_msg_list VARCHAR2
896 , x_return_status out nocopy VARCHAR2
897 , x_msg_count out nocopy NUMBER
898 , x_msg_data out nocopy VARCHAR2
899 , p5_a0 JTF_NUMBER_TABLE
900 , p5_a1 JTF_NUMBER_TABLE
901 , p5_a2 JTF_NUMBER_TABLE
902 , p5_a3 JTF_NUMBER_TABLE
903 , p5_a4 JTF_VARCHAR2_TABLE_100
904 , p5_a5 JTF_VARCHAR2_TABLE_100
905 , p5_a6 JTF_NUMBER_TABLE
906 , p5_a7 JTF_VARCHAR2_TABLE_100
907 , p5_a8 JTF_NUMBER_TABLE
908 , p5_a9 JTF_NUMBER_TABLE
909 , p5_a10 JTF_DATE_TABLE
910 , p5_a11 JTF_NUMBER_TABLE
911 , p5_a12 JTF_DATE_TABLE
912 , p5_a13 JTF_DATE_TABLE
913 , p5_a14 JTF_DATE_TABLE
914 , p5_a15 JTF_DATE_TABLE
915 , p5_a16 JTF_VARCHAR2_TABLE_2000
916 , p5_a17 JTF_NUMBER_TABLE
917 , p5_a18 JTF_NUMBER_TABLE
918 , p5_a19 JTF_NUMBER_TABLE
919 , p5_a20 JTF_DATE_TABLE
920 , p5_a21 JTF_NUMBER_TABLE
921 , p5_a22 JTF_VARCHAR2_TABLE_100
922 , p5_a23 JTF_NUMBER_TABLE
923 , p5_a24 JTF_NUMBER_TABLE
924 , p5_a25 JTF_VARCHAR2_TABLE_100
925 , p5_a26 JTF_NUMBER_TABLE
926 , p5_a27 JTF_NUMBER_TABLE
927 );
928 procedure validate_streams(p_api_version NUMBER
929 , p_init_msg_list VARCHAR2
930 , x_return_status out nocopy VARCHAR2
931 , x_msg_count out nocopy NUMBER
932 , x_msg_data out nocopy VARCHAR2
933 , p5_a0 NUMBER := 0-1962.0724
934 , p5_a1 NUMBER := 0-1962.0724
935 , p5_a2 NUMBER := 0-1962.0724
936 , p5_a3 NUMBER := 0-1962.0724
937 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
938 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
939 , p5_a6 NUMBER := 0-1962.0724
940 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
941 , p5_a8 NUMBER := 0-1962.0724
942 , p5_a9 NUMBER := 0-1962.0724
943 , p5_a10 DATE := fnd_api.g_miss_date
944 , p5_a11 NUMBER := 0-1962.0724
945 , p5_a12 DATE := fnd_api.g_miss_date
946 , p5_a13 DATE := fnd_api.g_miss_date
947 , p5_a14 DATE := fnd_api.g_miss_date
948 , p5_a15 DATE := fnd_api.g_miss_date
949 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
950 , p5_a17 NUMBER := 0-1962.0724
951 , p5_a18 NUMBER := 0-1962.0724
952 , p5_a19 NUMBER := 0-1962.0724
953 , p5_a20 DATE := fnd_api.g_miss_date
954 , p5_a21 NUMBER := 0-1962.0724
955 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
956 , p5_a23 NUMBER := 0-1962.0724
957 , p5_a24 NUMBER := 0-1962.0724
958 , p5_a25 VARCHAR2 := fnd_api.g_miss_char
959 , p5_a26 NUMBER := 0-1962.0724
960 , p5_a27 NUMBER := 0-1962.0724
961 );
962 procedure create_stream_elements(p_api_version NUMBER
963 , p_init_msg_list VARCHAR2
964 , x_return_status out nocopy VARCHAR2
965 , x_msg_count out nocopy NUMBER
966 , x_msg_data out nocopy VARCHAR2
967 , p5_a0 JTF_NUMBER_TABLE
968 , p5_a1 JTF_NUMBER_TABLE
969 , p5_a2 JTF_NUMBER_TABLE
970 , p5_a3 JTF_NUMBER_TABLE
971 , p5_a4 JTF_VARCHAR2_TABLE_2000
972 , p5_a5 JTF_VARCHAR2_TABLE_100
973 , p5_a6 JTF_DATE_TABLE
974 , p5_a7 JTF_NUMBER_TABLE
975 , p5_a8 JTF_NUMBER_TABLE
976 , p5_a9 JTF_NUMBER_TABLE
977 , p5_a10 JTF_DATE_TABLE
978 , p5_a11 JTF_NUMBER_TABLE
979 , p5_a12 JTF_DATE_TABLE
980 , p5_a13 JTF_NUMBER_TABLE
981 , p5_a14 JTF_DATE_TABLE
982 , p5_a15 JTF_NUMBER_TABLE
983 , p5_a16 JTF_DATE_TABLE
984 , p5_a17 JTF_NUMBER_TABLE
985 , p5_a18 JTF_NUMBER_TABLE
986 , p5_a19 JTF_NUMBER_TABLE
987 , p5_a20 JTF_NUMBER_TABLE
988 , p5_a21 JTF_VARCHAR2_TABLE_100
989 , p5_a22 JTF_VARCHAR2_TABLE_100
990 , p5_a23 JTF_VARCHAR2_TABLE_100
991 , p5_a24 JTF_DATE_TABLE
992 , p6_a0 out nocopy JTF_NUMBER_TABLE
993 , p6_a1 out nocopy JTF_NUMBER_TABLE
994 , p6_a2 out nocopy JTF_NUMBER_TABLE
995 , p6_a3 out nocopy JTF_NUMBER_TABLE
996 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
997 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
998 , p6_a6 out nocopy JTF_DATE_TABLE
999 , p6_a7 out nocopy JTF_NUMBER_TABLE
1000 , p6_a8 out nocopy JTF_NUMBER_TABLE
1001 , p6_a9 out nocopy JTF_NUMBER_TABLE
1002 , p6_a10 out nocopy JTF_DATE_TABLE
1003 , p6_a11 out nocopy JTF_NUMBER_TABLE
1004 , p6_a12 out nocopy JTF_DATE_TABLE
1005 , p6_a13 out nocopy JTF_NUMBER_TABLE
1006 , p6_a14 out nocopy JTF_DATE_TABLE
1007 , p6_a15 out nocopy JTF_NUMBER_TABLE
1008 , p6_a16 out nocopy JTF_DATE_TABLE
1009 , p6_a17 out nocopy JTF_NUMBER_TABLE
1010 , p6_a18 out nocopy JTF_NUMBER_TABLE
1011 , p6_a19 out nocopy JTF_NUMBER_TABLE
1012 , p6_a20 out nocopy JTF_NUMBER_TABLE
1013 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1014 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
1015 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
1016 , p6_a24 out nocopy JTF_DATE_TABLE
1017 );
1018 procedure create_stream_elements(p_api_version NUMBER
1019 , p_init_msg_list VARCHAR2
1020 , x_return_status out nocopy VARCHAR2
1021 , x_msg_count out nocopy NUMBER
1022 , x_msg_data out nocopy VARCHAR2
1023 , p6_a0 out nocopy NUMBER
1024 , p6_a1 out nocopy NUMBER
1025 , p6_a2 out nocopy NUMBER
1026 , p6_a3 out nocopy NUMBER
1027 , p6_a4 out nocopy VARCHAR2
1028 , p6_a5 out nocopy VARCHAR2
1029 , p6_a6 out nocopy DATE
1030 , p6_a7 out nocopy NUMBER
1031 , p6_a8 out nocopy NUMBER
1032 , p6_a9 out nocopy NUMBER
1033 , p6_a10 out nocopy DATE
1034 , p6_a11 out nocopy NUMBER
1035 , p6_a12 out nocopy DATE
1036 , p6_a13 out nocopy NUMBER
1037 , p6_a14 out nocopy DATE
1038 , p6_a15 out nocopy NUMBER
1039 , p6_a16 out nocopy DATE
1040 , p6_a17 out nocopy NUMBER
1041 , p6_a18 out nocopy NUMBER
1042 , p6_a19 out nocopy NUMBER
1043 , p6_a20 out nocopy NUMBER
1044 , p6_a21 out nocopy VARCHAR2
1045 , p6_a22 out nocopy VARCHAR2
1046 , p6_a23 out nocopy VARCHAR2
1047 , p6_a24 out nocopy DATE
1048 , p5_a0 NUMBER := 0-1962.0724
1049 , p5_a1 NUMBER := 0-1962.0724
1050 , p5_a2 NUMBER := 0-1962.0724
1051 , p5_a3 NUMBER := 0-1962.0724
1052 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1053 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1054 , p5_a6 DATE := fnd_api.g_miss_date
1055 , p5_a7 NUMBER := 0-1962.0724
1056 , p5_a8 NUMBER := 0-1962.0724
1057 , p5_a9 NUMBER := 0-1962.0724
1058 , p5_a10 DATE := fnd_api.g_miss_date
1059 , p5_a11 NUMBER := 0-1962.0724
1060 , p5_a12 DATE := fnd_api.g_miss_date
1061 , p5_a13 NUMBER := 0-1962.0724
1062 , p5_a14 DATE := fnd_api.g_miss_date
1063 , p5_a15 NUMBER := 0-1962.0724
1064 , p5_a16 DATE := fnd_api.g_miss_date
1065 , p5_a17 NUMBER := 0-1962.0724
1066 , p5_a18 NUMBER := 0-1962.0724
1067 , p5_a19 NUMBER := 0-1962.0724
1068 , p5_a20 NUMBER := 0-1962.0724
1069 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1070 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1071 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1072 , p5_a24 DATE := fnd_api.g_miss_date
1073 );
1074 procedure lock_stream_elements(p_api_version NUMBER
1075 , p_init_msg_list VARCHAR2
1076 , x_return_status out nocopy VARCHAR2
1077 , x_msg_count out nocopy NUMBER
1078 , x_msg_data out nocopy VARCHAR2
1079 , p5_a0 JTF_NUMBER_TABLE
1080 , p5_a1 JTF_NUMBER_TABLE
1081 , p5_a2 JTF_NUMBER_TABLE
1082 , p5_a3 JTF_NUMBER_TABLE
1083 , p5_a4 JTF_VARCHAR2_TABLE_2000
1084 , p5_a5 JTF_VARCHAR2_TABLE_100
1085 , p5_a6 JTF_DATE_TABLE
1086 , p5_a7 JTF_NUMBER_TABLE
1087 , p5_a8 JTF_NUMBER_TABLE
1088 , p5_a9 JTF_NUMBER_TABLE
1089 , p5_a10 JTF_DATE_TABLE
1090 , p5_a11 JTF_NUMBER_TABLE
1091 , p5_a12 JTF_DATE_TABLE
1092 , p5_a13 JTF_NUMBER_TABLE
1093 , p5_a14 JTF_DATE_TABLE
1094 , p5_a15 JTF_NUMBER_TABLE
1095 , p5_a16 JTF_DATE_TABLE
1096 , p5_a17 JTF_NUMBER_TABLE
1097 , p5_a18 JTF_NUMBER_TABLE
1098 , p5_a19 JTF_NUMBER_TABLE
1099 , p5_a20 JTF_NUMBER_TABLE
1100 , p5_a21 JTF_VARCHAR2_TABLE_100
1101 , p5_a22 JTF_VARCHAR2_TABLE_100
1102 , p5_a23 JTF_VARCHAR2_TABLE_100
1103 , p5_a24 JTF_DATE_TABLE
1104 );
1105 procedure lock_stream_elements(p_api_version NUMBER
1106 , p_init_msg_list VARCHAR2
1107 , x_return_status out nocopy VARCHAR2
1108 , x_msg_count out nocopy NUMBER
1109 , x_msg_data out nocopy VARCHAR2
1110 , p5_a0 NUMBER := 0-1962.0724
1111 , p5_a1 NUMBER := 0-1962.0724
1112 , p5_a2 NUMBER := 0-1962.0724
1113 , p5_a3 NUMBER := 0-1962.0724
1114 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1115 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1116 , p5_a6 DATE := fnd_api.g_miss_date
1117 , p5_a7 NUMBER := 0-1962.0724
1118 , p5_a8 NUMBER := 0-1962.0724
1119 , p5_a9 NUMBER := 0-1962.0724
1120 , p5_a10 DATE := fnd_api.g_miss_date
1121 , p5_a11 NUMBER := 0-1962.0724
1122 , p5_a12 DATE := fnd_api.g_miss_date
1123 , p5_a13 NUMBER := 0-1962.0724
1124 , p5_a14 DATE := fnd_api.g_miss_date
1125 , p5_a15 NUMBER := 0-1962.0724
1126 , p5_a16 DATE := fnd_api.g_miss_date
1127 , p5_a17 NUMBER := 0-1962.0724
1128 , p5_a18 NUMBER := 0-1962.0724
1129 , p5_a19 NUMBER := 0-1962.0724
1130 , p5_a20 NUMBER := 0-1962.0724
1131 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1132 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1133 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1134 , p5_a24 DATE := fnd_api.g_miss_date
1135 );
1136 procedure update_stream_elements(p_api_version NUMBER
1137 , p_init_msg_list VARCHAR2
1138 , x_return_status out nocopy VARCHAR2
1139 , x_msg_count out nocopy NUMBER
1140 , x_msg_data out nocopy VARCHAR2
1141 , p5_a0 JTF_NUMBER_TABLE
1142 , p5_a1 JTF_NUMBER_TABLE
1143 , p5_a2 JTF_NUMBER_TABLE
1144 , p5_a3 JTF_NUMBER_TABLE
1145 , p5_a4 JTF_VARCHAR2_TABLE_2000
1146 , p5_a5 JTF_VARCHAR2_TABLE_100
1147 , p5_a6 JTF_DATE_TABLE
1148 , p5_a7 JTF_NUMBER_TABLE
1149 , p5_a8 JTF_NUMBER_TABLE
1150 , p5_a9 JTF_NUMBER_TABLE
1151 , p5_a10 JTF_DATE_TABLE
1152 , p5_a11 JTF_NUMBER_TABLE
1153 , p5_a12 JTF_DATE_TABLE
1154 , p5_a13 JTF_NUMBER_TABLE
1155 , p5_a14 JTF_DATE_TABLE
1156 , p5_a15 JTF_NUMBER_TABLE
1157 , p5_a16 JTF_DATE_TABLE
1158 , p5_a17 JTF_NUMBER_TABLE
1159 , p5_a18 JTF_NUMBER_TABLE
1160 , p5_a19 JTF_NUMBER_TABLE
1161 , p5_a20 JTF_NUMBER_TABLE
1162 , p5_a21 JTF_VARCHAR2_TABLE_100
1163 , p5_a22 JTF_VARCHAR2_TABLE_100
1164 , p5_a23 JTF_VARCHAR2_TABLE_100
1165 , p5_a24 JTF_DATE_TABLE
1166 , p6_a0 out nocopy JTF_NUMBER_TABLE
1167 , p6_a1 out nocopy JTF_NUMBER_TABLE
1168 , p6_a2 out nocopy JTF_NUMBER_TABLE
1169 , p6_a3 out nocopy JTF_NUMBER_TABLE
1170 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1171 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1172 , p6_a6 out nocopy JTF_DATE_TABLE
1173 , p6_a7 out nocopy JTF_NUMBER_TABLE
1174 , p6_a8 out nocopy JTF_NUMBER_TABLE
1175 , p6_a9 out nocopy JTF_NUMBER_TABLE
1176 , p6_a10 out nocopy JTF_DATE_TABLE
1177 , p6_a11 out nocopy JTF_NUMBER_TABLE
1178 , p6_a12 out nocopy JTF_DATE_TABLE
1179 , p6_a13 out nocopy JTF_NUMBER_TABLE
1180 , p6_a14 out nocopy JTF_DATE_TABLE
1181 , p6_a15 out nocopy JTF_NUMBER_TABLE
1182 , p6_a16 out nocopy JTF_DATE_TABLE
1183 , p6_a17 out nocopy JTF_NUMBER_TABLE
1184 , p6_a18 out nocopy JTF_NUMBER_TABLE
1185 , p6_a19 out nocopy JTF_NUMBER_TABLE
1186 , p6_a20 out nocopy JTF_NUMBER_TABLE
1187 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1188 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
1189 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
1190 , p6_a24 out nocopy JTF_DATE_TABLE
1191 );
1192 procedure update_stream_elements(p_api_version NUMBER
1193 , p_init_msg_list VARCHAR2
1194 , x_return_status out nocopy VARCHAR2
1195 , x_msg_count out nocopy NUMBER
1196 , x_msg_data out nocopy VARCHAR2
1197 , p6_a0 out nocopy NUMBER
1198 , p6_a1 out nocopy NUMBER
1199 , p6_a2 out nocopy NUMBER
1200 , p6_a3 out nocopy NUMBER
1201 , p6_a4 out nocopy VARCHAR2
1202 , p6_a5 out nocopy VARCHAR2
1203 , p6_a6 out nocopy DATE
1204 , p6_a7 out nocopy NUMBER
1205 , p6_a8 out nocopy NUMBER
1206 , p6_a9 out nocopy NUMBER
1207 , p6_a10 out nocopy DATE
1208 , p6_a11 out nocopy NUMBER
1209 , p6_a12 out nocopy DATE
1210 , p6_a13 out nocopy NUMBER
1211 , p6_a14 out nocopy DATE
1212 , p6_a15 out nocopy NUMBER
1213 , p6_a16 out nocopy DATE
1214 , p6_a17 out nocopy NUMBER
1215 , p6_a18 out nocopy NUMBER
1216 , p6_a19 out nocopy NUMBER
1217 , p6_a20 out nocopy NUMBER
1218 , p6_a21 out nocopy VARCHAR2
1219 , p6_a22 out nocopy VARCHAR2
1220 , p6_a23 out nocopy VARCHAR2
1221 , p6_a24 out nocopy DATE
1222 , p5_a0 NUMBER := 0-1962.0724
1223 , p5_a1 NUMBER := 0-1962.0724
1224 , p5_a2 NUMBER := 0-1962.0724
1225 , p5_a3 NUMBER := 0-1962.0724
1226 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1227 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1228 , p5_a6 DATE := fnd_api.g_miss_date
1229 , p5_a7 NUMBER := 0-1962.0724
1230 , p5_a8 NUMBER := 0-1962.0724
1231 , p5_a9 NUMBER := 0-1962.0724
1232 , p5_a10 DATE := fnd_api.g_miss_date
1233 , p5_a11 NUMBER := 0-1962.0724
1234 , p5_a12 DATE := fnd_api.g_miss_date
1235 , p5_a13 NUMBER := 0-1962.0724
1236 , p5_a14 DATE := fnd_api.g_miss_date
1237 , p5_a15 NUMBER := 0-1962.0724
1238 , p5_a16 DATE := fnd_api.g_miss_date
1239 , p5_a17 NUMBER := 0-1962.0724
1240 , p5_a18 NUMBER := 0-1962.0724
1241 , p5_a19 NUMBER := 0-1962.0724
1242 , p5_a20 NUMBER := 0-1962.0724
1243 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1244 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1245 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1246 , p5_a24 DATE := fnd_api.g_miss_date
1247 );
1248 procedure delete_stream_elements(p_api_version NUMBER
1249 , p_init_msg_list VARCHAR2
1250 , x_return_status out nocopy VARCHAR2
1251 , x_msg_count out nocopy NUMBER
1252 , x_msg_data out nocopy VARCHAR2
1253 , p5_a0 JTF_NUMBER_TABLE
1254 , p5_a1 JTF_NUMBER_TABLE
1255 , p5_a2 JTF_NUMBER_TABLE
1256 , p5_a3 JTF_NUMBER_TABLE
1257 , p5_a4 JTF_VARCHAR2_TABLE_2000
1258 , p5_a5 JTF_VARCHAR2_TABLE_100
1259 , p5_a6 JTF_DATE_TABLE
1260 , p5_a7 JTF_NUMBER_TABLE
1261 , p5_a8 JTF_NUMBER_TABLE
1262 , p5_a9 JTF_NUMBER_TABLE
1263 , p5_a10 JTF_DATE_TABLE
1264 , p5_a11 JTF_NUMBER_TABLE
1265 , p5_a12 JTF_DATE_TABLE
1266 , p5_a13 JTF_NUMBER_TABLE
1267 , p5_a14 JTF_DATE_TABLE
1268 , p5_a15 JTF_NUMBER_TABLE
1269 , p5_a16 JTF_DATE_TABLE
1270 , p5_a17 JTF_NUMBER_TABLE
1271 , p5_a18 JTF_NUMBER_TABLE
1272 , p5_a19 JTF_NUMBER_TABLE
1273 , p5_a20 JTF_NUMBER_TABLE
1274 , p5_a21 JTF_VARCHAR2_TABLE_100
1275 , p5_a22 JTF_VARCHAR2_TABLE_100
1276 , p5_a23 JTF_VARCHAR2_TABLE_100
1277 , p5_a24 JTF_DATE_TABLE
1278 );
1279 procedure delete_stream_elements(p_api_version NUMBER
1280 , p_init_msg_list VARCHAR2
1281 , x_return_status out nocopy VARCHAR2
1282 , x_msg_count out nocopy NUMBER
1283 , x_msg_data out nocopy VARCHAR2
1284 , p5_a0 NUMBER := 0-1962.0724
1285 , p5_a1 NUMBER := 0-1962.0724
1286 , p5_a2 NUMBER := 0-1962.0724
1287 , p5_a3 NUMBER := 0-1962.0724
1288 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1289 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1290 , p5_a6 DATE := fnd_api.g_miss_date
1291 , p5_a7 NUMBER := 0-1962.0724
1292 , p5_a8 NUMBER := 0-1962.0724
1293 , p5_a9 NUMBER := 0-1962.0724
1294 , p5_a10 DATE := fnd_api.g_miss_date
1295 , p5_a11 NUMBER := 0-1962.0724
1296 , p5_a12 DATE := fnd_api.g_miss_date
1297 , p5_a13 NUMBER := 0-1962.0724
1298 , p5_a14 DATE := fnd_api.g_miss_date
1299 , p5_a15 NUMBER := 0-1962.0724
1300 , p5_a16 DATE := fnd_api.g_miss_date
1301 , p5_a17 NUMBER := 0-1962.0724
1302 , p5_a18 NUMBER := 0-1962.0724
1303 , p5_a19 NUMBER := 0-1962.0724
1304 , p5_a20 NUMBER := 0-1962.0724
1305 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1306 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1307 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1308 , p5_a24 DATE := fnd_api.g_miss_date
1309 );
1310 procedure validate_stream_elements(p_api_version NUMBER
1311 , p_init_msg_list VARCHAR2
1312 , x_return_status out nocopy VARCHAR2
1313 , x_msg_count out nocopy NUMBER
1314 , x_msg_data out nocopy VARCHAR2
1315 , p5_a0 JTF_NUMBER_TABLE
1316 , p5_a1 JTF_NUMBER_TABLE
1317 , p5_a2 JTF_NUMBER_TABLE
1318 , p5_a3 JTF_NUMBER_TABLE
1319 , p5_a4 JTF_VARCHAR2_TABLE_2000
1320 , p5_a5 JTF_VARCHAR2_TABLE_100
1321 , p5_a6 JTF_DATE_TABLE
1322 , p5_a7 JTF_NUMBER_TABLE
1323 , p5_a8 JTF_NUMBER_TABLE
1324 , p5_a9 JTF_NUMBER_TABLE
1325 , p5_a10 JTF_DATE_TABLE
1326 , p5_a11 JTF_NUMBER_TABLE
1327 , p5_a12 JTF_DATE_TABLE
1328 , p5_a13 JTF_NUMBER_TABLE
1329 , p5_a14 JTF_DATE_TABLE
1330 , p5_a15 JTF_NUMBER_TABLE
1331 , p5_a16 JTF_DATE_TABLE
1332 , p5_a17 JTF_NUMBER_TABLE
1333 , p5_a18 JTF_NUMBER_TABLE
1334 , p5_a19 JTF_NUMBER_TABLE
1335 , p5_a20 JTF_NUMBER_TABLE
1336 , p5_a21 JTF_VARCHAR2_TABLE_100
1337 , p5_a22 JTF_VARCHAR2_TABLE_100
1338 , p5_a23 JTF_VARCHAR2_TABLE_100
1339 , p5_a24 JTF_DATE_TABLE
1340 );
1341 procedure validate_stream_elements(p_api_version NUMBER
1342 , p_init_msg_list VARCHAR2
1343 , x_return_status out nocopy VARCHAR2
1344 , x_msg_count out nocopy NUMBER
1345 , x_msg_data out nocopy VARCHAR2
1346 , p5_a0 NUMBER := 0-1962.0724
1347 , p5_a1 NUMBER := 0-1962.0724
1348 , p5_a2 NUMBER := 0-1962.0724
1349 , p5_a3 NUMBER := 0-1962.0724
1350 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1351 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1352 , p5_a6 DATE := fnd_api.g_miss_date
1353 , p5_a7 NUMBER := 0-1962.0724
1354 , p5_a8 NUMBER := 0-1962.0724
1355 , p5_a9 NUMBER := 0-1962.0724
1356 , p5_a10 DATE := fnd_api.g_miss_date
1357 , p5_a11 NUMBER := 0-1962.0724
1358 , p5_a12 DATE := fnd_api.g_miss_date
1359 , p5_a13 NUMBER := 0-1962.0724
1360 , p5_a14 DATE := fnd_api.g_miss_date
1361 , p5_a15 NUMBER := 0-1962.0724
1362 , p5_a16 DATE := fnd_api.g_miss_date
1363 , p5_a17 NUMBER := 0-1962.0724
1364 , p5_a18 NUMBER := 0-1962.0724
1365 , p5_a19 NUMBER := 0-1962.0724
1366 , p5_a20 NUMBER := 0-1962.0724
1367 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1368 , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1369 , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1370 , p5_a24 DATE := fnd_api.g_miss_date
1371 );
1372 end okl_streams_pvt_w;