1 Package pqh_crl_upd as
2 /* $Header: pqcrlrhi.pkh 120.0 2005/05/29 01:45 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_effective_date in date
45 ,p_language_code in varchar2
46 ,p_criteria_rate_defn_id in number
47 ,p_name in varchar2 default hr_api.g_varchar2
48 );
49 --
50 --
51 -- ----------------------------------------------------------------------------
52 -- |----------------------------< translate_row >-------------------------------|
53 -- ----------------------------------------------------------------------------
54 --
55 -- {Start of Comments}
56 --
57 -- Description:
58 -- This procedure is updates the name column for each language.
59 --
60 -- Pre-requisites:
61 -- A unique surrogate key ID value is known to exist in the
62 -- non-translated table. The row in the non-translated table has been
63 -- successfully locked.
64 --
65 -- In Parameters:
66 --
67 -- Post Success:
68 -- The changes will be committed to the database
69 --
70 -- Post Failure:
71 -- If an error has occurred a pl/sql exception will be raised.
72 --
73 -- Developer Implementation Notes:
74 -- None.
75 --
76 -- Access Status:
77 -- Internal Development Use Only.
78 --
79 -- {End of Comments}
80 -- ----------------------------------------------------------------------------
81 Procedure translate_row (
82 p_short_name in varchar2,
83 p_name in varchar2,
84 p_owner in varchar2);
85 --
86 end pqh_crl_upd;