DBA Data[Home] [Help]

APPS.BSC_PMF_UI_WRAPPER dependencies on BSC_DIMENSION_LEVELS_PVT

Line 3843: v_temp := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name);

3839:
3840: v_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name := p_Short_Name;
3841:
3842: -- Get the BSC Dimension Level Id of the Imported PMF Level
3843: v_temp := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name);
3844:
3845: if v_temp is null then /* If the Dimension Level has not been Imported */
3846:
3847: v_sql := 'select LEVEL_VIEW_NAME from bsc_bis_dim_levels_v where SHORT_NAME = :1';

Line 3944: v_Dim_Level_Rec.Bsc_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Level_Short_Name);

3940: v_Dim_Level_Rec.Bsc_Level_Short_Name := p_Short_Name;
3941: v_Dim_Level_Rec.Bsc_Source := 'PMF';
3942:
3943: if v_Dim_Level_Rec.Bsc_Source <> 'BSC' then
3944: v_Dim_Level_Rec.Bsc_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Level_Short_Name);
3945: if v_Dim_Level_Rec.Bsc_Level_Id is null then
3946: v_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name := v_Dim_Level_Rec.Bsc_Level_Short_Name;
3947: BSC_PMF_UI_API_PUB.Import_PMF_Dim_Level(v_commit ,v_Bsc_Pmf_Dim_Rec
3948: ,x_return_status ,x_msg_count ,x_msg_data );

Line 3949: v_Dim_Level_Rec.Bsc_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Level_Short_Name);

3945: if v_Dim_Level_Rec.Bsc_Level_Id is null then
3946: v_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name := v_Dim_Level_Rec.Bsc_Level_Short_Name;
3947: BSC_PMF_UI_API_PUB.Import_PMF_Dim_Level(v_commit ,v_Bsc_Pmf_Dim_Rec
3948: ,x_return_status ,x_msg_count ,x_msg_data );
3949: v_Dim_Level_Rec.Bsc_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Level_Short_Name);
3950: BSC_MULTI_USER_PVT.Apply_Multi_User_Env('DIM_LEVEL', v_Dim_Level_Rec.Bsc_Level_Id
3951: , null, null, null, 'LCK', null, x_return_status, x_msg_count ,x_msg_data);
3952: end if;
3953: end if;

Line 3999: v_Dim_Level_Rec.Bsc_Parent_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Parent_Level_Short_Name);

3995:
3996: -- Evaluate if it need import the child dimension Level--
3997: if v_Dim_Level_Rec.Bsc_Parent_Level_Source <> 'BSC' then
3998:
3999: v_Dim_Level_Rec.Bsc_Parent_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Parent_Level_Short_Name);
4000: if v_Dim_Level_Rec.Bsc_Parent_Level_Id is null then
4001: v_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name := v_Dim_Level_Rec.Bsc_Parent_Level_Short_Name;
4002:
4003: BSC_PMF_UI_API_PUB.Import_PMF_Dim_Level(v_commit ,v_Bsc_Pmf_Dim_Rec

Line 4006: v_Dim_Level_Rec.Bsc_Parent_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Parent_Level_Short_Name);

4002:
4003: BSC_PMF_UI_API_PUB.Import_PMF_Dim_Level(v_commit ,v_Bsc_Pmf_Dim_Rec
4004: ,x_return_status ,x_msg_count ,x_msg_data );
4005:
4006: v_Dim_Level_Rec.Bsc_Parent_Level_Id := BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(v_Dim_Level_Rec.Bsc_Parent_Level_Short_Name);
4007: BSC_MULTI_USER_PVT.Apply_Multi_User_Env('DIM_LEVEL', v_Dim_Level_Rec.Bsc_Level_Id, null, null, null
4008: , 'LCK', null, x_return_status, x_msg_count ,x_msg_data);
4009:
4010: end if;