32: l_row_type varchar2(10) := 'ACP';
33:
34: BEGIN
35: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
36: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
37:
38: /*
39: l_sqltext := '
40: SELECT
288:
289:
290: l_custom_rec.attribute_name := ':l_period_type_id' ;
291: l_custom_rec.attribute_value:= l_period_type_id;
292: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
293: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
294:
295: p_custom_output.Extend();
296: p_custom_output(p_custom_output.count) := l_custom_rec;
289:
290: l_custom_rec.attribute_name := ':l_period_type_id' ;
291: l_custom_rec.attribute_value:= l_period_type_id;
292: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
293: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
294:
295: p_custom_output.Extend();
296: p_custom_output(p_custom_output.count) := l_custom_rec;
297:
296: p_custom_output(p_custom_output.count) := l_custom_rec;
297:
298: l_custom_rec.attribute_name := ':l_max_collect_date' ;
299: l_custom_rec.attribute_value:= l_max_collect_date;
300: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
301: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
302:
303: p_custom_output.Extend();
304: p_custom_output(p_custom_output.count) := l_custom_rec;
297:
298: l_custom_rec.attribute_name := ':l_max_collect_date' ;
299: l_custom_rec.attribute_value:= l_max_collect_date;
300: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
301: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
302:
303: p_custom_output.Extend();
304: p_custom_output(p_custom_output.count) := l_custom_rec;
305:
305:
306:
307: l_custom_rec.attribute_name := ':l_application_id';
308: l_custom_rec.attribute_value:= l_application_id;
309: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
310: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
311:
312: p_custom_output.EXTEND;
313: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
306:
307: l_custom_rec.attribute_name := ':l_application_id';
308: l_custom_rec.attribute_value:= l_application_id;
309: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
310: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
311:
312: p_custom_output.EXTEND;
313: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
314:
314:
315: IF ( l_account IS NOT NULL) THEN
316: l_custom_rec.attribute_name := ':l_account' ;
317: l_custom_rec.attribute_value:= l_account;
318: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
319: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
320:
321: p_custom_output.Extend();
322: p_custom_output(p_custom_output.count) := l_custom_rec;
315: IF ( l_account IS NOT NULL) THEN
316: l_custom_rec.attribute_name := ':l_account' ;
317: l_custom_rec.attribute_value:= l_account;
318: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
319: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
320:
321: p_custom_output.Extend();
322: p_custom_output(p_custom_output.count) := l_custom_rec;
323: END IF;
324:
325: IF ( l_classification IS NOT NULL) THEN
326: l_custom_rec.attribute_name := ':l_classification' ;
327: l_custom_rec.attribute_value:= l_classification;
328: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
329: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
330:
331: p_custom_output.Extend();
332: p_custom_output(p_custom_output.count) := l_custom_rec;
325: IF ( l_classification IS NOT NULL) THEN
326: l_custom_rec.attribute_name := ':l_classification' ;
327: l_custom_rec.attribute_value:= l_classification;
328: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
329: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
330:
331: p_custom_output.Extend();
332: p_custom_output(p_custom_output.count) := l_custom_rec;
333: END IF;
333: END IF;
334:
335: l_custom_rec.attribute_name := ':l_row_type' ;
336: l_custom_rec.attribute_value:= l_row_type;
337: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
338: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
339:
340: p_custom_output.Extend();
341: p_custom_output(p_custom_output.count) := l_custom_rec;
334:
335: l_custom_rec.attribute_name := ':l_row_type' ;
336: l_custom_rec.attribute_value:= l_row_type;
337: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
338: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
339:
340: p_custom_output.Extend();
341: p_custom_output(p_custom_output.count) := l_custom_rec;
342: