Friday 21 June 2013

FND_GLOBAL PACKAGE

Recently i come across a requirement to capture the requestid of the concurrent with in the concurrent program session...Even i am aware of the FND_GLOBAL package...But it didnt strike'at first go.....so i am writing this article for people who are not even aware that this package exists..
FND_GLOBAL package gives the most of the environment values
This package should be used in database side only...use FND_PROFILE package to get these values in Forms.
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;

Ur's
AmarAlam

0 comments:

Post a Comment