SELECT fnd_profile.VALUE ('GL_SET_OF_BKS_ID') FROM DUAL--获取当前帐套
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 |
初始化:
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;