895: x_custom_sql := l_act_sqlstmt;
896:
897: /**05.05.2006 npanandi: adding code for dynamic binding of time period dimensions**/
898: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
899: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
900:
901: x_custom_output.EXTEND;
902: l_bind_rec.attribute_name := ':TIME1';
903: l_bind_rec.attribute_value := v_period;
900:
901: x_custom_output.EXTEND;
902: l_bind_rec.attribute_name := ':TIME1';
903: l_bind_rec.attribute_value := v_period;
904: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
905: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
906: x_custom_output(x_custom_output.COUNT) := l_bind_rec;
907: /**05.05.2006 npanandi: finished code for dynamic binding of time period dimensions**/
908: end;
901: x_custom_output.EXTEND;
902: l_bind_rec.attribute_name := ':TIME1';
903: l_bind_rec.attribute_value := v_period;
904: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
905: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
906: x_custom_output(x_custom_output.COUNT) := l_bind_rec;
907: /**05.05.2006 npanandi: finished code for dynamic binding of time period dimensions**/
908: end;
909: