eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.QA_QLTRSLTR_XMLP_PKG

Source


1 PACKAGE QA_QLTRSLTR_XMLP_PKG AUTHID CURRENT_USER 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 
474   FUNCTION C_MAY_DASH_23FORMULA RETURN VARCHAR2;
475 
476   FUNCTION C_MAY_DASH_24FORMULA RETURN VARCHAR2;
477 
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 
503 
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;
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
581                           ,COL_15 IN VARCHAR2) RETURN VARCHAR2;
582 
583   FUNCTION C_AST_14FORMULA(NUM_14 IN NUMBER
584                           ,COL_14 IN VARCHAR2) RETURN VARCHAR2;
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 
643                     ,X_SELECT OUT NOCOPY VARCHAR2
640   FUNCTION AFTERREPORT RETURN BOOLEAN;
641 
642   PROCEDURE MAKE_SQL(X_CRITERIA_ID IN NUMBER
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