110: ELSE
111: l_item_cat_flag := 0; -- product
112: END IF;
113:
114: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
115: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
116:
117: IF (l_prod IS NULL OR l_prod = '' OR l_prod = 'All') AND
118: (l_cust IS NULL OR l_cust = '' OR l_cust = 'All')
176: ORDER BY fii.start_date';
177:
178: x_custom_sql := l_stmt;
179:
180: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
181: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
182: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
183: x_custom_output.extend;
184: x_custom_output(1) := l_custom_rec;
178: x_custom_sql := l_stmt;
179:
180: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.View_By_Value;
181: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
182: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
183: x_custom_output.extend;
184: x_custom_output(1) := l_custom_rec;
185:
186: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
184: x_custom_output(1) := l_custom_rec;
185:
186: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
187: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
188: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;
189: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;
190: x_custom_output.extend;
191: x_custom_output(2) := l_custom_rec;
192:
185:
186: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
187: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
188: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.Bind_Type;
189: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.Integer_Bind;
190: x_custom_output.extend;
191: x_custom_output(2) := l_custom_rec;
192:
193: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
191: x_custom_output(2) := l_custom_rec;
192:
193: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
194: l_custom_rec.attribute_value := to_char(l_cust_flag);
195: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
196: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
197: x_custom_output.extend;
198: x_custom_output(3) := l_custom_rec;
199:
192:
193: l_custom_rec.attribute_name := ':ISC_CUST_FLAG';
194: l_custom_rec.attribute_value := to_char(l_cust_flag);
195: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
196: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
197: x_custom_output.extend;
198: x_custom_output(3) := l_custom_rec;
199:
200: END Get_Sql;