Oracle Apps: Add Responsibility to User
Adding a Responsibility to an Oracle User in R12 Oracle Apps using API -- FND_USER_PKG.ADDRESP to add responsibility ‘System Administrator’ for the user ‘USERZEE’ using the API. DECLARE v_user_name VARCHAR2 (100) := 'USERZEE'; v_responsibility_name VARCHAR2 (100) := 'System Administrator'; v_application_name VARCHAR2 (100) := NULL; v_responsibility_key VARCHAR2 (100) := NULL; v_security_group VARCHAR2 (100) := NULL; v_description VARCHAR2 (100) := NULL; BEGIN SELECT fa.application_short_name, fr.responsibility_key, ...