APPS.BIS_UTILITIES_PVT dependencies on BISFV_DIMENSION_LEVELS

Line 5504: FROM bisfv_dimension_levels

5500: RETURN BOOLEAN
5501: IS
5502: CURSOR c_dims IS
5503: SELECT source ,dimension_short_name, dimension_level_short_name
5504: FROM bisfv_dimension_levels
5505: WHERE dimension_level_id = p_bis_dimlevel_id;
5506: l_source bisfv_dimension_levels.SOURCE%TYPE;
5507: l_dimshort_name bisfv_dimension_levels.DIMENSION_SHORT_NAME%TYPE;
5508: l_dimlevel_name bisfv_dimension_levels.DIMENSION_LEVEL_SHORT_NAME%TYPE;

Line 5506: l_source bisfv_dimension_levels.SOURCE%TYPE;

5502: CURSOR c_dims IS
5503: SELECT source ,dimension_short_name, dimension_level_short_name
5504: FROM bisfv_dimension_levels
5505: WHERE dimension_level_id = p_bis_dimlevel_id;
5506: l_source bisfv_dimension_levels.SOURCE%TYPE;
5507: l_dimshort_name bisfv_dimension_levels.DIMENSION_SHORT_NAME%TYPE;
5508: l_dimlevel_name bisfv_dimension_levels.DIMENSION_LEVEL_SHORT_NAME%TYPE;
5509: l_dimshortname_time VARCHAR2(32000);
5510: l_lvlshortname_total VARCHAR2(32000);

Line 5507: l_dimshort_name bisfv_dimension_levels.DIMENSION_SHORT_NAME%TYPE;

5503: SELECT source ,dimension_short_name, dimension_level_short_name
5504: FROM bisfv_dimension_levels
5505: WHERE dimension_level_id = p_bis_dimlevel_id;
5506: l_source bisfv_dimension_levels.SOURCE%TYPE;
5507: l_dimshort_name bisfv_dimension_levels.DIMENSION_SHORT_NAME%TYPE;
5508: l_dimlevel_name bisfv_dimension_levels.DIMENSION_LEVEL_SHORT_NAME%TYPE;
5509: l_dimshortname_time VARCHAR2(32000);
5510: l_lvlshortname_total VARCHAR2(32000);
5511: BEGIN

Line 5508: l_dimlevel_name bisfv_dimension_levels.DIMENSION_LEVEL_SHORT_NAME%TYPE;

5504: FROM bisfv_dimension_levels
5505: WHERE dimension_level_id = p_bis_dimlevel_id;
5506: l_source bisfv_dimension_levels.SOURCE%TYPE;
5507: l_dimshort_name bisfv_dimension_levels.DIMENSION_SHORT_NAME%TYPE;
5508: l_dimlevel_name bisfv_dimension_levels.DIMENSION_LEVEL_SHORT_NAME%TYPE;
5509: l_dimshortname_time VARCHAR2(32000);
5510: l_lvlshortname_total VARCHAR2(32000);
5511: BEGIN
5512: x_return_status := FND_API.G_RET_STS_SUCCESS;