[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: pqh_asa_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 >------------------------------|
386: --
387: l_proc varchar2(72) := g_package||'pre_update';
388: --
389: Begin
390: hr_utility.set_location('Entering:'||l_proc, 5);
391: --
392: --
393: --
394: dt_pre_update
398: ,p_validation_start_date => p_validation_start_date
399: ,p_validation_end_date => p_validation_end_date
400: );
401: --
402: hr_utility.set_location(' Leaving:'||l_proc, 10);
403: End pre_update;
404: --
405: -- ----------------------------------------------------------------------------
406: -- |----------------------------< post_update >-------------------------------|
444: --
445: l_proc varchar2(72) := g_package||'post_update';
446: --
447: Begin
448: hr_utility.set_location('Entering:'||l_proc, 5);
449: begin
450: --
451: pqh_asa_rku.after_update
452: (p_effective_date
786: ,p_hook_type => 'AU');
787: --
788: end;
789: --
790: hr_utility.set_location(' Leaving:'||l_proc, 10);
791: End post_update;
792: --
793: -- ----------------------------------------------------------------------------
794: -- |-----------------------------< convert_defs >-----------------------------|
1164: l_validation_start_date date;
1165: l_validation_end_date date;
1166: --
1167: Begin
1168: hr_utility.set_location('Entering:'||l_proc, 5);
1169: --
1170: -- Ensure that the DateTrack update mode is valid
1171: --
1172: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
1326: l_rec pqh_asa_shd.g_rec_type;
1327: l_proc varchar2(72) := g_package||'upd';
1328: --
1329: Begin
1330: hr_utility.set_location('Entering:'||l_proc, 5);
1331: --
1332: -- Call conversion function to turn arguments into the
1333: -- l_rec structure.
1334: --
1432: p_effective_start_date := l_rec.effective_start_date;
1433: p_effective_end_date := l_rec.effective_end_date;
1434: --
1435: --
1436: hr_utility.set_location(' Leaving:'||l_proc, 10);
1437: End upd;
1438: --
1439: end pqh_asa_upd;