APPS.PA_PURGE_BATCHES_PKG dependencies on PA_PURGE_PROJECTS

Line 160: -- pa_purge_projects table by calling the pa_purge_projects delete_row

156: raise ;
157: END update_row;
158:
159: -- The delete_row table handler cascades the delete to the
160: -- pa_purge_projects table by calling the pa_purge_projects delete_row
161: -- table handler.
162:
163: procedure delete_row (x_rowid in VARCHAR2) is
164: cursor get_batch is select batch_status_code,

Line 184: from pa_purge_projects

180: -- cascade delete to purge projects in the batch.
181: DECLARE
182: cursor purge_projects is
183: select rowid, project_id, last_project_status_code
184: from pa_purge_projects
185: where purge_batch_id = batches_rec.purge_batch_id
186: for update of project_id, purge_batch_id nowait;
187:
188: projects_rec purge_projects%rowtype;

Line 204: pa_purge_projects_pkg.delete_row ( projects_rec.rowid);

200: open project ;
201: if (purge_projects%notfound) then
202: exit;
203: else
204: pa_purge_projects_pkg.delete_row ( projects_rec.rowid);
205: end if;
206: close project ;
207: END LOOP;
208: