52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: --
59: -- Delete the per_salary_surveys row.
60: --
61: delete from per_salary_surveys
62: where salary_survey_id = p_rec.salary_survey_id;
63: --
64: --
65: hr_utility.set_location(' Leaving:'||l_proc, 10);
66: --
67: Exception
68: When hr_api.child_integrity_violated then
69: -- Child integrity has been violated
109: --
110: l_proc varchar2(72) := g_package||'pre_delete';
111: --
112: Begin
113: hr_utility.set_location('Entering:'||l_proc, 5);
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: End pre_delete;
117: --
111: --
112: Begin
113: hr_utility.set_location('Entering:'||l_proc, 5);
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: End pre_delete;
117: --
118: -- ----------------------------------------------------------------------------
119: -- |-----------------------------< post_delete >------------------------------|
151: --
152: l_proc varchar2(72) := g_package||'post_delete';
153: --
154: Begin
155: hr_utility.set_location('Entering:'||l_proc, 5);
156: --
157: begin
158: per_pss_rkd.after_delete
159: (p_salary_survey_id
223: ,p_hook_type => 'AD'
224: );
225: end;
226: --
227: hr_utility.set_location(' Leaving:'||l_proc, 10);
228: --
229: End post_delete;
230: --
231: -- ----------------------------------------------------------------------------
238: --
239: l_proc varchar2(72) := g_package||'del';
240: --
241: Begin
242: hr_utility.set_location('Entering:'||l_proc, 5);
243: --
244: -- We must lock the row which we need to delete.
245: --
246: per_pss_shd.lck
278: l_rec per_pss_shd.g_rec_type;
279: l_proc varchar2(72) := g_package||'del';
280: --
281: Begin
282: hr_utility.set_location('Entering:'||l_proc, 5);
283: --
284: -- As the delete procedure accepts a plsql record structure we do need to
285: -- convert the arguments into the record structure.
286: -- We don't need to call the supplied conversion argument routine as we
294: -- business process
295: --
296: del(l_rec);
297: --
298: hr_utility.set_location(' Leaving:'||l_proc, 10);
299: End del;
300: --
301: end per_pss_del;