[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: --
95: p_rec.start_date := p_validation_start_date;
96: p_rec.end_date := p_validation_end_date;
97: End If;
98: --
99: hr_utility.set_location(' Leaving:'||l_proc, 15);
100: Exception
101: When hr_api.check_integrity_violated Then
102: -- A check constraint has been violated
103: --
154: --
155: l_proc varchar2(72) := g_package||'update_dml';
156: --
157: Begin
158: hr_utility.set_location('Entering:'||l_proc, 5);
159: --
160: ame_itc_upd.dt_update_dml
161: (p_rec => p_rec
162: ,p_effective_date => p_effective_date
164: ,p_validation_start_date => p_validation_start_date
165: ,p_validation_end_date => p_validation_end_date
166: );
167: --
168: hr_utility.set_location(' Leaving:'||l_proc, 10);
169: End update_dml;
170: --
171: -- ----------------------------------------------------------------------------
172: -- |----------------------------< dt_pre_update >-----------------------------|
222: l_proc varchar2(72) := g_package||'dt_pre_update';
223: l_dummy_version_number number;
224: --
225: Begin
226: hr_utility.set_location('Entering:'||l_proc, 5);
227: If (p_datetrack_mode <> hr_api.g_correction) then
228: --
229: -- Update the current effective end date
230: --
260: ,p_validation_start_date => p_validation_start_date
261: ,p_validation_end_date => p_validation_end_date
262: );
263: End If;
264: hr_utility.set_location(' Leaving:'||l_proc, 20);
265: End dt_pre_update;
266: --
267: -- ----------------------------------------------------------------------------
268: -- |------------------------------< pre_update >------------------------------|
306: --
307: l_proc varchar2(72) := g_package||'pre_update';
308: --
309: Begin
310: hr_utility.set_location('Entering:'||l_proc, 5);
311: --
312: --
313: --
314: dt_pre_update
318: ,p_validation_start_date => p_validation_start_date
319: ,p_validation_end_date => p_validation_end_date
320: );
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 10);
323: End pre_update;
324: --
325: -- ----------------------------------------------------------------------------
326: -- |----------------------------< post_update >-------------------------------|
364: --
365: l_proc varchar2(72) := g_package||'post_update';
366: --
367: Begin
368: hr_utility.set_location('Entering:'||l_proc, 5);
369: begin
370: --
371: ame_itc_rku.after_update
372: (p_effective_date => p_effective_date
393: ,p_hook_type => 'AU');
394: --
395: end;
396: --
397: hr_utility.set_location(' Leaving:'||l_proc, 10);
398: End post_update;
399: --
400: -- ----------------------------------------------------------------------------
401: -- |-----------------------------< convert_defs >-----------------------------|
471: l_validation_start_date date;
472: l_validation_end_date date;
473: --
474: Begin
475: hr_utility.set_location('Entering:'||l_proc, 5);
476: --
477: -- Ensure that the DateTrack update mode is valid
478: --
479: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
558: l_rec ame_itc_shd.g_rec_type;
559: l_proc varchar2(72) := g_package||'upd';
560: --
561: Begin
562: hr_utility.set_location('Entering:'||l_proc, 5);
563: --
564: -- Call conversion function to turn arguments into the
565: -- l_rec structure.
566: --
589: p_start_date := l_rec.start_date;
590: p_end_date := l_rec.end_date;
591: --
592: --
593: hr_utility.set_location(' Leaving:'||l_proc, 10);
594: End upd;
595: --
596: end ame_itc_upd;