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 dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 16: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

12: l_security_clause VARCHAR2(4000);
13: l_custom_rec BIS_QUERY_ATTRIBUTES;
14:
15: /* Parameter values */
16: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
17: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
18:
19: /* Pre-calculations */
20: l_tot_gain NUMBER;

Line 17: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

13: l_custom_rec BIS_QUERY_ATTRIBUTES;
14:
15: /* Parameter values */
16: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
17: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
18:
19: /* Pre-calculations */
20: l_tot_gain NUMBER;
21: l_tot_gain_hire NUMBER;

Line 58: hri_oltp_pmv_util_param.get_parameters_from_table

54: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
55: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
56:
57: /* Get common parameter values */
58: hri_oltp_pmv_util_param.get_parameters_from_table
59: (p_page_parameter_tbl => p_page_parameter_tbl,
60: p_parameter_rec => l_parameter_rec,
61: p_bind_tab => l_bind_tab);
62:

Line 323: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

319: l_security_clause VARCHAR2(4000);
320: --
321: -- Page parameters
322: --
323: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
324: --
325: -- Bind values for SQL and PMV mode
326: --
327: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

Line 327: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

323: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
324: --
325: -- Bind values for SQL and PMV mode
326: --
327: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
328: --
329: -- Parameter values for getting the inner SQL
330: --
331: l_wrkfc_params hri_bpl_fact_sup_wrkfc_sql.WRKFC_FACT_PARAM_TYPE;

Line 346: hri_oltp_pmv_util_param.get_parameters_from_table

342: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
343: --
344: -- Get the parameter information from the page parameter table
345: --
346: hri_oltp_pmv_util_param.get_parameters_from_table
347: (p_page_parameter_tbl => p_page_parameter_tbl,
348: p_parameter_rec => l_parameter_rec,
349: p_bind_tab => l_bind_tab);
350: --

Line 404: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

400: l_security_clause VARCHAR2(4000);
401: l_custom_rec BIS_QUERY_ATTRIBUTES;
402:
403: /* Parameter values */
404: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
405: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
406:
407: /* Dynamic SQL controls */
408: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

Line 405: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

401: l_custom_rec BIS_QUERY_ATTRIBUTES;
402:
403: /* Parameter values */
404: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
405: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
406:
407: /* Dynamic SQL controls */
408: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
409: l_wrkfc_fact_sql VARCHAR2(10000);

Line 422: hri_oltp_pmv_util_param.get_parameters_from_table

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

Line 490: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

486: l_security_clause VARCHAR2(4000);
487: l_custom_rec BIS_QUERY_ATTRIBUTES;
488:
489: /* Parameter values */
490: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
491: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
492:
493: /* Dynamic SQL controls */
494: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

Line 491: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

487: l_custom_rec BIS_QUERY_ATTRIBUTES;
488:
489: /* Parameter values */
490: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
491: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
492:
493: /* Dynamic SQL controls */
494: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
495: l_wrkfc_fact_sql VARCHAR2(10000);

Line 508: hri_oltp_pmv_util_param.get_parameters_from_table

504: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
505: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
506:
507: /* Get common parameter values */
508: hri_oltp_pmv_util_param.get_parameters_from_table
509: (p_page_parameter_tbl => p_page_parameter_tbl,
510: p_parameter_rec => l_parameter_rec,
511: p_bind_tab => l_bind_tab);
512: