[Home] [Help]
PACKAGE: APPS.QA_QLTRSLTR_XMLP_PKG
Source
1 PACKAGE QA_QLTRSLTR_XMLP_PKG AS
2 /* $Header: QLTRSLTRS.pls 120.0 2007/12/24 10:38:53 krreddy noship $ */
3 P_QTY_PRECISION NUMBER;
4
5 P_DEFAULT_SEL VARCHAR2(6000) := 'Select CHARACTER1 col_1,PLAN_ID num_1,
6 CHARACTER2 col_2,PLAN_ID num_2,CHARACTER3 col_3,PLAN_ID num_3,CHARACTER4 col_4,PLAN_ID num_4,CHARACTER5 col_5,PLAN_ID num_5,CHARACTER6 col_6,
7 PLAN_ID num_6,CHARACTER7 col_7,PLAN_ID num_7,CHARACTER8 col_8,PLAN_ID num_8, CHARACTER9 col_9, PLAN_ID num_9, CHARACTER10 col_10, PLAN_ID num_10,
8 CHARACTER11 col_11, PLAN_ID num_11,CHARACTER12 col_12,PLAN_ID num_12,CHARACTER13 col_13,PLAN_ID num_13,CHARACTER14 col_14,PLAN_ID num_14,
9 CHARACTER15 col_15,PLAN_ID num_15,CHARACTER16 col_16,PLAN_ID num_16, CHARACTER17 col_17, PLAN_ID num_17, CHARACTER18 col_18, PLAN_ID num_18,
10 CHARACTER19 col_19, PLAN_ID num_19, CHARACTER20 col_20, PLAN_ID num_20, CHARACTER21 col_21, PLAN_ID num_21,CHARACTER22 col_22, PLAN_ID num_22,
11 CHARACTER23 col_23, PLAN_ID num_23,CHARACTER24 col_24, PLAN_ID num_24,CHARACTER25 col_25, PLAN_ID num_25,CHARACTER26 col_26,PLAN_ID num_26,
12 CHARACTER27 col_27,PLAN_ID num_27,CHARACTER28 col_28,PLAN_ID num_28,CHARACTER29 col_29, PLAN_ID num_29,CHARACTER30 col_30, PLAN_ID num_30';
13
14 P_1 VARCHAR2(200):='plan_id';
15
16 P_2 VARCHAR2(200):='group_id';
17
18 P_3 VARCHAR2(200):='Quantity';
19
20 P_4 VARCHAR2(200);
21
22 P_5 VARCHAR2(200);
23
24 P_6 VARCHAR2(200);
25
26 P_7 VARCHAR2(200);
27
28 P_8 VARCHAR2(200);
29
30 P_9 VARCHAR2(200);
31
32 P_10 VARCHAR2(200);
33
34 P_11 VARCHAR2(200);
35
36 P_12 VARCHAR2(200);
37
38 P_13 VARCHAR2(200);
39
40 P_14 VARCHAR2(200);
41
42 P_15 VARCHAR2(200);
43
44 P_16 VARCHAR2(200);
45
46 P_17 NUMBER;
47
48 P_18 VARCHAR2(200);
49
50 P_19 VARCHAR2(200);
51
52 P_20 VARCHAR2(200);
53
54 P_21 VARCHAR2(200);
55
56 P_22 VARCHAR2(200);
57
58 P_23 VARCHAR2(200);
59
60 P_24 VARCHAR2(200);
61
62 P_25 VARCHAR2(200);
63
64 P_26 VARCHAR2(200);
65
66 P_27 VARCHAR2(200);
67
68 P_28 VARCHAR2(200);
69
70 P_29 VARCHAR2(200);
71
72 P_30 VARCHAR2(200);
73
74 P_ORGANIZATION_ID NUMBER:=7;
75
76 P_CRITERIA_ID NUMBER;
77
78 P_DEFAULT_PROMPTS VARCHAR2(1500) := 'select ''Plan_nchjgfchnid'', ''Quantity'', ''Quality_Code'', null, null, null, null, null, null, null, null,
79 null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null into :P_1, :P_2, :P_3, :P_4, :P_5,
80 :P_6, :P_7, :P_8, :P_9,:P_10, :P_11, :P_12, :P_13, :P_14, :P_15, :P_16, :P_17, :P_18, :P_19, :P_20, :P_21, :P_22, :P_23, :P_24, :P_25, :P_26, :P_27,
81 :P_28, :P_29, :P_30 from dual';
82
83 P_DEFAULT_WHERE VARCHAR2(6000) := 'from qa_results';
84
85 P_CRITERIA_SET_ID NUMBER;
86
87 P_PLAN_ID NUMBER;
88
89 P_PROMPTS_1 VARCHAR2(500):='SELECT ''Quantity'', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,
90 null, null, null, null, null, null, null, null, null, null,';
91
92 P_PROMPTS_2 VARCHAR2(500):='null, null into :P_1, :P_2, :P_3, :P_4, :P_5, :P_6, :P_7, :P_8, :P_9,:P_10, :P_11, :P_12, :P_13, :P_14, :P_15, :P_16,
93 :P_17, :P_18, :P_19, :P_20, :P_21, :P_22, :P_23, :P_24, :P_25, :P_26, :P_27, :P_28, :P_29, :P_30 from dual';
94
95 P_PROMPTS_3 VARCHAR2(240);
96
97 P_PROMPTS_4 VARCHAR2(240);
98
99 P_PROMPTS_5 VARCHAR2(240);
100
101 P_PROMPTS_6 VARCHAR2(240);
102
103 P_SELECT_1 VARCHAR2(240):='SELECT to_char(QUANTITY) col_1, CHARACTER2 col_2, CHARACTER3 col_3, CHARACTER4 col_4, CHARACTER5 col_5, CHARACTER6 col_6,
104 CHARACTER7 col_7, CHARACTER8 col_8, CHARACTER9 col_9, CHARACTER10 col_10, CHARACTER11 col_11, CHARACTER12 col_12,';
105
106 P_SELECT_2 VARCHAR2(240):='CHARACTER13 col_13, CHARACTER14 col_14, CHARACTER15 col_15,CHARACTER16 col_16, CHARACTER17 col_17, CHARACTER18 col_18,
107 CHARACTER19 col_19,CHARACTER20 col_20, CHARACTER21 col_21, CHARACTER22 col_22,';
108
109 P_SELECT_16 VARCHAR2(240);
110
111 P_SELECT_22 VARCHAR2(240);
112
113 P_SELECT_21 VARCHAR2(240);
114
115 P_SELECT_24 VARCHAR2(240);
116
117 P_SELECT_23 VARCHAR2(240);
118
119 P_SELECT_25 VARCHAR2(240);
120
121 P_SELECT_17 VARCHAR2(240);
122
123 P_SELECT_19 VARCHAR2(240);
124
125 P_SELECT_18 VARCHAR2(240);
126
127 P_SELECT_20 VARCHAR2(240);
128
129 P_SELECT_15 VARCHAR2(240);
130
131 P_SELECT_14 VARCHAR2(240);
132
133 P_SELECT_13 VARCHAR2(240);
134
135 P_SELECT_12 VARCHAR2(240);
136
137 P_SELECT_11 VARCHAR2(240);
138
139 P_SELECT_10 VARCHAR2(240);
140
141 P_SELECT_9 VARCHAR2(240);
142
143 P_SELECT_8 VARCHAR2(240);
144
145 P_SELECT_7 VARCHAR2(240);
146
147 P_SELECT_6 VARCHAR2(240);
148
149 P_SELECT_5 VARCHAR2(240);
150
151 P_SELECT_4 VARCHAR2(240);
152
153 P_SELECT_3 VARCHAR2(240):='CHARACTER23 col_23,CHARACTER24 col_24, CHARACTER25 col_25, CHARACTER26 col_26, CHARACTER27 col_27,CHARACTER28 col_28,
154 CHARACTER29 col_29, CHARACTER30 col_30';
155
156 P_WHERE_23 VARCHAR2(240);
157
158 P_WHERE_22 VARCHAR2(240);
159
160 P_WHERE_21 VARCHAR2(240);
161
162 P_WHERE_20 VARCHAR2(240);
163
164 P_WHERE_19 VARCHAR2(240);
165
166 P_WHERE_18 VARCHAR2(240);
167
168 P_WHERE_17 VARCHAR2(240);
169
170 P_WHERE_16 VARCHAR2(240);
171
172 P_WHERE_15 VARCHAR2(240);
173
174 P_WHERE_14 VARCHAR2(240);
175
176 P_WHERE_13 VARCHAR2(240);
177
178 P_WHERE_12 VARCHAR2(240);
179
180 P_WHERE_11 VARCHAR2(240);
181
182 P_WHERE_10 VARCHAR2(240);
183
184 P_WHERE_9 VARCHAR2(240);
185
186 P_WHERE_8 VARCHAR2(240);
187
188 P_WHERE_7 VARCHAR2(240);
189
190 P_WHERE_6 VARCHAR2(240);
191
192 P_WHERE_5 VARCHAR2(240);
193
194 P_WHERE_4 VARCHAR2(240);
195
196 P_WHERE_3 VARCHAR2(240);
197
198 P_WHERE_2 VARCHAR2(240);
199
200 P_WHERE_1 VARCHAR2(240):='from qa_results';
201
202 P_WHERE_24 VARCHAR2(240);
203
204 P_WHERE_25 VARCHAR2(240);
205
206 P_SUM_1 NUMBER;
207
208 P_LENGTH_1 VARCHAR2(240);
209
210 P_LENGTH_2 VARCHAR2(240);
211
212 P_DEFAULT_DASHES VARCHAR2(20000);
213
214 P_LENGTH_5 VARCHAR2(240);
215
216 P_LENGTH_3 VARCHAR2(240);
217
218 P_LENGTH_4 VARCHAR2(240);
219
220 P_LENGTH_6 VARCHAR2(240);
221
222 P_SUM_30 NUMBER;
223
224 P_SUM_29 NUMBER;
225
226 P_SUM_28 NUMBER;
227
228 P_SUM_27 NUMBER;
229
230 P_SUM_26 NUMBER;
231
232 P_SUM_25 NUMBER;
233
234 P_SUM_24 NUMBER;
235
236 P_SUM_23 NUMBER;
237
238 P_SUM_22 NUMBER;
239
240 P_SUM_21 NUMBER;
241
242 P_SUM_20 NUMBER;
243
244 P_SUM_19 NUMBER;
245
246 P_SUM_18 NUMBER;
247
248 P_SUM_17 NUMBER;
249
250 P_SUM_16 NUMBER;
251
252 P_SUM_15 NUMBER;
253
254 P_SUM_14 NUMBER;
255
256 P_SUM_13 NUMBER;
257
258 P_SUM_12 NUMBER;
259
260 P_SUM_11 NUMBER;
261
262 P_SUM_10 NUMBER;
263
264 P_SUM_9 NUMBER;
265
266 P_SUM_8 NUMBER;
267
268 P_SUM_7 NUMBER;
269
270 P_SUM_6 NUMBER;
271
272 P_SUM_5 NUMBER;
273
274 P_SUM_4 NUMBER;
275
276 P_SUM_3 NUMBER;
277
278 P_SUM_2 NUMBER;
279
280 P_SUMS_6 VARCHAR2(240);
281
282 P_SUMS_5 VARCHAR2(240);
283
284 P_SUMS_4 VARCHAR2(240);
285
286 P_SUMS_3 VARCHAR2(240);
287
288 P_SUMS_2 VARCHAR2(240);
289
290 P_SUMS_1 VARCHAR2(240);
291
292 P_LEN_1 NUMBER;
293
294 P_LEN_30 NUMBER;
295
296 P_LEN_29 NUMBER;
297
298 P_LEN_28 NUMBER;
299
300 P_LEN_27 NUMBER;
301
302 P_LEN_26 NUMBER;
303
304 P_LEN_25 NUMBER;
305
306 P_LEN_24 NUMBER;
307
308 P_LEN_23 NUMBER;
309
310 P_LEN_22 NUMBER;
311
312 P_LEN_21 NUMBER;
313
314 P_LEN_20 NUMBER;
315
316 P_LEN_19 NUMBER;
317
318 P_LEN_18 NUMBER;
319
320 P_LEN_17 NUMBER;
321
322 P_LEN_16 NUMBER;
323
324 P_LEN_15 NUMBER;
325
326 P_LEN_14 NUMBER;
327
328 P_LEN_13 NUMBER;
329
330 P_LEN_12 NUMBER;
331
332 P_LEN_11 NUMBER;
333
334 P_LEN_10 NUMBER;
335
336 P_LEN_9 NUMBER;
337
338 P_LEN_8 NUMBER;
339
340 P_LEN_7 NUMBER;
341
342 P_LEN_6 NUMBER;
343
344 P_LEN_5 NUMBER;
345
346 P_LEN_4 NUMBER;
347
348 P_LEN_3 NUMBER;
349
350 P_LEN_2 NUMBER;
351
352 P_DEFAULT_LENGTH VARCHAR2(1500);
353
354 P_DEFAULT_SUMS VARCHAR2(1500);
355
356 P_TITLE VARCHAR2(50);
357
358 P_DESC VARCHAR2(240);
359
360 P_CONC_REQUEST_ID NUMBER := 0;
361
362 P_USER_ID NUMBER:='1001';
363
364 P_SECURITY_PROFILE NUMBER:=2;
365
366 FUNCTION AFTERPFORM RETURN BOOLEAN;
367
368 FUNCTION BEFOREREPORT RETURN BOOLEAN;
369
370 FUNCTION C_DASH_1FORMULA RETURN VARCHAR2;
371
372 FUNCTION C_DASH_2FORMULA RETURN VARCHAR2;
373
374 FUNCTION C_DASH_3FORMULA RETURN VARCHAR2;
375
376 FUNCTION C_DASH_4FORMULA RETURN VARCHAR2;
377
378 FUNCTION C_DASH_5FORMULA RETURN VARCHAR2;
379
380 FUNCTION C_DASH_6FORMULA RETURN VARCHAR2;
381
382 FUNCTION C_DASH_7FORMULA RETURN VARCHAR2;
383
384 FUNCTION C_DASH_8FORMULA RETURN VARCHAR2;
385
386 FUNCTION C_DASH_9FORMULA RETURN VARCHAR2;
387
388 FUNCTION C_DASH_10FORMULA RETURN VARCHAR2;
389
390 FUNCTION C_DASH_11FORMULA RETURN VARCHAR2;
391
392 FUNCTION C_DASH_12FORMULA RETURN VARCHAR2;
393
394 FUNCTION C_DASH_13FORMULA RETURN VARCHAR2;
395
396 FUNCTION C_DASH_14FORMULA RETURN VARCHAR2;
397
398 FUNCTION C_DASH_15FORMULA RETURN VARCHAR2;
399
400 FUNCTION C_DASH_16FORMULA RETURN VARCHAR2;
401
402 FUNCTION C_DASH_17FORMULA RETURN VARCHAR2;
403
404 FUNCTION C_DASH_18FORMULA RETURN VARCHAR2;
405
406 FUNCTION C_DASH_19FORMULA RETURN VARCHAR2;
407
408 FUNCTION C_DASH_20FORMULA RETURN VARCHAR2;
409
410 FUNCTION C_DASH_21FORMULA RETURN VARCHAR2;
411
412 FUNCTION C_DASH_22FORMULA RETURN VARCHAR2;
413
414 FUNCTION C_DASH_23FORMULA RETURN VARCHAR2;
415
416 FUNCTION C_DASH_24FORMULA RETURN VARCHAR2;
417
418 FUNCTION C_DASH_25FORMULA RETURN VARCHAR2;
419
420 FUNCTION C_DASH_26FORMULA RETURN VARCHAR2;
421
422 FUNCTION C_DASH_27FORMULA RETURN VARCHAR2;
423
424 FUNCTION C_DASH_28FORMULA RETURN VARCHAR2;
425
426 FUNCTION C_DASH_29FORMULA RETURN VARCHAR2;
427
428 FUNCTION C_DASH_30FORMULA RETURN VARCHAR2;
429
430 FUNCTION C_MAY_DASH_1FORMULA RETURN VARCHAR2;
431
432 FUNCTION C_MAY_DASH_2FORMULA RETURN VARCHAR2;
433
434 FUNCTION C_MAY_DASH_3FORMULA RETURN VARCHAR2;
435
436 FUNCTION C_MAY_DASH_4FORMULA RETURN VARCHAR2;
437
438 FUNCTION C_MAY_DASH_5FORMULA RETURN VARCHAR2;
439
440 FUNCTION C_MAY_DASH_6FORMULA RETURN VARCHAR2;
441
442 FUNCTION C_MAY_DASH_7FORMULA RETURN VARCHAR2;
443
444 FUNCTION C_MAY_DASH_8FORMULA RETURN VARCHAR2;
445
446 FUNCTION C_MAY_DASH_9FORMULA RETURN VARCHAR2;
447
448 FUNCTION C_MAY_DASH_10FORMULA RETURN VARCHAR2;
449
450 FUNCTION C_MAY_DASH_11FORMULA RETURN VARCHAR2;
451
452 FUNCTION C_MAY_DASH_12FORMULA RETURN VARCHAR2;
453
454 FUNCTION C_MAY_DASH_13FORMULA RETURN VARCHAR2;
455
456 FUNCTION C_MAY_DASH_14FORMULA RETURN VARCHAR2;
457
458 FUNCTION C_MAY_DASH_15FORMULA RETURN VARCHAR2;
459
460 FUNCTION C_MAY_DASH_16FORMULA RETURN VARCHAR2;
461
462 FUNCTION C_MAY_DASH_17FORMULA RETURN VARCHAR2;
463
464 FUNCTION C_MAY_DASH_18FORMULA RETURN VARCHAR2;
465
466 FUNCTION C_MAY_DASH_19FORMULA RETURN VARCHAR2;
467
468 FUNCTION C_MAY_DASH_20FORMULA RETURN VARCHAR2;
469
470 FUNCTION C_MAY_DASH_21FORMULA RETURN VARCHAR2;
471
472 FUNCTION C_MAY_DASH_22FORMULA RETURN VARCHAR2;
473
477
474 FUNCTION C_MAY_DASH_23FORMULA RETURN VARCHAR2;
475
476 FUNCTION C_MAY_DASH_24FORMULA RETURN VARCHAR2;
478 FUNCTION C_MAY_DASH_25FORMULA RETURN VARCHAR2;
479
480 FUNCTION C_MAY_DASH_26FORMULA RETURN VARCHAR2;
481
482 FUNCTION C_MAY_DASH_27FORMULA RETURN VARCHAR2;
483
484 FUNCTION C_MAY_DASH_28FORMULA RETURN VARCHAR2;
485
486 FUNCTION C_MAY_DASH_29FORMULA RETURN VARCHAR2;
487
488 FUNCTION C_MAY_DASH_30FORMULA RETURN VARCHAR2;
489
490 FUNCTION C_FINAL_SUM_1FORMULA(SUM_1 IN NUMBER) RETURN VARCHAR2;
491
492 FUNCTION C_FINAL_SUM_2FORMULA(SUM_2 IN NUMBER) RETURN VARCHAR2;
493
494 FUNCTION C_FINAL_SUM_3FORMULA(SUM_3 IN NUMBER) RETURN VARCHAR2;
495
496 FUNCTION C_FINAL_SUM_4FORMULA(SUM_4 IN NUMBER) RETURN VARCHAR2;
497
498 FUNCTION C_FINAL_SUM_5FORMULA(SUM_5 IN NUMBER) RETURN VARCHAR2;
499
500 FUNCTION C_FINAL_SUM_6FORMULA(SUM_6 IN NUMBER) RETURN VARCHAR2;
501
502 FUNCTION C_FINAL_SUM_7FORMULA(SUM_7 IN NUMBER) RETURN VARCHAR2;
503
504 FUNCTION C_FINAL_SUM_8FORMULA(SUM_8 IN NUMBER) RETURN VARCHAR2;
505
506 FUNCTION C_FINAL_SUM_9FORMULA(SUM_9 IN NUMBER) RETURN VARCHAR2;
507
508 FUNCTION C_FINAL_SUM_10FORMULA(SUM_10 IN NUMBER) RETURN VARCHAR2;
509
510 FUNCTION C_FINAL_SUM_11FORMULA(SUM_11 IN NUMBER) RETURN VARCHAR2;
511
512 FUNCTION C_FINAL_SUM_12FORMULA(SUM_12 IN NUMBER) RETURN VARCHAR2;
513
514 FUNCTION C_FINAL_SUM_13FORMULA(SUM_13 IN NUMBER) RETURN VARCHAR2;
515
516 FUNCTION C_FINAL_SUM_14FORMULA(SUM_14 IN NUMBER) RETURN VARCHAR2;
517
518 FUNCTION C_FINAL_SUM_15FORMULA(SUM_15 IN NUMBER) RETURN VARCHAR2;
519
520 FUNCTION C_FINAL_SUM_16FORMULA(SUM_16 IN NUMBER) RETURN VARCHAR2;
521
522 FUNCTION C_FINAL_SUM_17FORMULA(SUM_17 IN NUMBER) RETURN VARCHAR2;
523
524 FUNCTION C_FINAL_SUM_18FORMULA(SUM_18 IN NUMBER) RETURN VARCHAR2;
525
526 FUNCTION C_FINAL_SUM_19FORMULA(SUM_19 IN NUMBER) RETURN VARCHAR2;
527
528 FUNCTION C_FINAL_SUM_20FORMULA(SUM_20 IN NUMBER) RETURN VARCHAR2;
529
530 FUNCTION C_FINAL_SUM_21FORMULA(SUM_21 IN NUMBER) RETURN VARCHAR2;
531
532 FUNCTION C_FINAL_SUM_22FORMULA(SUM_22 IN NUMBER) RETURN VARCHAR2;
533
534 FUNCTION C_FINAL_SUM_23FORMULA(SUM_23 IN NUMBER) RETURN VARCHAR2;
535
536 FUNCTION C_FINAL_SUM_24FORMULA(SUM_24 IN NUMBER) RETURN VARCHAR2;
537
538 FUNCTION C_FINAL_SUM_25FORMULA(SUM_25 IN NUMBER) RETURN VARCHAR2;
539
540 FUNCTION C_FINAL_SUM_26FORMULA(SUM_26 IN NUMBER) RETURN VARCHAR2;
541
542 FUNCTION C_FINAL_SUM_27FORMULA(SUM_27 IN NUMBER) RETURN VARCHAR2;
543
544 FUNCTION C_FINAL_SUM_28FORMULA(SUM_28 IN NUMBER) RETURN VARCHAR2;
545
546 FUNCTION C_FINAL_SUM_29FORMULA(SUM_29 IN NUMBER) RETURN VARCHAR2;
547
548 FUNCTION C_FINAL_SUM_30FORMULA(SUM_30 IN NUMBER) RETURN VARCHAR2;
549
550 FUNCTION C_AST_2FORMULA(NUM_2 IN NUMBER
551 ,COL_2 IN VARCHAR2) RETURN VARCHAR2;
552
553 FUNCTION C_AST_3FORMULA(NUM_3 IN NUMBER
554 ,COL_3 IN VARCHAR2) RETURN VARCHAR2;
555
556 FUNCTION C_AST_1FORMULA(NUM_1 IN NUMBER
557 ,COL_1 IN VARCHAR2) RETURN VARCHAR2;
558
559 FUNCTION C_AST_4FORMULA(NUM_4 IN NUMBER
560 ,COL_4 IN VARCHAR2) RETURN VARCHAR2;
561
562 FUNCTION C_AST_5FORMULA(NUM_5 IN NUMBER
563 ,COL_5 IN VARCHAR2) RETURN VARCHAR2;
564
565 FUNCTION C_AST_6FORMULA(NUM_6 IN NUMBER
566 ,COL_6 IN VARCHAR2) RETURN VARCHAR2;
567
568 FUNCTION C_AST_7FORMULA(NUM_7 IN NUMBER
569 ,COL_7 IN VARCHAR2) RETURN VARCHAR2;
570
571 FUNCTION C_AST_8FORMULA(NUM_8 IN NUMBER
572 ,COL_8 IN VARCHAR2) RETURN VARCHAR2;
573
574 FUNCTION C_AST_9FORMULA(NUM_9 IN NUMBER
575 ,COL_9 IN VARCHAR2) RETURN VARCHAR2;
576
577 FUNCTION C_AST_10FORMULA(NUM_10 IN NUMBER
578 ,COL_10 IN VARCHAR2) RETURN VARCHAR2;
579
580 FUNCTION C_AST_15FORMULA(NUM_15 IN NUMBER
584 ,COL_14 IN VARCHAR2) RETURN VARCHAR2;
581 ,COL_15 IN VARCHAR2) RETURN VARCHAR2;
582
583 FUNCTION C_AST_14FORMULA(NUM_14 IN NUMBER
585
586 FUNCTION C_AST_13FORMULA(NUM_13 IN NUMBER
587 ,COL_13 IN VARCHAR2) RETURN VARCHAR2;
588
589 FUNCTION C_AST_12FORMULA(NUM_12 IN NUMBER
590 ,COL_12 IN VARCHAR2) RETURN VARCHAR2;
591
592 FUNCTION C_AST_11FORMULA(NUM_11 IN NUMBER
593 ,COL_11 IN VARCHAR2) RETURN VARCHAR2;
594
595 FUNCTION C_AST_18FORMULA(NUM_18 IN NUMBER
596 ,COL_18 IN VARCHAR2) RETURN VARCHAR2;
597
598 FUNCTION C_AST_17FORMULA(NUM_17 IN NUMBER
599 ,COL_17 IN VARCHAR2) RETURN VARCHAR2;
600
601 FUNCTION C_AST_16FORMULA(NUM_16 IN NUMBER
602 ,COL_16 IN VARCHAR2) RETURN VARCHAR2;
603
604 FUNCTION C_AST_19FORMULA(NUM_19 IN NUMBER
605 ,COL_19 IN VARCHAR2) RETURN VARCHAR2;
606
607 FUNCTION C_AST_20FORMULA(NUM_20 IN NUMBER
608 ,COL_20 IN VARCHAR2) RETURN VARCHAR2;
609
610 FUNCTION C_AST_25FORMULA(NUM_25 IN NUMBER
611 ,COL_25 IN VARCHAR2) RETURN VARCHAR2;
612
613 FUNCTION C_AST_24FORMULA(NUM_24 IN NUMBER
614 ,COL_24 IN VARCHAR2) RETURN VARCHAR2;
615
616 FUNCTION C_AST_23FORMULA(NUM_23 IN NUMBER
617 ,COL_23 IN VARCHAR2) RETURN VARCHAR2;
618
619 FUNCTION C_AST_22FORMULA(NUM_22 IN NUMBER
620 ,COL_22 IN VARCHAR2) RETURN VARCHAR2;
621
622 FUNCTION C_AST_21FORMULA(NUM_21 IN NUMBER
623 ,COL_21 IN VARCHAR2) RETURN VARCHAR2;
624
625 FUNCTION C_AST_30FORMULA(NUM_30 IN NUMBER
626 ,COL_30 IN VARCHAR2) RETURN VARCHAR2;
627
628 FUNCTION C_AST_29FORMULA(NUM_29 IN NUMBER
629 ,COL_29 IN VARCHAR2) RETURN VARCHAR2;
630
631 FUNCTION C_AST_28FORMULA(NUM_28 IN NUMBER
632 ,COL_28 IN VARCHAR2) RETURN VARCHAR2;
633
634 FUNCTION C_AST_27FORMULA(NUM_27 IN NUMBER
635 ,COL_27 IN VARCHAR2) RETURN VARCHAR2;
636
637 FUNCTION C_AST_26FORMULA(NUM_26 IN NUMBER
638 ,COL_26 IN VARCHAR2) RETURN VARCHAR2;
639
640 FUNCTION AFTERREPORT RETURN BOOLEAN;
641
642 PROCEDURE MAKE_SQL(X_CRITERIA_ID IN NUMBER
643 ,X_SELECT OUT NOCOPY VARCHAR2
644 ,X_WHERE OUT NOCOPY VARCHAR2
645 ,X_PROMPTS OUT NOCOPY VARCHAR2
646 ,X_LENGTH OUT NOCOPY VARCHAR2
647 ,X_SUM OUT NOCOPY VARCHAR2
648 ,X_TITLE OUT NOCOPY VARCHAR2
649 ,X_DESCRIPTION OUT NOCOPY VARCHAR2);
650
651 V_CRITERIA_ID NUMBER;
652
653 V_SELECT VARCHAR2(32767);
654
655 V_WHERE VARCHAR2(32767);
656
657 V_PROMPTS VARCHAR2(32767);
658
659 V_LENGTH VARCHAR2(32767);
660
661 V_SUM VARCHAR2(32767);
662
663 PROCEDURE LAUNCH_PRODUCT(X_PLAN_ID IN NUMBER);
664
665 PROCEDURE CREATE_WHERE(X_ROW IN NUMBER);
666
667 FUNCTION FKEY_RESOLVER(X_ROW IN NUMBER) RETURN VARCHAR2;
668
669 FUNCTION RESOLVE_TYPE(X_ROW IN NUMBER
670 ,X_NAME IN VARCHAR2) RETURN VARCHAR2;
671
672 FUNCTION ADD_FXN(X_ROW IN NUMBER
673 ,X_NAME IN VARCHAR2) RETURN VARCHAR2;
674
675 FUNCTION ADD_FXN_RPT(X_ROW IN NUMBER
676 ,X_NAME IN VARCHAR2) RETURN VARCHAR2;
677
678 PROCEDURE LOOP_THROUGH_RECORDS;
679
680 END QA_QLTRSLTR_XMLP_PKG;
681
682