[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: --
133: p_rec.effective_start_date := p_validation_start_date;
134: p_rec.effective_end_date := p_validation_end_date;
135: End If;
136: --
137: hr_utility.set_location(' Leaving:'||l_proc, 15);
138: Exception
139: When hr_api.check_integrity_violated Then
140: -- A check constraint has been violated
141: --
192: --
193: l_proc varchar2(72) := g_package||'update_dml';
194: --
195: Begin
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: --
198: pay_prt_upd.dt_update_dml
199: (p_rec => p_rec
200: ,p_effective_date => p_effective_date
202: ,p_validation_start_date => p_validation_start_date
203: ,p_validation_end_date => p_validation_end_date
204: );
205: --
206: hr_utility.set_location(' Leaving:'||l_proc, 10);
207: End update_dml;
208: --
209: -- ----------------------------------------------------------------------------
210: -- |----------------------------< dt_pre_update >-----------------------------|
260: l_proc varchar2(72) := g_package||'dt_pre_update';
261: l_dummy_version_number number;
262: --
263: Begin
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: If (p_datetrack_mode <> hr_api.g_correction) then
266: --
267: -- Update the current effective end date
268: --
298: ,p_validation_start_date => p_validation_start_date
299: ,p_validation_end_date => p_validation_end_date
300: );
301: End If;
302: hr_utility.set_location(' Leaving:'||l_proc, 20);
303: End dt_pre_update;
304: --
305: -- ----------------------------------------------------------------------------
306: -- |------------------------------< pre_update >------------------------------|
345: --
346: l_proc varchar2(72) := g_package||'pre_update';
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);
350: --
351: --
352: --
353: dt_pre_update
357: ,p_validation_start_date => p_validation_start_date
358: ,p_validation_end_date => p_validation_end_date
359: );
360: --
361: hr_utility.set_location(' Leaving:'||l_proc, 10);
362: End pre_update;
363: --
364: -- ----------------------------------------------------------------------------
365: -- |----------------------------< post_update >-------------------------------|
403: --
404: l_proc varchar2(72) := g_package||'post_update';
405: --
406: Begin
407: hr_utility.set_location('Entering:'||l_proc, 5);
408: begin
409: --
410: pay_prt_rku.after_update
411: (p_effective_date
583: ,p_hook_type => 'AU');
584: --
585: end;
586: --
587: hr_utility.set_location(' Leaving:'||l_proc, 10);
588: End post_update;
589: --
590: -- ----------------------------------------------------------------------------
591: -- |-----------------------------< convert_defs >-----------------------------|
805: l_validation_start_date date;
806: l_validation_end_date date;
807: --
808: Begin
809: hr_utility.set_location('Entering:'||l_proc, 5);
810: --
811: -- Ensure that the DateTrack update mode is valid
812: --
813: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
919: l_rec pay_prt_shd.g_rec_type;
920: l_proc varchar2(72) := g_package||'upd';
921: --
922: Begin
923: hr_utility.set_location('Entering:'||l_proc, 5);
924: --
925: -- Call conversion function to turn arguments into the
926: -- l_rec structure.
927: --
986: p_effective_start_date := l_rec.effective_start_date;
987: p_effective_end_date := l_rec.effective_end_date;
988: --
989: --
990: hr_utility.set_location(' Leaving:'||l_proc, 10);
991: End upd;
992: --
993: end pay_prt_upd;