APPS.FND_PREFERENCE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

   SELECT preference_value INTO l_pref_value
     FROM fnd_user_preferences
     WHERE user_name=p_user_name
     AND module_name=p_module_name
     AND preference_name=p_pref_name;

Line: 63

	UPDATE	fnd_user_preferences
	SET		preference_value=p_pref_value
	WHERE	user_name=p_user_name
	AND		module_name=p_module_name
	AND		preference_name=p_pref_name;

Line: 71

		INSERT INTO	fnd_user_preferences
		(
			user_name,
			module_name,
			preference_name,
			preference_value
		)
		VALUES
		(
			p_user_name,
			p_module_name,
			p_pref_name,
			p_pref_value
		);

Line: 143

   SELECT COUNT(1) INTO l_count
     FROM fnd_user_preferences
     WHERE user_name=p_user_name
     AND module_name=p_module_name
     AND preference_name=p_pref_name;

Line: 160

    DELETE FROM fnd_user_preferences
      WHERE user_name=p_user_name
      AND  module_name=p_module_name
      AND  preference_name=p_pref_name;

Line: 186

      delete_all(p_user_name,p_module_name);

Line: 204

PROCEDURE delete_all(p_user_name IN VARCHAR2,
		     p_module_name IN VARCHAR2)
  IS
BEGIN
   DELETE FROM fnd_user_preferences
     WHERE user_name=p_user_name
     AND  module_name=p_module_name;

Line: 222

  select nvl(preference_value,'*NULL*') into l_pref_value
  from   fnd_user_preferences
  where  user_name = p_user_name
  and    module_name = p_module_name
  and    preference_name = p_pref_name;

Line: 246

  update fnd_user_preferences
  set    preference_value = decode(p_pref_value, '*NULL*', null, p_pref_value)
  where  user_name = p_user_name
  and    module_name = p_module_name
  and    preference_name = p_pref_name;

Line: 253

    insert into fnd_user_preferences (
      user_name,
      module_name,
      preference_name,
      preference_value)
        values
     (p_user_name,
      p_module_name,
      p_pref_name,
      decode(p_pref_value, '*NULL*', null, p_pref_value));