DBA Data[Home] [Help]

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: