EBS 11i Add resposibility api

Find the necessary details for a particular responsibility:

    

 SELECT fa.application_short_name,

                fr.responsibility_key,

                frg.security_group_key,                     

                frt.description

    FROM apps.fnd_responsibility fr,

                apps.fnd_application fa,

                apps.fnd_security_groups frg,

                apps.fnd_responsibility_tl frt

   WHERE fr.application_id = fa.application_id

     AND    fr.data_group_id = frg.security_group_id

     AND    fr.responsibility_id = frt.responsibility_id

     AND    frt.LANGUAGE = USERENV ('LANG')

     AND    frt.responsibility_name = 'RESP_NAME_HERE'

  fnd_user_pkg.addresp (username          => v_user_name,

                                             resp_app           => v_application_name,

                                             resp_key            => v_responsibility_key,

                                             security_group => v_security_group,

                                             description        => v_description,

                                             start_date          => SYSDATE,

                                             end_date            => NULL

                                            );

SQL> exec fnd_user_pkg.addresp('SHAIKS','XXSSHAIK','RESP_NAME_HERE,'STANDARD',null,sysdate,NULL);

PL/SQL procedure successfully completed.

SQL> COMMIT;

Commit complete.