APPS.BSC_KPI_PVT dependencies on BSC_KPI_DEFAULTS_TL

Line 25: | 1. Modified Update Query for BSC_KPIS_TL, BSC_KPI_DEFAULTS_TL|

21: | |
22: | History: |
23: | |
24: | 04-MAR-2003 PAJOHRI MLS Bug #2721899 |
25: | 1. Modified Update Query for BSC_KPIS_TL, BSC_KPI_DEFAULTS_TL|
26: | 2. Modified Insert Query for BSC_KPI_DEFAULTS_TL. |
27: | 3. Changed nvl(.Bsc_Language, userenv('LANG')) |
28: | to userenv('LANG') |
29: | 20-MAR-03 PWALI for bug #2843082 |

Line 26: | 2. Modified Insert Query for BSC_KPI_DEFAULTS_TL. |

22: | History: |
23: | |
24: | 04-MAR-2003 PAJOHRI MLS Bug #2721899 |
25: | 1. Modified Update Query for BSC_KPIS_TL, BSC_KPI_DEFAULTS_TL|
26: | 2. Modified Insert Query for BSC_KPI_DEFAULTS_TL. |
27: | 3. Changed nvl(.Bsc_Language, userenv('LANG')) |
28: | to userenv('LANG') |
29: | 20-MAR-03 PWALI for bug #2843082 |
30: | 13-MAY-2003 PWALI Bug #2942895, SQL BIND COMPLIANCE |

Line 3917: l_db_object := 'BSC_KPI_DEFAULTS_TL';

3913: ,l_Bsc_Kpi_Entity_Rec.Created_By
3914: ,l_Bsc_Kpi_Entity_Rec.Last_Update_Login
3915: ,l_Bsc_Kpi_Entity_Rec.Bsc_Measure_Source);
3916:
3917: l_db_object := 'BSC_KPI_DEFAULTS_TL';
3918:
3919: insert into BSC_KPI_DEFAULTS_TL( tab_id
3920: ,indicator
3921: ,language

Line 3919: insert into BSC_KPI_DEFAULTS_TL( tab_id

3915: ,l_Bsc_Kpi_Entity_Rec.Bsc_Measure_Source);
3916:
3917: l_db_object := 'BSC_KPI_DEFAULTS_TL';
3918:
3919: insert into BSC_KPI_DEFAULTS_TL( tab_id
3920: ,indicator
3921: ,language
3922: ,source_lang
3923: ,analysis_option0_name

Line 3973: FROM BSC_KPI_DEFAULTS_TL T

3969: FROM FND_LANGUAGES L
3970: WHERE L.INSTALLED_FLAG IN ('I', 'B')
3971: AND NOT EXISTS
3972: ( SELECT NULL
3973: FROM BSC_KPI_DEFAULTS_TL T
3974: WHERE T.indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
3975: AND T.LANGUAGE = L.LANGUAGE_CODE);
3976:
3977:

Line 4129: ,BSC_KPI_DEFAULTS_TL b

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');
4133:

Line 4367: update BSC_KPI_DEFAULTS_TL

4363: ,last_update_login = l_Bsc_Kpi_Entity_Rec.Last_Update_Login
4364: ,measure_source = l_Bsc_Kpi_Entity_Rec.Bsc_Measure_Source
4365: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
4366:
4367: update BSC_KPI_DEFAULTS_TL
4368: set analysis_option0_name = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Anal_Opt0_Name
4369: ,analysis_option1_name = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Anal_Opt1_Name
4370: ,analysis_option2_name = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Anal_Opt2_Name
4371: ,period_name = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Period_Name

Line 4479: delete from BSC_KPI_DEFAULTS_TL

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;
4481:
4482: if (p_commit = FND_API.G_TRUE) then
4483: commit;

Line 4883: update BSC_KPI_DEFAULTS_TL

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');
4882:
4883: update BSC_KPI_DEFAULTS_TL
4884: set tab_id = p_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id
4885: where indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
4886:
4887: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Update_Kpi_In_Tab - Flag 4');