[Home] [Help]
PACKAGE: APPS.OKL_STRM_GEN_TEMPLATE_PUB_W
Source
1 package okl_strm_gen_template_pub_w as
2 /* $Header: OKLUTSGS.pls 120.9 2007/10/15 16:08:11 dpsingh ship $ */
3 procedure create_strm_gen_template(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 , p7_a0 JTF_NUMBER_TABLE
9 , p7_a1 JTF_NUMBER_TABLE
10 , p7_a2 JTF_VARCHAR2_TABLE_200
11 , p7_a3 JTF_VARCHAR2_TABLE_2000
12 , p7_a4 JTF_VARCHAR2_TABLE_100
13 , p7_a5 JTF_VARCHAR2_TABLE_100
14 , p7_a6 JTF_VARCHAR2_TABLE_500
15 , p7_a7 JTF_VARCHAR2_TABLE_500
16 , p7_a8 JTF_NUMBER_TABLE
17 , p7_a9 JTF_NUMBER_TABLE
18 , p7_a10 JTF_DATE_TABLE
19 , p7_a11 JTF_NUMBER_TABLE
20 , p7_a12 JTF_DATE_TABLE
21 , p7_a13 JTF_NUMBER_TABLE
22 , p7_a14 JTF_NUMBER_TABLE
23 , p8_a0 JTF_NUMBER_TABLE
24 , p8_a1 JTF_NUMBER_TABLE
25 , p8_a2 JTF_NUMBER_TABLE
26 , p8_a3 JTF_VARCHAR2_TABLE_100
27 , p8_a4 JTF_NUMBER_TABLE
28 , p8_a5 JTF_NUMBER_TABLE
29 , p8_a6 JTF_VARCHAR2_TABLE_200
30 , p8_a7 JTF_NUMBER_TABLE
31 , p8_a8 JTF_NUMBER_TABLE
32 , p8_a9 JTF_DATE_TABLE
33 , p8_a10 JTF_NUMBER_TABLE
34 , p8_a11 JTF_DATE_TABLE
35 , p8_a12 JTF_NUMBER_TABLE
36 , p9_a0 out nocopy NUMBER
37 , p9_a1 out nocopy NUMBER
38 , p9_a2 out nocopy NUMBER
39 , p9_a3 out nocopy VARCHAR2
40 , p9_a4 out nocopy DATE
41 , p9_a5 out nocopy DATE
42 , p9_a6 out nocopy VARCHAR2
43 , p9_a7 out nocopy VARCHAR2
44 , p9_a8 out nocopy VARCHAR2
45 , p9_a9 out nocopy VARCHAR2
46 , p9_a10 out nocopy VARCHAR2
47 , p9_a11 out nocopy VARCHAR2
48 , p9_a12 out nocopy VARCHAR2
49 , p9_a13 out nocopy VARCHAR2
50 , p9_a14 out nocopy VARCHAR2
51 , p9_a15 out nocopy VARCHAR2
52 , p9_a16 out nocopy VARCHAR2
53 , p9_a17 out nocopy VARCHAR2
54 , p9_a18 out nocopy VARCHAR2
55 , p9_a19 out nocopy VARCHAR2
56 , p9_a20 out nocopy VARCHAR2
57 , p9_a21 out nocopy VARCHAR2
58 , p9_a22 out nocopy VARCHAR2
59 , p9_a23 out nocopy NUMBER
60 , p9_a24 out nocopy NUMBER
61 , p9_a25 out nocopy DATE
62 , p9_a26 out nocopy NUMBER
63 , p9_a27 out nocopy DATE
64 , p9_a28 out nocopy NUMBER
65 , p5_a0 NUMBER := 0-1962.0724
66 , p5_a1 NUMBER := 0-1962.0724
67 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
68 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
69 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
70 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
71 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
72 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
73 , p5_a8 NUMBER := 0-1962.0724
74 , p5_a9 NUMBER := 0-1962.0724
75 , p5_a10 DATE := fnd_api.g_miss_date
76 , p5_a11 NUMBER := 0-1962.0724
77 , p5_a12 DATE := fnd_api.g_miss_date
78 , p5_a13 NUMBER := 0-1962.0724
79 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
80 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
81 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
82 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
83 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
84 , p6_a0 NUMBER := 0-1962.0724
85 , p6_a1 NUMBER := 0-1962.0724
86 , p6_a2 NUMBER := 0-1962.0724
87 , p6_a3 VARCHAR2 := fnd_api.g_miss_char
88 , p6_a4 DATE := fnd_api.g_miss_date
89 , p6_a5 DATE := fnd_api.g_miss_date
90 , p6_a6 VARCHAR2 := fnd_api.g_miss_char
91 , p6_a7 VARCHAR2 := fnd_api.g_miss_char
92 , p6_a8 VARCHAR2 := fnd_api.g_miss_char
93 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
94 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
95 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
96 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
97 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
98 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
99 , p6_a15 VARCHAR2 := fnd_api.g_miss_char
100 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
101 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
102 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
103 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
104 , p6_a20 VARCHAR2 := fnd_api.g_miss_char
105 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
106 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
107 , p6_a23 NUMBER := 0-1962.0724
108 , p6_a24 NUMBER := 0-1962.0724
109 , p6_a25 DATE := fnd_api.g_miss_date
110 , p6_a26 NUMBER := 0-1962.0724
111 , p6_a27 DATE := fnd_api.g_miss_date
112 , p6_a28 NUMBER := 0-1962.0724
113 );
114 procedure update_strm_gen_template(p_api_version NUMBER
115 , p_init_msg_list VARCHAR2
116 , x_return_status out nocopy VARCHAR2
117 , x_msg_count out nocopy NUMBER
118 , x_msg_data out nocopy VARCHAR2
119 , p7_a0 JTF_NUMBER_TABLE
120 , p7_a1 JTF_NUMBER_TABLE
121 , p7_a2 JTF_VARCHAR2_TABLE_200
122 , p7_a3 JTF_VARCHAR2_TABLE_2000
123 , p7_a4 JTF_VARCHAR2_TABLE_100
124 , p7_a5 JTF_VARCHAR2_TABLE_100
125 , p7_a6 JTF_VARCHAR2_TABLE_500
126 , p7_a7 JTF_VARCHAR2_TABLE_500
127 , p7_a8 JTF_NUMBER_TABLE
128 , p7_a9 JTF_NUMBER_TABLE
129 , p7_a10 JTF_DATE_TABLE
130 , p7_a11 JTF_NUMBER_TABLE
131 , p7_a12 JTF_DATE_TABLE
132 , p7_a13 JTF_NUMBER_TABLE
133 , p7_a14 JTF_NUMBER_TABLE
134 , p8_a0 JTF_NUMBER_TABLE
135 , p8_a1 JTF_NUMBER_TABLE
136 , p8_a2 JTF_NUMBER_TABLE
137 , p8_a3 JTF_VARCHAR2_TABLE_100
138 , p8_a4 JTF_NUMBER_TABLE
139 , p8_a5 JTF_NUMBER_TABLE
140 , p8_a6 JTF_VARCHAR2_TABLE_200
141 , p8_a7 JTF_NUMBER_TABLE
142 , p8_a8 JTF_NUMBER_TABLE
143 , p8_a9 JTF_DATE_TABLE
144 , p8_a10 JTF_NUMBER_TABLE
145 , p8_a11 JTF_DATE_TABLE
146 , p8_a12 JTF_NUMBER_TABLE
147 , p9_a0 out nocopy NUMBER
148 , p9_a1 out nocopy NUMBER
149 , p9_a2 out nocopy NUMBER
150 , p9_a3 out nocopy VARCHAR2
151 , p9_a4 out nocopy DATE
152 , p9_a5 out nocopy DATE
153 , p9_a6 out nocopy VARCHAR2
154 , p9_a7 out nocopy VARCHAR2
155 , p9_a8 out nocopy VARCHAR2
156 , p9_a9 out nocopy VARCHAR2
157 , p9_a10 out nocopy VARCHAR2
158 , p9_a11 out nocopy VARCHAR2
159 , p9_a12 out nocopy VARCHAR2
160 , p9_a13 out nocopy VARCHAR2
161 , p9_a14 out nocopy VARCHAR2
162 , p9_a15 out nocopy VARCHAR2
163 , p9_a16 out nocopy VARCHAR2
164 , p9_a17 out nocopy VARCHAR2
165 , p9_a18 out nocopy VARCHAR2
166 , p9_a19 out nocopy VARCHAR2
167 , p9_a20 out nocopy VARCHAR2
168 , p9_a21 out nocopy VARCHAR2
169 , p9_a22 out nocopy VARCHAR2
170 , p9_a23 out nocopy NUMBER
171 , p9_a24 out nocopy NUMBER
172 , p9_a25 out nocopy DATE
173 , p9_a26 out nocopy NUMBER
174 , p9_a27 out nocopy DATE
175 , p9_a28 out nocopy NUMBER
176 , p5_a0 NUMBER := 0-1962.0724
177 , p5_a1 NUMBER := 0-1962.0724
178 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
179 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
180 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
181 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
182 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
183 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
184 , p5_a8 NUMBER := 0-1962.0724
185 , p5_a9 NUMBER := 0-1962.0724
186 , p5_a10 DATE := fnd_api.g_miss_date
187 , p5_a11 NUMBER := 0-1962.0724
188 , p5_a12 DATE := fnd_api.g_miss_date
189 , p5_a13 NUMBER := 0-1962.0724
190 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
191 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
192 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
193 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
194 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
195 , p6_a0 NUMBER := 0-1962.0724
196 , p6_a1 NUMBER := 0-1962.0724
197 , p6_a2 NUMBER := 0-1962.0724
198 , p6_a3 VARCHAR2 := fnd_api.g_miss_char
199 , p6_a4 DATE := fnd_api.g_miss_date
200 , p6_a5 DATE := fnd_api.g_miss_date
201 , p6_a6 VARCHAR2 := fnd_api.g_miss_char
202 , p6_a7 VARCHAR2 := fnd_api.g_miss_char
203 , p6_a8 VARCHAR2 := fnd_api.g_miss_char
204 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
205 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
206 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
207 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
208 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
209 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
210 , p6_a15 VARCHAR2 := fnd_api.g_miss_char
211 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
212 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
213 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
214 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
215 , p6_a20 VARCHAR2 := fnd_api.g_miss_char
216 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
217 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
218 , p6_a23 NUMBER := 0-1962.0724
219 , p6_a24 NUMBER := 0-1962.0724
220 , p6_a25 DATE := fnd_api.g_miss_date
221 , p6_a26 NUMBER := 0-1962.0724
222 , p6_a27 DATE := fnd_api.g_miss_date
223 , p6_a28 NUMBER := 0-1962.0724
224 );
225 procedure delete_tmpt_prc_params(p_api_version NUMBER
226 , p_init_msg_list VARCHAR2
227 , x_return_status out nocopy VARCHAR2
228 , x_msg_count out nocopy NUMBER
229 , x_msg_data out nocopy VARCHAR2
230 , p5_a0 JTF_NUMBER_TABLE
231 , p5_a1 JTF_NUMBER_TABLE
232 , p5_a2 JTF_VARCHAR2_TABLE_200
233 , p5_a3 JTF_VARCHAR2_TABLE_2000
234 , p5_a4 JTF_VARCHAR2_TABLE_100
235 , p5_a5 JTF_VARCHAR2_TABLE_100
236 , p5_a6 JTF_VARCHAR2_TABLE_500
237 , p5_a7 JTF_VARCHAR2_TABLE_500
238 , p5_a8 JTF_NUMBER_TABLE
239 , p5_a9 JTF_NUMBER_TABLE
240 , p5_a10 JTF_DATE_TABLE
241 , p5_a11 JTF_NUMBER_TABLE
242 , p5_a12 JTF_DATE_TABLE
243 , p5_a13 JTF_NUMBER_TABLE
244 , p5_a14 JTF_NUMBER_TABLE
245 );
246 procedure delete_pri_tmpt_lns(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_NUMBER_TABLE
253 , p5_a2 JTF_NUMBER_TABLE
254 , p5_a3 JTF_VARCHAR2_TABLE_100
255 , p5_a4 JTF_NUMBER_TABLE
256 , p5_a5 JTF_NUMBER_TABLE
257 , p5_a6 JTF_VARCHAR2_TABLE_200
258 , p5_a7 JTF_NUMBER_TABLE
259 , p5_a8 JTF_NUMBER_TABLE
260 , p5_a9 JTF_DATE_TABLE
261 , p5_a10 JTF_NUMBER_TABLE
262 , p5_a11 JTF_DATE_TABLE
263 , p5_a12 JTF_NUMBER_TABLE
264 );
265 procedure delete_dep_tmpt_lns(p_api_version NUMBER
266 , p_init_msg_list VARCHAR2
267 , x_return_status out nocopy VARCHAR2
268 , x_msg_count out nocopy NUMBER
269 , x_msg_data out nocopy VARCHAR2
270 , p5_a0 JTF_NUMBER_TABLE
271 , p5_a1 JTF_NUMBER_TABLE
272 , p5_a2 JTF_NUMBER_TABLE
273 , p5_a3 JTF_VARCHAR2_TABLE_100
274 , p5_a4 JTF_NUMBER_TABLE
275 , p5_a5 JTF_NUMBER_TABLE
276 , p5_a6 JTF_VARCHAR2_TABLE_200
277 , p5_a7 JTF_NUMBER_TABLE
278 , p5_a8 JTF_NUMBER_TABLE
279 , p5_a9 JTF_DATE_TABLE
280 , p5_a10 JTF_NUMBER_TABLE
281 , p5_a11 JTF_DATE_TABLE
282 , p5_a12 JTF_NUMBER_TABLE
283 );
284 procedure update_dep_strms(p_api_version NUMBER
285 , p_init_msg_list VARCHAR2
286 , x_return_status out nocopy VARCHAR2
287 , x_msg_count out nocopy NUMBER
288 , x_msg_data out nocopy VARCHAR2
289 , p_gtt_id NUMBER
290 , p_pri_sty_id NUMBER
291 , p7_a0 JTF_NUMBER_TABLE
292 , p7_a1 JTF_NUMBER_TABLE
293 , p7_a2 JTF_NUMBER_TABLE
294 , p7_a3 JTF_VARCHAR2_TABLE_100
295 , p7_a4 JTF_NUMBER_TABLE
296 , p7_a5 JTF_NUMBER_TABLE
297 , p7_a6 JTF_VARCHAR2_TABLE_200
298 , p7_a7 JTF_NUMBER_TABLE
299 , p7_a8 JTF_NUMBER_TABLE
300 , p7_a9 JTF_DATE_TABLE
301 , p7_a10 JTF_NUMBER_TABLE
302 , p7_a11 JTF_DATE_TABLE
303 , p7_a12 JTF_NUMBER_TABLE
304 , x_missing_deps out nocopy VARCHAR2
305 , x_show_warn_flag out nocopy VARCHAR2
306 );
307 procedure create_version_duplicate(p_api_version NUMBER
308 , p_init_msg_list VARCHAR2
309 , x_return_status out nocopy VARCHAR2
310 , x_msg_count out nocopy NUMBER
311 , x_msg_data out nocopy VARCHAR2
312 , p_gtt_id NUMBER
313 , p_mode VARCHAR2
314 , p7_a0 out nocopy NUMBER
315 , p7_a1 out nocopy NUMBER
316 , p7_a2 out nocopy NUMBER
317 , p7_a3 out nocopy VARCHAR2
318 , p7_a4 out nocopy DATE
319 , p7_a5 out nocopy DATE
320 , p7_a6 out nocopy VARCHAR2
321 , p7_a7 out nocopy VARCHAR2
322 , p7_a8 out nocopy VARCHAR2
323 , p7_a9 out nocopy VARCHAR2
324 , p7_a10 out nocopy VARCHAR2
325 , p7_a11 out nocopy VARCHAR2
326 , p7_a12 out nocopy VARCHAR2
327 , p7_a13 out nocopy VARCHAR2
328 , p7_a14 out nocopy VARCHAR2
329 , p7_a15 out nocopy VARCHAR2
330 , p7_a16 out nocopy VARCHAR2
331 , p7_a17 out nocopy VARCHAR2
332 , p7_a18 out nocopy VARCHAR2
333 , p7_a19 out nocopy VARCHAR2
334 , p7_a20 out nocopy VARCHAR2
335 , p7_a21 out nocopy VARCHAR2
336 , p7_a22 out nocopy VARCHAR2
337 , p7_a23 out nocopy NUMBER
338 , p7_a24 out nocopy NUMBER
339 , p7_a25 out nocopy DATE
340 , p7_a26 out nocopy NUMBER
341 , p7_a27 out nocopy DATE
342 , p7_a28 out nocopy NUMBER
343 );
344 procedure validate_template(p_api_version NUMBER
345 , p_init_msg_list VARCHAR2
346 , x_return_status out nocopy VARCHAR2
347 , x_msg_count out nocopy NUMBER
348 , x_msg_data out nocopy VARCHAR2
349 , p_gtt_id NUMBER
350 , p6_a0 out nocopy JTF_VARCHAR2_TABLE_2500
351 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
352 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
353 , x_return_tmpt_status out nocopy VARCHAR2
354 , p_during_upd_flag VARCHAR2
355 );
356 procedure validate_for_warnings(p_api_version NUMBER
357 , p_init_msg_list VARCHAR2
358 , x_return_status out nocopy VARCHAR2
359 , x_msg_count out nocopy NUMBER
360 , x_msg_data out nocopy VARCHAR2
361 , p_gtt_id NUMBER
362 , p6_a0 out nocopy JTF_VARCHAR2_TABLE_2500
363 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
364 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
365 , p_during_upd_flag VARCHAR
366 , x_pri_purpose_list out nocopy VARCHAR
367 );
368 procedure update_pri_dep_of_sgt(p_api_version NUMBER
369 , p_init_msg_list VARCHAR2
370 , x_return_status out nocopy VARCHAR2
371 , x_msg_count out nocopy NUMBER
372 , x_msg_data out nocopy VARCHAR2
373 , p7_a0 JTF_NUMBER_TABLE
374 , p7_a1 JTF_NUMBER_TABLE
375 , p7_a2 JTF_VARCHAR2_TABLE_200
376 , p7_a3 JTF_VARCHAR2_TABLE_2000
377 , p7_a4 JTF_VARCHAR2_TABLE_100
378 , p7_a5 JTF_VARCHAR2_TABLE_100
379 , p7_a6 JTF_VARCHAR2_TABLE_500
380 , p7_a7 JTF_VARCHAR2_TABLE_500
381 , p7_a8 JTF_NUMBER_TABLE
382 , p7_a9 JTF_NUMBER_TABLE
383 , p7_a10 JTF_DATE_TABLE
384 , p7_a11 JTF_NUMBER_TABLE
385 , p7_a12 JTF_DATE_TABLE
386 , p7_a13 JTF_NUMBER_TABLE
387 , p7_a14 JTF_NUMBER_TABLE
388 , p8_a0 JTF_NUMBER_TABLE
389 , p8_a1 JTF_NUMBER_TABLE
390 , p8_a2 JTF_NUMBER_TABLE
391 , p8_a3 JTF_VARCHAR2_TABLE_100
392 , p8_a4 JTF_NUMBER_TABLE
393 , p8_a5 JTF_NUMBER_TABLE
394 , p8_a6 JTF_VARCHAR2_TABLE_200
395 , p8_a7 JTF_NUMBER_TABLE
396 , p8_a8 JTF_NUMBER_TABLE
397 , p8_a9 JTF_DATE_TABLE
398 , p8_a10 JTF_NUMBER_TABLE
399 , p8_a11 JTF_DATE_TABLE
400 , p8_a12 JTF_NUMBER_TABLE
401 , p9_a0 JTF_NUMBER_TABLE
402 , p9_a1 JTF_NUMBER_TABLE
403 , p9_a2 JTF_NUMBER_TABLE
404 , p9_a3 JTF_VARCHAR2_TABLE_100
405 , p9_a4 JTF_NUMBER_TABLE
406 , p9_a5 JTF_NUMBER_TABLE
407 , p9_a6 JTF_VARCHAR2_TABLE_200
408 , p9_a7 JTF_NUMBER_TABLE
409 , p9_a8 JTF_NUMBER_TABLE
410 , p9_a9 JTF_DATE_TABLE
411 , p9_a10 JTF_NUMBER_TABLE
412 , p9_a11 JTF_DATE_TABLE
413 , p9_a12 JTF_NUMBER_TABLE
414 , p10_a0 JTF_NUMBER_TABLE
415 , p10_a1 JTF_NUMBER_TABLE
416 , p10_a2 JTF_NUMBER_TABLE
417 , p10_a3 JTF_VARCHAR2_TABLE_100
418 , p10_a4 JTF_NUMBER_TABLE
419 , p10_a5 JTF_NUMBER_TABLE
420 , p10_a6 JTF_VARCHAR2_TABLE_200
421 , p10_a7 JTF_NUMBER_TABLE
422 , p10_a8 JTF_NUMBER_TABLE
423 , p10_a9 JTF_DATE_TABLE
424 , p10_a10 JTF_NUMBER_TABLE
425 , p10_a11 JTF_DATE_TABLE
426 , p10_a12 JTF_NUMBER_TABLE
427 , p11_a0 out nocopy NUMBER
428 , p11_a1 out nocopy NUMBER
429 , p11_a2 out nocopy NUMBER
430 , p11_a3 out nocopy VARCHAR2
431 , p11_a4 out nocopy DATE
432 , p11_a5 out nocopy DATE
433 , p11_a6 out nocopy VARCHAR2
434 , p11_a7 out nocopy VARCHAR2
435 , p11_a8 out nocopy VARCHAR2
436 , p11_a9 out nocopy VARCHAR2
437 , p11_a10 out nocopy VARCHAR2
438 , p11_a11 out nocopy VARCHAR2
439 , p11_a12 out nocopy VARCHAR2
440 , p11_a13 out nocopy VARCHAR2
441 , p11_a14 out nocopy VARCHAR2
442 , p11_a15 out nocopy VARCHAR2
443 , p11_a16 out nocopy VARCHAR2
444 , p11_a17 out nocopy VARCHAR2
445 , p11_a18 out nocopy VARCHAR2
446 , p11_a19 out nocopy VARCHAR2
447 , p11_a20 out nocopy VARCHAR2
448 , p11_a21 out nocopy VARCHAR2
449 , p11_a22 out nocopy VARCHAR2
450 , p11_a23 out nocopy NUMBER
451 , p11_a24 out nocopy NUMBER
452 , p11_a25 out nocopy DATE
453 , p11_a26 out nocopy NUMBER
454 , p11_a27 out nocopy DATE
455 , p11_a28 out nocopy NUMBER
456 , x_pri_purpose_list out nocopy VARCHAR2
457 , p5_a0 NUMBER := 0-1962.0724
458 , p5_a1 NUMBER := 0-1962.0724
459 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
460 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
461 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
462 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
463 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
464 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
465 , p5_a8 NUMBER := 0-1962.0724
466 , p5_a9 NUMBER := 0-1962.0724
467 , p5_a10 DATE := fnd_api.g_miss_date
468 , p5_a11 NUMBER := 0-1962.0724
469 , p5_a12 DATE := fnd_api.g_miss_date
470 , p5_a13 NUMBER := 0-1962.0724
471 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
472 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
473 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
474 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
475 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
476 , p6_a0 NUMBER := 0-1962.0724
477 , p6_a1 NUMBER := 0-1962.0724
478 , p6_a2 NUMBER := 0-1962.0724
479 , p6_a3 VARCHAR2 := fnd_api.g_miss_char
480 , p6_a4 DATE := fnd_api.g_miss_date
481 , p6_a5 DATE := fnd_api.g_miss_date
482 , p6_a6 VARCHAR2 := fnd_api.g_miss_char
483 , p6_a7 VARCHAR2 := fnd_api.g_miss_char
484 , p6_a8 VARCHAR2 := fnd_api.g_miss_char
485 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
486 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
487 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
488 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
489 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
490 , p6_a14 VARCHAR2 := fnd_api.g_miss_char
491 , p6_a15 VARCHAR2 := fnd_api.g_miss_char
492 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
493 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
494 , p6_a18 VARCHAR2 := fnd_api.g_miss_char
495 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
496 , p6_a20 VARCHAR2 := fnd_api.g_miss_char
497 , p6_a21 VARCHAR2 := fnd_api.g_miss_char
498 , p6_a22 VARCHAR2 := fnd_api.g_miss_char
499 , p6_a23 NUMBER := 0-1962.0724
500 , p6_a24 NUMBER := 0-1962.0724
501 , p6_a25 DATE := fnd_api.g_miss_date
502 , p6_a26 NUMBER := 0-1962.0724
503 , p6_a27 DATE := fnd_api.g_miss_date
504 , p6_a28 NUMBER := 0-1962.0724
505 );
506 end okl_strm_gen_template_pub_w;