127: /***12.12.2005 npanandi: bug 4880422 fix ends ***/
128:
129: /**04.27.2006 npanandi: adding code for dynamic binding of time period dimensions**/
130: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
131: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
132:
133: p_exp_source_output.EXTEND;
134: l_bind_rec.attribute_name := ':TIME1';
135: l_bind_rec.attribute_value := v_period;
132:
133: p_exp_source_output.EXTEND;
134: l_bind_rec.attribute_name := ':TIME1';
135: l_bind_rec.attribute_value := v_period;
136: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
137: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
138: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
139: /**04.27.2006 npanandi: finished code for dynamic binding of time period dimensions**/
140: END get_org_kpi;
133: p_exp_source_output.EXTEND;
134: l_bind_rec.attribute_name := ':TIME1';
135: l_bind_rec.attribute_value := v_period;
136: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
137: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
138: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
139: /**04.27.2006 npanandi: finished code for dynamic binding of time period dimensions**/
140: END get_org_kpi;
141:
445: p_exp_source_sql := l_act_sqlstmt;
446:
447: /**04.27.2006 npanandi: adding code for dynamic binding of time period dimensions**/
448: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
449: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
450:
451: p_exp_source_output.EXTEND;
452: l_bind_rec.attribute_name := ':TIME1';
453: l_bind_rec.attribute_value := v_period;
450:
451: p_exp_source_output.EXTEND;
452: l_bind_rec.attribute_name := ':TIME1';
453: l_bind_rec.attribute_value := v_period;
454: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
455: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
456: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
457:
458: p_exp_source_output.EXTEND;
451: p_exp_source_output.EXTEND;
452: l_bind_rec.attribute_name := ':TIME1';
453: l_bind_rec.attribute_value := v_period;
454: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
455: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
456: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
457:
458: p_exp_source_output.EXTEND;
459: l_bind_rec.attribute_name := ':TIME2';
457:
458: p_exp_source_output.EXTEND;
459: l_bind_rec.attribute_name := ':TIME2';
460: l_bind_rec.attribute_value := v_period;
461: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
462: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
463: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
464:
465: p_exp_source_output.EXTEND;
458: p_exp_source_output.EXTEND;
459: l_bind_rec.attribute_name := ':TIME2';
460: l_bind_rec.attribute_value := v_period;
461: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
462: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
463: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
464:
465: p_exp_source_output.EXTEND;
466: l_bind_rec.attribute_name := ':TIME3';
464:
465: p_exp_source_output.EXTEND;
466: l_bind_rec.attribute_name := ':TIME3';
467: l_bind_rec.attribute_value := v_period;
468: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
469: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
470: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
471:
472: p_exp_source_output.EXTEND;
465: p_exp_source_output.EXTEND;
466: l_bind_rec.attribute_name := ':TIME3';
467: l_bind_rec.attribute_value := v_period;
468: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
469: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
470: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
471:
472: p_exp_source_output.EXTEND;
473: l_bind_rec.attribute_name := ':TIME4';
471:
472: p_exp_source_output.EXTEND;
473: l_bind_rec.attribute_name := ':TIME4';
474: l_bind_rec.attribute_value := v_period;
475: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
476: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
477: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
478:
479: p_exp_source_output.EXTEND;
472: p_exp_source_output.EXTEND;
473: l_bind_rec.attribute_name := ':TIME4';
474: l_bind_rec.attribute_value := v_period;
475: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
476: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
477: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
478:
479: p_exp_source_output.EXTEND;
480: l_bind_rec.attribute_name := ':TIME5';
478:
479: p_exp_source_output.EXTEND;
480: l_bind_rec.attribute_name := ':TIME5';
481: l_bind_rec.attribute_value := v_period;
482: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
483: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
484: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
485:
486: p_exp_source_output.EXTEND;
479: p_exp_source_output.EXTEND;
480: l_bind_rec.attribute_name := ':TIME5';
481: l_bind_rec.attribute_value := v_period;
482: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
483: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
484: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
485:
486: p_exp_source_output.EXTEND;
487: l_bind_rec.attribute_name := ':TIME6';
485:
486: p_exp_source_output.EXTEND;
487: l_bind_rec.attribute_name := ':TIME6';
488: l_bind_rec.attribute_value := v_period;
489: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
490: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
491: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
492:
493: p_exp_source_output.EXTEND;
486: p_exp_source_output.EXTEND;
487: l_bind_rec.attribute_name := ':TIME6';
488: l_bind_rec.attribute_value := v_period;
489: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
490: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
491: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
492:
493: p_exp_source_output.EXTEND;
494: l_bind_rec.attribute_name := ':TIME7';
492:
493: p_exp_source_output.EXTEND;
494: l_bind_rec.attribute_name := ':TIME7';
495: l_bind_rec.attribute_value := v_period;
496: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
497: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
498: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
499: /**04.27.2006 npanandi: finished code for dynamic binding of time period dimensions**/
500: END get_org_certification_result;
493: p_exp_source_output.EXTEND;
494: l_bind_rec.attribute_name := ':TIME7';
495: l_bind_rec.attribute_value := v_period;
496: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
497: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
498: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
499: /**04.27.2006 npanandi: finished code for dynamic binding of time period dimensions**/
500: END get_org_certification_result;
501:
655: p_exp_source_sql := l_act_sqlstmt;
656:
657: /**04.27.2006 npanandi: adding code for dynamic binding of time period dimensions**/
658: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
659: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
660:
661: p_exp_source_output.EXTEND;
662: l_bind_rec.attribute_name := ':TIME1';
663: l_bind_rec.attribute_value := v_period;
660:
661: p_exp_source_output.EXTEND;
662: l_bind_rec.attribute_name := ':TIME1';
663: l_bind_rec.attribute_value := v_period;
664: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
665: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
666: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
667: /**04.27.2006 npanandi: finished code for dynamic binding of time period dimensions**/
668: END get_org_cert_prcnt;
661: p_exp_source_output.EXTEND;
662: l_bind_rec.attribute_name := ':TIME1';
663: l_bind_rec.attribute_value := v_period;
664: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
665: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
666: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
667: /**04.27.2006 npanandi: finished code for dynamic binding of time period dimensions**/
668: END get_org_cert_prcnt;
669:
861: p_exp_source_sql := l_act_sqlstmt;
862:
863: /**04.27.2006 npanandi: adding code for dynamic binding of time period dimensions**/
864: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
865: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
866:
867: p_exp_source_output.EXTEND;
868: l_bind_rec.attribute_name := ':TIME1';
869: l_bind_rec.attribute_value := v_period;
866:
867: p_exp_source_output.EXTEND;
868: l_bind_rec.attribute_name := ':TIME1';
869: l_bind_rec.attribute_value := v_period;
870: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
871: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
872: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
873: /**04.27.2006 npanandi: finished code for dynamic binding of time period dimensions**/
874:
867: p_exp_source_output.EXTEND;
868: l_bind_rec.attribute_name := ':TIME1';
869: l_bind_rec.attribute_value := v_period;
870: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
871: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
872: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
873: /**04.27.2006 npanandi: finished code for dynamic binding of time period dimensions**/
874:
875: END get_unmitigated_risks;
1059: p_exp_source_sql := l_act_sqlstmt;
1060:
1061: /**04.28.2006 npanandi: adding code for dynamic binding of time period dimensions**/
1062: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
1063: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1064:
1065: p_exp_source_output.EXTEND;
1066: l_bind_rec.attribute_name := ':TIME1';
1067: l_bind_rec.attribute_value := v_period;
1064:
1065: p_exp_source_output.EXTEND;
1066: l_bind_rec.attribute_name := ':TIME1';
1067: l_bind_rec.attribute_value := v_period;
1068: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1069: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1070: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
1071: /**04.28.2006 npanandi: finished code for dynamic binding of time period dimensions**/
1072:
1065: p_exp_source_output.EXTEND;
1066: l_bind_rec.attribute_name := ':TIME1';
1067: l_bind_rec.attribute_value := v_period;
1068: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1069: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1070: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
1071: /**04.28.2006 npanandi: finished code for dynamic binding of time period dimensions**/
1072:
1073:
1459: p_exp_source_sql := l_act_sqlstmt;
1460:
1461: /**04.28.2006 npanandi: adding code for dynamic binding of time period dimensions**/
1462: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
1463: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1464:
1465: p_exp_source_output.EXTEND;
1466: l_bind_rec.attribute_name := ':TIME1';
1467: l_bind_rec.attribute_value := v_period;
1464:
1465: p_exp_source_output.EXTEND;
1466: l_bind_rec.attribute_name := ':TIME1';
1467: l_bind_rec.attribute_value := v_period;
1468: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1469: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1470: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
1471: /**04.28.2006 npanandi: finished code for dynamic binding of time period dimensions**/
1472: END get_deficient_processes;
1465: p_exp_source_output.EXTEND;
1466: l_bind_rec.attribute_name := ':TIME1';
1467: l_bind_rec.attribute_value := v_period;
1468: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1469: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1470: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
1471: /**04.28.2006 npanandi: finished code for dynamic binding of time period dimensions**/
1472: END get_deficient_processes;
1473:
1641: ----p_exp_source_sql := l_sqlstmt || l_from_clause || l_group_by;
1642:
1643: /**04.28.2006 npanandi: adding code for dynamic binding of time period dimensions**/
1644: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
1645: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1646:
1647: p_exp_source_output.EXTEND;
1648: l_bind_rec.attribute_name := ':TIME1';
1649: l_bind_rec.attribute_value := v_period;
1646:
1647: p_exp_source_output.EXTEND;
1648: l_bind_rec.attribute_name := ':TIME1';
1649: l_bind_rec.attribute_value := v_period;
1650: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1651: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1652: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
1653: /**04.28.2006 npanandi: finished code for dynamic binding of time period dimensions**/
1654:
1647: p_exp_source_output.EXTEND;
1648: l_bind_rec.attribute_name := ':TIME1';
1649: l_bind_rec.attribute_value := v_period;
1650: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1651: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1652: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
1653: /**04.28.2006 npanandi: finished code for dynamic binding of time period dimensions**/
1654:
1655: END get_org_certification_detail;
1837: p_exp_source_sql := l_act_sqlstmt;
1838:
1839: /**04.28.2006 npanandi: adding code for dynamic binding of time period dimensions**/
1840: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
1841: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1842:
1843: p_exp_source_output.EXTEND;
1844: l_bind_rec.attribute_name := ':TIME1';
1845: l_bind_rec.attribute_value := v_period;
1842:
1843: p_exp_source_output.EXTEND;
1844: l_bind_rec.attribute_name := ':TIME1';
1845: l_bind_rec.attribute_value := v_period;
1846: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1847: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1848: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
1849: /**04.28.2006 npanandi: finished code for dynamic binding of time period dimensions**/
1850: END get_process_detail;
1843: p_exp_source_output.EXTEND;
1844: l_bind_rec.attribute_name := ':TIME1';
1845: l_bind_rec.attribute_value := v_period;
1846: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1847: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1848: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
1849: /**04.28.2006 npanandi: finished code for dynamic binding of time period dimensions**/
1850: END get_process_detail;
1851: