57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
60: Begin
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
75: where vacancy_consideration_id = p_rec.vacancy_consideration_id;
76: --
77: --
78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: --
81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
137: --
138: l_proc varchar2(72) := g_package||'pre_update';
139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_update;
145: --
139: --
140: Begin
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: hr_utility.set_location(' Leaving:'||l_proc, 10);
144: End pre_update;
145: --
146: -- ----------------------------------------------------------------------------
147: -- |-----------------------------< post_update >------------------------------|
182: --
183: l_proc varchar2(72) := g_package||'post_update';
184: --
185: Begin
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: begin
188: --
189: irc_ivc_rku.after_update
190: (p_effective_date => p_effective_date
213: ,p_hook_type => 'AU');
214: --
215: end;
216: --
217: hr_utility.set_location(' Leaving:'||l_proc, 10);
218: End post_update;
219: --
220: -- ----------------------------------------------------------------------------
221: -- |-----------------------------< convert_defs >-----------------------------|
292: --
293: l_proc varchar2(72) := g_package||'upd';
294: --
295: Begin
296: hr_utility.set_location('Entering:'||l_proc, 5);
297: --
298: -- We must lock the row which we need to update.
299: --
300: irc_ivc_shd.lck
355: l_rec irc_ivc_shd.g_rec_type;
356: l_proc varchar2(72) := g_package||'upd';
357: --
358: Begin
359: hr_utility.set_location('Entering:'||l_proc, 5);
360: --
361: -- Call conversion function to turn arguments into the
362: -- l_rec structure.
363: --
380: ,l_rec
381: );
382: p_object_version_number := l_rec.object_version_number;
383: --
384: hr_utility.set_location(' Leaving:'||l_proc, 10);
385: End upd;
386: --
387: end irc_ivc_upd;