--模擬用戶登錄，該用戶ID為1010 fnd_global.apps_initialize(user_id => 1010, resp_id => 20420, resp_appl_id => 1); end; --獲取當時登錄的用戶的ID DECLARE l_user_id NUMBER := ...
--模擬用戶登錄，該用戶ID為1010 fnd_global.apps_initialize(user_id => 1010, resp_id => 20420, resp_appl_id => 1); end; --獲取當時登錄的用戶的ID DECLARE l_user_id NUMBER := fnd_global.user_id; l_employee_name VARCHAR2(30); BEGIN /* SELECT ppf.full_name INTO l_employee_name FROM per_people_f ppf, fnd_user fu WHERE fu.user_id = l_user_id AND fu.employee_id = ppf.person_id; dbms_output.put_line(l_employee_name);*/－－註釋部分為根據user_id得到對應的人員 dbms_output.put_line(l_user_id); END;
