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: --
113: where spinal_point_id = p_rec.spinal_point_id;
114: --
115: per_psp_shd.g_api_dml := false; -- Unset the api dml status
116: --
117: hr_utility.set_location(' Leaving:'||l_proc, 10);
118: --
119: Exception
120: When hr_api.check_integrity_violated Then
121: -- A check constraint has been violated
175: --
176: l_proc varchar2(72) := g_package||'pre_update';
177: --
178: Begin
179: hr_utility.set_location('Entering:'||l_proc, 5);
180: --
181: hr_utility.set_location(' Leaving:'||l_proc, 10);
182: End pre_update;
183: --
177: --
178: Begin
179: hr_utility.set_location('Entering:'||l_proc, 5);
180: --
181: hr_utility.set_location(' Leaving:'||l_proc, 10);
182: End pre_update;
183: --
184: -- ----------------------------------------------------------------------------
185: -- |-----------------------------< post_update >------------------------------|
220: --
221: l_proc varchar2(72) := g_package||'post_update';
222: --
223: Begin
224: hr_utility.set_location('Entering:'||l_proc, 5);
225: begin
226: --
227: per_psp_rku.after_update
228: (p_effective_date => p_effective_date
399: ,p_hook_type => 'AU');
400: --
401: end;
402: --
403: hr_utility.set_location(' Leaving:'||l_proc, 10);
404: End post_update;
405: --
406: -- ----------------------------------------------------------------------------
407: -- |-----------------------------< convert_defs >-----------------------------|
627: --
628: l_proc varchar2(72) := g_package||'upd';
629: --
630: Begin
631: hr_utility.set_location('Entering:'||l_proc, 5);
632: --
633: -- We must lock the row which we need to update.
634: --
635: per_psp_shd.lck
722: l_rec per_psp_shd.g_rec_type;
723: l_proc varchar2(72) := g_package||'upd';
724: --
725: Begin
726: hr_utility.set_location('Entering:'||l_proc, 5);
727: --
728: -- Call conversion function to turn arguments into the
729: -- l_rec structure.
730: --
782: ,l_rec
783: );
784: p_object_version_number := l_rec.object_version_number;
785: --
786: hr_utility.set_location(' Leaving:'||l_proc, 10);
787: End upd;
788: --
789: end per_psp_upd;