[Home] [Help]
64: --
65: l_proc varchar2(72) := g_package||'dt_update_dml';
66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.
75: --
138: p_rec.start_date := p_validation_start_date;
139: p_rec.end_date := p_validation_end_date;
140: End If;
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 15);
143: Exception
144: When hr_api.check_integrity_violated Then
145: -- A check constraint has been violated
146: --
197: --
198: l_proc varchar2(72) := g_package||'update_dml';
199: --
200: Begin
201: hr_utility.set_location('Entering:'||l_proc, 5);
202: --
203: irc_irf_upd.dt_update_dml
204: (p_rec => p_rec
205: ,p_effective_date => p_effective_date
207: ,p_validation_start_date => p_validation_start_date
208: ,p_validation_end_date => p_validation_end_date
209: );
210: --
211: hr_utility.set_location(' Leaving:'||l_proc, 10);
212: End update_dml;
213: --
214: -- ----------------------------------------------------------------------------
215: -- |----------------------------< dt_pre_update >-----------------------------|
265: l_proc varchar2(72) := g_package||'dt_pre_update';
266: l_dummy_version_number number;
267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: If (p_datetrack_mode <> hr_api.g_correction) then
271: --
272: -- Update the current effective end date
273: --
301: ,p_validation_start_date => p_validation_start_date
302: ,p_validation_end_date => p_validation_end_date
303: );
304: End If;
305: hr_utility.set_location(' Leaving:'||l_proc, 20);
306: End dt_pre_update;
307: --
308: -- ----------------------------------------------------------------------------
309: -- |------------------------------< pre_update >------------------------------|
347: --
348: l_proc varchar2(72) := g_package||'pre_update';
349: --
350: Begin
351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: --
354: --
355: dt_pre_update
359: ,p_validation_start_date => p_validation_start_date
360: ,p_validation_end_date => p_validation_end_date
361: );
362: --
363: hr_utility.set_location(' Leaving:'||l_proc, 10);
364: End pre_update;
365: --
366: -- ----------------------------------------------------------------------------
367: -- |----------------------------< post_update >-------------------------------|
405: --
406: l_proc varchar2(72) := g_package||'post_update';
407: --
408: Begin
409: hr_utility.set_location('Entering:'||l_proc, 5);
410: begin
411: --
412: irc_irf_rku.after_update
413: (p_effective_date => p_effective_date
510: ,p_hook_type => 'AU');
511: --
512: end;
513: --
514: hr_utility.set_location(' Leaving:'||l_proc, 10);
515: End post_update;
516: --
517: -- ----------------------------------------------------------------------------
518: -- |-----------------------------< convert_defs >-----------------------------|
752: l_validation_start_date date;
753: l_validation_end_date date;
754: --
755: Begin
756: hr_utility.set_location('Entering:'||l_proc, 5);
757: --
758: -- Ensure that the DateTrack update mode is valid
759: --
760: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
875: l_rec irc_irf_shd.g_rec_type;
876: l_proc varchar2(72) := g_package||'upd';
877: --
878: Begin
879: hr_utility.set_location('Entering:'||l_proc, 5);
880: --
881: -- Call conversion function to turn arguments into the
882: -- l_rec structure.
883: --
945: p_start_date := l_rec.start_date;
946: p_end_date := l_rec.end_date;
947: --
948: --
949: hr_utility.set_location(' Leaving:'||l_proc, 10);
950: End upd;
951: --
952: end irc_irf_upd;