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,
371:
372: p_custom_output.EXTEND();
373: l_custom_rec.attribute_name := ':l_period_type_id' ;
374: l_custom_rec.attribute_value:= l_period_type_id;
375: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
376: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
377:
378: p_custom_output.Extend();
379: p_custom_output(p_custom_output.count) := l_custom_rec;
372: p_custom_output.EXTEND();
373: l_custom_rec.attribute_name := ':l_period_type_id' ;
374: l_custom_rec.attribute_value:= l_period_type_id;
375: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
376: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
377:
378: p_custom_output.Extend();
379: p_custom_output(p_custom_output.count) := l_custom_rec;
380:
382:
383: IF ( l_account IS NOT NULL) THEN
384: l_custom_rec.attribute_name := ':l_account' ;
385: l_custom_rec.attribute_value:= l_account;
386: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
387: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
388:
389: p_custom_output.Extend();
390: p_custom_output(p_custom_output.count) := l_custom_rec;
383: IF ( l_account IS NOT NULL) THEN
384: l_custom_rec.attribute_name := ':l_account' ;
385: l_custom_rec.attribute_value:= l_account;
386: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
387: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
388:
389: p_custom_output.Extend();
390: p_custom_output(p_custom_output.count) := l_custom_rec;
391: END IF;
392:
393: IF ( l_classification IS NOT NULL) THEN
394: l_custom_rec.attribute_name := ':l_classification' ;
395: l_custom_rec.attribute_value:= l_classification;
396: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
397: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
398:
399: p_custom_output.Extend();
400: p_custom_output(p_custom_output.count) := l_custom_rec;
393: IF ( l_classification IS NOT NULL) THEN
394: l_custom_rec.attribute_name := ':l_classification' ;
395: l_custom_rec.attribute_value:= l_classification;
396: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
397: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
398:
399: p_custom_output.Extend();
400: p_custom_output(p_custom_output.count) := l_custom_rec;
401: END IF;
401: END IF;
402:
403: l_custom_rec.attribute_name := ':l_max_collect_date' ;
404: l_custom_rec.attribute_value:= l_max_collect_date;
405: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
406: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
407:
408: p_custom_output.Extend();
409: p_custom_output(p_custom_output.count) := l_custom_rec;
402:
403: l_custom_rec.attribute_name := ':l_max_collect_date' ;
404: l_custom_rec.attribute_value:= l_max_collect_date;
405: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
406: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
407:
408: p_custom_output.Extend();
409: p_custom_output(p_custom_output.count) := l_custom_rec;
410:
407:
408: p_custom_output.Extend();
409: p_custom_output(p_custom_output.count) := l_custom_rec;
410:
411: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
412: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
413: l_custom_rec.attribute_value := l_view_by;
414:
415: p_custom_output.EXTEND();
408: p_custom_output.Extend();
409: p_custom_output(p_custom_output.count) := l_custom_rec;
410:
411: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
412: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
413: l_custom_rec.attribute_value := l_view_by;
414:
415: p_custom_output.EXTEND();
416: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
416: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
417:
418: l_custom_rec.attribute_name := ':l_row_type' ;
419: l_custom_rec.attribute_value:= l_row_type;
420: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
421: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
422:
423: p_custom_output.Extend();
424: p_custom_output(p_custom_output.count) := l_custom_rec;
417:
418: l_custom_rec.attribute_name := ':l_row_type' ;
419: l_custom_rec.attribute_value:= l_row_type;
420: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
421: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
422:
423: p_custom_output.Extend();
424: p_custom_output(p_custom_output.count) := l_custom_rec;
425: