DBA Data[Home] [Help]

APPS.BSC_KPI_PVT dependencies on BSC_KPI_DEFAULTS_B

Line 3876: l_db_object := 'BSC_KPI_DEFAULTS_B';

3872: if l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Anal_Opt0_Name is null then
3873: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Anal_Opt0_Name := 'Option ' || to_char(l_Bsc_Kpi_Entity_Rec.Bsc_Num_Options - 1);
3874: end if;
3875:
3876: l_db_object := 'BSC_KPI_DEFAULTS_B';
3877:
3878: insert into BSC_KPI_DEFAULTS_B( tab_id
3879: ,indicator
3880: ,format_mask

Line 3878: insert into BSC_KPI_DEFAULTS_B( tab_id

3874: end if;
3875:
3876: l_db_object := 'BSC_KPI_DEFAULTS_B';
3877:
3878: insert into BSC_KPI_DEFAULTS_B( tab_id
3879: ,indicator
3880: ,format_mask
3881: ,color_method
3882: ,dim_set_id

Line 4128: from BSC_KPI_DEFAULTS_B a

4124: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Dim_Level5_Text
4125: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Dim_Level6_Text
4126: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Dim_Level7_Text
4127: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Dim_Level8_Text
4128: from BSC_KPI_DEFAULTS_B a
4129: ,BSC_KPI_DEFAULTS_TL b
4130: where a.indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
4131: and a.indicator = b.indicator
4132: and b.language = USERENV('LANG');

Line 4346: update BSC_KPI_DEFAULTS_B

4342: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Dim_Level8_Text is not null then
4343: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Dim_Level8_Text := p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Dim_Level8_Text;
4344: end if;
4345:
4346: update BSC_KPI_DEFAULTS_B
4347: set tab_id = l_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id
4348: ,format_mask = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Format_Mask
4349: ,color_method = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Color_Method
4350: ,dim_set_id = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Dim_Set_Id

Line 4476: delete from BSC_KPI_DEFAULTS_B

4472: FND_MSG_PUB.ADD;
4473: RAISE FND_API.G_EXC_ERROR;
4474: end if;
4475:
4476: delete from BSC_KPI_DEFAULTS_B
4477: where indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
4478:
4479: delete from BSC_KPI_DEFAULTS_TL
4480: where indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;

Line 4877: update BSC_KPI_DEFAULTS_B

4873:
4874: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Update_Kpi_In_Tab - Flag 2');
4875:
4876: -- Update Kpi defaults.
4877: update BSC_KPI_DEFAULTS_B
4878: set tab_id = p_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id
4879: where indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
4880:
4881: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Update_Kpi_In_Tab - Flag 3');