1 Package ame_cal_del as
2 /* $Header: amcalrhi.pkh 120.0 2005/09/02 03:54 mbocutt 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_application_id in number
40 ,p_associated_column1 in varchar2 default null
41 );
42 --
43 end ame_cal_del;