eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_DIMENSION_LEVEL_PVT dependencies on BIS_LEVELS

Line 1212: select bis_levels_s.NextVal into l_id from dual;

1208:
1209:
1210: IF ( l_level_name_is_used = FALSE ) THEN
1211:
1212: select bis_levels_s.NextVal into l_id from dual;
1213:
1214: l_Dimension_Level_Rec.Last_Update_Date := NVL(p_Dimension_Level_Rec.Last_Update_Date, SYSDATE);
1215:
1216: Create_New_Dimension_Level

Line 1318: FROM bis_levels_vl

1314: BEGIN
1315:
1316: SELECT level_id
1317: INTO l_level_id
1318: FROM bis_levels_vl
1319: WHERE
1320: name = p_level_name
1321: AND source = p_source
1322: AND dimension_id = p_dimension_id;

Line 1374: insert into bis_levels(

1370:
1371:
1372: SAVEPOINT InsertIntoBISLevels;
1373:
1374: insert into bis_levels(
1375: LEVEL_ID
1376: , SHORT_NAME
1377: , DIMENSION_ID
1378: , LEVEL_VALUES_VIEW_NAME

Line 1423: insert into bis_LEVELS_TL (

1419: , p_drill_to_form_function
1420: , p_hide
1421: );
1422:
1423: insert into bis_LEVELS_TL (
1424: LEVEL_ID,
1425: LANGUAGE,
1426: NAME,
1427: DESCRIPTION,

Line 1448: , BIS_LEVELS DL

1444: , p_login_id
1445: , 'Y'
1446: , userenv('LANG')
1447: from FND_LANGUAGES L
1448: , BIS_LEVELS DL
1449: where L.INSTALLED_FLAG in ('I', 'B')
1450: and DL.SHORT_NAME = p_level_short_name
1451: and not exists
1452: (select 'EXIST'

Line 1453: from BIS_LEVELS_TL TL

1449: where L.INSTALLED_FLAG in ('I', 'B')
1450: and DL.SHORT_NAME = p_level_short_name
1451: and not exists
1452: (select 'EXIST'
1453: from BIS_LEVELS_TL TL
1454: , BIS_LEVELS T
1455: where T.level_ID = TL.level_id
1456: and T.SHORT_NAME = p_level_short_name
1457: and TL.LANGUAGE = L.LANGUAGE_CODE);

Line 1454: , BIS_LEVELS T

1450: and DL.SHORT_NAME = p_level_short_name
1451: and not exists
1452: (select 'EXIST'
1453: from BIS_LEVELS_TL TL
1454: , BIS_LEVELS T
1455: where T.level_ID = TL.level_id
1456: and T.SHORT_NAME = p_level_short_name
1457: and TL.LANGUAGE = L.LANGUAGE_CODE);
1458:

Line 1609: Update bis_Levels

1605: END IF;
1606: ------------------
1607:
1608: l_Dimension_Level_Rec.Last_Update_Date := NVL(p_Dimension_Level_Rec.Last_Update_Date, SYSDATE);
1609: Update bis_Levels
1610: set
1611: SHORT_NAME = l_Dimension_Level_Rec.Dimension_Level_Short_Name
1612: , DIMENSION_ID = l_Dimension_Level_Rec.Dimension_ID
1613: , LEVEL_VALUES_VIEW_NAME = l_Dimension_Level_Rec.Level_Values_View_Name

Line 1772: Update bis_levels_TL

1768: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1769: l_login_id := fnd_global.LOGIN_ID;
1770: --
1771: l_Dimension_Level_Rec.Last_Update_Date := NVL(p_Dimension_Level_Rec.Last_Update_Date, SYSDATE);
1772: Update bis_levels_TL
1773: set
1774: NAME = l_Dimension_Level_Rec.Dimension_Level_Name
1775: , DESCRIPTION = l_Dimension_Level_Rec.description
1776: , LAST_UPDATE_DATE = l_Dimension_Level_Rec.Last_Update_Date

Line 2026: FROM BIS_LEVELS

2022: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2023:
2024: CURSOR cr_dim_short_name IS
2025: SELECT level_id
2026: FROM BIS_LEVELS
2027: WHERE short_name = p_Dimension_Level_Rec.Dimension_Level_Short_Name;
2028: BEGIN
2029: SAVEPOINT DeleteFromBISDimLevs;
2030:

Line 2055: DELETE FROM bis_levels

2051: RAISE FND_API.G_EXC_ERROR;
2052: END IF;
2053:
2054: IF(l_dim_level_id IS NOT NULL) THEN
2055: DELETE FROM bis_levels
2056: WHERE level_id = l_dim_level_id;
2057:
2058: DELETE FROM bis_levels_tl
2059: WHERE level_id = l_dim_level_id;

Line 2058: DELETE FROM bis_levels_tl

2054: IF(l_dim_level_id IS NOT NULL) THEN
2055: DELETE FROM bis_levels
2056: WHERE level_id = l_dim_level_id;
2057:
2058: DELETE FROM bis_levels_tl
2059: WHERE level_id = l_dim_level_id;
2060: END IF;
2061: IF (p_commit = FND_API.G_TRUE) THEN
2062: COMMIT;

Line 2115: FROM BIS_LEVELS

2111:
2112:
2113: SELECT LEVEL_ID
2114: INTO l_dim_level_id
2115: FROM BIS_LEVELS
2116: WHERE SHORT_NAME = p_Dimension_Level_Rec.Dimension_Level_Short_Name;
2117:
2118: UPDATE BIS_LEVELS_TL
2119: SET NAME = p_Dimension_Level_Rec.Dimension_Level_Name

Line 2118: UPDATE BIS_LEVELS_TL

2114: INTO l_dim_level_id
2115: FROM BIS_LEVELS
2116: WHERE SHORT_NAME = p_Dimension_Level_Rec.Dimension_Level_Short_Name;
2117:
2118: UPDATE BIS_LEVELS_TL
2119: SET NAME = p_Dimension_Level_Rec.Dimension_Level_Name
2120: , DESCRIPTION = p_Dimension_Level_Rec.Description
2121: , SOURCE_LANG = p_Dimension_Level_Rec.Source_Lang
2122: , LAST_UPDATED_BY = l_user_id

Line 2166: FROM BIS_LEVELS_CUSTOMIZATIONS_VL

2162: APPLICATION_ID,
2163: RESPONSIBILITY_ID,
2164: ORG_ID,
2165: SITE_ID
2166: FROM BIS_LEVELS_CUSTOMIZATIONS_VL
2167: WHERE LEVEL_ID = p_dim_level_id
2168: AND (user_id = fnd_global.user_id
2169: OR responsibility_id = fnd_global.RESP_ID
2170: OR application_id = fnd_global.RESP_APPL_ID

Line 2173: l_dim_lvl_custom_name_usr bis_levels_customizations_tl.name%TYPE;

2169: OR responsibility_id = fnd_global.RESP_ID
2170: OR application_id = fnd_global.RESP_APPL_ID
2171: OR org_id = fnd_global.ORG_ID
2172: OR site_id = 0) ;
2173: l_dim_lvl_custom_name_usr bis_levels_customizations_tl.name%TYPE;
2174: l_dim_lvl_custom_name_resp bis_levels_customizations_tl.name%TYPE;
2175: l_dim_lvl_custom_name_appl bis_levels_customizations_tl.name%TYPE;
2176: l_dim_lvl_custom_name_org bis_levels_customizations_tl.name%TYPE;
2177: l_dim_lvl_custom_name_site bis_levels_customizations_tl.name%TYPE;

Line 2174: l_dim_lvl_custom_name_resp bis_levels_customizations_tl.name%TYPE;

2170: OR application_id = fnd_global.RESP_APPL_ID
2171: OR org_id = fnd_global.ORG_ID
2172: OR site_id = 0) ;
2173: l_dim_lvl_custom_name_usr bis_levels_customizations_tl.name%TYPE;
2174: l_dim_lvl_custom_name_resp bis_levels_customizations_tl.name%TYPE;
2175: l_dim_lvl_custom_name_appl bis_levels_customizations_tl.name%TYPE;
2176: l_dim_lvl_custom_name_org bis_levels_customizations_tl.name%TYPE;
2177: l_dim_lvl_custom_name_site bis_levels_customizations_tl.name%TYPE;
2178: BEGIN

Line 2175: l_dim_lvl_custom_name_appl bis_levels_customizations_tl.name%TYPE;

2171: OR org_id = fnd_global.ORG_ID
2172: OR site_id = 0) ;
2173: l_dim_lvl_custom_name_usr bis_levels_customizations_tl.name%TYPE;
2174: l_dim_lvl_custom_name_resp bis_levels_customizations_tl.name%TYPE;
2175: l_dim_lvl_custom_name_appl bis_levels_customizations_tl.name%TYPE;
2176: l_dim_lvl_custom_name_org bis_levels_customizations_tl.name%TYPE;
2177: l_dim_lvl_custom_name_site bis_levels_customizations_tl.name%TYPE;
2178: BEGIN
2179: IF (c_cust%ISOPEN) THEN

Line 2176: l_dim_lvl_custom_name_org bis_levels_customizations_tl.name%TYPE;

2172: OR site_id = 0) ;
2173: l_dim_lvl_custom_name_usr bis_levels_customizations_tl.name%TYPE;
2174: l_dim_lvl_custom_name_resp bis_levels_customizations_tl.name%TYPE;
2175: l_dim_lvl_custom_name_appl bis_levels_customizations_tl.name%TYPE;
2176: l_dim_lvl_custom_name_org bis_levels_customizations_tl.name%TYPE;
2177: l_dim_lvl_custom_name_site bis_levels_customizations_tl.name%TYPE;
2178: BEGIN
2179: IF (c_cust%ISOPEN) THEN
2180: CLOSE c_cust;

Line 2177: l_dim_lvl_custom_name_site bis_levels_customizations_tl.name%TYPE;

2173: l_dim_lvl_custom_name_usr bis_levels_customizations_tl.name%TYPE;
2174: l_dim_lvl_custom_name_resp bis_levels_customizations_tl.name%TYPE;
2175: l_dim_lvl_custom_name_appl bis_levels_customizations_tl.name%TYPE;
2176: l_dim_lvl_custom_name_org bis_levels_customizations_tl.name%TYPE;
2177: l_dim_lvl_custom_name_site bis_levels_customizations_tl.name%TYPE;
2178: BEGIN
2179: IF (c_cust%ISOPEN) THEN
2180: CLOSE c_cust;
2181: END IF;

Line 2227: FROM BIS_LEVELS_CUSTOMIZATIONS_VL

2223: APPLICATION_ID,
2224: RESPONSIBILITY_ID,
2225: ORG_ID,
2226: SITE_ID
2227: FROM BIS_LEVELS_CUSTOMIZATIONS_VL
2228: WHERE LEVEL_ID = p_dim_level_id
2229: AND (user_id = fnd_global.user_id
2230: OR responsibility_id = fnd_global.RESP_ID
2231: OR application_id = fnd_global.RESP_APPL_ID

Line 2234: l_dim_lvl_custom_desc_usr bis_levels_customizations_tl.description%TYPE;

2230: OR responsibility_id = fnd_global.RESP_ID
2231: OR application_id = fnd_global.RESP_APPL_ID
2232: OR org_id = fnd_global.ORG_ID
2233: OR site_id = 0) ;
2234: l_dim_lvl_custom_desc_usr bis_levels_customizations_tl.description%TYPE;
2235: l_dim_lvl_custom_desc_resp bis_levels_customizations_tl.description%TYPE;
2236: l_dim_lvl_custom_desc_appl bis_levels_customizations_tl.description%TYPE;
2237: l_dim_lvl_custom_desc_org bis_levels_customizations_tl.description%TYPE;
2238: l_dim_lvl_custom_desc_site bis_levels_customizations_tl.description%TYPE;

Line 2235: l_dim_lvl_custom_desc_resp bis_levels_customizations_tl.description%TYPE;

2231: OR application_id = fnd_global.RESP_APPL_ID
2232: OR org_id = fnd_global.ORG_ID
2233: OR site_id = 0) ;
2234: l_dim_lvl_custom_desc_usr bis_levels_customizations_tl.description%TYPE;
2235: l_dim_lvl_custom_desc_resp bis_levels_customizations_tl.description%TYPE;
2236: l_dim_lvl_custom_desc_appl bis_levels_customizations_tl.description%TYPE;
2237: l_dim_lvl_custom_desc_org bis_levels_customizations_tl.description%TYPE;
2238: l_dim_lvl_custom_desc_site bis_levels_customizations_tl.description%TYPE;
2239: BEGIN

