[Home] [Help]
55:
56: /* Dynamic SQL Controls */
57: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
58: l_wrkfc_fact_sql VARCHAR2(10000);
59: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
60: l_wcnt_chg_fact_sql VARCHAR2(10000);
61:
62: /* Dynamic strings */
63: l_direct_reports_string VARCHAR2(1000);
134: l_wcnt_chg_fact_params.bind_format := 'PMV';
135: l_wcnt_chg_fact_params.include_comp := 'Y';
136: l_wcnt_chg_fact_params.include_sep := 'Y';
137: l_wcnt_chg_fact_params.bucket_dim := 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X';
138: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql
139: (p_parameter_rec => l_parameter_rec,
140: p_bind_tab => l_bind_tab,
141: p_wcnt_chg_params => l_wcnt_chg_fact_params,
142: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP_BCKT.GET_SQL_BKCT_PERF');
478:
479: /* Dynamic SQL Controls */
480: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
481: l_wrkfc_fact_sql VARCHAR2(10000);
482: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
483: l_wcnt_chg_fact_sql VARCHAR2(10000);
484:
485: /* Dynamic strings */
486: l_direct_reports_string VARCHAR2(1000);
549: /* Get SQL for workforce changes fact */
550: l_wcnt_chg_fact_params.bind_format := 'PMV';
551: l_wcnt_chg_fact_params.include_sep := 'Y';
552: l_wcnt_chg_fact_params.bucket_dim := 'HRI_LOW+HRI_LOW_BAND_X';
553: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql
554: (p_parameter_rec => l_parameter_rec,
555: p_bind_tab => l_bind_tab,
556: p_wcnt_chg_params => l_wcnt_chg_fact_params,
557: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP_BCKT.GET_SQL_BKCT_LOW');
849: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
850: --
851: -- Parameter values for getting the inner SQL
852: --
853: l_wcnt_chg_params hri_bpl_fact_sup_wcnt_chg_sql.WCNT_CHG_FACT_PARAM_TYPE;
854: --
855: -- Inner SQL
856: --
857: l_inn_sql VARCHAR2(32767);