DBA Data[Home] [Help]

APPS.BSC_COMMON_DIM_LEVELS_PUB dependencies on BSC_DIMENSION_LEVELS_PUB

Line 17: v_Common_Level_ReTrieved_Tbl BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type;

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;

Line 18: v_Common_Level_Found_Tbl BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_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;

Line 20: v_Dim_Level_Rec_R BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

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;

Line 21: v_Dim_Level_Rec_F BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

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;

Line 336: ,x_Dim_Level_Tbl OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type

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

Line 344: v_Dim_Level_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

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:

Line 589: ,x_Dim_Level_Tbl OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type

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

Line 597: v_Dim_Level_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

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:

Line 691: v_Common_Level_ReTrieved_Tbl BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type;

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:

Line 692: v_Dim_Level_Rec_R BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

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