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: --
288: p_rec.effective_start_date := p_validation_start_date;
289: p_rec.effective_end_date := p_validation_end_date;
290: End If;
291: --
292: hr_utility.set_location(' Leaving:'||l_proc, 15);
293: Exception
294: When hr_api.check_integrity_violated Then
295: -- A check constraint has been violated
296: ben_pln_shd.g_api_dml := false; -- Unset the api dml status
346: --
347: l_proc varchar2(72) := g_package||'update_dml';
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);
351: --
352: dt_update_dml(p_rec => p_rec,
353: p_effective_date => p_effective_date,
354: p_datetrack_mode => p_datetrack_mode,
354: p_datetrack_mode => p_datetrack_mode,
355: p_validation_start_date => p_validation_start_date,
356: p_validation_end_date => p_validation_end_date);
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 10);
359: End update_dml;
360: --
361: -- ----------------------------------------------------------------------------
362: -- |----------------------------< dt_pre_update >-----------------------------|
411: l_proc varchar2(72) := g_package||'dt_pre_update';
412: l_dummy_version_number number;
413: --
414: Begin
415: hr_utility.set_location('Entering:'||l_proc, 5);
416: If (p_datetrack_mode <> 'CORRECTION') then
417: hr_utility.set_location(l_proc, 10);
418: --
419: -- Update the current effective end date
413: --
414: Begin
415: hr_utility.set_location('Entering:'||l_proc, 5);
416: If (p_datetrack_mode <> 'CORRECTION') then
417: hr_utility.set_location(l_proc, 10);
418: --
419: -- Update the current effective end date
420: --
421: ben_pln_shd.upd_effective_end_date
426: p_validation_end_date => p_validation_end_date,
427: p_object_version_number => l_dummy_version_number);
428: --
429: If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
430: hr_utility.set_location(l_proc, 15);
431: --
432: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
433: -- delete any future rows
434: --
438: p_datetrack_mode => p_datetrack_mode,
439: p_validation_start_date => p_validation_start_date,
440: p_validation_end_date => p_validation_end_date);
441: End If;
442: hr_utility.set_location(l_proc, 20);
443: --
444: -- We must now insert the updated row
445: --
446: ben_pln_ins.insert_dml
449: p_datetrack_mode => p_datetrack_mode,
450: p_validation_start_date => p_validation_start_date,
451: p_validation_end_date => p_validation_end_date);
452: End If;
453: hr_utility.set_location(' Leaving:'||l_proc, 20);
454: End dt_pre_update;
455: --
456: -- ----------------------------------------------------------------------------
457: -- |------------------------------< pre_update >------------------------------|
495: --
496: l_proc varchar2(72) := g_package||'pre_update';
497: --
498: Begin
499: hr_utility.set_location('Entering:'||l_proc, 5);
500: --
501: --
502: --
503: dt_pre_update
515: p_name => p_rec.name
516: ) ;
517: --Bug : 3460429
518:
519: hr_utility.set_location(' Leaving:'||l_proc, 10);
520: End pre_update;
521: --
522: -- ----------------------------------------------------------------------------
523: -- |-----------------------------< post_update >------------------------------|
560: --
561: l_proc varchar2(72) := g_package||'post_update';
562: --
563: Begin
564: hr_utility.set_location('Entering:'||l_proc, 5);
565: --
566: --
567: -- Start of API User Hook for post_update.
568: -- Added for GSP validations
981: end;
982: --
983: -- End of API User Hook for post_update.
984: --
985: hr_utility.set_location(' Leaving:'||l_proc, 10);
986: End post_update;
987: --
988: --
989: -- ----------------------------------------------------------------------------
1000: l_validation_start_date date;
1001: l_validation_end_date date;
1002: --
1003: Begin
1004: hr_utility.set_location('Entering:'||l_proc, 5);
1005: --
1006: -- Ensure that the DateTrack update mode is valid
1007: --
1008: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
1023: --
1024: -- 2. Call the supporting update validate operations.
1025: --
1026: ben_pln_upd2.convert_defs(p_rec);
1027: hr_utility.set_location('xxxxx l_validation_start_date '||l_validation_start_date, 100);
1028: hr_utility.set_location('xxxx l_validation_end_date '||l_validation_end_date, 100);
1029: ben_pln_bus.update_validate
1030: (p_rec => p_rec,
1031: p_effective_date => p_effective_date,
1024: -- 2. Call the supporting update validate operations.
1025: --
1026: ben_pln_upd2.convert_defs(p_rec);
1027: hr_utility.set_location('xxxxx l_validation_start_date '||l_validation_start_date, 100);
1028: hr_utility.set_location('xxxx l_validation_end_date '||l_validation_end_date, 100);
1029: ben_pln_bus.update_validate
1030: (p_rec => p_rec,
1031: p_effective_date => p_effective_date,
1032: p_datetrack_mode => p_datetrack_mode,
1264: l_rec ben_pln_shd.g_rec_type;
1265: l_proc varchar2(72) := g_package||'upd';
1266: --
1267: Begin
1268: hr_utility.set_location('Entering:'||l_proc, 5);
1269: --
1270: -- Call conversion function to turn arguments into the
1271: -- l_rec structure.
1272: --
1475: p_effective_start_date := l_rec.effective_start_date;
1476: p_effective_end_date := l_rec.effective_end_date;
1477: --
1478: --
1479: hr_utility.set_location(' Leaving:'||l_proc, 10);
1480: End upd;
1481: --
1482: end ben_pln_upd;