[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: --
149: p_rec.effective_start_date := p_validation_start_date;
150: p_rec.effective_end_date := p_validation_end_date;
151: End If;
152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 15);
154: Exception
155: When hr_api.check_integrity_violated Then
156: -- A check constraint has been violated
157: --
208: --
209: l_proc varchar2(72) := g_package||'update_dml';
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: hr_cle_upd.dt_update_dml
215: (p_rec => p_rec
216: ,p_effective_date => p_effective_date
218: ,p_validation_start_date => p_validation_start_date
219: ,p_validation_end_date => p_validation_end_date
220: );
221: --
222: hr_utility.set_location(' Leaving:'||l_proc, 10);
223: End update_dml;
224: --
225: -- ----------------------------------------------------------------------------
226: -- |----------------------------< dt_pre_update >-----------------------------|
276: l_proc varchar2(72) := g_package||'dt_pre_update';
277: l_dummy_version_number number;
278: --
279: Begin
280: hr_utility.set_location('Entering:'||l_proc, 5);
281: If (p_datetrack_mode <> hr_api.g_correction) then
282: --
283: -- Update the current effective end date
284: --
314: ,p_validation_start_date => p_validation_start_date
315: ,p_validation_end_date => p_validation_end_date
316: );
317: End If;
318: hr_utility.set_location(' Leaving:'||l_proc, 20);
319: End dt_pre_update;
320: --
321: -- ----------------------------------------------------------------------------
322: -- |------------------------------< pre_update >------------------------------|
360: --
361: l_proc varchar2(72) := g_package||'pre_update';
362: --
363: Begin
364: hr_utility.set_location('Entering:'||l_proc, 5);
365: --
366: --
367: --
368: dt_pre_update
372: ,p_validation_start_date => p_validation_start_date
373: ,p_validation_end_date => p_validation_end_date
374: );
375: --
376: hr_utility.set_location(' Leaving:'||l_proc, 10);
377: End pre_update;
378: --
379: -- ----------------------------------------------------------------------------
380: -- |----------------------------< post_update >-------------------------------|
418: --
419: l_proc varchar2(72) := g_package||'post_update';
420: --
421: Begin
422: hr_utility.set_location('Entering:'||l_proc, 5);
423: begin
424: --
425: hr_cle_rku.after_update
426: (p_effective_date
656: ,p_hook_type => 'AU');
657: --
658: end;
659: --
660: hr_utility.set_location(' Leaving:'||l_proc, 10);
661: End post_update;
662: --
663: -- ----------------------------------------------------------------------------
664: -- |-----------------------------< convert_defs >-----------------------------|
931: l_validation_start_date date;
932: l_validation_end_date date;
933: --
934: Begin
935: hr_utility.set_location('Entering:'||l_proc, 5);
936: --
937: -- Ensure that the DateTrack update mode is valid
938: --
939: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
1061: l_rec hr_cle_shd.g_rec_type;
1062: l_proc varchar2(72) := g_package||'upd';
1063: --
1064: Begin
1065: hr_utility.set_location('Entering:'||l_proc, 5);
1066: --
1067: -- Call conversion function to turn arguments into the
1068: -- l_rec structure.
1069: --
1141: p_effective_start_date := l_rec.effective_start_date;
1142: p_effective_end_date := l_rec.effective_end_date;
1143: --
1144: --
1145: hr_utility.set_location(' Leaving:'||l_proc, 10);
1146: End upd;
1147: --
1148: end hr_cle_upd;