Oracle eBS經驗分享

1.FND_GLOBAL.USERID --Returns userid

2.FND_GLOBAL.APPS_INTIALIZE procedure

•    APPS_INITIALIZE(user_id in number,resp_id in number,resp_appl_id in number);
     This is used to set the values userid and responsibilityid for a session
  3.FND_GLOBAL.LOGIN_ID -Gives login id
  4.FND_GLOBAL.CONC_LOGIN_ID--Not sure how to use this
  5.FND_GLOBAL.PROG_APPL_ID--Concurrent program application id
  6.FND_GLOBAL.CONC_PROGRAM_ID--Concurrent program id
  7.FND_GLOBAL.CONC_REQUEST_ID (Server)This will give the concurrent request id of the program which is calling the plsql package..

ln_Request_id:=FND_GLOBAL.CONC_REQUEST_ID;