376: avg4_cnt
377: ORDER BY
378: ' || l_order_by;
379:
380: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
381: x_custom_output := bis_query_attributes_tbl();
382:
383: x_custom_output.extend;
384: l_custom_rec.attribute_name := ':ITEM';
382:
383: x_custom_output.extend;
384: l_custom_rec.attribute_name := ':ITEM';
385: l_custom_rec.attribute_value := l_item;
386: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
387: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
388: x_custom_output(1) := l_custom_rec;
389:
390: x_custom_output.extend;
383: x_custom_output.extend;
384: l_custom_rec.attribute_name := ':ITEM';
385: l_custom_rec.attribute_value := l_item;
386: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
387: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
388: x_custom_output(1) := l_custom_rec;
389:
390: x_custom_output.extend;
391: l_custom_rec.attribute_name := ':ORG';
389:
390: x_custom_output.extend;
391: l_custom_rec.attribute_name := ':ORG';
392: l_custom_rec.attribute_value :=replace(l_org,'''');
393: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
394: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
395: x_custom_output(2) := l_custom_rec;
396:
397: x_custom_output.extend;
390: x_custom_output.extend;
391: l_custom_rec.attribute_name := ':ORG';
392: l_custom_rec.attribute_value :=replace(l_org,'''');
393: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
394: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
395: x_custom_output(2) := l_custom_rec;
396:
397: x_custom_output.extend;
398: l_custom_rec.attribute_name := ':REASON';
396:
397: x_custom_output.extend;
398: l_custom_rec.attribute_name := ':REASON';
399: l_custom_rec.attribute_value := l_reason;
400: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
401: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
402: x_custom_output(3) := l_custom_rec;
403:
404: x_custom_output.extend;
397: x_custom_output.extend;
398: l_custom_rec.attribute_name := ':REASON';
399: l_custom_rec.attribute_value := l_reason;
400: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
401: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
402: x_custom_output(3) := l_custom_rec;
403:
404: x_custom_output.extend;
405: l_custom_rec.attribute_name := ':PRIORITY';
403:
404: x_custom_output.extend;
405: l_custom_rec.attribute_name := ':PRIORITY';
406: l_custom_rec.attribute_value := l_priority;
407: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
408: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
409: x_custom_output(4) := l_custom_rec;
410:
411: x_custom_output.extend;
404: x_custom_output.extend;
405: l_custom_rec.attribute_name := ':PRIORITY';
406: l_custom_rec.attribute_value := l_priority;
407: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
408: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
409: x_custom_output(4) := l_custom_rec;
410:
411: x_custom_output.extend;
412: l_custom_rec.attribute_name := ':TYPE';
410:
411: x_custom_output.extend;
412: l_custom_rec.attribute_name := ':TYPE';
413: l_custom_rec.attribute_value := replace(l_type,'''');
414: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
415: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
416: x_custom_output(5) := l_custom_rec;
417:
418:
411: x_custom_output.extend;
412: l_custom_rec.attribute_name := ':TYPE';
413: l_custom_rec.attribute_value := replace(l_type,'''');
414: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
415: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
416: x_custom_output(5) := l_custom_rec;
417:
418:
419: x_custom_output.extend;
418:
419: x_custom_output.extend;
420: l_custom_rec.attribute_name := ':STATUS';
421: l_custom_rec.attribute_value := replace(l_status,'''');
422: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
423: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
424: x_custom_output(6) := l_custom_rec;
425:
426:
419: x_custom_output.extend;
420: l_custom_rec.attribute_name := ':STATUS';
421: l_custom_rec.attribute_value := replace(l_status,'''');
422: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
423: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
424: x_custom_output(6) := l_custom_rec;
425:
426:
427: EXCEPTION