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