31: -- Declare cursors and local variables
32: --
33: l_effective_date date;
34: l_proc varchar2(72) := g_package||'create_successee_detail';
35: l_successee_detail_id per_sp_successee_details.successee_detail_id%TYPE;
36: l_object_version_number per_sp_successee_details.object_version_number%TYPE;
37: begin
38: hr_utility.set_location('Entering:'|| l_proc, 10);
39: --
32: --
33: l_effective_date date;
34: l_proc varchar2(72) := g_package||'create_successee_detail';
35: l_successee_detail_id per_sp_successee_details.successee_detail_id%TYPE;
36: l_object_version_number per_sp_successee_details.object_version_number%TYPE;
37: begin
38: hr_utility.set_location('Entering:'|| l_proc, 10);
39: --
40: -- Issue a savepoint
205: -- Declare cursors and local variables
206: --
207: l_effective_date date;
208: l_proc varchar2(72) := g_package||'update_successee_detail';
209: l_object_version_number per_sp_successee_details.object_version_number%TYPE;
210: begin
211: hr_utility.set_location('Entering:'|| l_proc, 10);
212: --
213: -- Issue a savepoint