Line 28: cursor get_id is select pa_purge_batches_s.nextval from dual ;
24: x_org_id in NUMBER) is
25:
26: cursor c is select rowid from pa_purge_batches
27: where purge_batch_id = x_purge_batch_id; 28: cursor get_id is select pa_purge_batches_s.nextval from dual ; 29: x_err_code NUMBER;
30: x_return_status VARCHAR2(630);
31: l_purge_batch_id NUMBER := x_purge_batch_id;
32: