APPS.BSC_DIMENSION_GROUPS_PUB dependencies on BSC_SYS_DIM_GROUPS_TL

Line 130: l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( 'BSC_SYS_DIM_GROUPS_TL'

126:
127: -- Get the next ID value for the current group.
128:
129: IF l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id IS NULL THEN
130: l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( 'BSC_SYS_DIM_GROUPS_TL'
131: ,'DIM_GROUP_ID');
132: END IF;
133:
134:

Line 1113: -- dimension short name is not populated as of now in bsc_sys_dim_groups_tl

1109: FROM bsc_sys_dim_levels_b
1110: WHERE short_name = p_dim_level_shortname;
1111:
1112: -- Passing dim_group_id is mandatory for calling the below procedure. As,
1113: -- dimension short name is not populated as of now in bsc_sys_dim_groups_tl
1114: -- dim_group_id will be retrieved from the bsc_sys_dim_levels_by_group table.
1115: -- This shouldn't create any problem as dim_level_id is unique in
1116: -- bsc_sys_dim_levels_by_group table for levels imported from PMF to BSC.
1117:

Line 1233: -- since name is used as a unique column in bsc_sys_dim_groups_tl. The name itself will not matter

1229: BEGIN
1230:
1231: l_Dim_Grp_Rec := p_Dim_Grp_Rec;
1232: -- If the dimension group name in bsc is the same as that in pmf seeded dimensions, then use another name
1233: -- since name is used as a unique column in bsc_sys_dim_groups_tl. The name itself will not matter
1234: -- for PMF since short_name is used at all places. (bug# 3028436)
1235:
1236: get_unique_dim_group_name(
1237: p_dim_group_name => p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name

Line 1294: l_dim_group_name bsc_sys_dim_groups_tl.name%TYPE;

1290: )
1291: IS
1292: l_count NUMBER;
1293: l_counter NUMBER;
1294: l_dim_group_name bsc_sys_dim_groups_tl.name%TYPE;
1295: BEGIN
1296: l_dim_group_name := p_dim_group_name;
1297: l_counter := p_counter + 1;
1298:

Line 1368: -- since name is used as a unique column in bsc_sys_dim_groups_tl. The name itself will not matter

1364: l_is_insert := 'N';
1365: END IF;
1366:
1367: -- If the dimension group name in bsc is the same as that in pmf seeded dimensions, then use another name
1368: -- since name is used as a unique column in bsc_sys_dim_groups_tl. The name itself will not matter
1369: -- for PMF since short_name is used at all places. (bug# 3028436)
1370:
1371: get_unique_dim_group_name(
1372: p_dim_group_name => p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name