13: ,x_msg_count OUT NOCOPY number
14: ,x_msg_data OUT NOCOPY varchar2
15: ) IS
16:
17: v_Common_Level_ReTrieved_Tbl BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type;
18: v_Common_Level_Found_Tbl BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type;
19:
20: v_Dim_Level_Rec_R BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
21: v_Dim_Level_Rec_F BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
14: ,x_msg_data OUT NOCOPY varchar2
15: ) IS
16:
17: v_Common_Level_ReTrieved_Tbl BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type;
18: v_Common_Level_Found_Tbl BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type;
19:
20: v_Dim_Level_Rec_R BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
21: v_Dim_Level_Rec_F BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
22: v_Index NUMBER;
16:
17: v_Common_Level_ReTrieved_Tbl BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type;
18: v_Common_Level_Found_Tbl BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type;
19:
20: v_Dim_Level_Rec_R BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
21: v_Dim_Level_Rec_F BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
22: v_Index NUMBER;
23: v_Parent_Dim_Level_Id NUMBER;
24: l_deleted_rows NUMBER;
17: v_Common_Level_ReTrieved_Tbl BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type;
18: v_Common_Level_Found_Tbl BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type;
19:
20: v_Dim_Level_Rec_R BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
21: v_Dim_Level_Rec_F BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
22: v_Index NUMBER;
23: v_Parent_Dim_Level_Id NUMBER;
24: l_deleted_rows NUMBER;
25: l_Bsc_Tab_Entity_Rec BSC_SCORECARD_PUB.Bsc_Tab_Entity_Rec;
332: -------------------------------------------------------------------------------------------------------------------
333: PROCEDURE Find_Common_Dim_Levels(
334: p_commit IN varchar2 := FND_API.G_FALSE
335: ,p_Tab_Id IN number
336: ,x_Dim_Level_Tbl OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type
337: ,x_return_status OUT NOCOPY varchar2
338: ,x_msg_count OUT NOCOPY number
339: ,x_msg_data OUT NOCOPY varchar2
340: ) IS
340: ) IS
341:
342: v_Num_KPI_Default_PMF number; /* Number of KPIs With Default PMF Measures */
343: v_Num_Dim_Sets_In_Tab number;
344: v_Dim_Level_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
345:
346: v_Index number;
347: v_Parent_Dim_Level_Id number;
348:
585: -------------------------------------------------------------------------------------------------------------------*/
586: PROCEDURE Retrieve_Common_Dim_Levels(
587: p_commit IN varchar2 := FND_API.G_FALSE
588: ,p_Tab_Id IN number
589: ,x_Dim_Level_Tbl OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type
590: ,x_return_status OUT NOCOPY varchar2
591: ,x_msg_count OUT NOCOPY number
592: ,x_msg_data OUT NOCOPY varchar2
593: ) IS
593: ) IS
594:
595: -- used
596:
597: v_Dim_Level_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
598: v_Index number;
599: v_Parent_Dim_Level_Id number;
600:
601:
687: ,x_msg_count OUT NOCOPY number
688: ,x_msg_data OUT NOCOPY varchar2
689: ) IS
690:
691: v_Common_Level_ReTrieved_Tbl BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type;
692: v_Dim_Level_Rec_R BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
693: v_Indicator number;
694: v_index number;
695:
688: ,x_msg_data OUT NOCOPY varchar2
689: ) IS
690:
691: v_Common_Level_ReTrieved_Tbl BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type;
692: v_Dim_Level_Rec_R BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
693: v_Indicator number;
694: v_index number;
695:
696: CURSOR c_KPIs IS