DBA Data[Home] [Help]

APPS.BSC_PMF_UI_WRAPPER dependencies on BSC_PMF_UI_API_PUB

Line 75: g_Bsc_Pmf_Ui_Rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type;

71: C_DISABLE_FLAG CONSTANT NUMBER := 1;
72: C_HIDE_FLAG CONSTANT NUMBER := 0;
73:
74: -- Define global variables to be passed to PMF-BSC API.
75: g_Bsc_Pmf_Ui_Rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type;
76: g_Bsc_Pmf_Dim_Tbl BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type;
77: g_Fire varchar2(3);
78:
79:

Line 76: g_Bsc_Pmf_Dim_Tbl BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type;

72: C_HIDE_FLAG CONSTANT NUMBER := 0;
73:
74: -- Define global variables to be passed to PMF-BSC API.
75: g_Bsc_Pmf_Ui_Rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type;
76: g_Bsc_Pmf_Dim_Tbl BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type;
77: g_Fire varchar2(3);
78:
79:
80:

Line 161: BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Api( FND_API.G_FALSE

157:
158: g_Bsc_Pmf_Dim_Tbl(l_tbl_cnt + 1).Dimension_Level_Short_Name := p_dim_level_short_name;
159:
160: if g_Fire = 'YES' then
161: BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Api( FND_API.G_FALSE
162: ,g_Bsc_Pmf_Ui_Rec
163: ,g_Bsc_Pmf_Dim_Tbl
164: ,0
165: ,l_bad_level

Line 235: l_dim_levels_table BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type;

231: l_msg_data VARCHAR2(255);
232: l_dim_level VARCHAR2(100);
233: l_dim_levels VARCHAR2(32000);
234: l_dim_levels_count NUMBER;
235: l_dim_levels_table BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type;
236: l_analysis_option_rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type;
237: l_pos NUMBER;
238:
239: -- following set of variables add to support Default and View by Levels.

Line 236: l_analysis_option_rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type;

232: l_dim_level VARCHAR2(100);
233: l_dim_levels VARCHAR2(32000);
234: l_dim_levels_count NUMBER;
235: l_dim_levels_table BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Tbl_Type;
236: l_analysis_option_rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Rec_Type;
237: l_pos NUMBER;
238:
239: -- following set of variables add to support Default and View by Levels.
240: l_bis_dim_levels varchar2(5000);

Line 352: BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Api(

348:
349: end if;
350:
351: -- call the api to create analysis option
352: BSC_PMF_UI_API_PUB.Bsc_Pmf_Ui_Api(
353: FND_API.G_FALSE,
354: l_analysis_option_rec,
355: l_dim_levels_table,
356: 0,

Line 3826: v_Bsc_Pmf_Dim_Rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type;

3822: ,x_msg_count OUT NOCOPY number
3823: ,x_msg_data OUT NOCOPY varchar2
3824: ) IS
3825:
3826: v_Bsc_Pmf_Dim_Rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type;
3827: v_commit varchar(5) := FND_API.G_FALSE;
3828: v_temp number;
3829: v_level_view_name varchar(200);
3830: v_sql varchar(300);

Line 3852: BSC_PMF_UI_API_PUB.Import_PMF_Dim_Level( v_commit ,v_Bsc_Pmf_Dim_Rec ,x_return_status ,x_msg_count ,x_msg_data );

3848: OPEN cv FOR v_sql USING p_Short_Name;
3849: FETCH cv INTO v_level_view_name;
3850: --DBMS_OUTPUT.PUT_LINE(' Import_Dim_Level (wrapper) - v_level_view_name = ' || v_level_view_name );
3851:
3852: BSC_PMF_UI_API_PUB.Import_PMF_Dim_Level( v_commit ,v_Bsc_Pmf_Dim_Rec ,x_return_status ,x_msg_count ,x_msg_data );
3853: end if;
3854: --DBMS_OUTPUT.PUT_LINE('End Import_Dim_Level (wrapper) ' );
3855:
3856: EXCEPTION

Line 3913: v_Bsc_Pmf_Dim_Rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type;

3909:
3910: v_array_Dim_Levels t_of_Bsc_Dim_Level_Rec;
3911:
3912: v_Dim_Level_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
3913: v_Bsc_Pmf_Dim_Rec BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type;
3914: v_commit varchar(5) := FND_API.G_FALSE;
3915:
3916: v_Dim_Level_Id number;
3917:

Line 3947: BSC_PMF_UI_API_PUB.Import_PMF_Dim_Level(v_commit ,v_Bsc_Pmf_Dim_Rec

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 );
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);

Line 4003: BSC_PMF_UI_API_PUB.Import_PMF_Dim_Level(v_commit ,v_Bsc_Pmf_Dim_Rec

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
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

Line 4775: -- BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby( 1

4771:
4772:
4773: x_is_there_time := 'N';
4774:
4775: -- BSC_PMF_UI_API_PUB.Get_DimLevel_Viewby( 1
4776: BIS_PMV_BSC_API_PUB.Get_DimLevel_Viewby( 1
4777: ,l_region_code
4778: ,p_measure_short_name
4779: ,l_DimLevel_Viewby_Tbl