DBA Data[Home] [Help]

APPS.BSC_COLOR_RANGES_PUB dependencies on FND_GLOBAL

Line 97: l_user_id := FND_GLOBAL.USER_ID;

93: IF (x_return_status <> 'S') THEN
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

Line 228: l_user_id := FND_GLOBAL.USER_ID;

224: IF (x_return_status <> 'S') THEN
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

Line 280: l_user_id := FND_GLOBAL.USER_ID;

276: IF (x_return_status <> 'S') THEN
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

Line 883: ,last_updated_by = FND_GLOBAL.USER_ID

879: END IF;
880: IF (p_kpi_measure_id IS NULL) THEN
881: UPDATE bsc_color_type_props
882: SET last_update_date = sysdate
883: ,last_updated_by = FND_GLOBAL.USER_ID
884: WHERE indicator = p_objective_id
885: AND kpi_measure_id IS NULL;
886: ELSE
887: UPDATE bsc_color_type_props

Line 889: ,last_updated_by = FND_GLOBAL.USER_ID

885: AND kpi_measure_id IS NULL;
886: ELSE
887: UPDATE bsc_color_type_props
888: SET last_update_date = sysdate
889: ,last_updated_by = FND_GLOBAL.USER_ID
890: WHERE indicator = p_objective_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;

Line 903: l_user_id := FND_GLOBAL.USER_ID;

899: IF (x_return_status <> 'S') THEN
900: RAISE FND_API.G_EXC_ERROR;
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

Line 939: ,last_updated_by = FND_GLOBAL.USER_ID

935: AND kpi_measure_id IS NULL;
936:
937: UPDATE bsc_color_type_props
938: SET last_update_date = sysdate
939: ,last_updated_by = FND_GLOBAL.USER_ID
940: WHERE indicator = c_shared.indicator
941: AND kpi_measure_id IS NULL;
942: ELSE
943: SELECT kpi_measure_id

Line 954: ,last_updated_by = FND_GLOBAL.USER_ID

950: AND series_id = l_series_id;
951:
952: UPDATE bsc_color_type_props
953: SET last_update_date = sysdate
954: ,last_updated_by = FND_GLOBAL.USER_ID
955: WHERE indicator = c_shared.indicator
956: AND kpi_measure_id = l_kpi_measure_id
957: AND NVL(property_value, -1) = DECODE(p_property_value, NULL, -1, p_property_value);
958:

Line 1173: ,p_user_id => FND_GLOBAL.user_id

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
1176: ,x_msg_data => x_msg_data);
1177: IF (x_return_status <> 'S') THEN