APPS.BSC_COLOR_PVT dependencies on BSC_SYS_COLORS_B

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

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

Line 57: FROM BSC_SYS_COLORS_B

53: SAVEPOINT BscColorPvt_CrtColor;
54:
55: IF(p_Bsc_Color_Rec.Color_id IS NOT NULL) THEN
56: SELECT COUNT(1) INTO l_Count
57: FROM BSC_SYS_COLORS_B
58: WHERE COLOR_ID = p_Bsc_Color_Rec.Color_id;
59:
60: IF (l_Count > 0) THEN
61: FND_MESSAGE.SET_NAME('BSC','BSC_COLOR_ID_EXISTS');

Line 392: UPDATE bsc_sys_colors_b

388: ,last_update_login= l_login_id
389: WHERE color_id= l_Bsc_Color_Rec.color_id
390: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
391:
392: UPDATE bsc_sys_colors_b
393: SET perf_sequence = l_Bsc_Color_Rec.perf_sequence
394: ,color = l_Bsc_Color_Rec.color
395: ,forecast_color = l_Bsc_Color_Rec.forecast_color
396: ,numeric_equivalent = l_Bsc_Color_Rec.numeric_equivalent

Line 512: FROM bsc_sys_colors_b

508: SAVEPOINT BscColorPvt_LoadColor;
509:
510: SELECT COUNT(1)
511: INTO l_count
512: FROM bsc_sys_colors_b
513: WHERE short_name = p_Bsc_Color_Rec.short_name;
514:
515: IF (l_count > 0) THEN
516: Load_Translated_Color(p_Bsc_Color_Rec => p_Bsc_Color_Rec