APPS.BSC_BIS_KPI_CRUD_PUB dependencies on AK_REGION_ITEMS_VL

Line 4722: -- Passed p_measure_name instead of Page Name for Measure Long Label AK_REGION_ITEMS_VL

4718: l_Max_Seq_Number := Find_Max_Seq_Of_Region_Item(l_Region_Code);
4719: l_Max_Seq_Number := l_Max_Seq_Number + 10;
4720:
4721:
4722: -- Passed p_measure_name instead of Page Name for Measure Long Label AK_REGION_ITEMS_VL
4723: -- for Bug#3802192
4724: -- Create Compare TO and Change Region Items
4725: Create_Addl_Ak_Region_Items(
4726: p_commit => p_Commit

Line 10211: FROM AK_REGION_ITEMS_VL AV

10207: , AV.ATTRIBUTE12
10208: , AV.ATTRIBUTE13
10209: , AV.ATTRIBUTE14
10210: , AV.ATTRIBUTE15
10211: FROM AK_REGION_ITEMS_VL AV
10212: WHERE AV.ITEM_STYLE <> BIS_AK_REGION_PUB.c_NESTED_REGION_STYLE
10213: AND AV.REGION_CODE = p_Region_Code
10214: AND AV.REGION_APPLICATION_ID = p_Region_Application_Id
10215: AND AV.ATTRIBUTE1 IN ('DIMENSION LEVEL',

Line 11588: l_attribute2 AK_REGION_ITEMS_VL.attribute2%TYPE;

11584: ,x_non_time_dim_dimObjs OUT NOCOPY BSC_VARCHAR2_TBL_TYPE
11585: ,x_non_time_counter OUT NOCOPY NUMBER
11586: ) IS
11587:
11588: l_attribute2 AK_REGION_ITEMS_VL.attribute2%TYPE;
11589: l_displayseq AK_REGION_ITEMS_VL.display_sequence%TYPE;
11590: l_dim VARCHAR2(1000);
11591:
11592: CURSOR c_dim_dimObj IS

Line 11589: l_displayseq AK_REGION_ITEMS_VL.display_sequence%TYPE;

11585: ,x_non_time_counter OUT NOCOPY NUMBER
11586: ) IS
11587:
11588: l_attribute2 AK_REGION_ITEMS_VL.attribute2%TYPE;
11589: l_displayseq AK_REGION_ITEMS_VL.display_sequence%TYPE;
11590: l_dim VARCHAR2(1000);
11591:
11592: CURSOR c_dim_dimObj IS
11593: SELECT DISTINCT a.attribute2, a.display_sequence