56: --
57: l_proc varchar2(72) := g_package||'delete_dml';
58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: --
62: per_fdl_shd.g_api_dml := true; -- Set the api dml status
63: --
64: -- Delete the per_fnd_doc_links row.
68: --
69: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
70:
71: --
72: hr_utility.set_location(' Leaving:'||l_proc, 10);
73: --
74: Exception
75: When hr_api.child_integrity_violated then
76: -- Child integrity has been violated
122: --
123: l_proc varchar2(72) := g_package||'pre_delete';
124: --
125: Begin
126: hr_utility.set_location('Entering:'||l_proc, 5);
127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 10);
129: End pre_delete;
130:
124: --
125: Begin
126: hr_utility.set_location('Entering:'||l_proc, 5);
127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 10);
129: End pre_delete;
130:
131: --
132: -- ----------------------------------------------------------------------------
166: --
167: l_proc varchar2(72) := g_package||'post_delete';
168: --
169: Begin
170: hr_utility.set_location('Entering:'||l_proc, 5);
171: begin
172:
173: -- For Future Use
174: /*
234: --
235: end;
236:
237: --
238: hr_utility.set_location(' Leaving:'||l_proc, 10);
239: End post_delete;
240:
241: --
242: -- ----------------------------------------------------------------------------
248: --
249: l_proc varchar2(72) := g_package||'del';
250: --
251: Begin
252: hr_utility.set_location('Entering:'||l_proc, 5);
253: --
254: -- We must lock the row which we need to delete.
255: --
256: per_fdl_shd.lck
294: l_rec per_fdl_shd.g_rec_type;
295: l_proc varchar2(72) := g_package||'del';
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: -- As the delete procedure accepts a plsql record structure we do need to
301: -- convert the arguments into the record structure.
302: -- We don't need to call the supplied conversion argument routine as we
310: -- business process
311: --
312: per_fdl_del.del(l_rec);
313: --
314: hr_utility.set_location(' Leaving:'||l_proc, 10);
315: End del;
316:
317: --
318: end per_fdl_del;