149: X_LAST_UPDATED_BY in NUMBER,
150: X_LAST_UPDATE_LOGIN in NUMBER
151: ) is
152: begin
153: update FND_FLEX_HIERARCHIES set
154: HIERARCHY_CODE = X_HIERARCHY_CODE,
155: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
156: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
157: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
314: X_LAST_UPDATED_BY => x_who.last_updated_by,
315: X_LAST_UPDATE_LOGIN => x_who.last_update_login);
316: EXCEPTION
317: WHEN no_data_found THEN
318: SELECT fnd_flex_hierarchies_s.NEXTVAL
319: INTO l_hierarchy_id
320: FROM dual;
321:
322: fnd_flex_hierarchies_pkg.insert_row