APPS.BIS_PMF_GET_DIMLEVELS_PVT dependencies on BIS_DIMENSIONS

Line 210: ,p_dimshortname IN bis_dimensions.short_name%TYPE

206: FUNCTION needs_time_cols (
207: p_source IN bis_levels.source%TYPE
208: ,p_data_source IN bis_levels.level_values_view_name%TYPE
209: ,p_lvlshortname IN bis_levels.short_name%TYPE
210: ,p_dimshortname IN bis_dimensions.short_name%TYPE
211: ) RETURN BOOLEAN;
212:
213: --====================================================================
214: FUNCTION IS_DISTINCT_USED

Line 876: FROM bis_levels lvl, bis_dimensions dim, bsc_sys_dim_levels_b bscdl

872: )
873: IS
874: CURSOR c_dimlvls IS
875: SELECT lvl.short_name, dim.short_name, lvl.level_values_view_name, bscdl.source, bscdl.level_view_name
876: FROM bis_levels lvl, bis_dimensions dim, bsc_sys_dim_levels_b bscdl
877: WHERE lvl.dimension_id = dim.dimension_id AND
878: (lvl.short_name = p_dim_level_name AND p_dim_level_name IS NOT NULL)
879: AND bscdl.short_name = lvl.short_name
880: ;

Line 883: l_dimshortname bis_dimensions.short_name%TYPE;

879: AND bscdl.short_name = lvl.short_name
880: ;
881: l_lvlshortname bis_levels.short_name%TYPE;
882: l_levelvalueview bis_levels.level_values_view_name%TYPE;
883: l_dimshortname bis_dimensions.short_name%TYPE;
884: l_time_columns VARCHAR2(2000);
885: l_Api_name VARCHAR2(200) := 'GET_BIS_SELECT_STRING';
886: l_Is_Rolling_Period_Level NUMBER; -- 2408906
887: l_dimshortname_time bis_dimensions.short_name%TYPE;

Line 887: l_dimshortname_time bis_dimensions.short_name%TYPE;

883: l_dimshortname bis_dimensions.short_name%TYPE;
884: l_time_columns VARCHAR2(2000);
885: l_Api_name VARCHAR2(200) := 'GET_BIS_SELECT_STRING';
886: l_Is_Rolling_Period_Level NUMBER; -- 2408906
887: l_dimshortname_time bis_dimensions.short_name%TYPE;
888: l_pmfBscSource VARCHAR2(30);
889: l_bscLevelViewName VARCHAR2(30);
890: l_id VARCHAR2(30) := 'ID';
891: l_value VARCHAR2(30) := 'VALUE';

Line 1879: ,p_dimshortname IN bis_dimensions.short_name%TYPE

1875: FUNCTION needs_time_cols (
1876: p_source IN bis_levels.source%TYPE
1877: ,p_data_source IN bis_levels.level_values_view_name%TYPE
1878: ,p_lvlshortname IN bis_levels.short_name%TYPE
1879: ,p_dimshortname IN bis_dimensions.short_name%TYPE
1880: ) RETURN BOOLEAN
1881: IS
1882: l_dimshortname_time bis_dimensions.short_name%TYPE;
1883: l_lvlshortname_total bis_levels.short_name%TYPE;

Line 1882: l_dimshortname_time bis_dimensions.short_name%TYPE;

1878: ,p_lvlshortname IN bis_levels.short_name%TYPE
1879: ,p_dimshortname IN bis_dimensions.short_name%TYPE
1880: ) RETURN BOOLEAN
1881: IS
1882: l_dimshortname_time bis_dimensions.short_name%TYPE;
1883: l_lvlshortname_total bis_levels.short_name%TYPE;
1884: BEGIN
1885: IF p_source IS NOT NULL THEN
1886: l_dimshortname_time := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_SRC(p_source => p_source);