75: l_vb_prod := (l_view_by = 'ITEM+ENI_ITEM' );
76: l_vb_cust := (l_view_by = 'CUSTOMER+FII_CUSTOMERS' );
77: l_vb_org := (l_view_by = 'ORGANIZATION+ORGANIZATION');
78:
79: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
80: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
81:
82: l_measures := '
83: , ENI_MEASURE1, ENI_MEASURE2, ENI_MEASURE3, ENI_MEASURE4, ENI_MEASURE5
427: x_custom_sql := l_stmt;
428:
429: l_custom_rec.attribute_name := ':ENI_ITEM_CAT_FLAG';
430: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
431: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
432: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
433: x_custom_output.EXTEND;
434: x_custom_output(1) := l_custom_rec;
435:
428:
429: l_custom_rec.attribute_name := ':ENI_ITEM_CAT_FLAG';
430: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
431: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
432: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
433: x_custom_output.EXTEND;
434: x_custom_output(1) := l_custom_rec;
435:
436: l_custom_rec.attribute_name := ':ENI_CUST_FLAG';
434: x_custom_output(1) := l_custom_rec;
435:
436: l_custom_rec.attribute_name := ':ENI_CUST_FLAG';
437: l_custom_rec.attribute_value := to_char(l_cust_flag);
438: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
439: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
440: x_custom_output.EXTEND;
441: x_custom_output(2) := l_custom_rec;
442:
435:
436: l_custom_rec.attribute_name := ':ENI_CUST_FLAG';
437: l_custom_rec.attribute_value := to_char(l_cust_flag);
438: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
439: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
440: x_custom_output.EXTEND;
441: x_custom_output(2) := l_custom_rec;
442:
443: l_custom_rec.attribute_name := ':ENI_LANG';
441: x_custom_output(2) := l_custom_rec;
442:
443: l_custom_rec.attribute_name := ':ENI_LANG';
444: l_custom_rec.attribute_value := l_lang;
445: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
446: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
447: x_custom_output.EXTEND;
448: x_custom_output(3) := l_custom_rec;
449:
442:
443: l_custom_rec.attribute_name := ':ENI_LANG';
444: l_custom_rec.attribute_value := l_lang;
445: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
446: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
447: x_custom_output.EXTEND;
448: x_custom_output(3) := l_custom_rec;
449:
450: END Get_Sql;