DBA Data[Home] [Help]

APPS.AME_UPDATE_USERNAME_PKG dependencies on AME_TEMP_INSERTIONS

Line 183: log_message('Migrating name field in ame_temp_insertions');

179: log_message(sqlerrm,sqlcode);
180: l_success := false;
181: end;
182:
183: log_message('Migrating name field in ame_temp_insertions');
184: begin
185: update ame_temp_insertions ati
186: set ati.name = l_new_name
187: where ati.name = l_old_name;

Line 185: update ame_temp_insertions ati

181: end;
182:
183: log_message('Migrating name field in ame_temp_insertions');
184: begin
185: update ame_temp_insertions ati
186: set ati.name = l_new_name
187: where ati.name = l_old_name;
188: if sql%found then
189: log_message('Migrated ' || sql%rowcount || ' rows successfully');

Line 219: log_message('Migrating parameter field in ame_temp_insertions');

215: log_message(sqlerrm,sqlcode);
216: l_success := false;
217: end;
218:
219: log_message('Migrating parameter field in ame_temp_insertions');
220: begin
221: update ame_temp_insertions ati
222: set ati.parameter = l_new_name ||
223: substrb(ati.parameter

Line 221: update ame_temp_insertions ati

217: end;
218:
219: log_message('Migrating parameter field in ame_temp_insertions');
220: begin
221: update ame_temp_insertions ati
222: set ati.parameter = l_new_name ||
223: substrb(ati.parameter
224: ,instrb(ati.parameter
225: ,fnd_global.local_chr(11)

Line 247: log_message('Migrating description field in ame_temp_insertions');

243: log_message(sqlerrm,sqlcode);
244: l_success := false;
245: end;
246:
247: log_message('Migrating description field in ame_temp_insertions');
248: begin
249: update ame_temp_insertions ati
250: set ati.description = decode(order_type
251: ,'after_approver'

Line 249: update ame_temp_insertions ati

245: end;
246:
247: log_message('Migrating description field in ame_temp_insertions');
248: begin
249: update ame_temp_insertions ati
250: set ati.description = decode(order_type
251: ,'after_approver'
252: ,'Always put the new approver right after the following approver: ' || l_new_name
253: ,'Always put the new approver right before the following approver: ' || l_new_name)