[Home] [Help]
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 >------------------------------|
183: --
184: l_proc varchar2(72) := g_package||'post_update';
185: --
186: Begin
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: begin
189: --
190: ota_srt_rku.after_update
191: (p_effective_date => p_effective_date
216: ,p_hook_type => 'AU');
217: --
218: end;
219: --
220: hr_utility.set_location(' Leaving:'||l_proc, 10);
221: End post_update;
222: --
223: -- ----------------------------------------------------------------------------
224: -- |-----------------------------< 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: ota_srt_shd.lck
358: l_rec ota_srt_shd.g_rec_type;
359: l_proc varchar2(72) := g_package||'upd';
360: --
361: Begin
362: hr_utility.set_location('Entering:'||l_proc, 5);
363: --
364: -- Call conversion function to turn arguments into the
365: -- l_rec structure.
366: --
382: ,l_rec
383: );
384: --
385: --
386: hr_utility.set_location(' Leaving:'||l_proc, 10);
387: End upd;
388: --
389: -- ----------------------------------------------------------------------------
390: -- |------------------------------< upd_tl >----------------------------------|
409: --
410: l_proc varchar2(72) := g_package||'upd_tl';
411: --
412: Begin
413: hr_utility.set_location('Entering:'||l_proc,10);
414: --
415: -- Update the translated values for every matching row
416: -- setting SOURCE_LANG to the specified language.
417: --
427: end loop;
428: --
429: upd_key_flex_meanings(p_supplied_resource_id);
430: --
431: hr_utility.set_location(' Leaving:'||l_proc,20);
432: End upd_tl;
433: --
434: -- ----------------------------------------------------------------------------
435: -- |------------------------------< upd_key_flex_meanings >-------------------|
462: l_proc varchar2(72) := g_package||'upd_key_flex_meanings';
463: --
464: Begin
465: --
466: hr_utility.set_location('Entering:'||l_proc, 5);
467: --
468: For l_language IN csr_languages Loop
469: --
470: -- Lock the existing record (which may already be updated)
498: -- Set the session language
499: --
500: ota_mls_utility.set_session_language_code( l_userenv_language_code );
501: --
502: hr_utility.set_location(' Leaving:'||l_proc,20);
503: --
504: Exception
505: --
506: When Others Then