[Home] [Help]
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
95: --
96: savepoint create_election_candidate;
351: --
352: p_election_candidate_id := l_election_candidate_id;
353: p_object_version_number := l_object_version_number;
354: --
355: hr_utility.set_location(' Leaving:'||l_proc, 70);
356: exception
357: when hr_api.validate_enabled then
358: --
359: -- As the Validate_Enabled exception has been raised
366: -- when validation only mode is being used.)
367: --
368: p_election_candidate_id := null;
369: p_object_version_number := null;
370: hr_utility.set_location(' Leaving:'||l_proc, 80);
371: when others then
372: --
373: -- A validation or unexpected error has occured
374: --
378: --
379: p_election_candidate_id := null;
380: p_object_version_number := null;
381: --
382: hr_utility.set_location(' Leaving:'||l_proc, 90);
383: raise;
384: end create_election_candidate;
385: --
386:
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);
475: --
476: -- Issue a savepoint
477: --
478: savepoint update_election_candidate;
733: -- Set all output arguments
734: --
735: p_object_version_number := l_object_version_number;
736: --
737: hr_utility.set_location(' Leaving:'||l_proc, 70);
738: exception
739: when hr_api.validate_enabled then
740: --
741: -- As the Validate_Enabled exception has been raised
747: -- (Any key or derived arguments must be set to null
748: -- when validation only mode is being used.)
749: --
750: p_object_version_number := null;
751: hr_utility.set_location(' Leaving:'||l_proc, 80);
752: when others then
753: --
754: -- A validation or unexpected error has occured
755: --
758: -- set in out parameters and set out parameters
759: --
760: p_object_version_number := l_ovn;
761: --
762: hr_utility.set_location(' Leaving:'||l_proc, 90);
763: raise;
764: end update_election_candidate;
765: --
766: -- |---------------------------< delete_election_candidate >--------------------------|
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);
784: --
785: -- Issue a savepoint if operating in validation only mode
786: --
787: savepoint delete_election_candidate;
785: -- Issue a savepoint if operating in validation only mode
786: --
787: savepoint delete_election_candidate;
788: --
789: hr_utility.set_location(l_proc, 20);
790: --
791: -- Process Logic
792: --
793: hr_utility.set_location(l_proc, 30);
789: hr_utility.set_location(l_proc, 20);
790: --
791: -- Process Logic
792: --
793: hr_utility.set_location(l_proc, 30);
794: --
795: l_object_version_number := p_object_version_number;
796: --
797: begin
835: );
836: --
837: end;
838: --
839: hr_utility.set_location(l_proc, 60);
840: --
841: -- When in validation only mode raise the Validate_Enabled exception
842: --
843: p_object_version_number := l_object_version_number;
849: -- Set all output arguments (returned by some dt modes only)
850: --
851: p_object_version_number := l_object_version_number;
852: --
853: hr_utility.set_location(' Leaving:'||l_proc, 70);
854: --
855: exception
856: --
857: when hr_api.validate_enabled then