90: OPEN C;
91: FETCH C INTO X_Rowid;
92: if (C%NOTFOUND) then
93: CLOSE C;
94: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
95: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
96: hr_utility.set_message_token('STEP','1');
97: hr_utility.raise_error;
98: end if;
91: FETCH C INTO X_Rowid;
92: if (C%NOTFOUND) then
93: CLOSE C;
94: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
95: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
96: hr_utility.set_message_token('STEP','1');
97: hr_utility.raise_error;
98: end if;
99: CLOSE C;
92: if (C%NOTFOUND) then
93: CLOSE C;
94: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
95: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
96: hr_utility.set_message_token('STEP','1');
97: hr_utility.raise_error;
98: end if;
99: CLOSE C;
100: END Insert_Row;
93: CLOSE C;
94: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
95: hr_utility.set_message_token('PROCEDURE','INSERT_ROW');
96: hr_utility.set_message_token('STEP','1');
97: hr_utility.raise_error;
98: end if;
99: CLOSE C;
100: END Insert_Row;
101:
127: OPEN C;
128: FETCH C INTO Recinfo;
129: if (C%NOTFOUND) then
130: CLOSE C;
131: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
132: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
133: hr_utility.set_message_token('STEP','1');
134: hr_utility.raise_error;
135: end if;
128: FETCH C INTO Recinfo;
129: if (C%NOTFOUND) then
130: CLOSE C;
131: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
132: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
133: hr_utility.set_message_token('STEP','1');
134: hr_utility.raise_error;
135: end if;
136: CLOSE C;
129: if (C%NOTFOUND) then
130: CLOSE C;
131: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
132: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
133: hr_utility.set_message_token('STEP','1');
134: hr_utility.raise_error;
135: end if;
136: CLOSE C;
137:
130: CLOSE C;
131: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
132: hr_utility.set_message_token('PROCEDURE','LOCK_ROW');
133: hr_utility.set_message_token('STEP','1');
134: hr_utility.raise_error;
135: end if;
136: CLOSE C;
137:
138: Recinfo.default_label := rtrim(Recinfo.default_label);
214: block_name = X_Block_Name
215: WHERE rowid = X_rowid;
216:
217: if (SQL%NOTFOUND) then
218: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
219: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
220: hr_utility.set_message_token('STEP','1');
221: hr_utility.raise_error;
222: end if;
215: WHERE rowid = X_rowid;
216:
217: if (SQL%NOTFOUND) then
218: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
219: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
220: hr_utility.set_message_token('STEP','1');
221: hr_utility.raise_error;
222: end if;
223:
216:
217: if (SQL%NOTFOUND) then
218: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
219: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
220: hr_utility.set_message_token('STEP','1');
221: hr_utility.raise_error;
222: end if;
223:
224: update HR_NAVIGATION_UNITS_TL
217: if (SQL%NOTFOUND) then
218: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
219: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
220: hr_utility.set_message_token('STEP','1');
221: hr_utility.raise_error;
222: end if;
223:
224: update HR_NAVIGATION_UNITS_TL
225: set
228: where NAV_UNIT_ID = X_NAV_UNIT_ID
229: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
230:
231: if (sql%notfound) then
232: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
234: hr_utility.set_message_token('STEP','1');
235: hr_utility.raise_error;
236: end if;
229: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
230:
231: if (sql%notfound) then
232: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
234: hr_utility.set_message_token('STEP','1');
235: hr_utility.raise_error;
236: end if;
237:
230:
231: if (sql%notfound) then
232: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
234: hr_utility.set_message_token('STEP','1');
235: hr_utility.raise_error;
236: end if;
237:
238: END Update_Row;
231: if (sql%notfound) then
232: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
233: hr_utility.set_message_token('PROCEDURE','UPDATE_ROW');
234: hr_utility.set_message_token('STEP','1');
235: hr_utility.raise_error;
236: end if;
237:
238: END Update_Row;
239:
291: delete from HR_NAVIGATION_UNITS_TL
292: where NAV_UNIT_ID = X_NAV_UNIT_ID;
293:
294: if (sql%notfound) then
295: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
296: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
297: hr_utility.set_message_token('STEP','1');
298: hr_utility.raise_error;
299: end if;
292: where NAV_UNIT_ID = X_NAV_UNIT_ID;
293:
294: if (sql%notfound) then
295: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
296: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
297: hr_utility.set_message_token('STEP','1');
298: hr_utility.raise_error;
299: end if;
300:
293:
294: if (sql%notfound) then
295: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
296: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
297: hr_utility.set_message_token('STEP','1');
298: hr_utility.raise_error;
299: end if;
300:
301: DELETE FROM HR_NAVIGATION_UNITS
294: if (sql%notfound) then
295: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
296: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
297: hr_utility.set_message_token('STEP','1');
298: hr_utility.raise_error;
299: end if;
300:
301: DELETE FROM HR_NAVIGATION_UNITS
302: WHERE rowid = X_Rowid;
301: DELETE FROM HR_NAVIGATION_UNITS
302: WHERE rowid = X_Rowid;
303:
304: if (SQL%NOTFOUND) then
305: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
306: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
307: hr_utility.set_message_token('STEP','1');
308: hr_utility.raise_error;
309: end if;
302: WHERE rowid = X_Rowid;
303:
304: if (SQL%NOTFOUND) then
305: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
306: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
307: hr_utility.set_message_token('STEP','1');
308: hr_utility.raise_error;
309: end if;
310: END Delete_Row;
303:
304: if (SQL%NOTFOUND) then
305: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
306: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
307: hr_utility.set_message_token('STEP','1');
308: hr_utility.raise_error;
309: end if;
310: END Delete_Row;
311:
304: if (SQL%NOTFOUND) then
305: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
306: hr_utility.set_message_token('PROCEDURE','DELETE_ROW');
307: hr_utility.set_message_token('STEP','1');
308: hr_utility.raise_error;
309: end if;
310: END Delete_Row;
311:
312: procedure ADD_LANGUAGE