eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_BIS_DIMENSION_PUB dependencies on BSC_SYS_DIM_LEVELS_B

Line 91: p_dim_obj_id BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE

87: TYPE KPI_Dim_Set_Table_Type IS TABLE OF KPI_Dim_Set_Type INDEX BY BINARY_INTEGER;
88: /*********************************************************************************/
89: TYPE Dim_Obj_Relations_Type IS Record
90: (
91: p_dim_obj_id BSC_SYS_DIM_LEVELS_B.dim_level_id%TYPE
92: );
93: TYPE Dim_Obj_Table_Type IS TABLE OF Dim_Obj_Relations_Type INDEX BY BINARY_INTEGER;
94: /*********************************************************************************/
95:

Line 99: p_short_name BSC_SYS_DIM_LEVELS_B.short_name%TYPE

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;
102:
103: /*********************************************************************************/

Line 285: , p_Dim_Level_Id IN BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE

281: Function to check Dimension/Dimension Object if association exists
282: *********************************************************************************************/
283: FUNCTION is_Relation_Exists
284: ( p_Dim_Grp_Id IN BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE
285: , p_Dim_Level_Id IN BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE
286: ) RETURN BOOLEAN IS
287: l_flag BOOLEAN := FALSE;
288: l_Count NUMBER := 0;
289: BEGIN

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 308: l_Bsc_Dim_Obj_ID BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE;

304: Set the ALL Enable Flag Primary Flag
305: *********************************************************************************/
306: FUNCTION Get_Primary_All_Flag(p_Dim_Obj_Short_Name IN VARCHAR2)
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:

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 354: ( p_Dim_Level_Id IN BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE

350: /*********************************************************************************************
351: Returns the number of dimension associated with the dimension object
352: *********************************************************************************************/
353: FUNCTION Get_Number_Of_Dimensions
354: ( p_Dim_Level_Id IN BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE
355: ) RETURN NUMBER IS
356: l_Count NUMBER := 0;
357: BEGIN
358: SELECT COUNT(Dim_Group_ID) INTO l_Count

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 374: l_Bsc_Level_ID BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE;

370: , x_return_status OUT NOCOPY VARCHAR2
371: , x_msg_count OUT NOCOPY NUMBER
372: , x_msg_data OUT NOCOPY VARCHAR2
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:

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 443: l_Bsc_Level_ID BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE;

439: , x_return_status OUT NOCOPY VARCHAR2
440: , x_msg_count OUT NOCOPY NUMBER
441: , x_msg_data OUT NOCOPY VARCHAR2
442: ) IS
443: l_Bsc_Level_ID BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE;
444: l_Bsc_Group_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE := NULL;
445: l_Bis_Group_ID BIS_DIMENSIONS.Dimension_ID%TYPE;
446:
447: l_Old_Bsc_Group_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;

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 903: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;

899: -- Start Granular Locking added by Aditya
900: l_Dim_Obj_Tab BSC_BIS_LOCKS_PUB.t_numberTable;
901: l_dim_obj_names VARCHAR2(32000);
902:
903: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
904: l_index NUMBER := 0;
905: -- End Granular Locking added by Aditya
906:
907: l_pmf_disp_name VARCHAR2(255); -- DispName

Line 1227: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;

1223: , x_msg_count OUT NOCOPY NUMBER
1224: , x_msg_data OUT NOCOPY VARCHAR2
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);

Line 1228: l_Source_Type BSC_SYS_DIM_LEVELS_B.Source%TYPE;

1224: , x_msg_data OUT NOCOPY VARCHAR2
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;

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 1232: l_assign 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;
1234: l_MTab_DimRels1 BSC_BIS_DIMENSION_PUB.Dim_Obj_Table_Type;
1235: l_MTab_DimRels2 BSC_BIS_DIMENSION_PUB.Dim_Obj_Table_Type;
1236:

Line 1242: l_dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE;

1238: l_count NUMBER;
1239: l_count1 NUMBER;
1240: l_flag BOOLEAN;
1241: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
1242: l_dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE;
1243:
1244: l_tab_index NUMBER;
1245: l_original_tab_index NUMBER;
1246: l_struct_change BOOLEAN := FALSE;

Line 1251: FROM BSC_SYS_DIM_LEVELS_B B

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

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 1269: FROM BSC_SYS_DIM_LEVELS_B

1265:
1266: CURSOR cr_bsc_dim_obj_id IS
1267: SELECT Dim_Level_Id
1268: , Source
1269: FROM BSC_SYS_DIM_LEVELS_B
1270: WHERE Short_Name = l_dim_obj_name;
1271: BEGIN
1272:
1273: FND_MSG_PUB.Initialize;

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 1538: l_Dim_Obj_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE;

1534: l_valid_Assign BOOLEAN := FALSE;
1535: l_do_not_cascade BOOLEAN := TRUE;
1536:
1537: l_dim_obj_sht_name BSC_SYS_DIM_LEVELS_VL.Short_Name%TYPE;
1538: l_Dim_Obj_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
1539: l_Dim_Obj_Name BSC_SYS_DIM_LEVELS_TL.Name%TYPE;
1540: l_Rolling_Period NUMBER;
1541:
1542: CURSOR cr_bsc_dim_obj_id IS

Line 1543: SELECT dim_level_id FROM BSC_SYS_DIM_LEVELS_B

1539: l_Dim_Obj_Name BSC_SYS_DIM_LEVELS_TL.Name%TYPE;
1540: l_Rolling_Period NUMBER;
1541:
1542: CURSOR cr_bsc_dim_obj_id IS
1543: SELECT dim_level_id FROM BSC_SYS_DIM_LEVELS_B
1544: WHERE short_name = p_dim_obj_short_name;
1545:
1546: CURSOR cr_bsc_dim_id IS
1547: SELECT dim_group_id FROM BSC_SYS_DIM_GROUPS_VL

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 2027: l_Dim_Obj_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE := NULL;

2023: , x_msg_count OUT NOCOPY NUMBER
2024: , x_msg_data OUT NOCOPY VARCHAR2
2025: ) IS
2026: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
2027: l_Dim_Obj_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE := NULL;
2028: l_Dim_Grp_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE;
2029: l_Source_Type BSC_SYS_DIM_LEVELS_B.Source%TYPE;
2030: l_dim_obj_names VARCHAR2(32000);
2031: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;

Line 2029: l_Source_Type BSC_SYS_DIM_LEVELS_B.Source%TYPE;

2025: ) IS
2026: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
2027: l_Dim_Obj_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE := NULL;
2028: l_Dim_Grp_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE;
2029: l_Source_Type BSC_SYS_DIM_LEVELS_B.Source%TYPE;
2030: l_dim_obj_names VARCHAR2(32000);
2031: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
2032: l_MTab_Tbl BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type;
2033: l_Bis_Group_ID BIS_DIMENSIONS.Dimension_ID%TYPE;

Line 2031: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;

2027: l_Dim_Obj_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE := NULL;
2028: l_Dim_Grp_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE;
2029: l_Source_Type BSC_SYS_DIM_LEVELS_B.Source%TYPE;
2030: l_dim_obj_names VARCHAR2(32000);
2031: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
2032: l_MTab_Tbl BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type;
2033: l_Bis_Group_ID BIS_DIMENSIONS.Dimension_ID%TYPE;
2034: l_kpi_cascade BOOLEAN := FALSE;
2035: l_count NUMBER;

Line 2048: FROM BSC_SYS_DIM_LEVELS_B

2044:
2045: CURSOR cr_bsc_dim_obj_id IS
2046: SELECT Dim_Level_Id
2047: , Source
2048: FROM BSC_SYS_DIM_LEVELS_B
2049: WHERE Short_Name = l_dim_obj_name;
2050:
2051: CURSOR cr_bis_dim_ids IS
2052: SELECT Short_Name

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 2378: l_unassign BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;

2374: , x_msg_data OUT NOCOPY VARCHAR2
2375: ) IS
2376: l_unassigns VARCHAR2(32000);
2377: l_assigns VARCHAR2(32000);
2378: l_unassign BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
2379: l_assign BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
2380: l_unassign_dim_objs VARCHAR2(32000);
2381: l_flag BOOLEAN;
2382:

Line 2379: l_assign BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;

2375: ) IS
2376: l_unassigns VARCHAR2(32000);
2377: l_assigns VARCHAR2(32000);
2378: l_unassign BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
2379: l_assign BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
2380: l_unassign_dim_objs VARCHAR2(32000);
2381: l_flag BOOLEAN;
2382:
2383: l_dim_obj_sht_names VARCHAR2(32000);

Line 2867: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;

2863:
2864: l_Dim_Obj_Tab BSC_BIS_LOCKS_PUB.t_numberTable;
2865: l_dim_obj_names VARCHAR2(32000);
2866:
2867: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
2868: l_index NUMBER := 0;
2869: l_mix_type_dim BOOLEAN;
2870: l_dim_type VARCHAR2(10);
2871: l_count NUMBER;

Line 3127: FROM BSC_SYS_DIM_LEVELS_B

3123: FROM BSC_SYS_DIM_GROUPS_VL WHERE short_name = p_dim_short_name;
3124:
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:

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 3605: l_Data_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE := NULL;

3601: FUNCTION Get_Dimension_Source
3602: (
3603: p_short_Name IN VARCHAR2
3604: ) RETURN VARCHAR2 IS
3605: l_Data_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE := NULL;
3606:
3607: CURSOR c_Dim_Obj_Data_Source IS
3608: SELECT VL.Source
3609: FROM BSC_SYS_DIM_GROUPS_TL TL

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 3611: , BSC_SYS_DIM_LEVELS_B VL

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;
3615: BEGIN

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 3809: l_Source BSC_SYS_DIM_LEVELS_B.Source%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;
3809: l_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
3810: l_indicator_list VARCHAR2(32000);
3811: l_obj_name bsc_kpis_vl.name%TYPE;
3812: l_ind bsc_kpis_vl.indicator%TYPE;
3813: l_sql VARCHAR2(2000);

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 3822: , BSC_SYS_DIM_LEVELS_B C

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
3825: AND B.Short_Name = p_Dim_Short_Name
3826: AND C.Short_Name = p_dim_Obj_Short_Name;

Line 3975: l_Dim_Obj_Name BSC_SYS_DIM_LEVELS_B.short_name%TYPE;

3971: ) RETURN VARCHAR2 IS
3972: l_Msg_Data VARCHAR2(32000);
3973: l_msg_count NUMBER;
3974:
3975: l_Dim_Obj_Name BSC_SYS_DIM_LEVELS_B.short_name%TYPE;
3976: l_Dim_Obj_Old_Name BSC_SYS_DIM_LEVELS_B.short_name%TYPE;
3977: l_Dim_Grp_Id BSC_SYS_DIM_GROUPS_VL.Dim_Group_Id%TYPE;
3978: l_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
3979:

Line 3976: l_Dim_Obj_Old_Name BSC_SYS_DIM_LEVELS_B.short_name%TYPE;

3972: l_Msg_Data VARCHAR2(32000);
3973: l_msg_count NUMBER;
3974:
3975: l_Dim_Obj_Name BSC_SYS_DIM_LEVELS_B.short_name%TYPE;
3976: l_Dim_Obj_Old_Name BSC_SYS_DIM_LEVELS_B.short_name%TYPE;
3977: l_Dim_Grp_Id BSC_SYS_DIM_GROUPS_VL.Dim_Group_Id%TYPE;
3978: l_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
3979:
3980: l_old_dim_objects VARCHAR2(8000) := NULL;

Line 3978: l_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE;

3974:
3975: l_Dim_Obj_Name BSC_SYS_DIM_LEVELS_B.short_name%TYPE;
3976: l_Dim_Obj_Old_Name BSC_SYS_DIM_LEVELS_B.short_name%TYPE;
3977: l_Dim_Grp_Id BSC_SYS_DIM_GROUPS_VL.Dim_Group_Id%TYPE;
3978: l_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
3979:
3980: l_old_dim_objects VARCHAR2(8000) := NULL;
3981: l_temp_dim_objcts VARCHAR2(8000);
3982: l_temp_var VARCHAR2(8000);

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 3996: , BSC_SYS_DIM_LEVELS_B C

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
4000: ORDER BY B.Dim_Level_Index;

Line 4161: FROM BSC_SYS_DIM_LEVELS_B B

4157: AND B.SHORT_NAME = p_Dim_Short_Name;
4158:
4159: CURSOR cr_dimobj_in_dimset IS
4160: SELECT B.SHORT_NAME
4161: FROM BSC_SYS_DIM_LEVELS_B B
4162: ,BSC_KPI_DIM_LEVEL_PROPERTIES KDL
4163: WHERE B.DIM_LEVEL_ID = KDL.DIM_LEVEL_ID
4164: AND KDL.indicator = l_kpi_id
4165: AND KDL.dim_set_id = l_dim_set_id;

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 4171: ,BSC_SYS_DIM_LEVELS_B BL

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
4174: AND VL.SHORT_NAME = p_Dim_Short_Name;
4175:

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 4443: l_source BSC_SYS_DIM_LEVELS_B.Source%TYPE;

4439: l_count NUMBER;
4440: l_dim_group_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
4441: l_dim_short_names VARCHAR2(32000);
4442: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
4443: l_source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
4444:
4445: CURSOR c_dim_set_kpi IS
4446: SELECT DISTINCT A.indicator INDICATOR
4447: , A.dim_set_id DIM_SET_ID

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