APPS.BSC_BIS_DIMENSION_PUB dependencies on BSC_KPIS_B

Line 97: ( p_indicator BSC_KPIS_B.indicator%TYPE ,

93: TYPE Dim_Obj_Table_Type IS TABLE OF Dim_Obj_Relations_Type INDEX BY BINARY_INTEGER;
94: /*********************************************************************************/
95:
96: TYPE dimobj_objective_kpis_type IS RECORD
97: ( p_indicator BSC_KPIS_B.indicator%TYPE ,
98: p_kpi_measure_id BSC_DB_DATASET_DIM_SETS_V.kpi_measure_id%TYPE,
99: p_short_name BSC_SYS_DIM_LEVELS_B.short_name%TYPE
100: );
101: TYPE dimobj_obj_kpis_tbl_type IS TABLE OF dimobj_objective_kpis_type INDEX BY BINARY_INTEGER;

Line 123: p_obj_id IN bsc_kpis_b.indicator%TYPE,

119:
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:

Line 131: p_indicator IN bsc_kpis_b.indicator%TYPE,

127:
128: FUNCTION get_kpi_flag_change (
129: p_old_default IN VARCHAR2,
130: p_new_default IN VARCHAR2,
131: p_indicator IN bsc_kpis_b.indicator%TYPE,
132: p_dim_obj_objs_tbl IN OUT NOCOPY BSC_BIS_DIMENSION_PUB.dimobj_obj_kpis_tbl_type
133: )
134: RETURN NUMBER;
135:

Line 724: , BSC_KPIS_B B

720: SELECT DISTINCT A.indicator INDICATOR
721: , A.dim_set_id DIM_SET_ID
722: , A.Dim_Group_Index
723: FROM BSC_KPI_DIM_GROUPS A
724: , BSC_KPIS_B B
725: WHERE A.INDICATOR = B.INDICATOR
726: AND B.share_flag <> 2
727: AND A.dim_group_id = p_dim_group_id
728: ORDER BY A.Dim_Group_Index;

Line 4450: , BSC_KPIS_B B

4446: SELECT DISTINCT A.indicator INDICATOR
4447: , A.dim_set_id DIM_SET_ID
4448: , A.Dim_Group_Index
4449: FROM BSC_KPI_DIM_GROUPS A
4450: , BSC_KPIS_B B
4451: WHERE A.INDICATOR = B.INDICATOR
4452: AND B.share_flag <> 2
4453: AND A.dim_group_id = l_dim_group_id
4454: ORDER BY A.Dim_Group_Index;

Line 4637: p_obj_id IN bsc_kpis_b.indicator%TYPE,

4633:
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;

Line 4677: p_indicator IN bsc_kpis_b.indicator%TYPE,

4673:
4674: FUNCTION get_kpi_flag_change (
4675: p_old_default IN VARCHAR2,
4676: p_new_default IN VARCHAR2,
4677: p_indicator IN bsc_kpis_b.indicator%TYPE,
4678: p_dim_obj_objs_tbl IN OUT NOCOPY BSC_BIS_DIMENSION_PUB.dimobj_obj_kpis_tbl_type
4679: )
4680: RETURN NUMBER IS
4681:

Line 4696: FROM bsc_kpis_b WHERE

4692:
4693: BEGIN
4694:
4695: SELECT count(0) INTO l_count
4696: FROM bsc_kpis_b WHERE
4697: indicator = p_indicator;
4698: l_result := BSC_DESIGNER_PVT.G_ActionFlag.Normal;
4699:
4700: IF (l_count = 1) THEN