APPS.BIS_PORTLET_PMREGION dependencies on BIS_LEVELS

Line 2147: l_Org_Level_Name bis_levels_tl.name%TYPE;

2143: -- meastmon 09/19/2001 Fix bug#1993015 This variable needs to be VARCHAR2
2144: l_Org_Level_Value_ID VARCHAR2(80); --number;
2145:
2146: l_Org_Level_Short_Name VARCHAR2(240);
2147: l_Org_Level_Name bis_levels_tl.name%TYPE;
2148:
2149: l_link VARCHAR2(32000);
2150: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2151: l_clear VARCHAR2(32000);

Line 4154: l_Org_Level_Name bis_levels_tl.name%TYPE;

4150: --
4151: l_Org_Seq_Num number;
4152: l_Org_Level_Value_ID number;
4153: l_Org_Level_Short_Name varchar2(240);
4154: l_Org_Level_Name bis_levels_tl.name%TYPE;
4155:
4156: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4157: l_clear VARCHAR2(32000);
4158: l_sobString VARCHAR2(32000);

Line 4314: FROM BIS_LEVELS

4310: -- Set the set of books id for GL dimension levels
4311: --
4312: SELECT level_id
4313: INTO l_sob_level_id
4314: FROM BIS_LEVELS
4315: WHERE SHORT_NAME = 'SET OF BOOKS';
4316:
4317: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4318: /*

Line 7333: FROM bis_levels

7329:
7330:
7331: SELECT short_name
7332: INTO level_short_name
7333: FROM bis_levels
7334: WHERE level_id = l_time_dimension_level_id;
7335:
7336: isRollingLevel := bis_utilities_pvt.Is_Rolling_Period_Level(level_short_name);
7337: