50: --
51: -- When in validation only mode raise the Validate_Enabled exception
52: --
53: if p_validate then
54: raise hr_api.validate_enabled;
55: end if;
56: --
57: -- Set all output arguments
58: --
62: hr_utility.set_location(' Leaving:'||l_proc, 70);
63: --
64: exception
65: --
66: when hr_api.validate_enabled then
67: --
68: -- As the Validate_Enabled exception has been raised
69: -- we must rollback to the savepoint
70: --
97: --
98: procedure update_batch_ranges
99: (p_validate in boolean default false
100: ,p_range_id in number
101: ,p_benefit_action_id in number default hr_api.g_number
102: ,p_range_status_cd in varchar2 default hr_api.g_varchar2
103: ,p_starting_person_action_id in number default hr_api.g_number
104: ,p_ending_person_action_id in number default hr_api.g_number
105: ,p_object_version_number in out nocopy number
98: procedure update_batch_ranges
99: (p_validate in boolean default false
100: ,p_range_id in number
101: ,p_benefit_action_id in number default hr_api.g_number
102: ,p_range_status_cd in varchar2 default hr_api.g_varchar2
103: ,p_starting_person_action_id in number default hr_api.g_number
104: ,p_ending_person_action_id in number default hr_api.g_number
105: ,p_object_version_number in out nocopy number
106: ,p_effective_date in date) is
99: (p_validate in boolean default false
100: ,p_range_id in number
101: ,p_benefit_action_id in number default hr_api.g_number
102: ,p_range_status_cd in varchar2 default hr_api.g_varchar2
103: ,p_starting_person_action_id in number default hr_api.g_number
104: ,p_ending_person_action_id in number default hr_api.g_number
105: ,p_object_version_number in out nocopy number
106: ,p_effective_date in date) is
107: --
100: ,p_range_id in number
101: ,p_benefit_action_id in number default hr_api.g_number
102: ,p_range_status_cd in varchar2 default hr_api.g_varchar2
103: ,p_starting_person_action_id in number default hr_api.g_number
104: ,p_ending_person_action_id in number default hr_api.g_number
105: ,p_object_version_number in out nocopy number
106: ,p_effective_date in date) is
107: --
108: -- Declare cursors and local variables
137: --
138: -- When in validation only mode raise the Validate_Enabled exception
139: --
140: if p_validate then
141: raise hr_api.validate_enabled;
142: end if;
143: --
144: -- Set all output arguments
145: --
148: hr_utility.set_location(' Leaving:'||l_proc, 70);
149: --
150: exception
151: --
152: when hr_api.validate_enabled then
153: --
154: -- As the Validate_Enabled exception has been raised
155: -- we must rollback to the savepoint
156: --
208: --
209: -- When in validation only mode raise the Validate_Enabled exception
210: --
211: if p_validate then
212: raise hr_api.validate_enabled;
213: end if;
214: --
215: hr_utility.set_location(' Leaving:'||l_proc, 70);
216: --
215: hr_utility.set_location(' Leaving:'||l_proc, 70);
216: --
217: exception
218: --
219: when hr_api.validate_enabled then
220: --
221: -- As the Validate_Enabled exception has been raised
222: -- we must rollback to the savepoint
223: --