APPS.BSC_BIS_KPI_CRUD_PUB dependencies on BSC_SYS_DIM_GROUPS_VL

Line 4523: from bsc_sys_dim_groups_vl

4519: select dim_group_id, dim_level_id, dim_level_index
4520: from bsc_sys_dim_levels_by_group
4521: where dim_group_id in
4522: (select dim_group_id
4523: from bsc_sys_dim_groups_vl
4524: where short_name = p_Dim_Short_Name);*/
4525:
4526:
4527: BEGIN

Line 5687: FROM BSC_SYS_DIM_GROUPS_VL

5683: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
5684: WHERE DIM_GROUP_ID IN
5685: (
5686: SELECT DIM_GROUP_ID
5687: FROM BSC_SYS_DIM_GROUPS_VL
5688: WHERE SHORT_NAME = l_Dimension_Short_Name
5689: );
5690:
5691:

Line 6302: FROM BSC_SYS_DIM_GROUPS_VL DG

6298: ) IS
6299:
6300: CURSOR c_Dim_Obj_Short_Name IS
6301: SELECT DO.SHORT_NAME
6302: FROM BSC_SYS_DIM_GROUPS_VL DG
6303: , BSC_SYS_DIM_LEVELS_BY_GROUP DD
6304: , BSC_SYS_DIM_LEVELS_B DO
6305: WHERE DG.DIM_GROUP_ID = DD.DIM_GROUP_ID
6306: AND DD.DIM_LEVEL_ID = DO.DIM_LEVEL_ID

Line 6319: FROM BSC_SYS_DIM_GROUPS_VL

6315: x_Time_Dim_Obj_Counter := 0;
6316: x_Non_Time_Dim_Obj_Counter := 0;
6317:
6318: SELECT COUNT(1) INTO l_Count
6319: FROM BSC_SYS_DIM_GROUPS_VL
6320: WHERE SHORT_NAME = p_Dim_Short_Name;
6321:
6322: IF l_Count = 0 THEN
6323: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_SHORT_NAME');

Line 6383: FROM BSC_SYS_DIM_GROUPS_VL DG,

6379: BEGIN
6380: NULL;
6381: SELECT DECODE(COUNT(1), 0, FND_API.G_FALSE, FND_API.G_TRUE)
6382: INTO l_Is_Time_Dim_Obj
6383: FROM BSC_SYS_DIM_GROUPS_VL DG,
6384: BSC_SYS_DIM_LEVELS_BY_GROUP DD,
6385: BSC_SYS_DIM_LEVELS_B DO
6386: WHERE DG.DIM_GROUP_ID = DD.DIM_GROUP_ID
6387: AND DD.DIM_LEVEL_ID = DO.DIM_LEVEL_ID

Line 6410: FROM BSC_SYS_DIM_GROUPS_VL DG,

6406: x_Is_Time_Dim_Obj := NULL;
6407:
6408: SELECT DECODE(COUNT(1), 0, FND_API.G_FALSE, FND_API.G_TRUE)
6409: INTO x_Is_Time_Dim_Obj
6410: FROM BSC_SYS_DIM_GROUPS_VL DG,
6411: BSC_SYS_DIM_LEVELS_BY_GROUP DD,
6412: BSC_SYS_DIM_LEVELS_B DO
6413: WHERE DG.DIM_GROUP_ID = DD.DIM_GROUP_ID
6414: AND DD.DIM_LEVEL_ID = DO.DIM_LEVEL_ID

Line 8752: FROM BSC_SYS_DIM_GROUPS_VL G

8748: -- Added for Bug#5081180 to ensure Delete_Dimension API is not called when
8749: -- the Dimension does not exist.
8750:
8751: SELECT COUNT(1) INTO l_Count
8752: FROM BSC_SYS_DIM_GROUPS_VL G
8753: WHERE G.SHORT_NAME = p_Region_Code;
8754:
8755: IF ((p_Delete_Dimensions = FND_API.G_TRUE) AND (l_Count <> 0)) THEN
8756: BSC_BIS_DIMENSION_PUB.Delete_Dimension

Line 10272: l_Region_Code BSC_SYS_DIM_GROUPS_VL.SHORT_NAME%TYPE;

10268: -- Returns the Dimension Object group created for this Dashboard.
10269: FUNCTION Get_Param_Portlet_By_Dashboard (
10270: p_Page_Function_Name IN VARCHAR2
10271: ) RETURN VARCHAR2 IS
10272: l_Region_Code BSC_SYS_DIM_GROUPS_VL.SHORT_NAME%TYPE;
10273: BEGIN
10274: SELECT G.SHORT_NAME INTO l_Region_Code
10275: FROM BSC_KPIS_B K,
10276: BSC_KPI_DIM_GROUPS KG,

Line 10277: BSC_SYS_DIM_GROUPS_VL G

10273: BEGIN
10274: SELECT G.SHORT_NAME INTO l_Region_Code
10275: FROM BSC_KPIS_B K,
10276: BSC_KPI_DIM_GROUPS KG,
10277: BSC_SYS_DIM_GROUPS_VL G
10278: WHERE K.SHORT_NAME = p_Page_Function_Name
10279: AND KG.INDICATOR = K.INDICATOR
10280: AND G.DIM_GROUP_ID = KG.DIM_GROUP_ID;
10281:

Line 10922: , BSC_SYS_DIM_GROUPS_VL G

10918:
10919: SELECT COUNT(1) INTO l_Count
10920: FROM BSC_KPIS_B K
10921: , BSC_KPI_DIM_GROUPS KG
10922: , BSC_SYS_DIM_GROUPS_VL G
10923: WHERE
10924: K.INDICATOR = p_Kpi_Id
10925: AND G.SHORT_NAME = p_Dimension_Short_Name
10926: AND KG.INDICATOR = K.INDICATOR

Line 11262: FROM BSC_SYS_DIM_GROUPS_VL GP,

11258: , x_Msg_Data OUT NOCOPY VARCHAR2
11259: ) IS
11260: CURSOR c_Objective_List IS
11261: SELECT KP.NAME || '[' || KP.INDICATOR || ']' NAME
11262: FROM BSC_SYS_DIM_GROUPS_VL GP,
11263: BSC_KPI_DIM_GROUPS KG,
11264: BSC_KPIS_VL KP
11265: WHERE GP.SHORT_NAME = p_Region_Code
11266: AND KG.DIM_GROUP_ID = GP.DIM_GROUP_ID

Line 11318: FROM BSC_SYS_DIM_GROUPS_VL GP,

11314: l_Is_XTD_Enabled VARCHAR2(1);
11315:
11316: CURSOR c_Objective_List IS
11317: SELECT KP.INDICATOR
11318: FROM BSC_SYS_DIM_GROUPS_VL GP,
11319: BSC_KPI_DIM_GROUPS KG,
11320: BSC_KPIS_VL KP
11321: WHERE GP.SHORT_NAME = p_Region_Code
11322: AND KG.DIM_GROUP_ID = GP.DIM_GROUP_ID