[Home] [Help]
77: l_person_extra_info_id per_people_extra_info.person_extra_info_id%type;
78:
79: --
80: begin
81: hr_utility.set_location('Entering:'|| l_proc, 5);
82: --
83: -- Issue a savepoint if operating in validation only mode.
84: --
85: savepoint ghr_create_person_extra_info;
160: --set all output variables
161:
162: p_person_extra_info_id := l_person_extra_info_id;
163: p_object_version_number := l_object_version_number;
164: hr_utility.set_location(' Leaving:'||l_proc, 11);
165: exception
166: when hr_api.validate_enabled then
167: --
168: -- As the Validate_Enabled exception has been raised
176: --
177: p_person_extra_info_id := null;
178: p_object_version_number := null;
179: --
180: hr_utility.set_location(' Leaving:'||l_proc, 12);
181: when others then
182: ROLLBACK TO ghr_create_person_extra_info;
183: raise;
184: end create_person_extra_info;
251: l_proc varchar2(72) := g_package||'update_person_extra_info';
252: l_object_version_number per_phones.object_version_number%TYPE;
253: --
254: begin
255: hr_utility.set_location('Entering:'|| l_proc, 5);
256: --
257: -- Issue a savepoint if operating in validation only mode.
258: --
259: savepoint ghr_update_person_extra_info;
320: p_object_version_number => p_object_version_number
321: );
322: --
323: --
324: hr_utility.set_location(l_proc, 7);
325: --
326: ghr_history_api.post_update_process;
327:
328: if p_validate then
328: if p_validate then
329: raise hr_api.validate_enabled;
330: end if;
331: --
332: hr_utility.set_location(' Leaving:'||l_proc, 11);
333: exception
334: when hr_api.validate_enabled then
335: --
336: -- As the Validate_Enabled exception has been raised
343: -- when validation only mode is being used.)
344: --
345: p_object_version_number := l_object_version_number;
346: --
347: hr_utility.set_location(' Leaving:'||l_proc, 12);
348: when others then
349: ROLLBACK TO ghr_update_person_extra_info;
350: raise;
351: end update_person_extra_info;