1 package ff_database_items_pkg as
2 /* $Header: ffdbi01t.pkh 120.5 2006/11/30 16:00:14 arashid noship $ */
3 --
4 -- Global Variables.
5 --
6
7 --
8 -- Flag to selectively disable triggers associated with this package.
9 --
10 g_disable_triggers varchar2(10) := 'N';
11
12 ------------------------------ insert_tl_rows -----------------------------
13 --
14 -- NAME
15 -- insert_tl_rows
16 --
17 -- DESCRIPTION
18 -- Procedure for inserting _TL rows.
19 --
20 -- NOTES
21 -- Private routine for inserting _TL rows. For Oracle FF and Core PAY
22 -- use only.
23 --
24 procedure insert_tl_rows
25 (x_user_name in varchar2
26 ,x_user_entity_id in number
27 ,x_language in varchar2
28 ,x_translated_user_name in varchar2
29 ,x_description in varchar2
30 );
31 -------------------------------- insert_row -------------------------------
32 --
33 -- NAME
34 -- insert_row
35 --
36 -- DESCRIPTION
37 -- Standard row insert procedure. Creates the FF_DATABASE_ITEM_TL rows
38 -- also.
39 --
40 -- All parameters must be not NULL except for X_DESCRIPTION.
41 --
42 procedure insert_row
43 (x_rowid in out nocopy varchar2
44 ,x_user_name in out nocopy varchar2
45 ,x_user_entity_id in number
46 ,x_data_type in varchar2
47 ,x_definition_text in varchar2
48 ,x_null_allowed_flag in varchar2
49 ,x_translated_user_name in out nocopy varchar2
50 ,x_description in varchar2
51 );
52 -------------------------------- update_row -------------------------------
53 --
54 -- NAME
55 -- update_row
56 --
57 -- DESCRIPTION
58 -- Standard update procedure. All parameters must be not NULL except
59 -- for X_DESCRIPTION.
60 --
61 procedure update_row
62 (x_user_name in varchar2
63 ,x_user_entity_id in number
64 ,x_data_type in varchar2
65 ,x_definition_text in varchar2
66 ,x_null_allowed_flag in varchar2
67 ,x_translated_user_name in out nocopy varchar2
68 ,x_description in varchar2
69 );
70 ------------------------- update_seeded_tl_rows ---------------------------
71 --
72 -- NAME
73 -- update_seeded_tl_rows
74 --
75 -- DESCRIPTION
76 -- Procedure for updating seeded _TL rows. This code does not raise
77 -- errors, but logs error messages for later processing and sets
78 -- x_got_error to TRUE upon error.
79 --
80 -- NOTES
81 -- If the old translated name will disappear after update, but is
82 -- referenced in a compiled Formula, the translated name is still
83 -- updated. The Formula information is saved for later processing.
84 --
85 -- Private routine for updating _TL rows. For Oracle FF and Core PAY
86 -- use only.
87 --
88 procedure update_seeded_tl_rows
89 (x_user_name in varchar2
90 ,x_user_entity_id in number
91 ,x_language in varchar2
92 ,x_translated_user_name in out nocopy varchar2
93 ,x_description in varchar2
94 ,x_got_error out nocopy boolean
95 );
96 ----------------------------- update_tl_rows ------------------------------
97 --
98 -- NAME
99 -- update_tl_rows
100 --
101 -- DESCRIPTION
102 -- Procedure for updating _TL rows.
103 --
104 -- NOTES
105 -- Private routine for updating _TL rows. For Oracle FF and Core PAY
106 -- use only.
107 --
108 procedure update_tl_rows
109 (x_user_name in varchar2
110 ,x_user_entity_id in number
111 ,x_language in varchar2
112 ,x_translated_user_name in out nocopy varchar2
113 ,x_description in varchar2
114 );
115 ------------------------------ update_tl_row ------------------------------
116 --
117 -- NAME
118 -- update_tl_row
119 --
120 -- DESCRIPTION
121 -- Update procedure for an individual _TL row. All parameters must be
122 -- not NULL except for X_DESCRIPTION.
123 --
124 -- NOTES
125 -- Private routine for updating _TL row. For Oracle FF and Core PAY
126 -- use only.
127 --
128 procedure update_tl_row
129 (x_user_name in varchar2
130 ,x_user_entity_id in number
131 ,x_language in varchar2
132 ,x_source_lang in varchar2
133 ,x_translated_user_name in varchar2
134 ,x_description in varchar2
135 );
136 -------------------------------- delete_row -------------------------------
137 --
138 -- NAME
139 -- delete_row
140 --
141 -- DESCRIPTION
142 -- Standard delete procedure.
143 --
144 procedure delete_row
145 (x_user_name in varchar2
146 ,x_user_entity_id in number
147 );
148 --
149 ------------------------------ delete_tl_rows -----------------------------
150 --
151 -- NAME
152 -- delete_tl_rows
153 --
154 -- DESCRIPTION
155 -- Procedure for deleting _TL rows.
156 --
157 -- NOTES
158 -- Private routine for deleting _TL rows. For Oracle FF and Core PAY
159 -- use only.
160 --
161 procedure delete_tl_rows
162 (x_user_name in varchar2
163 ,x_user_entity_id in number
164 );
165 ------------------------------- add_language ------------------------------
166 --
167 -- NAME
168 -- add_language
169 --
170 -- DESCRIPTION
171 -- Called from FFNLINS.sql when a new language is added.
172 --
173 -- NOTES
174 -- Performs internal COMMITs.
175 --
176 procedure add_language;
177 ------------------------------ translate_row ------------------------------
178 --
179 -- NAME
180 -- translate_row
181 --
182 -- DESCRIPTION
183 -- Procedure to create a translated row. If X_LANGUAGE is NULL then
184 -- userenv('LANG') is used. This is effectively an update call.
185 --
186 procedure translate_row
187 (x_user_name in varchar2
188 ,x_legislation_code in varchar2
189 ,x_translated_user_name in varchar2
190 ,x_description in varchar2
191 ,x_language in varchar2
192 ,x_owner in varchar2
193 );
194
195 end ff_database_items_pkg;