96: END;
97:
98: -- Eventually get this string from the util package
99:
100: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
101: x_custom_output := bis_query_attributes_tbl();
102:
103: if ((l_org IS NULL OR l_org = '' OR l_org = 'All') or (l_item IS NULL OR l_item = '' OR l_item = 'All')) then
104: l_sql_stmt := 'select null VIEWBY,
190:
191: end if;
192:
193: x_custom_sql := l_sql_stmt;
194: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
195: x_custom_output := bis_query_attributes_tbl();
196:
197: x_custom_output.extend;
198: l_custom_rec.attribute_name := ':l_item';
196:
197: x_custom_output.extend;
198: l_custom_rec.attribute_name := ':l_item';
199: l_custom_rec.attribute_value := replace(l_item,'''');
200: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
201: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
202: x_custom_output(1) := l_custom_rec;
203:
204: x_custom_output.extend;
197: x_custom_output.extend;
198: l_custom_rec.attribute_name := ':l_item';
199: l_custom_rec.attribute_value := replace(l_item,'''');
200: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
201: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
202: x_custom_output(1) := l_custom_rec;
203:
204: x_custom_output.extend;
205: l_custom_rec.attribute_name := ':l_org';
203:
204: x_custom_output.extend;
205: l_custom_rec.attribute_name := ':l_org';
206: l_custom_rec.attribute_value := replace(l_org,'''');
207: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
208: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
209: x_custom_output(2) := l_custom_rec;
210:
211: x_custom_output.extend;
204: x_custom_output.extend;
205: l_custom_rec.attribute_name := ':l_org';
206: l_custom_rec.attribute_value := replace(l_org,'''');
207: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
208: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
209: x_custom_output(2) := l_custom_rec;
210:
211: x_custom_output.extend;
212: l_custom_rec.attribute_name := ':l_period_type';
210:
211: x_custom_output.extend;
212: l_custom_rec.attribute_name := ':l_period_type';
213: l_custom_rec.attribute_value := replace(l_period_type,'''');
214: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
215: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
216: x_custom_output(3) := l_custom_rec;
217:
218: x_custom_output.extend;
211: x_custom_output.extend;
212: l_custom_rec.attribute_name := ':l_period_type';
213: l_custom_rec.attribute_value := replace(l_period_type,'''');
214: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
215: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
216: x_custom_output(3) := l_custom_rec;
217:
218: x_custom_output.extend;
219: l_custom_rec.attribute_name := ':l_comp_type';
217:
218: x_custom_output.extend;
219: l_custom_rec.attribute_name := ':l_comp_type';
220: l_custom_rec.attribute_value := replace(l_comp_type,'''');
221: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
222: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
223: x_custom_output(4) := l_custom_rec;
224:
225: END get_sql;
218: x_custom_output.extend;
219: l_custom_rec.attribute_name := ':l_comp_type';
220: l_custom_rec.attribute_value := replace(l_comp_type,'''');
221: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
222: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
223: x_custom_output(4) := l_custom_rec;
224:
225: END get_sql;
226: