[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: --
105: p_rec.start_date := p_validation_start_date;
106: p_rec.end_date := p_validation_end_date;
107: End If;
108: --
109: hr_utility.set_location(' Leaving:'||l_proc, 15);
110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: --
164: --
165: l_proc varchar2(72) := g_package||'update_dml';
166: --
167: Begin
168: hr_utility.set_location('Entering:'||l_proc, 5);
169: --
170: ame_atr_upd.dt_update_dml
171: (p_rec => p_rec
172: ,p_effective_date => p_effective_date
174: ,p_validation_start_date => p_validation_start_date
175: ,p_validation_end_date => p_validation_end_date
176: );
177: --
178: hr_utility.set_location(' Leaving:'||l_proc, 10);
179: End update_dml;
180: --
181: -- ----------------------------------------------------------------------------
182: -- |----------------------------< dt_pre_update >-----------------------------|
232: l_proc varchar2(72) := g_package||'dt_pre_update';
233: l_dummy_version_number number;
234: --
235: Begin
236: hr_utility.set_location('Entering:'||l_proc, 5);
237: If (p_datetrack_mode <> hr_api.g_correction) then
238: --
239: -- Update the current effective end date
240: --
268: ,p_validation_start_date => p_validation_start_date
269: ,p_validation_end_date => p_validation_end_date
270: );
271: End If;
272: hr_utility.set_location(' Leaving:'||l_proc, 20);
273: End dt_pre_update;
274: --
275: -- ----------------------------------------------------------------------------
276: -- |------------------------------< pre_update >------------------------------|
314: --
315: l_proc varchar2(72) := g_package||'pre_update';
316: --
317: Begin
318: hr_utility.set_location('Entering:'||l_proc, 5);
319: --
320: --
321: --
322: dt_pre_update
326: ,p_validation_start_date => p_validation_start_date
327: ,p_validation_end_date => p_validation_end_date
328: );
329: --
330: hr_utility.set_location(' Leaving:'||l_proc, 10);
331: End pre_update;
332: --
333: -- ----------------------------------------------------------------------------
334: -- |----------------------------< post_update >-------------------------------|
372: --
373: l_proc varchar2(72) := g_package||'post_update';
374: --
375: Begin
376: hr_utility.set_location('Entering:'||l_proc, 5);
377: begin
378: --
379: ame_atr_rku.after_update
380: (p_effective_date
438: ,p_hook_type => 'AU');
439: --
440: end;
441: --
442: hr_utility.set_location(' Leaving:'||l_proc, 10);
443: End post_update;
444: --
445: -- ----------------------------------------------------------------------------
446: -- |-----------------------------< convert_defs >-----------------------------|
540: l_validation_start_date date;
541: l_validation_end_date date;
542: --
543: Begin
544: hr_utility.set_location('Entering:'||l_proc, 5);
545: --
546: -- Ensure that the DateTrack update mode is valid
547: --
548: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
633: l_rec ame_atr_shd.g_rec_type;
634: l_proc varchar2(72) := g_package||'upd';
635: --
636: Begin
637: hr_utility.set_location('Entering:'||l_proc, 5);
638: --
639: -- Call conversion function to turn arguments into the
640: -- l_rec structure.
641: --
670: p_start_date := l_rec.start_date;
671: p_end_date := l_rec.end_date;
672: --
673: --
674: hr_utility.set_location(' Leaving:'||l_proc, 10);
675: End upd;
676: --
677: end ame_atr_upd;