zz:http://www.oracleappshub.com/api/oracle-api-availability-profile/
In oracle user Profile functionality is provided in the FND_PROFILE package and the FNDSQF library.
What is inside this API:
- Retrieve user profile values for the current run-time environment
- Set user profile values for the current run-time environment
There are various Objects that can be used with this API\'s. These are discussed below:
1. Put :This can be used to put a value to the specified user profile option.
Usage:
- FND_Profile.Put(\'PROFILE_NAME\',\'New_Value\')
- FND_Profile.Put(\'USERNAME\', Usr_Name)
- FND_Profile.Put(\'RESP_ID\', Resp_ID)
- FND_Profile.Put(\'RESP_APPL_ID\', Resp_App_ID)
- FND_Profile.Put(\'USER_ID\', User_ID)
2.DEFINED : this is function returns TRUE if a value has been assigned to the specified profile option.
Usage:
- SELECT fnd_profile.defined(\'ACCOUNT_GENERATOR:DEBUG_MODE\') ACC_GEN_DEBUG_SESSION_MODE FROM DUAL;
3.GET :This is used to retrieve the current value of the specified user profile option
Usage :
Different type of options can be retrieved like
- FND_Profile.Get(\'PROFILENAME\', Profile_name);
- FND_Profile.Get(\'CONC_LOGIN_ID\', Conc_login_id);
- FND_Profile.Get(\'LOGIN_ID\', loginid);
4.VALUE : This is function which returns a character string. Used to retrieve the current value of the specified user profile option.
Usage:
- fnd_profile.value(\'PROFILEOPTION\')
- fnd_profile.value(\'MFG_ORGANIZATION_ID\')
- fnd_profile.value(\'login_ID\')
- fnd_profile.value(\'USER_ID\')
- fnd_profile.value(\'USERNAME\')
- fnd_profile.value(\'CONCURRENT_REQUEST_ID\')
- fnd_profile.value(\'GL_SET_OF_BKS_ID\')
- fnd_profile.value(\'ORG_ID\')
- fnd_profile.value(\'SO_ORGANIZATION_ID\')
- fnd_profile.value(\'APPL_SHRT_NAME\')
- fnd_profile.value(\'RESP_NAME\')
- fnd_profile.value(\'RESP_ID\')
5.VALUE_WNPS: This is a function, returns a character string. This is Used to retrieve the current value of the specified user profile option without caching it.
6.SAVE_USER :This is function used to save a value for a profile option permanently to the database, for the current user level. It is necessary to explicitly issue a commit when using this function. Returns TRUE if profile option is successfully saved, otherwise FALSE.
7.SAVE :This is function used to save a value for a profile option permanently to the database, for a specified level. It is necessary to explicitly issue a commit when using this function. Returns TRUE if profile option is successfully saved, otherwise FALSE.
Usage
- fnd_profile.save(\'GUEST_USER_PWD\', \'GUEST/ORACLE\', \'SITE\');
8.INITIALIZE :This is used by internal Applications Object Library to initialize the internal profile information at the level context.
The cache is first cleared of all database options.
Usage:
- fnd_profile.initialize(user_id);
9.PUTMULTIPLE :This is used by internal Applications Object Library to set multiple pairs of profile options and values.