DBA Data[Home] [Help]

APPS.BSC_BIS_DIM_GROUP_PUB dependencies on BIS_DIMENSIONS_VL

Line 99: SELECT COUNT(*) INTO l_count FROM bis_dimensions_vl

95: RAISE FND_API.G_EXC_ERROR;
96: END IF;
97:
98: --check for uniqueness of p_display_name
99: SELECT COUNT(*) INTO l_count FROM bis_dimensions_vl
100: WHERE name = p_display_name
101: AND dimension_id <> l_dimension_rec.dimension_id;
102: IF (l_count > 0) THEN
103: l_msg_data := 'P_DISPLAY_NAME =<'||p_display_name||'> must be UNIQUE';