1 Package ota_srt_upd as
2 /* $Header: otsrtrhi.pkh 120.0 2005/05/29 07:33:05 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_supplied_resource_id in number
47 ,p_name in varchar2 default hr_api.g_varchar2
48 ,p_special_instruction in varchar2 default hr_api.g_varchar2
49 );
50 --
51 -- ----------------------------------------------------------------------------
52 -- |------------------------------< upd_key_flex_meanings >----------------------------------|
53 -- ----------------------------------------------------------------------------
54 --
55 -- {Start of Comments}
56 --
57 -- Description:
58 -- This procedure will populate the translated values of concatenated
59 -- field into translated table. It will update all rows for the specified ID where
60 -- p_language_cde matches the LANGUAGE or SOURCE_LANG columns.
61 --
62 -- Pre-requisites:
63 -- Temporarily setting the session language, once for each installed language
64 -- in order to retrieve the translated NAME. The session language will be reset
65 -- to the original afterwards.
66 --
67 -- In Parameters:
68 -- p_supplied_resource_id
69 --
70 -- Post Success:
71 -- Populate all the rows in the _TL table for the given resource_id where
72 -- p_language_code matches the LANGUAGE or SOURCE_LANG columns.
73 -- Rows which are updated will also have SOURCE_LANG set to
74 -- p_language_code. None of the updates will be committed to the database.
75 --
76 -- Post Failure:
77 -- If an error has occurred a pl/sql exception will be raised. And the
78 -- session language will be reset to original.
79 --
80 -- Developer Implementation Notes:
81 -- None.
82 --
83 -- Access Status:
84 -- Will be called from ins_tl and upd_tl as last step. Internal Development Use Only.
85 --
86 -- {End of Comments}
87 --
88 -- ----------------------------------------------------------------------------
89 -- |------------------------------< upd_key_flex_meanings >-------------------|
90 -- ----------------------------------------------------------------------------
91 --
92 Procedure upd_key_flex_meanings
93 ( p_supplied_resource_id in number
94 ) ;
95 --
96 end ota_srt_upd;