APPS.AME_UPDATE_USERNAME_PKG dependencies on WF_ROLES

Line 90: and aagi.parameter_name = 'wf_roles_name';

86: begin
87: update ame_approval_group_items aagi
88: set aagi.parameter = l_new_name
89: where aagi.parameter = l_old_name
90: and aagi.parameter_name = 'wf_roles_name';
91: if sql%found then
92: log_message('Migrated ' || sql%rowcount || ' rows successfully');
93: else
94: log_message('No Rows Migrated');

Line 109: and aagm.parameter_name = 'wf_roles_name';

105: begin
106: update ame_approval_group_members aagm
107: set aagm.parameter = l_new_name
108: where aagm.parameter = l_old_name
109: and aagm.parameter_name = 'wf_roles_name';
110: if sql%found then
111: log_message('Migrated ' || sql%rowcount || ' rows successfully');
112: else
113: log_message('No Rows Migrated');

Line 260: from wf_roles wr

256: from ame_calling_apps aca
257: where aca.application_id = ati.application_id)
258: and instrb(ati.parameter,l_new_name,1,1) = 1
259: and exists (select wr.name
260: from wf_roles wr
261: where wr.name = l_new_name
262: and wr.orig_system = 'FND_USR');
263: if sql%found then
264: log_message('Migrated ' || sql%rowcount || ' rows successfully');