APPS.BSC_UPGRADES dependencies on BIS_LEVELS

Line 1271: FROM BIS_LEVELS_VL;

1267: , Source
1268: , Comparison_Label_Code
1269: , Attribute_Code
1270: , Application_Id
1271: FROM BIS_LEVELS_VL;
1272:
1273: CURSOR c_bsc_dim_objs IS
1274: SELECT Dim_Level_Id
1275: , Name

Line 1311: FROM BIS_LEVELS

1307: l_sql VARCHAR2(32000);
1308:
1309: CURSOR c_oltp_level_name IS
1310: SELECT level_values_view_name
1311: FROM BIS_LEVELS
1312: WHERE SOURCE = 'OLTP'
1313: AND level_values_view_name NOT LIKE 'BSC_D_%'
1314: AND level_values_view_name IS NOT NULL;
1315: BEGIN

Line 1339: FROM BIS_LEVELS

1335: WHERE short_name IS NULL;
1336:
1337: FOR cd IN c_bsc_dim_objs LOOP
1338: SELECT COUNT(1) INTO l_count
1339: FROM BIS_LEVELS
1340: WHERE short_name = cd.Short_Name;
1341: IF (l_count = 0) THEN
1342: SELECT COUNT(1) INTO l_count
1343: FROM BIS_LEVELS_TL

Line 1343: FROM BIS_LEVELS_TL

1339: FROM BIS_LEVELS
1340: WHERE short_name = cd.Short_Name;
1341: IF (l_count = 0) THEN
1342: SELECT COUNT(1) INTO l_count
1343: FROM BIS_LEVELS_TL
1344: WHERE Name = cd.Name
1345: AND language = userenv('LANG');
1346:
1347: IF (l_count = 0) THEN

Line 1563: FROM BIS_LEVELS A

1559: FROM BSC_SYS_DIM_GROUPS_VL;
1560:
1561: CURSOR dim_obj_short_name IS
1562: SELECT A.short_name short_name
1563: FROM BIS_LEVELS A
1564: WHERE A.dimension_id = l_dimension_id;
1565:
1566:
1567: l_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

Line 1639: -- Added because join to bis_levels is causing FTS.

1635: );
1636:
1637: -- sync-up dimension - dimension objects relationship to BSC side.
1638: FOR dim_cn IN dim_obj_short_name LOOP
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

Line 1929: FROM BIS_LEVELS

1925: BEGIN
1926:
1927: SELECT LEVEL_ID
1928: INTO l_level_id
1929: FROM BIS_LEVELS
1930: WHERE SHORT_NAME = p_level_short_name;
1931:
1932: l_Dim_Level_Rec.Bsc_Level_Short_Name := p_level_short_name;
1933: --As of now LUD is not being updated, but populated for future use

Line 1941: FROM BIS_LEVELS_TL

1937: l_Dim_Level_Rec.Bsc_Dim_Level_Help,
1938: l_Dim_Level_Rec.Bsc_Language,
1939: l_Dim_Level_Rec.Bsc_Last_Update_Date,
1940: l_Dim_Level_Rec.Bsc_Source_Language
1941: FROM BIS_LEVELS_TL
1942: WHERE LEVEL_ID = l_level_id
1943: AND LANGUAGE = cd.language_code;
1944:
1945: BSC_DIMENSION_LEVELS_PUB.Trans_DimObj_By_Given_Lang

Line 2755: UPDATE bis_levels

2751: BEGIN
2752:
2753: FOR l_bsc_rel_rec IN c_bsc_rel LOOP
2754:
2755: UPDATE bis_levels
2756: SET dimension_id = l_bsc_rel_rec.dimension_id
2757: WHERE short_name = l_bsc_rel_rec.short_name
2758: AND dimension_id = -1 ;
2759: