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