150: THEN l_item_cat_flag := 1; -- All
151: ELSE l_item_cat_flag := 0; -- Product Category
152: END IF;
153:
154: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
155: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
156:
157: IF (l_invalid_curr)
158: THEN l_stmt := '
237: END IF;
238:
239: x_custom_sql := l_stmt;
240:
241: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
242: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
243: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
244: x_custom_output.extend;
245: x_custom_output(1) := l_custom_rec;
239: x_custom_sql := l_stmt;
240:
241: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
242: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
243: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
244: x_custom_output.extend;
245: x_custom_output(1) := l_custom_rec;
246:
247: l_custom_rec.attribute_name := ':ISC_CUST';
245: x_custom_output(1) := l_custom_rec;
246:
247: l_custom_rec.attribute_name := ':ISC_CUST';
248: l_custom_rec.attribute_value := l_cust_flag;
249: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
250: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
251: x_custom_output.EXTEND;
252: x_custom_output(2) := l_custom_rec;
253:
246:
247: l_custom_rec.attribute_name := ':ISC_CUST';
248: l_custom_rec.attribute_value := l_cust_flag;
249: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
250: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
251: x_custom_output.EXTEND;
252: x_custom_output(2) := l_custom_rec;
253:
254: l_custom_rec.attribute_name := ':ISC_SG';
252: x_custom_output(2) := l_custom_rec;
253:
254: l_custom_rec.attribute_name := ':ISC_SG';
255: l_custom_rec.attribute_value := to_char(l_sg_sg);
256: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
257: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
258: x_custom_output.extend;
259: x_custom_output(3) := l_custom_rec;
260:
253:
254: l_custom_rec.attribute_name := ':ISC_SG';
255: l_custom_rec.attribute_value := to_char(l_sg_sg);
256: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
257: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
258: x_custom_output.extend;
259: x_custom_output(3) := l_custom_rec;
260:
261: l_custom_rec.attribute_name := ':ISC_RES';
259: x_custom_output(3) := l_custom_rec;
260:
261: l_custom_rec.attribute_name := ':ISC_RES';
262: l_custom_rec.attribute_value := to_char(l_sg_res);
263: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
264: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
265: x_custom_output.extend;
266: x_custom_output(4) := l_custom_rec;
267:
260:
261: l_custom_rec.attribute_name := ':ISC_RES';
262: l_custom_rec.attribute_value := to_char(l_sg_res);
263: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
264: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
265: x_custom_output.extend;
266: x_custom_output(4) := l_custom_rec;
267:
268: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
266: x_custom_output(4) := l_custom_rec;
267:
268: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
269: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
270: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
271: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
272: x_custom_output.extend;
273: x_custom_output(5) := l_custom_rec;
274:
267:
268: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
269: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
270: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
271: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
272: x_custom_output.extend;
273: x_custom_output(5) := l_custom_rec;
274:
275: END get_sql;