[Home] [Help]
28:
29: PROCEDURE get_kpi(
30: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
31: ,p_exp_source_sql out NOCOPY VARCHAR2
32: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
33: is
34: l_sqlstmt VARCHAR2(15000);
35: counter NUMBER := 0;
36: where_clause VARCHAR2(4000) := ' ';
39:
40: v_period varchar2(100);
41: v_qtr varchar2(100);
42: v_year varchar2(100);
43: l_bind_rec BIS_QUERY_ATTRIBUTES;
44: BEGIN
45: counter := p_page_parameter_tbl.COUNT;
46: FOR i IN 1..counter LOOP
47: IF p_page_parameter_tbl(i).parameter_id IS NOT NULL THEN
129:
130: p_exp_source_sql := l_sqlstmt;
131:
132: /**04.21.2006 npanandi: adding code for dynamic binding of time period dimensions**/
133: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
134: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
135:
136: p_exp_source_output.EXTEND;
137: l_bind_rec.attribute_name := ':WFTIME';
168: */
169: PROCEDURE get_open_remediation_result(
170: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
171: ,p_exp_source_sql out NOCOPY VARCHAR2
172: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
173: is
174: counter NUMBER := 0;
175: l_sqlstmt VARCHAR2(15000);
176: l_act_sqlstmt varchar2(15000);
187:
188: v_period varchar2(100);
189: v_qtr varchar2(100);
190: v_year varchar2(100);
191: l_bind_rec BIS_QUERY_ATTRIBUTES;
192: BEGIN
193:
194: counter := p_page_parameter_tbl.COUNT;
195: FOR i IN 1..counter LOOP
410: --todo remove the status_code condition
411: p_exp_source_sql := l_act_sqlstmt;
412:
413: /**04.25.2006 npanandi: adding code for dynamic binding of time period dimensions**/
414: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
415: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
416:
417: p_exp_source_output.EXTEND;
418: l_bind_rec.attribute_name := ':WFTIME';
447:
448: PROCEDURE get_findings_details(
449: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
450: ,p_exp_source_sql out NOCOPY VARCHAR2
451: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
452: is
453: counter NUMBER := 0;
454: l_sqlstmt VARCHAR2(15000);
455: where_clause VARCHAR2(2000) := ' ';
459:
460: v_period varchar2(100);
461: v_qtr varchar2(100);
462: v_year varchar2(100);
463: l_bind_rec BIS_QUERY_ATTRIBUTES;
464: BEGIN
465: counter := p_page_parameter_tbl.COUNT;
466: FOR i IN 1..counter LOOP
467: IF p_page_parameter_tbl(i).parameter_id IS NOT NULL THEN
580: ;
581: p_exp_source_sql := l_sqlstmt;
582:
583: /**04.25.2006 npanandi: adding code for dynamic binding of time period dimensions**/
584: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
585: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
586:
587: p_exp_source_output.EXTEND;
588: l_bind_rec.attribute_name := ':TIME';
596:
597: PROCEDURE get_remediations_details(
598: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
599: ,p_exp_source_sql out NOCOPY VARCHAR2
600: ,p_exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
601: is
602: counter NUMBER := 0;
603: l_sqlstmt VARCHAR2(15000);
604: where_clause VARCHAR2(2000) := ' ';
608:
609: v_period varchar2(100);
610: v_qtr varchar2(100);
611: v_year varchar2(100);
612: l_bind_rec BIS_QUERY_ATTRIBUTES;
613: BEGIN
614:
615: counter := p_page_parameter_tbl.COUNT;
616: FOR i IN 1..counter LOOP
736:
737: p_exp_source_sql := l_sqlstmt;
738:
739: /**04.25.2006 npanandi: adding code for dynamic binding of time period dimensions**/
740: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
741: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
742:
743: p_exp_source_output.EXTEND;
744: l_bind_rec.attribute_name := ':TIME';