Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Thursday, August 13, 2015

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.



No comments: