DBA Data[Home] [Help]

APPS.BSC_BIS_DIMENSION_PUB dependencies on BSC_SYS_DIM_LEVELS_BY_GROUP

Line 291: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

287: l_flag BOOLEAN := FALSE;
288: l_Count NUMBER := 0;
289: BEGIN
290: SELECT COUNT(1) INTO l_Count
291: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
292: WHERE Dim_Level_Id = p_Dim_Level_Id
293: AND Dim_Group_Id = p_Dim_Grp_Id;
294: IF (l_Count = 0) THEN
295: RETURN FALSE;

Line 311: l_All_Flag BSC_SYS_DIM_LEVELS_BY_GROUP.Total_Flag%TYPE;

307: RETURN NUMBER IS
308: l_Bsc_Dim_Obj_ID BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE;
309: l_Bsc_Group_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
310: l_Dim_Short_Name BIS_DIMENSIONS.Short_Name%TYPE;
311: l_All_Flag BSC_SYS_DIM_LEVELS_BY_GROUP.Total_Flag%TYPE;
312:
313: CURSOR c_Bis_Levels IS
314: SELECT B.Short_Name
315: FROM BIS_LEVELS A

Line 322: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

318: AND A.Dimension_Id = B.Dimension_Id;
319:
320: CURSOR c_All_Pri_Flag IS
321: SELECT Total_Flag
322: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
323: WHERE Dim_Level_Id = l_Bsc_Dim_Obj_ID
324: AND Dim_Group_Id = l_Bsc_Group_ID;
325: BEGIN
326: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Get_Primary_All_Flag procedure');

Line 359: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

355: ) RETURN NUMBER IS
356: l_Count NUMBER := 0;
357: BEGIN
358: SELECT COUNT(Dim_Group_ID) INTO l_Count
359: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
360: WHERE Dim_Level_Id = p_Dim_Level_Id;
361: RETURN l_Count;
362: EXCEPTION
363: WHEN OTHERS THEN

Line 377: l_Total_Flag BSC_SYS_DIM_LEVELS_BY_GROUP.Total_Flag%TYPE := NULL;

373: ) IS
374: l_Bsc_Level_ID BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE;
375: l_Bsc_Group_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
376: l_Dim_Short_Name BIS_DIMENSIONS.Short_Name%TYPE;
377: l_Total_Flag BSC_SYS_DIM_LEVELS_BY_GROUP.Total_Flag%TYPE := NULL;
378:
379: CURSOR c_Bis_Levels IS
380: SELECT B.Short_Name
381: FROM BIS_LEVELS A

Line 388: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

384: AND A.Dimension_Id = B.Dimension_Id;
385:
386: CURSOR c_Total_Flag IS
387: SELECT Total_Flag
388: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
389: WHERE Dim_Group_Id = l_Bsc_Group_ID
390: AND Dim_Level_Id = l_Bsc_Level_ID;
391: BEGIN
392: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Sync_All_Enable_Flag procedure');

Line 414: UPDATE BSC_SYS_DIM_LEVELS_BY_GROUP

410: OPEN c_Total_Flag;
411: FETCH c_Total_Flag INTO l_Total_Flag;
412: CLOSE c_Total_Flag;
413: IF (l_Total_Flag IS NOT NULL) THEN
414: UPDATE BSC_SYS_DIM_LEVELS_BY_GROUP
415: SET Total_Flag = l_Total_Flag
416: WHERE Dim_Level_Id = l_Bsc_Level_ID;
417: END IF;
418: END IF;

Line 468: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

464: AND A.Dimension_Id = B.Dimension_Id;
465:
466: CURSOR c_Dim_Groups IS
467: SELECT Dim_Group_Id
468: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
469: WHERE Dim_Level_Id = l_Bsc_Level_ID
470: ORDER BY Dim_Level_Index DESC;
471:
472: CURSOR c_Dim_Short_Name IS

Line 1229: l_All_Flag BSC_SYS_DIM_LEVELS_BY_GROUP.Total_Flag%TYPE;

1225: ) IS
1226: l_dim_obj_names VARCHAR2(32000);
1227: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
1228: l_Source_Type BSC_SYS_DIM_LEVELS_B.Source%TYPE;
1229: l_All_Flag BSC_SYS_DIM_LEVELS_BY_GROUP.Total_Flag%TYPE;
1230:
1231: l_assigns VARCHAR2(32000);
1232: l_assign BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
1233: l_MTab_Tbl BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type;

Line 1252: , BSC_SYS_DIM_LEVELS_BY_GROUP A

1248: CURSOR c_dim_obj_index IS
1249: SELECT B.Short_Name
1250: , B.Dim_Level_ID
1251: FROM BSC_SYS_DIM_LEVELS_B B
1252: , BSC_SYS_DIM_LEVELS_BY_GROUP A
1253: WHERE A.dim_group_id =
1254: ( SELECT dim_group_id
1255: FROM BSC_SYS_DIM_GROUPS_VL
1256: WHERE Short_Name = p_dim_short_name

Line 1393: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

1389: END LOOP;
1390: l_count := 0;
1391: FOR i IN 0..(l_MTab_DimRels1.COUNT-1) LOOP
1392: SELECT Dim_Level_Index INTO l_original_tab_index
1393: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
1394: WHERE Dim_Group_Id = l_dim_group_id
1395: AND Dim_Level_ID = l_MTab_DimRels1(i).p_dim_obj_id;
1396:
1397: IF (l_original_tab_index <> l_count) THEN

Line 1421: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

1417: WHILE (l_tab_index <= l_count1) LOOP
1418: IF (l_MTab_DimRels2.EXISTS(l_tab_index)) THEN
1419: SELECT Dim_Level_Index
1420: INTO l_original_tab_index
1421: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
1422: WHERE Dim_Group_Id = l_dim_group_id
1423: AND Dim_Level_ID = l_MTab_DimRels2(l_tab_index).p_dim_obj_id;
1424: IF (l_original_tab_index <> l_count) THEN
1425: l_bsc_dimension_rec.Bsc_Dim_Level_Index := l_count;

Line 1556: FROM BSC_SYS_DIM_LEVELS_BY_GROUP B,

1552: SELECT B.Default_Value
1553: , C.Short_Name
1554: , C.Source
1555: , C.Name
1556: FROM BSC_SYS_DIM_LEVELS_BY_GROUP B,
1557: BSC_SYS_DIM_GROUPS_VL V,
1558: BSC_SYS_DIM_LEVELS_VL C
1559: WHERE V.Dim_Group_Id = B.Dim_Group_Id
1560: AND B.Dim_Level_Id = C.Dim_Level_Id

Line 1565: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

1561: AND V.Short_Name = p_Dim_Short_Name;
1562:
1563: CURSOR c_Defaut_Value IS
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:

Line 1612: FROM BSC_SYS_DIM_LEVELS_BY_GROUP B

1608: -- that in a dimension there cannot be more than one dimension object with comparison as the
1609: -- default value
1610: SELECT COUNT(B.DEFAULT_VALUE)
1611: INTO l_count
1612: FROM BSC_SYS_DIM_LEVELS_BY_GROUP B
1613: WHERE B.DIM_GROUP_ID = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id;
1614:
1615: IF (l_count > 1) THEN
1616: l_comp_count := 0;

Line 1676: l_bsc_dimension_rec.Bsc_Group_Level_Total_Flag := p_total_flag; -- BSC_SYS_DIM_LEVELS_BY_GROUP.TOTAL_FLAG, true

1672:
1673: IF ((p_total_flag IS NULL) OR ((p_total_flag <> 0) AND (p_total_flag <> -1))) THEN
1674: l_bsc_dimension_rec.Bsc_Group_Level_Total_Flag := -1;
1675: ELSE
1676: l_bsc_dimension_rec.Bsc_Group_Level_Total_Flag := p_total_flag; -- BSC_SYS_DIM_LEVELS_BY_GROUP.TOTAL_FLAG, true
1677: END IF;
1678: IF (p_dim_obj_short_name IS NOT NULL) THEN
1679: IF (cr_bsc_dim_obj_id%ISOPEN) THEN
1680: CLOSE cr_bsc_dim_obj_id;

Line 1805: UPDATE BSC_SYS_DIM_LEVELS_BY_GROUP

1801: --if Dimension is already assigned to "UNASSIGNED" Dimension
1802: l_Dim_Grp_Id := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(BSC_BIS_DIMENSION_PUB.Unassigned_Dim);
1803: IF (BSC_BIS_DIMENSION_PUB.is_Relation_Exists(l_Dim_Grp_Id, l_bsc_dimension_rec.Bsc_Level_Id)) THEN
1804:
1805: UPDATE BSC_SYS_DIM_LEVELS_BY_GROUP
1806: SET Dim_Group_ID = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
1807: WHERE Dim_Level_ID = l_bsc_dimension_rec.Bsc_Level_Id
1808: AND Dim_Group_ID = l_Dim_Grp_Id;
1809: ELSE

Line 2151: UPDATE BSC_SYS_DIM_LEVELS_BY_GROUP

2147: l_kpi_cascade := TRUE;
2148: IF (l_Dim_Obj_Source = 'PMF') THEN
2149: IF (BSC_BIS_DIMENSION_PUB.Get_Number_Of_Dimensions(l_bsc_dimension_rec.Bsc_Level_Id) = 1) THEN
2150: l_Dim_Grp_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(BSC_BIS_DIMENSION_PUB.Unassigned_Dim);
2151: UPDATE BSC_SYS_DIM_LEVELS_BY_GROUP
2152: SET Dim_Group_Id = l_Dim_Grp_ID
2153: WHERE Dim_Group_Id = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
2154: AND Dim_Level_Id = l_bsc_dimension_rec.Bsc_Level_Id;
2155: END IF;

Line 3129: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

3125: CURSOR cr_bsc_dim IS
3126: SELECT short_name
3127: FROM BSC_SYS_DIM_LEVELS_B
3128: WHERE dim_level_id IN (SELECT dim_level_id
3129: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
3130: WHERE dim_group_id = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id);
3131:
3132: CURSOR cr_indicdimset_for_dimgrp IS
3133: SELECT grp.indicator , grp.dim_set_id,count(kpi.dim_level_index)

Line 3610: , BSC_SYS_DIM_LEVELS_BY_GROUP GP

3606:
3607: CURSOR c_Dim_Obj_Data_Source IS
3608: SELECT VL.Source
3609: FROM BSC_SYS_DIM_GROUPS_TL TL
3610: , BSC_SYS_DIM_LEVELS_BY_GROUP GP
3611: , BSC_SYS_DIM_LEVELS_B VL
3612: WHERE TL.Dim_Group_Id = GP.Dim_Group_Id
3613: AND GP.Dim_Level_Id = VL.Dim_Level_Id
3614: AND TL.Short_Name = p_short_Name;

Line 3803: l_default_Value BSC_SYS_DIM_LEVELS_BY_GROUP.Default_Value%TYPE;

3799: ) RETURN VARCHAR2 IS
3800: l_Msg_Data VARCHAR2(32000);
3801: l_msg_count NUMBER;
3802:
3803: l_default_Value BSC_SYS_DIM_LEVELS_BY_GROUP.Default_Value%TYPE;
3804: l_new_default_Value BSC_SYS_DIM_LEVELS_BY_GROUP.Default_Value%TYPE;
3805: l_Prod_Mode BSC_SYS_INIT.Property_Value%TYPE;
3806: l_Struct_Flag BOOLEAN := FALSE;
3807: l_kpi_names VARCHAR2(32000);

Line 3804: l_new_default_Value BSC_SYS_DIM_LEVELS_BY_GROUP.Default_Value%TYPE;

3800: l_Msg_Data VARCHAR2(32000);
3801: l_msg_count NUMBER;
3802:
3803: l_default_Value BSC_SYS_DIM_LEVELS_BY_GROUP.Default_Value%TYPE;
3804: l_new_default_Value BSC_SYS_DIM_LEVELS_BY_GROUP.Default_Value%TYPE;
3805: l_Prod_Mode BSC_SYS_INIT.Property_Value%TYPE;
3806: l_Struct_Flag BOOLEAN := FALSE;
3807: l_kpi_names VARCHAR2(32000);
3808: l_Dim_Grp_Id BSC_SYS_DIM_GROUPS_VL.Dim_Group_Id%TYPE;

Line 3820: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A

3816: CURSOR c_default_Value IS
3817: SELECT A.Default_Value
3818: , A.Dim_Group_ID
3819: , C.Source
3820: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A
3821: , BSC_SYS_DIM_GROUPS_VL B
3822: , BSC_SYS_DIM_LEVELS_B C
3823: WHERE A.Dim_Group_Id = B.Dim_Group_Id
3824: AND A.Dim_Level_Id = C.Dim_Level_Id

Line 3995: , BSC_SYS_DIM_LEVELS_BY_GROUP B

3991: , B.Dim_Level_Index
3992: , A.Dim_Group_Id
3993: , C.Source
3994: FROM BSC_SYS_DIM_GROUPS_VL A
3995: , BSC_SYS_DIM_LEVELS_BY_GROUP B
3996: , BSC_SYS_DIM_LEVELS_B C
3997: WHERE A.Dim_Group_Id = B.Dim_Group_Id
3998: AND C.Dim_Level_Id = B.Dim_Level_Id
3999: AND A.Short_Name = p_Dim_Short_Name

Line 4169: FROM BSC_SYS_DIM_LEVELS_BY_GROUP B

4165: AND KDL.dim_set_id = l_dim_set_id;
4166:
4167: CURSOR cr_dimobjs_in_dim IS
4168: SELECT BL.SHORT_NAME
4169: FROM BSC_SYS_DIM_LEVELS_BY_GROUP B
4170: ,BSC_SYS_DIM_GROUPS_VL VL
4171: ,BSC_SYS_DIM_LEVELS_B BL
4172: WHERE VL.DIM_GROUP_ID = B.DIM_GROUP_ID
4173: AND BL.DIM_LEVEL_ID = B.DIM_LEVEL_ID

Line 4351: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

4347:
4348: l_dim_group_id := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_dim_short_name);
4349:
4350: SELECT count(dim_level_id) into l_count
4351: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
4352: WHERE dim_group_id = l_dim_group_id;
4353:
4354: IF (l_count =0) THEN
4355:

Line 4408: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

4404:
4405:
4406:
4407: SELECT count(dim_level_id) into l_count
4408: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
4409: WHERE dim_group_id = l_dim_group_id;
4410:
4411: IF ((l_count =1) AND (BSC_BIS_DIMENSION_PUB.Is_Dimension_in_Ind( l_dim_group_id))) THEN
4412:

Line 4458: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

4454: ORDER BY A.Dim_Group_Index;
4455:
4456: CURSOR c_dim_level_count IS
4457: SELECT count(dim_level_id)
4458: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
4459: WHERE dim_group_id = l_dim_group_id;
4460:
4461: BEGIN
4462:

Line 4481: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

4477:
4478:
4479: -- check if empty dimension
4480: SELECT count(dim_level_id) into l_count
4481: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
4482: WHERE dim_group_id = l_dim_group_id;
4483:
4484: IF (l_count =0) THEN
4485: -- Cascading unassign empty dimension from Objectives-dim sets