55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
104: where succession_plan_id = p_rec.succession_plan_id;
105: --
106: per_suc_shd.g_api_dml := false; -- Unset the api dml status
107: --
108: hr_utility.set_location(' Leaving:'||l_proc, 10);
109: --
110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
164: --
165: l_proc varchar2(72) := g_package||'pre_update';
166: --
167: Begin
168: hr_utility.set_location('Entering:'||l_proc, 5);
169: --
170: hr_utility.set_location(' Leaving:'||l_proc, 10);
171: End pre_update;
172: --
166: --
167: Begin
168: hr_utility.set_location('Entering:'||l_proc, 5);
169: --
170: hr_utility.set_location(' Leaving:'||l_proc, 10);
171: End pre_update;
172: --
173: -- ----------------------------------------------------------------------------
174: -- |-----------------------------< post_update >------------------------------|
207: --
208: l_proc varchar2(72) := g_package||'post_update';
209: --
210: Begin
211: hr_utility.set_location('Entering:'||l_proc, 5);
212: --
213: -- Start of Row Handler User Hook for post_update.
214: --
215: Begin
291: end;
292: --
293: -- End of Row Handler User Hook for post_update.
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 10);
296: End post_update;
297: --
298: -- ----------------------------------------------------------------------------
299: -- |-----------------------------< convert_defs >-----------------------------|
344: l_proc varchar2(72) := g_package||'convert_defs';
345: --
346: Begin
347: --
348: hr_utility.set_location('Entering:'||l_proc, 5);
349: --
350: -- We must now examine each argument value in the
351: -- p_rec plsql record structure
352: -- to see if a system default is being used. If a system default
476: p_rec.successee_person_id :=
477: per_suc_shd.g_old_rec.successee_person_id;
478: End If;
479: --
480: hr_utility.set_location(' Leaving:'||l_proc, 10);
481: --
482: End convert_defs;
483: --
484: -- ----------------------------------------------------------------------------
492: --
493: l_proc varchar2(72) := g_package||'upd';
494: --
495: Begin
496: hr_utility.set_location('Entering:'||l_proc, 5);
497: --
498: -- We must lock the row which we need to update.
499: --
500: per_suc_shd.lck
569: l_rec per_suc_shd.g_rec_type;
570: l_proc varchar2(72) := g_package||'upd';
571: --
572: Begin
573: hr_utility.set_location('Entering:'||l_proc, 5);
574: --
575: -- Call conversion function to turn arguments into the
576: -- l_rec structure.
577: --
619: --
620: upd(l_rec,p_effective_date);
621: p_object_version_number := l_rec.object_version_number;
622: --
623: hr_utility.set_location(' Leaving:'||l_proc, 10);
624: End upd;
625: --
626: end per_suc_upd;