APPS.PY_ROLLBACK_PKG dependencies on FF_ARCHIVE_ITEMS

Line 191: from ff_archive_items

187: c_indent constant varchar2(40) := 'py_rollback_pkg.remove_archive_items';
188: --
189: cursor architems (p_source number, p_archive_type varchar2) is
190: select archive_item_id
191: from ff_archive_items
192: where context1 = p_source
193: and nvl(archive_type, 'AAP') = p_archive_type;
194: --
195: begin

Line 204: delete from ff_archive_items

200: delete from ff_archive_item_contexts
201: where archive_item_id = arcrec.archive_item_id;
202: --
203: -- delete the archive items.
204: delete from ff_archive_items
205: where archive_item_id = arcrec.archive_item_id;
206: end loop;
207: end;
208: --