[Home] [Help]
1: Package Body hr_ttl_del as
2: /* $Header: hrttlrhi.pkb 115.1 2004/04/05 07:21 menderby noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hr_ttl_del.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------------< delete_dml >------------------------------|
12: -- ----------------------------------------------------------------------------
213: hr_multi_message.end_validation_set;
214: --
215: -- Call the supporting pre-delete operation
216: --
217: hr_ttl_del.pre_delete(p_rec);
218: --
219: -- Delete the row.
220: --
221: hr_ttl_del.delete_dml(p_rec);
217: hr_ttl_del.pre_delete(p_rec);
218: --
219: -- Delete the row.
220: --
221: hr_ttl_del.delete_dml(p_rec);
222: --
223: -- Call the supporting post-delete operation
224: --
225: hr_ttl_del.post_delete(p_rec);
221: hr_ttl_del.delete_dml(p_rec);
222: --
223: -- Call the supporting post-delete operation
224: --
225: hr_ttl_del.post_delete(p_rec);
226: --
227: -- Call to raise any errors on multi-message list
228: hr_multi_message.end_validation_set;
229: --
254: -- Having converted the arguments into the hr_ttl_rec
255: -- plsql record structure we must call the corresponding entity
256: -- business process
257: --
258: hr_ttl_del.del(l_rec);
259: --
260: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: End del;
262: --
283: --
284: -- Delete all the translated rows
285: --
286: for l_lang in csr_del_langs loop
287: hr_ttl_del.del
288: (p_topic_id => p_topic_id
289: ,p_language => l_lang.language
290: );
291: end loop;
292: --
293: hr_utility.set_location(' Leaving:'||l_proc,20);
294: End del_tl;
295: --
296: end hr_ttl_del;