Tuesday, January 20, 2009

FND_GLOBAL PACKAGE

Recently i come accross a requirement to capture the requestidof 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 awarethat this package exists..
FND_GLOBAL package gives the most of the enviroment 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_INTIALIZEprocedure 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;

16 comments:

Anonymous said...

Thanks.
Very Informative.
I was looking for it

Anonymous said...

Thanx for the information...
Too useful :)

Poonam said...

My login id value is always -1, when I use FND_GLOBAL.LOGIN_ID.
How shall I retrieve the correct value.
Lots of Thanks in Advance.

announcements said...

This is so cool and the information contributes a lot to all people. Thanks for this post.

note pads said...

By the way, what is FND?

baby photo books said...

Thanks for giving us ideas on FND_Global Package. Thanks for this post.

Christmas cards said...

I am glad that you shared this thought about FND. Keep on updating us.

holiday greetings cards said...

I love this FND: Global Package. Thanks for sharing this information.

christmas party invitations said...

Thanks for making us aware of this. Thank you very much for updating us.

Christmas Photo Books said...

thanks for making us aware of this package. At least we are now informed.

John said...

Useless - where does the package live?

Anonymous said...

Very useful info for me..Keep on posting good stuff.. Thanks..

Unknown said...
This comment has been removed by the author.
Unknown said...
This comment has been removed by the author.
Unknown said...
This comment has been removed by the author.
Unknown said...


Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.