FND_GLOBAL and FND_PROFILE: Import List of System Global values

FND_GLOBAL and FND_PROFILE: Import List of System Global values


FND_PROFILE values:


1  fnd_profile.value('PROFILEOPTION')
2  fnd_profile.value('MFG_ORGANIZATION_ID')
3  fnd_profile.value('ORG_ID')
4  fnd_profile.value('LOGIN_ID')
5  fnd_profile.value('USER_ID')
6  fnd_profile.value('USERNAME')
7  fnd_profile.value('CONCURRENT_REQUEST_ID')
8  fnd_profile.value('GL_SET_OF_BKS_ID')
9  fnd_profile.value('SO_ORGANIZATION_ID')
10 fnd_profile.value('APPL_SHRT_NAME')
11 fnd_profile.value('RESP_NAME')
12 fnd_profile.value('RESP_ID')
13 fnd_profile.value('PER_BUSINESS_GROUP_ID')
14 fnd_profile.value('GL_SET_OF_BKS_ID')
15 fnd_profile.value('CURRENT_ORG_CONTEXT')


FND_GLOBAL values:


1  fnd_global.USER_ID
2  fnd_global.USER_NAME
3  fnd_global.RESP_ID
4  fnd_global.RESP_NAME
5  fnd_global.APPLICATION_NAME
6  fnd_global.APPLICATION_SHORT_NAME
7  fnd_global.RESP_APPL_ID
8  fnd_global.BASE_LANGUAGE
9  fnd_global.CONC_LOGIN_ID
10 fnd_global.CONC_PRIORITY_REQUEST
11 fnd_global.CONC_PROCESS_ID
12 fnd_global.CONC_PROGRAM_ID
13 fnd_global.CONC_QUEUE_ID
14 fnd_global.CONC_REQUEST_ID
15 fnd_global.CURRENT_LANGUAGE
16 fnd_global.CUSTOMER_ID
17 fnd_global.EMPLOYEE_ID
18 fnd_global.FORM_APPL_ID
19 fnd_global.FORM_ID
20 fnd_global.GET_SESSION_CONTEXT
21 fnd_global.LANGUAGE_COUNT
22 fnd_global.LOGIN_ID
23 fnd_global.NEWLINE
24 fnd_global.NLS_DATE_FORMAT
25 fnd_global.NLS_DATE_LANGUAGE
26 fnd_global.NLS_LANGUAGE
27 fnd_global.NLS_NUMERIC_CHARACTERS
28 fnd_global.NLS_SORT
29 fnd_global.NLS_TERRITORY
30 fnd_global.ORG_ID
31 fnd_global.ORG_NAME
32 fnd_global.PARTY_ID
33 fnd_global.PER_BUSINESS_GROUP_ID
34 fnd_global.PER_SECURITY_PROFILE_ID
35 fnd_global.PROG_APPL_ID
36 fnd_global.QUEUE_APPL_ID
37 fnd_global.RT_TEST_ID
38 fnd_global.SECURITY_GROUP_ID
39 fnd_global.SERVER_ID
40 fnd_global.SESSION_ID
41 fnd_global.SUPPLIER_ID
42 fnd_global.TAB


Examples to initialize the application environment:


v_user_id      PLS_INTEGER  :=  fnd_global.user_id;
v_login_id     PLS_INTEGER  :=  fnd_global.login_id;
v_conc_req_id  PLS_INTEGER  :=  fnd_global.conc_request_id;
v_org_id       PLS_INTEGER  :=  fnd_profile.value('ORG_ID');
v_sob_id       PLS_INTEGER  :=  fnd_profile.value('GL_SET_OF_BKS_ID');


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);