DBA Data[Home] [Help]

APPS.PAY_PYR_DEL dependencies on HR_UTILITY

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

54: --
55: l_proc VARCHAR2(72) := g_package||'delete_dml';
56: --
57: BEGIN
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: pay_pyr_shd.g_api_dml := TRUE; -- Set the api dml status
61: --
62: -- Delete the pay_rates row.

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

65: WHERE rate_id = p_rec.rate_id;
66: --
67: pay_pyr_shd.g_api_dml := FALSE; -- Unset the api dml status
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: EXCEPTION
72: WHEN hr_api.child_integrity_violated THEN
73: -- Child integrity has been violated

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

115: --
116: l_proc VARCHAR2(72) := g_package||'pre_delete';
117: --
118: BEGIN
119: hr_utility.set_location('Entering:'||l_proc, 5);
120: --
121: hr_utility.set_location(' Leaving:'||l_proc, 10);
122: END pre_delete;
123: --

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

117: --
118: BEGIN
119: hr_utility.set_location('Entering:'||l_proc, 5);
120: --
121: hr_utility.set_location(' Leaving:'||l_proc, 10);
122: END pre_delete;
123: --
124: -- ----------------------------------------------------------------------------
125: -- |-----------------------------< post_delete >------------------------------|

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

157: --
158: l_proc VARCHAR2(72) := g_package||'post_delete';
159: --
160: BEGIN
161: hr_utility.set_location('Entering:'||l_proc, 5);
162: BEGIN
163: --
164: pay_pyr_rkd.after_delete
165: (p_rate_id

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

243: ,p_hook_type => 'AD');
244: --
245: END;
246: --
247: hr_utility.set_location(' Leaving:'||l_proc, 10);
248: END post_delete;
249: --
250: -- ----------------------------------------------------------------------------
251: -- |---------------------------------< del >----------------------------------|

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

256: --
257: l_proc VARCHAR2(72) := g_package||'del';
258: --
259: BEGIN
260: hr_utility.set_location('Entering:'||l_proc, 5);
261: --
262: -- We must lock the row which we need to delete.
263: --
264: pay_pyr_shd.lck

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

301: l_rec pay_pyr_shd.g_rec_type;
302: l_proc VARCHAR2(72) := g_package||'del';
303: --
304: BEGIN
305: hr_utility.set_location('Entering:'||l_proc, 5);
306: --
307: -- As the delete procedure accepts a plsql record structure we do need to
308: -- convert the arguments INTO the record structure.
309: -- We don't need to call the supplied conversion argument routine as we

Line 322: hr_utility.set_location(' Leaving:'||l_proc, 999);

318: -- business process
319: --
320: pay_pyr_del.del(l_rec);
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 999);
323: --
324: END del;
325: --
326: END pay_pyr_del;