APPS.WF_LOCAL_SYNCH dependencies on FND_PREFERENCE

Line 3016: -- For each FND or PER DISABLED user call fnd_preference.get() to get the previous

3012: errstack varchar2(4000);
3013:
3014: begin
3015:
3016: -- For each FND or PER DISABLED user call fnd_preference.get() to get the previous
3017: -- preference value, if exists call fnd_preference.put() to reset the same preference
3018: for fnd_usr_rec in c_fnd_users loop
3019:
3020: -- Concatenate username with orig system and orig system id to make it unique

Line 3017: -- preference value, if exists call fnd_preference.put() to reset the same preference

3013:
3014: begin
3015:
3016: -- For each FND or PER DISABLED user call fnd_preference.get() to get the previous
3017: -- preference value, if exists call fnd_preference.put() to reset the same preference
3018: for fnd_usr_rec in c_fnd_users loop
3019:
3020: -- Concatenate username with orig system and orig system id to make it unique
3021: -- in FND_USER_PREFERENCES table

Line 3024: l_prev_preference := fnd_preference.get(l_userName, 'WF' , 'PREV_MAILTYPE');

3020: -- Concatenate username with orig system and orig system id to make it unique
3021: -- in FND_USER_PREFERENCES table
3022: l_userName := fnd_usr_rec.name || ':' || fnd_usr_rec.orig_system || ':' ||
3023: fnd_usr_rec.orig_system_id;
3024: l_prev_preference := fnd_preference.get(l_userName, 'WF' , 'PREV_MAILTYPE');
3025:
3026: if(l_prev_preference is not null) then
3027:
3028: fnd_preference.put(fnd_usr_rec.name, 'WF' , 'MAILTYPE', l_prev_preference);

Line 3028: fnd_preference.put(fnd_usr_rec.name, 'WF' , 'MAILTYPE', l_prev_preference);

3024: l_prev_preference := fnd_preference.get(l_userName, 'WF' , 'PREV_MAILTYPE');
3025:
3026: if(l_prev_preference is not null) then
3027:
3028: fnd_preference.put(fnd_usr_rec.name, 'WF' , 'MAILTYPE', l_prev_preference);
3029: -- remove the row from FND_USER_PREFERENCES table after reset
3030: fnd_preference.remove(l_userName, 'WF' , 'PREV_MAILTYPE');
3031:
3032: end if;

Line 3030: fnd_preference.remove(l_userName, 'WF' , 'PREV_MAILTYPE');

3026: if(l_prev_preference is not null) then
3027:
3028: fnd_preference.put(fnd_usr_rec.name, 'WF' , 'MAILTYPE', l_prev_preference);
3029: -- remove the row from FND_USER_PREFERENCES table after reset
3030: fnd_preference.remove(l_userName, 'WF' , 'PREV_MAILTYPE');
3031:
3032: end if;
3033:
3034: end loop;

Line 3036: -- For each DISABLED user/role other than FND or PER, call fnd_preference.get() to get

3032: end if;
3033:
3034: end loop;
3035:
3036: -- For each DISABLED user/role other than FND or PER, call fnd_preference.get() to get
3037: -- the previous preference value, if exists call wf_local_synch.Propagate_User
3038: -- to reset the notification preference in wf_local_roles table
3039: for user_rec in c_other_users loop
3040:

Line 3044: l_prev_preference := fnd_preference.get(l_userName, 'WF' , 'PREV_MAILTYPE');

3040:
3041: -- Concatenate username with orig system and orig system id to make it unique
3042: -- in FND_USER_PREFERENCES table
3043: l_userName := user_rec.name || ':' || user_rec.orig_system || ':' || user_rec.orig_system_id;
3044: l_prev_preference := fnd_preference.get(l_userName, 'WF' , 'PREV_MAILTYPE');
3045:
3046: if(l_prev_preference is not null) then
3047:
3048: wf_event.AddParameterToList('orclWorkFlowNotificationPref', l_prev_preference, l_parameterlist);

Line 3054: fnd_preference.remove(l_userName, 'WF' , 'PREV_MAILTYPE');

3050: wf_event.AddParameterToList('RAISEERRORS', 'TRUE', l_parameterlist);
3051: wf_local_synch.Propagate_User(user_rec.orig_system , user_rec.orig_system_id , l_parameterlist);
3052:
3053: -- remove the row from FND_USER_PREFERENCES table after reset
3054: fnd_preference.remove(l_userName, 'WF' , 'PREV_MAILTYPE');
3055:
3056: end if;
3057:
3058: end loop;