APPS.BSC_PMF_UI_API_PUB dependencies on AK_REGION_ITEMS

Line 1466: -- Cursor to get the Dimension Level Info from ak_region_items table ---------

1462: l_DimLevel_Viewby_Tbl DimLevel_Viewby_Tbl_Type;
1463: l_index number;
1464: NOT_VALID_DIMENSION VARCHAR2(40) := 'BSC_NOT_VALID_DIMENSION_FLAG' ;
1465:
1466: -- Cursor to get the Dimension Level Info from ak_region_items table ---------
1467:
1468: CURSOR c_region IS
1469: SELECT region_code
1470: FROM ak_region_items

Line 1470: FROM ak_region_items

1466: -- Cursor to get the Dimension Level Info from ak_region_items table ---------
1467:
1468: CURSOR c_region IS
1469: SELECT region_code
1470: FROM ak_region_items
1471: WHERE attribute1='MEASURE'
1472: AND attribute2 = p_Measure_Short_Name
1473: ORDER BY creation_date DESC;
1474:

Line 1477: FROM ak_region_items

1473: ORDER BY creation_date DESC;
1474:
1475: CURSOR c_nested_region IS
1476: SELECT DISTINCT nested_region_code
1477: FROM ak_region_items
1478: WHERE region_code = l_Region_Code
1479: AND item_style = 'NESTED_REGION';
1480:
1481: CURSOR c_Viewby_Report IS

Line 1488: FROM ak_region_items

1484: WHERE region_code = l_Region_Code;
1485:
1486: CURSOR c_dim_levels IS
1487: SELECT attribute2, attribute1, required_flag
1488: FROM ak_region_items
1489: WHERE region_code = l_Region_Code
1490: AND (attribute1 = 'DIMENSION LEVEL' OR attribute1 = 'HIDE PARAMETER' OR attribute1 = 'HIDE VIEW BY DIMENSION')
1491: ORDER BY attribute2, attribute1;
1492:

Line 1493: -- Cursor to get the Dimension Level Info from ak_region_items table when exists a Nested Region

1489: WHERE region_code = l_Region_Code
1490: AND (attribute1 = 'DIMENSION LEVEL' OR attribute1 = 'HIDE PARAMETER' OR attribute1 = 'HIDE VIEW BY DIMENSION')
1491: ORDER BY attribute2, attribute1;
1492:
1493: -- Cursor to get the Dimension Level Info from ak_region_items table when exists a Nested Region
1494: CURSOR c_dim_levels1 IS
1495: SELECT attribute2, attribute1, region_code, required_flag
1496: FROM ak_region_items
1497: WHERE (region_code = l_Region_Code OR region_code = l_nested_region_code)

Line 1496: FROM ak_region_items

1492:
1493: -- Cursor to get the Dimension Level Info from ak_region_items table when exists a Nested Region
1494: CURSOR c_dim_levels1 IS
1495: SELECT attribute2, attribute1, region_code, required_flag
1496: FROM ak_region_items
1497: WHERE (region_code = l_Region_Code OR region_code = l_nested_region_code)
1498: AND (attribute1 = 'DIMENSION LEVEL' OR attribute1 = 'HIDE PARAMETER' OR attribute1 = 'HIDE VIEW BY DIMENSION')
1499: ORDER BY attribute2, attribute1, region_code;
1500: Begin

Line 1508: --So we have to query ak_region_items table to get the region_code

1504:
1505: -- Check the Region code passed to the API
1506: if p_Region_Code is null then
1507: --If the region_code passed to the API is NULL, then the Measure is not associated with any Report.
1508: --So we have to query ak_region_items table to get the region_code
1509:
1510: OPEN c_region;
1511: FETCH c_region INTO l_Region_Code;
1512: if c_region%NOTFOUND then