[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: --
175: p_rec.effective_start_date := p_validation_start_date;
176: p_rec.effective_end_date := p_validation_end_date;
177: End If;
178: --
179: hr_utility.set_location(' Leaving:'||l_proc, 15);
180: Exception
181: When hr_api.check_integrity_violated Then
182: -- A check constraint has been violated
183: --
234: --
235: l_proc varchar2(72) := g_package||'update_dml';
236: --
237: Begin
238: hr_utility.set_location('Entering:'||l_proc, 5);
239: --
240: per_dis_upd.dt_update_dml
241: (p_rec => p_rec
242: ,p_effective_date => p_effective_date
244: ,p_validation_start_date => p_validation_start_date
245: ,p_validation_end_date => p_validation_end_date
246: );
247: --
248: hr_utility.set_location(' Leaving:'||l_proc, 10);
249: End update_dml;
250: --
251: -- ----------------------------------------------------------------------------
252: -- |----------------------------< dt_pre_update >-----------------------------|
302: l_proc varchar2(72) := g_package||'dt_pre_update';
303: l_dummy_version_number number;
304: --
305: Begin
306: hr_utility.set_location('Entering:'||l_proc, 5);
307: If (p_datetrack_mode <> hr_api.g_correction) then
308: --
309: -- Update the current effective end date
310: --
340: ,p_validation_start_date => p_validation_start_date
341: ,p_validation_end_date => p_validation_end_date
342: );
343: End If;
344: hr_utility.set_location(' Leaving:'||l_proc, 20);
345: End dt_pre_update;
346: --
347: -- ----------------------------------------------------------------------------
348: -- |------------------------------< pre_update >------------------------------|
387: --
388: l_proc varchar2(72) := g_package||'pre_update';
389: --
390: Begin
391: hr_utility.set_location('Entering:'||l_proc, 5);
392: --
393: --
394: --
395: dt_pre_update
399: ,p_validation_start_date => p_validation_start_date
400: ,p_validation_end_date => p_validation_end_date
401: );
402: --
403: hr_utility.set_location(' Leaving:'||l_proc, 10);
404: End pre_update;
405: --
406: -- ----------------------------------------------------------------------------
407: -- |----------------------------< post_update >-------------------------------|
445: --
446: l_proc varchar2(72) := g_package||'post_update';
447: --
448: Begin
449: hr_utility.set_location('Entering:'||l_proc, 5);
450: begin
451: --
452: per_dis_rku.after_update
453: (p_effective_date
785: ,p_hook_type => 'AU');
786: --
787: end;
788: --
789: hr_utility.set_location(' Leaving:'||l_proc, 10);
790: End post_update;
791: --
792: -- ----------------------------------------------------------------------------
793: -- |-----------------------------< convert_defs >-----------------------------|
1163: l_validation_start_date date;
1164: l_validation_end_date date;
1165: --
1166: Begin
1167: hr_utility.set_location('Entering:'||l_proc, 5);
1168: --
1169: -- Ensure that the DateTrack update mode is valid
1170: --
1171: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
1318: l_rec per_dis_shd.g_rec_type;
1319: l_proc varchar2(72) := g_package||'upd';
1320: --
1321: Begin
1322: hr_utility.set_location('Entering:'||l_proc, 5);
1323: --
1324: -- Call conversion function to turn arguments into the
1325: -- l_rec structure.
1326: --
1424: p_effective_start_date := l_rec.effective_start_date;
1425: p_effective_end_date := l_rec.effective_end_date;
1426: --
1427: --
1428: hr_utility.set_location(' Leaving:'||l_proc, 10);
1429: End upd;
1430: --
1431: end per_dis_upd;