APPS.BIS_DIMLEVEL_ERRS_PVT dependencies on BIS_PMF_GET_DIMLEVELS_PVT

Line 25: G_PKG_NAME VARCHAR2(200) := 'BIS_PMF_GET_DIMLEVELS_PVT';

21: -- CONSTANTS
22: EDW_ACCT_FLEXFIELD VARCHAR2(200) := 'EDW_GL';
23: EDW_LVL_TBL_SUFFIX VARCHAR2(200) := '_LTC';
24: EDW_LVL_FLEX_PK_SUFFIX VARCHAR2(200) := '_NAME';
25: G_PKG_NAME VARCHAR2(200) := 'BIS_PMF_GET_DIMLEVELS_PVT';
26: --Copied from JK's utilities blindly almost
27: PROCEDURE FILE_OPEN
28: (p_file_name IN VARCHAR2
29: ,x_file_handle OUT NOCOPY UTL_FILE.FILE_TYPE

Line 203: IF (BIS_PMF_GET_DIMLEVELS_PVT.isAccounting_Flexfield(l_lvlshortname))

199: FETCH c_dims INTO l_dimshortname;
200: CLOSE c_dims;
201: */
202: EXECUTE IMMEDIATE l_dim_sql INTO l_dimshortname USING l_lvlshortname;
203: IF (BIS_PMF_GET_DIMLEVELS_PVT.isAccounting_Flexfield(l_lvlshortname))
204: THEN
205: --l_pkkey := c_rec.prefix||EDW_LVL_FLEX_PK_SUFFIX;
206: l_pkkey := l_prefix||EDW_LVL_FLEX_PK_SUFFIX;
207: l_tablename := l_dimshortname;

Line 312: -- IF (NOT(BIS_PMF_GET_DIMLEVELS_PVT.isAccounting_Flexfield(l_lvlshortname))) THEN

308: END;
309: ELSE
310: l_time_columns := '';
311: END IF;
312: -- IF (NOT(BIS_PMF_GET_DIMLEVELS_PVT.isAccounting_Flexfield(l_lvlshortname))) THEN
313: l_sql_string := 'SELECT '||l_valuename||' from '||l_tablename|| ' where rownum < 2';
314: BEGIN
315: EXECUTE IMMEDIATE l_sql_string ;
316: EXCEPTION