1 Package ota_adt_upd as
2 /* $Header: otadtrhi.pkh 120.1 2005/07/11 07:32:22 pgupta noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------------< upd_tl >----------------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 -- {Start of Comments}
9 --
10 -- Description:
11 -- This procedure is the main interface for updating rows into the
12 -- translated table. It will update all rows for the specified ID where
13 -- p_language_cde matches the LANGUAGE or SOURCE_LANG columns. This
14 -- allows individual translations to be updated and keeps translations,
15 -- which have not been given explicit values, synchronised with the
16 -- original language.
17 --
18 -- Pre-requisites:
19 -- A unique surrogate key ID value is known to exist in the
20 -- non-translated table. The row in the non-translated table has been
21 -- successfully locked.
22 --
23 -- In Parameters:
24 -- p_language_code must be set to the base or any installed language.
25 --
26 -- Post Success:
27 -- Fully validated rows will be updated in the _TL table where
28 -- p_language_code matches the LANGUAGE or SOURCE_LANG columns.
29 -- Rows which are updated will also have SOURCE_LANG set to
30 -- p_language_code. None of the updates will be committed to the database.
31 --
32 -- Post Failure:
33 -- If an error has occurred a pl/sql exception will be raised.
34 --
35 -- Developer Implementation Notes:
36 -- None.
37 --
38 -- Access Status:
39 -- Internal Development Use Only.
40 --
41 -- {End of Comments}
42 -- ----------------------------------------------------------------------------
43 Procedure upd_tl
44 (p_effective_date in date
45 ,p_language_code in varchar2
46 ,p_activity_id in number
47 ,p_name in varchar2 default hr_api.g_varchar2
48 ,p_description in varchar2 default hr_api.g_varchar2
49 );
50 --
51 end ota_adt_upd;