Line 2236: l_dim_lvl_custom_desc_appl bis_levels_customizations_tl.description%TYPE;

2232: OR org_id = fnd_global.ORG_ID
2233: OR site_id = 0) ;
2234: l_dim_lvl_custom_desc_usr bis_levels_customizations_tl.description%TYPE;
2235: l_dim_lvl_custom_desc_resp bis_levels_customizations_tl.description%TYPE;
2236: l_dim_lvl_custom_desc_appl bis_levels_customizations_tl.description%TYPE;
2237: l_dim_lvl_custom_desc_org bis_levels_customizations_tl.description%TYPE;
2238: l_dim_lvl_custom_desc_site bis_levels_customizations_tl.description%TYPE;
2239: BEGIN
2240: IF (c_cust%ISOPEN) THEN

Line 2237: l_dim_lvl_custom_desc_org bis_levels_customizations_tl.description%TYPE;

2233: OR site_id = 0) ;
2234: l_dim_lvl_custom_desc_usr bis_levels_customizations_tl.description%TYPE;
2235: l_dim_lvl_custom_desc_resp bis_levels_customizations_tl.description%TYPE;
2236: l_dim_lvl_custom_desc_appl bis_levels_customizations_tl.description%TYPE;
2237: l_dim_lvl_custom_desc_org bis_levels_customizations_tl.description%TYPE;
2238: l_dim_lvl_custom_desc_site bis_levels_customizations_tl.description%TYPE;
2239: BEGIN
2240: IF (c_cust%ISOPEN) THEN
2241: CLOSE c_cust;

