APPS.BSC_BIS_DIM_OBJ_PUB dependencies on BIS_DIMENSIONS

Line 409: l_Dim_Short_Name BIS_DIMENSIONS.Short_Name%TYPE;

405: , x_msg_data OUT NOCOPY VARCHAR2
406: ) IS
407: l_Bsc_Dim_Obj_ID BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE;
408: l_Bsc_Group_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
409: l_Dim_Short_Name BIS_DIMENSIONS.Short_Name%TYPE;
410:
411: CURSOR c_Bis_Levels IS
412: SELECT B.Short_Name
413: FROM BIS_LEVELS A

Line 414: , BIS_DIMENSIONS B

410:
411: CURSOR c_Bis_Levels IS
412: SELECT B.Short_Name
413: FROM BIS_LEVELS A
414: , BIS_DIMENSIONS B
415: WHERE A.Short_Name = p_Dim_Obj_Short_Name
416: AND A.Dimension_Id = B.Dimension_Id;
417: BEGIN
418:

Line 1977: l_Dim_Short_Name BIS_DIMENSIONS.SHORT_NAME%TYPE;

1973:
1974: FUNCTION Retrieve_Primary_Dimension(
1975: p_Dim_Obj_Short_Name IN VARCHAR2
1976: ) RETURN VARCHAR2 IS
1977: l_Dim_Short_Name BIS_DIMENSIONS.SHORT_NAME%TYPE;
1978: CURSOR c_Bis_Levels IS
1979: SELECT B.Short_Name
1980: FROM BIS_LEVELS A
1981: , BIS_DIMENSIONS B

Line 1981: , BIS_DIMENSIONS B

1977: l_Dim_Short_Name BIS_DIMENSIONS.SHORT_NAME%TYPE;
1978: CURSOR c_Bis_Levels IS
1979: SELECT B.Short_Name
1980: FROM BIS_LEVELS A
1981: , BIS_DIMENSIONS B
1982: WHERE A.Short_Name = p_Dim_Obj_Short_Name
1983: AND A.Dimension_Id = B.Dimension_Id;
1984: BEGIN
1985: OPEN c_Bis_Levels;

Line 2104: , BIS_DIMENSIONS B

2100: /* ADDED BY RAVI *********/
2101: CURSOR c_dim_short_name IS
2102: SELECT B.SHORT_NAME
2103: FROM BIS_LEVELS A
2104: , BIS_DIMENSIONS B
2105: WHERE B.DIMENSION_ID = A.DIMENSION_ID
2106: AND A.SHORT_NAME = p_dim_obj_short_name;
2107: --dimension_level_short_name = p_dim_obj_short_name;
2108: l_dim_short_name BIS_DIMENSIONS.short_name%TYPE;

Line 2108: l_dim_short_name BIS_DIMENSIONS.short_name%TYPE;

2104: , BIS_DIMENSIONS B
2105: WHERE B.DIMENSION_ID = A.DIMENSION_ID
2106: AND A.SHORT_NAME = p_dim_obj_short_name;
2107: --dimension_level_short_name = p_dim_obj_short_name;
2108: l_dim_short_name BIS_DIMENSIONS.short_name%TYPE;
2109: l_dim_exist BOOLEAN := FALSE;
2110: l_first_dim_short_name BIS_DIMENSIONS.short_name%TYPE;
2111: l_first BOOLEAN := TRUE;
2112: l_primary_dim_sht_name BIS_DIMENSIONS.short_name%TYPE;

Line 2110: l_first_dim_short_name BIS_DIMENSIONS.short_name%TYPE;

2106: AND A.SHORT_NAME = p_dim_obj_short_name;
2107: --dimension_level_short_name = p_dim_obj_short_name;
2108: l_dim_short_name BIS_DIMENSIONS.short_name%TYPE;
2109: l_dim_exist BOOLEAN := FALSE;
2110: l_first_dim_short_name BIS_DIMENSIONS.short_name%TYPE;
2111: l_first BOOLEAN := TRUE;
2112: l_primary_dim_sht_name BIS_DIMENSIONS.short_name%TYPE;
2113: /********************************/
2114:

Line 2112: l_primary_dim_sht_name BIS_DIMENSIONS.short_name%TYPE;

2108: l_dim_short_name BIS_DIMENSIONS.short_name%TYPE;
2109: l_dim_exist BOOLEAN := FALSE;
2110: l_first_dim_short_name BIS_DIMENSIONS.short_name%TYPE;
2111: l_first BOOLEAN := TRUE;
2112: l_primary_dim_sht_name BIS_DIMENSIONS.short_name%TYPE;
2113: /********************************/
2114:
2115: CURSOR c_Master_Level IS
2116: SELECT Short_Name

Line 5484: FROM BIS_DIMENSIONS

5480: p_dim_short_name IN VARCHAR2
5481: ) RETURN NUMBER IS
5482: CURSOR c_dim_short_name IS
5483: SELECT dimension_id
5484: FROM BIS_DIMENSIONS
5485: WHERE short_name = p_dim_short_name;
5486:
5487: l_dim_id BISFV_DIMENSION_LEVELS.dimension_id%TYPE;
5488: BEGIN

Line 7236: l_Dim_Short_Name BIS_DIMENSIONS.SHORT_NAME%TYPE;

7232: , x_Msg_Count OUT NOCOPY NUMBER
7233: , x_Msg_Data OUT NOCOPY VARCHAR2
7234: ) IS
7235: l_Dim_DimObj_Sht_Name VARCHAR2(1000);
7236: l_Dim_Short_Name BIS_DIMENSIONS.SHORT_NAME%TYPE;
7237: CURSOR c_dim_groups IS
7238: SELECT
7239: bis_dim.short_name
7240: FROM

Line 7243: bis_dimensions bis_dim

7239: bis_dim.short_name
7240: FROM
7241: ak_regions reg,
7242: ak_region_items reg_item,
7243: bis_dimensions bis_dim
7244: WHERE
7245: reg_item.attribute2 = l_Dim_DimObj_Sht_Name
7246: AND reg.region_code = reg_item.region_code
7247: AND bis_dim.short_name = reg.attribute12