DBA Data[Home] [Help]

APPS.PER_SHA_DEL dependencies on HR_UTILITY

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

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_std_holiday_absences row.
53: --
54: delete from per_std_holiday_absences

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

53: --
54: delete from per_std_holiday_absences
55: where std_holiday_absences_id = p_rec.std_holiday_absences_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

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

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

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

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

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

143: --
144: l_proc varchar2(72) := g_package||'post_delete';
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: -- Start of API User Hook for post_delete.
150: begin
151: per_sha_rkd.after_delete

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

187: );
188: end;
189: -- End of API User Hook for post_delete.
190: --
191: hr_utility.set_location(' Leaving:'||l_proc, 10);
192: End post_delete;
193: --
194: -- ----------------------------------------------------------------------------
195: -- |---------------------------------< del >----------------------------------|

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

201: --
202: l_proc varchar2(72) := g_package||'del';
203: --
204: Begin
205: hr_utility.set_location('Entering:'||l_proc, 5);
206: --
207: -- We must lock the row which we need to delete.
208: --
209: per_sha_shd.lck

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

241: l_rec per_sha_shd.g_rec_type;
242: l_proc varchar2(72) := g_package||'del';
243: --
244: Begin
245: hr_utility.set_location('Entering:'||l_proc, 5);
246: --
247: -- As the delete procedure accepts a plsql record structure we do need to
248: -- convert the arguments into the record structure.
249: -- We don't need to call the supplied conversion argument routine as we

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

257: -- business process
258: --
259: del(l_rec);
260: --
261: hr_utility.set_location(' Leaving:'||l_proc, 10);
262: End del;
263: --
264: end per_sha_del;