58: l_proc constant varchar2(72):= g_package||'update_dml';
59: --
60: Begin
61:
62: hr_utility.set_location('Entering:'||l_proc, 5);
63: --
64: -- Increment the object version
65: p_rec.object_version_number := p_rec.object_version_number + 1;
66: --
81: where rank_process_approval_id = p_rec.rank_process_approval_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
144: l_proc constant varchar2(72):= g_package||'pre_update';
145: --
146: Begin
147:
148: hr_utility.set_location('Entering:'||l_proc, 5);
149: --
150: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: End pre_update;
152: --
146: Begin
147:
148: hr_utility.set_location('Entering:'||l_proc, 5);
149: --
150: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: End pre_update;
152: --
153: -- ----------------------------------------------------------------------------
154: -- |-----------------------------< post_update >------------------------------|
190: l_proc constant varchar2(72):= g_package||'post_update';
191: --
192: Begin
193:
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: begin
196: --
197: pqh_rap_rku.after_update
198: (p_effective_date => p_effective_date
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 >-----------------------------|
333: l_proc constant varchar2(72):= g_package||'upd';
334: --
335: Begin
336:
337: hr_utility.set_location('Entering:'||l_proc, 5);
338: --
339: -- We must lock the row which we need to update.
340: --
341: pqh_rap_shd.lck
396: l_proc constant varchar2(72):= g_package||'upd';
397: --
398: Begin
399:
400: hr_utility.set_location('Entering:'||l_proc, 5);
401: --
402: -- Call conversion function to turn arguments into the
403: -- l_rec structure.
404: --
423: ,l_rec
424: );
425: p_object_version_number := l_rec.object_version_number;
426: --
427: hr_utility.set_location(' Leaving:'||l_proc, 10);
428: End upd;
429: --
430: end pqh_rap_upd;