APPS.PY_ROLLBACK_PKG dependencies on FF_ARCHIVE_ITEMS

Line 196: from ff_archive_items

192: c_indent constant varchar2(40) := 'py_rollback_pkg.remove_archive_items';
193: --
194: cursor architems (p_source number, p_archive_type varchar2) is
195: select archive_item_id
196: from ff_archive_items
197: where context1 = p_source
198: and nvl(archive_type, 'AAP') = p_archive_type;
199: --
200: begin

Line 209: delete from ff_archive_items

205: delete from ff_archive_item_contexts
206: where archive_item_id = arcrec.archive_item_id;
207: --
208: -- delete the archive items.
209: delete from ff_archive_items
210: where archive_item_id = arcrec.archive_item_id;
211: end loop;
212: end;
213: --