eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_OLTP_PMV_OPEN_ENRT_STAT dependencies on BIS_QUERY_ATTRIBUTES

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 18: l_custom_rec BIS_QUERY_ATTRIBUTES;

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;
19: L_VALUE varchar2(80);
20: --
21: l_pgm_rptgtyp_id number;
22: l_enrt_perd_found boolean := false;

Line 87: x_custom_output(x_custom_output.LAST) := bis_query_attributes

83: --
84: -- For Dimension : Reporting Group => PGM_A+PGM_B = RPTGTYP_ID
85: --
86: x_custom_output.EXTEND;
87: x_custom_output(x_custom_output.LAST) := bis_query_attributes
88: ( ':PGM_RPTGTYP_ID'
89: , l_value
90: , bis_pmv_parameters_pub.bind_type
91: , bis_pmv_parameters_pub.numeric_bind);

Line 107: x_custom_output(x_custom_output.LAST) := bis_query_attributes

103: --
104: -- For Dimension : Program => PL_TYP_A+PL_TYP_B = PTIP_ID
105: --
106: x_custom_output.EXTEND;
107: x_custom_output(x_custom_output.LAST) := bis_query_attributes
108: ( ':PTIP_PLTYP_ID'
109: , l_value
110: , bis_pmv_parameters_pub.bind_type
111: , bis_pmv_parameters_pub.numeric_bind);

Line 125: x_custom_output(x_custom_output.LAST) := bis_query_attributes

121: --
122: -- For Dimension : Program => PLN_A+PLN_B = PLIP_ID
123: --
124: x_custom_output.EXTEND;
125: x_custom_output(x_custom_output.LAST) := bis_query_attributes
126: ( ':PLIP_PL_ID'
127: , l_value
128: , bis_pmv_parameters_pub.bind_type
129: , bis_pmv_parameters_pub.numeric_bind);

Line 144: x_custom_output(x_custom_output.LAST) := bis_query_attributes

140: --
141: -- Assigned Life Event Date
142: --
143: x_custom_output.EXTEND;
144: x_custom_output(x_custom_output.LAST) := bis_query_attributes
145: ( ':ASND_LF_EVT_DT'
146: , to_char(l_asnd_lf_evt_dt, 'DD/MM/YYYY')
147: , bis_pmv_parameters_pub.bind_type
148: , bis_pmv_parameters_pub.DATE_BIND);

Line 167: x_custom_output(x_custom_output.LAST) := bis_query_attributes

163: --
164: -- Effective Date
165: --
166: x_custom_output.EXTEND;
167: x_custom_output(x_custom_output.LAST) := bis_query_attributes
168: ( ':BEN_AS_OF_DATE'
169: , l_value
170: , bis_pmv_parameters_pub.bind_type
171: , bis_pmv_parameters_pub.DATE_BIND);

Line 184: x_custom_output(x_custom_output.LAST) := bis_query_attributes

180: --
181: -- Action Type Code
182: --
183: x_custom_output.EXTEND;
184: x_custom_output(x_custom_output.LAST) := bis_query_attributes
185: ( ':ACTN_TYP_CD'
186: , l_value
187: , bis_pmv_parameters_pub.bind_type
188: , bis_pmv_parameters_pub.VARCHAR2_BIND);

Line 233: x_custom_output(x_custom_output.LAST) := bis_query_attributes

229: --
230: end if;
231: --
232: x_custom_output.EXTEND;
233: x_custom_output(x_custom_output.LAST) := bis_query_attributes
234: ( ':ASND_LF_EVT_DT'
235: , to_char(l_asnd_lf_evt_dt, 'DD/MM/YYYY')
236: , bis_pmv_parameters_pub.bind_type
237: , bis_pmv_parameters_pub.DATE_BIND);

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 374: l_custom_rec BIS_QUERY_ATTRIBUTES;

370: )
371: IS
372: --
373: l_selection number;
374: l_custom_rec BIS_QUERY_ATTRIBUTES;
375: --
376: BEGIN
377: --
378: x_custom_sql := ' SELECT NULL HRI_P_CHAR1_GA /* Participation By Plan */,

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 479: l_custom_rec BIS_QUERY_ATTRIBUTES;

475: )
476: IS
477: --
478: l_selection number;
479: l_custom_rec BIS_QUERY_ATTRIBUTES;
480: --
481: BEGIN
482: --
483: x_custom_sql := ' SELECT NULL HRI_P_CHAR1_GA /* Participation By Option In Plan */,

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 564: l_custom_rec BIS_QUERY_ATTRIBUTES;

560: )
561: IS
562: --
563: l_selection number;
564: l_custom_rec BIS_QUERY_ATTRIBUTES;
565: --
566: BEGIN
567: --
568: x_custom_sql := ' SELECT NULL HRI_P_CHAR1_GA /* Open Action Items */,

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 641: l_custom_rec BIS_QUERY_ATTRIBUTES;

637: )
638: IS
639: --
640: l_selection NUMBER;
641: l_custom_rec BIS_QUERY_ATTRIBUTES;
642: l_lnk_profile_chk NUMBER;
643: --
644: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
645: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

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 795: l_custom_rec BIS_QUERY_ATTRIBUTES;

791: )
792: IS
793: --
794: l_selection number;
795: l_custom_rec BIS_QUERY_ATTRIBUTES;
796: --
797: BEGIN
798: --
799: x_custom_sql := ' SELECT NULL HRI_P_CHAR1_GA /* Event Status */,

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 865: l_custom_rec BIS_QUERY_ATTRIBUTES;

861: )
862: IS
863: --
864: l_selection number;
865: l_custom_rec BIS_QUERY_ATTRIBUTES;
866: --
867: BEGIN
868: --
869: x_custom_sql := ' SELECT NULL HRI_P_CHAR1_GA /* Open Enrollment KPIs */,

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 935: l_custom_rec BIS_QUERY_ATTRIBUTES;

931: )
932: IS
933: --
934: l_selection number;
935: l_custom_rec BIS_QUERY_ATTRIBUTES;
936: --
937: BEGIN
938: --
939: x_custom_sql := ' SELECT NULL HRI_P_MEASURE1 /* Open Enrollment Status */,

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 1001: l_custom_rec BIS_QUERY_ATTRIBUTES;

997: )
998: IS
999: --
1000: l_selection number;
1001: l_custom_rec BIS_QUERY_ATTRIBUTES;
1002: --
1003: BEGIN
1004: --
1005: x_custom_sql := ' SELECT NULL HRI_P_CHAR1_GA /* Participation By Plan Type */,

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