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