57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
60: Begin
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: --
63: --
64: --
65: --
76: and language = p_rec.language;
77: --
78: --
79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: --
82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
138: --
139: l_proc varchar2(72) := g_package||'pre_update';
140: --
141: Begin
142: hr_utility.set_location('Entering:'||l_proc, 5);
143: --
144: hr_utility.set_location(' Leaving:'||l_proc, 10);
145: End pre_update;
146: --
140: --
141: Begin
142: hr_utility.set_location('Entering:'||l_proc, 5);
143: --
144: hr_utility.set_location(' Leaving:'||l_proc, 10);
145: End pre_update;
146: --
147: -- ----------------------------------------------------------------------------
148: -- |-----------------------------< post_update >------------------------------|
182: --
183: l_proc varchar2(72) := g_package||'post_update';
184: --
185: Begin
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: begin
188: --
189:
190: hr_itl_rku.after_update
217:
218:
219: end;
220: --
221: hr_utility.set_location(' Leaving:'||l_proc, 10);
222: End post_update;
223: --
224: -- ----------------------------------------------------------------------------
225: -- |-----------------------------< convert_defs >-----------------------------|
299: --
300: l_proc varchar2(72) := g_package||'upd';
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc, 5);
304: --
305: -- We must lock the row which we need to update.
306: --
307: hr_itl_shd.lck
356: l_rec hr_itl_shd.g_rec_type;
357: l_proc varchar2(72) := g_package||'upd';
358: --
359: Begin
360: hr_utility.set_location('Entering:'||l_proc, 5);
361: --
362: -- Call conversion function to turn arguments into the
363: -- l_rec structure.
364: --
379: (l_rec
380: );
381: --
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 10);
384: End upd;
385: --
386: -- ----------------------------------------------------------------------------
387: -- |------------------------------< upd_tl >----------------------------------|
405: --
406: l_proc varchar2(72) := g_package||'upd_tl';
407: --
408: Begin
409: hr_utility.set_location('Entering:'||l_proc,10);
410: --
411: -- Update the translated values for every matching row
412: -- setting SOURCE_LANG to the specified language.
413: --
420: ,p_service_name => p_service_name
421: );
422: end loop;
423: --
424: hr_utility.set_location(' Leaving:'||l_proc,20);
425: End upd_tl;
426: --
427: end hr_itl_upd;