[Home] [Help]
75: l_object_version_number per_people_extra_info.object_version_number%type;
76: l_person_extra_info_id per_people_extra_info.person_extra_info_id%type;
77: --
78: begin
79: hr_utility.set_location('Entering:'|| l_proc, 5);
80: --
81: -- Issue a savepoint
82: --
83: savepoint create_person_extra_info;
150: end;
151: --
152: -- End of Before Process User Hook call
153: --
154: hr_utility.set_location(l_proc, 7);
155: --
156: -- Process Logic
157: --
158: pe_pei_ins.ins
216: );
217: p_object_version_number := l_object_version_number;
218: p_person_extra_info_id := l_person_extra_info_id;
219: --
220: hr_utility.set_location(l_proc, 8);
221: --
222: -- Call After Process User Hook
223: --
224: begin
295: if p_validate then
296: raise hr_api.validate_enabled;
297: end if;
298: --
299: hr_utility.set_location(' Leaving:'||l_proc, 11);
300: exception
301: when hr_api.validate_enabled then
302: --
303: -- As the Validate_Enabled exception has been raised
311: --
312: p_person_extra_info_id := null;
313: p_object_version_number := null;
314: --
315: hr_utility.set_location(' Leaving:'||l_proc, 12);
316: --
317: when others then
318: --
319: -- A validation or unexpected error has occurred
399: l_object_version_number per_phones.object_version_number%TYPE;
400: l_ovn per_phones.object_version_number%TYPE := p_object_version_number;
401: --
402: begin
403: hr_utility.set_location('Entering:'|| l_proc, 5);
404: --
405: -- Issue a savepoint
406: --
407: savepoint update_person_extra_info;
475: --
476: -- End of Before Process User Hook call
477: --
478: --
479: hr_utility.set_location(l_proc, 7);
480: --
481: -- Store the original ovn in case we rollback when p_validate is true
482: --
483: l_object_version_number := p_object_version_number;
541: ,p_object_version_number => p_object_version_number
542: ,p_validate => false
543: );
544: --
545: hr_utility.set_location(l_proc, 8);
546: --
547: -- Call After Process User Hook
548: --
549: begin
618: if p_validate then
619: raise hr_api.validate_enabled;
620: end if;
621: --
622: hr_utility.set_location(' Leaving:'||l_proc, 11);
623: exception
624: when hr_api.validate_enabled then
625: --
626: -- As the Validate_Enabled exception has been raised
633: -- when validation only mode is being used.)
634: --
635: p_object_version_number := l_object_version_number;
636: --
637: hr_utility.set_location(' Leaving:'||l_proc, 12);
638: --
639: when others then
640: --
641: -- A validation or unexpected error has occurred
667: --
668: l_proc varchar2(72) := g_package||'delete_person_extra_info';
669: --
670: begin
671: hr_utility.set_location('Entering:'|| l_proc, 5);
672: --
673: -- Issue a savepoint
674: --
675: savepoint delete_person_extra_info;
690: end;
691: --
692: -- End of Before Process User Hook call
693: --
694: hr_utility.set_location(l_proc, 7);
695: --
696: -- Process Logic - Delete Person Extra Info details
697: --
698: pe_pei_del.del
700: ,p_object_version_number => p_object_version_number
701: ,p_validate => false
702: );
703: --
704: hr_utility.set_location(l_proc, 8);
705: --
706: -- Call Before Process User Hook
707: --
708: begin
725: if p_validate then
726: raise hr_api.validate_enabled;
727: end if;
728: --
729: hr_utility.set_location(' Leaving:'||l_proc, 11);
730: exception
731: when hr_api.validate_enabled then
732: --
733: -- As the Validate_Enabled exception has been raised
734: -- we must rollback to the savepoint
735: --
736: ROLLBACK TO delete_person_extra_info;
737: --
738: hr_utility.set_location(' Leaving:'||l_proc, 12);
739: --
740: when others then
741: --
742: -- A validation or unexpected error has occurred