DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_OPEN_ENRT_STAT dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 14: x_custom_output IN OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,

10: -- procedures.
11: --
12: procedure SET_BIND_PARAMETERS(
13: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
14: x_custom_output IN OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,
15: p_selection OUT NOCOPY NUMBER)
16: IS
17: --
18: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 369: x_custom_output OUT NOCOPY bis_query_attributes_tbl

365: --
366: PROCEDURE GET_ELIGENRL_PLIP_SQL (
367: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
368: x_custom_sql OUT NOCOPY VARCHAR2,
369: x_custom_output OUT NOCOPY bis_query_attributes_tbl
370: )
371: IS
372: --
373: l_selection number;

Line 387: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

383: NULL HRI_P_DRILL_URL1
384: FROM DUAL';
385: --
386: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
387: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
388: --
389: set_bind_parameters( p_page_parameter_tbl => p_page_parameter_tbl,
390: x_custom_output => x_custom_output,
391: p_selection => l_selection) ;

Line 474: x_custom_output OUT NOCOPY bis_query_attributes_tbl

470: --
471: PROCEDURE GET_ELIGENRL_OIPL_SQL (
472: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
473: x_custom_sql OUT NOCOPY VARCHAR2,
474: x_custom_output OUT NOCOPY bis_query_attributes_tbl
475: )
476: IS
477: --
478: l_selection number;

Line 490: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

486: NULL HRI_P_MEASURE3_MP
487: FROM DUAL';
488: --
489: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
490: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
491: --
492: set_bind_parameters( p_page_parameter_tbl => p_page_parameter_tbl,
493: x_custom_output => x_custom_output,
494: p_selection => l_selection) ;

Line 559: x_custom_output OUT NOCOPY bis_query_attributes_tbl

555: --
556: PROCEDURE GET_ENRLACTN_SQL (
557: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
558: x_custom_sql OUT NOCOPY VARCHAR2,
559: x_custom_output OUT NOCOPY bis_query_attributes_tbl
560: )
561: IS
562: --
563: l_selection number;

Line 575: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

571: NULL HRI_P_CHAR2_GA
572: FROM DUAL';
573: --
574: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
575: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
576: --
577: set_bind_parameters( p_page_parameter_tbl => p_page_parameter_tbl,
578: x_custom_output => x_custom_output,
579: p_selection => l_selection) ;

Line 636: x_custom_output OUT NOCOPY bis_query_attributes_tbl

632: --
633: PROCEDURE GET_ENRLACTN_DET_SQL (
634: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
635: x_custom_sql OUT NOCOPY VARCHAR2,
636: x_custom_output OUT NOCOPY bis_query_attributes_tbl
637: )
638: IS
639: --
640: l_selection NUMBER;

Line 664: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

660: NULL HRI_P_DRILL_URL1
661: FROM DUAL';
662: --
663: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
664: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
665: --
666: set_bind_parameters( p_page_parameter_tbl => p_page_parameter_tbl,
667: x_custom_output => x_custom_output,
668: p_selection => l_selection) ;

Line 790: x_custom_output OUT NOCOPY bis_query_attributes_tbl

786: --
787: PROCEDURE GET_ELCTN_EVNT_SQL (
788: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
789: x_custom_sql OUT NOCOPY VARCHAR2,
790: x_custom_output OUT NOCOPY bis_query_attributes_tbl
791: )
792: IS
793: --
794: l_selection number;

Line 804: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

800: NULL HRI_P_MEASURE1
801: FROM DUAL';
802: --
803: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
804: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
805: --
806: set_bind_parameters( p_page_parameter_tbl => p_page_parameter_tbl,
807: x_custom_output => x_custom_output,
808: p_selection => l_selection) ;

Line 860: x_custom_output OUT NOCOPY bis_query_attributes_tbl

856: --
857: PROCEDURE GET_ENRT_KPI_GRAPH_SQL (
858: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
859: x_custom_sql OUT NOCOPY VARCHAR2,
860: x_custom_output OUT NOCOPY bis_query_attributes_tbl
861: )
862: IS
863: --
864: l_selection number;

Line 874: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

870: NULL HRI_P_MEASURE1
871: FROM DUAL';
872: --
873: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
874: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
875: --
876: set_bind_parameters( p_page_parameter_tbl => p_page_parameter_tbl,
877: x_custom_output => x_custom_output,
878: p_selection => l_selection) ;

Line 930: x_custom_output OUT NOCOPY bis_query_attributes_tbl

926: --
927: PROCEDURE GET_ENRT_KPI_SQL (
928: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
929: x_custom_sql OUT NOCOPY VARCHAR2,
930: x_custom_output OUT NOCOPY bis_query_attributes_tbl
931: )
932: IS
933: --
934: l_selection number;

Line 946: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

942: NULL HRI_P_MEASURE4
943: FROM DUAL';
944: --
945: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
946: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
947: --
948: set_bind_parameters( p_page_parameter_tbl => p_page_parameter_tbl,
949: x_custom_output => x_custom_output,
950: p_selection => l_selection) ;

Line 996: x_custom_output OUT NOCOPY bis_query_attributes_tbl

992: --
993: PROCEDURE GET_ELIGENRL_PTIP_SQL (
994: p_page_parameter_tbl IN bis_pmv_page_parameter_tbl,
995: x_custom_sql OUT NOCOPY VARCHAR2,
996: x_custom_output OUT NOCOPY bis_query_attributes_tbl
997: )
998: IS
999: --
1000: l_selection number;

Line 1019: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

1015: NULL HRI_P_MEASURE10
1016: FROM DUAL';
1017: --
1018: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1019: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1020: --
1021: set_bind_parameters( p_page_parameter_tbl => p_page_parameter_tbl,
1022: x_custom_output => x_custom_output,
1023: p_selection => l_selection) ;