APPS.BSC_UTILITY dependencies on AK_REGION_ITEMS

Line 2542: l_sql := 'SELECT DISTINCT REGION_CODE FROM ak_region_items WHERE node_query_flag = ''Y'' AND node_display_flag = ''N'' AND SUBSTR(attribute2,INSTR(attribute2,''+'') +1 ,LENGTH(attribute2)) IN (' ;

2538: FND_MSG_PUB.Initialize;
2539: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2540: IF (p_Short_Names IS NOT NULL) THEN
2541: x_region_codes := FND_TABLE_OF_VARCHAR2_30();
2542: l_sql := 'SELECT DISTINCT REGION_CODE FROM ak_region_items WHERE node_query_flag = ''Y'' AND node_display_flag = ''N'' AND SUBSTR(attribute2,INSTR(attribute2,''+'') +1 ,LENGTH(attribute2)) IN (' ;
2543: l_short_names := p_Short_Names;
2544: WHILE (BSC_UTILITY.is_more( l_short_names,l_dim_obj_sht_name)) LOOP
2545: l_attr2_sql := l_attr2_sql || '''' || l_dim_obj_sht_name || ''',' ;
2546: END LOOP;

Line 2592: FROM ak_region_items

2588: l_report_name VARCHAR2(100);
2589:
2590: CURSOR c_regions_dim IS
2591: SELECT DISTINCT REGION_CODE
2592: FROM ak_region_items
2593: WHERE attribute2 LIKE p_Short_name ||'+%'
2594: AND attribute1 IN ('VIEWBY PARAMETER', 'DIMENSION LEVEL', 'DIM LEVEL SINGLE VALUE', 'HIDE VIEW BY DIMENSION');
2595:
2596: CURSOR c_regions_dim_grp IS

Line 2603: FROM ak_region_items

2599: WHERE attribute12 = p_Short_Name;
2600:
2601: CURSOR c_regions_dim_obj IS
2602: SELECT DISTINCT REGION_CODE
2603: FROM ak_region_items
2604: WHERE attribute2 = p_Short_name
2605: AND attribute1 IN ('VIEWBY PARAMETER', 'DIMENSION LEVEL', 'DIM LEVEL SINGLE VALUE', 'HIDE VIEW BY DIMENSION');
2606: BEGIN
2607:

Line 4095: l_attribute2 ak_region_items.attribute2%TYPE;

4091: )RETURN VARCHAR2
4092: IS
4093: l_count NUMBER;
4094: l_flag VARCHAR2(10);
4095: l_attribute2 ak_region_items.attribute2%TYPE;
4096: BEGIN
4097:
4098: l_flag := FND_API.G_FALSE;
4099: l_count := 0;

Line 4108: FROM ak_region_items a,

4104: WHERE dataset_id =p_dataset_id;
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