[Home] [Help]
91: l_training_plan_cost_id number;
92: l_object_version_number number;
93: l_effective_date date;
94: begin
95: hr_utility.set_location('Entering:'|| l_proc, 10);
96: --
97: -- Issue a savepoint
98: --
99: savepoint create_cost;
359: --
360: p_training_plan_cost_id := l_training_plan_cost_id;
361: p_object_version_number := l_object_version_number;
362: --
363: hr_utility.set_location(' Leaving:'||l_proc, 70);
364: exception
365: when hr_api.validate_enabled then
366: --
367: -- As the Validate_Enabled exception has been raised
374: -- when validation only mode is being used.)
375: --
376: p_training_plan_cost_id := null;
377: p_object_version_number := null;
378: hr_utility.set_location(' Leaving:'||l_proc, 80);
379: when others then
380: --
381: -- A validation or unexpected error has occured
382: --
382: --
383: rollback to create_cost;
384: p_training_plan_cost_id := null;
385: p_object_version_number := null;
386: hr_utility.set_location(' Leaving:'||l_proc, 90);
387: raise;
388: end create_cost;
389: -- ----------------------------------------------------------------------------
390: -- |-------------------------< UPDATE_COST >----------------------------------|
466: l_proc varchar2(72) := g_package||' Update Cost';
467: l_object_version_number number := p_object_version_number;
468: l_effective_date date;
469: begin
470: hr_utility.set_location('Entering:'|| l_proc, 10);
471: --
472: -- Issue a savepoint
473: --
474: savepoint update_cost;
720: -- Set all output arguments
721: --
722: p_object_version_number := l_object_version_number;
723: --
724: hr_utility.set_location(' Leaving:'||l_proc, 70);
725: exception
726: when hr_api.validate_enabled then
727: --
728: -- As the Validate_Enabled exception has been raised
734: -- (Any key or derived arguments must be set to null
735: -- when validation only mode is being used.)
736: --
737: p_object_version_number := null;
738: hr_utility.set_location(' Leaving:'||l_proc, 80);
739: when others then
740: --
741: -- A validation or unexpected error has occured
742: --
741: -- A validation or unexpected error has occured
742: --
743: rollback to update_cost;
744: p_object_version_number := l_object_version_number;
745: hr_utility.set_location(' Leaving:'||l_proc, 90);
746: raise;
747: end update_cost;
748: --
749: -- ----------------------------------------------------------------------------
760: --
761: l_proc varchar2(72) := g_package||' Delete Cost';
762: --
763: begin
764: hr_utility.set_location('Entering:'|| l_proc, 10);
765: --
766: -- Issue a savepoint
767: --
768: savepoint delete_cost;
818: --
819: -- Set all output arguments
820: --
821: --
822: hr_utility.set_location(' Leaving:'||l_proc, 170);
823: exception
824: when hr_api.validate_enabled then
825: --
826: -- As the Validate_Enabled exception has been raised
831: -- Only set output warning arguments
832: -- (Any key or derived arguments must be set to null
833: -- when validation only mode is being used.)
834: --
835: hr_utility.set_location(' Leaving:'||l_proc, 180);
836: when others then
837: --
838: -- A validation or unexpected error has occured
839: --
837: --
838: -- A validation or unexpected error has occured
839: --
840: rollback to delete_cost;
841: hr_utility.set_location(' Leaving:'||l_proc, 190);
842: raise;
843: end delete_cost;
844: --
845: end ota_tpc_api;