176: l_count := 1;
177: WHILE l_count > 0 LOOP
178: SELECT hz_imp_batch_summary_s.NEXTVAL
179: INTO x_batch_id
180: FROM dual;
181:
182: BEGIN
183: SELECT 'Y'
184: INTO l_dummy