63: --
64: l_proc varchar2(72) := g_package||'dt_update_dml';
65: --
66: Begin
67: hr_utility.set_location('Entering:'||l_proc, 5);
68: --
69: If (p_datetrack_mode = 'CORRECTION') then
70: hr_utility.set_location(l_proc, 10);
71: --
66: Begin
67: hr_utility.set_location('Entering:'||l_proc, 5);
68: --
69: If (p_datetrack_mode = 'CORRECTION') then
70: hr_utility.set_location(l_proc, 10);
71: --
72: -- Because we are updating a row we must get the next object
73: -- version number.
74: --
158: p_rec.effective_start_date := p_validation_start_date;
159: p_rec.effective_end_date := p_validation_end_date;
160: End If;
161: --
162: hr_utility.set_location(' Leaving:'||l_proc, 15);
163: Exception
164: When hr_api.check_integrity_violated Then
165: -- A check constraint has been violated
166: ben_cct_shd.g_api_dml := false; -- Unset the api dml status
216: --
217: l_proc varchar2(72) := g_package||'update_dml';
218: --
219: Begin
220: hr_utility.set_location('Entering:'||l_proc, 5);
221: --
222: dt_update_dml(p_rec => p_rec,
223: p_effective_date => p_effective_date,
224: p_datetrack_mode => p_datetrack_mode,
224: p_datetrack_mode => p_datetrack_mode,
225: p_validation_start_date => p_validation_start_date,
226: p_validation_end_date => p_validation_end_date);
227: --
228: hr_utility.set_location(' Leaving:'||l_proc, 10);
229: End update_dml;
230: --
231: -- ----------------------------------------------------------------------------
232: -- |----------------------------< dt_pre_update >-----------------------------|
281: l_proc varchar2(72) := g_package||'dt_pre_update';
282: l_dummy_version_number number;
283: --
284: Begin
285: hr_utility.set_location('Entering:'||l_proc, 5);
286: If (p_datetrack_mode <> 'CORRECTION') then
287: hr_utility.set_location(l_proc, 10);
288: --
289: -- Update the current effective end date
283: --
284: Begin
285: hr_utility.set_location('Entering:'||l_proc, 5);
286: If (p_datetrack_mode <> 'CORRECTION') then
287: hr_utility.set_location(l_proc, 10);
288: --
289: -- Update the current effective end date
290: --
291: ben_cct_shd.upd_effective_end_date
296: p_validation_end_date => p_validation_end_date,
297: p_object_version_number => l_dummy_version_number);
298: --
299: If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
300: hr_utility.set_location(l_proc, 15);
301: --
302: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
303: -- delete any future rows
304: --
308: p_datetrack_mode => p_datetrack_mode,
309: p_validation_start_date => p_validation_start_date,
310: p_validation_end_date => p_validation_end_date);
311: End If;
312: hr_utility.set_location(l_proc, 20);
313: --
314: -- We must now insert the updated row
315: --
316: ben_cct_ins.insert_dml
319: p_datetrack_mode => p_datetrack_mode,
320: p_validation_start_date => p_validation_start_date,
321: p_validation_end_date => p_validation_end_date);
322: End If;
323: hr_utility.set_location(' Leaving:'||l_proc, 20);
324: End dt_pre_update;
325: --
326: -- ----------------------------------------------------------------------------
327: -- |------------------------------< pre_update >------------------------------|
365: --
366: l_proc varchar2(72) := g_package||'pre_update';
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);
370: --
371: --
372: --
373: dt_pre_update
376: p_datetrack_mode => p_datetrack_mode,
377: p_validation_start_date => p_validation_start_date,
378: p_validation_end_date => p_validation_end_date);
379: --
380: hr_utility.set_location(' Leaving:'||l_proc, 10);
381: End pre_update;
382: --
383: -- ----------------------------------------------------------------------------
384: -- |-----------------------------< post_update >------------------------------|
421: --
422: l_proc varchar2(72) := g_package||'post_update';
423: --
424: Begin
425: hr_utility.set_location('Entering:'||l_proc, 5);
426: --
427: --
428: -- Start of API User Hook for post_update.
429: --
548: --
549: -- End of API User Hook for post_update.
550: --
551: --
552: hr_utility.set_location(' Leaving:'||l_proc, 10);
553: End post_update;
554: --
555: -- ----------------------------------------------------------------------------
556: -- |-----------------------------< convert_defs >-----------------------------|
600: l_proc varchar2(72) := g_package||'convert_defs';
601: --
602: Begin
603: --
604: hr_utility.set_location('Entering:'||l_proc, 5);
605: --
606: -- We must now examine each argument value in the
607: -- p_rec plsql record structure
608: -- to see if a system default is being used. If a system default
796: p_rec.cct_attribute9 :=
797: ben_cct_shd.g_old_rec.cct_attribute9;
798: End If;
799: --
800: hr_utility.set_location(' Leaving:'||l_proc, 10);
801: --
802: End convert_defs;
803: --
804: -- ----------------------------------------------------------------------------
815: l_validation_start_date date;
816: l_validation_end_date date;
817: --
818: Begin
819: hr_utility.set_location('Entering:'||l_proc, 5);
820: --
821: -- Ensure that the DateTrack update mode is valid
822: --
823: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
937: l_rec ben_cct_shd.g_rec_type;
938: l_proc varchar2(72) := g_package||'upd';
939: --
940: Begin
941: hr_utility.set_location('Entering:'||l_proc, 5);
942: --
943: -- Call conversion function to turn arguments into the
944: -- l_rec structure.
945: --
1008: p_effective_start_date := l_rec.effective_start_date;
1009: p_effective_end_date := l_rec.effective_end_date;
1010: --
1011: --
1012: hr_utility.set_location(' Leaving:'||l_proc, 10);
1013: End upd;
1014: --
1015: end ben_cct_upd;