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,
390:
391: IF ( l_account IS NOT NULL) THEN
392: l_custom_rec.attribute_name := ':l_account' ;
393: l_custom_rec.attribute_value:= l_account;
394: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
395: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
396:
397: p_custom_output.Extend();
398: p_custom_output(p_custom_output.count) := l_custom_rec;
391: IF ( l_account IS NOT NULL) THEN
392: l_custom_rec.attribute_name := ':l_account' ;
393: l_custom_rec.attribute_value:= l_account;
394: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
395: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
396:
397: p_custom_output.Extend();
398: p_custom_output(p_custom_output.count) := l_custom_rec;
399: END IF;
400:
401: IF ( l_classification IS NOT NULL) THEN
402: l_custom_rec.attribute_name := ':l_classification' ;
403: l_custom_rec.attribute_value:= l_classification;
404: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
405: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
406:
407: p_custom_output.Extend();
408: p_custom_output(p_custom_output.count) := l_custom_rec;
401: IF ( l_classification IS NOT NULL) THEN
402: l_custom_rec.attribute_name := ':l_classification' ;
403: l_custom_rec.attribute_value:= l_classification;
404: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
405: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
406:
407: p_custom_output.Extend();
408: p_custom_output(p_custom_output.count) := l_custom_rec;
409: END IF;
409: END IF;
410:
411: l_custom_rec.attribute_name := ':l_application_id';
412: l_custom_rec.attribute_value:= l_application_id;
413: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
414: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
415:
416: p_custom_output.EXTEND;
417: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
410:
411: l_custom_rec.attribute_name := ':l_application_id';
412: l_custom_rec.attribute_value:= l_application_id;
413: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
414: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
415:
416: p_custom_output.EXTEND;
417: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
418:
415:
416: p_custom_output.EXTEND;
417: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
418:
419: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
420: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
421: l_custom_rec.attribute_value := l_view_by;
422:
423: p_custom_output.EXTEND();
416: p_custom_output.EXTEND;
417: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
418:
419: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
420: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
421: l_custom_rec.attribute_value := l_view_by;
422:
423: p_custom_output.EXTEND();
424: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
424: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
425:
426: l_custom_rec.attribute_name := ':l_row_type' ;
427: l_custom_rec.attribute_value:= l_row_type;
428: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
429: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
430:
431: p_custom_output.Extend();
432: p_custom_output(p_custom_output.count) := l_custom_rec;
425:
426: l_custom_rec.attribute_name := ':l_row_type' ;
427: l_custom_rec.attribute_value:= l_row_type;
428: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
429: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
430:
431: p_custom_output.Extend();
432: p_custom_output(p_custom_output.count) := l_custom_rec;
433: