[Home] [Help]
2159: WHERE SHORT_NAME = p_Entity_Short_Name;
2160: ELSE
2161: SELECT NAME
2162: INTO l_name
2163: FROM BSC_SYS_DIM_GROUPS_VL
2164: WHERE SHORT_NAME = p_Entity_Short_Name;
2165: END IF;
2166: RETURN l_name;
2167: END;
2214: RETURN VARCHAR2 IS
2215: l_Count NUMBER;
2216: BEGIN
2217: SELECT COUNT(1) INTO l_Count
2218: FROM BSC_SYS_DIM_GROUPS_VL B
2219: , BSC_KPIS_B K
2220: , BSC_KPI_DIM_GROUPS G
2221: WHERE B.SHORT_NAME = p_Short_Name
2222: AND K.SHORT_NAME = B.SHORT_NAME
2235: l_Count NUMBER;
2236: BEGIN
2237: SELECT COUNT(1)
2238: INTO l_Count
2239: FROM BSC_SYS_DIM_GROUPS_VL d,
2240: BSC_KPI_DIM_GROUPS k
2241: WHERE d.DIM_GROUP_ID = k.DIM_GROUP_ID
2242: AND BSC_BIS_DIMENSION_PUB.Get_Dimension_Source(d.SHORT_NAME)=BSC_UTILITY.c_PMF
2243: AND d.SHORT_NAME=p_Short_Name;