DBA Data[Home] [Help]

APPS.BIS_DIMENSION_LEVEL_PVT dependencies on BSC_SYS_DIM_LEVELS_B

Line 2362: l_do_source BSC_SYS_DIM_LEVELS_B.SOURCE%TYPE;

2358: RETURN NULL;
2359: END get_customized_enabled;
2360:
2361: FUNCTION isPMFDimensionLevel(p_dim_level_id IN NUMBER) RETURN BOOLEAN AS
2362: l_do_source BSC_SYS_DIM_LEVELS_B.SOURCE%TYPE;
2363: CURSOR c_do_src(cp_dim_level_id IN VARCHAR2) IS
2364: SELECT do.source FROM bsc_sys_dim_levels_b do, bis_levels dl WHERE do.short_name = dl.short_name
2365: AND dl.level_id = cp_dim_level_id;
2366: BEGIN

Line 2364: SELECT do.source FROM bsc_sys_dim_levels_b do, bis_levels dl WHERE do.short_name = dl.short_name

2360:
2361: FUNCTION isPMFDimensionLevel(p_dim_level_id IN NUMBER) RETURN BOOLEAN AS
2362: l_do_source BSC_SYS_DIM_LEVELS_B.SOURCE%TYPE;
2363: CURSOR c_do_src(cp_dim_level_id IN VARCHAR2) IS
2364: SELECT do.source FROM bsc_sys_dim_levels_b do, bis_levels dl WHERE do.short_name = dl.short_name
2365: AND dl.level_id = cp_dim_level_id;
2366: BEGIN
2367: -- check if the dimension level type is of PMF and then check if this can be disabled.
2368: IF (c_do_src%ISOPEN) THEN

Line 2415: bsc_sys_dim_levels_b do , bis_levels lvl

2411: FUNCTION IS_ASSIGNED_TO_KPI( p_dim_level_id IN NUMBER) RETURN BOOLEAN IS
2412: l_kpi_assing_usage NUMBER;
2413: BEGIN
2414: SELECT COUNT(1) INTO l_kpi_assing_usage FROM bsc_kpi_dim_levels_b kpi,
2415: bsc_sys_dim_levels_b do , bis_levels lvl
2416: WHERE do.level_table_name = kpi.level_table_name
2417: AND do.short_name = lvl.short_name
2418: AND lvl.level_id = p_dim_level_id;
2419: