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