62: l_old_name := l_event.getValueForParameter('OLD_USER_NAME');
63:
64: log_message ('Old user name is ' || l_old_name);
65: log_message ('New user name is ' || l_new_name);
66: log_message ('Migrating variable_value field in ame_config_vars');
67: begin
68: update ame_config_vars acv
69: set acv.variable_value = l_new_name
70: where acv.variable_value = l_old_name
64: log_message ('Old user name is ' || l_old_name);
65: log_message ('New user name is ' || l_new_name);
66: log_message ('Migrating variable_value field in ame_config_vars');
67: begin
68: update ame_config_vars acv
69: set acv.variable_value = l_new_name
70: where acv.variable_value = l_old_name
71: and acv.variable_name = 'adminApprover';
72: if sql%found then
295:
296: begin
297: select variable_value
298: into admin_approver
299: from ame_config_vars
300: where sysdate between start_date and nvl(end_date - (1/86400),sysdate)
301: and variable_name = 'adminApprover'
302: and (application_id is null or application_id = 0)
303: and rownum < 2;
329: rollback;
330: begin
331: select variable_value
332: into admin_approver
333: from ame_config_vars
334: where sysdate between start_date and nvl(end_date - (1/86400),sysdate)
335: and variable_name = 'adminApprover'
336: and (application_id is null or application_id = 0)
337: and rownum < 2;