APPS.BSC_COLOR_RANGES_PUB dependencies on BSC_COLOR_RANGE_ID_S

Line 71: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL

67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: SAVEPOINT BscColorRangePub_CrtColorRng;
70:
71: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL
72: INTO l_range_id
73: FROM DUAL;
74:
75:

Line 110: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL

106: END IF;
107:
108: IF (p_kpi_measure_id IS NULL) THEN -- Threshold is for objective.
109: FOR c_shared IN c_shared_obj LOOP
110: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL
111: INTO l_range_id
112: FROM DUAL;
113: BSC_COLOR_RANGE_PVT.Create_Color_Props(p_objective_id => c_shared.indicator
114: ,p_kpi_measure_id => p_kpi_measure_id

Line 201: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL

197: FND_MSG_PUB.ADD;
198: RAISE FND_API.G_EXC_ERROR;
199: END IF;
200:
201: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL
202: INTO l_range_id
203: FROM DUAL;
204:
205: l_color_type := 'PERCENT_OF_TARGET';

Line 254: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL

250:
251: FOR c_shared IN c_shared_obj LOOP
252: l_objective_id := c_shared.indicator;
253:
254: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL
255: INTO l_range_id
256: FROM DUAL;
257:
258: IF (p_kpi_measure_id IS NOT NULL) THEN

Line 1024: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL

1020: x_return_status := FND_API.G_RET_STS_SUCCESS;
1021:
1022: SAVEPOINT BscColorRangePub_CrtColorRng;
1023:
1024: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL
1025: INTO l_range_id
1026: FROM DUAL;
1027:
1028: -- ppandey get all the shared objectives and cascade the ranges to it.