天天看點

關于FND_PROFILE與FND_GLOBLE

fnd_global package可以取得一些關於當前login in用戶的資訊

fnd_concurrent_requests functions   select FND_PROFILE.VALUE('RESP_APPL_ID') from dual 取得目前APPLICATION_ID   select * from FND_USER_RESP_GROUPS  存放使用者所擁有的一些責任  

取得當前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;

繼續閱讀