Oracle EBS 二次开发 FND_GLOBAL PACKAGE 返回全局变量

 

 

这个包，可以应用于你的 PL/SQL 中！ 

这个包返回系统的全局变量。 你可以设置那个列insert 或者update。

 

                  主要函数：

 

                              FND_GLOBAL.USER_ID(SERVER) RETURN NUMBER    返回登陆者的ID

                              FND_GLOBAL.APPS_INITIALIZE(USER_ID IN  NUMBER,

                                                                                                                RESP_ID IN NUMBER,

                                                                                                                RESP_APPL_ID IN NUMBER)  设置全局变量和profile values 在数据库中。

                                                参数说明：  USER_ID The USER_ID number
                                                                            RESP_ID The ID number of the responsibility
                                                                              RESP_APPL_ID The ID number of the application to which the responsibility belongs

                              EXAMPLE    fnd_global.APPS_INITIALIZE (1010, 20417, 201);

 

                            FND_GLOBAL.LOGIN_ID RETURN NUMBER;  返回登陆ID

                              FND_CLOBAL.CONC_LOGIN_ID RETURN NUMBER  返并发执行的登陆ID

                    　 FND_GLOBAL.PROG_APPL_ID  RETURN NUMBER    返回并发执行的项目应用ID

                            FND_GLOBAL.CONC_PROGRAM_ID RETURN NUMBER 返回并发项目ID

                              FND_GLOBAL.CONC_REQUEST_ID RETURN NUMBER  返回请求ID