APPS.BSC_UPDATE_DIM dependencies on BSC_KPI_DIM_LEVELS_B

Line 1558: from bsc_kpi_dim_levels_b

1554: h_aw_impl_type := 2;
1555:
1556: select count(level_table_name)
1557: into h_count
1558: from bsc_kpi_dim_levels_b
1559: where indicator in (
1560: select p.indicator
1561: from bsc_kpi_properties p, bsc_kpis_b k
1562: where p.indicator = k.indicator and

Line 1594: from bsc_kpi_dim_levels_b

1590: h_mv_impl_type := 1;
1591:
1592: select count(level_table_name)
1593: into h_count
1594: from bsc_kpi_dim_levels_b
1595: where indicator in (
1596: select k.indicator
1597: from bsc_kpi_properties p, bsc_kpis_b k
1598: where p.indicator (+) = k.indicator and

Line 3750: FROM BSC_KPI_DIM_LEVELS_B D

3746: SET PROTOTYPE_FLAG = 6,
3747: LAST_UPDATED_BY = BSC_APPS.fnd_global_user_id,
3748: LAST_UPDATE_DATE = SYSDATE
3749: WHERE INDICATOR IN (SELECT D.INDICATOR
3750: FROM BSC_KPI_DIM_LEVELS_B D
3751: WHERE K.INDICATOR = D.INDICATOR AND
3752: (D.LEVEL_TABLE_NAME = x_dim_table OR
3753: D.TABLE_RELATION = x_dim_table)) AND
3754: PROTOTYPE_FLAG in (0, 6, 7);

Line 3760: FROM bsc_kpi_dim_levels_b d

3756: -- Color By KPI: Mark KPIs for color re-calculation
3757: UPDATE bsc_kpi_analysis_measures_b k
3758: SET prototype_flag = BSC_DESIGNER_PVT.C_COLOR_CHANGE -- 7
3759: WHERE indicator IN (SELECT d.indicator
3760: FROM bsc_kpi_dim_levels_b d
3761: WHERE k.indicator = d.indicator
3762: AND (d.level_table_name = x_dim_table
3763: OR d.table_relation = x_dim_table));
3764:

Line 4762: FROM BSC_KPI_DIM_LEVELS_B D

4758: SET PROTOTYPE_FLAG = 6,
4759: LAST_UPDATED_BY = BSC_APPS.fnd_global_user_id,
4760: LAST_UPDATE_DATE = SYSDATE
4761: WHERE INDICATOR IN (SELECT D.INDICATOR
4762: FROM BSC_KPI_DIM_LEVELS_B D
4763: WHERE K.INDICATOR = D.INDICATOR AND
4764: D.LEVEL_TABLE_NAME = h_mod_dimensions(h_i)) AND
4765: PROTOTYPE_FLAG in (0, 6, 7);
4766:

Line 4771: FROM bsc_kpi_dim_levels_b d

4767: -- Color By KPI: Mark KPIs for color re-calculation
4768: UPDATE bsc_kpi_analysis_measures_b k
4769: SET prototype_flag = BSC_DESIGNER_PVT.C_COLOR_CHANGE -- 7
4770: WHERE indicator IN (SELECT d.indicator
4771: FROM bsc_kpi_dim_levels_b d
4772: WHERE k.indicator = d.indicator
4773: AND d.level_table_name = h_mod_dimensions(h_i));
4774:
4775: COMMIT;

Line 5113: ' FROM bsc_kpi_dim_levels_b d, bsc_kpis_b k'||

5109:
5110: /*
5111: c_indicators t_cursor;
5112: c_indicators_sql VARCHAR2(2000) := 'SELECT d.indicator, d.level_table_name, d.default_key_value'||
5113: ' FROM bsc_kpi_dim_levels_b d, bsc_kpis_b k'||
5114: ' WHERE d.indicator = k.indicator AND'||
5115: ' d.default_key_value IS NOT NULL';
5116: */
5117: CURSOR c_indicators IS

Line 5119: FROM bsc_kpi_dim_levels_b d, bsc_kpis_b k

5115: ' d.default_key_value IS NOT NULL';
5116: */
5117: CURSOR c_indicators IS
5118: SELECT d.indicator, d.level_table_name, d.default_key_value
5119: FROM bsc_kpi_dim_levels_b d, bsc_kpis_b k
5120: WHERE d.indicator = k.indicator AND
5121: d.default_key_value IS NOT NULL;
5122:
5123: h_indicator NUMBER;

Line 5124: h_level_table_name bsc_kpi_dim_levels_b.level_table_name%TYPE;

5120: WHERE d.indicator = k.indicator AND
5121: d.default_key_value IS NOT NULL;
5122:
5123: h_indicator NUMBER;
5124: h_level_table_name bsc_kpi_dim_levels_b.level_table_name%TYPE;
5125: h_default_key_value bsc_kpi_dim_levels_b.default_key_value%TYPE;
5126:
5127: h_sql VARCHAR2(32700);
5128:

Line 5125: h_default_key_value bsc_kpi_dim_levels_b.default_key_value%TYPE;

5121: d.default_key_value IS NOT NULL;
5122:
5123: h_indicator NUMBER;
5124: h_level_table_name bsc_kpi_dim_levels_b.level_table_name%TYPE;
5125: h_default_key_value bsc_kpi_dim_levels_b.default_key_value%TYPE;
5126:
5127: h_sql VARCHAR2(32700);
5128:
5129: h_code NUMBER;