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_PMV_PARAMETERS_PUB

Line 51: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

47: );
48: --
49: BEGIN
50: --
51: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
52: --
53: IF (p_page_parameter_tbl.COUNT > 0)
54: THEN
55: --

Line 90: , bis_pmv_parameters_pub.bind_type

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);
92: --
93: l_pgm_rptgtyp_id := l_value;
94: --

Line 91: , bis_pmv_parameters_pub.numeric_bind);

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);
92: --
93: l_pgm_rptgtyp_id := l_value;
94: --
95: ELSIF p_page_parameter_tbl (i).parameter_name = 'PL_TYP_A+PL_TYP_B'

Line 110: , bis_pmv_parameters_pub.bind_type

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);
112: --
113: ELSIF p_page_parameter_tbl (i).parameter_name = 'PLN_A+PLN_B'
114: THEN

Line 111: , bis_pmv_parameters_pub.numeric_bind);

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);
112: --
113: ELSIF p_page_parameter_tbl (i).parameter_name = 'PLN_A+PLN_B'
114: THEN
115: --

Line 128: , bis_pmv_parameters_pub.bind_type

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);
130: --
131: /*
132: --

Line 129: , bis_pmv_parameters_pub.numeric_bind);

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);
130: --
131: /*
132: --
133: -- Uncomment this code when Enrollment Period Dimension is Re-instated

Line 147: , bis_pmv_parameters_pub.bind_type

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);
149: --
150: if nvl(l_value, '') <> ''
151: then

Line 148: , bis_pmv_parameters_pub.DATE_BIND);

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);
149: --
150: if nvl(l_value, '') <> ''
151: then
152: --

Line 170: , bis_pmv_parameters_pub.bind_type

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);
172: --
173: l_effective_date := to_date(l_value, 'DD/MM/YYYY');
174: --

Line 171: , bis_pmv_parameters_pub.DATE_BIND);

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);
172: --
173: l_effective_date := to_date(l_value, 'DD/MM/YYYY');
174: --
175: ELSIF p_page_parameter_tbl (i).parameter_name = 'ACTN_TYP_A+ACTN_TYP_B'

Line 187: , bis_pmv_parameters_pub.bind_type

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);
189: --
190: END IF;
191: --

Line 188: , bis_pmv_parameters_pub.VARCHAR2_BIND);

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);
189: --
190: END IF;
191: --
192: END LOOP;

Line 236: , bis_pmv_parameters_pub.bind_type

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);
238: --
239: END IF;
240: --

Line 237: , bis_pmv_parameters_pub.DATE_BIND);

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);
238: --
239: END IF;
240: --
241: --

Line 386: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

382: NULL HRI_P_MEASURE4,
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,

Line 489: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

485: NULL HRI_P_MEASURE2,
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,

Line 574: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

570: NULL HRI_P_MEASURE2,
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,

Line 663: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

659: NULL HRI_P_CHAR9_GA,
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,

Line 803: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

799: x_custom_sql := ' SELECT NULL HRI_P_CHAR1_GA /* Event Status */,
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,

Line 873: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

869: x_custom_sql := ' SELECT NULL HRI_P_CHAR1_GA /* Open Enrollment KPIs */,
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,

Line 945: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

941: NULL HRI_P_MEASURE3,
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,

Line 1018: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1014: NULL HRI_P_MEASURE9_MP,
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,