128: ELSE
129: l_item_cat_flag := 0; -- product
130: END IF;
131:
132: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
133: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
134:
135: IF (l_prod IS NULL OR l_prod = '' OR l_prod = 'All') AND
136: (l_cust IS NULL OR l_cust = '' OR l_cust = 'All')
278: ORDER BY fii.start_date';
279:
280: x_custom_sql := l_stmt;
281:
282: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
283: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
284: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
285: x_custom_output.extend;
286: x_custom_output(1) := l_custom_rec;
280: x_custom_sql := l_stmt;
281:
282: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
283: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
284: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
285: x_custom_output.extend;
286: x_custom_output(1) := l_custom_rec;
287:
288: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
286: x_custom_output(1) := l_custom_rec;
287:
288: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
289: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
290: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;
291: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;
292: x_custom_output.extend;
293: x_custom_output(2) := l_custom_rec;
294:
287:
288: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
289: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
290: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;
291: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;
292: x_custom_output.extend;
293: x_custom_output(2) := l_custom_rec;
294:
295: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
293: x_custom_output(2) := l_custom_rec;
294:
295: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
296: l_custom_rec.attribute_value := to_char(l_cust_flag);
297: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
298: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
299: x_custom_output.extend;
300: x_custom_output(3) := l_custom_rec;
301:
294:
295: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
296: l_custom_rec.attribute_value := to_char(l_cust_flag);
297: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
298: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
299: x_custom_output.extend;
300: x_custom_output(3) := l_custom_rec;
301:
302: END Get_Sql;