[Home] [Help]
65: --
66: l_proc varchar2(72) := g_package||'dt_update_dml';
67: --
68: Begin
69: hr_utility.set_location('Entering:'||l_proc, 5);
70: --
71: If (p_datetrack_mode = hr_api.g_correction) then
72: hr_utility.set_location(l_proc, 10);
73: --
68: Begin
69: hr_utility.set_location('Entering:'||l_proc, 5);
70: --
71: If (p_datetrack_mode = hr_api.g_correction) then
72: hr_utility.set_location(l_proc, 10);
73: --
74: -- Because we are updating a row we must get the next object
75: -- version number.
76: --
140: p_rec.effective_start_date := p_validation_start_date;
141: p_rec.effective_end_date := p_validation_end_date;
142: End If;
143: --
144: hr_utility.set_location(' Leaving:'||l_proc, 15);
145: Exception
146: When hr_api.check_integrity_violated Then
147: -- A check constraint has been violated
148: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
199: --
200: l_proc varchar2(72) := g_package||'update_dml';
201: --
202: Begin
203: hr_utility.set_location('Entering:'||l_proc, 5);
204: --
205: pay_ele_upd.dt_update_dml
206: (p_rec => p_rec
207: ,p_effective_date => p_effective_date
209: ,p_validation_start_date => p_validation_start_date
210: ,p_validation_end_date => p_validation_end_date
211: );
212: --
213: hr_utility.set_location(' Leaving:'||l_proc, 10);
214: End update_dml;
215: --
216: -- ----------------------------------------------------------------------------
217: -- |----------------------------< dt_pre_update >-----------------------------|
267: l_proc varchar2(72) := g_package||'dt_pre_update';
268: l_dummy_version_number number;
269: --
270: Begin
271: hr_utility.set_location('Entering:'||l_proc, 5);
272: If (p_datetrack_mode <> hr_api.g_correction) then
273: --
274: -- Update the current effective end date
275: --
305: ,p_validation_start_date => p_validation_start_date
306: ,p_validation_end_date => p_validation_end_date
307: );
308: End If;
309: hr_utility.set_location(' Leaving:'||l_proc, 20);
310: End dt_pre_update;
311: --
312: -- ----------------------------------------------------------------------------
313: -- |------------------------------< pre_update >------------------------------|
352: --
353: l_proc varchar2(72) := g_package||'pre_update';
354: --
355: Begin
356: hr_utility.set_location('Entering:'||l_proc, 5);
357: --
358: --
359: -- Insert the comment text if comments exist
360: --
379: ,p_validation_start_date => p_validation_start_date
380: ,p_validation_end_date => p_validation_end_date
381: );
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 10);
384: End pre_update;
385: --
386: -- ----------------------------------------------------------------------------
387: -- |----------------------------< post_update >-------------------------------|
426:
427: l_proc varchar2(72) := g_package||'post_update';
428: --
429: Begin
430: hr_utility.set_location('Entering:'||l_proc, 5);
431: begin
432: --
433: pay_ele_rku.after_update
434: (p_effective_date
691: --
692: -- 11-NOV-03
693: -- Hard calls to DYT_PKG removed, perfomed in pyentapi.pkb
694:
695: hr_utility.set_location('Leaving:'||l_proc, 900);
696: --
697: End post_update;
698: --
699: -- ----------------------------------------------------------------------------
930: l_validation_start_date date;
931: l_validation_end_date date;
932: --
933: Begin
934: hr_utility.set_location('Entering:'||l_proc, 5);
935: --
936: -- Ensure that the DateTrack update mode is valid
937: --
938: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
1049: l_rec pay_ele_shd.g_rec_type;
1050: l_proc varchar2(72) := g_package||'upd';
1051: --
1052: Begin
1053: hr_utility.set_location('Entering:'||l_proc, 5);
1054: --
1055: -- Call conversion function to turn arguments into the
1056: -- l_rec structure.
1057: --
1120: p_effective_start_date := l_rec.effective_start_date;
1121: p_effective_end_date := l_rec.effective_end_date;
1122: p_comment_id := l_rec.comment_id;
1123: --
1124: hr_utility.set_location(' Leaving:'||l_proc, 10);
1125: End upd;
1126: --
1127: end pay_ele_upd;