APPS.BSC_BIS_CUSTOM_KPI_UTIL_PUB dependencies on AK_REGIONS

Line 850: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;

846: p_Short_Name IN VARCHAR2
847: ) RETURN VARCHAR2
848: IS
849: l_Count NUMBER;
850: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;
851: l_Source_Type AK_REGIONS.ATTRIBUTE10%TYPE;
852: BEGIN
853:
854: IF (p_Short_Name IS NULL) THEN

Line 851: l_Source_Type AK_REGIONS.ATTRIBUTE10%TYPE;

847: ) RETURN VARCHAR2
848: IS
849: l_Count NUMBER;
850: l_Region_Code AK_REGIONS.REGION_CODE%TYPE;
851: l_Source_Type AK_REGIONS.ATTRIBUTE10%TYPE;
852: BEGIN
853:
854: IF (p_Short_Name IS NULL) THEN
855: RETURN FND_API.G_FALSE;

Line 862: FROM AK_REGIONS R

858: -- we populate the Objective with FUNCTION_NAME of the report.
859: l_Region_Code := BIS_PMV_UTIL.GetReportRegion(p_Short_Name);
860:
861: SELECT R.ATTRIBUTE10 INTO l_Source_Type
862: FROM AK_REGIONS R
863: WHERE R.REGION_CODE = l_Region_Code;
864:
865: IF (l_Source_Type = C_BSC_DATA_SOURCE) THEN
866: RETURN FND_API.G_TRUE;