DBA Data[Home] [Help]

APPS.PQP_ERG_DEL dependencies on HR_UTILITY

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

89: --
90: l_proc varchar2(72) := g_package||'delete_dml';
91: --
92: Begin
93: hr_utility.set_location('Entering:'||l_proc, 5);
94: --
95: pqp_erg_shd.g_api_dml := true; -- Set the api dml status
96: --
97: -- Delete the pqp_exception_report_groups row.

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

100: where exception_group_id = p_rec.exception_group_id;
101: --
102: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status
103: --
104: hr_utility.set_location(' Leaving:'||l_proc, 10);
105: --
106: Exception
107: When hr_api.child_integrity_violated then
108: -- Child integrity has been violated

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

150: --
151: l_proc varchar2(72) := g_package||'pre_delete';
152: --
153: Begin
154: hr_utility.set_location('Entering:'||l_proc, 5);
155: --
156: hr_utility.set_location(' Leaving:'||l_proc, 10);
157: End pre_delete;
158: --

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

152: --
153: Begin
154: hr_utility.set_location('Entering:'||l_proc, 5);
155: --
156: hr_utility.set_location(' Leaving:'||l_proc, 10);
157: End pre_delete;
158: --
159: -- ----------------------------------------------------------------------------
160: -- |-----------------------------< post_delete >------------------------------|

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

192: --
193: l_proc varchar2(72) := g_package||'post_delete';
194: --
195: Begin
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: begin
198: --
199: pqp_erg_rkd.after_delete
200: (p_exception_group_id

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

224: ,p_hook_type => 'AD');
225: --
226: end;
227: --
228: hr_utility.set_location(' Leaving:'||l_proc, 10);
229: End post_delete;
230: --
231: -- ----------------------------------------------------------------------------
232: -- |---------------------------------< del >----------------------------------|

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

238: l_proc varchar2(72) := g_package||'del';
239: l_rec pqp_erg_shd.g_rec_type;
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:

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

284: l_rec pqp_erg_shd.g_rec_type;
285: l_proc varchar2(72) := g_package||'del';
286: --
287: Begin
288: hr_utility.set_location('Entering:'||l_proc, 5);
289: --
290: -- As the delete procedure accepts a plsql record structure we do need to
291: -- convert the arguments into the record structure.
292: -- We don't need to call the supplied conversion argument routine as we

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

300: -- business process
301: --
302: pqp_erg_del.del(l_rec);
303: --
304: hr_utility.set_location(' Leaving:'||l_proc, 10);
305: End del;
306: --
307: end pqp_erg_del;