DBA Data[Home] [Help]

APPS.PER_STT_DEL dependencies on HR_UTILITY

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

49: --
50: l_proc varchar2(72) := g_package||'delete_dml';
51: --
52: Begin
53: hr_utility.set_location('Entering:'||l_proc, 5);
54: --
55: --
56: -- Delete the per_shared_types_tl row.
57: --

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

59: where shared_type_id = p_rec.shared_type_id
60: and language = p_rec.language;
61: --
62: --
63: hr_utility.set_location(' Leaving:'||l_proc, 10);
64: --
65: Exception
66: When hr_api.child_integrity_violated then
67: -- Child integrity has been violated

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

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

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

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

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

149: --
150: l_proc varchar2(72) := g_package||'post_delete';
151: --
152: Begin
153: hr_utility.set_location('Entering:'||l_proc, 5);
154: --
155: --
156: -- Start of API User Hook for post_delete.
157: --

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

177: --
178: -- End of API User Hook for post_delete.
179: --
180: --
181: hr_utility.set_location(' Leaving:'||l_proc, 10);
182: End post_delete;
183: --
184: -- ----------------------------------------------------------------------------
185: -- |---------------------------------< del >----------------------------------|

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

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

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

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

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

248: -- business process
249: --
250: del(l_rec);
251: --
252: hr_utility.set_location(' Leaving:'||l_proc, 10);
253: End del;
254: --
255: procedure del_tl (p_shared_type_id in number )
256: is

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

260: where stt.shared_type_id = p_shared_type_id ;
261: l_proc varchar2(72) := g_package||'del_tl';
262: --
263: Begin
264: hr_utility.set_location('Entering:'||l_proc, 10);
265: for l_lang in csr_del_langs loop
266: del(
267: p_shared_type_id => p_shared_type_id,
268: p_language => l_lang.language );

Line 270: hr_utility.set_location('Entering:'||l_proc, 20);

266: del(
267: p_shared_type_id => p_shared_type_id,
268: p_language => l_lang.language );
269: end loop;
270: hr_utility.set_location('Entering:'||l_proc, 20);
271: end del_tl ;
272: end per_stt_del;