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

Line 240: 'AND wcnt.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

236: l_parameter_name = 'HRI_WRKACTVT+HRI_WAC_SEPCAT_X') THEN
237:
238: /* Dynamically set conditions for parameter */
239: p_fact_conditions := p_fact_conditions ||
240: 'AND wcnt.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
241: (l_parameter_name).fact_viewby_col ||
242: ' IN (' || g_binds(l_parameter_name) || ')' || g_rtn;
243:
244: /* Keep count of parameters set */

Line 326: l_wcnt_vby_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

322: /* snapshot */
323: /*----------------------------------------------------------------------------*/
324:
325: /* Set the local variables for which fact table to use */
326: l_wcnt_vby_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
327: (p_parameter_rec.view_by).sup_lvl_wcnt_mv_snp;
328: IF p_bucket_dim IS NOT NULL THEN
329: l_wcnt_bkt_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
330: (p_bucket_dim).sup_lvl_wcnt_mv_snp;

Line 329: l_wcnt_bkt_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

325: /* Set the local variables for which fact table to use */
326: l_wcnt_vby_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
327: (p_parameter_rec.view_by).sup_lvl_wcnt_mv_snp;
328: IF p_bucket_dim IS NOT NULL THEN
329: l_wcnt_bkt_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
330: (p_bucket_dim).sup_lvl_wcnt_mv_snp;
331: END IF;
332: IF p_single_param IS NOT NULL THEN
333: l_wcnt_prm_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

Line 333: l_wcnt_prm_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

329: l_wcnt_bkt_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
330: (p_bucket_dim).sup_lvl_wcnt_mv_snp;
331: END IF;
332: IF p_single_param IS NOT NULL THEN
333: l_wcnt_prm_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
334: (p_single_param).sup_lvl_wcnt_mv_snp;
335: END IF;
336:
337: /* If no parameters are supplied use the viewby or bucket dimension table */

Line 497: l_bucket_tab hri_mtdt_dim_lvl.dim_lvl_buckets_tabtype;

493: /* Return string */
494: l_column_list VARCHAR2(5000);
495:
496: /* Table of buckets for the given bucket dimension */
497: l_bucket_tab hri_mtdt_dim_lvl.dim_lvl_buckets_tabtype;
498:
499: /* Column Templates */
500: l_bucket_column VARCHAR2(1000);
501:

Line 530: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

526: IF (p_wcnt_chg_params.bucket_dim IS NOT NULL) THEN
527:
528: /* Replace the bucket column tag in the bucket column template */
529: l_bucket_column := REPLACE(p_template_bucket, '',
530: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
531: (p_wcnt_chg_params.bucket_dim).fact_viewby_col);
532:
533: /* Set buckets table */
534: IF (p_wcnt_chg_params.bucket_dim = 'HRI_LOW+HRI_LOW_BAND_X') THEN

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

531: (p_wcnt_chg_params.bucket_dim).fact_viewby_col);
532:
533: /* Set buckets table */
534: IF (p_wcnt_chg_params.bucket_dim = 'HRI_LOW+HRI_LOW_BAND_X') THEN
535: hri_mtdt_dim_lvl.set_low_band_buckets(p_parameter_rec.wkth_wktyp_sk_fk);
536: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
537: ELSIF (p_wcnt_chg_params.bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
538: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
539: ELSIF (p_wcnt_chg_params.bucket_dim = 'JOB+PRIMARY_JOB_ROLE') THEN

Line 536: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;

532:
533: /* Set buckets table */
534: IF (p_wcnt_chg_params.bucket_dim = 'HRI_LOW+HRI_LOW_BAND_X') THEN
535: hri_mtdt_dim_lvl.set_low_band_buckets(p_parameter_rec.wkth_wktyp_sk_fk);
536: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
537: ELSIF (p_wcnt_chg_params.bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
538: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
539: ELSIF (p_wcnt_chg_params.bucket_dim = 'JOB+PRIMARY_JOB_ROLE') THEN
540: l_bucket_tab := hri_mtdt_dim_lvl.g_primary_job_role_tab;

Line 538: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;

534: IF (p_wcnt_chg_params.bucket_dim = 'HRI_LOW+HRI_LOW_BAND_X') THEN
535: hri_mtdt_dim_lvl.set_low_band_buckets(p_parameter_rec.wkth_wktyp_sk_fk);
536: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
537: ELSIF (p_wcnt_chg_params.bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
538: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
539: ELSIF (p_wcnt_chg_params.bucket_dim = 'JOB+PRIMARY_JOB_ROLE') THEN
540: l_bucket_tab := hri_mtdt_dim_lvl.g_primary_job_role_tab;
541: ELSIF (p_wcnt_chg_params.bucket_dim = 'HRI_PRSNTYP+HRI_WKTH_WKTYP') THEN
542: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;

Line 540: l_bucket_tab := hri_mtdt_dim_lvl.g_primary_job_role_tab;

536: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
537: ELSIF (p_wcnt_chg_params.bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
538: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
539: ELSIF (p_wcnt_chg_params.bucket_dim = 'JOB+PRIMARY_JOB_ROLE') THEN
540: l_bucket_tab := hri_mtdt_dim_lvl.g_primary_job_role_tab;
541: ELSIF (p_wcnt_chg_params.bucket_dim = 'HRI_PRSNTYP+HRI_WKTH_WKTYP') THEN
542: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;
543: END IF;
544:

Line 542: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;

538: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
539: ELSIF (p_wcnt_chg_params.bucket_dim = 'JOB+PRIMARY_JOB_ROLE') THEN
540: l_bucket_tab := hri_mtdt_dim_lvl.g_primary_job_role_tab;
541: ELSIF (p_wcnt_chg_params.bucket_dim = 'HRI_PRSNTYP+HRI_WKTH_WKTYP') THEN
542: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;
543: END IF;
544:
545: /* Loop through buckets table to add required columns */
546: FOR i IN l_bucket_tab.FIRST..l_bucket_tab.LAST LOOP

Line 852: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

848: /**************************/
849:
850: l_fact_sql :=
851: 'SELECT /*+ NO_MERGE INDEX(wcnt) */
852: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
853: (p_parameter_rec.view_by).fact_viewby_col || ' vby_id
854: ,' || l_direct_ind || ' direct_ind ' || g_rtn ||
855: l_col_list ||
856: 'FROM' || g_rtn ||

Line 862: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

858: p_fact_conditions ||
859: l_date_condition ||
860: l_snapshot_condition ||
861: 'GROUP BY
862: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
863: (p_parameter_rec.view_by).fact_viewby_col || g_rtn ||
864: ',' || l_direct_ind;
865:
866: RETURN l_fact_sql;