APPS.HR_WORKFLOWS_PKG dependencies on HR_WORKFLOWS

Line 1: package body HR_WORKFLOWS_PKG as

1: package body HR_WORKFLOWS_PKG as
2: /* $Header: hrdwflct.pkb 115.7 2004/05/28 02:58:20 adhunter noship $ */
3:
4: procedure CLEANUP_TASKFLOW_UPDATE (
5: X_WORKFLOW_ID in NUMBER

Line 51: cursor C is select ROWID from HR_WORKFLOWS

47: X_WORKFLOW_ID in NUMBER,
48: X_WORKFLOW_NAME in VARCHAR2,
49: X_LEGISLATION_CODE in VARCHAR2
50: ) is
51: cursor C is select ROWID from HR_WORKFLOWS
52: where WORKFLOW_ID = X_WORKFLOW_ID
53: ;
54: begin
55: insert into HR_WORKFLOWS (

Line 55: insert into HR_WORKFLOWS (

51: cursor C is select ROWID from HR_WORKFLOWS
52: where WORKFLOW_ID = X_WORKFLOW_ID
53: ;
54: begin
55: insert into HR_WORKFLOWS (
56: WORKFLOW_ID,
57: WORKFLOW_NAME,
58: LEGISLATION_CODE
59: )

Line 80: from HR_WORKFLOWS

76: ) is
77: cursor c1 is select
78: WORKFLOW_NAME,
79: LEGISLATION_CODE
80: from HR_WORKFLOWS
81: where WORKFLOW_ID = X_WORKFLOW_ID
82: for update of WORKFLOW_ID nowait;
83: begin
84: for tlinfo in c1 loop

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 117: delete from HR_WORKFLOWS

113: procedure DELETE_ROW (
114: X_WORKFLOW_ID in NUMBER
115: ) is
116: begin
117: delete from HR_WORKFLOWS
118: where WORKFLOW_ID = X_WORKFLOW_ID;
119:
120: if (sql%notfound) then
121: raise no_data_found;

Line 178: from HR_WORKFLOWS

174:
175: begin
176: select WORKFLOW_ID
177: into X_WORKFLOW_ID
178: from HR_WORKFLOWS
179: where WORKFLOW_NAME=X_WORKFLOW_NAME;
180:
181: exception
182: when no_data_found then

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:

Line 213: end HR_WORKFLOWS_PKG;

209: end if;
210:
211: end LOAD_ROW;
212:
213: end HR_WORKFLOWS_PKG;