46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52:
53: -- Delete the ghr_pd_routing_history row.
54: --
55: delete from ghr_pd_routing_history
56: where pd_routing_history_id = p_rec.pd_routing_history_id;
57: --
58:
59: hr_utility.set_location(' Leaving:'||l_proc, 10);
60: --
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated
103: --
104: l_proc varchar2(72) := g_package||'pre_delete';
105: --
106: Begin
107: hr_utility.set_location('Entering:'||l_proc, 5);
108: --
109: hr_utility.set_location(' Leaving:'||l_proc, 10);
110: End pre_delete;
111: --
105: --
106: Begin
107: hr_utility.set_location('Entering:'||l_proc, 5);
108: --
109: hr_utility.set_location(' Leaving:'||l_proc, 10);
110: End pre_delete;
111: --
112: -- ----------------------------------------------------------------------------
113: -- |-----------------------------< post_delete >------------------------------|
145: --
146: l_proc varchar2(72) := g_package||'post_delete';
147: --
148: Begin
149: hr_utility.set_location('Entering:'||l_proc, 5);
150: --
151: -- This is a hook point and the user hook for post_delete is called here.
152: --
153: begin
181: ,p_hook_type => 'AD'
182: );
183: end;
184: -- End of API User Hook for post_delete.
185: hr_utility.set_location(' Leaving:'||l_proc, 10);
186: End post_delete;
187: --
188: -- ----------------------------------------------------------------------------
189: -- |---------------------------------< del >----------------------------------|
196: --
197: l_proc varchar2(72) := g_package||'del';
198: --
199: Begin
200: hr_utility.set_location('Entering:'||l_proc, 5);
201: --
202: -- Determine if the business process is to be validated.
203: --
204: If p_validate then
237: If p_validate then
238: Raise HR_Api.Validate_Enabled;
239: End If;
240: --
241: hr_utility.set_location(' Leaving:'||l_proc, 10);
242: Exception
243: When HR_Api.Validate_Enabled Then
244: --
245: -- As the Validate_Enabled exception has been raised
261: l_rec ghr_pdh_shd.g_rec_type;
262: l_proc varchar2(72) := g_package||'del';
263: --
264: Begin
265: hr_utility.set_location('Entering:'||l_proc, 5);
266: --
267: -- As the delete procedure accepts a plsql record structure we do need to
268: -- convert the arguments into the record structure.
269: -- We don't need to call the supplied conversion argument routine as we
277: -- business process
278: --
279: del(l_rec, p_validate);
280: --
281: hr_utility.set_location(' Leaving:'||l_proc, 10);
282: End del;
283: --
284: end ghr_pdh_del;