Line 2297: select Wip_purge_temp_s.nextval into x_group_id from dual;
2293: x_from_date date;
2294:
2295: begin
2296: -- generate a group ID 2297: select Wip_purge_temp_s.nextval into x_group_id from dual; 2298:
2299: -- find jobs
2300: if (p_purge_type in (PURGE_JOBS, PURGE_LOTBASED, PURGE_ALL)) then
2301: