APPS.BSC_UPGRADES dependencies on BSC_SYS_DIM_LEVELS_B

Line 1321: UPDATE BSC_SYS_DIM_LEVELS_B

1317: FND_MSG_PUB.Initialize;
1318: SAVEPOINT BscSyncDimeObjects;
1319:
1320: --Modify level_table_names in BSC tables to Upper case
1321: UPDATE BSC_SYS_DIM_LEVELS_B
1322: SET Level_Table_Name = UPPER(Level_Table_Name)
1323: WHERE LEVEL_TABLE_NAME <> UPPER(LEVEL_TABLE_NAME);
1324:
1325: UPDATE BSC_KPI_DIM_LEVELS_B

Line 1333: UPDATE BSC_SYS_DIM_LEVELS_B

1329: UPDATE BSC_DB_TABLES_RELS
1330: SET Table_Name = UPPER(Table_Name)
1331: WHERE Table_Name <> UPPER(Table_Name);
1332:
1333: UPDATE BSC_SYS_DIM_LEVELS_B
1334: SET SHORT_NAME = 'BSC_DIM_OBJ_'||Dim_Level_Id||'_'||ROWNUM
1335: WHERE short_name IS NULL;
1336:
1337: FOR cd IN c_bsc_dim_objs LOOP

Line 1396: FROM BSC_SYS_DIM_LEVELS_B

1392: END LOOP;
1393:
1394: FOR cd IN c_bis_dim_objs LOOP
1395: SELECT COUNT(1) INTO l_count
1396: FROM BSC_SYS_DIM_LEVELS_B
1397: WHERE short_name = cd.Short_Name;
1398:
1399: IF(l_count = 0) THEN
1400: l_bsc_dim_obj_rec.Source := cd.Source;

Line 1401: l_bsc_dim_obj_rec.Bsc_Level_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value('BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID');

1397: WHERE short_name = cd.Short_Name;
1398:
1399: IF(l_count = 0) THEN
1400: l_bsc_dim_obj_rec.Source := cd.Source;
1401: l_bsc_dim_obj_rec.Bsc_Level_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value('BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID');
1402: l_bsc_dim_obj_rec.Bsc_Source := 'PMF';
1403: l_bsc_dim_obj_rec.Bsc_Level_User_Key_Size := 5;
1404: l_bsc_dim_obj_rec.Bsc_Level_Disp_Key_Size := 15;
1405: l_bsc_dim_obj_rec.Bsc_Level_Abbreviation := SUBSTR(REPLACE(cd.Short_Name, ' ', ''), 1, 5);

Line 1643: FROM BSC_SYS_DIM_LEVELS_B

1639: -- Added because join to bis_levels is causing FTS.
1640: BEGIN
1641: SELECT dim_level_id
1642: INTO l_cn_dim_level_id
1643: FROM BSC_SYS_DIM_LEVELS_B
1644: WHERE short_name = dim_cn.short_name;
1645: EXCEPTION WHEN OTHERS THEN
1646: NULL;
1647: END;

Line 1649: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

1645: EXCEPTION WHEN OTHERS THEN
1646: NULL;
1647: END;
1648: SELECT COUNT(1) INTO l_count
1649: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
1650: WHERE dim_level_id = l_cn_dim_level_id
1651: AND dim_group_id = (SELECT Dim_Group_Id
1652: FROM BSC_SYS_DIM_GROUPS_VL WHERE SHORT_NAME = cd.Short_Name);
1653:

Line 1843: FROM BSC_SYS_DIM_LEVELS_B

1839: BEGIN
1840:
1841: SELECT DIM_LEVEL_ID
1842: INTO l_level_id
1843: FROM BSC_SYS_DIM_LEVELS_B
1844: WHERE SHORT_NAME = p_level_short_name;
1845:
1846: l_Dim_Level_Rec.Dimension_Short_Name := p_level_short_name;
1847:

Line 2742: bsc_sys_dim_levels_b bsc_lvl,

2738:
2739: CURSOR c_bsc_rel is
2740: SELECT bsc_lvl.short_name, bis_dim.dimension_id
2741: FROM bsc_sys_dim_groups_vl bsc_dim,
2742: bsc_sys_dim_levels_b bsc_lvl,
2743: bsc_sys_dim_levels_by_group lvl_by_grp,
2744: bis_dimensions bis_dim
2745: WHERE bsc_dim.dim_group_id = lvl_by_grp.dim_group_id
2746: AND bsc_lvl.dim_level_id = lvl_by_grp.dim_level_id

Line 2743: bsc_sys_dim_levels_by_group lvl_by_grp,

2739: CURSOR c_bsc_rel is
2740: SELECT bsc_lvl.short_name, bis_dim.dimension_id
2741: FROM bsc_sys_dim_groups_vl bsc_dim,
2742: bsc_sys_dim_levels_b bsc_lvl,
2743: bsc_sys_dim_levels_by_group lvl_by_grp,
2744: bis_dimensions bis_dim
2745: WHERE bsc_dim.dim_group_id = lvl_by_grp.dim_group_id
2746: AND bsc_lvl.dim_level_id = lvl_by_grp.dim_level_id
2747: /* AND bsc_dim.dim_group_id = bis_dim.dim_grp_id cannot use since dim_group_id is not updated on BIS side yet */

Line 2899: l_level_view_name bsc_sys_dim_levels_b.level_view_name%TYPE;

2895: , x_msg_count OUT NOCOPY NUMBER
2896: , x_msg_data OUT NOCOPY VARCHAR2
2897: ) IS
2898: l_sql VARCHAR2(2000);
2899: l_level_view_name bsc_sys_dim_levels_b.level_view_name%TYPE;
2900: l_table_type bsc_sys_dim_levels_b.table_type%TYPE;
2901:
2902: CURSOR c_dim_obj(p_sht_name VARCHAR2) IS
2903: SELECT level_view_name,table_type

Line 2900: l_table_type bsc_sys_dim_levels_b.table_type%TYPE;

2896: , x_msg_data OUT NOCOPY VARCHAR2
2897: ) IS
2898: l_sql VARCHAR2(2000);
2899: l_level_view_name bsc_sys_dim_levels_b.level_view_name%TYPE;
2900: l_table_type bsc_sys_dim_levels_b.table_type%TYPE;
2901:
2902: CURSOR c_dim_obj(p_sht_name VARCHAR2) IS
2903: SELECT level_view_name,table_type
2904: FROM bsc_sys_dim_levels_b

Line 2904: FROM bsc_sys_dim_levels_b

2900: l_table_type bsc_sys_dim_levels_b.table_type%TYPE;
2901:
2902: CURSOR c_dim_obj(p_sht_name VARCHAR2) IS
2903: SELECT level_view_name,table_type
2904: FROM bsc_sys_dim_levels_b
2905: WHERE short_name = p_sht_name;
2906:
2907: BEGIN
2908: FND_MSG_PUB.Initialize;

Line 2925: UPDATE bsc_sys_dim_levels_b

2921: EXCEPTION
2922: WHEN OTHERS THEN
2923: NULL;
2924: END;
2925: UPDATE bsc_sys_dim_levels_b
2926: SET table_type = -1
2927: WHERE short_name = p_Dim_Obj_Sht_Name(i);
2928: END IF;
2929: END LOOP;