APPS.BSC_DEFAULT_KEY_ITEM_PUB dependencies on BSC_KPI_DIM_LEVEL_PROPERTIES

Line 293: , p_key_value IN BSC_KPI_DIM_LEVEL_PROPERTIES.default_key_value%TYPE

289: (
290: p_indicator IN BSC_KPIS_B.indicator%TYPE
291: , p_dim_id IN BSC_KPI_DIM_SETS_VL.dim_set_id%TYPE
292: , p_dim_obj_sht_name IN BSC_SYS_DIM_LEVELS_VL.short_name%TYPE
293: , p_key_value IN BSC_KPI_DIM_LEVEL_PROPERTIES.default_key_value%TYPE
294: , x_return_status OUT NOCOPY VARCHAR2
295: , x_msg_count OUT NOCOPY NUMBER
296: , x_msg_data OUT NOCOPY VARCHAR2
297: )IS

Line 486: FROM bsc_kpi_dim_level_properties

482: IF (l_dim_set_id IS NOT NULL AND l_dim_level_id IS NOT NULL AND l_dim_level_index IS NOT NULL AND l_def_key_id <> l_init_def_key_id) THEN
483:
484: SELECT count(0)
485: INTO l_count
486: FROM bsc_kpi_dim_level_properties
487: WHERE indicator = p_kpi_id
488: AND dim_set_id = l_dim_set_id
489: AND dim_level_id= l_dim_level_id;
490:

Line 521: UPDATE bsc_kpi_dim_level_properties

517: AND dim_level_index = l_dim_level_index;
518:
519: IF (l_count > 0) THEN
520:
521: UPDATE bsc_kpi_dim_level_properties
522: SET default_key_value = l_def_key_id
523: WHERE indicator = p_kpi_id
524: AND dim_set_id = l_dim_set_id
525: AND dim_level_id = l_dim_level_id;