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: --
151: where previous_employer_id = p_rec.previous_employer_id;
152: --
153: --
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
156: --
157: Exception
158: When hr_api.check_integrity_violated Then
159: -- A check constraint has been violated
213: --
214: l_proc varchar2(72) := g_package||'pre_update';
215: --
216: Begin
217: hr_utility.set_location('Entering:'||l_proc, 5);
218: --
219: hr_utility.set_location(' Leaving:'||l_proc, 10);
220: End pre_update;
221: --
215: --
216: Begin
217: hr_utility.set_location('Entering:'||l_proc, 5);
218: --
219: hr_utility.set_location(' Leaving:'||l_proc, 10);
220: End pre_update;
221: --
222: -- ----------------------------------------------------------------------------
223: -- |-----------------------------< post_update >------------------------------|
258: --
259: l_proc varchar2(72) := g_package||'post_update';
260: --
261: Begin
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: begin
264: --
265: per_pem_rku.after_update
266: (p_effective_date => p_effective_date
589: ,p_hook_type => 'AU');
590: --
591: end;
592: --
593: hr_utility.set_location(' Leaving:'||l_proc, 10);
594: End post_update;
595: --
596: -- ----------------------------------------------------------------------------
597: -- |-----------------------------< convert_defs >-----------------------------|
968: --
969: l_proc varchar2(72) := g_package||'upd';
970: --
971: Begin
972: hr_utility.set_location('Entering:'||l_proc, 5);
973: --
974: -- We must lock the row which we need to update.
975: --
976: per_pem_shd.lck
1100: l_rec per_pem_shd.g_rec_type;
1101: l_proc varchar2(72) := g_package||'upd';
1102: --
1103: Begin
1104: hr_utility.set_location('Entering:'||l_proc, 5);
1105: --
1106: -- Call conversion function to turn arguments into the
1107: -- l_rec structure.
1108: --
1198: ,l_rec
1199: );
1200: p_object_version_number := l_rec.object_version_number;
1201: --
1202: hr_utility.set_location(' Leaving:'||l_proc, 10);
1203: End upd;
1204: --
1205: end per_pem_upd;