52: hr_utility.set_location('Entering:'||l_proc, 5);
53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55: --
56: -- Insert the row into: ghr_pa_requests
57: --
58: insert into ghr_pa_requests
59: ( pa_request_id,
60: pa_notification_id,
54: --
55: --
56: -- Insert the row into: ghr_pa_requests
57: --
58: insert into ghr_pa_requests
59: ( pa_request_id,
60: pa_notification_id,
61: noa_family_code,
62: routing_group_id,
572: --
573: --
574: --
575: --
576: Cursor C_Sel1 is select ghr_pa_requests_s.nextval from sys.dual;
577: --
578: Begin
579: hr_utility.set_location('Entering:'||l_proc, 5);
580: if p_rec.pa_request_id is null then
856: );
857: exception
858: when hr_api.cannot_find_prog_unit then
859: hr_api.cannot_find_prog_unit_error
860: ( p_module_name => 'GHR_PA_REQUESTS'
861: ,p_hook_type => 'AI'
862: );
863: end;
864: -- End of API User Hook for post_insert.