35: --Initialize p_custom_output
36: --
37:
38: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
39: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
40:
41: -- Get the parameters
42:
43: BIX_PMV_DBI_UTL_PKG.get_emc_page_params( p_page_parameter_tbl,
265:
266: p_custom_output.EXTEND();
267: l_custom_rec.attribute_name := ':l_period_type_id' ;
268: l_custom_rec.attribute_value:= l_period_type_id;
269: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
270: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
271:
272: p_custom_output.Extend();
273: p_custom_output(p_custom_output.count) := l_custom_rec;
266: p_custom_output.EXTEND();
267: l_custom_rec.attribute_name := ':l_period_type_id' ;
268: l_custom_rec.attribute_value:= l_period_type_id;
269: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
270: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
271:
272: p_custom_output.Extend();
273: p_custom_output(p_custom_output.count) := l_custom_rec;
274:
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_max_collect_date' ;
298: l_custom_rec.attribute_value:= l_max_collect_date;
299: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
300: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_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_max_collect_date' ;
298: l_custom_rec.attribute_value:= l_max_collect_date;
299: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
300: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
301:
302: p_custom_output.Extend();
303: p_custom_output(p_custom_output.count) := l_custom_rec;
304:
301:
302: p_custom_output.Extend();
303: p_custom_output(p_custom_output.count) := l_custom_rec;
304:
305: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
306: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
307: l_custom_rec.attribute_value := l_view_by;
308:
309: p_custom_output.EXTEND();
302: p_custom_output.Extend();
303: p_custom_output(p_custom_output.count) := l_custom_rec;
304:
305: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
306: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
307: l_custom_rec.attribute_value := l_view_by;
308:
309: p_custom_output.EXTEND();
310: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
310: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
311:
312: l_custom_rec.attribute_name := ':l_row_type' ;
313: l_custom_rec.attribute_value:= l_row_type;
314: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
315: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
316:
317: p_custom_output.Extend();
318: p_custom_output(p_custom_output.count) := l_custom_rec;
311:
312: l_custom_rec.attribute_name := ':l_row_type' ;
313: l_custom_rec.attribute_value:= l_row_type;
314: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
315: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
316:
317: p_custom_output.Extend();
318: p_custom_output(p_custom_output.count) := l_custom_rec;
319: