APPS.BSC_UPGRADES dependencies on BIS_DIMENSIONS

Line 1548: FROM BIS_DIMENSIONS_VL

1544: , Last_Update_Login
1545: , Name
1546: , Description
1547: , Application_Id
1548: FROM BIS_DIMENSIONS_VL
1549: WHERE DIM_GRP_ID IS NULL;
1550:
1551: CURSOR c_bsc_dims IS
1552: SELECT Dim_Group_Id

Line 1680: FROM BIS_DIMENSIONS

1676: END LOOP;
1677:
1678: FOR cd IN c_bsc_dims LOOP
1679: SELECT COUNT(1) INTO l_count
1680: FROM BIS_DIMENSIONS
1681: WHERE short_name = cd.Short_Name;
1682:
1683: IF (l_count = 0) THEN
1684: SELECT COUNT(1) INTO l_count

Line 1685: FROM BIS_DIMENSIONS_TL

1681: WHERE short_name = cd.Short_Name;
1682:
1683: IF (l_count = 0) THEN
1684: SELECT COUNT(1) INTO l_count
1685: FROM BIS_DIMENSIONS_TL
1686: WHERE Name = cd.Name
1687: AND language = userenv('LANG');
1688:
1689: IF (l_count = 0) THEN

Line 1729: UPDATE BIS_DIMENSIONS

1725: );
1726:
1727: END IF;
1728:
1729: UPDATE BIS_DIMENSIONS
1730: SET Dim_Grp_ID = cd.Dim_Group_Id
1731: WHERE Short_Name = cd.short_name;
1732:
1733: END LOOP;

Line 2098: FROM BIS_DIMENSIONS

2094: BEGIN
2095:
2096: SELECT DIMENSION_ID
2097: INTO l_dim_id
2098: FROM BIS_DIMENSIONS
2099: WHERE SHORT_NAME = p_dim_short_name;
2100:
2101: l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Short_Name := p_dim_short_name;
2102:

Line 2109: FROM BIS_DIMENSIONS_TL

2105: INTO l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name,
2106: l_Dim_Grp_Rec.Bsc_Language,
2107: l_Dim_Grp_Rec.Bsc_Last_Update_Date,
2108: l_Dim_Grp_Rec.Bsc_Source_Language
2109: FROM BIS_DIMENSIONS_TL
2110: WHERE DIMENSION_ID = l_dim_id
2111: AND LANGUAGE = cd.language_code;
2112:
2113: BSC_DIMENSION_GROUPS_PUB.Translate_Dim_By_Given_Lang

Line 2744: bis_dimensions bis_dim

2740: SELECT bsc_lvl.short_name, bis_dim.dimension_id
2741: FROM bsc_sys_dim_groups_vl bsc_dim,
2742: bsc_sys_dim_levels_b bsc_lvl,
2743: bsc_sys_dim_levels_by_group lvl_by_grp,
2744: bis_dimensions bis_dim
2745: WHERE bsc_dim.dim_group_id = lvl_by_grp.dim_group_id
2746: AND bsc_lvl.dim_level_id = lvl_by_grp.dim_level_id
2747: /* AND bsc_dim.dim_group_id = bis_dim.dim_grp_id cannot use since dim_group_id is not updated on BIS side yet */
2748: AND bsc_dim.short_name = bis_dim.short_name /* can assume here since short name are same on both side */

Line 2785: TYPE t_short_names IS TABLE OF BIS_DIMENSIONS.SHORT_NAME%TYPE INDEX BY BINARY_INTEGER;

2781: FUNCTION Update_Dim_Hide_Properties (
2782: x_error_msg OUT NOCOPY VARCHAR2
2783: ) RETURN BOOLEAN
2784: IS
2785: TYPE t_short_names IS TABLE OF BIS_DIMENSIONS.SHORT_NAME%TYPE INDEX BY BINARY_INTEGER;
2786: l_dim_short_names t_short_names;
2787: l_row_count NUMBER := 0;
2788:
2789: CURSOR cr_internal_dimensions IS

Line 2793: bis_dimensions

2789: CURSOR cr_internal_dimensions IS
2790: SELECT
2791: short_name
2792: FROM
2793: bis_dimensions
2794: WHERE
2795: (bsc_utility.Is_Internal_AG_Dim(short_name) IS NOT NULL OR
2796: bsc_utility.Is_Internal_BIS_Import_Dim(short_name) IS NOT NULL OR
2797: bsc_utility.Is_Internal_WKPI_Dim(short_name) IS NOT NULL)

Line 2812: UPDATE BIS_DIMENSIONS

2808: EXIT WHEN l_row_count = cr_internal_dimensions%ROWCOUNT;
2809: l_row_count := cr_internal_dimensions%ROWCOUNT;
2810:
2811: FORALL i in 1..l_dim_short_names.COUNT
2812: UPDATE BIS_DIMENSIONS
2813: SET HIDE_IN_DESIGN = FND_API.G_TRUE
2814: WHERE SHORT_NAME = l_dim_short_names(i);
2815: END LOOP;
2816:

Line 2870: UPDATE BIS_DIMENSIONS

2866: EXIT WHEN l_row_count = cr_pmf_import_dims%ROWCOUNT;
2867: l_row_count := cr_pmf_import_dims%ROWCOUNT;
2868:
2869: FOR i in 1..l_dim_short_names.COUNT LOOP
2870: UPDATE BIS_DIMENSIONS
2871: SET HIDE_IN_DESIGN = FND_API.G_TRUE
2872: WHERE SHORT_NAME = l_dim_short_names(i);
2873: END LOOP;
2874: END LOOP;