[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: --
101: p_rec.start_date := p_validation_start_date;
102: p_rec.end_date := p_validation_end_date;
103: End If;
104: --
105: hr_utility.set_location(' Leaving:'||l_proc, 15);
106: Exception
107: When hr_api.check_integrity_violated Then
108: -- A check constraint has been violated
109: --
160: --
161: l_proc varchar2(72) := g_package||'update_dml';
162: --
163: Begin
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: --
166: ame_apu_upd.dt_update_dml
167: (p_rec => p_rec
168: ,p_effective_date => p_effective_date
170: ,p_validation_start_date => p_validation_start_date
171: ,p_validation_end_date => p_validation_end_date
172: );
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 10);
175: End update_dml;
176: --
177: -- ----------------------------------------------------------------------------
178: -- |----------------------------< dt_pre_update >-----------------------------|
228: l_proc varchar2(72) := g_package||'dt_pre_update';
229: l_dummy_version_number number;
230: --
231: Begin
232: hr_utility.set_location('Entering:'||l_proc, 5);
233: If (p_datetrack_mode <> hr_api.g_correction) then
234: --
235: -- Update the current effective end date
236: --
267: ,p_validation_start_date => p_validation_start_date
268: ,p_validation_end_date => p_validation_end_date
269: );
270: End If;
271: hr_utility.set_location(' Leaving:'||l_proc, 20);
272: End dt_pre_update;
273: --
274: -- ----------------------------------------------------------------------------
275: -- |------------------------------< pre_update >------------------------------|
313: --
314: l_proc varchar2(72) := g_package||'pre_update';
315: --
316: Begin
317: hr_utility.set_location('Entering:'||l_proc, 5);
318: --
319: --
320: --
321: dt_pre_update
325: ,p_validation_start_date => p_validation_start_date
326: ,p_validation_end_date => p_validation_end_date
327: );
328: --
329: hr_utility.set_location(' Leaving:'||l_proc, 10);
330: End pre_update;
331: --
332: -- ----------------------------------------------------------------------------
333: -- |----------------------------< post_update >-------------------------------|
371: --
372: l_proc varchar2(72) := g_package||'post_update';
373: --
374: Begin
375: hr_utility.set_location('Entering:'||l_proc, 5);
376: begin
377: --
378: ame_apu_rku.after_update
379: (p_effective_date
411: ,p_hook_type => 'AU');
412: --
413: end;
414: --
415: hr_utility.set_location(' Leaving:'||l_proc, 10);
416: End post_update;
417: --
418: -- ----------------------------------------------------------------------------
419: -- |-----------------------------< convert_defs >-----------------------------|
486: l_validation_start_date date;
487: l_validation_end_date date;
488: --
489: Begin
490: hr_utility.set_location('Entering:'||l_proc, 5);
491: --
492: -- Ensure that the DateTrack update mode is valid
493: --
494: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
574: l_rec ame_apu_shd.g_rec_type;
575: l_proc varchar2(72) := g_package||'upd';
576: --
577: Begin
578: hr_utility.set_location('Entering:'||l_proc, 5);
579: --
580: -- Call conversion function to turn arguments into the
581: -- l_rec structure.
582: --
605: p_start_date := l_rec.start_date;
606: p_end_date := l_rec.end_date;
607: --
608: --
609: hr_utility.set_location(' Leaving:'||l_proc, 10);
610: End upd;
611: --
612: end ame_apu_upd;