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: --
81: where recruitment_activity_for_id = p_rec.rec_activity_for_id;
82: --
83: --
84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: --
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
143: --
144: l_proc varchar2(72) := g_package||'pre_update';
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: End pre_update;
151: --
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: End pre_update;
151: --
152: -- ----------------------------------------------------------------------------
153: -- |-----------------------------< post_update >------------------------------|
187: --
188: l_proc varchar2(72) := g_package||'post_update';
189: --
190: Begin
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: begin
193: --
194: per_rcf_rku.after_update
195: (p_rec_activity_for_id
237: ,p_hook_type => 'AU');
238: --
239: end;
240: --
241: hr_utility.set_location(' Leaving:'||l_proc, 10);
242: End post_update;
243: --
244: -- ----------------------------------------------------------------------------
245: -- |-----------------------------< convert_defs >-----------------------------|
335: --
336: l_proc varchar2(72) := g_package||'upd';
337: --
338: Begin
339: hr_utility.set_location('Entering:'||l_proc, 5);
340: --
341: -- We must lock the row which we need to update.
342: --
343: per_rcf_shd.lck
393: l_rec per_rcf_shd.g_rec_type;
394: l_proc varchar2(72) := g_package||'upd';
395: --
396: Begin
397: hr_utility.set_location('Entering:'||l_proc, 5);
398: --
399: -- Call conversion function to turn arguments into the
400: -- l_rec structure.
401: --
420: (l_rec
421: );
422: p_object_version_number := l_rec.object_version_number;
423: --
424: hr_utility.set_location(' Leaving:'||l_proc, 10);
425: End upd;
426: --
427: end per_rcf_upd;