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_BPL_TREND_TRM_SQL dependencies on HRI_MTDT_DIM_LVL

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

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

Line 157: l_bucket_tab hri_mtdt_dim_lvl.dim_lvl_buckets_tabtype;

153: l_column_bucket VARCHAR2(1000);
154: --
155: -- table of bucket values
156: --
157: l_bucket_tab hri_mtdt_dim_lvl.dim_lvl_buckets_tabtype;
158: --
159: -- For forming the select statement
160: --
161: l_measure_trm VARCHAR2(1000);

Line 174: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

170: IF p_bucket_dim IS NOT NULL THEN
171:
172: -- Set the bucket column template to use the bucket column
173: l_column_bucket := REPLACE(g_column_bucket, '',
174: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
175: (p_bucket_dim).fact_viewby_col);
176:
177: -- Get a pl/sql table containing the buckets for the given bucket dimension
178: IF (p_bucket_dim = 'HRI_LOW+HRI_LOW_BAND_X') THEN

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

175: (p_bucket_dim).fact_viewby_col);
176:
177: -- Get a pl/sql table containing the buckets for the given bucket dimension
178: IF (p_bucket_dim = 'HRI_LOW+HRI_LOW_BAND_X') THEN
179: hri_mtdt_dim_lvl.set_low_band_buckets(p_parameter_rec.wkth_wktyp_sk_fk);
180: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
181: ELSIF (p_bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
182: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
183: ELSIF (p_bucket_dim = 'GEOGRAPHY+COUNTRY') THEN

Line 180: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;

176:
177: -- Get a pl/sql table containing the buckets for the given bucket dimension
178: IF (p_bucket_dim = 'HRI_LOW+HRI_LOW_BAND_X') THEN
179: hri_mtdt_dim_lvl.set_low_band_buckets(p_parameter_rec.wkth_wktyp_sk_fk);
180: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
181: ELSIF (p_bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
182: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
183: ELSIF (p_bucket_dim = 'GEOGRAPHY+COUNTRY') THEN
184: l_bucket_tab := hri_mtdt_dim_lvl.g_country_buckets_tab;

Line 182: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;

178: IF (p_bucket_dim = 'HRI_LOW+HRI_LOW_BAND_X') THEN
179: hri_mtdt_dim_lvl.set_low_band_buckets(p_parameter_rec.wkth_wktyp_sk_fk);
180: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
181: ELSIF (p_bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
182: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
183: ELSIF (p_bucket_dim = 'GEOGRAPHY+COUNTRY') THEN
184: l_bucket_tab := hri_mtdt_dim_lvl.g_country_buckets_tab;
185: ELSIF (p_bucket_dim = 'HRI_PRSNTYP+HRI_WKTH_WKTYP') THEN
186: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;

Line 184: l_bucket_tab := hri_mtdt_dim_lvl.g_country_buckets_tab;

180: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
181: ELSIF (p_bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
182: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
183: ELSIF (p_bucket_dim = 'GEOGRAPHY+COUNTRY') THEN
184: l_bucket_tab := hri_mtdt_dim_lvl.g_country_buckets_tab;
185: ELSIF (p_bucket_dim = 'HRI_PRSNTYP+HRI_WKTH_WKTYP') THEN
186: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;
187: END IF;
188: END IF;

Line 186: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;

182: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
183: ELSIF (p_bucket_dim = 'GEOGRAPHY+COUNTRY') THEN
184: l_bucket_tab := hri_mtdt_dim_lvl.g_country_buckets_tab;
185: ELSIF (p_bucket_dim = 'HRI_PRSNTYP+HRI_WKTH_WKTYP') THEN
186: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;
187: END IF;
188: END IF;
189:
190: -- Add termination columns