AOL: Apps Initialize Script

 Apps Initialization Script  : 

l_resp_id number; 

l_user_id number; 

l_app_id   number;

BEGIN

select t.RESPONSIBILITY_ID 

into g_resp_id

 from fnd_responsibility_tl t where t.RESPONSIBILITY_NAME like 'Purchasing Administrator';

SELECT f.USER_ID

into l_user_id

 FROM fnd_user f WHERE f.user_name =  'USERNAME';

 select t.application_id 

into l_app_id  

from fnd_application_vl t where application_short_name = 'PO';

  fnd_global.apps_initialize(user_id           => l_user_id

                            ,resp_id           => g_resp_id

                            ,resp_appl_id      => l_app_id  

                            ,security_group_id => 0

                            ,server_id         => NULL);

EXCEPTION

  WHEN OTHERS THEN

    dbms_output.put_line('SQLERRM ' || SQLERRM);

  

END;