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_CUSTOMIZATIONS

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 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 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;