1 Package per_gdt_upd as
2 /* $Header: pegdtrhi.pkh 120.0 2005/05/31 09:16:49 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_grade_id in number
46 ,p_name in varchar2 default hr_api.g_varchar2
47 );
48 --
49 --
50 -- ----------------------------------------------------------------------------
51 -- |------------------------------< upd_tl >----------------------------------|
52 -- ----------------------------------------------------------------------------
53 --
54 -- {Start of Comments}
55 --
56 -- Description:
57 -- This will update all rows for the specified ID for lanugages. It will
58 -- translate the for key flex meaning for each language.
59 --
60 -- Pre-requisites:
61 -- A unique surrogate key ID value is known to exist in the
62 -- non-translated table.
63 --
64 -- In Parameters:
65 -- p_grade_id
66 --
67 -- Post Success:
68 -- Fully validated rows will be updated in the _TL table where
69 -- p_language_code matches the LANGUAGE or SOURCE_LANG columns.
70 -- Rows which are updated will also have SOURCE_LANG set to
71 -- p_language_code. None of the updates will be committed to the database.
72 --
73 -- Post Failure:
74 -- If an error has occurred a pl/sql exception will be raised.
75 --
76 -- Developer Implementation Notes:
77 -- None.
78 --
79 -- Access Status:
80 -- Internal Development Use Only.
81 --
82 -- {End of Comments}
83 -- ----------------------------------------------------------------------------
84 --
85 --
86 -- ----------------------------------------------------------------------------
87 -- |------------------------------< upd_key_flex_meanings >-------------------|
88 -- ----------------------------------------------------------------------------
89 -- {Start of Comments}
90 --
91 -- Description:
92 -- This procedure update all languages with the transalated flex cocatnation.
93 --
94 -- Pre-requisites:
95 -- A unique surrogate key ID value is known to exist in the
96 -- non-translated table.
97 --
98 -- In Parameters:
99 --
100 --
101 -- Post Success:
102 -- Fully validated rows will be updated in the _TL table
103 -- None of the updates will be committed to the database.
104 --
105 -- Post Failure:
106 -- If an error has occurred a pl/sql exception will be raised.
107 --
108 -- Developer Implementation Notes:
109 -- None.
110 --
111 -- Access Status:
112 -- Internal Development Use Only.
113 --
114 -- {End of Comments}
115 -- ----------------------------------------------------------------------------
116 Procedure upd_key_flex_meanings
117 ( p_grade_id in number
118 );
119 --
120 end per_gdt_upd;