APPS.HRI_BPL_TREND_WRKFC_SQL dependencies on HRI_MTDT_DIM_LVL

Line 113: 'AND fact.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

109: l_parameter_name = 'HRI_LOW+HRI_LOW_BAND_X') THEN
110:
111: /* Dynamically set conditions for parameter */
112: p_fact_conditions := p_fact_conditions ||
113: 'AND fact.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
114: (l_parameter_name).fact_viewby_col ||
115: ' IN (' || p_bind_tab(l_parameter_name).pmv_bind_string || ')' || g_rtn;
116:
117: /* Keep count of parameters set */

Line 153: l_bucket_tab hri_mtdt_dim_lvl.dim_lvl_buckets_tabtype;

149:
150: -- template
151: l_column_bucket VARCHAR2(1000);
152: -- table of bucket values
153: l_bucket_tab hri_mtdt_dim_lvl.dim_lvl_buckets_tabtype;
154: --
155: -- For forming the select statement
156: --
157: l_measure_hdc VARCHAR2(1000);

Line 211: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

207: IF p_bucket_dim IS NOT NULL THEN
208:
209: -- Set the template to use the bucket column
210: l_column_bucket := REPLACE(g_column_bucket, '',
211: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
212: (p_bucket_dim).fact_viewby_col);
213:
214: -- Get a pl/sql table containing the buckets for the given bucket dimension
215: IF (p_bucket_dim = 'HRI_LOW+HRI_LOW_BAND_X') THEN

Line 216: hri_mtdt_dim_lvl.set_low_band_buckets(p_parameter_rec.wkth_wktyp_sk_fk);

212: (p_bucket_dim).fact_viewby_col);
213:
214: -- Get a pl/sql table containing the buckets for the given bucket dimension
215: IF (p_bucket_dim = 'HRI_LOW+HRI_LOW_BAND_X') THEN
216: hri_mtdt_dim_lvl.set_low_band_buckets(p_parameter_rec.wkth_wktyp_sk_fk);
217: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
218: ELSIF (p_bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
219: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
220: ELSIF (p_bucket_dim = 'GEOGRAPHY+COUNTRY') THEN

Line 217: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;

213:
214: -- Get a pl/sql table containing the buckets for the given bucket dimension
215: IF (p_bucket_dim = 'HRI_LOW+HRI_LOW_BAND_X') THEN
216: hri_mtdt_dim_lvl.set_low_band_buckets(p_parameter_rec.wkth_wktyp_sk_fk);
217: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
218: ELSIF (p_bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
219: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
220: ELSIF (p_bucket_dim = 'GEOGRAPHY+COUNTRY') THEN
221: l_bucket_tab := hri_mtdt_dim_lvl.g_country_buckets_tab;

Line 219: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;

215: IF (p_bucket_dim = 'HRI_LOW+HRI_LOW_BAND_X') THEN
216: hri_mtdt_dim_lvl.set_low_band_buckets(p_parameter_rec.wkth_wktyp_sk_fk);
217: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
218: ELSIF (p_bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
219: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
220: ELSIF (p_bucket_dim = 'GEOGRAPHY+COUNTRY') THEN
221: l_bucket_tab := hri_mtdt_dim_lvl.g_country_buckets_tab;
222: ELSIF (p_bucket_dim = 'HRI_PRSNTYP+HRI_WKTH_WKTYP') THEN
223: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;

Line 221: l_bucket_tab := hri_mtdt_dim_lvl.g_country_buckets_tab;

217: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
218: ELSIF (p_bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
219: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
220: ELSIF (p_bucket_dim = 'GEOGRAPHY+COUNTRY') THEN
221: l_bucket_tab := hri_mtdt_dim_lvl.g_country_buckets_tab;
222: ELSIF (p_bucket_dim = 'HRI_PRSNTYP+HRI_WKTH_WKTYP') THEN
223: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;
224: END IF;
225: END IF;

Line 223: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;

219: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
220: ELSIF (p_bucket_dim = 'GEOGRAPHY+COUNTRY') THEN
221: l_bucket_tab := hri_mtdt_dim_lvl.g_country_buckets_tab;
222: ELSIF (p_bucket_dim = 'HRI_PRSNTYP+HRI_WKTH_WKTYP') THEN
223: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;
224: END IF;
225: END IF;
226:
227: -- Add headcount columns