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_BPL_FACT_SUP_WRKFC_SQL

Line 46: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

42: l_drill_url5 VARCHAR2(300);
43: l_drill_url6 VARCHAR2(300);
44:
45: /* Dynamic SQL controls */
46: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
47: l_wrkfc_fact_sql VARCHAR2(10000);
48: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
49: l_wcnt_chg_fact_sql VARCHAR2(10000);
50:

Line 152: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

148: l_wrkfc_fact_params.bind_format := 'PMV';
149: l_wrkfc_fact_params.include_comp := 'Y';
150: l_wrkfc_fact_params.include_hdc := 'Y';
151: l_wrkfc_fact_params.include_start := 'Y';
152: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
153: (p_parameter_rec => l_parameter_rec,
154: p_bind_tab => l_bind_tab,
155: p_wrkfc_params => l_wrkfc_fact_params,
156: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP.GET_SQL2');

Line 331: l_wrkfc_params hri_bpl_fact_sup_wrkfc_sql.WRKFC_FACT_PARAM_TYPE;

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;
332: --
333: -- Inner SQL
334: --
335: l_trend_sql VARCHAR2(32767);

Line 408: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

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);
410: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
411: l_wcnt_chg_fact_sql VARCHAR2(10000);
412:

Line 443: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

439: l_wrkfc_fact_params.include_low := 'Y';
440: l_wrkfc_fact_params.include_pasg_cnt := 'Y';
441: l_wrkfc_fact_params.kpi_mode := 'Y';
442: l_wrkfc_fact_params.bucket_dim := 'HRI_PRSNTYP+HRI_WKTH_WKTYP';
443: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
444: (p_parameter_rec => l_parameter_rec,
445: p_bind_tab => l_bind_tab,
446: p_wrkfc_params => l_wrkfc_fact_params,
447: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP.GET_WMV_C_LOW_KPI');

Line 494: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

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);
496: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
497: l_wcnt_chg_fact_sql VARCHAR2(10000);
498:

Line 526: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

522: l_wrkfc_fact_params.include_comp := 'Y';
523: l_wrkfc_fact_params.include_hdc := 'Y';
524: l_wrkfc_fact_params.kpi_mode := 'Y';
525: l_wrkfc_fact_params.bucket_dim := 'HRI_PRSNTYP+HRI_WKTH_WKTYP';
526: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
527: (p_parameter_rec => l_parameter_rec,
528: p_bind_tab => l_bind_tab,
529: p_wrkfc_params => l_wrkfc_fact_params,
530: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP.GET_WMV_C_KPI');