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: --
87: where successee_detail_id = p_rec.successee_detail_id;
88: --
89: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
90: --
91: hr_utility.set_location(' Leaving:'||l_proc, 10);
92: --
93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
149: --
150: l_proc varchar2(72) := g_package||'pre_update';
151: --
152: Begin
153: hr_utility.set_location('Entering:'||l_proc, 5);
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
156: End pre_update;
157: --
151: --
152: Begin
153: hr_utility.set_location('Entering:'||l_proc, 5);
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
156: End pre_update;
157: --
158: -- ----------------------------------------------------------------------------
159: -- |-----------------------------< post_update >------------------------------|
194: --
195: l_proc varchar2(72) := g_package||'post_update';
196: --
197: Begin
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: begin
200: --
201: per_ssd_rku.after_update
202: (p_effective_date => p_effective_date
269: ,p_hook_type => 'AU');
270: --
271: end;
272: --
273: hr_utility.set_location(' Leaving:'||l_proc, 10);
274: End post_update;
275: --
276: -- ----------------------------------------------------------------------------
277: -- |-----------------------------< convert_defs >-----------------------------|
392: --
393: l_proc varchar2(72) := g_package||'upd';
394: --
395: Begin
396: hr_utility.set_location('Entering:'||l_proc, 5);
397: --
398: -- We must lock the row which we need to update.
399: --
400: per_ssd_shd.lck
461: l_rec per_ssd_shd.g_rec_type;
462: l_proc varchar2(72) := g_package||'upd';
463: --
464: Begin
465: hr_utility.set_location('Entering:'||l_proc, 5);
466: --
467: -- Call conversion function to turn arguments into the
468: -- l_rec structure.
469: --
495: ,l_rec
496: );
497: p_object_version_number := l_rec.object_version_number;
498: --
499: hr_utility.set_location(' Leaving:'||l_proc, 10);
500: End upd;
501: --
502: end per_ssd_upd;