225: ' || l_where_clause;
226:
227:
228: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
229: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
230: x_custom_output.extend;
231:
232: l_custom_rec.attribute_name := ':ITEM+ENI_ITEM';
233: l_custom_rec.attribute_value := 5;
230: x_custom_output.extend;
231:
232: l_custom_rec.attribute_name := ':ITEM+ENI_ITEM';
233: l_custom_rec.attribute_value := 5;
234: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
235: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
236: x_custom_output.extend;
237: x_custom_output(1) := l_custom_rec;
238:
231:
232: l_custom_rec.attribute_name := ':ITEM+ENI_ITEM';
233: l_custom_rec.attribute_value := 5;
234: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
235: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
236: x_custom_output.extend;
237: x_custom_output(1) := l_custom_rec;
238:
239: -- Start Bug 5083911
239: -- Start Bug 5083911
240: x_custom_output.extend;
241: l_custom_rec.attribute_name := ':CATEGORY';
242: l_custom_rec.attribute_value :=replace(l_category,'''');
243: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
244: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
245: x_custom_output(2) := l_custom_rec;
246:
247: x_custom_output.extend;
240: x_custom_output.extend;
241: l_custom_rec.attribute_name := ':CATEGORY';
242: l_custom_rec.attribute_value :=replace(l_category,'''');
243: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
244: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
245: x_custom_output(2) := l_custom_rec;
246:
247: x_custom_output.extend;
248: l_custom_rec.attribute_name := ':PERIODAND'; --Bug 5083652
246:
247: x_custom_output.extend;
248: l_custom_rec.attribute_name := ':PERIODAND'; --Bug 5083652
249: l_custom_rec.attribute_value := replace(l_period_bitand,'''');
250: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
251: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
252: x_custom_output(3) := l_custom_rec;
253:
254: -- End Bug 5083911
247: x_custom_output.extend;
248: l_custom_rec.attribute_name := ':PERIODAND'; --Bug 5083652
249: l_custom_rec.attribute_value := replace(l_period_bitand,'''');
250: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
251: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
252: x_custom_output(3) := l_custom_rec;
253:
254: -- End Bug 5083911
255:
257:
258: x_custom_output.extend;
259: l_custom_rec.attribute_name := ':PERIODTYPE';
260: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
261: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
262: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
263: x_custom_output(8) := l_custom_rec;
264:
265: x_custom_output.extend;
258: x_custom_output.extend;
259: l_custom_rec.attribute_name := ':PERIODTYPE';
260: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
261: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
262: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
263: x_custom_output(8) := l_custom_rec;
264:
265: x_custom_output.extend;
266: l_custom_rec.attribute_name := ':COMPARETYPE';
264:
265: x_custom_output.extend;
266: l_custom_rec.attribute_name := ':COMPARETYPE';
267: l_custom_rec.attribute_value := REPLACE(l_comp_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(9) := l_custom_rec;
271:
272: x_custom_output.extend;
265: x_custom_output.extend;
266: l_custom_rec.attribute_name := ':COMPARETYPE';
267: l_custom_rec.attribute_value := REPLACE(l_comp_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(9) := l_custom_rec;
271:
272: x_custom_output.extend;
273: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
271:
272: x_custom_output.extend;
273: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
274: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
275: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
276: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
277: x_custom_output(11) := l_custom_rec;
278:
279: --Bug 5083652 -- End Code
272: x_custom_output.extend;
273: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
274: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
275: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
276: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
277: x_custom_output(11) := l_custom_rec;
278:
279: --Bug 5083652 -- End Code
280: