[Home] [Help]
85: l_person_extra_info_id per_people_extra_info.person_extra_info_id%type;
86: l_business_group_id per_all_people_f.business_group_id%type; --- for the bug 4943224
87: --
88: begin
89: hr_utility.set_location('Entering:'|| l_proc, 5);
90:
91: /*---------------------- Start for bug 4943224 ------------------------------------*/
92: open cur_per_person_id (p_person_id);
93: fetch cur_per_person_id into l_business_group_id;
174: end;
175: --
176: -- End of Before Process User Hook call
177: --
178: hr_utility.set_location(l_proc, 7);
179: --
180: -- Process Logic
181: --
182: pe_pei_ins.ins
240: );
241: p_object_version_number := l_object_version_number;
242: p_person_extra_info_id := l_person_extra_info_id;
243: --
244: hr_utility.set_location(l_proc, 8);
245: --
246: -- Call After Process User Hook
247: --
248: begin
319: if p_validate then
320: raise hr_api.validate_enabled;
321: end if;
322: --
323: hr_utility.set_location(' Leaving:'||l_proc, 11);
324: exception
325: when hr_api.validate_enabled then
326: --
327: -- As the Validate_Enabled exception has been raised
335: --
336: p_person_extra_info_id := null;
337: p_object_version_number := null;
338: --
339: hr_utility.set_location(' Leaving:'||l_proc, 12);
340: --
341: when others then
342: --
343: -- A validation or unexpected error has occurred
423: l_object_version_number per_phones.object_version_number%TYPE;
424: l_ovn per_phones.object_version_number%TYPE := p_object_version_number;
425: --
426: begin
427: hr_utility.set_location('Entering:'|| l_proc, 5);
428: --
429: -- Issue a savepoint
430: --
431: savepoint update_person_extra_info;
499: --
500: -- End of Before Process User Hook call
501: --
502: --
503: hr_utility.set_location(l_proc, 7);
504: --
505: -- Store the original ovn in case we rollback when p_validate is true
506: --
507: l_object_version_number := p_object_version_number;
565: ,p_object_version_number => p_object_version_number
566: ,p_validate => false
567: );
568: --
569: hr_utility.set_location(l_proc, 8);
570: --
571: -- Call After Process User Hook
572: --
573: begin
642: if p_validate then
643: raise hr_api.validate_enabled;
644: end if;
645: --
646: hr_utility.set_location(' Leaving:'||l_proc, 11);
647: exception
648: when hr_api.validate_enabled then
649: --
650: -- As the Validate_Enabled exception has been raised
657: -- when validation only mode is being used.)
658: --
659: p_object_version_number := l_object_version_number;
660: --
661: hr_utility.set_location(' Leaving:'||l_proc, 12);
662: --
663: when others then
664: --
665: -- A validation or unexpected error has occurred
691: --
692: l_proc varchar2(72) := g_package||'delete_person_extra_info';
693: --
694: begin
695: hr_utility.set_location('Entering:'|| l_proc, 5);
696: --
697: -- Issue a savepoint
698: --
699: savepoint delete_person_extra_info;
714: end;
715: --
716: -- End of Before Process User Hook call
717: --
718: hr_utility.set_location(l_proc, 7);
719: --
720: -- Process Logic - Delete Person Extra Info details
721: --
722: pe_pei_del.del
724: ,p_object_version_number => p_object_version_number
725: ,p_validate => false
726: );
727: --
728: hr_utility.set_location(l_proc, 8);
729: --
730: -- Call Before Process User Hook
731: --
732: begin
749: if p_validate then
750: raise hr_api.validate_enabled;
751: end if;
752: --
753: hr_utility.set_location(' Leaving:'||l_proc, 11);
754: exception
755: when hr_api.validate_enabled then
756: --
757: -- As the Validate_Enabled exception has been raised
758: -- we must rollback to the savepoint
759: --
760: ROLLBACK TO delete_person_extra_info;
761: --
762: hr_utility.set_location(' Leaving:'||l_proc, 12);
763: --
764: when others then
765: --
766: -- A validation or unexpected error has occurred