55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
140: where maternity_id = p_rec.maternity_id;
141: --
142: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
143: --
144: hr_utility.set_location(' Leaving:'||l_proc, 10);
145: --
146: Exception
147: When hr_api.check_integrity_violated Then
148: -- A check constraint has been violated
200: --
201: l_proc varchar2(72) := g_package||'pre_update';
202: --
203: Begin
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: hr_utility.set_location(' Leaving:'||l_proc, 10);
207: End pre_update;
208: --
202: --
203: Begin
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: hr_utility.set_location(' Leaving:'||l_proc, 10);
207: End pre_update;
208: --
209: -- ----------------------------------------------------------------------------
210: -- |-----------------------------< post_update >------------------------------|
242: --
243: l_proc varchar2(72) := g_package||'post_update';
244: --
245: Begin
246: hr_utility.set_location('Entering:'||l_proc, 5);
247: --
248: hr_utility.set_location(' Leaving:'||l_proc, 10);
249: End post_update;
250: --
244: --
245: Begin
246: hr_utility.set_location('Entering:'||l_proc, 5);
247: --
248: hr_utility.set_location(' Leaving:'||l_proc, 10);
249: End post_update;
250: --
251: -- ----------------------------------------------------------------------------
252: -- |-----------------------------< convert_defs >-----------------------------|
297: l_proc varchar2(72) := g_package||'convert_defs';
298: --
299: Begin
300: --
301: hr_utility.set_location('Entering:'||l_proc, 5);
302: --
303: -- We must now examine each argument value in the
304: -- p_rec plsql record structure
305: -- to see if a system default is being used. If a system default
590: p_rec.mat_information30 :=
591: ssp_mat_shd.g_old_rec.mat_information30;
592: End If;
593: --
594: hr_utility.set_location(' Leaving:'||l_proc, 10);
595: --
596: End convert_defs;
597: --
598: -- ----------------------------------------------------------------------------
606: --
607: l_proc varchar2(72) := g_package||'upd';
608: --
609: Begin
610: hr_utility.set_location('Entering:'||l_proc, 5);
611: --
612: -- Determine if the business process is to be validated.
613: --
614: If p_validate then
652: If p_validate then
653: Raise HR_Api.Validate_Enabled;
654: End If;
655: --
656: hr_utility.set_location(' Leaving:'||l_proc, 10);
657: Exception
658: When HR_Api.Validate_Enabled Then
659: --
660: -- As the Validate_Enabled exception has been raised
744: l_rec ssp_mat_shd.g_rec_type;
745: l_proc varchar2(72) := g_package||'upd';
746: --
747: Begin
748: hr_utility.set_location('Entering:'||l_proc, 5);
749: --
750: -- Call conversion function to turn arguments into the
751: -- l_rec structure.
752: --
832: --
833: upd(l_rec, p_validate);
834: p_object_version_number := l_rec.object_version_number;
835: --
836: hr_utility.set_location(' Leaving:'||l_proc, 10);
837: End upd;
838: --
839: end ssp_mat_upd;