18: l_previous_as_of_date DATE;
19: l_period_type_id NUMBER;
20: l_time_id_column VARCHAR2(1000);
21: l_goal NUMBER;
22: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
23: l_classification VARCHAR2(32000);
24: l_where_clause VARCHAR2(32000);
25: l_view_by varchar2(1000);
26: l_row_type varchar2(10) := 'AC';
266: END IF;
267:
268: p_custom_sql := l_sqltext;
269:
270: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
271: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
272: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
273:
274: p_custom_output.EXTEND();
267:
268: p_custom_sql := l_sqltext;
269:
270: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
271: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
272: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
273:
274: p_custom_output.EXTEND();
275: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
276:
277: IF ( l_account IS NOT NULL) THEN
278: l_custom_rec.attribute_name := ':l_account' ;
279: l_custom_rec.attribute_value:= l_account;
280: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
281: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
282:
283: p_custom_output.Extend();
284: p_custom_output(p_custom_output.count) := l_custom_rec;
277: IF ( l_account IS NOT NULL) THEN
278: l_custom_rec.attribute_name := ':l_account' ;
279: l_custom_rec.attribute_value:= l_account;
280: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
281: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
282:
283: p_custom_output.Extend();
284: p_custom_output(p_custom_output.count) := l_custom_rec;
285: END IF;
286:
287: IF ( l_classification IS NOT NULL) THEN
288: l_custom_rec.attribute_name := ':l_classification' ;
289: l_custom_rec.attribute_value:= l_classification;
290: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
291: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
292:
293: p_custom_output.Extend();
294: p_custom_output(p_custom_output.count) := l_custom_rec;
287: IF ( l_classification IS NOT NULL) THEN
288: l_custom_rec.attribute_name := ':l_classification' ;
289: l_custom_rec.attribute_value:= l_classification;
290: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
291: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
292:
293: p_custom_output.Extend();
294: p_custom_output(p_custom_output.count) := l_custom_rec;
295: END IF;
295: END IF;
296:
297: l_custom_rec.attribute_name := ':l_row_type' ;
298: l_custom_rec.attribute_value:= l_row_type;
299: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
300: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
301:
302: p_custom_output.Extend();
303: p_custom_output(p_custom_output.count) := l_custom_rec;
296:
297: l_custom_rec.attribute_name := ':l_row_type' ;
298: l_custom_rec.attribute_value:= l_row_type;
299: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
300: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
301:
302: p_custom_output.Extend();
303: p_custom_output(p_custom_output.count) := l_custom_rec;
304: