DBA Data[Home] [Help]

APPS.WF_LOCAL_SYNCH dependencies on FND_USER

Line 879: select user_name from fnd_user

875: p_start_date in date,
876: p_expiration_date in date) is
877:
878: cursor linked_per_users is
879: select user_name from fnd_user
880: where employee_id = p_orig_system_id;
881:
882: cursor linked_tca_users is
883: select user_name from fnd_user

Line 883: select user_name from fnd_user

879: select user_name from fnd_user
880: where employee_id = p_orig_system_id;
881:
882: cursor linked_tca_users is
883: select user_name from fnd_user
884: where customer_id = p_orig_system_id;
885:
886: cursor fnd_users is
887: select user_name from fnd_user

Line 886: cursor fnd_users is

882: cursor linked_tca_users is
883: select user_name from fnd_user
884: where customer_id = p_orig_system_id;
885:
886: cursor fnd_users is
887: select user_name from fnd_user
888: where user_id = p_orig_system_id;
889:
890: l_partitionID NUMBER;

Line 887: select user_name from fnd_user

883: select user_name from fnd_user
884: where customer_id = p_orig_system_id;
885:
886: cursor fnd_users is
887: select user_name from fnd_user
888: where user_id = p_orig_system_id;
889:
890: l_partitionID NUMBER;
891: l_partitionName varchar2(30);

Line 932: -- tell entmgr if linked to an FND user

928: if (g_overWrite_UserRoles) then -- <6817561>
929: l_overWrite_UserRoles := 'Y';
930: end if;
931: --
932: -- tell entmgr if linked to an FND user
933: --
934: if (p_orig_system = 'FND_USR') then
935: for myuser in fnd_users loop
936: wf_local_synch.update_entmgr('USER',

Line 935: for myuser in fnd_users loop

931: --
932: -- tell entmgr if linked to an FND user
933: --
934: if (p_orig_system = 'FND_USR') then
935: for myuser in fnd_users loop
936: wf_local_synch.update_entmgr('USER',
937: myuser.user_name,
938: p_attributes,
939: p_orig_system);

Line 1069: -- First, a new FND_USER might be created with the association to an employee

1065:
1066: -- If the calling orig_system is 'FND_USR' and g_employeeID is not null, we
1067: -- need to check for one of two situations.
1068: --
1069: -- First, a new FND_USER might be created with the association to an employee
1070: -- in the same transaction.
1071: --
1072: -- Second, an FND_USER might be updated to be associated with the employee.
1073: --

Line 1072: -- Second, an FND_USER might be updated to be associated with the employee.

1068: --
1069: -- First, a new FND_USER might be created with the association to an employee
1070: -- in the same transaction.
1071: --
1072: -- Second, an FND_USER might be updated to be associated with the employee.
1073: --
1074: -- If there is an employee id, fnd_usr is required to populate the
1075: -- employeeID attribute for every call to WF_LOCAL_SYNCH.
1076: --

Line 1208: -- If we were able to delete an fnd_user from wf_local_roles then

1204:
1205: end if;
1206:
1207: if (sql%rowcount > 0) then
1208: -- If we were able to delete an fnd_user from wf_local_roles then
1209: -- We can change any wf_local_user_roles over to PER.
1210:
1211: -- We will now reassign all active user/role relationships.
1212: WF_DIRECTORY.ReassignUserRoles(g_name, p_orig_system,

Line 1361: -- Now we need to update all of the user_roles back to the fnd_user.

1357: raise;
1358: end if;
1359: end;
1360: */
1361: -- Now we need to update all of the user_roles back to the fnd_user.
1362: WF_DIRECTORY.ReassignUserRoles(g_name, 'PER', g_employeeID,
1363: p_orig_system, p_orig_system_id,
1364: g_lastUpdateDate, g_lastUpdatedBy,
1365: g_lastUpdateLogin

Line 1370: --FND_USER is propagating a user that is not associated with an employee.

1366: , g_overWrite_UserRoles -- <6817561>
1367: );
1368:
1369: else
1370: --FND_USER is propagating a user that is not associated with an employee.
1371: g_origSystem := p_orig_system;
1372: g_origSystemID := p_orig_system_id;
1373:
1374: begin

Line 1697: --since the FND User form is responsible for that. So we will create

1693:
1694: --Due to the association between employees and users, we have special
1695: --handling for calls coming from 'PER'. If 'PER' is inserting a new
1696: --record (creating an employee), it cannot be associated with a user
1697: --since the FND User form is responsible for that. So we will create
1698: --a 'PER_ROLE' to designate an employee that is not associated with a user.
1699: --
1700: --However, if the employee is already associated with a user, then this would
1701: --be an update call. We need to preserve the NOTIFICATION_PREFERENCE,

Line 1975: FROM FND_USER

1971: when NO_DATA_FOUND then
1972: if (p_user_orig_system = 'FND_USR') then --Check for possible PER
1973: SELECT user_name, employee_id, 'PER'
1974: INTO l_userName, l_origSystemID, l_origSystem
1975: FROM FND_USER
1976: WHERE USER_ID = p_user_orig_system_id;
1977: end if;
1978: end;
1979:

Line 2992: cursor c_fnd_users is

2988: */
2989: PROCEDURE bulk_reset_ntfPref(errbuf out NOCOPY varchar2,
2990: retcode out NOCOPY varchar2) is
2991:
2992: cursor c_fnd_users is
2993: select name, orig_system, orig_system_id
2994: from wf_local_roles
2995: where orig_system in ('FND_USR', 'PER')
2996: and notification_preference = 'DISABLED'

Line 3018: for fnd_usr_rec in c_fnd_users loop

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
3022: l_userName := fnd_usr_rec.name || ':' || fnd_usr_rec.orig_system || ':' ||

Line 3021: -- in FND_USER_PREFERENCES table

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
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:

Line 3029: -- remove the row from FND_USER_PREFERENCES table after reset

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;
3033:

Line 3042: -- in FND_USER_PREFERENCES table

3038: -- to reset the notification preference in wf_local_roles table
3039: for user_rec in c_other_users loop
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

Line 3053: -- remove the row from FND_USER_PREFERENCES table after reset

3049: wf_event.AddParameterToList('USER_NAME', user_rec.name, l_parameterlist);
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: