DBA Data[Home] [Help]

APPS.HR_QSF_DEL dependencies on HR_UTILITY

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

52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57:
58:
59: -- Delete the hr_quest_fields row.
60:

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

61: delete from hr_quest_fields
62: where field_id = p_rec.field_id;
63:
64:
65: hr_utility.set_location(' Leaving:'||l_proc, 10);
66:
67: Exception
68: When hr_api.child_integrity_violated then
69: -- Child integrity has been violated

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

109:
110: l_proc varchar2(72) := g_package||'pre_delete';
111:
112: Begin
113: hr_utility.set_location('Entering:'||l_proc, 5);
114:
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: End pre_delete;
117: --

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

111:
112: Begin
113: hr_utility.set_location('Entering:'||l_proc, 5);
114:
115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: End pre_delete;
117: --
118: -- ----------------------------------------------------------------------------
119: -- |-----------------------------< post_delete >------------------------------|

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

151: --
152: l_proc varchar2(72) := g_package||'post_delete';
153: --
154: Begin
155: hr_utility.set_location('Entering:'||l_proc, 5);
156: hr_qsf_rkd.after_delete
157: (p_field_id
158: => p_rec.field_id
159: ,p_questionnaire_template_id_o

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

180: (p_module_name => 'HR_QUEST_FIELDS'
181: ,p_hook_type => 'AD');
182: --
183: --
184: hr_utility.set_location(' Leaving:'||l_proc, 10);
185: End post_delete;
186: --
187: -- ----------------------------------------------------------------------------
188: -- |---------------------------------< del >----------------------------------|

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

194:
195: l_proc varchar2(72) := g_package||'del';
196: --
197: Begin
198: hr_utility.set_location('Entering:'||l_proc, 5);
199:
200: -- We must lock the row which we need to delete.
201: --
202: hr_qsf_shd.lck

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

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

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

252: -- business process
253: --
254: del(l_rec);
255: --
256: hr_utility.set_location(' Leaving:'||l_proc, 10);
257: End del;
258: --
259: end hr_qsf_del;