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: --
82: and language = p_rec.language;
83: --
84: --
85: --
86: hr_utility.set_location(' Leaving:'||l_proc, 10);
87: --
88: Exception
89: When hr_api.check_integrity_violated Then
90: -- A check constraint has been violated
144: --
145: l_proc varchar2(72) := g_package||'pre_update';
146: --
147: Begin
148: hr_utility.set_location('Entering:'||l_proc, 5);
149: --
150: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: End pre_update;
152: --
146: --
147: Begin
148: hr_utility.set_location('Entering:'||l_proc, 5);
149: --
150: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: End pre_update;
152: --
153: -- ----------------------------------------------------------------------------
154: -- |-----------------------------< post_update >------------------------------|
188: --
189: l_proc varchar2(72) := g_package||'post_update';
190: --
191: Begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: begin
194: --
195: per_qat_rku.after_update
196: (p_qualification_id
244: ,p_hook_type => 'AU');
245: --
246: end;
247: --
248: hr_utility.set_location(' Leaving:'||l_proc, 10);
249: End post_update;
250: --
251: -- ----------------------------------------------------------------------------
252: -- |-----------------------------< convert_defs >-----------------------------|
350: --
351: l_proc varchar2(72) := g_package||'upd';
352: --
353: Begin
354: hr_utility.set_location('Entering:'||l_proc, 5);
355: --
356: -- We must lock the row which we need to update.
357: --
358: per_qat_shd.lck
412: l_rec per_qat_shd.g_rec_type;
413: l_proc varchar2(72) := g_package||'upd';
414: --
415: Begin
416: hr_utility.set_location('Entering:'||l_proc, 5);
417: --
418: -- Call conversion function to turn arguments into the
419: -- l_rec structure.
420: --
441: (l_rec
442: );
443: --
444: --
445: hr_utility.set_location(' Leaving:'||l_proc, 10);
446: End upd;
447: --
448: -- ----------------------------------------------------------------------------
449: -- |------------------------------< upd_tl >----------------------------------|
473: --
474: l_proc varchar2(72) := g_package||'upd_tl';
475: --
476: Begin
477: hr_utility.set_location('Entering:'||l_proc,10);
478: --
479: -- Update the translated values for every matching row
480: -- setting SOURCE_LANG to the specified language.
481: --
494: ,p_membership_category => p_membership_category
495: );
496: end loop;
497: --
498: hr_utility.set_location(' Leaving:'||l_proc,20);
499: End upd_tl;
500: --
501: end per_qat_upd;