1 Package per_jbt_upd as
2 /* $Header: pejbtrhi.pkh 120.0 2005/05/31 10:35:16 appldev 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_language_code in varchar2
45 ,p_job_id in number
46 ,p_name in varchar2 default hr_api.g_varchar2
47 );
48 --
49 --
50 -- ----------------------------------------------------------------------------
51 -- |------------------------------< upd_key_flex_meanings >-------------------|
52 -- ----------------------------------------------------------------------------
53 -- {Start of Comments}
54 --
55 -- Description:
56 -- This procedure update all languages with the transalated flex cocatnation.
57 --
58 -- Pre-requisites:
59 -- A unique surrogate key ID value is known to exist in the
60 -- non-translated table.
61 --
62 -- In Parameters:
63 --
64 --
65 -- Post Success:
66 -- Fully validated rows will be updated in the _TL table
67 -- None of the updates will be committed to the database.
68 --
69 -- Post Failure:
70 -- If an error has occurred a pl/sql exception will be raised.
71 --
72 -- Developer Implementation Notes:
73 -- None.
74 --
75 -- Access Status:
76 -- Internal Development Use Only.
77 --
78 -- {End of Comments}
79 -- ----------------------------------------------------------------------------
80 Procedure upd_key_flex_meanings
81 ( p_job_id in number
82 );
83 --
84 end per_jbt_upd;