eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_COLOR_RANGES_PUB dependencies on BSC_COLOR_RANGE_PVT

Line 85: BSC_COLOR_RANGE_PVT.Create_Color_Props(p_objective_id => p_objective_id

81: l_is_succ := Get_Next_Token(l_threshold,':',l_Bsc_Kpi_Color_Range_Rec(l_loop_count).color_id);
82:
83: END LOOP;
84:
85: BSC_COLOR_RANGE_PVT.Create_Color_Props(p_objective_id => p_objective_id
86: ,p_kpi_measure_id => p_kpi_measure_id
87: ,p_color_type => p_color_type
88: ,p_color_range_id => l_range_id
89: ,p_property_value => p_property_value

Line 98: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => l_range_id

94: RAISE FND_API.G_EXC_ERROR;
95: END IF;
96:
97: l_user_id := FND_GLOBAL.USER_ID;
98: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => l_range_id
99: ,p_Bsc_Kpi_Color_Range_Rec => l_Bsc_Kpi_Color_Range_Rec
100: ,p_user_id => l_user_id
101: ,x_return_status => x_return_status
102: ,x_msg_count => x_msg_count

Line 113: BSC_COLOR_RANGE_PVT.Create_Color_Props(p_objective_id => c_shared.indicator

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
117: ,p_property_value => p_property_value

Line 124: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => l_range_id

120: ,x_msg_data => x_msg_data);
121: IF (x_return_status <> 'S') THEN
122: RAISE FND_API.G_EXC_ERROR;
123: END IF;
124: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => l_range_id
125: ,p_Bsc_Kpi_Color_Range_Rec => l_Bsc_Kpi_Color_Range_Rec
126: ,p_user_id => l_user_id
127: ,x_return_status => x_return_status
128: ,x_msg_count => x_msg_count

Line 216: BSC_COLOR_RANGE_PVT.Create_Color_Props(p_objective_id => p_objective_id

212: END IF;
213:
214: l_Bsc_Kpi_Color_Range_Rec := Get_Def_Color_Range_Rec(p_color_method);
215:
216: BSC_COLOR_RANGE_PVT.Create_Color_Props(p_objective_id => p_objective_id
217: ,p_kpi_measure_id => p_kpi_measure_id
218: ,p_color_type => l_color_type
219: ,p_color_range_id => l_range_id
220: ,p_property_value => p_property_value

Line 229: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => l_range_id

225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227:
228: l_user_id := FND_GLOBAL.USER_ID;
229: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => l_range_id
230: ,p_Bsc_Kpi_Color_Range_Rec => l_Bsc_Kpi_Color_Range_Rec
231: ,p_user_id => l_user_id
232: ,x_return_status => x_return_status
233: ,x_msg_count => x_msg_count

Line 268: BSC_COLOR_RANGE_PVT.Create_Color_Props(p_objective_id => c_shared.indicator

264: AND analysis_option1 = l_an_opt1
265: AND analysis_option2 = l_an_opt2
266: AND series_id = l_series_id;
267:
268: BSC_COLOR_RANGE_PVT.Create_Color_Props(p_objective_id => c_shared.indicator
269: ,p_kpi_measure_id => l_kpi_measure_id
270: ,p_color_type => l_color_type
271: ,p_color_range_id => l_range_id
272: ,p_property_value => p_property_value

Line 281: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => l_range_id

277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279:
280: l_user_id := FND_GLOBAL.USER_ID;
281: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => l_range_id
282: ,p_Bsc_Kpi_Color_Range_Rec => l_Bsc_Kpi_Color_Range_Rec
283: ,p_user_id => l_user_id
284: ,x_return_status => x_return_status
285: ,x_msg_count => x_msg_count

Line 895: BSC_COLOR_RANGE_PVT.Delete_Color_Ranges(p_color_range_id => l_color_range_ids_rec.color_range_id

891: AND kpi_measure_id = p_kpi_measure_id
892: AND NVL(property_value, -1) = DECODE(p_property_value, NULL, -1, p_property_value);
893: END IF;
894:
895: BSC_COLOR_RANGE_PVT.Delete_Color_Ranges(p_color_range_id => l_color_range_ids_rec.color_range_id
896: ,x_return_status => x_return_status
897: ,x_msg_count => x_msg_count
898: ,x_msg_data => x_msg_data);
899: IF (x_return_status <> 'S') THEN

Line 905: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => l_color_range_ids_rec.color_range_id

901: END IF;
902:
903: l_user_id := FND_GLOBAL.USER_ID;
904:
905: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => l_color_range_ids_rec.color_range_id
906: ,p_Bsc_Kpi_Color_Range_Rec => l_Bsc_Kpi_Color_Range_Rec
907: ,p_user_id => l_user_id
908: ,x_return_status => x_return_status
909: ,x_msg_count => x_msg_count

Line 962: BSC_COLOR_RANGE_PVT.Delete_Color_Ranges(p_color_range_id => l_range_id

958:
959: l_range_id := Get_Range_Id(c_shared.indicator, l_kpi_measure_id, p_property_value);
960: END IF;
961:
962: BSC_COLOR_RANGE_PVT.Delete_Color_Ranges(p_color_range_id => l_range_id
963: ,x_return_status => x_return_status
964: ,x_msg_count => x_msg_count
965: ,x_msg_data => x_msg_data);
966:

Line 970: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => l_range_id

966:
967: IF (x_return_status <> 'S') THEN
968: RAISE FND_API.G_EXC_ERROR;
969: END IF;
970: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => l_range_id
971: ,p_Bsc_Kpi_Color_Range_Rec => l_Bsc_Kpi_Color_Range_Rec
972: ,p_user_id => l_user_id
973: ,x_return_status => x_return_status
974: ,x_msg_count => x_msg_count

Line 1033: BSC_COLOR_RANGE_PVT.Create_Color_Props(p_objective_id => p_objective_id

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.
1031: -- This case is when weaghted threshold is defined for master Objective.
1032:
1033: BSC_COLOR_RANGE_PVT.Create_Color_Props(p_objective_id => p_objective_id
1034: ,p_kpi_measure_id => p_kpi_measure_id
1035: ,p_color_type => p_color_type
1036: ,p_color_range_id => l_range_id
1037: ,x_return_status => x_return_status

Line 1171: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => p_color_range_id

1167: END LOOP;
1168: -- ppandey: get all the shared objectives and cascade the ranges to it.
1169: -- This is existing approach also, and it allows us to provide functionality
1170: -- to support different threashold for shared objective if needed in future.
1171: BSC_COLOR_RANGE_PVT.Create_Color_Range(p_range_id => p_color_range_id
1172: ,p_Bsc_Kpi_Color_Range_Rec => l_Bsc_Kpi_Color_Range_Rec
1173: ,p_user_id => FND_GLOBAL.user_id
1174: ,x_return_status => x_return_status
1175: ,x_msg_count => x_msg_count

Line 1279: BSC_COLOR_RANGE_PVT.Delete_Color_Prop_Ranges(p_color_range_id => l_range_id

1275: -- If objective threshold- Delete for shared objective also.
1276: IF (l_kpi_measure_id IS NULL) THEN
1277: FOR c_ranges IN c_all_ranges LOOP
1278: l_range_id := c_ranges.color_range_id;
1279: BSC_COLOR_RANGE_PVT.Delete_Color_Prop_Ranges(p_color_range_id => l_range_id
1280: ,x_return_status => x_return_status
1281: ,x_msg_count => x_msg_count
1282: ,x_msg_data => x_msg_data);
1283: IF (x_return_status <> 'S') THEN

Line 1290: BSC_COLOR_RANGE_PVT.Delete_Color_Prop_Ranges(p_color_range_id => l_range_id

1286: END LOOP;
1287: ELSE
1288: FOR c_ranges IN c_measure_ranges LOOP
1289: l_range_id := c_ranges.color_range_id;
1290: BSC_COLOR_RANGE_PVT.Delete_Color_Prop_Ranges(p_color_range_id => l_range_id
1291: ,x_return_status => x_return_status
1292: ,x_msg_count => x_msg_count
1293: ,x_msg_data => x_msg_data);
1294: IF (x_return_status <> 'S') THEN

Line 1316: BSC_COLOR_RANGE_PVT.Delete_Color_Prop_Ranges(p_color_range_id => l_range_id

1312: l_objective_id := c_shared.indicator;
1313: IF (l_kpi_measure_id IS NULL) THEN
1314: FOR c_ranges IN c_all_ranges LOOP
1315: l_range_id := c_ranges.color_range_id;
1316: BSC_COLOR_RANGE_PVT.Delete_Color_Prop_Ranges(p_color_range_id => l_range_id
1317: ,x_return_status => x_return_status
1318: ,x_msg_count => x_msg_count
1319: ,x_msg_data => x_msg_data);
1320: IF (x_return_status <> 'S') THEN

Line 1336: BSC_COLOR_RANGE_PVT.Delete_Color_Prop_Ranges(p_color_range_id => l_range_id

1332: AND series_id = l_series_id;
1333:
1334: FOR c_ranges IN c_measure_ranges LOOP
1335: l_range_id := c_ranges.color_range_id;
1336: BSC_COLOR_RANGE_PVT.Delete_Color_Prop_Ranges(p_color_range_id => l_range_id
1337: ,x_return_status => x_return_status
1338: ,x_msg_count => x_msg_count
1339: ,x_msg_data => x_msg_data);
1340: IF (x_return_status <> 'S') THEN

Line 1409: BSC_COLOR_RANGE_PVT.Delete_Color_Prop_Ranges(p_color_range_id => l_range_id

1405: -- to support different threashold for shared objective if needed in future.
1406: -- If measure threshold- delete for measures in shared objective also.
1407: -- If objective threshold- Delete for shared objective also.
1408: l_range_id := p_color_range_id;
1409: BSC_COLOR_RANGE_PVT.Delete_Color_Prop_Ranges(p_color_range_id => l_range_id
1410: ,x_return_status => x_return_status
1411: ,x_msg_count => x_msg_count
1412: ,x_msg_data => x_msg_data);
1413: IF (x_return_status <> 'S') THEN

Line 1437: BSC_COLOR_RANGE_PVT.Delete_Color_Prop_Ranges(p_color_range_id => l_range_id

1433: AND series_id = l_series_id;
1434:
1435: l_range_id := Get_Range_Id(c_shared.indicator, l_kpi_measure_id, l_property_value);
1436:
1437: BSC_COLOR_RANGE_PVT.Delete_Color_Prop_Ranges(p_color_range_id => l_range_id
1438: ,x_return_status => x_return_status
1439: ,x_msg_count => x_msg_count
1440: ,x_msg_data => x_msg_data);
1441: IF (x_return_status <> 'S') THEN