118: l_noa_family_code ghr_pa_requests.noa_family_code%type;
119:
120: begin
121: l_proc := g_package||'create_pa_request_extra_info';
122: hr_utility.set_location('Entering:'|| l_proc, 5);
123: --
124: savepoint create_pa_request_extra_info;
125: --
126: --
192: end;
193: --
194: -- End of Before Process User Hook call
195: --
196: hr_utility.set_location(l_proc, 7);
197: -- Validation
198:
199: FOR l_cur_noa_family_code IN c_noa_family_code(p_pa_request_id) LOOP
200: l_noa_family_code := l_cur_noa_family_code.noa_family_code;
301: ,p_object_version_number => p_object_version_number
302: ,p_validate => false
303: );
304: --
305: hr_utility.set_location(l_proc, 8);
306: --
307: --
308: -- Call After Process User Hook
309: --
382: if p_validate then
383: raise hr_api.validate_enabled;
384: end if;
385: --
386: hr_utility.set_location(' Leaving:'||l_proc, 11);
387: exception
388: when hr_api.validate_enabled then
389: --
390: -- As the Validate_Enabled exception has been raised
402: when others then
403: ROLLBACK TO create_pa_request_extra_info;
404: p_pa_request_extra_info_id := null;
405: p_object_version_number := null;
406: hr_utility.set_location(' Leaving:'||l_proc, 12);
407: raise;
408:
409: end create_pa_request_extra_info;
410: --
491: WHERE pa_request_extra_info_id = c_pa_req_extra_info_id;
492:
493: begin
494: l_proc := g_package||'update_pa_request_extra_info';
495: hr_utility.set_location('Entering:'|| l_proc, 5);
496: l_obj_version_number := p_object_version_number;
497: --
498: savepoint update_pa_request_extra_info;
499: --
567: end;
568: --
569: -- End of Before Process User Hook call
570: --
571: hr_utility.set_location(l_proc, 7);
572: --
573: -- Store the original ovn in case we rollback when p_validate is true
574: --
575: l_object_version_number := p_object_version_number;
684: ,p_object_version_number => p_object_version_number
685: ,p_validate => false
686: );
687: --
688: hr_utility.set_location(l_proc, 8);
689: --
690: --
691: -- Call After Process User Hook
692: --
764: if p_validate then
765: raise hr_api.validate_enabled;
766: end if;
767: --
768: hr_utility.set_location(' Leaving:'||l_proc, 11);
769: exception
770: when hr_api.validate_enabled then
771: --
772: -- As the Validate_Enabled exception has been raised
785: ROLLBACK TO update_pa_request_extra_info;
786: p_object_version_number := l_obj_version_number; -- NOCOPY Changes
787: raise;
788: --
789: hr_utility.set_location(' Leaving:'||l_proc, 12);
790: end update_pa_request_extra_info;
791: --
792: --
793: -- ----------------------------------------------------------------------------
805: l_proc varchar2(72);
806: --
807: begin
808: l_proc := g_package||'delete_pa_request_extra_info';
809: hr_utility.set_location('Entering:'|| l_proc, 5);
810: --
811: savepoint delete_pa_request_extra_info;
812: --
813: --
827: end;
828: --
829: -- End of Before Process User Hook call
830: --
831: hr_utility.set_location(l_proc, 7);
832: --
833: -- Process Logic - Delete pa_request Extra Info details
834: --
835: ghr_rei_del.del
837: ,p_object_version_number => p_object_version_number
838: ,p_validate => false
839: );
840: --
841: hr_utility.set_location(l_proc, 8);
842: --
843: --
844: -- Call After Process User Hook
845: --
863: if p_validate then
864: raise hr_api.validate_enabled;
865: end if;
866: --
867: hr_utility.set_location(' Leaving:'||l_proc, 11);
868: exception
869: when hr_api.validate_enabled then
870: --
871: -- As the Validate_Enabled exception has been raised
876: when others then
877: ROLLBACK TO delete_pa_request_extra_info;
878: raise;
879:
880: hr_utility.set_location(' Leaving:'||l_proc, 12);
881: end delete_pa_request_extra_info;
882: --
883: --
884:
962: IF p_information_type = 'GHR_US_PAR_BENEFITS' THEN
963:
964: IF p_ben_ei_validate = 'TRUE' THEN
965: -- Get PA Request Record details
966: hr_utility.set_location('---------------- Validation starts-------------------------------',1234);
967: FOR l_cur_pa_req IN c_get_pa_req(p_pa_request_id) LOOP
968: l_retirement_plan := l_cur_pa_req.retirement_plan;
969: l_pa_request_id := l_cur_pa_req.pa_request_id;
970: l_effective_date := l_cur_pa_req.effective_date;