APPS.BSC_KPI_PVT dependencies on BSC_KPIS_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 198: l_db_object := 'BSC_KPIS_TL';

194: ,l_Bsc_Kpi_Entity_Rec.Bsc_Prototype_Color_Id
195: ,l_Bsc_Kpi_Entity_Rec.Bsc_Prototype_Trend_Id
196: ,l_Bsc_Kpi_Entity_Rec.Bsc_Weighted_Color_Method);
197:
198: l_db_object := 'BSC_KPIS_TL';
199:
200: -- Fixed bug 2635468 ISSUE FIFTH
201: insert into BSC_KPIS_TL (
202: INDICATOR,

Line 201: insert into BSC_KPIS_TL (

197:
198: l_db_object := 'BSC_KPIS_TL';
199:
200: -- Fixed bug 2635468 ISSUE FIFTH
201: insert into BSC_KPIS_TL (
202: INDICATOR,
203: LANGUAGE,
204: SOURCE_LANG,
205: NAME,

Line 217: from BSC_KPIS_TL T

213: from FND_LANGUAGES L
214: where L.INSTALLED_FLAG in ('I', 'B')
215: and not exists
216: (select NULL
217: from BSC_KPIS_TL T
218: where T.INDICATOR = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
219: and T.LANGUAGE = L.LANGUAGE_CODE);
220:
221: if (p_commit = FND_API.G_TRUE) then

Line 360: ,BSC_KPIS_TL B

356: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Name
357: ,x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Help
358: ,x_Bsc_Kpi_Entity_Rec.Bsc_Source_Language
359: FROM BSC_KPIS_B A
360: ,BSC_KPIS_TL B
361: WHERE A.INDICATOR = B.INDICATOR
362: AND A.INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
363: AND B.LANGUAGE = USERENV('LANG');
364: -- Fixed Third issue in bug 2635468

Line 567: update BSC_KPIS_TL

563: ,prototype_trend_id = l_Bsc_Kpi_Entity_Rec.Bsc_Prototype_Trend_Id
564: ,weighted_color_method = l_Bsc_Kpi_Entity_Rec.Bsc_Weighted_Color_Method
565: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
566:
567: update BSC_KPIS_TL
568: set name = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Name
569: ,help = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Help
570: ,SOURCE_LANG = userenv('LANG')
571: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id

Line 676: DELETE FROM BSC_KPIS_TL

672: IF l_Delete_Kpi_b THEN
673: DELETE FROM BSC_KPIS_B
674: WHERE INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
675:
676: DELETE FROM BSC_KPIS_TL
677: WHERE INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
678: ELSE
679: UPDATE BSC_KPIS_B
680: SET PROTOTYPE_FLAG = BSC_KPI_PUB.DELETE_KPI_FLAG

Line 5742: from BSC_KPIS_TL

5738: begin
5739:
5740: select count(*)
5741: into l_count
5742: from BSC_KPIS_TL
5743: where upper(name) = upper(p_Kpi_Name);
5744:
5745: return l_count;
5746: