关于FND_PROFILE与FND_GLOBLE
来源:互联网 发布:软件工程项目实例 编辑:程序博客网 时间:2024/04/28 06:41
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;
- 关于FND_PROFILE与FND_GLOBLE
- FND_PROFILE
- Sample of API FND_PROFILE
- fnd_profile.value的用法
- fnd_profile.value的用法
- fnd_profile.value的用法
- 如何在report中使用fnd_profile.value ,srw.user_exit
- Using API FND_PROFILE.save to update profile from backend
- 关于与
- EBS中调用fnd_profile.value(GL_ACCESS_SET_ID)取不到值的情况
- 关于&&与&,||与|
- 关于火星与地球~~~~~
- 关于伪科学与想象力
- 关于面试与加薪
- 关于爱情与等待
- 关于成长与独立
- 关于gcc与g++
- 关于gcc与g++
- java中求100到1000的质数和
- C# 界面间数据传递
- Redmine、Apache、Git集成遇到的重重困难
- 解决java java.io.FileNotFoundException: http:\localhost:8080 (文件名、目录名或卷)问题
- 高性能mysql之统计表
- 关于FND_PROFILE与FND_GLOBLE
- 删除指针
- 为kindeditor添加在线播放视频功能(基于原有flash上传,mp4,flv,flash)
- Java Test network connection and set TimeOut time length
- Android SurfaceView 详解(二)
- 数据库设计5步骤
- OFBiz 的中文乱码解决方案
- Java应用开发:文件加密解密
- sendmail 在AS5全新安装