DBA Data[Home] [Help]

APPS.GHR_PDH_INS dependencies on GHR_PD_ROUTING_HISTORY

Line 56: -- Insert the row into: ghr_pd_routing_history

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_pd_routing_history
57: --
58:
59: insert into ghr_pd_routing_history
60: (pd_routing_history_id,

Line 59: insert into ghr_pd_routing_history

55:
56: -- Insert the row into: ghr_pd_routing_history
57: --
58:
59: insert into ghr_pd_routing_history
60: (pd_routing_history_id,
61: position_description_id,
62: initiator_flag,
63: requester_flag,

Line 167: Cursor C_Sel1 is select ghr_pd_routing_history_s.nextval from sys.dual;

163: (p_rec in out NOCOPY ghr_pdh_shd.g_rec_type)is
164: --
165: l_proc varchar2(72) := g_package||'pre_insert';
166: --
167: Cursor C_Sel1 is select ghr_pd_routing_history_s.nextval from sys.dual;
168: --
169: Begin
170: hr_utility.set_location('Entering:'||l_proc, 5);
171: --

Line 252: ( p_module_name => 'GHR_PD_ROUTING_HISTORY'

248:
249: exception
250: when hr_api.cannot_find_prog_unit then
251: hr_api.cannot_find_prog_unit_error
252: ( p_module_name => 'GHR_PD_ROUTING_HISTORY'
253: ,p_hook_type => 'AI'
254: );
255: end;
256: -- End of API User Hook for post_insert.