DBA Data[Home] [Help]

APPS.ENI_DBI_PME_KPI_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 174: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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:

Line 598: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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,'''');

Line 603: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

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;

Line 604: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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';

Line 610: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

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;

Line 611: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

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';

Line 617: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

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;

Line 618: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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';

Line 624: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

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;

Line 625: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

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

Line 631: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

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

Line 632: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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:

Line 640: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

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;

Line 641: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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';

Line 647: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

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:

Line 648: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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;

Line 655: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

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

Line 656: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

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: