DBA Data[Home] [Help]

APPS.FA_MAINT_PURGE_PKG dependencies on FA_MAINT_EVENTS

Line 129: from fa_maint_events me,

125: prog_failed exception;
126:
127: /* cursor for assets_to_purge is
128: select me.schedule_id
129: from fa_maint_events me,
130: fa_additions ad
131: where ad.asset_number >= nvl(h_from_asset_number,ad.asset_number) and
132: ad.asset_number <= nvl(h_to_asset_number,ad.asset_number) and
133: ad.category_id = nvl(h_category_id,ad.category_id) and

Line 237: delete from fa_maint_events me

233: h_mesg_name := 'FA_SHARED_DELETE_FAILED';
234: savepoint asset_maint;
235: savepoint_set := TRUE;
236:
237: delete from fa_maint_events me
238: where me.book_type_code = nvl(h_book_type_code,me.book_type_code) and
239: me.status = nvl(h_status, me.status) and
240: me.maintenance_date between nvl(h_from_date,me.maintenance_date) and
241: nvl(h_to_date,me.maintenance_date) and

Line 276: fnd_message.set_token('TABLE','FA_MAINT_EVENTS',FALSE);

272: if (savepoint_set) then
273: rollback to savepoint asset_maint;
274: end if;
275: fnd_message.set_name('OFA',h_mesg_name);
276: fnd_message.set_token('TABLE','FA_MAINT_EVENTS',FALSE);
277: h_mesg_str := fnd_message.get;
278: fa_rx_conc_mesg_pkg.log(h_mesg_str);
279: fa_rx_conc_mesg_pkg.log('');
280: