DBA Data[Home] [Help]

APPS.PQH_RAP_DEL dependencies on HR_UTILITY

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

55: l_proc constant varchar2(72):= g_package||'delete_dml';
56: --
57: Begin
58:
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: --
62: --
63: -- Delete the pqh_rank_process_approvals row.

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

66: where rank_process_approval_id = p_rec.rank_process_approval_id;
67: --
68: --
69: --
70: hr_utility.set_location(' Leaving:'||l_proc, 10);
71: --
72: Exception
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated

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

117: l_proc constant varchar2(72):= g_package||'pre_delete';
118: --
119: Begin
120:
121: hr_utility.set_location('Entering:'||l_proc, 5);
122: --
123: hr_utility.set_location(' Leaving:'||l_proc, 10);
124: End pre_delete;
125: --

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

119: Begin
120:
121: hr_utility.set_location('Entering:'||l_proc, 5);
122: --
123: hr_utility.set_location(' Leaving:'||l_proc, 10);
124: End pre_delete;
125: --
126: -- ----------------------------------------------------------------------------
127: -- |-----------------------------< post_delete >------------------------------|

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

160: l_proc constant varchar2(72):= g_package||'post_delete';
161: --
162: Begin
163:
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: begin
166: --
167: pqh_rap_rkd.after_delete
168: (p_rank_process_approval_id

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

192: ,p_hook_type => 'AD');
193: --
194: end;
195: --
196: hr_utility.set_location(' Leaving:'||l_proc, 10);
197: End post_delete;
198: --
199: -- ----------------------------------------------------------------------------
200: -- |---------------------------------< del >----------------------------------|

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

206: l_proc constant varchar2(72):= g_package||'del';
207: --
208: Begin
209:
210: hr_utility.set_location('Entering:'||l_proc, 5);
211: --
212: -- We must lock the row which we need to delete.
213: --
214: pqh_rap_shd.lck

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

252: l_proc constant varchar2(72):= g_package||'del';
253: --
254: Begin
255:
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: -- As the delete procedure accepts a plsql record structure we do need to
259: -- convert the arguments into the record structure.
260: -- We don't need to call the supplied conversion argument routine as we

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

268: -- business process
269: --
270: pqh_rap_del.del(l_rec);
271: --
272: hr_utility.set_location(' Leaving:'||l_proc, 10);
273: End del;
274: --
275: end pqh_rap_del;