[Home] [Help]
99: X_WORKFLOW_NAME in VARCHAR2,
100: X_LEGISLATION_CODE in VARCHAR2
101: ) is
102: begin
103: update HR_WORKFLOWS set
104: WORKFLOW_NAME = X_WORKFLOW_NAME,
105: LEGISLATION_CODE = X_LEGISLATION_CODE
106: where WORKFLOW_ID = X_WORKFLOW_ID;
107:
179: where WORKFLOW_NAME=X_WORKFLOW_NAME;
180:
181: exception
182: when no_data_found then
183: select HR_WORKFLOWS_S.NEXTVAL
184: into X_WORKFLOW_ID
185: from DUAL;
186: end;
187: