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: --
79: where process_event_id = p_rec.process_event_id;
80: --
81: --
82: --
83: hr_utility.set_location(' Leaving:'||l_proc, 10);
84: --
85: Exception
86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
141: --
142: l_proc varchar2(72) := g_package||'pre_update';
143: --
144: Begin
145: hr_utility.set_location('Entering:'||l_proc, 5);
146: --
147: hr_utility.set_location(' Leaving:'||l_proc, 10);
148: End pre_update;
149: --
143: --
144: Begin
145: hr_utility.set_location('Entering:'||l_proc, 5);
146: --
147: hr_utility.set_location(' Leaving:'||l_proc, 10);
148: End pre_update;
149: --
150: -- ----------------------------------------------------------------------------
151: -- |-----------------------------< post_update >------------------------------|
185: --
186: l_proc varchar2(72) := g_package||'post_update';
187: --
188: Begin
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: hr_utility.set_location(' Leaving:'||l_proc, 10);
191: End post_update;
192: --
193: -- ----------------------------------------------------------------------------
186: l_proc varchar2(72) := g_package||'post_update';
187: --
188: Begin
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: hr_utility.set_location(' Leaving:'||l_proc, 10);
191: End post_update;
192: --
193: -- ----------------------------------------------------------------------------
194: -- |-----------------------------< convert_defs >-----------------------------|
276: --
277: l_proc varchar2(72) := g_package||'upd';
278: --
279: Begin
280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: -- We must lock the row which we need to update.
283: --
284: pay_ppe_shd.lck
328: l_rec pay_ppe_shd.g_rec_type;
329: l_proc varchar2(72) := g_package||'upd';
330: --
331: Begin
332: hr_utility.set_location('Entering:'||l_proc, 5);
333: --
334: -- Call conversion function to turn arguments into the
335: -- l_rec structure.
336: --
353: (l_rec
354: );
355: p_object_version_number := l_rec.object_version_number;
356: --
357: hr_utility.set_location(' Leaving:'||l_proc, 10);
358: End upd;
359: --
360: end pay_ppe_upd;