FND_PROFILE
to use the current value for the session
FND_PROFILE.VALUE :
This is a function which returns a character string. It can be used to retrieve the current value of the specified user profile option.
This is a function which returns a character string. It can be used to retrieve the current value of the specified user profile option.
Example:
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’)
No comments:
Post a Comment