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 120.1 2011/04/28 12:02:15 sidsaxen ship $ */
3:
4: PROCEDURE Cleanup_taskflow_update (x_workflow_id IN NUMBER)
5: IS

Line 88: cursor C is select ROWID from HR_WORKFLOWS

84: X_WORKFLOW_ID in NUMBER,
85: X_WORKFLOW_NAME in VARCHAR2,
86: X_LEGISLATION_CODE in VARCHAR2
87: ) is
88: cursor C is select ROWID from HR_WORKFLOWS
89: where WORKFLOW_ID = X_WORKFLOW_ID
90: ;
91: begin
92:

Line 93: insert into HR_WORKFLOWS (

89: where WORKFLOW_ID = X_WORKFLOW_ID
90: ;
91: begin
92:
93: insert into HR_WORKFLOWS (
94: WORKFLOW_ID,
95: WORKFLOW_NAME,
96: LEGISLATION_CODE
97: )

Line 118: from HR_WORKFLOWS

114: ) is
115: cursor c1 is select
116: WORKFLOW_NAME,
117: LEGISLATION_CODE
118: from HR_WORKFLOWS
119: where WORKFLOW_ID = X_WORKFLOW_ID
120: for update of WORKFLOW_ID nowait;
121: begin
122: for tlinfo in c1 loop

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 164: p_entity_name => 'HR_WORKFLOWS',

160:
161: BEGIN
162:
163: PER_RIC_PKG.chk_integrity (
164: p_entity_name => 'HR_WORKFLOWS',
165: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
166: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_UNITS', PER_RIC_PKG.column_info_tbl(
167: PER_RIC_PKG.col_info_rec('DEFAULT_WORKFLOW_ID',NULL,X_WORKFLOW_ID,NULL))),
168: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(

Line 178: delete from HR_WORKFLOWS

174: --
175: -- Code Ends Here
176: --
177:
178: delete from HR_WORKFLOWS
179: where WORKFLOW_ID = X_WORKFLOW_ID;
180:
181: if (sql%notfound) then
182: raise no_data_found;

Line 239: from HR_WORKFLOWS

235:
236: begin
237: select WORKFLOW_ID
238: into X_WORKFLOW_ID
239: from HR_WORKFLOWS
240: where WORKFLOW_NAME=X_WORKFLOW_NAME;
241:
242: exception
243: when no_data_found then

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:

Line 274: end HR_WORKFLOWS_PKG;

270: end if;
271:
272: end LOAD_ROW;
273:
274: end HR_WORKFLOWS_PKG;