Tuesday 13 March 2012

FND_Profile options and programatically we can assign the value to profile.


 fnd_profile.save
 GET :This is used to retrieve the current value of the specified user profile option
fnd_profile.get
FND_Profile.Get('PROFILENAME', Profile_name);
FND_Profile.Get('CONC_LOGIN_ID', Conc_login_id);
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)
  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');
566865.1,Note: 364503.1


 FND_Profile.Get('PROFILENAME', Profile_name)
  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;
 enti vachinda
  lekapothee
  nenu chepinatu cheyyi
  use
  fnd_profile.value('USERNAME')
 and then try to get this value using fnd_profile.get procedure
DECLARE
a BOOLEAN;
BEGIN
a := fnd_profile.SAVE ('CONC_REPORT_ACCESS_LEVEL' , 'R' , 'USER' , '22746' , NULL , NULL ); IF a THEN
DBMS_OUTPUT.put_line ('Success');
COMMIT;
ELSE
DBMS_OUTPUT.put_line ('Error');
END IF;
END;

No comments:

Post a Comment