DBA Data[Home] [Help]

APPS.GHR_PAR_INS dependencies on GHR_PA_REQUESTS

Line 56: -- Insert the row into: ghr_pa_requests

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,

Line 58: insert into ghr_pa_requests

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,

Line 576: Cursor C_Sel1 is select ghr_pa_requests_s.nextval from sys.dual;

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

Line 860: ( p_module_name => 'GHR_PA_REQUESTS'

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.