[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: --
135: p_rec.effective_start_date := p_validation_start_date;
136: p_rec.effective_end_date := p_validation_end_date;
137: End If;
138: --
139: hr_utility.set_location(' Leaving:'||l_proc, 15);
140: Exception
141: When hr_api.check_integrity_violated Then
142: -- A check constraint has been violated
143: --
194: --
195: l_proc varchar2(72) := g_package||'update_dml';
196: --
197: Begin
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: --
200: pay_pbc_upd.dt_update_dml
201: (p_rec => p_rec
202: ,p_effective_date => p_effective_date
204: ,p_validation_start_date => p_validation_start_date
205: ,p_validation_end_date => p_validation_end_date
206: );
207: --
208: hr_utility.set_location(' Leaving:'||l_proc, 10);
209: End update_dml;
210: --
211: -- ----------------------------------------------------------------------------
212: -- |----------------------------< dt_pre_update >-----------------------------|
262: l_proc varchar2(72) := g_package||'dt_pre_update';
263: l_dummy_version_number number;
264: --
265: Begin
266: hr_utility.set_location('Entering:'||l_proc, 5);
267: If (p_datetrack_mode <> hr_api.g_correction) then
268: --
269: -- Update the current effective end date
270: --
300: ,p_validation_start_date => p_validation_start_date
301: ,p_validation_end_date => p_validation_end_date
302: );
303: End If;
304: hr_utility.set_location(' Leaving:'||l_proc, 20);
305: End dt_pre_update;
306: --
307: -- ----------------------------------------------------------------------------
308: -- |------------------------------< 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: pay_pbc_rku.after_update
412: (p_effective_date => p_effective_date
502: ,p_hook_type => 'AU');
503: --
504: end;
505: --
506: hr_utility.set_location(' Leaving:'||l_proc, 10);
507: End post_update;
508: --
509: -- ----------------------------------------------------------------------------
510: -- |-----------------------------< convert_defs >-----------------------------|
720: l_validation_start_date date;
721: l_validation_end_date date;
722: --
723: Begin
724: hr_utility.set_location('Entering:'||l_proc, 5);
725: --
726: -- Ensure that the DateTrack update mode is valid
727: --
728: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
839: l_rec pay_pbc_shd.g_rec_type;
840: l_proc varchar2(72) := g_package||'upd';
841: --
842: Begin
843: hr_utility.set_location('Entering:'||l_proc, 5);
844: --
845: -- Call conversion function to turn arguments into the
846: -- l_rec structure.
847: --
905: p_effective_start_date := l_rec.effective_start_date;
906: p_effective_end_date := l_rec.effective_end_date;
907: --
908: --
909: hr_utility.set_location(' Leaving:'||l_proc, 10);
910: End upd;
911: --
912: end pay_pbc_upd;