35: --Initialize p_custom_output
36: --
37:
38: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
39: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
40:
41: -- Get the parameters
42:
43: BIX_PMV_DBI_UTL_PKG.get_emc_page_params( p_page_parameter_tbl,
261: -- insert Period Type ID bind variable
262:
263: l_custom_rec.attribute_name := ':l_period_type_id' ;
264: l_custom_rec.attribute_value:= 1;
265: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
266: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
267:
268: p_custom_output.Extend();
269: p_custom_output(p_custom_output.count) := l_custom_rec;
262:
263: l_custom_rec.attribute_name := ':l_period_type_id' ;
264: l_custom_rec.attribute_value:= 1;
265: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
266: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
267:
268: p_custom_output.Extend();
269: p_custom_output(p_custom_output.count) := l_custom_rec;
270:
272:
273: IF ( l_account IS NOT NULL) THEN
274: l_custom_rec.attribute_name := ':l_account' ;
275: l_custom_rec.attribute_value:= l_account;
276: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
277: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
278:
279: p_custom_output.Extend();
280: p_custom_output(p_custom_output.count) := l_custom_rec;
273: IF ( l_account IS NOT NULL) THEN
274: l_custom_rec.attribute_name := ':l_account' ;
275: l_custom_rec.attribute_value:= l_account;
276: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
277: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
278:
279: p_custom_output.Extend();
280: p_custom_output(p_custom_output.count) := l_custom_rec;
281: END IF;
283:
284: IF ( l_classification IS NOT NULL) THEN
285: l_custom_rec.attribute_name := ':l_classification' ;
286: l_custom_rec.attribute_value:= l_classification;
287: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
288: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
289:
290: p_custom_output.Extend();
291: p_custom_output(p_custom_output.count) := l_custom_rec;
284: IF ( l_classification IS NOT NULL) THEN
285: l_custom_rec.attribute_name := ':l_classification' ;
286: l_custom_rec.attribute_value:= l_classification;
287: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
288: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
289:
290: p_custom_output.Extend();
291: p_custom_output(p_custom_output.count) := l_custom_rec;
292: END IF;
292: END IF;
293:
294: l_custom_rec.attribute_name := ':l_max_collect_date' ;
295: l_custom_rec.attribute_value:= l_max_collect_date;
296: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
297: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
298:
299: p_custom_output.Extend();
300: p_custom_output(p_custom_output.count) := l_custom_rec;
293:
294: l_custom_rec.attribute_name := ':l_max_collect_date' ;
295: l_custom_rec.attribute_value:= l_max_collect_date;
296: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
297: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
298:
299: p_custom_output.Extend();
300: p_custom_output(p_custom_output.count) := l_custom_rec;
301:
300: p_custom_output(p_custom_output.count) := l_custom_rec;
301:
302: l_custom_rec.attribute_name := ':l_unident_string' ;
303: l_custom_rec.attribute_value:= l_unident_string;
304: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
305: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
306:
307: p_custom_output.Extend();
308: p_custom_output(p_custom_output.count) := l_custom_rec;
301:
302: l_custom_rec.attribute_name := ':l_unident_string' ;
303: l_custom_rec.attribute_value:= l_unident_string;
304: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
305: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
306:
307: p_custom_output.Extend();
308: p_custom_output(p_custom_output.count) := l_custom_rec;
309:
308: p_custom_output(p_custom_output.count) := l_custom_rec;
309:
310: l_custom_rec.attribute_name := ':l_application_id';
311: l_custom_rec.attribute_value:= l_application_id;
312: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
313: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
314:
315: p_custom_output.EXTEND;
316: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
309:
310: l_custom_rec.attribute_name := ':l_application_id';
311: l_custom_rec.attribute_value:= l_application_id;
312: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
313: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
314:
315: p_custom_output.EXTEND;
316: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
317:
316: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
317:
318: l_custom_rec.attribute_name := ':l_row_type' ;
319: l_custom_rec.attribute_value:= l_row_type;
320: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
321: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
322:
323: p_custom_output.Extend();
324: p_custom_output(p_custom_output.count) := l_custom_rec;
317:
318: l_custom_rec.attribute_name := ':l_row_type' ;
319: l_custom_rec.attribute_value:= l_row_type;
320: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
321: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
322:
323: p_custom_output.Extend();
324: p_custom_output(p_custom_output.count) := l_custom_rec;
325: