APPS.BSC_COLOR_RANGE_PVT dependencies on BSC_COLOR_TYPE_PROPS

Line 41: l_user_id bsc_color_type_props.last_updated_by%TYPE;

37: ,x_return_status OUT NOCOPY VARCHAR2
38: ,x_msg_count OUT NOCOPY NUMBER
39: ,x_msg_data OUT NOCOPY VARCHAR2
40: ) IS
41: l_user_id bsc_color_type_props.last_updated_by%TYPE;
42: l_count NUMBER;
43: BEGIN
44:
45: FND_MSG_PUB.Initialize;

Line 59: FROM bsc_color_type_props

55:
56: IF (p_kpi_measure_id IS NULL) THEN
57: SELECT COUNT(1)
58: INTO l_count
59: FROM bsc_color_type_props
60: WHERE indicator = p_objective_id
61: AND kpi_measure_id IS NULL;
62: ELSE
63: SELECT COUNT(1)

Line 65: FROM bsc_color_type_props

61: AND kpi_measure_id IS NULL;
62: ELSE
63: SELECT COUNT(1)
64: INTO l_count
65: FROM bsc_color_type_props
66: WHERE indicator = p_objective_id
67: AND kpi_measure_id = p_kpi_measure_id
68: AND NVL(property_value, -1) = DECODE(p_property_value, NULL, -1, p_property_value);
69: END IF;

Line 79: INSERT INTO bsc_color_type_props(indicator

75: END IF;
76:
77: l_user_id := FND_GLOBAL.USER_ID;
78:
79: INSERT INTO bsc_color_type_props(indicator
80: ,kpi_measure_id
81: ,color_type
82: ,color_range_id
83: ,property_value

Line 266: DELETE bsc_color_type_props

262: FND_MSG_PUB.ADD;
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265:
266: DELETE bsc_color_type_props
267: WHERE color_range_id = p_color_range_id;
268:
269: Delete_Color_Ranges(p_color_range_id => p_color_range_id
270: ,x_return_status => x_return_status