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: --
75: and language = p_rec.language;
76: --
77: --
78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: --
81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
137: --
138: l_proc varchar2(72) := g_package||'pre_update';
139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_update;
145: --
139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_update;
145: --
146: -- ----------------------------------------------------------------------------
147: -- |-----------------------------< post_update >------------------------------|
181: --
182: l_proc varchar2(72) := g_package||'post_update';
183: --
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: End post_update;
189: --
183: --
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: End post_update;
189: --
190: -- ----------------------------------------------------------------------------
191: -- |-----------------------------< convert_defs >-----------------------------|
261: --
262: l_proc varchar2(72) := g_package||'upd';
263: --
264: Begin
265: hr_utility.set_location('Entering:'||l_proc, 5);
266: --
267: -- We must lock the row which we need to update.
268: --
269: pay_rft_shd.lck
316: l_rec pay_rft_shd.g_rec_type;
317: l_proc varchar2(72) := g_package||'upd';
318: --
319: Begin
320: hr_utility.set_location('Entering:'||l_proc, 5);
321: --
322: -- Call conversion function to turn arguments into the
323: -- l_rec structure.
324: --
338: (l_rec
339: );
340: --
341: --
342: hr_utility.set_location(' Leaving:'||l_proc, 10);
343: End upd;
344: --
345: -- ----------------------------------------------------------------------------
346: -- |------------------------------< upd_tl >----------------------------------|
363: --
364: l_proc varchar2(72) := g_package||'upd_tl';
365: --
366: Begin
367: hr_utility.set_location('Entering:'||l_proc,10);
368: --
369: -- Update the translated values for every matching row
370: -- setting SOURCE_LANG to the specified language.
371: --
377: ,p_display_name => p_display_name
378: );
379: end loop;
380: --
381: hr_utility.set_location(' Leaving:'||l_proc,20);
382: End upd_tl;
383: --
384: end pay_rft_upd;