FND_GLOBAL API's

scu2005發表於2010-01-18
API
In Oracle Application, we have several API, in which few are termed as Global API's. These Global API's can be run only in Server (PL/SQL methods or Oracle Reports and not in Oracle Forms). These API's provide information about the current environment settings to the program.

Below are the FND_GLOBAL API's which are mostly used to fill the WHO columns in a base table.

FND_GLOBAL.USER_ID

    This function returns the current user id who has logged in to Oracle Apps. No parameter is required for the function.
   
FND_GLOBAL.LOGIN_ID

    This function returns the login id of the current user who has logged in to Oracle Apps. No parameter is required for the function.
   
FND_GLOBAL.CONC_LOGIN_ID

    This function returns the login id by which the current concurrent program is running in Oracle Apps. No parameter is required for the function.

FND_GLOBAL.PROG_APPL_ID

    This function returns the application id in which the current concurrent program is running in Oracle Apps. No parameter is required for the function.

FND_GLOBAL.CONC_PROGRAM_ID

    This function returns the program id of currently running concurrent program in Oracle Apps. No parameter is required for the function.
   
FND_GLOBAL.CONC_REQUEST_ID

    This function returns the concurrent request id of currently running concurrent program in Oracle Apps. No parameter is required for the function.

APPS_INITIALIZE

    This procedure initializes the global environment for running/processing some set of instructions particularly for a user in a particular responsibility.
    This program takes three parameters
    1. USER_ID - user id,
    2. RESP_ID - responsibility id and
    3. RESP_APPL_ID - responsibility application id.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/11536986/viewspace-625321/，如需轉載，請註明出處，否則將追究法律責任。

相關文章