DECLARE
l_resp_id INTEGER;
l_app_id INTEGER;
l_user_id INTEGER;
l_person_id INTEGER;
l_person_name VARCHAR2 (200);
l_person_l_name VARCHAR2 (200);
l_person_f_name VARCHAR2 (200);
l_person_m_name VARCHAR2 (200);
l_phone_number VARCHAR (200);
BEGIN
-- Test statements here
SELECT responsibility_id, application_id
INTO l_resp_id, l_app_id
FROM fnd_responsibility_vl
WHERE responsibility_name = 'АСФК: Все функции';
SELECT user_id
INTO l_user_id
FROM fnd_user
WHERE user_name = 'NLESIN';
fnd_global.apps_initialize (l_user_id, l_resp_id, l_app_id);
END;
Где:
NLESIN - Учётная запись пользователя в OeBS
