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';
289: END IF;
290:
291: p_custom_sql := l_sqltext;
292:
293: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
294: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
295: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
296:
297: p_custom_output.EXTEND();
290:
291: p_custom_sql := l_sqltext;
292:
293: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
294: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
295: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
296:
297: p_custom_output.EXTEND();
298: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
299:
300: IF ( l_account IS NOT NULL) THEN
301: l_custom_rec.attribute_name := ':l_account' ;
302: l_custom_rec.attribute_value:= l_account;
303: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
304: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
305:
306: p_custom_output.Extend();
307: p_custom_output(p_custom_output.count) := l_custom_rec;
300: IF ( l_account IS NOT NULL) THEN
301: l_custom_rec.attribute_name := ':l_account' ;
302: l_custom_rec.attribute_value:= l_account;
303: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
304: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
305:
306: p_custom_output.Extend();
307: p_custom_output(p_custom_output.count) := l_custom_rec;
308: END IF;
309:
310: IF ( l_classification IS NOT NULL) THEN
311: l_custom_rec.attribute_name := ':l_classification' ;
312: l_custom_rec.attribute_value:= l_classification;
313: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
314: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
315:
316: p_custom_output.Extend();
317: p_custom_output(p_custom_output.count) := l_custom_rec;
310: IF ( l_classification IS NOT NULL) THEN
311: l_custom_rec.attribute_name := ':l_classification' ;
312: l_custom_rec.attribute_value:= l_classification;
313: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
314: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
315:
316: p_custom_output.Extend();
317: p_custom_output(p_custom_output.count) := l_custom_rec;
318: END IF;
318: END IF;
319:
320: l_custom_rec.attribute_name := ':l_row_type' ;
321: l_custom_rec.attribute_value:= l_row_type;
322: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
323: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
324:
325: p_custom_output.Extend();
326: p_custom_output(p_custom_output.count) := l_custom_rec;
319:
320: l_custom_rec.attribute_name := ':l_row_type' ;
321: l_custom_rec.attribute_value:= l_row_type;
322: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
323: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
324:
325: p_custom_output.Extend();
326: p_custom_output(p_custom_output.count) := l_custom_rec;
327: