Для добавления функций в избранное по полномочиям — API:FND_SIGNON.UPDATE_NAVIGATOR
declare
l_user_id number;
l_resp_id number;
l_appl_id number;
begin
select user_id into l_user_id
from fnd_user t
where t.user_name = 'TEST_USER';
select fr.application_id, fr.responsibility_id
into l_appl_id, l_resp_id
from fnd_responsibility fr
where fr.responsibility_key = 'SYSTEM_ADMINISTRATOR';
fnd_global.apps_initialize(l_user_id, l_resp_id, l_appl_id);
fnd_signon.update_navigator(user_id => fnd_global.USER_ID,
resp_id => l_resp_id,
appl_id => l_appl_id,
login_id => fnd_global.LOGIN_ID,
function1 => 'FND_FNDSCAUS',
function2 => 'FND_FNDSCRSP',
function3 => 'FND_FNDCPMCP_SYS',
function4 => 'FND_FNDFFMDC',
function5 => 'FND_FNDFFMIS',
function6 => 'FND_FNDFFMVS',
function7 => 'FND_FNDFFMSV',
function8 => 'FND_FNDMNMNU',
function9 => 'WF_STATUS_MONITOR',
function10 => 'FND_CP_SEARCH_CONC_PROG',
window_width => 10,
window_height => 7,
window_xpos => 2.6,
window_ypos => 0.7,
new_window_flag => 'N');
end;
Последние комментарии