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')
280: ORDER BY fii.start_date';
281:
282: x_custom_sql := l_stmt;
283:
284: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
285: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
286: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
287: x_custom_output.extend;
288: x_custom_output(1) := l_custom_rec;
282: x_custom_sql := l_stmt;
283:
284: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
285: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
286: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
287: x_custom_output.extend;
288: x_custom_output(1) := l_custom_rec;
289:
290: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
288: x_custom_output(1) := l_custom_rec;
289:
290: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
291: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
292: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;
293: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;
294: x_custom_output.extend;
295: x_custom_output(2) := l_custom_rec;
296:
289:
290: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
291: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
292: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;
293: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;
294: x_custom_output.extend;
295: x_custom_output(2) := l_custom_rec;
296:
297: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
295: x_custom_output(2) := l_custom_rec;
296:
297: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
298: l_custom_rec.attribute_value := to_char(l_cust_flag);
299: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
300: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
301: x_custom_output.extend;
302: x_custom_output(3) := l_custom_rec;
303:
296:
297: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
298: l_custom_rec.attribute_value := to_char(l_cust_flag);
299: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
300: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
301: x_custom_output.extend;
302: x_custom_output(3) := l_custom_rec;
303:
304: END Get_Sql;