[Home] [Help]
PACKAGE: APPS.GL_JE_CATEGORIES_PKG
Source
1 PACKAGE GL_JE_CATEGORIES_PKG AUTHID CURRENT_USER AS
2 /* $Header: glijects.pls 120.6 2005/05/05 01:09:34 kvora ship $ */
3 --
4 -- Package
5 -- GL_JE_CATEGORIES_PKG
6 -- Purpose
7 -- To create GL_JE_CATEGORIES_PKG package.
8 -- History
9 -- 10.16.93 E. Rumanang Created
10 -- 28-MAR-94 D J Ogg Added select_columns
11
12 --
13 -- Procedure
14 -- check_unique
15 -- Purpose
16 -- Checks to make sure the given user_je_category_name
17 -- is unique within gl_je_categories table.
18 -- History
19 -- 10.16.93 E. Rumanang Created
20 -- Arguments
21 -- x_rowid The ID of the row to be checked
22 -- x_name The category name to be checked
23 -- Example
24 -- GL_JE_CATEGORIES_PKG.check_unique( '123:A:456', 'ALLOCATION' );
25 -- Notes
26 --
27 PROCEDURE check_unique( x_rowid VARCHAR2,
28 x_name VARCHAR2 );
29
30 --
31 -- Procedure
32 -- check_unique_key
33 -- Purpose
34 -- Checks to make sure the given je_category_key
35 -- is unique within gl_je_categories table.
36 -- History
37 -- 20-DEC-2004 D J Ogg Created
38 -- Arguments
39 -- x_rowid The ID of the row to be checked
40 -- x_key The category key to be checked
41 -- Example
42 -- GL_JE_CATEGORIES_PKG.check_unique_key( '123:A:456', 'ALLOCATION' );
43 -- Notes
44 --
45 PROCEDURE check_unique_key( x_rowid VARCHAR2,
46 x_key VARCHAR2 );
47
48
49 --
50 -- Procedure
51 -- get_unique_id
52 -- Purpose
53 -- Gets a unique id for a new category.
54 -- History
55 -- 10.16.93 E. Rumanang Created
56 -- Arguments
57 -- none
58 -- Example
59 -- je_category_name := GL_JE_CATEGORIES_PKG.get_unique_id;
60 -- Notes
61 --
62 FUNCTION get_unique_id RETURN NUMBER;
63
64
65 --
66 -- Procedure
67 -- insert_fnd_cat
68 -- Purpose
69 -- Insert into FND_DOC_SEQUENCE_CATEGORIES table for each
70 -- new created category.
71 -- History
72 -- 10.16.93 E. Rumanang Created
73 -- Arguments
74 -- x_je_category_name The category name id
75 -- x_user_je_category_name The user category name
76 -- x_description The description
77 -- x_last_updated_by The last person id who update the row
78 -- x_created_by The person id who create the row
79 -- x_last_update_login The person id who last login
80 -- Example
81 -- GL_JE_CATEGORIES_PKG.insert_fnd_cat(
82 -- 'id1', 'Allocation', 'alloc desc', 1, 1 );
83 -- Notes
84 --
85 PROCEDURE insert_fnd_cat( x_je_category_name VARCHAR2,
86 x_user_je_category_name VARCHAR2,
87 x_description VARCHAR2,
88 x_last_updated_by NUMBER,
89 x_created_by NUMBER,
90 x_last_update_login NUMBER );
91
92
93 --
94 -- Procedure
95 -- update_fnd_cat
96 -- Purpose
97 -- Update FND_DOC_SEQUENCE_CATEGORIES table for each
98 -- new updated category.
99 -- History
100 -- 10.16.93 E. Rumanang Created
101 -- Arguments
102 -- x_je_category_name The category name id
103 -- x_user_je_category_name The category name id
104 -- x_description The description
105 -- x_last_updated_by The last person id who update the row
106 -- Example
107 -- GL_JE_CATEGORIES_PKG.update_fnd_cat(
108 -- 'id1', 'alloc desc', 1 );
109 -- Notes
110 --
111
112 PROCEDURE update_fnd_cat( x_je_category_name VARCHAR2,
113 x_user_je_category_name VARCHAR2,
114 x_description VARCHAR2,
115 x_last_updated_by NUMBER );
116
117
118
119 -- Procedure
120 -- update_fnd_cat_all
121 -- Purpose
122 -- Update FND_DOC_SEQUENCE_CATEGORIES table for all
123 -- new updated categories. Only categories with new
124 -- user_je_category_name defined in the base language
125 -- will be updated.
126 -- History
127 -- 07-14-99 M C Hui Created
128 -- Arguments
129 -- x_last_updated_by The last person id who update the row
130 -- Example
131 -- GL_JE_CATEGORIES_PKG.update_fnd_cat(1);
132 -- Notes
133 --
134
135 PROCEDURE update_fnd_cat_all( x_last_updated_by NUMBER );
136
137
138 --
139 -- Procedure
140 -- insert_other_cat
141 -- Purpose
142 -- insert other tables which has journal category as its key column.
143 -- History
144 -- 06-JUN-98 Charmaine Wang Created
145
146 PROCEDURE insert_other_cat( x_je_category_name VARCHAR2,
147 x_user_je_category_name VARCHAR2,
148 x_description VARCHAR2,
149 x_last_updated_by NUMBER,
150 x_created_by NUMBER,
151 x_last_update_login NUMBER );
152
153
154 --
155 -- Procedure
156 -- select_columns
157 -- Purpose
158 -- Used to select the user_je_category_name for a given je_category_name
159 -- History
160 -- 28-MAR-93 D. J. Ogg Created
161 -- Arguments
162 -- x_je_category_name Category name to be found
163 -- x_user_je_category_name User name for the category
164 -- Example
165 -- gl_je_categories_pkg.select_columns('Budget', user_name);
166 -- Notes
167 --
168 PROCEDURE select_columns(
169 x_je_category_name VARCHAR2,
170 x_user_je_category_name IN OUT NOCOPY VARCHAR2 );
171
172 --
173 -- Procedure
174 -- Load_Row
175 -- Purpose
176 -- Called from loader config file to upload a multi-lingual entity
177 -- History
178 -- 07-12-99 M C Hui Created
179 -- Arguments
180 -- all the columns of the view GL_JE_CATEGORIES
181 -- Example
182 -- gl_je_categories_pkg.Load_Row(....;
183 -- Notes
184 --
185 PROCEDURE Load_Row(
186 X_Je_Category_Name IN OUT NOCOPY VARCHAR2,
187 X_Je_Category_Key VARCHAR2,
188 X_User_Je_Category_Name VARCHAR2,
189 X_Description VARCHAR2,
190 X_Attribute1 VARCHAR2,
191 X_Attribute2 VARCHAR2,
192 X_Attribute3 VARCHAR2,
193 X_Attribute4 VARCHAR2,
194 X_Attribute5 VARCHAR2,
195 X_Context VARCHAR2,
196 X_Owner VARCHAR2,
197 X_Force_Edits VARCHAR2);
198
199
200 --
201 -- Procedure
202 -- Translate_Row
203 -- Purpose
204 -- Called from loader config file to upload translations.
205 -- History
206 -- 07-12-99 M C Hui Created
207 -- Arguments
208 -- X_Je_Category_Name Journal entry category name
209 -- X_User_Je_Category_Name Journal entry category user defined name
210 -- X_Description Journal entry category description
211 -- X_Owner
212 -- Example
213 -- gl_je_category_pkg.Translate_Row(
214 -- 'Adjustment', 'Adjustment', 'SEED', 'Adjustment Journal Entry');
215 -- Notes
216 --
217 PROCEDURE Translate_Row(
218 X_Je_Category_Name VARCHAR2,
219 X_User_Je_Category_Name VARCHAR2,
220 X_Description VARCHAR2,
221 X_Owner VARCHAR2,
222 X_Force_Edits VARCHAR2 );
223
224 --
225 -- Procedure
226 -- Add_Language
227 -- Purpose
228 -- To add a new language row to the gl_je_categories_b
229 -- History
230 -- 24-NOV-98 M C Hui Created
231 -- Arguments
232 -- None
233 -- Example
234 -- gl_je_categories_pkg.Add_Language(....;
235 -- Notes
236 --
237 procedure ADD_LANGUAGE;
238
239
240 --
241 -- Procedure
242 -- Insert_Row
243 -- Purpose
244 -- Insert rows into gl_je_categories_tl
245 -- Added for the Consolidation Enhancements projects.
246 -- History
247 -- 16-AUG-01 O Monnier Created
248 -- Arguments
249 -- All the columns of the table GL_JE_CATEGORIES_TL
250 -- Example
251 -- gl_je_categories_pkg.Insert_Row(....;
252 -- Notes
253 --
254 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
255 X_Je_Category_Name IN OUT NOCOPY VARCHAR2,
256 X_Language IN OUT NOCOPY VARCHAR2,
257 X_Source_Lang IN OUT NOCOPY VARCHAR2,
258 X_Last_Update_Date DATE,
259 X_Last_Updated_By NUMBER,
260 X_User_Je_Category_Name VARCHAR2,
261 X_Je_Category_Key VARCHAR2,
262 X_Creation_Date DATE,
263 X_Created_By NUMBER,
264 X_Last_Update_Login NUMBER,
265 X_Description VARCHAR2,
266 X_Attribute1 VARCHAR2,
267 X_Attribute2 VARCHAR2,
268 X_Attribute3 VARCHAR2,
269 X_Attribute4 VARCHAR2,
270 X_Attribute5 VARCHAR2,
271 X_Context VARCHAR2,
272 X_Consolidation_Flag VARCHAR2);
273
274 --
275 -- Procedure
276 -- Update_Row
277 -- Purpose
278 -- Updates a row into gl_je_categories_tl
279 -- Added for the Consolidation Enhancements projects.
280 -- History
281 -- 16-AUG-01 O Monnier Created
282 -- Arguments
283 -- All the columns of the table GL_JE_CATEGORIES_TL
284 -- Example
285 -- gl_je_categories_pkg.Update_Row(....;
286 -- Notes
287 --
288 PROCEDURE Update_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
289 X_Je_Category_Name VARCHAR2,
290 X_Last_Update_Date DATE,
291 X_Last_Updated_By NUMBER,
292 X_User_Je_Category_Name VARCHAR2,
293 X_Je_Category_Key VARCHAR2,
294 X_Creation_Date DATE,
295 X_Last_Update_Login NUMBER,
296 X_Description VARCHAR2,
297 X_Attribute1 VARCHAR2,
298 X_Attribute2 VARCHAR2,
299 X_Attribute3 VARCHAR2,
300 X_Attribute4 VARCHAR2,
301 X_Attribute5 VARCHAR2,
302 X_Context VARCHAR2,
303 X_Consolidation_Flag VARCHAR2);
304
305 --
306 -- Procedure
307 -- Lock_Row
308 -- Purpose
309 -- Locks a row into gl_je_categories_tl
310 -- Added for the Consolidation Enhancements projects.
311 -- History
312 -- 16-AUG-01 O Monnier Created
313 -- Arguments
314 -- All the columns of the table GL_JE_CATEGORIES_TL
315 -- Example
316 -- gl_je_categories_pkg.Lock_Row(....;
317 -- Notes
318 --
319 PROCEDURE Lock_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
320 X_Je_Category_Name VARCHAR2,
321 X_User_Je_Category_Name VARCHAR2,
322 X_Je_Category_Key VARCHAR2,
323 X_Description VARCHAR2,
324 X_Attribute1 VARCHAR2,
325 X_Attribute2 VARCHAR2,
326 X_Attribute3 VARCHAR2,
327 X_Attribute4 VARCHAR2,
328 X_Attribute5 VARCHAR2,
329 X_Context VARCHAR2,
330 X_Consolidation_Flag VARCHAR2);
331
332
333 END GL_JE_CATEGORIES_PKG;