eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_DIMENSION_SETS_PVT dependencies on BSC_KPI_DIM_LEVELS_TL

Line 27: | BSC_KPI_DIM_LEVELS_TL, and Insert Query for |

23: | 18-DEC-2002 ASHANKAR Bug Fix #2716498 |
24: | |
25: | 04-MAR-2003 PAJOHRI MLS Bug #2721899 |
26: | 1. Modified Update Query for BSC_KPI_DIM_SETS_TL, |
27: | BSC_KPI_DIM_LEVELS_TL, and Insert Query for |
28: | BSC_KPI_DIM_LEVELS_TL. |
29: | 2. Changed nvl(l_Dim_Set_Rec.Bsc_Language, userenv('LANG')) |
30: | to userenv('LANG') |
31: | 18-MAR-2003 PAJOHRI Added Condition to update l_Dim_Set_Rec.Bsc_Dim_Set_Name, only |

Line 28: | BSC_KPI_DIM_LEVELS_TL. |

24: | |
25: | 04-MAR-2003 PAJOHRI MLS Bug #2721899 |
26: | 1. Modified Update Query for BSC_KPI_DIM_SETS_TL, |
27: | BSC_KPI_DIM_LEVELS_TL, and Insert Query for |
28: | BSC_KPI_DIM_LEVELS_TL. |
29: | 2. Changed nvl(l_Dim_Set_Rec.Bsc_Language, userenv('LANG')) |
30: | to userenv('LANG') |
31: | 18-MAR-2003 PAJOHRI Added Condition to update l_Dim_Set_Rec.Bsc_Dim_Set_Name, only |
32: | when it is Not Null |

Line 38: | BSC_KPI_DIM_LEVELS_TL to allow NULL value if NULL values are |

34: | 05-SEP-2003 Adeulgao Fixed bug#3128103 |
35: | 07-JAN-2004 PAJOHRI Bug #3343860, modified procedure Create_Dim_Levels for when |
36: | there is no dimension group associated with dimension set |
37: | 25-FEB-2004 PAJOHRI Bug #3446359, modified insertion logic for |
38: | BSC_KPI_DIM_LEVELS_TL to allow NULL value if NULL values are |
39: | passed from the Public APIs |
40: | 21-JUL-2005 ashankar Bug#4314386 |
41: +======================================================================================+
42: */

Line 1465: -- Insert pertaining values into table bsc_kpi_dim_levels_tl.

1461: ,p_Dim_Set_Rec.Bsc_Dset_User_Level1_Default
1462: ,p_Dim_Set_Rec.Bsc_Dset_User_Level2
1463: ,p_Dim_Set_Rec.Bsc_Dset_User_Level2_Default
1464: ,p_Dim_Set_Rec.Bsc_Dset_Target_Level);
1465: -- Insert pertaining values into table bsc_kpi_dim_levels_tl.
1466: IF (p_Dim_Set_Rec.Bsc_Level_Id IS NULL) THEN
1467: INSERT INTO BSC_KPI_DIM_LEVELS_TL
1468: ( Indicator
1469: , Dim_Set_Id

Line 1467: INSERT INTO BSC_KPI_DIM_LEVELS_TL

1463: ,p_Dim_Set_Rec.Bsc_Dset_User_Level2_Default
1464: ,p_Dim_Set_Rec.Bsc_Dset_Target_Level);
1465: -- Insert pertaining values into table bsc_kpi_dim_levels_tl.
1466: IF (p_Dim_Set_Rec.Bsc_Level_Id IS NULL) THEN
1467: INSERT INTO BSC_KPI_DIM_LEVELS_TL
1468: ( Indicator
1469: , Dim_Set_Id
1470: , Dim_Level_Index
1471: , Language

Line 1491: FROM BSC_KPI_DIM_LEVELS_TL T

1487: FROM FND_LANGUAGES L
1488: WHERE L.INSTALLED_FLAG IN ('I', 'B')
1489: AND NOT EXISTS
1490: ( SELECT NULL
1491: FROM BSC_KPI_DIM_LEVELS_TL T
1492: WHERE T.indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1493: AND dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1494: AND dim_level_index = p_Dim_Set_Rec.Bsc_Dset_Dim_Level_Index - 1
1495: AND T.LANGUAGE = L.LANGUAGE_CODE

Line 1505: INSERT INTO BSC_KPI_DIM_LEVELS_TL

1501: l_Dim_Set_Rec.Bsc_Dim_Tot_Disp_Name := cd.Total_Disp_Name;
1502: l_Dim_Set_Rec.Bsc_Dim_Comp_Disp_Name := cd.Comp_Disp_Name;
1503: l_Dim_Set_Rec.Bsc_Language := cd.Language;
1504: l_Dim_Set_Rec.Bsc_Source_Language := cd.Source_Lang;
1505: INSERT INTO BSC_KPI_DIM_LEVELS_TL
1506: ( indicator
1507: , dim_set_id
1508: , dim_level_index
1509: , language

Line 1667: , BSC_KPI_DIM_LEVELS_TL b

1663: , x_Dim_Set_Rec.Bsc_Dim_Level_Help
1664: , x_Dim_Set_Rec.Bsc_Dim_Tot_Disp_Name
1665: , x_Dim_Set_Rec.Bsc_Dim_Comp_Disp_Name
1666: from BSC_KPI_DIM_LEVELS_B a
1667: , BSC_KPI_DIM_LEVELS_TL b
1668: where a.indicator = b.indicator
1669: and a.dim_set_id = b.dim_set_id
1670: and a.dim_level_index = b.dim_level_index
1671: and a.indicator = p_Dim_Set_Rec.Bsc_Kpi_Id

Line 1934: update BSC_KPI_DIM_LEVELS_TL

1930: where indicator = l_Dim_Set_Rec.Bsc_Kpi_Id
1931: and dim_set_id = l_Dim_Set_Rec.Bsc_Dim_Set_Id
1932: and level_table_name = l_Dim_Set_Rec.Bsc_Level_Name;
1933:
1934: update BSC_KPI_DIM_LEVELS_TL
1935: set name = l_Dim_Set_Rec.Bsc_Dim_Level_Long_Name
1936: , help = l_Dim_Set_Rec.Bsc_Dim_Level_Help
1937: , total_disp_name = l_Dim_Set_Rec.Bsc_Dim_Tot_Disp_Name
1938: , comp_disp_name = l_Dim_Set_Rec.Bsc_Dim_Comp_Disp_Name

Line 2047: FROM bsc_kpi_dim_levels_tl

2043: AND dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
2044: AND dim_level_index = l_dim_index;
2045:
2046: DELETE
2047: FROM bsc_kpi_dim_levels_tl
2048: WHERE indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
2049: AND dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
2050: AND dim_level_index = l_dim_index;
2051: