ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 关于 profile value

关于 profile value

原创 Linux操作系统 作者:liangff 时间:2009-05-21 12:19:30 0 删除 编辑

在客户端取profile value:

BEGIN
  fnd_global.APPS_INITIALIZE

    (user_id => 1110 , -- 要取的profle对应的user

     resp_id => 50321, -- 要取的profle对应的职责

      resp_appl_id =>101 -- 要取的profle对应的application

        );
END;

select FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME') from dual;


Application context related APIs. The server-side package FND_GLOBAL returns the values of system globals, such as the login/signon or "session" type of values. You should not use FND_GLOBAL routines in your forms (that is on the client side). On the client side, most of the procedures in the FND_GLOBAL package are replaced by a user profile option with the same (or a similar) name. You should use FND_PROFILE routines in your forms instead.


select FND_PROFILE.value('USER_ID') from dual

-- VALUE - returns the value of a profile options

如果前面有设   fnd_global.APPS_INITIALIZE 能取到user id,

也可以用select fnd_global.user_id, FND_GLOBAL.resp_id, FND_GLOBAL.resp_appl_id from dual

但是用,select FND_PROFILE.VALUE_SPECIFIC('USER_ID') from dual

-- VALUE_SPECIFIC - Get profile value for a specific user/resp/appl combo

取不到user_id

但是设的相应的profile value可以通过该方法取得

如: select FND_PROFILE.VALUE_SPECIFIC('GL_SET_OF_BKS_NAME',null,50322,101) from dual

可以取得,设的特定的profile value.


select * from   fnd_profile_option_values

这个表里存放具体profile option 的value。

其中level_id 标识,该profile option是设在那个层级下的,level_value是这个层级对应的id:

LEVEL_ID = 10001, site 级,level_value 全部为0,不使用;
LEVEL_ID = 10002, application级,level_value = application_id
LEVEL_ID = 10003,  responsibility级, level_value = responsibility_id
LEVEL_ID = 10004,  user级, level_value = user_id


 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8754571/viewspace-600657/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-05-19

  • 博文量
    12
  • 访问量
    12395