APPS.BSC_BIS_DIM_GROUP_PUB dependencies on BIS_DIMENSIONS

Line 45: FROM bis_dimensions

41: l_msg_data VARCHAR2(2000);
42:
43: CURSOR cr_dim_id IS
44: SELECT dimension_id, short_name
45: FROM bis_dimensions
46: WHERE dimension_id = p_dimension_id;
47:
48: CURSOR cr_dim_short_name IS
49: SELECT dimension_id, short_name

Line 50: FROM bis_dimensions

46: WHERE dimension_id = p_dimension_id;
47:
48: CURSOR cr_dim_short_name IS
49: SELECT dimension_id, short_name
50: FROM bis_dimensions
51: WHERE short_name = p_short_name;
52:
53: BEGIN
54:

Line 65: l_msg_data := 'Record does not exist for BIS_DIMENSIONS.DIMENSION_ID =<'||p_dimension_id||'>';

61: FETCH cr_dim_id
62: INTO l_dimension_rec.dimension_id
63: , l_dimension_rec.dimension_short_name;
64: IF (cr_dim_id%ROWCOUNT = 0) THEN
65: l_msg_data := 'Record does not exist for BIS_DIMENSIONS.DIMENSION_ID =<'||p_dimension_id||'>';
66: x_return_status := FND_API.G_RET_STS_ERROR;
67: END IF;
68: CLOSE cr_dim_id;
69: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 81: l_msg_data := 'Record does not exist for BIS_DIMENSIONS.SHORT_NAME =<'||p_short_name||'>';

77: FETCH cr_dim_short_name
78: INTO l_dimension_rec.dimension_id
79: , l_dimension_rec.dimension_short_name;
80: IF (cr_dim_short_name%ROWCOUNT = 0) THEN
81: l_msg_data := 'Record does not exist for BIS_DIMENSIONS.SHORT_NAME =<'||p_short_name||'>';
82: x_return_status := FND_API.G_RET_STS_ERROR;
83: END IF;
84: CLOSE cr_dim_short_name;
85: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

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';