37: --Initialize p_custom_output
38: --
39:
40: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
41: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
42:
43: -- Get the parameters
44:
45: BIX_PMV_DBI_UTL_PKG.get_emc_page_params( p_page_parameter_tbl,
199: -- insert Period Type ID bind variable
200:
201: l_custom_rec.attribute_name := ':l_period_type_id' ;
202: l_custom_rec.attribute_value:= 1;
203: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
204: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
205:
206: p_custom_output.Extend();
207: p_custom_output(p_custom_output.count) := l_custom_rec;
200:
201: l_custom_rec.attribute_name := ':l_period_type_id' ;
202: l_custom_rec.attribute_value:= 1;
203: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
204: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
205:
206: p_custom_output.Extend();
207: p_custom_output(p_custom_output.count) := l_custom_rec;
208:
207: p_custom_output(p_custom_output.count) := l_custom_rec;
208:
209: l_custom_rec.attribute_name := ':l_outcome_filter' ;
210: l_custom_rec.attribute_value:= l_outcome_filter;
211: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
212: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
213:
214: p_custom_output.Extend();
215: p_custom_output(p_custom_output.count) := l_custom_rec;
208:
209: l_custom_rec.attribute_name := ':l_outcome_filter' ;
210: l_custom_rec.attribute_value:= l_outcome_filter;
211: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
212: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
213:
214: p_custom_output.Extend();
215: p_custom_output(p_custom_output.count) := l_custom_rec;
216:
218:
219: IF ( l_account IS NOT NULL) THEN
220: l_custom_rec.attribute_name := ':l_account' ;
221: l_custom_rec.attribute_value:= l_account;
222: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
223: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
224:
225: p_custom_output.Extend();
226: p_custom_output(p_custom_output.count) := l_custom_rec;
219: IF ( l_account IS NOT NULL) THEN
220: l_custom_rec.attribute_name := ':l_account' ;
221: l_custom_rec.attribute_value:= l_account;
222: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
223: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
224:
225: p_custom_output.Extend();
226: p_custom_output(p_custom_output.count) := l_custom_rec;
227: END IF;
229:
230: IF ( l_classification IS NOT NULL) THEN
231: l_custom_rec.attribute_name := ':l_classification' ;
232: l_custom_rec.attribute_value:= l_classification;
233: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
234: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
235:
236: p_custom_output.Extend();
237: p_custom_output(p_custom_output.count) := l_custom_rec;
230: IF ( l_classification IS NOT NULL) THEN
231: l_custom_rec.attribute_name := ':l_classification' ;
232: l_custom_rec.attribute_value:= l_classification;
233: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
234: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
235:
236: p_custom_output.Extend();
237: p_custom_output(p_custom_output.count) := l_custom_rec;
238: END IF;
238: END IF;
239:
240: l_custom_rec.attribute_name := ':l_row_type' ;
241: l_custom_rec.attribute_value:= l_row_type;
242: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
243: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
244:
245: p_custom_output.Extend();
246: p_custom_output(p_custom_output.count) := l_custom_rec;
239:
240: l_custom_rec.attribute_name := ':l_row_type' ;
241: l_custom_rec.attribute_value:= l_row_type;
242: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
243: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
244:
245: p_custom_output.Extend();
246: p_custom_output(p_custom_output.count) := l_custom_rec;
247:
247:
248:
249: l_custom_rec.attribute_name := ':l_subtotal' ;
250: l_custom_rec.attribute_value:= l_subtotal;
251: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
252: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
253:
254: p_custom_output.Extend();
255: p_custom_output(p_custom_output.count) := l_custom_rec;
248:
249: l_custom_rec.attribute_name := ':l_subtotal' ;
250: l_custom_rec.attribute_value:= l_subtotal;
251: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
252: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
253:
254: p_custom_output.Extend();
255: p_custom_output(p_custom_output.count) := l_custom_rec;
256:
256:
257:
258: l_custom_rec.attribute_name := ':l_unknown' ;
259: l_custom_rec.attribute_value:= l_unknown;
260: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
261: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
262:
263: p_custom_output.Extend();
264: p_custom_output(p_custom_output.count) := l_custom_rec;
257:
258: l_custom_rec.attribute_name := ':l_unknown' ;
259: l_custom_rec.attribute_value:= l_unknown;
260: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
261: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
262:
263: p_custom_output.Extend();
264: p_custom_output(p_custom_output.count) := l_custom_rec;
265:
265:
266:
267: l_custom_rec.attribute_name := ':l_space' ;
268: l_custom_rec.attribute_value:= ' ';
269: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
270: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
271:
272: p_custom_output.Extend();
273: p_custom_output(p_custom_output.count) := l_custom_rec;
266:
267: l_custom_rec.attribute_name := ':l_space' ;
268: l_custom_rec.attribute_value:= ' ';
269: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
270: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
271:
272: p_custom_output.Extend();
273: p_custom_output(p_custom_output.count) := l_custom_rec;
274: