Line 271: select EGO_CATG_MAPS_S.nextval into l_catg_map_id from dual;
267: OPEN get_catg_map_id(l_source_catg_set_id, l_target_catg_set_id);
268: -- if it doesn't exist, inserting in to the ego_catg_map_header table
269: FETCH get_catg_map_id INTO l_catg_map_id;
270: if (get_catg_map_id%NOTFOUND) THEN 271: select EGO_CATG_MAPS_S.nextval into l_catg_map_id from dual; 272:
273: INSERT INTO EGO_CATG_MAP_HDRS_B
274: (
275: CATG_MAP_ID,