[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: --
134: p_rec.effective_start_date := p_validation_start_date;
135: p_rec.effective_end_date := p_validation_end_date;
136: End If;
137: --
138: hr_utility.set_location(' Leaving:'||l_proc, 15);
139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: ben_vep_shd.g_api_dml := false; -- Unset the api dml status
193: --
194: l_proc varchar2(72) := g_package||'update_dml';
195: --
196: Begin
197: hr_utility.set_location('Entering:'||l_proc, 5);
198: --
199: ben_vep_upd.dt_update_dml
200: (p_rec => p_rec
201: ,p_effective_date => p_effective_date
203: ,p_validation_start_date => p_validation_start_date
204: ,p_validation_end_date => p_validation_end_date
205: );
206: --
207: hr_utility.set_location(' Leaving:'||l_proc, 10);
208: End update_dml;
209: --
210: -- ----------------------------------------------------------------------------
211: -- |----------------------------< dt_pre_update >-----------------------------|
261: l_proc varchar2(72) := g_package||'dt_pre_update';
262: l_dummy_version_number number;
263: --
264: Begin
265: hr_utility.set_location('Entering:'||l_proc, 5);
266: If (p_datetrack_mode <> hr_api.g_correction) then
267: --
268: -- Update the current effective end date
269: --
299: ,p_validation_start_date => p_validation_start_date
300: ,p_validation_end_date => p_validation_end_date
301: );
302: End If;
303: hr_utility.set_location(' Leaving:'||l_proc, 20);
304: End dt_pre_update;
305: --
306: -- ----------------------------------------------------------------------------
307: -- |------------------------------< pre_update >------------------------------|
346: --
347: l_proc varchar2(72) := g_package||'pre_update';
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);
351: --
352: --
353: --
354: dt_pre_update
358: ,p_validation_start_date => p_validation_start_date
359: ,p_validation_end_date => p_validation_end_date
360: );
361: --
362: hr_utility.set_location(' Leaving:'||l_proc, 10);
363: End pre_update;
364: --
365: -- ----------------------------------------------------------------------------
366: -- |----------------------------< post_update >-------------------------------|
404: --
405: l_proc varchar2(72) := g_package||'post_update';
406: --
407: Begin
408: hr_utility.set_location('Entering:'||l_proc, 5);
409: begin
410: --
411: ben_vep_rku.after_update
412: (p_effective_date
582: ,p_hook_type => 'AU');
583: --
584: end;
585: --
586: hr_utility.set_location(' Leaving:'||l_proc, 10);
587: End post_update;
588: --
589: -- ----------------------------------------------------------------------------
590: -- |-----------------------------< convert_defs >-----------------------------|
796: l_validation_start_date date;
797: l_validation_end_date date;
798: --
799: Begin
800: hr_utility.set_location('Entering:'||l_proc, 5);
801: --
802: -- Ensure that the DateTrack update mode is valid
803: --
804: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
911: l_rec ben_vep_shd.g_rec_type;
912: l_proc varchar2(72) := g_package||'upd';
913: --
914: Begin
915: hr_utility.set_location('Entering:'||l_proc, 5);
916: --
917: -- Call conversion function to turn arguments into the
918: -- l_rec structure.
919: --
976: p_effective_start_date := l_rec.effective_start_date;
977: p_effective_end_date := l_rec.effective_end_date;
978: --
979: --
980: hr_utility.set_location(' Leaving:'||l_proc, 10);
981: End upd;
982: --
983: end ben_vep_upd;