110: ELSE
111: l_item_cat_flag := 0; -- product
112: END IF;
113:
114: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
115: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
116:
117: IF (l_prod IS NULL OR l_prod = '' OR l_prod = 'All') AND
118: (l_cust IS NULL OR l_cust = '' OR l_cust = 'All')
207: ORDER BY fii.start_date';
208:
209: x_custom_sql := l_stmt;
210:
211: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
212: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
213: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
214: x_custom_output.extend;
215: x_custom_output(1) := l_custom_rec;
209: x_custom_sql := l_stmt;
210:
211: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
212: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
213: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
214: x_custom_output.extend;
215: x_custom_output(1) := l_custom_rec;
216:
217: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
215: x_custom_output(1) := l_custom_rec;
216:
217: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
218: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
219: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;
220: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;
221: x_custom_output.extend;
222: x_custom_output(2) := l_custom_rec;
223:
216:
217: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
218: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
219: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;
220: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;
221: x_custom_output.extend;
222: x_custom_output(2) := l_custom_rec;
223:
224: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
222: x_custom_output(2) := l_custom_rec;
223:
224: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
225: l_custom_rec.attribute_value := to_char(l_cust_flag);
226: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
227: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
228: x_custom_output.extend;
229: x_custom_output(3) := l_custom_rec;
230:
223:
224: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
225: l_custom_rec.attribute_value := to_char(l_cust_flag);
226: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
227: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
228: x_custom_output.extend;
229: x_custom_output(3) := l_custom_rec;
230:
231: END Get_Sql;