[Home] [Help]
34: l_end_date date;
35: l_key varchar2(1);
36: --
37: begin
38: hr_utility.set_location('Entering:'|| l_proc, 10);
39: --
40: -- Issue a savepoint
41: --
42: savepoint update_ame_config_variable;
119: --
120: p_start_date := l_start_date;
121: p_end_date := l_end_date;
122: --
123: hr_utility.set_location(' Leaving:'||l_proc, 70);
124: exception
125: when hr_api.validate_enabled then
126: --
127: -- As the Validate_Enabled exception has been raised
136: p_object_version_number := l_object_version_number;
137: p_start_date := null;
138: p_end_date := null;
139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 80);
141: when others then
142: --
143: -- A validation or unexpected error has occured
144: --
150: p_object_version_number := l_object_version_number;
151: p_start_date := null;
152: p_end_date := null;
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 90);
155: raise;
156: end update_ame_config_variable;
157: --
158: --
176: l_start_date date;
177: l_end_date date;
178: --
179: begin
180: hr_utility.set_location('Entering:'|| l_proc, 10);
181: --
182: -- Issue a savepoint
183: --
184: savepoint delete_ame_config_variable;
242: --
243: p_start_date := l_start_date;
244: p_end_date := l_end_date;
245: --
246: hr_utility.set_location(' Leaving:'||l_proc, 70);
247: exception
248: when hr_api.validate_enabled then
249: --
250: -- As the Validate_Enabled exception has been raised
259: p_object_version_number := l_object_version_number;
260: p_start_date := null;
261: p_end_date := null;
262: --
263: hr_utility.set_location(' Leaving:'||l_proc, 80);
264: when others then
265: --
266: -- A validation or unexpected error has occured
267: --
273: p_object_version_number := l_object_version_number;
274: p_start_date := null;
275: p_end_date := null;
276: --
277: hr_utility.set_location(' Leaving:'||l_proc, 90);
278: raise;
279: end delete_ame_config_variable;
280: end AME_CONFIG_VAR_API;