46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: -- Delete the per_assessments row.
53: --
54: delete from per_assessments
53: --
54: delete from per_assessments
55: where assessment_id = p_rec.assessment_id;
56: --
57: hr_utility.set_location(' Leaving:'||l_proc, 10);
58: --
59: Exception
60: When hr_api.child_integrity_violated then
61: -- Child integrity has been violated
101: --
102: l_proc varchar2(72) := g_package||'pre_delete';
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: hr_utility.set_location(' Leaving:'||l_proc, 10);
108: End pre_delete;
109: --
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: hr_utility.set_location(' Leaving:'||l_proc, 10);
108: End pre_delete;
109: --
110: -- ----------------------------------------------------------------------------
111: -- |-----------------------------< post_delete >------------------------------|
143: --
144: l_proc varchar2(72) := g_package||'post_delete';
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: -- This is a hook point and the user hook for post_delete is called here.
150: --
151: begin
197: );
198: end;
199: -- End of API User Hook for post_delete.
200: --
201: hr_utility.set_location(' Leaving:'||l_proc, 10);
202: End post_delete;
203: --
204: -- ----------------------------------------------------------------------------
205: -- |---------------------------------< del >----------------------------------|
212: --
213: l_proc varchar2(72) := g_package||'del';
214: --
215: Begin
216: hr_utility.set_location('Entering:'||l_proc, 5);
217: --
218: -- Determine if the business process is to be validated.
219: --
220: If p_validate then
263: If p_validate then
264: Raise HR_Api.Validate_Enabled;
265: End If;
266: --
267: hr_utility.set_location(' Leaving:'||l_proc, 10);
268: Exception
269: When HR_Api.Validate_Enabled Then
270: --
271: -- As the Validate_Enabled exception has been raised
287: l_rec per_asn_shd.g_rec_type;
288: l_proc varchar2(72) := g_package||'del';
289: --
290: Begin
291: hr_utility.set_location('Entering:'||l_proc, 5);
292: --
293: -- As the delete procedure accepts a plsql record structure we do need to
294: -- convert the arguments into the record structure.
295: -- We don't need to call the supplied conversion argument routine as we
303: -- business process
304: --
305: del(l_rec, p_validate);
306: --
307: hr_utility.set_location(' Leaving:'||l_proc, 10);
308: End del;
309: --
310: end per_asn_del;