[Home] [Help]
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;
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: hr_utility.set_location(l_proc, 6);
66: per_add_shd.g_api_dml := true; -- Set the api dml status
67: --
68: hr_utility.set_location(l_proc, 7);
69: -- Update the per_addresses Row
64: --
65: hr_utility.set_location(l_proc, 6);
66: per_add_shd.g_api_dml := true; -- Set the api dml status
67: --
68: hr_utility.set_location(l_proc, 7);
69: -- Update the per_addresses Row
70: --
71: update per_addresses
72: set
133: -- End of fix for Bug #2431588
134: style = p_rec.style
135: where address_id = p_rec.address_id;
136: --
137: hr_utility.set_location(l_proc, 8);
138: per_add_shd.g_api_dml := false; -- Unset the api dml status
139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 10);
141: --
136: --
137: hr_utility.set_location(l_proc, 8);
138: per_add_shd.g_api_dml := false; -- Unset the api dml status
139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 10);
141: --
142: Exception
143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
196: --
197: l_proc varchar2(72) := g_package||'pre_update';
198: --
199: Begin
200: hr_utility.set_location('Entering:'||l_proc, 5);
201: --
202: --
203: -- WWBUG 2203479.
204: -- Removed for irecruitment
222: ,country => p_rec.country
223: );
224: end if;
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 10);
227: End pre_update;
228: --
229: -- ----------------------------------------------------------------------------
230: -- |-----------------------------< post_update >------------------------------|
277: --
278: -- End of Fix for WWBUG 1408379
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: -- Start of API User Hook for post_update.
284: begin
285: per_add_rku.after_update
487: --
488: --
489: -- End of API User Hook for post_update.
490: --
491: hr_utility.set_location(' Leaving:'||l_proc, 10);
492: End post_update;
493: --
494: -- ----------------------------------------------------------------------------
495: -- |-----------------------------< convert_defs >-----------------------------|
540: l_proc varchar2(72) := g_package||'convert_defs';
541: --
542: Begin
543: --
544: hr_utility.set_location('Entering:'||l_proc, 5);
545: --
546: -- We must now examine each argument value in the
547: -- p_rec plsql record structure
548: -- to see if a system default is being used. If a system default
767:
768: --
769: -- Return the plsql record structure.
770: --
771: hr_utility.set_location(' Leaving:'||l_proc, 10);
772: Return(p_rec);
773: --
774: End convert_defs;
775: --
787: l_proc varchar2(72) := g_package||'upd';
788: l_convert per_add_shd.g_rec_type;
789: --
790: Begin
791: hr_utility.set_location('Entering:'||l_proc, 5);
792: --
793: -- Determine if the business process is to be validated.
794: --
795: If p_validate then
847: If p_validate then
848: Raise HR_Api.Validate_Enabled;
849: End If;
850: --
851: hr_utility.set_location(' Leaving:'||l_proc, 10);
852: Exception
853: When HR_Api.Validate_Enabled Then
854: --
855: -- As the Validate_Enabled exception has been raised
932: l_rec per_add_shd.g_rec_type;
933: l_proc varchar2(72) := g_package||'upd';
934: --
935: Begin
936: hr_utility.set_location('Entering:'||l_proc, 5);
937: --
938: -- Call conversion function to turn arguments into the
939: -- l_rec structure.
940: --
1016: ,p_validate_county
1017: );
1018: p_object_version_number := l_rec.object_version_number;
1019: --
1020: hr_utility.set_location(' Leaving:'||l_proc, 10);
1021: End upd;
1022: --
1023: end per_add_upd;