DBA Data[Home] [Help]

APPS.BSC_UPGRADES dependencies on BSC_SYS_DIM_GROUPS_TL

Line 1577: UPDATE BSC_SYS_DIM_GROUPS_TL

1573: BEGIN
1574: FND_MSG_PUB.Initialize;
1575: SAVEPOINT BscSyncDimensions;
1576:
1577: UPDATE BSC_SYS_DIM_GROUPS_TL
1578: SET SHORT_NAME = 'BSC_DIM_'||Dim_Group_Id
1579: WHERE short_name IS NULL;
1580:
1581: FOR cd IN c_bis_dims LOOP

Line 1589: FROM BSC_SYS_DIM_GROUPS_TL

1585:
1586: IF (l_count = 0) THEN
1587: IF (cd.Dimension_Id <> -1) THEN
1588: SELECT COUNT(1) INTO l_count
1589: FROM BSC_SYS_DIM_GROUPS_TL
1590: WHERE name = cd.Name
1591: AND language = userenv('LANG');
1592:
1593: IF (l_count = 0) THEN

Line 2022: FROM BSC_SYS_DIM_GROUPS_TL

2018: l_Dim_Grp_Rec.Dimension_Name,
2019: l_Dim_Grp_Rec.Language,
2020: l_Dim_Grp_Rec.Last_Update_Date,
2021: l_Dim_Grp_Rec.Source_Lang
2022: FROM BSC_SYS_DIM_GROUPS_TL
2023: WHERE SHORT_NAME = p_dim_short_name
2024: AND LANGUAGE = cd.language_code;
2025:
2026: BIS_DIMENSION_PUB.Translate_Dim_By_Given_Lang