[Home] [Help]
181: -- Assignment_Check (INTERNAL routine only)
182: --
183: -- Check whether a particular assignment of a user to a role exists,
184: -- regardless of start/end date. This is different from
185: -- wf_directory.IsPerformer which only operates for current sysdate.
186: -- In: username- user name
187: -- In: rolename- role name
188: --
189: function Assignment_Check(username in varchar2,
515:
516:
517: /* We can't just assume that the orig system is FND_USR. It could */
518: /* be PER because the row in wf_users/wf_roles is one or the other */
519: wf_directory.GetRoleOrigSysInfo(username,
520: l_user_orig_system,
521: l_user_orig_system_id);
522:
523: /* In case there is no WF user, sync this user up so there is one.*/
525: /* # Should we remove this code and just trust the bulk sync? */
526: if( (l_user_orig_system is NULL)
527: and (l_user_orig_system_id is NULL)) then
528: fnd_user_pkg.user_synch(username);
529: wf_directory.GetRoleOrigSysInfo(username,
530: l_user_orig_system,
531: l_user_orig_system_id);
532: end if;
533:
703: end if;
704:
705: /* We can't just assume that the orig system is FND_USR. It could */
706: /* be PER because the row in wf_users/wf_roles is one or the other */
707: wf_directory.GetRoleOrigSysInfo(username,
708: l_user_orig_system,
709: l_user_orig_system_id);
710:
711: /* In case there is no WF user, sync this user up so there is one.*/
713: /* # Should we remove this code and just trust bulk sync?*/
714: if( (l_user_orig_system is NULL)
715: and (l_user_orig_system_id is NULL)) then
716: fnd_user_pkg.user_synch(username);
717: wf_directory.GetRoleOrigSysInfo(username,
718: l_user_orig_system,
719: l_user_orig_system_id);
720: end if;
721:
925: ':'||resp_id;
926:
927: -- Bug3649874 propagate the who columns
928:
929: wf_directory.GetRoleOrigSysInfo(x_user_name,
930: l_user_orig_system,
931: l_user_orig_system_id);
932:
933: wf_local_synch.PropagateUserRole
1552: 'USER_ROLE Not FOUND. Need to insert');
1553: end if;
1554: -- We cant just assume that the orig system is FND_USR. It could
1555: -- be PER because the row in wf_users/wf_roles is one or the other
1556: wf_directory.GetRoleOrigSysInfo(rowrec.user_name,
1557: l_user_orig_system,
1558: l_user_orig_system_id);
1559: -- In case there is no WF user, sync this user up so there is one.
1560: -- Should never happen but be safe in case sync wasnt perfect in past
1566: 'Orig system and id not found. Trying to sync user:'||
1567: rowrec.user_name);
1568: end if;
1569: fnd_user_pkg.user_synch(rowrec.user_name);
1570: wf_directory.GetRoleOrigSysInfo(rowrec.user_name,
1571: l_user_orig_system,
1572: l_user_orig_system_id);
1573: end if;
1574: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then