APPS.BSC_DIMENSION_SETS_PVT dependencies on BSC_KPI_DIM_LEVELS_B

Line 1394: FROM BSC_KPI_DIM_LEVELS_B

1390: -- Determine if the dimension already belongs to this dimension set.
1391: IF (p_Dim_Set_Rec.Bsc_Level_Name IS NOT NULL) THEN
1392: SELECT count(*)
1393: INTO l_count
1394: FROM BSC_KPI_DIM_LEVELS_B
1395: WHERE indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1396: AND dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1397: AND upper(level_table_name) = upper(p_Dim_Set_Rec.Bsc_Level_Name)
1398: AND dim_level_index = p_Dim_Set_Rec.Bsc_Dset_Dim_Level_Index - 1;

Line 1403: -- Insert pertaining values into table bsc_kpi_dim_levels_b.

1399:
1400: -- If the dimension does not belong to the dimension set assign it, else
1401: -- raise an error.
1402: IF l_count = 0 THEN
1403: -- Insert pertaining values into table bsc_kpi_dim_levels_b.
1404: -- Reminder: some values are hard coded, need to get source.
1405: INSERT INTO BSC_KPI_DIM_LEVELS_B( indicator
1406: ,dim_set_id
1407: ,dim_level_index

Line 1405: INSERT INTO BSC_KPI_DIM_LEVELS_B( indicator

1401: -- raise an error.
1402: IF l_count = 0 THEN
1403: -- Insert pertaining values into table bsc_kpi_dim_levels_b.
1404: -- Reminder: some values are hard coded, need to get source.
1405: INSERT INTO BSC_KPI_DIM_LEVELS_B( indicator
1406: ,dim_set_id
1407: ,dim_level_index
1408: ,level_table_name
1409: ,level_view_name

Line 1666: from BSC_KPI_DIM_LEVELS_B a

1662: , x_Dim_Set_Rec.Bsc_Dim_Level_Long_Name
1663: , x_Dim_Set_Rec.Bsc_Dim_Level_Help
1664: , x_Dim_Set_Rec.Bsc_Dim_Tot_Disp_Name
1665: , x_Dim_Set_Rec.Bsc_Dim_Comp_Disp_Name
1666: from BSC_KPI_DIM_LEVELS_B a
1667: , BSC_KPI_DIM_LEVELS_TL b
1668: where a.indicator = b.indicator
1669: and a.dim_set_id = b.dim_set_id
1670: and a.dim_level_index = b.dim_level_index

Line 1902: update BSC_KPI_DIM_LEVELS_B a

1898: if p_Dim_Set_Rec.Bsc_Dset_Target_Level is not null then
1899: l_Dim_Set_Rec.Bsc_Dset_Target_Level := p_Dim_Set_Rec.Bsc_Dset_Target_Level;
1900: end if;
1901:
1902: update BSC_KPI_DIM_LEVELS_B a
1903: set dim_level_index = l_Dim_Set_Rec.Bsc_Dset_Dim_Level_Index
1904: , level_view_name = l_Dim_Set_Rec.Bsc_View_Name
1905: , filter_column = l_Dim_Set_Rec.Bsc_Dset_Filter_Column
1906: , filter_value = l_Dim_Set_Rec.Bsc_Dset_Filter_Value

Line 2008: SELECT DIM_LEVEL_INDEX FROM BSC_KPI_DIM_LEVELS_B

2004: --PAJOHRI ADDED 02-Jun-2003
2005: l_dim_index NUMBER;
2006:
2007: CURSOR c_dim_index IS
2008: SELECT DIM_LEVEL_INDEX FROM BSC_KPI_DIM_LEVELS_B
2009: WHERE DIM_SET_ID = p_Dim_Set_Rec.Bsc_Dim_Set_Id
2010: AND INDICATOR = p_Dim_Set_Rec.Bsc_Kpi_Id
2011: AND (LEVEL_TABLE_NAME = (SELECT LEVEL_TABLE_NAME FROM BSC_SYS_DIM_LEVELS_B
2012: WHERE DIM_LEVEL_ID = p_Dim_Set_Rec.Bsc_Level_Id)

Line 2041: FROM bsc_kpi_dim_levels_b

2037: FOR cd IN c_dim_index LOOP
2038: l_dim_index := cd.Dim_Level_Index;
2039:
2040: DELETE
2041: FROM bsc_kpi_dim_levels_b
2042: WHERE indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
2043: AND dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
2044: AND dim_level_index = l_dim_index;
2045: