APPS.BSC_BIS_DIMENSION_PUB dependencies on BSC_KPI_MEASURE_PROPS

Line 75: REM | BSC_KPI_MEASURE_PROPS table |

71: REM | 15-JUN-2006 ashankar Bug#5254737 Made changes to Create_Dimension |
72: REM | Method.Removed the parameter value 'TRUE' in |
73: REM | FND_MESSAGE.SET_TOKEN API |
74: REM | 27-Jun-07 ashankar Bug#6134149 synching up the dim obj props to |
75: REM | BSC_KPI_MEASURE_PROPS table |
76: REM | 02-AUG-07 psomesul B#6168487-Handling dim. object comparison settings |
77: REM +=======================================================================+
78: */
79: CONFIG_LIMIT_DIM CONSTANT NUMBER := 8;

Line 124: p_kpi_measure_id IN bsc_kpi_measure_props.kpi_measure_id%TYPE

120: FUNCTION is_color_change_required (
121: p_old_default IN VARCHAR2,
122: p_new_default IN VARCHAR2,
123: p_obj_id IN bsc_kpis_b.indicator%TYPE,
124: p_kpi_measure_id IN bsc_kpi_measure_props.kpi_measure_id%TYPE
125: )
126: RETURN NUMBER;
127:
128: FUNCTION get_kpi_flag_change (

Line 1568: l_kpi_measure_props_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;

1564: SELECT Default_Value
1565: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
1566: WHERE Dim_Group_Id = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;
1567:
1568: l_kpi_measure_props_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;
1569:
1570: CURSOR c_kpi_meas_props IS
1571: SELECT a.indicator,
1572: a.kpi_measure_id

Line 1912: BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props

1908: IF(p_default_value='C') THEN
1909: l_kpi_measure_props_rec.color_by_total := 0;
1910: END IF;
1911:
1912: BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props
1913: (
1914: p_commit => FND_API.G_FALSE
1915: , p_kpi_measure_rec => l_kpi_measure_props_rec
1916: , p_cascade_shared => TRUE

Line 3834: bsc_kpi_measure_props c

3830: a.kpi_measure_id,
3831: c.color_by_total
3832: FROM bsc_db_dataset_dim_sets_v a,
3833: bsc_kpi_dim_levels_vl b,
3834: bsc_kpi_measure_props c
3835: WHERE a.indicator =b.indicator
3836: AND a.dim_set_id =b.dim_set_id
3837: AND c.indicator = a.indicator
3838: AND c.kpi_measure_id = a.kpi_measure_id

Line 4638: p_kpi_measure_id IN bsc_kpi_measure_props.kpi_measure_id%TYPE

4634: FUNCTION is_color_change_required (
4635: p_old_default IN VARCHAR2,
4636: p_new_default IN VARCHAR2,
4637: p_obj_id IN bsc_kpis_b.indicator%TYPE,
4638: p_kpi_measure_id IN bsc_kpi_measure_props.kpi_measure_id%TYPE
4639: )
4640: RETURN NUMBER IS
4641: l_color_change NUMBER;
4642: CURSOR c_kpi_color IS

Line 4644: FROM bsc_kpi_measure_props c

4640: RETURN NUMBER IS
4641: l_color_change NUMBER;
4642: CURSOR c_kpi_color IS
4643: SELECT c.color_by_total
4644: FROM bsc_kpi_measure_props c
4645: WHERE c.indicator = p_obj_id
4646: AND c.kpi_measure_id = p_kpi_measure_id;
4647:
4648: BEGIN