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_WMV_SUP_BCKT dependencies on BIS_QUERY_ATTRIBUTES

Line 206: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

202: /* Entry point for Headcount for Performance Band SQL */
203: PROCEDURE get_sql_bckt_perf
204: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
205: x_custom_sql OUT NOCOPY VARCHAR2,
206: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
207:
208: /* Return information */
209: l_sqltext VARCHAR2(32767);
210: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 210: l_custom_rec BIS_QUERY_ATTRIBUTES;

206: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
207:
208: /* Return information */
209: l_sqltext VARCHAR2(32767);
210: l_custom_rec BIS_QUERY_ATTRIBUTES;
211:
212: /* Dynamic SQL support */
213: l_dynsql_rec dynamic_sql_rec_type;
214: l_security_clause VARCHAR2(4000);

Line 229: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

225: BEGIN
226:
227: /* Initialize out parameters */
228: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
229: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
230:
231:
232: /* Get common parameter values */
233: hri_oltp_pmv_util_param.get_parameters_from_table

Line 391: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

387: /* Entry point for Headcount for Period of Work Band SQL */
388: PROCEDURE get_sql_bckt_low
389: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
390: x_custom_sql OUT NOCOPY VARCHAR2,
391: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
392:
393: /* Return information */
394: l_sqltext VARCHAR2(32767);
395: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 395: l_custom_rec BIS_QUERY_ATTRIBUTES;

391: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
392:
393: /* Return information */
394: l_sqltext VARCHAR2(32767);
395: l_custom_rec BIS_QUERY_ATTRIBUTES;
396:
397: /* Dynamic SQL support */
398: l_dynsql_rec dynamic_sql_rec_type;
399: l_security_clause VARCHAR2(4000);

Line 421: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

417: BEGIN
418:
419: /* Initialize out parameters */
420: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
421: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
422: /* Get common parameter values */
423: hri_oltp_pmv_util_param.get_parameters_from_table
424: (p_page_parameter_tbl => p_page_parameter_tbl,
425: p_parameter_rec => l_parameter_rec,

Line 624: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

620: --
621: PROCEDURE get_wmv_perf_kpi
622: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
623: x_custom_sql OUT NOCOPY VARCHAR2,
624: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
625: --
626: -- The security clause
627: --
628: l_security_clause VARCHAR2(4000);

Line 645: l_custom_rec BIS_QUERY_ATTRIBUTES;

641: --
642: -- Inner SQL
643: --
644: l_inn_sql VARCHAR2(32767);
645: l_custom_rec BIS_QUERY_ATTRIBUTES;
646: --
647: BEGIN
648: --
649: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 649: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

645: l_custom_rec BIS_QUERY_ATTRIBUTES;
646: --
647: BEGIN
648: --
649: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
650: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
651: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
652: --
653: -- Get the parameter information from the page parameter table