198: IF(p_Bsc_Color_Rec.numeric_equivalent IS NOT NULL) THEN
199: l_Bsc_Color_Rec.numeric_equivalent := p_Bsc_Color_Rec.numeric_equivalent;
200: END IF;
201:
202: l_user_id := fnd_global.USER_ID;
203: l_login_id := fnd_global.LOGIN_ID;
204:
205: BSC_COLOR_PKG.UPDATE_ROW(p_Color_Id => l_Bsc_Color_Rec.color_id
206: ,p_Perf_Sequence_Id => l_Bsc_Color_Rec.Perf_Sequence
199: l_Bsc_Color_Rec.numeric_equivalent := p_Bsc_Color_Rec.numeric_equivalent;
200: END IF;
201:
202: l_user_id := fnd_global.USER_ID;
203: l_login_id := fnd_global.LOGIN_ID;
204:
205: BSC_COLOR_PKG.UPDATE_ROW(p_Color_Id => l_Bsc_Color_Rec.color_id
206: ,p_Perf_Sequence_Id => l_Bsc_Color_Rec.Perf_Sequence
207: ,p_System_Color => l_Bsc_Color_Rec.color
303: l_Bsc_Color_Rec.User_Forecast_Color := l_Bsc_Color_Rec.forecast_color;
304: END IF;
305:
306:
307: l_user_id := fnd_global.USER_ID;
308: l_login_id := fnd_global.LOGIN_ID;
309:
310: BSC_COLOR_PKG.UPDATE_ROW(p_Color_Id => l_Bsc_Color_Rec.color_id
311: ,p_System_Color_Name => l_Bsc_Color_Rec.name
304: END IF;
305:
306:
307: l_user_id := fnd_global.USER_ID;
308: l_login_id := fnd_global.LOGIN_ID;
309:
310: BSC_COLOR_PKG.UPDATE_ROW(p_Color_Id => l_Bsc_Color_Rec.color_id
311: ,p_System_Color_Name => l_Bsc_Color_Rec.name
312: ,p_System_Color_Desc => l_Bsc_Color_Rec.description
374: IF(p_Bsc_Color_Rec.numeric_equivalent IS NOT NULL) THEN
375: l_Bsc_Color_Rec.numeric_equivalent := p_Bsc_Color_Rec.numeric_equivalent;
376: END IF;
377:
378: l_user_id := fnd_global.USER_ID;
379: l_login_id := fnd_global.LOGIN_ID;
380:
381: UPDATE bsc_sys_colors_tl
382: SET name = l_Bsc_Color_Rec.name
375: l_Bsc_Color_Rec.numeric_equivalent := p_Bsc_Color_Rec.numeric_equivalent;
376: END IF;
377:
378: l_user_id := fnd_global.USER_ID;
379: l_login_id := fnd_global.LOGIN_ID;
380:
381: UPDATE bsc_sys_colors_tl
382: SET name = l_Bsc_Color_Rec.name
383: ,description = l_Bsc_Color_Rec.description