DBA Data[Home] [Help]

APPS.EGO_CATG_MAP_PKG dependencies on DUAL

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,