170: null as ENI_MEASURE34,
171: null as ENI_MEASURE35
172: FROM dual';
173: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
174: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
175: RETURN;
176:
177: END IF;
178:
594:
595: ';
596:
597: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
598: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
599:
600: x_custom_output.extend;
601: l_custom_rec.attribute_name := ':ITEM';
602: l_custom_rec.attribute_value := replace(l_item,'''');
599:
600: x_custom_output.extend;
601: l_custom_rec.attribute_name := ':ITEM';
602: l_custom_rec.attribute_value := replace(l_item,'''');
603: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
604: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
605: x_custom_output(1) := l_custom_rec;
606:
607: x_custom_output.extend;
600: x_custom_output.extend;
601: l_custom_rec.attribute_name := ':ITEM';
602: l_custom_rec.attribute_value := replace(l_item,'''');
603: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
604: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
605: x_custom_output(1) := l_custom_rec;
606:
607: x_custom_output.extend;
608: l_custom_rec.attribute_name := ':ORG';
606:
607: x_custom_output.extend;
608: l_custom_rec.attribute_name := ':ORG';
609: l_custom_rec.attribute_value :=replace(l_org,'''');
610: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
611: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
612: x_custom_output(2) := l_custom_rec;
613:
614: x_custom_output.extend;
607: x_custom_output.extend;
608: l_custom_rec.attribute_name := ':ORG';
609: l_custom_rec.attribute_value :=replace(l_org,'''');
610: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
611: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
612: x_custom_output(2) := l_custom_rec;
613:
614: x_custom_output.extend;
615: l_custom_rec.attribute_name := ':ITEMPCO';
613:
614: x_custom_output.extend;
615: l_custom_rec.attribute_name := ':ITEMPCO';
616: l_custom_rec.attribute_value := replace(l_item_pco,'''');
617: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
618: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
619: x_custom_output(3) := l_custom_rec;
620:
621: x_custom_output.extend;
614: x_custom_output.extend;
615: l_custom_rec.attribute_name := ':ITEMPCO';
616: l_custom_rec.attribute_value := replace(l_item_pco,'''');
617: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
618: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
619: x_custom_output(3) := l_custom_rec;
620:
621: x_custom_output.extend;
622: l_custom_rec.attribute_name := ':ORGPCO';
620:
621: x_custom_output.extend;
622: l_custom_rec.attribute_name := ':ORGPCO';
623: l_custom_rec.attribute_value :=replace(l_org_pco,'''');
624: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
625: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
626: x_custom_output(4) := l_custom_rec;
627:
628: x_custom_output.extend;
621: x_custom_output.extend;
622: l_custom_rec.attribute_name := ':ORGPCO';
623: l_custom_rec.attribute_value :=replace(l_org_pco,'''');
624: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
625: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
626: x_custom_output(4) := l_custom_rec;
627:
628: x_custom_output.extend;
629: l_custom_rec.attribute_name := ':PERIODAND';--Bug 5083652
627:
628: x_custom_output.extend;
629: l_custom_rec.attribute_name := ':PERIODAND';--Bug 5083652
630: l_custom_rec.attribute_value := replace(l_period_bitand,'''');
631: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
632: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
633: x_custom_output(5) := l_custom_rec;
634:
635: --Bug 5083652 -- Start Code
628: x_custom_output.extend;
629: l_custom_rec.attribute_name := ':PERIODAND';--Bug 5083652
630: l_custom_rec.attribute_value := replace(l_period_bitand,'''');
631: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
632: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
633: x_custom_output(5) := l_custom_rec;
634:
635: --Bug 5083652 -- Start Code
636:
636:
637: x_custom_output.extend;
638: l_custom_rec.attribute_name := ':PERIODTYPE';
639: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
640: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
641: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
642: x_custom_output(6) := l_custom_rec;
643:
644: x_custom_output.extend;
637: x_custom_output.extend;
638: l_custom_rec.attribute_name := ':PERIODTYPE';
639: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
640: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
641: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
642: x_custom_output(6) := l_custom_rec;
643:
644: x_custom_output.extend;
645: l_custom_rec.attribute_name := ':COMPARETYPE';
643:
644: x_custom_output.extend;
645: l_custom_rec.attribute_name := ':COMPARETYPE';
646: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
647: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
648: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
649: x_custom_output(7) := l_custom_rec;
650:
651:
644: x_custom_output.extend;
645: l_custom_rec.attribute_name := ':COMPARETYPE';
646: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
647: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
648: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
649: x_custom_output(7) := l_custom_rec;
650:
651:
652: x_custom_output.extend;
651:
652: x_custom_output.extend;
653: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
654: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
655: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
656: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
657: x_custom_output(8) := l_custom_rec;
658:
659: --Bug 5083652 -- End Code
652: x_custom_output.extend;
653: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
654: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
655: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
656: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
657: x_custom_output(8) := l_custom_rec;
658:
659: --Bug 5083652 -- End Code
660: