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: --
93: where template_id = p_rec.template_id;
94: --
95: psp_prt_shd.g_api_dml := false; -- Unset the api dml status
96: --
97: hr_utility.set_location(' Leaving:'||l_proc, 10);
98: --
99: Exception
100: When hr_api.check_integrity_violated Then
101: -- A check constraint has been violated
155: --
156: l_proc varchar2(72) := g_package||'pre_update';
157: --
158: Begin
159: hr_utility.set_location('Entering:'||l_proc, 5);
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 10);
162: End pre_update;
163: --
157: --
158: Begin
159: hr_utility.set_location('Entering:'||l_proc, 5);
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 10);
162: End pre_update;
163: --
164: -- ----------------------------------------------------------------------------
165: -- |-----------------------------< post_update >------------------------------|
199: --
200: l_proc varchar2(72) := g_package||'post_update';
201: --
202: Begin
203: hr_utility.set_location('Entering:'||l_proc, 5);
204: begin
205: --
206: psp_prt_rku.after_update
207: (p_template_id
297: ,p_hook_type => 'AU');
298: --
299: end;
300: --
301: hr_utility.set_location(' Leaving:'||l_proc, 10);
302: End post_update;
303: --
304: -- ----------------------------------------------------------------------------
305: -- |-----------------------------< convert_defs >-----------------------------|
443: --
444: l_proc varchar2(72) := g_package||'upd';
445: --
446: Begin
447: hr_utility.set_location('Entering:'||l_proc, 5);
448: --
449: -- We must lock the row which we need to update.
450: --
451: psp_prt_shd.lck
515: l_rec psp_prt_shd.g_rec_type;
516: l_proc varchar2(72) := g_package||'upd';
517: --
518: Begin
519: hr_utility.set_location('Entering:'||l_proc, 5);
520: --
521: -- Call conversion function to turn arguments into the
522: -- l_rec structure.
523: --
554: (l_rec
555: );
556: p_object_version_number := l_rec.object_version_number;
557: --
558: hr_utility.set_location(' Leaving:'||l_proc, 10);
559: End upd;
560: --
561: end psp_prt_upd;