85: l_object_version_number pqh_role_extra_info.object_version_number%type;
86: l_role_extra_info_id pqh_role_extra_info.role_extra_info_id%type;
87: --
88: begin
89: hr_utility.set_location('Entering:'|| l_proc, 5);
90: --
91: -- Issue a savepoint
92: --
93: savepoint create_role_extra_info;
170: );
171: end;
172: --
173: -- End of Before Process User Hook call
174: hr_utility.set_location(l_proc, 7);
175: --
176: -- Process Logic
177: --
178: pqh_rei_ins.ins
246: );
247: p_object_version_number := l_object_version_number;
248: p_role_extra_info_id := l_role_extra_info_id;
249: --
250: hr_utility.set_location(l_proc, 8);
251: --
252: -- Call After Process User Hook
253: --
254: begin
334: if p_validate then
335: raise hr_api.validate_enabled;
336: end if;
337: --
338: hr_utility.set_location(' Leaving:'||l_proc, 11);
339: exception
340: when hr_api.validate_enabled then
341: --
342: -- As the Validate_Enabled exception has been raised
350: --
351: p_role_extra_info_id := null;
352: p_object_version_number := null;
353: --
354: hr_utility.set_location(' Leaving:'||l_proc, 12);
355: --
356: when others then
357:
358: p_role_extra_info_id := null;
445: l_proc varchar2(72) := g_package||'update_role_extra_info';
446: l_object_version_number pqh_role_extra_info.object_version_number%TYPE;
447: --
448: begin
449: hr_utility.set_location('Entering:'|| l_proc, 5);
450: --
451: -- Issue a savepoint
452: --
453: savepoint update_role_extra_info;
531: end;
532: --
533: -- End of Before Process User Hook call
534: --
535: hr_utility.set_location(l_proc, 7);
536: --
537: -- Store the original ovn in case we rollback when p_validate is true
538: --
539: l_object_version_number := p_object_version_number;
607: ,p_object_version_number => p_object_version_number
608: ,p_validate => false
609: );
610: --
611: hr_utility.set_location(l_proc, 8);
612: --
613: -- Call After Process User Hook
614: --
615: begin
693: if p_validate then
694: raise hr_api.validate_enabled;
695: end if;
696: --
697: hr_utility.set_location(' Leaving:'||l_proc, 11);
698: exception
699: when hr_api.validate_enabled then
700: --
701: -- As the Validate_Enabled exception has been raised
708: -- when validation only mode is being used.)
709: --
710: p_object_version_number := l_object_version_number;
711: --
712: hr_utility.set_location(' Leaving:'||l_proc, 12);
713: --
714: when others then
715:
716: p_object_version_number := l_object_version_number;
740: --
741: l_proc varchar2(72) := g_package||'delete_role_extra_info';
742: --
743: begin
744: hr_utility.set_location('Entering:'|| l_proc, 5);
745: --
746: -- Issue a savepoint
747: --
748: savepoint delete_role_extra_info;
762: p_hook_type => 'BP'
763: );
764: end;
765: --
766: hr_utility.set_location(l_proc, 7);
767: --
768: -- Process Logic - Delete role Extra Info details
769: --
770: pqh_rei_del.del
772: ,p_object_version_number => p_object_version_number
773: ,p_validate => false
774: );
775: --
776: hr_utility.set_location(l_proc, 8);
777: --
778: -- Call After Process User Hook
779: --
780: begin
796: if p_validate then
797: raise hr_api.validate_enabled;
798: end if;
799: --
800: hr_utility.set_location(' Leaving:'||l_proc, 11);
801: exception
802: when hr_api.validate_enabled then
803: --
804: -- As the Validate_Enabled exception has been raised
805: -- we must rollback to the savepoint
806: --
807: ROLLBACK TO delete_role_extra_info;
808: --
809: hr_utility.set_location(' Leaving:'||l_proc, 12);
810: --
811: when others then
812: --
813: -- A validation or unexpected error has occurred