85: -- Declare cursors and local variables
86: --
87:
88: l_proc varchar2(72) := g_package||'create_election_candidate';
89: l_election_candidate_id per_election_candidates.election_candidate_id%TYPE;
90: l_object_version_number per_election_candidates.object_version_number%TYPE;
91: begin
92: hr_utility.set_location('Entering:'|| l_proc, 10);
93: --
86: --
87:
88: l_proc varchar2(72) := g_package||'create_election_candidate';
89: l_election_candidate_id per_election_candidates.election_candidate_id%TYPE;
90: l_object_version_number per_election_candidates.object_version_number%TYPE;
91: begin
92: hr_utility.set_location('Entering:'|| l_proc, 10);
93: --
94: -- Issue a savepoint
465: -- Declare cursors and local variables
466: --
467:
468: l_proc varchar2(72) := g_package||'create_election_candidate';
469: l_object_version_number per_election_candidates.object_version_number%TYPE;
470: l_ovn per_election_candidates.object_version_number%TYPE := p_object_version_number;
471:
472:
473: begin
466: --
467:
468: l_proc varchar2(72) := g_package||'create_election_candidate';
469: l_object_version_number per_election_candidates.object_version_number%TYPE;
470: l_ovn per_election_candidates.object_version_number%TYPE := p_object_version_number;
471:
472:
473: begin
474: hr_utility.set_location('Entering:'|| l_proc, 10);
774: --
775: -- Declare cursors and local variables
776: --
777: l_proc varchar2(72) := g_package||'delete_election_candidate';
778: l_object_version_number per_election_candidates.object_version_number%TYPE;
779: l_ovn per_election_candidates.object_version_number%TYPE := p_object_version_number;
780: --
781: begin
782: --
775: -- Declare cursors and local variables
776: --
777: l_proc varchar2(72) := g_package||'delete_election_candidate';
778: l_object_version_number per_election_candidates.object_version_number%TYPE;
779: l_ovn per_election_candidates.object_version_number%TYPE := p_object_version_number;
780: --
781: begin
782: --
783: hr_utility.set_location('Entering:'|| l_proc, 10);