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