249: ORDER BY
250: ' || l_order_by;
251:
252: --Bug 5083699 : Added Bind Parameter for CategoryId
253: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
254: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
255:
256: l_custom_rec.attribute_name := ':CATEGORY_ID';
257: l_custom_rec.attribute_value := replace(l_category,'''');
254: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
255:
256: l_custom_rec.attribute_name := ':CATEGORY_ID';
257: l_custom_rec.attribute_value := replace(l_category,'''');
258: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
259: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
260: x_custom_output.extend;
261: x_custom_output(1) := l_custom_rec;
262:
255:
256: l_custom_rec.attribute_name := ':CATEGORY_ID';
257: l_custom_rec.attribute_value := replace(l_category,'''');
258: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
259: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
260: x_custom_output.extend;
261: x_custom_output(1) := l_custom_rec;
262:
263: --Bug 5083652 -- Start Code
264:
265: x_custom_output.extend;
266: l_custom_rec.attribute_name := ':PERIODTYPE';
267: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
268: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
269: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
270: x_custom_output(2) := l_custom_rec;
271:
272: x_custom_output.extend;
265: x_custom_output.extend;
266: l_custom_rec.attribute_name := ':PERIODTYPE';
267: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
268: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
269: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
270: x_custom_output(2) := l_custom_rec;
271:
272: x_custom_output.extend;
273: l_custom_rec.attribute_name := ':COMPARETYPE';
271:
272: x_custom_output.extend;
273: l_custom_rec.attribute_name := ':COMPARETYPE';
274: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
275: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
276: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
277: x_custom_output(3) := l_custom_rec;
278:
279:
272: x_custom_output.extend;
273: l_custom_rec.attribute_name := ':COMPARETYPE';
274: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
275: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
276: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
277: x_custom_output(3) := l_custom_rec;
278:
279:
280: x_custom_output.extend;
279:
280: x_custom_output.extend;
281: l_custom_rec.attribute_name := ':PERIODAND';
282: l_custom_rec.attribute_value := REPLACE(l_period_bitand,'''');
283: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
284: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
285: x_custom_output(4) := l_custom_rec;
286:
287: x_custom_output.extend;
280: x_custom_output.extend;
281: l_custom_rec.attribute_name := ':PERIODAND';
282: l_custom_rec.attribute_value := REPLACE(l_period_bitand,'''');
283: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
284: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
285: x_custom_output(4) := l_custom_rec;
286:
287: x_custom_output.extend;
288: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
286:
287: x_custom_output.extend;
288: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
289: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
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(5) := l_custom_rec;
293:
294: --Bug 5083652 -- End Code
287: x_custom_output.extend;
288: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
289: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
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(5) := l_custom_rec;
293:
294: --Bug 5083652 -- End Code
295: END get_sql;