1: Package Body per_rsl_del as
2: /* $Header: perslrhi.pkb 120.1 2005/06/15 05:45:38 bshukla noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_rsl_del.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------------< delete_dml >------------------------------|
12: -- ----------------------------------------------------------------------------
215: hr_multi_message.end_validation_set;
216: --
217: -- Call the supporting pre-delete operation
218: --
219: per_rsl_del.pre_delete(p_rec);
220: --
221: -- Delete the row.
222: --
223: per_rsl_del.delete_dml(p_rec);
219: per_rsl_del.pre_delete(p_rec);
220: --
221: -- Delete the row.
222: --
223: per_rsl_del.delete_dml(p_rec);
224: --
225: -- Call the supporting post-delete operation
226: --
227: per_rsl_del.post_delete(p_rec);
223: per_rsl_del.delete_dml(p_rec);
224: --
225: -- Call the supporting post-delete operation
226: --
227: per_rsl_del.post_delete(p_rec);
228: --
229: -- Call to raise any errors on multi-message list
230: hr_multi_message.end_validation_set;
231: --
256: -- Having converted the arguments into the per_rsl_rec
257: -- plsql record structure we must call the corresponding entity
258: -- business process
259: --
260: per_rsl_del.del(l_rec);
261: --
262: hr_utility.set_location(' Leaving:'||l_proc, 10);
263: End del;
264: --
284: --
285: -- Delete all the translated rows
286: --
287: for l_lang in csr_del_langs loop
288: per_rsl_del.del
289: (p_rating_scale_id => p_rating_scale_id
290: ,p_language => l_lang.language
291: );
292: end loop;
293: --
294: hr_utility.set_location(' Leaving:'||l_proc,20);
295: End del_tl;
296: --
297: end per_rsl_del;