34: --Initialize p_custom_output
35: --
36:
37: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
38: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
39:
40: -- Get the parameters
41:
42: BIX_PMV_DBI_UTL_PKG.get_emc_page_params( p_page_parameter_tbl,
269: -- insert Period Type ID bind variable
270:
271: l_custom_rec.attribute_name := ':l_period_type_id' ;
272: l_custom_rec.attribute_value:= l_period_type_id;
273: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
274: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
275:
276: p_custom_output.Extend();
277: p_custom_output(p_custom_output.count) := l_custom_rec;
270:
271: l_custom_rec.attribute_name := ':l_period_type_id' ;
272: l_custom_rec.attribute_value:= l_period_type_id;
273: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
274: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
275:
276: p_custom_output.Extend();
277: p_custom_output(p_custom_output.count) := l_custom_rec;
278:
280:
281: IF ( l_account IS NOT NULL) THEN
282: l_custom_rec.attribute_name := ':l_account' ;
283: l_custom_rec.attribute_value:= l_account;
284: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
285: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
286:
287: p_custom_output.Extend();
288: p_custom_output(p_custom_output.count) := l_custom_rec;
281: IF ( l_account IS NOT NULL) THEN
282: l_custom_rec.attribute_name := ':l_account' ;
283: l_custom_rec.attribute_value:= l_account;
284: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
285: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
286:
287: p_custom_output.Extend();
288: p_custom_output(p_custom_output.count) := l_custom_rec;
289: END IF;
290:
291: IF ( l_classification IS NOT NULL) THEN
292: l_custom_rec.attribute_name := ':l_classification' ;
293: l_custom_rec.attribute_value:= l_classification;
294: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
295: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
296:
297: p_custom_output.Extend();
298: p_custom_output(p_custom_output.count) := l_custom_rec;
291: IF ( l_classification IS NOT NULL) THEN
292: l_custom_rec.attribute_name := ':l_classification' ;
293: l_custom_rec.attribute_value:= l_classification;
294: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
295: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
296:
297: p_custom_output.Extend();
298: p_custom_output(p_custom_output.count) := l_custom_rec;
299: END IF;
299: END IF;
300:
301: l_custom_rec.attribute_name := ':l_max_collect_date' ;
302: l_custom_rec.attribute_value:= l_max_collect_date;
303: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
304: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
305:
306: p_custom_output.Extend();
307: p_custom_output(p_custom_output.count) := l_custom_rec;
300:
301: l_custom_rec.attribute_name := ':l_max_collect_date' ;
302: l_custom_rec.attribute_value:= l_max_collect_date;
303: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
304: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
305:
306: p_custom_output.Extend();
307: p_custom_output(p_custom_output.count) := l_custom_rec;
308:
307: p_custom_output(p_custom_output.count) := l_custom_rec;
308:
309: l_custom_rec.attribute_name := ':l_application_id';
310: l_custom_rec.attribute_value:= l_application_id;
311: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
312: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
313:
314: p_custom_output.EXTEND;
315: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
308:
309: l_custom_rec.attribute_name := ':l_application_id';
310: l_custom_rec.attribute_value:= l_application_id;
311: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
312: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
313:
314: p_custom_output.EXTEND;
315: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
316:
313:
314: p_custom_output.EXTEND;
315: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
316:
317: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
318: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
319: l_custom_rec.attribute_value := l_view_by;
320:
321: p_custom_output.EXTEND();
314: p_custom_output.EXTEND;
315: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
316:
317: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
318: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
319: l_custom_rec.attribute_value := l_view_by;
320:
321: p_custom_output.EXTEND();
322: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
322: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
323:
324: l_custom_rec.attribute_name := ':l_row_type' ;
325: l_custom_rec.attribute_value:= l_row_type;
326: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
327: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
328:
329: p_custom_output.Extend();
330: p_custom_output(p_custom_output.count) := l_custom_rec;
323:
324: l_custom_rec.attribute_name := ':l_row_type' ;
325: l_custom_rec.attribute_value:= l_row_type;
326: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
327: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
328:
329: p_custom_output.Extend();
330: p_custom_output(p_custom_output.count) := l_custom_rec;
331: