1: Package Body pqh_rls_del as
2: /* $Header: pqrlsrhi.pkb 120.0.12020000.2 2013/04/12 18:48:44 pathota ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_rls_del.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------------< delete_dml >------------------------------|
12: -- ----------------------------------------------------------------------------
294: pqh_rls_bus.delete_validate(p_rec, p_effective_date);
295: --
296: -- Call the supporting pre-delete operation
297: --
298: pqh_rls_del.pre_delete(p_rec);
299: --
300: -- Delete the row.
301: --
302: pqh_rls_del.delete_dml(p_rec);
298: pqh_rls_del.pre_delete(p_rec);
299: --
300: -- Delete the row.
301: --
302: pqh_rls_del.delete_dml(p_rec);
303: --
304: -- Call the supporting post-delete operation
305: --
306: pqh_rls_del.post_delete(p_rec);
302: pqh_rls_del.delete_dml(p_rec);
303: --
304: -- Call the supporting post-delete operation
305: --
306: pqh_rls_del.post_delete(p_rec);
307: --
308: End del;
309: --
310: -- ----------------------------------------------------------------------------
333: -- Having converted the arguments into the pqh_rls_rec
334: -- plsql record structure we must call the corresponding entity
335: -- business process
336: --
337: pqh_rls_del.del(p_effective_date,l_rec);
338: --
339: hr_utility.set_location(' Leaving:'||l_proc, 10);
340: End del;
341: --
338: --
339: hr_utility.set_location(' Leaving:'||l_proc, 10);
340: End del;
341: --
342: end pqh_rls_del;