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: --
146: where previous_job_id = p_rec.previous_job_id;
147: --
148: --
149: --
150: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: --
152: Exception
153: When hr_api.check_integrity_violated Then
154: -- A check constraint has been violated
208: --
209: l_proc varchar2(72) := g_package||'pre_update';
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: End pre_update;
216: --
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: End pre_update;
216: --
217: -- ----------------------------------------------------------------------------
218: -- |-----------------------------< post_update >------------------------------|
253: --
254: l_proc varchar2(72) := g_package||'post_update';
255: --
256: Begin
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: begin
259: --
260: per_pjo_rku.after_update
261: (p_effective_date => p_effective_date
564: ,p_hook_type => 'AU');
565: --
566: end;
567: --
568: hr_utility.set_location(' Leaving:'||l_proc, 10);
569: End post_update;
570: --
571: -- ----------------------------------------------------------------------------
572: -- |-----------------------------< convert_defs >-----------------------------|
923: --
924: l_proc varchar2(72) := g_package||'upd';
925: --
926: Begin
927: hr_utility.set_location('Entering:'||l_proc, 5);
928: --
929: -- We must lock the row which we need to update.
930: --
931: per_pjo_shd.lck
1050: l_rec per_pjo_shd.g_rec_type;
1051: l_proc varchar2(72) := g_package||'upd';
1052: --
1053: Begin
1054: hr_utility.set_location('Entering:'||l_proc, 5);
1055: --
1056: -- Call conversion function to turn arguments into the
1057: -- l_rec structure.
1058: --
1143: ,l_rec
1144: );
1145: p_object_version_number := l_rec.object_version_number;
1146: --
1147: hr_utility.set_location(' Leaving:'||l_proc, 10);
1148: End upd;
1149: --
1150: end per_pjo_upd;