121: SELECT max(LOCATION_PROFILE_ID) INTO l_max_profile_id
122: FROM HZ_LOCATION_PROFILES;
123: WHILE l_temp_profile_id <= l_max_profile_id LOOP
124: SELECT HZ_LOCATION_PROFILES_S.NEXTVAL
125: INTO l_temp_profile_id FROM dual;
126: END LOOP;
127: END;
128:
129: ELSE