134: ';
135:
136: p_exp_source_sql := l_sqlstmt;
137: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
138: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
139:
140: p_exp_source_output.EXTEND;
141: l_bind_rec.attribute_name := ':TIME';
142: l_bind_rec.attribute_value := v_period;
139:
140: p_exp_source_output.EXTEND;
141: l_bind_rec.attribute_name := ':TIME';
142: l_bind_rec.attribute_value := v_period;
143: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
144: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
145: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
146:
147: END get_kpi;
140: p_exp_source_output.EXTEND;
141: l_bind_rec.attribute_name := ':TIME';
142: l_bind_rec.attribute_value := v_period;
143: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
144: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
145: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
146:
147: END get_kpi;
148:
255: ';
256:
257: p_exp_source_sql := l_sqlstmt;
258: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
259: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
260:
261: p_exp_source_output.EXTEND;
262: l_bind_rec.attribute_name := ':TIME';
263: l_bind_rec.attribute_value := v_period;
260:
261: p_exp_source_output.EXTEND;
262: l_bind_rec.attribute_name := ':TIME';
263: l_bind_rec.attribute_value := v_period;
264: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
265: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
266: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
267:
268: END get_sig_acct_eval_details;
261: p_exp_source_output.EXTEND;
262: l_bind_rec.attribute_name := ':TIME';
263: l_bind_rec.attribute_value := v_period;
264: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
265: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
266: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
267:
268: END get_sig_acct_eval_details;
269:
465:
466:
467: p_exp_source_sql := l_act_sqlstmt;
468: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
469: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
470:
471: p_exp_source_output.EXTEND;
472: l_bind_rec.attribute_name := ':TIME';
473: l_bind_rec.attribute_value := v_period;
470:
471: p_exp_source_output.EXTEND;
472: l_bind_rec.attribute_name := ':TIME';
473: l_bind_rec.attribute_value := v_period;
474: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
475: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
476: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
477: END get_org_details;
478:
471: p_exp_source_output.EXTEND;
472: l_bind_rec.attribute_name := ':TIME';
473: l_bind_rec.attribute_value := v_period;
474: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
475: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
476: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
477: END get_org_details;
478:
479: -- used in get_org_def_details
641: '||where_clause;
642:
643: p_exp_source_sql := l_sqlstmt;
644: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
645: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
646:
647: p_exp_source_output.EXTEND;
648: l_bind_rec.attribute_name := ':TIME';
649: l_bind_rec.attribute_value := v_period;
646:
647: p_exp_source_output.EXTEND;
648: l_bind_rec.attribute_name := ':TIME';
649: l_bind_rec.attribute_value := v_period;
650: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
651: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
652: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
653:
654: END get_org_def_details;
647: p_exp_source_output.EXTEND;
648: l_bind_rec.attribute_name := ':TIME';
649: l_bind_rec.attribute_value := v_period;
650: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
651: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
652: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
653:
654: END get_org_def_details;
655:
748: ' || where_clause;
749:
750: p_exp_source_sql := l_sqlstmt;
751: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
752: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
753:
754: p_exp_source_output.EXTEND;
755: l_bind_rec.attribute_name := ':TIME';
756: l_bind_rec.attribute_value := v_period;
753:
754: p_exp_source_output.EXTEND;
755: l_bind_rec.attribute_name := ':TIME';
756: l_bind_rec.attribute_value := v_period;
757: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
758: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
759: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
760:
761: END get_sig_acct_details;
754: p_exp_source_output.EXTEND;
755: l_bind_rec.attribute_name := ':TIME';
756: l_bind_rec.attribute_value := v_period;
757: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
758: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
759: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
760:
761: END get_sig_acct_details;
762:
911: order by a.col_rank ';
912:
913: p_exp_source_sql := l_act_sqlstmt;
914: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
915: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
916:
917: p_exp_source_output.EXTEND;
918: l_bind_rec.attribute_name := ':TIME';
919: l_bind_rec.attribute_value := v_period;
916:
917: p_exp_source_output.EXTEND;
918: l_bind_rec.attribute_name := ':TIME';
919: l_bind_rec.attribute_value := v_period;
920: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
921: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
922: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
923:
924: END get_sig_acct_eval_result;
917: p_exp_source_output.EXTEND;
918: l_bind_rec.attribute_name := ':TIME';
919: l_bind_rec.attribute_value := v_period;
920: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
921: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
922: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
923:
924: END get_sig_acct_eval_result;
925:
1130: order by a.col_rank ';
1131:
1132: p_exp_source_sql := l_act_sqlstmt;
1133: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
1134: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1135:
1136: p_exp_source_output.EXTEND;
1137: l_bind_rec.attribute_name := ':TIME';
1138: l_bind_rec.attribute_value := v_period;
1135:
1136: p_exp_source_output.EXTEND;
1137: l_bind_rec.attribute_name := ':TIME';
1138: l_bind_rec.attribute_value := v_period;
1139: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1140: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1141: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
1142: END get_sig_acct_eval_summ_result;
1143:
1136: p_exp_source_output.EXTEND;
1137: l_bind_rec.attribute_name := ':TIME';
1138: l_bind_rec.attribute_value := v_period;
1139: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1140: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1141: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
1142: END get_sig_acct_eval_summ_result;
1143:
1144: /*