1 Package hr_lot_del AUTHID CURRENT_USER as
2 /* $Header: hrlotrhi.pkh 120.0 2005/05/31 01:22:20 appldev noship $ */
3 -- ------------------------------------------------------------------------
4 -- |-----------------------------< del_tl >-------------------------------|
5 -- ------------------------------------------------------------------------
6 -- {Start Of Comments}
7 --
8 -- Description:
9 -- This procedure is the main interface for deleting rows in the
10 -- translated table. It will delete all translations which correspond
11 -- to the specified ID value.
12 --
13 -- Prerequisites:
14 -- A unique surrogate key ID value is known to exist in the
15 -- non-translated table. The row in the non-translated table has been
16 -- successfully locked.
17 --
18 -- In Parameters:
19 --
20 -- Post Success:
21 -- All validation will have passed and the set of translation rows
22 -- will be deleted from the _TL table. None of the changes will
23 -- be committed to the database.
24 --
25 -- Post Failure:
26 -- If an error has occurred a pl/sql exception will be raised.
27 --
28 -- Developer Implementation Notes:
29 -- None.
30 --
31 -- Access Status:
32 -- Internal Development Use Only.
33 --
34 -- {End Of Comments}
35 -- ------------------------------------------------------------------------
36 Procedure del_tl
37 (
38 p_location_id in number
39 );
40 --
41 end hr_lot_del;