121: OPEN C;
122: FETCH C INTO X_Rowid;
123: if (C%NOTFOUND) then
124: CLOSE C;
125: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
126: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
127: hr_utility.set_message_token('STEP','1');
128: hr_utility.raise_error;
129: end if;
122: FETCH C INTO X_Rowid;
123: if (C%NOTFOUND) then
124: CLOSE C;
125: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
126: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
127: hr_utility.set_message_token('STEP','1');
128: hr_utility.raise_error;
129: end if;
130: CLOSE C;
123: if (C%NOTFOUND) then
124: CLOSE C;
125: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
126: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
127: hr_utility.set_message_token('STEP','1');
128: hr_utility.raise_error;
129: end if;
130: CLOSE C;
131: END Insert_Row;
124: CLOSE C;
125: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
126: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
127: hr_utility.set_message_token('STEP','1');
128: hr_utility.raise_error;
129: end if;
130: CLOSE C;
131: END Insert_Row;
132:
158: OPEN C;
159: FETCH C INTO Recinfo;
160: if (C%NOTFOUND) then
161: CLOSE C;
162: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
163: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
164: hr_utility.set_message_token('STEP','1');
165: hr_utility.raise_error;
166: end if;
159: FETCH C INTO Recinfo;
160: if (C%NOTFOUND) then
161: CLOSE C;
162: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
163: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
164: hr_utility.set_message_token('STEP','1');
165: hr_utility.raise_error;
166: end if;
167: CLOSE C;
160: if (C%NOTFOUND) then
161: CLOSE C;
162: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
163: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
164: hr_utility.set_message_token('STEP','1');
165: hr_utility.raise_error;
166: end if;
167: CLOSE C;
168:
161: CLOSE C;
162: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
163: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
164: hr_utility.set_message_token('STEP','1');
165: hr_utility.raise_error;
166: end if;
167: CLOSE C;
168:
169: Recinfo.default_label := rtrim(Recinfo.default_label);
245: block_name = X_Block_Name
246: WHERE rowid = X_rowid;
247:
248: if (SQL%NOTFOUND) then
249: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
250: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
251: hr_utility.set_message_token('STEP','1');
252: hr_utility.raise_error;
253: end if;
246: WHERE rowid = X_rowid;
247:
248: if (SQL%NOTFOUND) then
249: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
250: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
251: hr_utility.set_message_token('STEP','1');
252: hr_utility.raise_error;
253: end if;
254:
247:
248: if (SQL%NOTFOUND) then
249: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
250: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
251: hr_utility.set_message_token('STEP','1');
252: hr_utility.raise_error;
253: end if;
254:
255: update HR_NAVIGATION_UNITS_TL
248: if (SQL%NOTFOUND) then
249: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
250: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
251: hr_utility.set_message_token('STEP','1');
252: hr_utility.raise_error;
253: end if;
254:
255: update HR_NAVIGATION_UNITS_TL
256: set
259: where NAV_UNIT_ID = X_NAV_UNIT_ID
260: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
261:
262: if (sql%notfound) then
263: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
264: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
265: hr_utility.set_message_token('STEP','1');
266: hr_utility.raise_error;
267: end if;
260: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
261:
262: if (sql%notfound) then
263: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
264: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
265: hr_utility.set_message_token('STEP','1');
266: hr_utility.raise_error;
267: end if;
268:
261:
262: if (sql%notfound) then
263: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
264: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
265: hr_utility.set_message_token('STEP','1');
266: hr_utility.raise_error;
267: end if;
268:
269: END Update_Row;
262: if (sql%notfound) then
263: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
264: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
265: hr_utility.set_message_token('STEP','1');
266: hr_utility.raise_error;
267: end if;
268:
269: END Update_Row;
270:
323: delete from HR_NAVIGATION_UNITS_TL
324: where NAV_UNIT_ID = X_NAV_UNIT_ID;
325:
326: if (sql%notfound) then
327: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
328: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
329: hr_utility.set_message_token('STEP','1');
330: hr_utility.raise_error;
331: end if;
324: where NAV_UNIT_ID = X_NAV_UNIT_ID;
325:
326: if (sql%notfound) then
327: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
328: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
329: hr_utility.set_message_token('STEP','1');
330: hr_utility.raise_error;
331: end if;
332:
325:
326: if (sql%notfound) then
327: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
328: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
329: hr_utility.set_message_token('STEP','1');
330: hr_utility.raise_error;
331: end if;
332:
333: --
326: if (sql%notfound) then
327: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
328: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
329: hr_utility.set_message_token('STEP','1');
330: hr_utility.raise_error;
331: end if;
332:
333: --
334: -- Added the following code as a part of Zero Downtime Patching Project.
356: DELETE FROM HR_NAVIGATION_UNITS
357: WHERE rowid = X_Rowid;
358:
359: if (SQL%NOTFOUND) then
360: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
361: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
362: hr_utility.set_message_token('STEP','1');
363: hr_utility.raise_error;
364: end if;
357: WHERE rowid = X_Rowid;
358:
359: if (SQL%NOTFOUND) then
360: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
361: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
362: hr_utility.set_message_token('STEP','1');
363: hr_utility.raise_error;
364: end if;
365: END Delete_Row;
358:
359: if (SQL%NOTFOUND) then
360: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
361: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
362: hr_utility.set_message_token('STEP','1');
363: hr_utility.raise_error;
364: end if;
365: END Delete_Row;
366:
359: if (SQL%NOTFOUND) then
360: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
361: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
362: hr_utility.set_message_token('STEP','1');
363: hr_utility.raise_error;
364: end if;
365: END Delete_Row;
366:
367: procedure ADD_LANGUAGE