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

Line 261: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

257:
258: /* Dynamically set conditions for parameter */
259: p_fact_conditions := p_fact_conditions || g_rtn ||
260: 'AND wrkfc.' ||
261: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
262: (l_parameter_name).fact_viewby_col ||
263: ' IN (' || g_binds(l_parameter_name) || ')';
264:
265: /* Keep count of parameters set and last parameter used */

Line 374: l_wrkfc_prm_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

370: /* Set the local variables for which fact table to use based on whether */
371: /* snapshots are available for the given manager or not */
372: IF (p_use_snapshot) THEN
373: IF (p_single_param IS NOT NULL) THEN
374: l_wrkfc_prm_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
375: (p_single_param).sup_lvl_wrkfc_mv_snp;
376: END IF;
377: l_wrkfc_sup_table := 'hri_mds_sup_wmv_sup_mv';
378: l_wrkfc_vby_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

Line 378: l_wrkfc_vby_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

374: l_wrkfc_prm_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
375: (p_single_param).sup_lvl_wrkfc_mv_snp;
376: END IF;
377: l_wrkfc_sup_table := 'hri_mds_sup_wmv_sup_mv';
378: l_wrkfc_vby_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
379: (p_parameter_rec.view_by).sup_lvl_wrkfc_mv_snp;
380: l_wrkfc_pvt_table := 'hri_mdp_sup_wrkfc_cjer_mv';
381:
382: IF (l_bucket_dim IS NOT NULL) THEN

Line 383: l_wrkfc_bkt_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

379: (p_parameter_rec.view_by).sup_lvl_wrkfc_mv_snp;
380: l_wrkfc_pvt_table := 'hri_mdp_sup_wrkfc_cjer_mv';
381:
382: IF (l_bucket_dim IS NOT NULL) THEN
383: l_wrkfc_bkt_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
384: (l_bucket_dim).sup_lvl_wrkfc_mv_snp;
385: END IF;
386: ELSE
387: IF (p_single_param IS NOT NULL) THEN

Line 388: l_wrkfc_prm_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

384: (l_bucket_dim).sup_lvl_wrkfc_mv_snp;
385: END IF;
386: ELSE
387: IF (p_single_param IS NOT NULL) THEN
388: l_wrkfc_prm_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
389: (p_single_param).sup_lvl_wrkfc_mv_name;
390: END IF;
391: l_wrkfc_sup_table := 'hri_mdp_sup_wcnt_sup_mv';
392: l_wrkfc_vby_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

Line 392: l_wrkfc_vby_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

388: l_wrkfc_prm_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
389: (p_single_param).sup_lvl_wrkfc_mv_name;
390: END IF;
391: l_wrkfc_sup_table := 'hri_mdp_sup_wcnt_sup_mv';
392: l_wrkfc_vby_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
393: (p_parameter_rec.view_by).sup_lvl_wrkfc_mv_name;
394: l_wrkfc_pvt_table := 'hri_mdp_sup_wrkfc_cjer_mv';
395:
396: IF (l_bucket_dim IS NOT NULL) THEN

Line 397: l_wrkfc_bkt_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

393: (p_parameter_rec.view_by).sup_lvl_wrkfc_mv_name;
394: l_wrkfc_pvt_table := 'hri_mdp_sup_wrkfc_cjer_mv';
395:
396: IF (l_bucket_dim IS NOT NULL) THEN
397: l_wrkfc_bkt_table := hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
398: (l_bucket_dim).sup_lvl_wrkfc_mv_name;
399: END IF;
400: END IF;
401:

Line 550: l_bucket_tab hri_mtdt_dim_lvl.dim_lvl_buckets_tabtype;

546: RETURN VARCHAR2 IS
547:
548: l_column_list VARCHAR2(5000);
549: l_bucket_condition VARCHAR2(1000);
550: l_bucket_tab hri_mtdt_dim_lvl.dim_lvl_buckets_tabtype;
551:
552: /* Column Templates */
553: l_select_column VARCHAR2(1000);
554: l_bucket_column VARCHAR2(1000);

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