Line 2238: l_dim_lvl_custom_desc_site bis_levels_customizations_tl.description%TYPE;

2234: l_dim_lvl_custom_desc_usr bis_levels_customizations_tl.description%TYPE;
2235: l_dim_lvl_custom_desc_resp bis_levels_customizations_tl.description%TYPE;
2236: l_dim_lvl_custom_desc_appl bis_levels_customizations_tl.description%TYPE;
2237: l_dim_lvl_custom_desc_org bis_levels_customizations_tl.description%TYPE;
2238: l_dim_lvl_custom_desc_site bis_levels_customizations_tl.description%TYPE;
2239: BEGIN
2240: IF (c_cust%ISOPEN) THEN
2241: CLOSE c_cust;
2242: END IF;

Line 2280: l_dim_level_id bis_levels.level_id%TYPE;

2276: RETURN NULL;
2277: END get_customized_description;
2278:
2279: FUNCTION get_customized_enabled( p_dim_level_sht_name IN VARCHAR2) RETURN VARCHAR2 AS
2280: l_dim_level_id bis_levels.level_id%TYPE;
2281: l_dim_level_enabled bis_levels.enabled%TYPE;
2282: l_dim_level_custom_enabled bis_levels_customizations.enabled%TYPE;
2283: BEGIN
2284: SELECT LEVEL_ID,ENABLED

