APPS.BIS_DIMENSION_PVT dependencies on BIS_DIMENSIONS_VL

Line 306: FROM bis_dimensions_vl

302: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
303: CURSOR cr_dim_id IS
304: SELECT dimension_id, short_name, name, description,
305: application_id, dim_grp_id, hide_in_design
306: FROM bis_dimensions_vl
307: WHERE dimension_id=p_Dimension_Rec.dimension_id;
308:
309: CURSOR cr_dim_short_name IS
310: SELECT dimension_id, short_name, name, description,

Line 312: FROM bis_dimensions_vl

308:
309: CURSOR cr_dim_short_name IS
310: SELECT dimension_id, short_name, name, description,
311: application_id, dim_grp_id, hide_in_design
312: FROM bis_dimensions_vl
313: WHERE short_name=p_Dimension_Rec.dimension_short_name;
314:
315: CURSOR cr_dim_name IS
316: SELECT dimension_id, short_name, name, description,

Line 318: FROM bis_dimensions_vl

314:
315: CURSOR cr_dim_name IS
316: SELECT dimension_id, short_name, name, description,
317: application_id, dim_grp_id, hide_in_design
318: FROM bis_dimensions_vl
319: WHERE name=p_Dimension_Rec.dimension_name;
320:
321: begin
322:

Line 1125: FROM bis_dimensions_vl

1121:
1122: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Short_Name)
1123: = FND_API.G_TRUE) THEN
1124: SELECT dimension_id INTO x_Dimension_ID
1125: FROM bis_dimensions_vl
1126: WHERE short_name = p_Dimension_Short_Name;
1127: elsIF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Name)
1128: = FND_API.G_TRUE) THEN
1129: SELECT dimension_id INTO x_Dimension_ID

Line 1130: FROM bis_dimensions_vl

1126: WHERE short_name = p_Dimension_Short_Name;
1127: elsIF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Name)
1128: = FND_API.G_TRUE) THEN
1129: SELECT dimension_id INTO x_Dimension_ID
1130: FROM bis_dimensions_vl
1131: WHERE name = p_Dimension_Name;
1132: else
1133: l_error_tbl := x_error_tbl;
1134: BIS_UTILITIES_PVT.Add_Error_Message

Line 1356: FROM bis_dimensions_vl BD, bsc_sys_dim_groups_vl BG

1352: FROM bsc_sys_dim_levels_by_group DLG, bsc_sys_dim_levels_b DLB
1353: WHERE DLB.source = 'PMF'
1354: AND DLG.dim_level_id = DLB.dim_level_id
1355: AND BG.dim_group_id = DLG.dim_group_id), 0, 'BSC', 'PMF') type
1356: FROM bis_dimensions_vl BD, bsc_sys_dim_groups_vl BG
1357: WHERE UPPER(BD.Name) = UPPER(p_Dimension_Name)
1358: AND BD.dim_grp_id = BG.dim_group_id
1359: AND BD.short_name <> p_Dimension_Short_Name;
1360:

Line 1365: FROM bis_dimensions_vl

1361: l_unique_name_rec c_unique_name%ROWTYPE;
1362: l_count NUMBER;
1363: BEGIN
1364: SELECT COUNT(1) INTO l_count
1365: FROM bis_dimensions_vl
1366: WHERE UPPER(name) = UPPER(p_Dimension_Name)
1367: AND short_name <> p_Dimension_Short_Name;
1368:
1369: IF (l_count <> 0) THEN

Line 1396: FROM bis_dimensions_vl

1392: WHILE (l_count > 0) LOOP
1393: l_new_disp_name := BSC_UTILITY.get_Next_DispName(l_new_disp_name);
1394:
1395: SELECT COUNT(1) INTO l_count
1396: FROM bis_dimensions_vl
1397: WHERE UPPER(name) = UPPER(l_new_disp_name);
1398:
1399: END LOOP;
1400: