DBA Data[Home] [Help]

APPS.GHR_REI_INS dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 61: -- Insert the row into: ghr_pa_request_extra_info

57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: -- Insert the row into: ghr_pa_request_extra_info
62: --
63: insert into ghr_pa_request_extra_info
64: ( pa_request_extra_info_id,
65: pa_request_id,

Line 63: insert into ghr_pa_request_extra_info

59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: -- Insert the row into: ghr_pa_request_extra_info
62: --
63: insert into ghr_pa_request_extra_info
64: ( pa_request_extra_info_id,
65: pa_request_id,
66: information_type,
67: rei_attribute_category,

Line 246: Cursor C_Sel1 is select ghr_pa_request_extra_info_s.nextval from sys.dual;

242: -- ----------------------------------------------------------------------------
243: Procedure pre_insert(p_rec in out nocopy ghr_rei_shd.g_rec_type) is
244: --
245: l_proc varchar2(72) := g_package||'pre_insert';
246: Cursor C_Sel1 is select ghr_pa_request_extra_info_s.nextval from sys.dual;
247: --
248: --
249: --
250: Begin

Line 369: ( p_module_name => 'GHR_PA_REQUEST_EXTRA_INFO'

365: );
366: exception
367: when hr_api.cannot_find_prog_unit then
368: hr_api.cannot_find_prog_unit_error
369: ( p_module_name => 'GHR_PA_REQUEST_EXTRA_INFO'
370: ,p_hook_type => 'AI'
371: );
372: end;
373: -- End of API User Hook for post_insert.