601:
602: /* Get a pl/sql table containing the bucket ids for the given */
603: /* bucket dimension */
604: IF (p_bucket_dim = 'HRI_LOW+HRI_LOW_BAND_X') THEN
605: hri_mtdt_dim_lvl.set_low_band_buckets(p_parameter_rec.wkth_wktyp_sk_fk);
606: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
607: ELSIF (p_bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
608: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
609: ELSIF (p_bucket_dim = 'JOB+PRIMARY_JOB_ROLE') THEN

Line 606: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;

602: /* Get a pl/sql table containing the bucket ids for the given */
603: /* bucket dimension */
604: IF (p_bucket_dim = 'HRI_LOW+HRI_LOW_BAND_X') THEN
605: hri_mtdt_dim_lvl.set_low_band_buckets(p_parameter_rec.wkth_wktyp_sk_fk);
606: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
607: ELSIF (p_bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
608: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
609: ELSIF (p_bucket_dim = 'JOB+PRIMARY_JOB_ROLE') THEN
610: l_bucket_tab := hri_mtdt_dim_lvl.g_primary_job_role_tab;

Line 608: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;

604: IF (p_bucket_dim = 'HRI_LOW+HRI_LOW_BAND_X') THEN
605: hri_mtdt_dim_lvl.set_low_band_buckets(p_parameter_rec.wkth_wktyp_sk_fk);
606: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
607: ELSIF (p_bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
608: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
609: ELSIF (p_bucket_dim = 'JOB+PRIMARY_JOB_ROLE') THEN
610: l_bucket_tab := hri_mtdt_dim_lvl.g_primary_job_role_tab;
611: ELSIF (p_bucket_dim = 'HRI_PRSNTYP+HRI_WKTH_WKTYP') THEN
612: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;

Line 610: l_bucket_tab := hri_mtdt_dim_lvl.g_primary_job_role_tab;

606: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
607: ELSIF (p_bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
608: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
609: ELSIF (p_bucket_dim = 'JOB+PRIMARY_JOB_ROLE') THEN
610: l_bucket_tab := hri_mtdt_dim_lvl.g_primary_job_role_tab;
611: ELSIF (p_bucket_dim = 'HRI_PRSNTYP+HRI_WKTH_WKTYP') THEN
612: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;
613: END IF;
614:

Line 612: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;

608: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
609: ELSIF (p_bucket_dim = 'JOB+PRIMARY_JOB_ROLE') THEN
610: l_bucket_tab := hri_mtdt_dim_lvl.g_primary_job_role_tab;
611: ELSIF (p_bucket_dim = 'HRI_PRSNTYP+HRI_WKTH_WKTYP') THEN
612: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;
613: END IF;
614:
615: /* Loop through bucket ids to add required columns */
616: FOR i IN l_bucket_tab.FIRST..l_bucket_tab.LAST LOOP

Line 684: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

680:
681: /* Set bucket column if applicable */
682: IF (p_wrkfc_params.bucket_dim IS NOT NULL) THEN
683: l_template_bucket := REPLACE(g_template_bucket, '',
684: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
685: (p_wrkfc_params.bucket_dim).fact_viewby_col);
686: l_template_total_bucket := REPLACE(l_template_total_bucket, '',
687: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
688: (p_wrkfc_params.bucket_dim).fact_viewby_col);

Line 687: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

683: l_template_bucket := REPLACE(g_template_bucket, '',
684: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
685: (p_wrkfc_params.bucket_dim).fact_viewby_col);
686: l_template_total_bucket := REPLACE(l_template_total_bucket, '',
687: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
688: (p_wrkfc_params.bucket_dim).fact_viewby_col);
689: END IF;
690:
691: /* Set whether or not to sample the measure value at period start dates */

Line 899: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

895:
896: /* Add bucket column to select clause if applicable */
897: IF (p_wrkfc_params.bucket_dim IS NOT NULL) THEN
898: l_inner_col_list := l_inner_col_list || ',' ||
899: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
900: (p_wrkfc_params.bucket_dim).fact_viewby_col || g_rtn;
901: END IF;
902:
903: /* Build up SELECT column list */

Line 981: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

977: /* Dynamically built column list */
978: l_outer_col_list ||
979: 'FROM (
980: SELECT /*+ ORDERED INDEX(wrkfc) */
981: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
982: (p_parameter_rec.view_by).fact_viewby_col || ' vby_id
983: ,cal.id effective_date
984: ,' || l_direct_ind || ' direct_ind ' || g_rtn ||
985: l_inner_col_list ||

Line 1011: p_bucket_tab IN hri_mtdt_dim_lvl.dim_lvl_buckets_tabtype)

1007: p_column_template IN VARCHAR2,
1008: p_total_template IN VARCHAR2,
1009: p_bucket_template IN VARCHAR2,
1010: p_bucket_dim IN VARCHAR2,
1011: p_bucket_tab IN hri_mtdt_dim_lvl.dim_lvl_buckets_tabtype)
1012: RETURN VARCHAR2 IS
1013:
1014: l_col_list VARCHAR2(10000);
1015:

Line 1147: l_bucket_tab hri_mtdt_dim_lvl.dim_lvl_buckets_tabtype;

1143: /* Whether to format the SQL for the view by manager special case */
1144: l_view_by_manager BOOLEAN;
1145:
1146: /* Table of bucket values */
1147: l_bucket_tab hri_mtdt_dim_lvl.dim_lvl_buckets_tabtype;
1148:
1149: /* Column templates */
1150: l_column_template VARCHAR2(1000);
1151: l_total_template VARCHAR2(1000);

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

1192:
1193: /* Get a pl/sql table containing the bucket ids for the given */
1194: /* bucket dimension */
1195: IF (p_wrkfc_params.bucket_dim = 'HRI_LOW+HRI_LOW_BAND_X') THEN
1196: hri_mtdt_dim_lvl.set_low_band_buckets(p_parameter_rec.wkth_wktyp_sk_fk);
1197: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
1198: ELSIF (p_wrkfc_params.bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
1199: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
1200: ELSIF (p_wrkfc_params.bucket_dim = 'JOB+PRIMARY_JOB_ROLE') THEN

Line 1197: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;

1193: /* Get a pl/sql table containing the bucket ids for the given */
1194: /* bucket dimension */
1195: IF (p_wrkfc_params.bucket_dim = 'HRI_LOW+HRI_LOW_BAND_X') THEN
1196: hri_mtdt_dim_lvl.set_low_band_buckets(p_parameter_rec.wkth_wktyp_sk_fk);
1197: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
1198: ELSIF (p_wrkfc_params.bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
1199: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
1200: ELSIF (p_wrkfc_params.bucket_dim = 'JOB+PRIMARY_JOB_ROLE') THEN
1201: l_bucket_tab := hri_mtdt_dim_lvl.g_primary_job_role_tab;

Line 1199: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;

1195: IF (p_wrkfc_params.bucket_dim = 'HRI_LOW+HRI_LOW_BAND_X') THEN
1196: hri_mtdt_dim_lvl.set_low_band_buckets(p_parameter_rec.wkth_wktyp_sk_fk);
1197: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
1198: ELSIF (p_wrkfc_params.bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
1199: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
1200: ELSIF (p_wrkfc_params.bucket_dim = 'JOB+PRIMARY_JOB_ROLE') THEN
1201: l_bucket_tab := hri_mtdt_dim_lvl.g_primary_job_role_tab;
1202: ELSIF (p_wrkfc_params.bucket_dim = 'HRI_PRSNTYP+HRI_WKTH_WKTYP') THEN
1203: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;

Line 1201: l_bucket_tab := hri_mtdt_dim_lvl.g_primary_job_role_tab;

1197: l_bucket_tab := hri_mtdt_dim_lvl.g_low_band_buckets_tab;
1198: ELSIF (p_wrkfc_params.bucket_dim = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X') THEN
1199: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
1200: ELSIF (p_wrkfc_params.bucket_dim = 'JOB+PRIMARY_JOB_ROLE') THEN
1201: l_bucket_tab := hri_mtdt_dim_lvl.g_primary_job_role_tab;
1202: ELSIF (p_wrkfc_params.bucket_dim = 'HRI_PRSNTYP+HRI_WKTH_WKTYP') THEN
1203: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;
1204: END IF;
1205:

Line 1203: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;

1199: l_bucket_tab := hri_mtdt_dim_lvl.g_prfmnc_band_buckets_tab;
1200: ELSIF (p_wrkfc_params.bucket_dim = 'JOB+PRIMARY_JOB_ROLE') THEN
1201: l_bucket_tab := hri_mtdt_dim_lvl.g_primary_job_role_tab;
1202: ELSIF (p_wrkfc_params.bucket_dim = 'HRI_PRSNTYP+HRI_WKTH_WKTYP') THEN
1203: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;
1204: END IF;
1205:
1206: l_bucket_template :=
1207: 'CASE WHEN ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

Line 1207: 'CASE WHEN ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

1203: l_bucket_tab := hri_mtdt_dim_lvl.g_wkth_wktyp_tab;
1204: END IF;
1205:
1206: l_bucket_template :=
1207: 'CASE WHEN ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
1208: (p_wrkfc_params.bucket_dim).fact_viewby_col || ' =
1209: THEN ' || l_column_template || '
1210: ELSE 0
1211: END';

Line 1316: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

1312: /**************************/
1313:
1314: l_sql_string :=
1315: 'SELECT /*+ NO_MERGE ORDERED INDEX(wrkfc) */
1316: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
1317: (p_parameter_rec.view_by).fact_viewby_col || ' vby_id
1318: ,' || l_direct_ind || ' direct_ind' || g_rtn ||
1319: /* Dynamically built column list */
1320: l_col_list ||

Line 1329: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

1325: AND wrkfc.comparison_type = &TIME_COMPARISON_TYPE' || g_rtn ||
1326: l_where_clause ||
1327: p_fact_conditions ||
1328: 'GROUP BY
1329: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
1330: (p_parameter_rec.view_by).fact_viewby_col || '
1331: ,' || l_direct_ind;
1332:
1333: RETURN l_sql_string;