DBA Data[Home] [Help]

APPS.PQH_ATT_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: --
53: -- Added the following code as a part of Zero Downtime Patching Project.
54: -- Code Starts Here.

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

75: delete from pqh_attributes
76: where attribute_id = p_rec.attribute_id;
77: --
78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: --
81: Exception
82: When hr_api.child_integrity_violated then
83: -- Child integrity has been violated

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

123: --
124: l_proc varchar2(72) := g_package||'pre_delete';
125: --
126: Begin
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 10);
130: End pre_delete;
131: --

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

125: --
126: Begin
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 10);
130: End pre_delete;
131: --
132: -- ----------------------------------------------------------------------------
133: -- |-----------------------------< post_delete >------------------------------|

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

166: --
167: l_proc varchar2(72) := g_package||'post_delete';
168: --
169: Begin
170: hr_utility.set_location('Entering:'||l_proc, 5);
171: --
172: --
173: -- Start of API User Hook for post_delete.
174: --

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

202: --
203: -- End of API User Hook for post_delete.
204: --
205: --
206: hr_utility.set_location(' Leaving:'||l_proc, 10);
207: End post_delete;
208: --
209: -- ----------------------------------------------------------------------------
210: -- |---------------------------------< del >----------------------------------|

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

217: --
218: l_proc varchar2(72) := g_package||'del';
219: --
220: Begin
221: hr_utility.set_location('Entering:'||l_proc, 5);
222: --
223: -- We must lock the row which we need to delete.
224: --
225: pqh_att_shd.lck

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

260: l_rec pqh_att_shd.g_rec_type;
261: l_proc varchar2(72) := g_package||'del';
262: --
263: Begin
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: --
266: -- As the delete procedure accepts a plsql record structure we do need to
267: -- convert the arguments into the record structure.
268: -- We don't need to call the supplied conversion argument routine as we

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

277: --
278: del(
279: p_effective_date,l_rec);
280: --
281: hr_utility.set_location(' Leaving:'||l_proc, 10);
282: End del;
283: --
284: end pqh_att_del;