APPS.BSC_UTILITY dependencies on AK_REGIONS

Line 2211: ak_regions without using indexed columns.

2207: /****************************************************************************************************
2208: The following three apis are taken from Is_Internal_Dim. They are required for fixes of bug#4602231
2209: where the Dimension LOV window will only call Is_Internal_AG_Dim and Is_Internal_BIS_Import_Dim
2210: to boost LOV performance. Is_Internal_WKPI_Dim is causing performance issue since it queries
2211: ak_regions without using indexed columns.
2212: ****************************************************************************************************/
2213: FUNCTION Is_Internal_AG_Dim(p_Short_Name IN VARCHAR2)
2214: RETURN VARCHAR2 IS
2215: l_Count NUMBER;

Line 2260: FROM ak_regions

2256: BEGIN
2257: -- Condition for Dimension Group created/used in Weighted Report.
2258: SELECT COUNT(1)
2259: INTO l_Count
2260: FROM ak_regions
2261: WHERE attribute_category = BSC_UTILITY.C_ATTRIBUTE_CATEGORY
2262: AND attribute10 = BSC_UTILITY.C_REPORT_TYPE_MDS
2263: AND attribute12 = p_Short_Name;
2264:

Line 2279: FROM ak_regions

2275: BEGIN
2276: -- Condition for Dimension Group created/used in Table Based Report.
2277: SELECT COUNT(1)
2278: INTO l_Count
2279: FROM ak_regions
2280: WHERE attribute_category = BSC_UTILITY.C_ATTRIBUTE_CATEGORY
2281: AND attribute10 = BSC_UTILITY.C_REPORT_TYPE_TABLE
2282: AND attribute12 = p_Short_Name;
2283:

Line 2290: FROM ak_regions

2286: END IF;
2287:
2288: SELECT COUNT(1)
2289: INTO l_Count
2290: FROM ak_regions
2291: WHERE attribute_category = BSC_UTILITY.C_ATTRIBUTE_CATEGORY
2292: AND attribute10 IS NULL
2293: AND attribute12 = p_Short_Name;
2294:

Line 2532: l_region_sht_name AK_REGIONS.REGION_CODE%TYPE;

2528: ) IS
2529: l_short_names VARCHAR2(32000);
2530: l_sql VARCHAR2(32000);
2531: l_attr2_sql VARCHAR2(32000);
2532: l_region_sht_name AK_REGIONS.REGION_CODE%TYPE;
2533: l_dim_obj_sht_name BIS_LEVELS.SHORT_NAME%TYPE;
2534: l_count NUMBER := 0;
2535: TYPE ref_cur IS REF CURSOR;
2536: c_regions_dim_obj ref_cur;

Line 2598: FROM ak_regions

2594: AND attribute1 IN ('VIEWBY PARAMETER', 'DIMENSION LEVEL', 'DIM LEVEL SINGLE VALUE', 'HIDE VIEW BY DIMENSION');
2595:
2596: CURSOR c_regions_dim_grp IS
2597: SELECT region_code
2598: FROM ak_regions
2599: WHERE attribute12 = p_Short_Name;
2600:
2601: CURSOR c_regions_dim_obj IS
2602: SELECT DISTINCT REGION_CODE

Line 2660: SELECT name FROM ak_regions_vl

2656: WHERE parameters like '%pRegionCode='|| p_Region_Code ||'%'
2657: AND rownum < 2;
2658:
2659: CURSOR c_region_name IS
2660: SELECT name FROM ak_regions_vl
2661: WHERE region_code = p_Region_Code;
2662:
2663: BEGIN
2664: FOR c_function_name_val IN c_function_name LOOP

Line 4109: ak_regions b

4105:
4106: SELECT COUNT(1)
4107: INTO l_count
4108: FROM ak_region_items a,
4109: ak_regions b
4110: WHERE a.region_code = b.region_code
4111: AND a.attribute1 IN (BSC_UTILITY.C_ATTRTYPE_MEASURE,BSC_UTILITY.C_ATTRTYPE_MEASURE_NO_TARGET,BSC_UTILITY.C_BUCKET_MEASURE,BSC_UTILITY.C_SUB_MEASURE)
4112: AND a.attribute2 = l_attribute2
4113: AND b.attribute10 = BSC_UTILITY.C_MULTIPLE_DATA_SOURCE;