APPS.WF_PREF dependencies on FND_USER_PREFERENCES

Line 871: -- preference values are null in FND_USER_PREFERENCES table.

867: -- get_pref2
868: -- Bug 8823516 - overriden function of get_pref().
869: -- Returns the default preference 'MAILHTML' when called by the
870: -- product team and null for WFDS, if both the user and global
871: -- preference values are null in FND_USER_PREFERENCES table.
872:
873: FUNCTION get_pref2
874: (
875: p_user_name IN VARCHAR2,

Line 888: FROM FND_USER_PREFERENCES

884:
885: -- Check if there is a preference for this user
886: SELECT MAX(PREFERENCE_VALUE)
887: INTO l_preference_value
888: FROM FND_USER_PREFERENCES
889: WHERE USER_NAME = p_user_name
890: AND PREFERENCE_NAME = p_preference_name
891: AND MODULE_NAME = 'WF';
892:

Line 899: FROM FND_USER_PREFERENCES

895: IF (l_preference_value IS NULL) THEN
896:
897: SELECT MAX(PREFERENCE_VALUE)
898: INTO l_preference_value
899: FROM FND_USER_PREFERENCES
900: WHERE USER_NAME = '-WF_DEFAULT-'
901: AND PREFERENCE_NAME = p_preference_name
902: AND MODULE_NAME = 'WF';
903: