153: ELSE l_item_cat_flag := 0; -- Product Category
154: END IF;
155:
156:
157: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
158: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
159:
160: IF (l_invalid_curr)
161: THEN l_stmt := '
318: END IF;
319:
320: x_custom_sql := l_stmt;
321:
322: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
323: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
324: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
325: x_custom_output.extend;
326: x_custom_output(1) := l_custom_rec;
320: x_custom_sql := l_stmt;
321:
322: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
323: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
324: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
325: x_custom_output.extend;
326: x_custom_output(1) := l_custom_rec;
327:
328: l_custom_rec.attribute_name := ':ISC_CUST';
326: x_custom_output(1) := l_custom_rec;
327:
328: l_custom_rec.attribute_name := ':ISC_CUST';
329: l_custom_rec.attribute_value := l_cust_flag;
330: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
331: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
332: x_custom_output.EXTEND;
333: x_custom_output(2) := l_custom_rec;
334:
327:
328: l_custom_rec.attribute_name := ':ISC_CUST';
329: l_custom_rec.attribute_value := l_cust_flag;
330: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
331: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
332: x_custom_output.EXTEND;
333: x_custom_output(2) := l_custom_rec;
334:
335: l_custom_rec.attribute_name := ':ISC_SG';
333: x_custom_output(2) := l_custom_rec;
334:
335: l_custom_rec.attribute_name := ':ISC_SG';
336: l_custom_rec.attribute_value := to_char(l_sg_sg);
337: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
338: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
339: x_custom_output.extend;
340: x_custom_output(3) := l_custom_rec;
341:
334:
335: l_custom_rec.attribute_name := ':ISC_SG';
336: l_custom_rec.attribute_value := to_char(l_sg_sg);
337: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
338: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
339: x_custom_output.extend;
340: x_custom_output(3) := l_custom_rec;
341:
342: l_custom_rec.attribute_name := ':ISC_RES';
340: x_custom_output(3) := l_custom_rec;
341:
342: l_custom_rec.attribute_name := ':ISC_RES';
343: l_custom_rec.attribute_value := to_char(l_sg_res);
344: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
345: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
346: x_custom_output.extend;
347: x_custom_output(4) := l_custom_rec;
348:
341:
342: l_custom_rec.attribute_name := ':ISC_RES';
343: l_custom_rec.attribute_value := to_char(l_sg_res);
344: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
345: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
346: x_custom_output.extend;
347: x_custom_output(4) := l_custom_rec;
348:
349: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
347: x_custom_output(4) := l_custom_rec;
348:
349: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
350: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
351: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
352: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
353: x_custom_output.extend;
354: x_custom_output(5) := l_custom_rec;
355:
348:
349: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
350: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
351: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
352: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
353: x_custom_output.extend;
354: x_custom_output(5) := l_custom_rec;
355:
356: END get_sql;