[Home] [Help]
873: p_start_date in date,
874: p_expiration_date in date) is
875:
876: cursor linked_per_users is
877: select user_name from fnd_user
878: where employee_id = p_orig_system_id;
879:
880: cursor linked_tca_users is
881: select user_name from fnd_user
877: select user_name from fnd_user
878: where employee_id = p_orig_system_id;
879:
880: cursor linked_tca_users is
881: select user_name from fnd_user
882: where customer_id = p_orig_system_id;
883:
884: cursor fnd_users is
885: select user_name from fnd_user
880: cursor linked_tca_users is
881: select user_name from fnd_user
882: where customer_id = p_orig_system_id;
883:
884: cursor fnd_users is
885: select user_name from fnd_user
886: where user_id = p_orig_system_id;
887:
888: l_partitionID NUMBER;
881: select user_name from fnd_user
882: where customer_id = p_orig_system_id;
883:
884: cursor fnd_users is
885: select user_name from fnd_user
886: where user_id = p_orig_system_id;
887:
888: l_partitionID NUMBER;
889: l_partitionName varchar2(30);
924: if (g_overWrite_UserRoles) then -- <6817561>
925: l_overWrite_UserRoles := 'Y';
926: end if;
927: --
928: -- tell entmgr if linked to an FND user
929: --
930: if (p_orig_system = 'FND_USR') then
931: for myuser in fnd_users loop
932: wf_local_synch.update_entmgr('USER',
927: --
928: -- tell entmgr if linked to an FND user
929: --
930: if (p_orig_system = 'FND_USR') then
931: for myuser in fnd_users loop
932: wf_local_synch.update_entmgr('USER',
933: myuser.user_name,
934: p_attributes,
935: p_orig_system);
1061:
1062: -- If the calling orig_system is 'FND_USR' and g_employeeID is not null, we
1063: -- need to check for one of two situations.
1064: --
1065: -- First, a new FND_USER might be created with the association to an employee
1066: -- in the same transaction.
1067: --
1068: -- Second, an FND_USER might be updated to be associated with the employee.
1069: --
1064: --
1065: -- First, a new FND_USER might be created with the association to an employee
1066: -- in the same transaction.
1067: --
1068: -- Second, an FND_USER might be updated to be associated with the employee.
1069: --
1070: -- If there is an employee id, fnd_usr is required to populate the
1071: -- employeeID attribute for every call to WF_LOCAL_SYNCH.
1072: --
1196:
1197: end if;
1198:
1199: if (sql%rowcount > 0) then
1200: -- If we were able to delete an fnd_user from wf_local_roles then
1201: -- We can change any wf_local_user_roles over to PER.
1202:
1203: -- We will now reassign all active user/role relationships.
1204: WF_DIRECTORY.ReassignUserRoles(g_name, p_orig_system,
1349: raise;
1350: end if;
1351: end;
1352: */
1353: -- Now we need to update all of the user_roles back to the fnd_user.
1354: WF_DIRECTORY.ReassignUserRoles(g_name, 'PER', g_employeeID,
1355: p_orig_system, p_orig_system_id,
1356: g_lastUpdateDate, g_lastUpdatedBy,
1357: g_lastUpdateLogin
1358: , g_overWrite_UserRoles -- <6817561>
1359: );
1360:
1361: else
1362: --FND_USER is propagating a user that is not associated with an employee.
1363: g_origSystem := p_orig_system;
1364: g_origSystemID := p_orig_system_id;
1365:
1366: begin
1680:
1681: --Due to the association between employees and users, we have special
1682: --handling for calls coming from 'PER'. If 'PER' is inserting a new
1683: --record (creating an employee), it cannot be associated with a user
1684: --since the FND User form is responsible for that. So we will create
1685: --a 'PER_ROLE' to designate an employee that is not associated with a user.
1686: --
1687: --However, if the employee is already associated with a user, then this would
1688: --be an update call. We need to preserve the NOTIFICATION_PREFERENCE,
1921: when NO_DATA_FOUND then
1922: if (p_user_orig_system = 'FND_USR') then --Check for possible PER
1923: SELECT user_name, employee_id, 'PER'
1924: INTO l_userName, l_origSystemID, l_origSystem
1925: FROM FND_USER
1926: WHERE USER_ID = p_user_orig_system_id;
1927: end if;
1928: end;
1929: