5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := 'per_seu_upd.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- ----------------------------------------------------------------------------
12: -- |------------------------------< update_dml >------------------------------|
13: -- ----------------------------------------------------------------------------
58: --
59: l_proc varchar2(72) := g_package||'update_dml';
60: --
61: Begin
62: hr_utility.set_location('Entering:'||l_proc, 5);
63: --
64: -- Increment the object version
65: p_rec.object_version_number := p_rec.object_version_number + 1;
66: --
78: where security_user_id = p_rec.security_user_id;
79: --
80: --
81: --
82: hr_utility.set_location(' Leaving:'||l_proc, 10);
83: --
84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
140: --
141: l_proc varchar2(72) := g_package||'pre_update';
142: --
143: Begin
144: hr_utility.set_location('Entering:'||l_proc, 5);
145: --
146: hr_utility.set_location(' Leaving:'||l_proc, 10);
147: End pre_update;
148: --
142: --
143: Begin
144: hr_utility.set_location('Entering:'||l_proc, 5);
145: --
146: hr_utility.set_location(' Leaving:'||l_proc, 10);
147: End pre_update;
148: --
149: -- ----------------------------------------------------------------------------
150: -- |-----------------------------< post_update >------------------------------|
188: --
189: Begin
190:
191: IF g_debug THEN
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: END IF;
194:
195: --
196: -- A change to the user or security profile means that
206: -- Set the warning flag to true if the user has static lists
207: -- and they will be deleted.
208: --
209: IF g_debug THEN
210: hr_utility.set_location(l_proc, 10);
211: END IF;
212:
213: p_del_static_lists_warning :=
214: hr_security_internal.user_in_static_lists
219: --
220: -- Delete the static lists for this user.
221: --
222: IF g_debug THEN
223: hr_utility.set_location(l_proc, 15);
224: END IF;
225:
226: hr_security_internal.delete_static_lists_for_user
227: (p_user_id => per_seu_shd.g_old_rec.user_id
231:
232: END IF;
233:
234: IF g_debug THEN
235: hr_utility.set_location(l_proc, 20);
236: END IF;
237:
238: begin
239: per_seu_rku.after_update
260: --
261: end;
262:
263: IF g_debug THEN
264: hr_utility.set_location(' Leaving:'||l_proc, 999);
265: END IF;
266:
267: End post_update;
268: --
343: l_proc varchar2(72) := g_package||'upd';
344: l_del_static_lists_warning boolean;
345: --
346: Begin
347: hr_utility.set_location('Entering:'||l_proc, 5);
348: --
349: -- We must lock the row which we need to update.
350: --
351: per_seu_shd.lck
411: l_proc varchar2(72) := g_package||'upd';
412: l_del_static_lists_warning boolean;
413: --
414: Begin
415: hr_utility.set_location('Entering:'||l_proc, 5);
416: --
417: -- Call conversion function to turn arguments into the
418: -- l_rec structure.
419: --
442: p_object_version_number := l_rec.object_version_number;
443: p_del_static_lists_warning := l_del_static_lists_warning;
444:
445: --
446: hr_utility.set_location(' Leaving:'||l_proc, 10);
447:
448: End upd;
449: --
450: end per_seu_upd;