355: BEGIN
356: l_count := 1;
357: WHILE l_count > 0 LOOP
358: SELECT HZ_GEOGRAPHIES_S.NEXTVAL
359: INTO x_geography_id FROM dual;
360: BEGIN
361: SELECT 'Y' INTO l_dummy
362: FROM HZ_GEOGRAPHIES
363: WHERE geography_id = x_geography_id;