ASSIGN RESPONSIBILITY FROM BACKEND

/* Formatted on 2020/02/11 11:33 (Formatter Plus v4.8.8) */
SELECT responsibility_id, responsibility_name
  FROM fnd_responsibility_vl
 WHERE responsibility_name LIKE 'System Administrator';





 DECLARE

  v_user_name  VARCHAR2(30) := '94533';
  Enter_Resp_Id  VARCHAR2(100) ;
  v_resp_appl  VARCHAR2(100);
  v_resp_key   VARCHAR2(100);
  v_appl_id    VARCHAR2(30);

BEGIN
select APPLICATION_ID ,RESPONSIBILITY_KEY
  into v_appl_id ,v_resp_key
  from FND_RESPONSIBILITY_VL
where RESPONSIBILITY_ID=('20420');

select APPLICATION_SHORT_NAME
  into v_resp_appl
  from FND_APPLICATION_VL 
where upper(APPLICATION_ID) = v_appl_id;

  fnd_user_pkg.addresp(username       => v_user_name
                      ,resp_app       => v_resp_appl
                      ,resp_key       => v_resp_key
                      ,security_group => 'STANDARD'
                      ,description    => 'Auto Assignment'
                      ,start_date     => SYSDATE
                      ,end_date       => SYSDATE + 1000);
END;
commit;
/