关于FND_PROFILE与FND_GLOBLE[Z]
fnd_global package可以取得一些關於當前login in用戶的信息
取得當前responsibility名稱
fnd_profile.value('RESP_NAME')
fnd_profile.value('RESP_ID')
|
USERNAME |
Your user’s current Oracle Application Object Library username. |
|
USER_ID |
Your user’s current Oracle Application Object Library user ID. |
|
RESP_ID |
Your user’s current responsibility ID. |
|
APPL_SHRT_NAME |
The short name of the application connected to your user’s current responsibility. |
|
RESP_APPL_ID |
The application ID of the application connected to your user’s current responsibility. |
|
FORM_NAME |
The name of the current form. Not available for concurrent programs. |
|
FORM_ID |
The form. ID of the current form. Not available for concurrent programs. |
|
FORM_APPL_NAME |
The name of the application for which the current form. is registered. Not available for concurrent programs. |
|
FORM_APPL_ID |
The application ID of the application for which the current form. is registered. Not available for concurrent programs. |
|
LOGON_DATE |
Your user’s logon date for the current session. |
|
LAST_LOGON_DATE |
Your user’s logon date for the previous session. |
|
LOGIN_ID |
Your user’s Sign–On Audit login ID in Oracle Application Object Library. |
|
CONC_REQUEST_ID |
instance of your running current program. You can only use this profile option in a concurrent program. You use this profile option to fill the REQUEST_ID Who column. |
|
CONC_PROGRAM_ID |
The program ID associated with a running current program. You can only use this profile option in a concurrent program. You use this profile option to fill the PROGRAM_ID Who column. |
|
CONC_PROGRAM_APPLICATION_ID |
The application ID associated with a running current program. You can only use this profile option in a concurrent program. You use this profile option to fill the PROGRAM_APPLICATION_ID Who column. |
|
CONC_LOGIN_ID |
The login ID associated with a running concurrent program. You can only use this profile option in a concurrent program. You can use this profile option to fill the LAST_UPDATE_LOGIN Who column. |
|
CONC_PRINT_OUTPUT |
The value Yes or No that you enter in the Print Output field when you register a concurrentprogram. You can use the routine afpoput() fromyour concurrent programs to change the value ofthis profile option for a particular instance of yourrunning concurrent program. This profile optiondetermines whether the concurrent managers printthe concurrent program’s output to the printer. |
|
CONC_PRINT_STYLE |
The print style. of your concurrent program’soutput that you enter in the Print Style. field whenyou register a concurrent program. You can usethe routine afpoput() from your concurrentprograms to change the value of this profile option |
要查询得到基于Muti-Org的视图中的数据，一般有以下几种方法：
1．
begin
dbms_application_info.set_client_info(:org_id);-
end;
2．
Declare
x_org_id number;
begin
Fnd_profile.GET('ORG_ID',x_org_id);
fnd_client_info.set_org_context(x_org_id);
end;
3．
begin
fnd_client_info.setup.client_info(application_id => 1,
responsibility_id => 2,
user_id in number => 3,
security_group_id => 4);
end;
4.
begin
fnd_global.APPS_Initialize( user_id=>3070,
resp_id=>50650,
resp_appl_id =>20003);
end;
