Wartości FND_PROFILE oraz FND_GLOBAL

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

Ten wpis został opublikowany w kategorii PLSQL, SQL-ki. Dodaj zakładkę do bezpośredniego odnośnika.

Dodaj komentarz