[Home] [Help]
90: X_NAME in VARCHAR2,
91: X_CUSTOMIZED_RESTRICTION_ID in NUMBER
92: ) is
93: begin
94: update HR_NAVIGATION_NODES set
95: NAV_UNIT_ID = X_NAV_UNIT_ID,
96: NAME = X_NAME,
97: CUSTOMIZED_RESTRICTION_ID = X_CUSTOMIZED_RESTRICTION_ID
98: where NAV_NODE_ID = X_NAV_NODE_ID;
236: );
237: END IF;
238: exception
239: when no_data_found then
240: select HR_NAVIGATION_NODES_S.NEXTVAL
241: into X_NAV_NODE_ID
242: from DUAL;
243:
244: INSERT_ROW(