Artyku\u0142 pochodzi ze strony <\/p>\n
http:\/\/appsr12help.blogspot.com\/2012\/12\/fndprofile-values.html<\/p>\n
[For more information, please visit http:\/\/docs.oracle.com\/cd\/E18727_01\/doc.121\/e12897\/T302934T462356.htm]<\/p>\n
Following are the FND_PROFILE values that can be used in the PL\/SQL code:<\/p>\n
fnd_profile.value(’PROFILEOPTION’);
\n fnd_profile.value(’MFG_ORGANIZATION_ID’);
\n fnd_profile.value(’ORG_ID’);
\n fnd_profile.value(’LOGIN_ID’);
\n fnd_profile.value(’USER_ID’);
\n fnd_profile.value(’USERNAME’);
\n fnd_profile.value(’CONCURRENT_REQUEST_ID’);
\n fnd_profile.value(’GL_SET_OF_BKS_ID’);
\n fnd_profile.value(’SO_ORGANIZATION_ID’);
\n fnd_profile.value(’APPL_SHRT_NAME’);
\n fnd_profile.value(’RESP_NAME’);
\n fnd_profile.value(’RESP_ID’);<\/p>\n
Following are the FND_GLOBAL values that can be used in the PL\/SQL code:<\/p>\n
FND_GLOBAL.USER_ID;
\n FND_GLOBAL.APPS_INTIALIZE;
\n FND_GLOBAL.LOGIN_ID;
\n FND_GLOBAL.CONC_LOGIN_ID;
\n FND_GLOBAL.PROG_APPL_ID;
\n FND_GLOBAL.CONC_PROGRAM_ID;
\n FND_GLOBAL.CONC_REQUEST_ID;<\/p>\n
For example, I almost always use the following global variable assignments in my package specification to use throughout the entire package body:<\/p>\n
g_user_id PLS_INTEGER := fnd_global.user_id;
\n g_login_id PLS_INTEGER := fnd_global.login_id;
\n g_conc_req_id PLS_INTEGER := fnd_global.conc_request_id;
\n g_org_id PLS_INTEGER := fnd_profile.value(’ORG_ID’);
\n g_sob_id PLS_INTEGER := fnd_profile.value(’GL_SET_OF_BKS_ID’);<\/p>\n
And initialize the application environment as follows:<\/p>\n
v_resp_appl_id := fnd_global.resp_appl_id;
\n v_resp_id := fnd_global.resp_id;
\n v_user_id := fnd_global.user_id;<\/p>\n
FND_GLOBAL.APPS_INITIALIZE(v_user_id,v_resp_id, v_resp_appl_id);<\/p>\n","protected":false},"excerpt":{"rendered":"
Artyku\u0142 pochodzi ze strony http:\/\/appsr12help.blogspot.com\/2012\/12\/fndprofile-values.html [For more information, please visit http:\/\/docs.oracle.com\/cd\/E18727_01\/doc.121\/e12897\/T302934T462356.htm] 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 … Czytaj dalej