126: -- Update by id or short_name
127: l_Weight_Reconfigured := FALSE;
128: FOR l_loop_count IN 1..p_bsc_color_tbl.COUNT LOOP
129: l_color_data := p_bsc_color_tbl(l_loop_count);
130: l_token_found := BSC_COLOR_RANGES_PUB.Get_Next_Token(l_color_data, ':', l_color_id);
131: l_token_found := BSC_COLOR_RANGES_PUB.Get_Next_Token(l_color_data, ':', l_Bsc_Color_Rec.User_Numeric_Equivalent);
132: l_token_found := BSC_COLOR_RANGES_PUB.Get_Next_Token(l_color_data, ':', l_Bsc_Color_Rec.User_Color);
133: l_token_found := BSC_COLOR_RANGES_PUB.Get_Next_Token(l_color_data, ':', l_Bsc_Color_Rec.User_forecast_color);
134: l_Bsc_Color_Rec.color_id := l_color_id;
127: l_Weight_Reconfigured := FALSE;
128: FOR l_loop_count IN 1..p_bsc_color_tbl.COUNT LOOP
129: l_color_data := p_bsc_color_tbl(l_loop_count);
130: l_token_found := BSC_COLOR_RANGES_PUB.Get_Next_Token(l_color_data, ':', l_color_id);
131: l_token_found := BSC_COLOR_RANGES_PUB.Get_Next_Token(l_color_data, ':', l_Bsc_Color_Rec.User_Numeric_Equivalent);
132: l_token_found := BSC_COLOR_RANGES_PUB.Get_Next_Token(l_color_data, ':', l_Bsc_Color_Rec.User_Color);
133: l_token_found := BSC_COLOR_RANGES_PUB.Get_Next_Token(l_color_data, ':', l_Bsc_Color_Rec.User_forecast_color);
134: l_Bsc_Color_Rec.color_id := l_color_id;
135:
128: FOR l_loop_count IN 1..p_bsc_color_tbl.COUNT LOOP
129: l_color_data := p_bsc_color_tbl(l_loop_count);
130: l_token_found := BSC_COLOR_RANGES_PUB.Get_Next_Token(l_color_data, ':', l_color_id);
131: l_token_found := BSC_COLOR_RANGES_PUB.Get_Next_Token(l_color_data, ':', l_Bsc_Color_Rec.User_Numeric_Equivalent);
132: l_token_found := BSC_COLOR_RANGES_PUB.Get_Next_Token(l_color_data, ':', l_Bsc_Color_Rec.User_Color);
133: l_token_found := BSC_COLOR_RANGES_PUB.Get_Next_Token(l_color_data, ':', l_Bsc_Color_Rec.User_forecast_color);
134: l_Bsc_Color_Rec.color_id := l_color_id;
135:
136: SELECT perf_sequence
129: l_color_data := p_bsc_color_tbl(l_loop_count);
130: l_token_found := BSC_COLOR_RANGES_PUB.Get_Next_Token(l_color_data, ':', l_color_id);
131: l_token_found := BSC_COLOR_RANGES_PUB.Get_Next_Token(l_color_data, ':', l_Bsc_Color_Rec.User_Numeric_Equivalent);
132: l_token_found := BSC_COLOR_RANGES_PUB.Get_Next_Token(l_color_data, ':', l_Bsc_Color_Rec.User_Color);
133: l_token_found := BSC_COLOR_RANGES_PUB.Get_Next_Token(l_color_data, ':', l_Bsc_Color_Rec.User_forecast_color);
134: l_Bsc_Color_Rec.color_id := l_color_id;
135:
136: SELECT perf_sequence
137: ,color