Line 2281: l_dim_level_enabled bis_levels.enabled%TYPE;

2277: END get_customized_description;
2278:
2279: FUNCTION get_customized_enabled( p_dim_level_sht_name IN VARCHAR2) RETURN VARCHAR2 AS
2280: l_dim_level_id bis_levels.level_id%TYPE;
2281: l_dim_level_enabled bis_levels.enabled%TYPE;
2282: l_dim_level_custom_enabled bis_levels_customizations.enabled%TYPE;
2283: BEGIN
2284: SELECT LEVEL_ID,ENABLED
2285: INTO l_dim_level_id,l_dim_level_enabled

Line 2282: l_dim_level_custom_enabled bis_levels_customizations.enabled%TYPE;

2278:
2279: FUNCTION get_customized_enabled( p_dim_level_sht_name IN VARCHAR2) RETURN VARCHAR2 AS
2280: l_dim_level_id bis_levels.level_id%TYPE;
2281: l_dim_level_enabled bis_levels.enabled%TYPE;
2282: l_dim_level_custom_enabled bis_levels_customizations.enabled%TYPE;
2283: BEGIN
2284: SELECT LEVEL_ID,ENABLED
2285: INTO l_dim_level_id,l_dim_level_enabled
2286: FROM BIS_LEVELS

Line 2286: FROM BIS_LEVELS

2282: l_dim_level_custom_enabled bis_levels_customizations.enabled%TYPE;
2283: BEGIN
2284: SELECT LEVEL_ID,ENABLED
2285: INTO l_dim_level_id,l_dim_level_enabled
2286: FROM BIS_LEVELS
2287: WHERE short_name = p_dim_level_sht_name;
2288:
2289: IF l_dim_level_id IS NOT NULL THEN
2290: l_dim_level_custom_enabled := get_customized_enabled(l_dim_level_id);

Line 2309: FROM BIS_LEVELS_CUSTOMIZATIONS

