129: ELSE
130: l_item_cat_flag := 0; -- product
131: END IF;
132:
133: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
134: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
135:
136: IF ((l_prod IS NULL OR l_prod = 'All') AND
137: (l_cust IS NULL OR l_cust = 'All'))
218: ORDER BY fii.start_date';
219:
220: x_custom_sql := l_stmt;
221:
222: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
223: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
224: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
225: x_custom_output.extend;
226: x_custom_output(1) := l_custom_rec;
220: x_custom_sql := l_stmt;
221:
222: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
223: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
224: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
225: x_custom_output.extend;
226: x_custom_output(1) := l_custom_rec;
227:
228: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
226: x_custom_output(1) := l_custom_rec;
227:
228: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
229: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
230: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;
231: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;
232: x_custom_output.extend;
233: x_custom_output(2) := l_custom_rec;
234:
227:
228: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
229: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
230: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;
231: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;
232: x_custom_output.extend;
233: x_custom_output(2) := l_custom_rec;
234:
235: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
233: x_custom_output(2) := l_custom_rec;
234:
235: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
236: l_custom_rec.attribute_value := to_char(l_cust_flag);
237: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
238: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
239: x_custom_output.extend;
240: x_custom_output(3) := l_custom_rec;
241:
234:
235: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
236: l_custom_rec.attribute_value := to_char(l_cust_flag);
237: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
238: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
239: x_custom_output.extend;
240: x_custom_output(3) := l_custom_rec;
241:
242: END Get_Sql;