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: pay_rtt_rku.after_update
190: (p_run_type_id
212: ,p_hook_type => 'AU');
213: --
214: end;
215: --
216: hr_utility.set_location(' Leaving:'||l_proc, 10);
217: End post_update;
218: --
219: -- ----------------------------------------------------------------------------
220: -- |-----------------------------< convert_defs >-----------------------------|
294: --
295: l_proc varchar2(72) := g_package||'upd';
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: -- We must lock the row which we need to update.
301: --
302: pay_rtt_shd.lck
344: l_rec pay_rtt_shd.g_rec_type;
345: l_proc varchar2(72) := g_package||'upd';
346: --
347: Begin
348: hr_utility.set_location('Entering:'||l_proc, 5);
349: --
350: -- Call conversion function to turn arguments into the
351: -- l_rec structure.
352: --
367: (l_rec
368: );
369: --
370: --
371: hr_utility.set_location(' Leaving:'||l_proc, 10);
372: End upd;
373: --
374: -- ----------------------------------------------------------------------------
375: -- |------------------------------< upd_tl >----------------------------------|
393: --
394: l_proc varchar2(72) := g_package||'upd_tl';
395: --
396: Begin
397: hr_utility.set_location('Entering:'||l_proc,10);
398: --
399: -- Update the translated values for every matching row
400: -- setting SOURCE_LANG to the specified language.
401: --
408: ,p_shortname => p_shortname
409: );
410: end loop;
411: --
412: hr_utility.set_location(' Leaving:'||l_proc,20);
413: End upd_tl;
414: --
415: end pay_rtt_upd;