2305: APPLICATION_ID,
2306: RESPONSIBILITY_ID,
2307: ORG_ID,
2308: SITE_ID
2309: FROM BIS_LEVELS_CUSTOMIZATIONS
2310: WHERE LEVEL_ID = p_dim_level_id
2311: AND (user_id = fnd_global.user_id
2312: OR responsibility_id = fnd_global.RESP_ID
2313: OR application_id = fnd_global.RESP_APPL_ID

Line 2316: l_dim_lvl_custom_enabled_usr bis_levels_customizations.enabled%TYPE;

2312: OR responsibility_id = fnd_global.RESP_ID
2313: OR application_id = fnd_global.RESP_APPL_ID
2314: OR org_id = fnd_global.ORG_ID
2315: OR site_id = 0) ;
2316: l_dim_lvl_custom_enabled_usr bis_levels_customizations.enabled%TYPE;
2317: l_dim_lvl_custom_enabled_resp bis_levels_customizations.enabled%TYPE;
2318: l_dim_lvl_custom_enabled_appl bis_levels_customizations.enabled%TYPE;
2319: l_dim_lvl_custom_enabled_org bis_levels_customizations.enabled%TYPE;
2320: l_dim_lvl_custom_enabled_site bis_levels_customizations.enabled%TYPE;

Line 2317: l_dim_lvl_custom_enabled_resp bis_levels_customizations.enabled%TYPE;

2313: OR application_id = fnd_global.RESP_APPL_ID
2314: OR org_id = fnd_global.ORG_ID
2315: OR site_id = 0) ;
2316: l_dim_lvl_custom_enabled_usr bis_levels_customizations.enabled%TYPE;
2317: l_dim_lvl_custom_enabled_resp bis_levels_customizations.enabled%TYPE;
2318: l_dim_lvl_custom_enabled_appl bis_levels_customizations.enabled%TYPE;
2319: l_dim_lvl_custom_enabled_org bis_levels_customizations.enabled%TYPE;
2320: l_dim_lvl_custom_enabled_site bis_levels_customizations.enabled%TYPE;
2321: BEGIN

Line 2318: l_dim_lvl_custom_enabled_appl bis_levels_customizations.enabled%TYPE;

2314: OR org_id = fnd_global.ORG_ID
2315: OR site_id = 0) ;
2316: l_dim_lvl_custom_enabled_usr bis_levels_customizations.enabled%TYPE;
2317: l_dim_lvl_custom_enabled_resp bis_levels_customizations.enabled%TYPE;
2318: l_dim_lvl_custom_enabled_appl bis_levels_customizations.enabled%TYPE;
2319: l_dim_lvl_custom_enabled_org bis_levels_customizations.enabled%TYPE;
2320: l_dim_lvl_custom_enabled_site bis_levels_customizations.enabled%TYPE;
2321: BEGIN
2322: IF (c_cust%ISOPEN) THEN

Line 2319: l_dim_lvl_custom_enabled_org bis_levels_customizations.enabled%TYPE;

2315: OR site_id = 0) ;
2316: l_dim_lvl_custom_enabled_usr bis_levels_customizations.enabled%TYPE;
2317: l_dim_lvl_custom_enabled_resp bis_levels_customizations.enabled%TYPE;
2318: l_dim_lvl_custom_enabled_appl bis_levels_customizations.enabled%TYPE;
2319: l_dim_lvl_custom_enabled_org bis_levels_customizations.enabled%TYPE;
2320: l_dim_lvl_custom_enabled_site bis_levels_customizations.enabled%TYPE;
2321: BEGIN
2322: IF (c_cust%ISOPEN) THEN
2323: CLOSE c_cust;

Line 2320: l_dim_lvl_custom_enabled_site bis_levels_customizations.enabled%TYPE;

2316: l_dim_lvl_custom_enabled_usr bis_levels_customizations.enabled%TYPE;
2317: l_dim_lvl_custom_enabled_resp bis_levels_customizations.enabled%TYPE;
2318: l_dim_lvl_custom_enabled_appl bis_levels_customizations.enabled%TYPE;
2319: l_dim_lvl_custom_enabled_org bis_levels_customizations.enabled%TYPE;
2320: l_dim_lvl_custom_enabled_site bis_levels_customizations.enabled%TYPE;
2321: BEGIN
2322: IF (c_cust%ISOPEN) THEN
2323: CLOSE c_cust;
2324: END IF;

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: