Adding Responsibility to the oracle apps user from backend in oracle apps

View assigned responsibilities:


SELECT  fu.user_name,
               frt.responsibility_name
  FROM fnd_user_resp_groups furg,
              fnd_user fu,
              fnd_responsibility_tl frt
 WHERE furg.user_id = fu.user_id
   AND    furg.responsibility_id = frt.responsibility_id
   AND    fu.user_name = '&1'

Add responsibility ::

BEGIN
FND_USER_PKG.AddResp('MYUSER', ' APPLICATION_SHORT_NAME ', 'RESPOSIBILITY_KEY',
'STANDARD', 'DESCRIPTION', sysdate, null);
END;
/

How to  find application id  short name ::

SQL>  select  RESPONSIBILITY_KEY ,RESPONSIBILITY_ID,APPLICATION_ID from  fnd_responsibility  where  RESPONSIBILITY_ID  like '50240';

RESPONSIBILITY_KEY             RESPONSIBILITY_ID    APPLICATION_ID

------------------------------        ----------------- --------------

XXX_INVENTORY                            50240                           401

SQL> select APPLICATION_ID ,APPLICATION_SHORT_NAME from fnd_application where  APPLICATION_ID like '401';

APPLICATION_ID    APPLICATION_SHORT_NAME

-------------- ---------    -----------------------------------------

           401                   INV

SQL>  select  RESPONSIBILITY_KEY ,RESPONSIBILITY_ID from  fnd_responsibility  where  RESPONSIBILITY_ID  like '50240';

RESPONSIBILITY_KEY             RESPONSIBILITY_ID

------------------------------ -----------------

XXXX_INVENTORY                            50240