APPS.WF_MAINTENANCE dependencies on FND_USER

Line 375: cursor c_invalid_fnd_users is

371: where wura.user_name = wur.user_name
372: and wura.role_name = wur.role_name);
373:
374: --Invalid and Duplicated records in the (FND_USR) partition
375: cursor c_invalid_fnd_users is
376: select wu.rowid, wu.orig_system old_orig_system,
377: wu.orig_system_id old_orig_system_id,
378: decode(nvl(fu.employee_id, -1),-1,'FND_USR','PER') new_orig_system,
379: nvl(fu.employee_id, fu.user_id)

Line 380: from wf_local_roles partition (FND_USR) wu, fnd_user fu

376: select wu.rowid, wu.orig_system old_orig_system,
377: wu.orig_system_id old_orig_system_id,
378: decode(nvl(fu.employee_id, -1),-1,'FND_USR','PER') new_orig_system,
379: nvl(fu.employee_id, fu.user_id)
380: from wf_local_roles partition (FND_USR) wu, fnd_user fu
381: where wu.name = fu.user_name
382: and (wu.orig_system <> decode(nvl(fu.employee_id, -1),-1,'FND_USR','PER')
383: or wu.orig_system_id <> nvl(fu.employee_id, fu.user_id));
384:

Line 649: open c_invalid_fnd_users;

645: <>
646: loop
647: --Clear the l_rowIDTAB before the next iteration
648: l_rowIDTAB.DELETE;
649: open c_invalid_fnd_users;
650: fetch c_invalid_fnd_users bulk collect into l_rowIDTAB, l_userOrigSrcTAB,
651: l_userOrigIDSrcTAB, l_userOrigDestTAB, l_userOrigIDDestTAB
652: limit l_maxRows;
653: close c_invalid_fnd_users;

Line 650: fetch c_invalid_fnd_users bulk collect into l_rowIDTAB, l_userOrigSrcTAB,

646: loop
647: --Clear the l_rowIDTAB before the next iteration
648: l_rowIDTAB.DELETE;
649: open c_invalid_fnd_users;
650: fetch c_invalid_fnd_users bulk collect into l_rowIDTAB, l_userOrigSrcTAB,
651: l_userOrigIDSrcTAB, l_userOrigDestTAB, l_userOrigIDDestTAB
652: limit l_maxRows;
653: close c_invalid_fnd_users;
654:

Line 653: close c_invalid_fnd_users;

649: open c_invalid_fnd_users;
650: fetch c_invalid_fnd_users bulk collect into l_rowIDTAB, l_userOrigSrcTAB,
651: l_userOrigIDSrcTAB, l_userOrigDestTAB, l_userOrigIDDestTAB
652: limit l_maxRows;
653: close c_invalid_fnd_users;
654:
655: if (l_rowIDTAB.count > 0) then
656: begin
657: forall i in l_rowIDTAB.FIRST..l_rowIDTAB.LAST save exceptions

Line 679: if c_invalid_fnd_users%ISOPEN then

675: end if;
676: end loop fnd_usr_loop;
677: exception
678: when others then
679: if c_invalid_fnd_users%ISOPEN then
680: close c_invalid_fnd_users;
681: end if;
682: raise;
683: end; --End of duplicate/invalid FND_USR/PER user correction.

Line 680: close c_invalid_fnd_users;

676: end loop fnd_usr_loop;
677: exception
678: when others then
679: if c_invalid_fnd_users%ISOPEN then
680: close c_invalid_fnd_users;
681: end if;
682: raise;
683: end; --End of duplicate/invalid FND_USR/PER user correction.
684: