APPS.BSC_COLOR_RANGE_PVT dependencies on BSC_COLOR_RANGES

Line 140: ,p_Bsc_Kpi_Color_Range_Rec IN BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec

136: ************************************************************************************/
137: PROCEDURE Create_Color_Range (
138: p_commit IN VARCHAR2 := FND_API.G_FALSE
139: ,p_range_id IN NUMBER
140: ,p_Bsc_Kpi_Color_Range_Rec IN BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec
141: ,p_user_id IN FND_USER.user_id%TYPE
142: ,x_return_status OUT NOCOPY VARCHAR2
143: ,x_msg_count OUT NOCOPY NUMBER
144: ,x_msg_data OUT NOCOPY VARCHAR2

Line 146: l_bsc_kpi_color_range_rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;

142: ,x_return_status OUT NOCOPY VARCHAR2
143: ,x_msg_count OUT NOCOPY NUMBER
144: ,x_msg_data OUT NOCOPY VARCHAR2
145: ) IS
146: l_bsc_kpi_color_range_rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
147: l_th_count NUMBER;
148: BEGIN
149:
150: FND_MSG_PUB.Initialize;

Line 158: INSERT INTO bsc_color_ranges(color_range_id

154: l_bsc_kpi_color_range_rec := p_Bsc_Kpi_Color_Range_Rec;
155:
156: IF(p_Bsc_Kpi_Color_Range_Rec IS NOT NULL) THEN
157: FOR l_th_count IN 1..p_Bsc_Kpi_Color_Range_Rec.COUNT LOOP
158: INSERT INTO bsc_color_ranges(color_range_id
159: ,color_range_sequence
160: ,low
161: ,high
162: ,color_id)

Line 228: DELETE bsc_color_ranges

224: FND_MSG_PUB.ADD;
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227:
228: DELETE bsc_color_ranges
229: WHERE color_range_id = p_color_range_id;
230:
231: EXCEPTION
232: WHEN OTHERS THEN