APPS.HR_WORKFLOWS_PKG dependencies on HR_WORKFLOWS_S
Line 103: update HR_WORKFLOWS set
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:
Line 183: select HR_WORKFLOWS_S.NEXTVAL
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: