APPS.BSC_COLOR_RANGES_PUB dependencies on DUAL

Line 73: FROM DUAL;

69: SAVEPOINT BscColorRangePub_CrtColorRng;
70:
71: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL
72: INTO l_range_id
73: FROM DUAL;
74:
75:
76: FOR l_loop_count IN 1..p_threshold_color.COUNT LOOP
77: l_threshold := p_threshold_color(l_loop_count);

Line 112: FROM DUAL;

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
115: ,p_color_type => p_color_type
116: ,p_color_range_id => l_range_id

Line 203: FROM DUAL;

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';
206:
207: IF (p_color_method IS NULL OR p_color_method > 3) THEN

Line 256: FROM DUAL;

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
259: SELECT kpi_measure_id
260: INTO l_kpi_measure_id

Line 1026: FROM DUAL;

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.
1029: -- This is existing approach also, and it allows us to provide functionality
1030: -- to support different threashold for shared objective if needed in future.