APPS.BSC_DIMENSION_GROUPS_PUB dependencies on BSC_SYS_DIM_GROUPS_VL

Line 160: from BSC_SYS_DIM_GROUPS_VL

156: IF (p_create_Dim_Levels) THEN
157: -- Get the group id for the current group name.
158: select dim_group_id
159: into l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id
160: from BSC_SYS_DIM_GROUPS_VL
161: where upper(name) = upper(p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name);
162:
163: -- Call private version of this procedure.
164: Create_Dim_Levels_In_Group( p_commit

Line 904: FROM bsc_sys_dim_groups_vl

900: l_dim_grp_rec_out BSC_DIMENSION_GROUPS_PUB.BSC_DIM_GROUP_REC_TYPE;
901:
902: CURSOR c_dim_group (cp_dim_shortname VARCHAR2) IS
903: SELECT dim_group_id
904: FROM bsc_sys_dim_groups_vl
905: WHERE short_name = cp_dim_shortname;
906:
907: CURSOR c_dim_level (cp_dim_level_shortname VARCHAR2) IS
908: SELECT dim_level_id, total_disp_name, comp_disp_name

Line 1120: FROM bsc_sys_dim_groups_vl

1116: -- bsc_sys_dim_levels_by_group table for levels imported from PMF to BSC.
1117:
1118: SELECT dim_group_id
1119: INTO l_dim_group_id
1120: FROM bsc_sys_dim_groups_vl
1121: WHERE short_name = p_dim_shortname;
1122:
1123: l_dim_grp_rec.bsc_level_id := l_dim_level_id;
1124: l_dim_grp_rec.bsc_dim_level_group_id := l_dim_group_id;

Line 1302: FROM bsc_sys_dim_groups_vl

1298:
1299: IF (p_is_insert = 'Y') THEN
1300: SELECT count(dim_group_id)
1301: INTO l_count
1302: FROM bsc_sys_dim_groups_vl
1303: WHERE
1304: UPPER(name) = UPPER(p_dim_group_name);
1305: ELSE -- for update
1306: SELECT count(dim_group_id)

Line 1308: FROM bsc_sys_dim_groups_vl

1304: UPPER(name) = UPPER(p_dim_group_name);
1305: ELSE -- for update
1306: SELECT count(dim_group_id)
1307: INTO l_count
1308: FROM bsc_sys_dim_groups_vl
1309: WHERE
1310: UPPER(name) = UPPER(p_dim_group_name)
1311: AND
1312: UPPER(short_name) <> UPPER(p_dim_group_short_name);

Line 1359: FROM bsc_sys_dim_groups_vl

1355: l_Bsc_Dim_Group_Rec.Bsc_Last_Updated_By := p_Dim_Grp_Rec.Bsc_Last_Updated_By;
1356:
1357: SELECT count(dim_group_id)
1358: INTO l_count
1359: FROM bsc_sys_dim_groups_vl
1360: WHERE
1361: short_name = l_Bsc_Dim_Group_Rec.Bsc_Dim_Level_Group_Short_Name;
1362:
1363: IF (l_count > 0) THEN -- update

Line 1389: ,p_table_name => 'BSC_SYS_DIM_GROUPS_VL'

1385:
1386: BIS_UTIL.Validate_For_Update (p_last_update_date => l_Bsc_Dim_Group_Rec.Bsc_Last_Update_Date
1387: ,p_owner => l_owner_name
1388: ,p_force_mode => p_force_mode
1389: ,p_table_name => 'BSC_SYS_DIM_GROUPS_VL'
1390: ,p_key_value => l_Bsc_Dim_Group_Rec.Bsc_Dim_Level_Group_Short_Name
1391: ,x_ret_code => l_ret_code
1392: ,x_return_status => x_return_status
1393: ,x_msg_data => x_msg_data

Line 1480: , bsc_sys_dim_groups_vl b

1476: SELECT count(a.dim_level_id)
1477: INTO l_rel_count
1478: FROM
1479: bsc_sys_dim_levels_b a
1480: , bsc_sys_dim_groups_vl b
1481: , bsc_sys_dim_levels_by_group c
1482: WHERE
1483: a.short_name = p_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name
1484: and b.short_name = l_Bsc_Dim_Group_Rec.Bsc_Dim_Level_Group_Short_Name

Line 1552: FROM bsc_sys_dim_groups_vl

1548: ) IS
1549:
1550: CURSOR c_dim_grp_id (cp_short_name VARCHAR2) IS
1551: SELECT dim_group_id
1552: FROM bsc_sys_dim_groups_vl
1553: WHERE short_name = cp_short_name;
1554:
1555: BEGIN
1556: