[Home] [Help]
52: --
53: l_proc VARCHAR2(72) := g_package||'delete_dml';
54: --
55: BEGIN
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: hr_loc_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the location row.
63: WHERE location_id = p_rec.location_id;
64: --
65: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: EXCEPTION
70: WHEN hr_api.child_integrity_violated THEN
71: -- Child integrity has been violated
113: --
114: l_proc VARCHAR2(72) := g_package||'pre_delete';
115: --
116: BEGIN
117: hr_utility.set_location('Entering:'||l_proc, 5);
118: --
119: hr_utility.set_location(' Leaving:'||l_proc, 10);
120: END pre_delete;
121: --
115: --
116: BEGIN
117: hr_utility.set_location('Entering:'||l_proc, 5);
118: --
119: hr_utility.set_location(' Leaving:'||l_proc, 10);
120: END pre_delete;
121: --
122: -- ----------------------------------------------------------------------------
123: -- |-----------------------------< post_delete >------------------------------|
155: --
156: l_proc VARCHAR2(72) := g_package||'post_delete';
157: --
158: BEGIN
159: hr_utility.set_location('Entering:'||l_proc, 5);
160: --
161: --
162: -- Start of API User Hook for the after delete hook
163: --
254: --
255: -- End of API User Hook for the after_delete hook
256: --
257: --
258: hr_utility.set_location(' Leaving:'||l_proc, 10);
259: END post_delete;
260: --
261: -- ----------------------------------------------------------------------------
262: -- |---------------------------------< del >----------------------------------|
309: --
310: l_proc VARCHAR2(72) := g_package||'del';
311: --
312: BEGIN
313: hr_utility.set_location('Entering:'||l_proc, 5);
314: --
315: -- We must lock the row which we need to delete.
316: --
317: hr_loc_shd.lck ( p_rec.location_id,
315: -- We must lock the row which we need to delete.
316: --
317: hr_loc_shd.lck ( p_rec.location_id,
318: p_rec.object_version_number );
319: hr_utility.set_location(l_proc, 10);
320: --
321: -- Call the supporting delete validate operation
322: --
323: hr_loc_bus.delete_validate( p_rec => p_rec );
320: --
321: -- Call the supporting delete validate operation
322: --
323: hr_loc_bus.delete_validate( p_rec => p_rec );
324: hr_utility.set_location(l_proc, 15);
325: --
326: -- Call the supporting pre-delete operation
327: --
328: pre_delete(p_rec);
325: --
326: -- Call the supporting pre-delete operation
327: --
328: pre_delete(p_rec);
329: hr_utility.set_location(l_proc, 20);
330: --
331: -- Delete the row.
332: --
333: delete_dml(p_rec);
330: --
331: -- Delete the row.
332: --
333: delete_dml(p_rec);
334: hr_utility.set_location(l_proc, 25);
335: --
336: -- Call the supporting post-delete operation
337: --
338: post_delete(p_rec);
336: -- Call the supporting post-delete operation
337: --
338: post_delete(p_rec);
339: --
340: hr_utility.set_location(' Leaving:'||l_proc, 35);
341:
342: END del;
343: --
344: -- ----------------------------------------------------------------------------
388: l_rec hr_loc_shd.g_rec_type;
389: l_proc VARCHAR2(72) := g_package||'del';
390: --
391: BEGIN
392: hr_utility.set_location('Entering:'||l_proc, 5);
393: --
394: -- As the delete procedure accepts a plsql record structure we do need to
395: -- convert the arguments into the record structure.
396: -- We don't need to call the supplied conversion argument routine as we
404: -- business process
405: --
406: del(p_rec => l_rec );
407: --
408: hr_utility.set_location(' Leaving:'||l_proc, 10);
409: END del;
410: --
411: END hr_loc_del;