FND_PROFILE and FND_GLOBAL values

5 04 2017

Following are the FND_PROFILE values that can be used in the PL/SQL code:

fnd_profile.value(‘PROFILEOPTION’);

fnd_profile.value(‘MFG_ORGANIZATION_ID’);

fnd_profile.value(‘ORG_ID’);

fnd_profile.value(‘LOGIN_ID’);

fnd_profile.value(‘USER_ID’);

fnd_profile.value(‘USERNAME’);

fnd_profile.value(‘CONCURRENT_REQUEST_ID’);

fnd_profile.value(‘GL_SET_OF_BKS_ID’);

fnd_profile.value(‘SO_ORGANIZATION_ID’);

fnd_profile.value(‘APPL_SHRT_NAME’);

fnd_profile.value(‘RESP_NAME’);

fnd_profile.value(‘RESP_ID’);
Following are the FND_GLOBAL values that can be used in the PL/SQL code:

FND_GLOBAL.USER_ID;

FND_GLOBAL.APPS_INTIALIZE;

FND_GLOBAL.LOGIN_ID;

FND_GLOBAL.CONC_LOGIN_ID;

FND_GLOBAL.PROG_APPL_ID;

FND_GLOBAL.CONC_PROGRAM_ID;

FND_GLOBAL.CONC_REQUEST_ID;
For example, I almost always use the following global variable assignments in my package specification to use throughout the entire package body:

g_user_id      PLS_INTEGER  :=  fnd_global.user_id;

g_login_id     PLS_INTEGER  :=  fnd_global.login_id;

g_conc_req_id  PLS_INTEGER  :=  fnd_global.conc_request_id;

g_org_id       PLS_INTEGER  :=  fnd_profile.value(‘ORG_ID’);

g_sob_id       PLS_INTEGER  :=  fnd_profile.value(‘GL_SET_OF_BKS_ID’);
And initialize the application environment as follows:

v_resp_appl_id  := fnd_global.resp_appl_id;

v_resp_id       := fnd_global.resp_id;

v_user_id       := fnd_global.user_id;

 

FND_GLOBAL.APPS_INITIALIZE(v_user_id,v_resp_id, v_resp_appl_id);

Advertisements

Actions

Information

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




%d bloggers like this: