DBA Data[Home] [Help]

APPS.PER_PSS_DEL dependencies on HR_UTILITY

Line 56: hr_utility.set_location('Entering:'||l_proc, 5);

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: --

Line 65: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

Line 113: hr_utility.set_location('Entering:'||l_proc, 5);

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: --

Line 115: hr_utility.set_location(' Leaving:'||l_proc, 10);

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 >------------------------------|

Line 155: hr_utility.set_location('Entering:'||l_proc, 5);

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

Line 227: hr_utility.set_location(' Leaving:'||l_proc, 10);

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: -- ----------------------------------------------------------------------------

Line 242: hr_utility.set_location('Entering:'||l_proc, 5);

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

Line 282: hr_utility.set_location('Entering:'||l_proc, 5);

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

Line 298: hr_utility.set_location(' Leaving:'||l_proc, 10);

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;