Assign responsibility via backend in Oracle

Query to get the details w.r.t. the responsibility

SELECT FAV.APPLICATION_SHORT_NAME, FAV.APPLICATION_NAME,FRV.RESPONSIBILITY_KEY, FRV.RESPONSIBILITY_NAME
FROM FND_APPLICATION_VL FAV, FND_RESPONSIBILITY_VL FRV
WHERE FRV.APPLICATION_ID=FAV.APPLICATION_ID
and FRV.RESPONSIBILITY_NAME = 'System Administrator'
ORDER BY FRV.RESPONSIBILITY_NAME ;




Run the below block in APPS schema to assign the responsibility

BEGIN
        fnd_user_pkg.addresp ('<user_name>', 'SYSADMIN' , 'SYSTEM_ADMINISTRATOR', 'STANDARD',
        'Add Responsibility to USER using pl/sql', SYSDATE, SYSDATE + 1000);
        COMMIT;
        DBMS_OUTPUT.put_line ('Responsibility Added Successfully');
END;

to remove the assigned responsibility

BEGIN
        fnd_user_pkg.addresp ('<user_name>', 'SYSADMIN' , 'SYSTEM_ADMINISTRATOR', 'STANDARD');
        COMMIT;
        DBMS_OUTPUT.put_line ('Responsibility Removed Successfully');
END;