DBA Data[Home] [Help]

APPS.BIS_PORTLET_PMREGION dependencies on BIS_INDICATOR_REGION_PUB

Line 1592: l_selections_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;

1588: l_text VARCHAR2(32000);
1589: l_return_status VARCHAR2(32000);
1590: l_indicators_tbl BIS_TARGET_LEVEL_PUB.Target_Level_Tbl_Type;
1591: l_displaylabels_tbl Selected_Values_Tbl_Type;
1592: l_selections_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
1593: l_temp_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
1594: l_unique BOOLEAN;
1595: l_cnt pls_integer;
1596: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 1656: BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections

1652:
1653:
1654: -- Get all the previously selected Indicator levels from
1655: -- bis_user_ind_selections table.
1656: BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections
1657: ( p_api_version => 1.0
1658: , p_user_id => l_user_id
1659: , p_all_info => FND_API.G_TRUE
1660: , p_plug_id => l_plug_id

Line 2117: l_labels_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;

2113: l_return_status VARCHAR2(32000);
2114: l_loc PLS_INTEGER;
2115: l_value VARCHAR2(32000);
2116: l_text VARCHAR2(32000);
2117: l_labels_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
2118: l_orgs_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2119: l_dim1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2120: l_dim2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2121: l_dim3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 2253: BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections

2249:
2250: -- Get all the previously selected labels from
2251: -- selections box.
2252:
2253: BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections
2254: ( p_api_version => 1.0
2255: , p_user_id => l_user_id
2256: , p_all_info => FND_API.G_TRUE
2257: , p_plug_id => l_plug_id

Line 3923: l_indicator_region_values BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;

3919: l_length pls_integer;
3920: l_display_label varchar2(32000);
3921: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3922: l_return_status varchar2(32000);
3923: l_indicator_region_values BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;
3924: l_plan_idnum pls_integer;
3925:
3926: begin
3927:

Line 3937: BIS_INDICATOR_REGION_PUB.Delete_User_Ind_Selections(

3933: l_session_id := icx_sec.g_session_id;
3934: l_user_id := icx_sec.getID(icx_sec.PV_USER_ID,'', l_session_id);
3935:
3936: -- Deleting the old rows of this userid and plugid from the selections table
3937: BIS_INDICATOR_REGION_PUB.Delete_User_Ind_Selections(
3938: p_api_version => 1.0,
3939: p_user_id => l_user_id,
3940: p_plug_id => l_plug_id,
3941: x_return_status => l_return_status,

Line 4010: BIS_INDICATOR_REGION_PUB.Create_User_Ind_Selection(

4006: l_indicator_region_values.DIM7_LEVEL_VALUE_ID := l_d7;
4007:
4008: l_indicator_region_values.PLAN_ID := l_plan;
4009:
4010: BIS_INDICATOR_REGION_PUB.Create_User_Ind_Selection(
4011: p_api_version => 1.0,
4012: p_Indicator_Region_Rec => l_indicator_region_values,
4013: x_return_status => l_return_status,
4014: x_error_Tbl => l_error_tbl);

Line 4116: l_favorites_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;

4112: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4113: l_dim6_level_value_rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
4114: l_dim7_level_value_rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
4115:
4116: l_favorites_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
4117: l_orgs_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4118: l_dim1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4119: l_dim2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4120: l_dim3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 4291: BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections

4287: -- htp.p('
*****************************************************
');
4288:
4289: -- Get all the previously selected labels from
4290: -- selections table.
4291: BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections
4292: ( p_api_version => 1.0
4293: , p_user_id => l_user_id
4294: , p_all_info => FND_API.G_TRUE
4295: , p_plug_id => l_plug_id

Line 6006: l_ind_rec BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;

6002: IS
6003:
6004: l_plan_id NUMBER;
6005: l_tar_level_id NUMBER;
6006: l_ind_rec BIS_INDICATOR_REGION_PUB.Indicator_Region_Rec_Type;
6007:
6008: BEGIN
6009: --dbms_output.put_line('p_parameters='|| p_parameters);
6010: --Transfer the values to the fields in the record

Line 6052: BIS_INDICATOR_REGION_PUB.Create_User_Ind_Selection(

6048: l_ind_rec.DIM7_LEVEL_VALUE_ID :=BIS_PMF_PORTLET_UTIL.get_pl_value(c_key_dv_id7,p_parameters);
6049:
6050:
6051: -- save to database
6052: BIS_INDICATOR_REGION_PUB.Create_User_Ind_Selection(
6053: p_api_version => 1.0
6054: ,p_Indicator_Region_Rec => l_ind_rec
6055: ,x_return_status => x_return_status
6056: ,x_error_Tbl => x_error_tbl