[Home] [Help]
93: X_IN_OR_OUT in VARCHAR2,
94: X_MANDATORY_FLAG in VARCHAR2
95: ) is
96: begin
97: update HR_NAV_UNIT_GLOBAL_USAGES set
98: NAV_UNIT_ID = X_NAV_UNIT_ID,
99: GLOBAL_NAME = X_GLOBAL_NAME,
100: IN_OR_OUT = X_IN_OR_OUT,
101: MANDATORY_FLAG = X_MANDATORY_FLAG
185: END IF;
186:
187: exception
188: when no_data_found then
189: select HR_NAV_UNIT_GLOBAL_USAGES_S.NEXTVAL
190: into X_GLOBAL_USAGE_ID
191: from DUAL;
192:
193: INSERT_ROW(