[Home] [Help]
59: --
60: --
61: ghr_pah_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: ghr_pa_history
64: --
65: insert into ghr_pa_history
66: ( pa_history_id,
67: pa_request_id,
61: ghr_pah_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: ghr_pa_history
64: --
65: insert into ghr_pa_history
66: ( pa_history_id,
67: pa_request_id,
68: process_date,
69: nature_of_action_id,
553: Procedure pre_insert(p_rec in out nocopy ghr_pah_shd.g_rec_type) is
554: --
555: l_proc varchar2(72) := g_package||'pre_insert';
556: --
557: Cursor C_Sel1 is select ghr_pa_history_s.nextval from sys.dual;
558: --
559: Begin
560: hr_utility.set_location('Entering:'||l_proc, 5);
561: --
826: );
827: exception
828: when hr_api.cannot_find_prog_unit then
829: hr_api.cannot_find_prog_unit_error
830: ( p_module_name => 'GHR_PA_HISTORY'
831: ,p_hook_type => 'AI'
832: );
833: end;
834: -- End of API User Hook for post_insert.