[Home] [Help]
214: l_security_clause VARCHAR2(4000);
215: l_direct_reports_string VARCHAR2(100);
216:
217: /* Dynamic SQL Controls */
218: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
219: l_wrkfc_fact_sql VARCHAR2(10000);
220:
221: /* Parameter values */
222: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
251: l_wrkfc_fact_params.bind_format := 'PMV';
252: l_wrkfc_fact_params.include_comp := 'Y';
253: l_wrkfc_fact_params.include_hdc := 'Y';
254: l_wrkfc_fact_params.bucket_dim := 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X';
255: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
256: (p_parameter_rec => l_parameter_rec,
257: p_bind_tab => l_bind_tab,
258: p_wrkfc_params => l_wrkfc_fact_params,
259: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP_BCKT.GET_SQL_BCKT_PERF');
403: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
404: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
405:
406: /* Dynamic SQL Controls */
407: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
408: l_wrkfc_fact_sql VARCHAR2(10000);
409:
410: /* Drill URLs for column drills on Headcount figure */
411: l_drill_url2 VARCHAR2(1000) := '''''';
447: l_wrkfc_fact_params.bind_format := 'PMV';
448: l_wrkfc_fact_params.include_comp := 'Y';
449: l_wrkfc_fact_params.include_hdc := 'Y';
450: l_wrkfc_fact_params.bucket_dim := 'HRI_LOW+HRI_LOW_BAND_X';
451: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
452: (p_parameter_rec => l_parameter_rec,
453: p_bind_tab => l_bind_tab,
454: p_wrkfc_params => l_wrkfc_fact_params,
455: p_calling_module => 'HRI_OLTP_PMV_WMV_SUP_BCKT.GET_SQL_BCKT_LOW');
636: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
637: --
638: -- Parameter values for getting the inner SQL
639: --
640: l_wrkfc_params hri_bpl_fact_sup_wrkfc_sql.WRKFC_FACT_PARAM_TYPE;
641: --
642: -- Inner SQL
643: --
644: l_inn_sql VARCHAR2(32767);