eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.BSC_UPGRADES_GENERIC dependencies on BSC_SYS_INIT

Line 27: -- This function will to insert initial grant role for all existing scorecards if a flag in bsc_sys_init table does not exist.

23:
24:
25: /*******************************************************************************************************
26: -- Upgrade for BSC 5.2 Roled Based Security Scorecard
27: -- This function will to insert initial grant role for all existing scorecards if a flag in bsc_sys_init table does not exist.
28: -- It will grant Designer Role (update Acess) to all design user (user with BSC_Manager or BSC_DESIGNER)
29: -- After this funciton executed, then it will set a flag in bsc_sys_init table, so it won't run next time.
30: *********************************************************************************************************/
31: FUNCTION Upgrade_Role_To_Tabs

Line 29: -- After this funciton executed, then it will set a flag in bsc_sys_init table, so it won't run next time.

25: /*******************************************************************************************************
26: -- Upgrade for BSC 5.2 Roled Based Security Scorecard
27: -- This function will to insert initial grant role for all existing scorecards if a flag in bsc_sys_init table does not exist.
28: -- It will grant Designer Role (update Acess) to all design user (user with BSC_Manager or BSC_DESIGNER)
29: -- After this funciton executed, then it will set a flag in bsc_sys_init table, so it won't run next time.
30: *********************************************************************************************************/
31: FUNCTION Upgrade_Role_To_Tabs
32: (
33: x_error_msg OUT NOCOPY VARCHAR2

Line 43: l_property_code bsc_sys_init.property_code%TYPE ;

39: l_msg_data VARCHAR2(2000);
40: x_return_status VARCHAR2(5000);
41: x_msg_count NUMBER;
42: x_msg_data VARCHAR2(5000);
43: l_property_code bsc_sys_init.property_code%TYPE ;
44: l_property_value bsc_sys_init.property_value%TYPE ;
45: l_role_name VARCHAR2(256);
46: l_object_name VARCHAR2(256);
47: l_object_id NUMBER;

Line 44: l_property_value bsc_sys_init.property_value%TYPE ;

40: x_return_status VARCHAR2(5000);
41: x_msg_count NUMBER;
42: x_msg_data VARCHAR2(5000);
43: l_property_code bsc_sys_init.property_code%TYPE ;
44: l_property_value bsc_sys_init.property_value%TYPE ;
45: l_role_name VARCHAR2(256);
46: l_object_name VARCHAR2(256);
47: l_object_id NUMBER;
48: l_instance_type FND_GRANTS.instance_type%TYPE;

Line 80: -- check bsc_sys_init for flag

76:
77: BEGIN
78: l_property_code := 'GRANT_ROLE_TAB';
79:
80: -- check bsc_sys_init for flag
81: IF NOT BSC_UPDATE_UTIL.Get_Init_Variable_Value(l_property_code, l_property_value) THEN
82: RAISE FND_API.G_EXC_ERROR;
83: END IF;
84: --dbms_output.put_line(substr('Value of l_property_value='||l_property_value,1,255));

Line 177: l_property_code bsc_sys_init.property_code%TYPE ;

173: l_msg_data VARCHAR2(2000);
174: x_return_status VARCHAR2(5000);
175: x_msg_count NUMBER;
176: x_msg_data VARCHAR2(5000);
177: l_property_code bsc_sys_init.property_code%TYPE ;
178: l_property_value bsc_sys_init.property_value%TYPE ;
179: l_tab_id NUMBER;
180: l_tab_view_id NUMBER;
181: l_name bsc_tab_views_vl.name%TYPE;

Line 178: l_property_value bsc_sys_init.property_value%TYPE ;

174: x_return_status VARCHAR2(5000);
175: x_msg_count NUMBER;
176: x_msg_data VARCHAR2(5000);
177: l_property_code bsc_sys_init.property_code%TYPE ;
178: l_property_value bsc_sys_init.property_value%TYPE ;
179: l_tab_id NUMBER;
180: l_tab_view_id NUMBER;
181: l_name bsc_tab_views_vl.name%TYPE;
182: l_help bsc_tab_views_vl.help%TYPE;

Line 193: -- check bsc_sys_init for flag

189:
190: BEGIN
191: l_property_code := 'TAB_VIEW_FUNCS';
192:
193: -- check bsc_sys_init for flag
194: IF NOT BSC_UPDATE_UTIL.Get_Init_Variable_Value(l_property_code, l_property_value) THEN
195: RAISE FND_API.G_EXC_ERROR;
196: END IF;
197: --dbms_output.put_line(substr('Value of l_property_value='||l_property_value,1,255));

Line 258: l_property_code bsc_sys_init.property_code%TYPE ;

254: l_msg_data VARCHAR2(2000);
255: x_return_status VARCHAR2(5000);
256: x_msg_count NUMBER;
257: x_msg_data VARCHAR2(5000);
258: l_property_code bsc_sys_init.property_code%TYPE ;
259: l_property_value bsc_sys_init.property_value%TYPE ;
260: l_label_id NUMBER;
261: l_count NUMBER;
262:

Line 259: l_property_value bsc_sys_init.property_value%TYPE ;

255: x_return_status VARCHAR2(5000);
256: x_msg_count NUMBER;
257: x_msg_data VARCHAR2(5000);
258: l_property_code bsc_sys_init.property_code%TYPE ;
259: l_property_value bsc_sys_init.property_value%TYPE ;
260: l_label_id NUMBER;
261: l_count NUMBER;
262:
263: CURSOR c_all_tab_view_kpis IS

Line 270: -- check bsc_sys_init for flag

266: from bsc_tab_view_kpi_tl;
267: BEGIN
268: l_property_code := 'TAB_VIEW_KPIS';
269:
270: -- check bsc_sys_init for flag
271: IF NOT BSC_UPDATE_UTIL.Get_Init_Variable_Value(l_property_code, l_property_value) THEN
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;
274: --dbms_output.put_line(substr('Value of l_property_value='||l_property_value,1,255));