DBA Data[Home] [Help]

APPS.HR_WORKFLOWS_PKG dependencies on HR_WORKFLOWS_S

Line 141: update HR_WORKFLOWS set

137: X_WORKFLOW_NAME in VARCHAR2,
138: X_LEGISLATION_CODE in VARCHAR2
139: ) is
140: begin
141: update HR_WORKFLOWS set
142: WORKFLOW_NAME = X_WORKFLOW_NAME,
143: LEGISLATION_CODE = X_LEGISLATION_CODE
144: where WORKFLOW_ID = X_WORKFLOW_ID;
145:

Line 244: select HR_WORKFLOWS_S.NEXTVAL

240: where WORKFLOW_NAME=X_WORKFLOW_NAME;
241:
242: exception
243: when no_data_found then
244: select HR_WORKFLOWS_S.NEXTVAL
245: into X_WORKFLOW_ID
246: from DUAL;
247: end;
248: