DBA Data[Home] [Help]

APPS.GHR_PRH_INS dependencies on GHR_PA_ROUTING_HISTORY

Line 59: -- Insert the row into: ghr_pa_routing_history

55: l_rec := p_rec;
56: p_rec.object_version_number := 1; -- Initialise the object version
57: --
58:
59: -- Insert the row into: ghr_pa_routing_history
60: --
61: insert into ghr_pa_routing_history
62: (pa_routing_history_id,
63: pa_request_id,

Line 61: insert into ghr_pa_routing_history

57: --
58:
59: -- Insert the row into: ghr_pa_routing_history
60: --
61: insert into ghr_pa_routing_history
62: (pa_routing_history_id,
63: pa_request_id,
64: attachment_modified_flag,
65: initiator_flag,

Line 184: Cursor C_Sel1 is select ghr_pa_routing_history_s.nextval from sys.dual;

180: --
181: l_proc varchar2(72);
182: l_rec ghr_prh_shd.g_rec_type;
183: --
184: Cursor C_Sel1 is select ghr_pa_routing_history_s.nextval from sys.dual;
185: --
186: Begin
187: l_proc := g_package||'pre_insert';
188: hr_utility.set_location('Entering:'||l_proc, 5);

Line 282: ( p_module_name => 'GHR_PA_ROUTING_HISTORY'

278:
279: exception
280: when hr_api.cannot_find_prog_unit then
281: hr_api.cannot_find_prog_unit_error
282: ( p_module_name => 'GHR_PA_ROUTING_HISTORY'
283: ,p_hook_type => 'AI'
284: );
285: end;
286: -- End of API User Hook for post_insert.