112: ';**/
113:
114: p_exp_source_sql := l_sqlstmt;
115: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
116: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
117:
118: p_exp_source_output.EXTEND;
119: l_bind_rec.attribute_name := ':TIME';
120: l_bind_rec.attribute_value := v_period;
117:
118: p_exp_source_output.EXTEND;
119: l_bind_rec.attribute_name := ':TIME';
120: l_bind_rec.attribute_value := v_period;
121: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
122: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
123: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
124:
125: END get_kpi;
118: p_exp_source_output.EXTEND;
119: l_bind_rec.attribute_name := ':TIME';
120: l_bind_rec.attribute_value := v_period;
121: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
122: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
123: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
124:
125: END get_kpi;
126:
220:
221: p_exp_source_sql := l_sqlstmt;
222:
223: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
224: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
225:
226: p_exp_source_output.EXTEND;
227: l_bind_rec.attribute_name := ':TIME';
228: l_bind_rec.attribute_value := v_period;
225:
226: p_exp_source_output.EXTEND;
227: l_bind_rec.attribute_name := ':TIME';
228: l_bind_rec.attribute_value := v_period;
229: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
230: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
231: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
232:
233: END get_proc_cert_details;
226: p_exp_source_output.EXTEND;
227: l_bind_rec.attribute_name := ':TIME';
228: l_bind_rec.attribute_value := v_period;
229: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
230: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
231: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
232:
233: END get_proc_cert_details;
234:
329: order by a.col_rank ';
330:
331: p_exp_source_sql := l_act_sqlstmt;
332: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
333: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
334:
335: p_exp_source_output.EXTEND;
336: l_bind_rec.attribute_name := ':TIME';
337: l_bind_rec.attribute_value := v_period;
334:
335: p_exp_source_output.EXTEND;
336: l_bind_rec.attribute_name := ':TIME';
337: l_bind_rec.attribute_value := v_period;
338: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
339: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
340: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
341:
342: END get_proc_cert_result;
335: p_exp_source_output.EXTEND;
336: l_bind_rec.attribute_name := ':TIME';
337: l_bind_rec.attribute_value := v_period;
338: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
339: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
340: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
341:
342: END get_proc_cert_result;
343:
570: order by a.col_rank ';
571:
572: p_exp_source_sql := l_act_sqlstmt;
573: p_exp_source_output := BIS_QUERY_ATTRIBUTES_TBL();
574: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
575:
576: p_exp_source_output.EXTEND;
577: l_bind_rec.attribute_name := ':TIME';
578: l_bind_rec.attribute_value := v_period;
575:
576: p_exp_source_output.EXTEND;
577: l_bind_rec.attribute_name := ':TIME';
578: l_bind_rec.attribute_value := v_period;
579: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
580: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
581: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
582:
583: END get_proc_cert_summary;
576: p_exp_source_output.EXTEND;
577: l_bind_rec.attribute_name := ':TIME';
578: l_bind_rec.attribute_value := v_period;
579: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
580: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
581: p_exp_source_output(p_exp_source_output.COUNT) := l_bind_rec;
582:
583: END get_proc_cert_summary;
584: