53: -- Declare cursors and local variables
54: --
55: --
56: l_proc varchar2(72) := g_package||'create_participant';
57: l_participant_id per_participants.participant_id%TYPE;
58: l_object_version_number per_participants.object_version_number%TYPE;
59: begin
60: hr_utility.set_location('Entering:'|| l_proc, 5);
61: --
54: --
55: --
56: l_proc varchar2(72) := g_package||'create_participant';
57: l_participant_id per_participants.participant_id%TYPE;
58: l_object_version_number per_participants.object_version_number%TYPE;
59: begin
60: hr_utility.set_location('Entering:'|| l_proc, 5);
61: --
62: -- Issue a savepoint.
302: -- Declare cursors and local variables
303: --
304:
305: l_proc varchar2(72) := g_package||'update_participant';
306: l_object_version_number per_participants.object_version_number%TYPE;
307: l_ovn per_participants.object_version_number%TYPE := p_object_version_number;
308: begin
309: hr_utility.set_location('Entering:'|| l_proc, 5);
310: --
303: --
304:
305: l_proc varchar2(72) := g_package||'update_participant';
306: l_object_version_number per_participants.object_version_number%TYPE;
307: l_ovn per_participants.object_version_number%TYPE := p_object_version_number;
308: begin
309: hr_utility.set_location('Entering:'|| l_proc, 5);
310: --
311: -- Issue a savepoint.