APPS.WF_MAINTENANCE dependencies on WF_NOTIFICATIONS

Line 48: from WF_NOTIFICATIONS

44: where ASSIGNED_USER = l_oldname;
45:
46: cursor Notifications (l_oldname varchar2) is
47: select NOTIFICATION_ID
48: from WF_NOTIFICATIONS
49: where RECIPIENT_ROLE = l_oldname
50: or ORIGINAL_RECIPIENT = l_oldname
51: or more_info_role = l_oldname
52: or from_role = l_oldname

Line 159: update WF_NOTIFICATIONS

155: end loop;
156:
157: for NTF in Notifications (l_oldname) loop
158:
159: update WF_NOTIFICATIONS
160: set RECIPIENT_ROLE = l_newname
161: where NOTIFICATION_ID = ntf.notification_id
162: and RECIPIENT_ROLE = l_oldname;
163:

Line 164: update WF_NOTIFICATIONS

160: set RECIPIENT_ROLE = l_newname
161: where NOTIFICATION_ID = ntf.notification_id
162: and RECIPIENT_ROLE = l_oldname;
163:
164: update WF_NOTIFICATIONS
165: set ORIGINAL_RECIPIENT = l_newname
166: where NOTIFICATION_ID = ntf.notification_id
167: and ORIGINAL_RECIPIENT = l_oldname;
168:

Line 169: update WF_NOTIFICATIONS

165: set ORIGINAL_RECIPIENT = l_newname
166: where NOTIFICATION_ID = ntf.notification_id
167: and ORIGINAL_RECIPIENT = l_oldname;
168:
169: update WF_NOTIFICATIONS
170: set MORE_INFO_ROLE = l_newname
171: where NOTIFICATION_ID = ntf.notification_id
172: and MORE_INFO_ROLE = l_oldname;
173:

Line 174: update WF_NOTIFICATIONS

170: set MORE_INFO_ROLE = l_newname
171: where NOTIFICATION_ID = ntf.notification_id
172: and MORE_INFO_ROLE = l_oldname;
173:
174: update WF_NOTIFICATIONS
175: set FROM_ROLE = l_newname
176: where NOTIFICATION_ID = ntf.notification_id
177: and FROM_ROLE = l_oldname;
178:

Line 179: update WF_NOTIFICATIONS

175: set FROM_ROLE = l_newname
176: where NOTIFICATION_ID = ntf.notification_id
177: and FROM_ROLE = l_oldname;
178:
179: update WF_NOTIFICATIONS
180: set RESPONDER = l_newname
181: where NOTIFICATION_ID = ntf.notification_id
182: and RESPONDER = l_oldname;
183: