APPS.BSC_BIS_DIMENSION_PUB dependencies on BIS_DIMENSIONS_VL

Line 940: FROM BIS_DIMENSIONS_VL

936: FROM BSC_SYS_DIM_GROUPS_VL
937: WHERE UPPER(Short_Name) = UPPER(l_temp_var)
938: UNION
939: SELECT COUNT(1) rec_count
940: FROM BIS_DIMENSIONS_VL
941: WHERE UPPER(Short_Name) = UPPER(l_temp_var))
942: WHERE rec_count > 0;
943: IF (l_count = 0) THEN
944: l_flag := FALSE;

Line 996: FROM BIS_DIMENSIONS_VL

992: RAISE FND_API.G_EXC_ERROR;
993: END IF;
994:
995: SELECT COUNT(1) INTO l_count
996: FROM BIS_DIMENSIONS_VL
997: WHERE UPPER(short_name) = UPPER(l_dim_short_name);
998: IF (l_count <> 0) THEN
999: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1000: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'));

Line 1030: FROM BIS_DIMENSIONS_VL

1026: -- Enh#4172034: Validations
1027: IF ((l_dim_type IS NULL) OR (l_dim_type = 'BSC')) THEN
1028:
1029: SELECT COUNT(1) INTO l_count
1030: FROM BIS_DIMENSIONS_VL
1031: WHERE UPPER(name) = UPPER(p_display_name);
1032:
1033: WHILE(l_count > 0) LOOP
1034: l_pmf_disp_name := bsc_utility.get_Next_DispName(l_pmf_disp_name);

Line 1037: FROM BIS_DIMENSIONS_VL

1033: WHILE(l_count > 0) LOOP
1034: l_pmf_disp_name := bsc_utility.get_Next_DispName(l_pmf_disp_name);
1035:
1036: SELECT COUNT(1) INTO l_count
1037: FROM BIS_DIMENSIONS_VL
1038: WHERE UPPER(name) = UPPER(l_pmf_disp_name);
1039:
1040: END LOOP;
1041:

Line 1056: FROM BIS_DIMENSIONS_VL

1052: RAISE FND_API.G_EXC_ERROR;
1053: END IF;
1054:
1055: SELECT COUNT(1) INTO l_count
1056: FROM BIS_DIMENSIONS_VL
1057: WHERE UPPER(name) = UPPER(p_display_name);
1058: IF (l_count <> 0) THEN
1059: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1060: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));

Line 2568: FROM BIS_DIMENSIONS_VL

2564: WHERE short_name = l_dim_short_name;
2565:
2566: CURSOR cr_bis_dim_id IS
2567: SELECT name, description, dimension_id
2568: FROM BIS_DIMENSIONS_VL
2569: WHERE short_name = l_dim_short_name;
2570: BEGIN
2571: SAVEPOINT UpdateBSCDimensionPMD;
2572:

Line 2630: FROM BIS_DIMENSIONS_VL

2626: IF (p_display_name IS NOT NULL) THEN
2627: IF (p_display_name <> l_bis_dimension_rec.Dimension_Name) THEN
2628: l_pmf_disp_name := p_display_name;
2629: SELECT COUNT(1) INTO l_count
2630: FROM BIS_DIMENSIONS_VL
2631: WHERE UPPER(short_name) <> UPPER(l_dim_short_name)
2632: AND UPPER(name) = UPPER(p_display_name);
2633: WHILE(l_count > 0) LOOP
2634: l_pmf_disp_name := bsc_utility.get_Next_DispName(l_pmf_disp_name);

Line 2636: FROM BIS_DIMENSIONS_VL

2632: AND UPPER(name) = UPPER(p_display_name);
2633: WHILE(l_count > 0) LOOP
2634: l_pmf_disp_name := bsc_utility.get_Next_DispName(l_pmf_disp_name);
2635: SELECT COUNT(1) INTO l_count
2636: FROM BIS_DIMENSIONS_VL
2637: WHERE UPPER(name) = UPPER(l_pmf_disp_name);
2638: END LOOP;
2639: END IF;
2640: END IF;

Line 2937: FROM BIS_DIMENSIONS_VL

2933: RAISE FND_API.G_EXC_ERROR;
2934: END IF;
2935:
2936: SELECT COUNT(1) INTO l_count
2937: FROM BIS_DIMENSIONS_VL
2938: WHERE UPPER(short_name) <> UPPER(p_dim_short_name)
2939: AND UPPER(name) = UPPER(p_display_name);
2940: IF (l_count <> 0) THEN
2941: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');

Line 3328: FROM BIS_DIMENSIONS_VL

3324:
3325: CURSOR cr_bis_dim_short_name IS
3326: SELECT dimension_id
3327: ,name
3328: FROM BIS_DIMENSIONS_VL
3329: WHERE short_name = p_dim_short_name;
3330:
3331: CURSOR cr_bsc_dimension_id IS
3332: SELECT dim_group_id