APPS.BSC_COLOR_PUB 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: Public 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: | 16-APR-2007 Bug #5938481 Changing the system level weight is not changing |
22: | the prototype flag of the objectives |
23: +======================================================================================+

Line 110: l_User_Numeric_Equivalent_Orig bsc_sys_colors_b.user_numeric_equivalent%TYPE;

106: l_sys_color NUMBER;
107: l_Bsc_Color_Rec BSC_COLOR_PUB.Bsc_Color_Rec;
108: l_token_found BOOLEAN;
109: l_Weight_Reconfigured BOOLEAN;
110: l_User_Numeric_Equivalent_Orig bsc_sys_colors_b.user_numeric_equivalent%TYPE;
111:
112: CURSOR c_Kpis IS
113: SELECT
114: indicator

Line 146: FROM bsc_sys_colors_b

142: ,l_Bsc_Color_Rec.Color
143: ,l_Bsc_color_rec.forecast_color
144: ,l_Bsc_Color_Rec.Numeric_Equivalent
145: ,l_User_Numeric_Equivalent_Orig
146: FROM bsc_sys_colors_b
147: WHERE color_id = l_color_id;
148:
149: IF l_User_Numeric_Equivalent_Orig <> l_Bsc_Color_Rec.User_Numeric_Equivalent THEN
150: l_Weight_Reconfigured := TRUE;