APPS.BSC_COLOR_PKG dependencies on BSC_SYS_COLORS_B

Line 19: | provide CRUD APIs for BSC_SYS_COLORS_B and related table |

15: | Pradeep Pandey |
16: | |
17: | Description: Package Body version. |
18: | This package is CRUD for System level Color properties |
19: | provide CRUD APIs for BSC_SYS_COLORS_B and related table |
20: | |
21: +======================================================================================+
22: */
23:

Line 49: INSERT INTO bsc_sys_colors_b (color_id

45: ,p_Last_Update_Login IN NUMBER
46: ) IS
47: BEGIN
48:
49: INSERT INTO bsc_sys_colors_b (color_id
50: ,short_name
51: ,perf_sequence
52: ,color
53: ,user_color

Line 129: UPDATE bsc_sys_colors_b

125: ,p_Last_Update_Login IN NUMBER
126: ) IS
127: BEGIN
128: -- Update by id or short_name
129: UPDATE bsc_sys_colors_b
130: SET perf_sequence = p_Perf_Sequence_Id
131: ,color = p_System_Color
132: ,user_color = p_User_Color
133: ,user_forecast_color = p_User_Forecast_Color

Line 170: UPDATE bsc_sys_colors_b

166: ,p_Last_Update_Login IN NUMBER
167: ) IS
168: BEGIN
169: -- Update by id or short_name
170: UPDATE bsc_sys_colors_b
171: SET perf_sequence = p_Perf_Sequence_Id
172: ,color = p_System_Color
173: ,user_color = p_User_Color
174: ,user_forecast_color = p_User_Forecast_Color

Line 193: DELETE BSC_SYS_COLORS_B

189: ) IS
190: l_bsc_color_id NUMBER;
191: BEGIN
192: IF (p_Bsc_Color_Id IS NOT NULL) THEN
193: DELETE BSC_SYS_COLORS_B
194: WHERE color_id = p_Bsc_Color_Id;
195:
196: DELETE bsc_sys_colors_tl
197: WHERE color_id = p_Bsc_Color_Id;

Line 201: FROM bsc_sys_colors_b

197: WHERE color_id = p_Bsc_Color_Id;
198: ELSE -- Delete by short_name
199: SELECT color_id
200: INTO l_bsc_color_id
201: FROM bsc_sys_colors_b
202: WHERE short_name=p_Bsc_Color_SN;
203:
204: DELETE BSC_SYS_COLORS_B
205: WHERE short_name = p_Bsc_Color_SN;

Line 204: DELETE BSC_SYS_COLORS_B

200: INTO l_bsc_color_id
201: FROM bsc_sys_colors_b
202: WHERE short_name=p_Bsc_Color_SN;
203:
204: DELETE BSC_SYS_COLORS_B
205: WHERE short_name = p_Bsc_Color_SN;
206:
207: DELETE bsc_sys_colors_tl
208: WHERE color_id = l_bsc_color_id;