[Home] [Help]
PACKAGE: APPS.GL_CODE_COMBINATIONS_PKG
Source
1 PACKAGE GL_CODE_COMBINATIONS_PKG AS
2 /* $Header: gliccids.pls 120.9 2005/07/01 05:19:22 agovil ship $ */
3
4
5 --
6 -- Procedure
7 -- select_row
8 -- Purpose
9 -- select a row
10 -- History
11 -- 14-APR-94 ERumanan Created.
12 -- Arguments
13 -- recinfo record information
14 -- Example
15 -- select_row(recinfo);
16 -- Notes
17 --
18 PROCEDURE select_row(recinfo IN OUT NOCOPY gl_code_combinations%ROWTYPE);
19
20
21
22 --
23 -- Procedure
24 -- select_columns
25 -- Purpose
26 -- Get values of some columns.
27 -- History
28 -- 14-APR-94 ERumanan Created.
29 -- Arguments
30 -- code_combination_id
31 -- account_type
32 -- Example
33 -- select_columns( :block.code_combination_id,
34 -- :block.account_type );
35 -- Notes
36 --
37 PROCEDURE select_columns(
38 X_code_combination_id NUMBER,
39 X_account_type IN OUT NOCOPY VARCHAR2,
40 X_template_id IN OUT NOCOPY NUMBER );
41
42
43
44 --
45 -- Procedure
46 -- check_unique
47 -- Purpose
48 -- Check the uniqueness of the ccid.
49 -- History
50 -- 27-NOV-1993 ERumanan Created.
51 -- Arguments
52 -- x_rowid The ID of the row to be checked
53 -- x_ccid The code combination id to be checked
54 -- Example
55 -- GL_CODE_COMBINATIONS_PKG.check_unique( '12345', 1010 );
56 -- Notes
57 --
58 PROCEDURE check_unique( x_rowid VARCHAR2,
59 x_ccid NUMBER );
60
61
62
63 --
64 -- Procedure
65 -- get_valid_sob_summary
66 -- Purpose
67 -- Retrieve the summary account id and template id that match
68 -- with the given ledger and also match with all the segment
69 -- values of the given ccid.
70 -- History
71 -- 08-MAR-1994 ERumanan Created.
72 -- Arguments
73 -- x_ccid The code combination id to be checked.
74 -- x_template_id The valid template_id
75 -- x_ledger_id The ledger id to be checked.
76 -- Example
77 -- GL_CODE_COMBINATIONS_PKG.get_valid_sob_summary(
78 -- 123, x_template_id, 1);
79 -- Notes
80 --
81 PROCEDURE get_valid_sob_summary(
82 x_ccid NUMBER,
83 x_template_id IN OUT NOCOPY NUMBER,
84 x_ledger_id NUMBER );
85
86
87
88 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
89 X_Code_Combination_Id NUMBER,
90 X_Alt_Code_Combination_Id NUMBER,
91 X_Last_Update_Date DATE,
92 X_Last_Updated_By NUMBER,
93 X_Chart_Of_Accounts_Id NUMBER,
94 X_Detail_Posting_F VARCHAR2,
95 X_Detail_Budgeting_F VARCHAR2,
96 X_Balanced_BudgetF VARCHAR2,
97 X_Account_Type VARCHAR2,
98 X_Enabled_Flag VARCHAR2,
99 X_Summary_Flag VARCHAR2,
100 X_Segment1 VARCHAR2,
101 X_Segment2 VARCHAR2,
102 X_Segment3 VARCHAR2,
103 X_Segment4 VARCHAR2,
104 X_Segment5 VARCHAR2,
105 X_Segment6 VARCHAR2,
106 X_Segment7 VARCHAR2,
107 X_Segment8 VARCHAR2,
108 X_Segment9 VARCHAR2,
109 X_Segment10 VARCHAR2,
110 X_Segment11 VARCHAR2,
111 X_Segment12 VARCHAR2,
112 X_Segment13 VARCHAR2,
113 X_Segment14 VARCHAR2,
114 X_Segment15 VARCHAR2,
115 X_Segment16 VARCHAR2,
116 X_Segment17 VARCHAR2,
117 X_Segment18 VARCHAR2,
118 X_Segment19 VARCHAR2,
119 X_Segment20 VARCHAR2,
120 X_Segment21 VARCHAR2,
121 X_Segment22 VARCHAR2,
122 X_Segment23 VARCHAR2,
123 X_Segment24 VARCHAR2,
124 X_Segment25 VARCHAR2,
125 X_Segment26 VARCHAR2,
126 X_Segment27 VARCHAR2,
127 X_Segment28 VARCHAR2,
128 X_Segment29 VARCHAR2,
129 X_Segment30 VARCHAR2,
130 X_Description VARCHAR2,
131 X_Template_Id NUMBER,
132 X_Start_Date_Active DATE,
133 X_End_Date_Active DATE,
134 X_Attribute1 VARCHAR2,
135 X_Attribute2 VARCHAR2,
136 X_Attribute3 VARCHAR2,
137 X_Attribute4 VARCHAR2,
138 X_Attribute5 VARCHAR2,
139 X_Attribute6 VARCHAR2,
140 X_Attribute7 VARCHAR2,
141 X_Attribute8 VARCHAR2,
142 X_Attribute9 VARCHAR2,
143 X_Attribute10 VARCHAR2,
144 X_Context VARCHAR2,
145 X_Segment_Attribute1 VARCHAR2,
146 X_Segment_Attribute2 VARCHAR2,
147 X_Segment_Attribute3 VARCHAR2,
148 X_Segment_Attribute4 VARCHAR2,
149 X_Segment_Attribute5 VARCHAR2,
150 X_Segment_Attribute6 VARCHAR2,
151 X_Segment_Attribute7 VARCHAR2,
152 X_Segment_Attribute8 VARCHAR2,
153 X_Segment_Attribute9 VARCHAR2,
154 X_Segment_Attribute10 VARCHAR2,
155 X_Segment_Attribute11 VARCHAR2,
156 X_Segment_Attribute12 VARCHAR2,
157 X_Segment_Attribute13 VARCHAR2,
158 X_Segment_Attribute14 VARCHAR2,
159 X_Segment_Attribute15 VARCHAR2,
160 X_Segment_Attribute16 VARCHAR2,
161 X_Segment_Attribute17 VARCHAR2,
162 X_Segment_Attribute18 VARCHAR2,
163 X_Segment_Attribute19 VARCHAR2,
164 X_Segment_Attribute20 VARCHAR2,
165 X_Segment_Attribute21 VARCHAR2,
166 X_Segment_Attribute22 VARCHAR2,
167 X_Segment_Attribute23 VARCHAR2,
168 X_Segment_Attribute24 VARCHAR2,
169 X_Segment_Attribute25 VARCHAR2,
170 X_Segment_Attribute26 VARCHAR2,
171 X_Segment_Attribute27 VARCHAR2,
172 X_Segment_Attribute28 VARCHAR2,
173 X_Segment_Attribute29 VARCHAR2,
174 X_Segment_Attribute30 VARCHAR2,
175 X_Segment_Attribute31 VARCHAR2,
176 X_Segment_Attribute32 VARCHAR2,
177 X_Segment_Attribute33 VARCHAR2,
178 X_Segment_Attribute34 VARCHAR2,
179 X_Segment_Attribute35 VARCHAR2,
180 X_Segment_Attribute36 VARCHAR2,
181 X_Segment_Attribute37 VARCHAR2,
182 X_Segment_Attribute38 VARCHAR2,
183 X_Segment_Attribute39 VARCHAR2,
184 X_Segment_Attribute40 VARCHAR2,
185 X_Segment_Attribute41 VARCHAR2,
186 X_Segment_Attribute42 VARCHAR2,
187 X_Jgzz_Recon_Context VARCHAR2,
188 X_Jgzz_Recon_Flag VARCHAR2,
189 X_reference1 VARCHAR2,
190 X_reference2 VARCHAR2,
191 X_reference3 VARCHAR2,
192 X_reference4 VARCHAR2,
193 X_reference5 VARCHAR2,
194 X_preserve_flag VARCHAR2,
195 X_refresh_flag VARCHAR2
196 );
197
198 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
199 X_Code_Combination_Id NUMBER,
200 X_Alt_Code_Combination_Id NUMBER,
201 X_Chart_Of_Accounts_Id NUMBER,
202 X_Detail_Posting_F VARCHAR2,
203 X_Detail_Budgeting_F VARCHAR2,
204 X_Balanced_BudgetF VARCHAR2,
205 X_Account_Type VARCHAR2,
206 X_Enabled_Flag VARCHAR2,
207 X_Summary_Flag VARCHAR2,
208 X_Segment1 VARCHAR2,
209 X_Segment2 VARCHAR2,
210 X_Segment3 VARCHAR2,
211 X_Segment4 VARCHAR2,
212 X_Segment5 VARCHAR2,
213 X_Segment6 VARCHAR2,
214 X_Segment7 VARCHAR2,
215 X_Segment8 VARCHAR2,
216 X_Segment9 VARCHAR2,
217 X_Segment10 VARCHAR2,
218 X_Segment11 VARCHAR2,
219 X_Segment12 VARCHAR2,
220 X_Segment13 VARCHAR2,
221 X_Segment14 VARCHAR2,
222 X_Segment15 VARCHAR2,
223 X_Segment16 VARCHAR2,
224 X_Segment17 VARCHAR2,
225 X_Segment18 VARCHAR2,
226 X_Segment19 VARCHAR2,
227 X_Segment20 VARCHAR2,
228 X_Segment21 VARCHAR2,
229 X_Segment22 VARCHAR2,
230 X_Segment23 VARCHAR2,
231 X_Segment24 VARCHAR2,
232 X_Segment25 VARCHAR2,
233 X_Segment26 VARCHAR2,
234 X_Segment27 VARCHAR2,
235 X_Segment28 VARCHAR2,
236 X_Segment29 VARCHAR2,
237 X_Segment30 VARCHAR2,
238 X_Description VARCHAR2,
239 X_Template_Id NUMBER,
240 X_Start_Date_Active DATE,
241 X_End_Date_Active DATE,
242 X_Attribute1 VARCHAR2,
243 X_Attribute2 VARCHAR2,
244 X_Attribute3 VARCHAR2,
245 X_Attribute4 VARCHAR2,
246 X_Attribute5 VARCHAR2,
247 X_Attribute6 VARCHAR2,
248 X_Attribute7 VARCHAR2,
249 X_Attribute8 VARCHAR2,
250 X_Attribute9 VARCHAR2,
251 X_Attribute10 VARCHAR2,
252 X_Context VARCHAR2,
253 X_Segment_Attribute1 VARCHAR2,
254 X_Segment_Attribute2 VARCHAR2,
255 X_Segment_Attribute3 VARCHAR2,
256 X_Segment_Attribute4 VARCHAR2,
257 X_Segment_Attribute5 VARCHAR2,
258 X_Segment_Attribute6 VARCHAR2,
259 X_Segment_Attribute7 VARCHAR2,
260 X_Segment_Attribute8 VARCHAR2,
261 X_Segment_Attribute9 VARCHAR2,
262 X_Segment_Attribute10 VARCHAR2,
263 X_Segment_Attribute11 VARCHAR2,
264 X_Segment_Attribute12 VARCHAR2,
265 X_Segment_Attribute13 VARCHAR2,
266 X_Segment_Attribute14 VARCHAR2,
267 X_Segment_Attribute15 VARCHAR2,
268 X_Segment_Attribute16 VARCHAR2,
269 X_Segment_Attribute17 VARCHAR2,
270 X_Segment_Attribute18 VARCHAR2,
271 X_Segment_Attribute19 VARCHAR2,
272 X_Segment_Attribute20 VARCHAR2,
273 X_Segment_Attribute21 VARCHAR2,
274 X_Segment_Attribute22 VARCHAR2,
275 X_Segment_Attribute23 VARCHAR2,
276 X_Segment_Attribute24 VARCHAR2,
277 X_Segment_Attribute25 VARCHAR2,
278 X_Segment_Attribute26 VARCHAR2,
279 X_Segment_Attribute27 VARCHAR2,
280 X_Segment_Attribute28 VARCHAR2,
281 X_Segment_Attribute29 VARCHAR2,
282 X_Segment_Attribute30 VARCHAR2,
283 X_Segment_Attribute31 VARCHAR2,
284 X_Segment_Attribute32 VARCHAR2,
285 X_Segment_Attribute33 VARCHAR2,
286 X_Segment_Attribute34 VARCHAR2,
287 X_Segment_Attribute35 VARCHAR2,
288 X_Segment_Attribute36 VARCHAR2,
289 X_Segment_Attribute37 VARCHAR2,
290 X_Segment_Attribute38 VARCHAR2,
291 X_Segment_Attribute39 VARCHAR2,
292 X_Segment_Attribute40 VARCHAR2,
293 X_Segment_Attribute41 VARCHAR2,
294 X_Segment_Attribute42 VARCHAR2,
298 X_reference2 VARCHAR2,
295 X_Jgzz_Recon_Context VARCHAR2,
296 X_Jgzz_Recon_Flag VARCHAR2,
297 X_reference1 VARCHAR2,
299 X_reference3 VARCHAR2,
300 X_reference4 VARCHAR2,
301 X_reference5 VARCHAR2,
302 X_preserve_flag VARCHAR2,
303 X_refresh_flag VARCHAR2
304 );
305
306 PROCEDURE Update_Row(X_Rowid VARCHAR2,
307 X_Code_Combination_Id NUMBER,
308 X_Alt_Code_Combination_Id NUMBER,
309 X_Last_Update_Date DATE,
310 X_Last_Updated_By NUMBER,
311 X_Chart_Of_Accounts_Id NUMBER,
312 X_Detail_Posting_F VARCHAR2,
313 X_Detail_Budgeting_F VARCHAR2,
314 X_Balanced_BudgetF VARCHAR2,
315 X_Account_Type VARCHAR2,
316 X_Enabled_Flag VARCHAR2,
317 X_Summary_Flag VARCHAR2,
318 X_Segment1 VARCHAR2,
319 X_Segment2 VARCHAR2,
320 X_Segment3 VARCHAR2,
321 X_Segment4 VARCHAR2,
322 X_Segment5 VARCHAR2,
323 X_Segment6 VARCHAR2,
324 X_Segment7 VARCHAR2,
325 X_Segment8 VARCHAR2,
326 X_Segment9 VARCHAR2,
327 X_Segment10 VARCHAR2,
328 X_Segment11 VARCHAR2,
329 X_Segment12 VARCHAR2,
330 X_Segment13 VARCHAR2,
331 X_Segment14 VARCHAR2,
332 X_Segment15 VARCHAR2,
333 X_Segment16 VARCHAR2,
334 X_Segment17 VARCHAR2,
335 X_Segment18 VARCHAR2,
336 X_Segment19 VARCHAR2,
337 X_Segment20 VARCHAR2,
338 X_Segment21 VARCHAR2,
339 X_Segment22 VARCHAR2,
340 X_Segment23 VARCHAR2,
341 X_Segment24 VARCHAR2,
342 X_Segment25 VARCHAR2,
343 X_Segment26 VARCHAR2,
344 X_Segment27 VARCHAR2,
345 X_Segment28 VARCHAR2,
346 X_Segment29 VARCHAR2,
347 X_Segment30 VARCHAR2,
348 X_Description VARCHAR2,
349 X_Template_Id NUMBER,
350 X_Start_Date_Active DATE,
351 X_End_Date_Active DATE,
352 X_Attribute1 VARCHAR2,
353 X_Attribute2 VARCHAR2,
354 X_Attribute3 VARCHAR2,
355 X_Attribute4 VARCHAR2,
356 X_Attribute5 VARCHAR2,
357 X_Attribute6 VARCHAR2,
358 X_Attribute7 VARCHAR2,
359 X_Attribute8 VARCHAR2,
360 X_Attribute9 VARCHAR2,
361 X_Attribute10 VARCHAR2,
362 X_Context VARCHAR2,
363 X_Segment_Attribute1 VARCHAR2,
364 X_Segment_Attribute2 VARCHAR2,
365 X_Segment_Attribute3 VARCHAR2,
366 X_Segment_Attribute4 VARCHAR2,
367 X_Segment_Attribute5 VARCHAR2,
368 X_Segment_Attribute6 VARCHAR2,
369 X_Segment_Attribute7 VARCHAR2,
370 X_Segment_Attribute8 VARCHAR2,
371 X_Segment_Attribute9 VARCHAR2,
372 X_Segment_Attribute10 VARCHAR2,
373 X_Segment_Attribute11 VARCHAR2,
374 X_Segment_Attribute12 VARCHAR2,
375 X_Segment_Attribute13 VARCHAR2,
376 X_Segment_Attribute14 VARCHAR2,
377 X_Segment_Attribute15 VARCHAR2,
378 X_Segment_Attribute16 VARCHAR2,
382 X_Segment_Attribute20 VARCHAR2,
379 X_Segment_Attribute17 VARCHAR2,
380 X_Segment_Attribute18 VARCHAR2,
381 X_Segment_Attribute19 VARCHAR2,
383 X_Segment_Attribute21 VARCHAR2,
384 X_Segment_Attribute22 VARCHAR2,
385 X_Segment_Attribute23 VARCHAR2,
386 X_Segment_Attribute24 VARCHAR2,
387 X_Segment_Attribute25 VARCHAR2,
388 X_Segment_Attribute26 VARCHAR2,
389 X_Segment_Attribute27 VARCHAR2,
390 X_Segment_Attribute28 VARCHAR2,
391 X_Segment_Attribute29 VARCHAR2,
392 X_Segment_Attribute30 VARCHAR2,
393 X_Segment_Attribute31 VARCHAR2,
394 X_Segment_Attribute32 VARCHAR2,
395 X_Segment_Attribute33 VARCHAR2,
396 X_Segment_Attribute34 VARCHAR2,
397 X_Segment_Attribute35 VARCHAR2,
398 X_Segment_Attribute36 VARCHAR2,
399 X_Segment_Attribute37 VARCHAR2,
400 X_Segment_Attribute38 VARCHAR2,
401 X_Segment_Attribute39 VARCHAR2,
402 X_Segment_Attribute40 VARCHAR2,
403 X_Segment_Attribute41 VARCHAR2,
404 X_Segment_Attribute42 VARCHAR2,
405 X_Jgzz_Recon_Context VARCHAR2,
406 X_Jgzz_Recon_Flag VARCHAR2,
407 X_reference1 VARCHAR2,
408 X_reference2 VARCHAR2,
409 X_reference3 VARCHAR2,
410 X_reference4 VARCHAR2,
411 X_reference5 VARCHAR2,
412 X_preserve_flag VARCHAR2,
413 X_refresh_flag VARCHAR2
414 );
415
416 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
417
418 FUNCTION Check_Net_Income_Account(X_CCID NUMBER) RETURN BOOLEAN;
419
420 --
421 -- Procedure
422 -- get_acct_info
423 -- Purpose
424 -- This procedure will return information about a particular code
425 -- combination, such if it is a net income account, values for template_id,
426 -- summary_flag and account_type.
427 --
428 -- History
429 -- 11-NOV-2000 S Kung Created.
430 -- Arguments
431 -- x_id_flex_structure_code unique VARCHAR2 code representing a chart
432 -- of accounts
433 -- Example
434 -- GL_CODE_COMBINATIONS_PKG.get_coa_id('USA_COA1', mCoaId, segCount);
435 -- Notes
436 --
437 Procedure Get_Acct_Info(X_CCID IN NUMBER,
438 X_NET_INCOME_ACCT_FLAG IN OUT NOCOPY NUMBER,
439 X_TEMPLATE_ID IN OUT NOCOPY NUMBER,
440 X_ACCT_TYPE IN OUT NOCOPY VARCHAR2,
441 X_SUMMARY_FLAG IN OUT NOCOPY VARCHAR2,
442 X_REFRESH_FLAG IN OUT NOCOPY VARCHAR2,
443 X_PRESERVE_FLAG IN OUT NOCOPY VARCHAR2,
444 X_ENABLED_FLAG IN OUT NOCOPY VARCHAR2);
445
446 --
447 -- Procedure
448 -- get_ccid
449 -- Purpose
450 -- This function will set up the neccessary validation rules needed
451 -- to call the AOL routine and create/retreieve a particular
452 -- detail code combination.
453 -- It will return the CCID of the detail account.
454 --
455 -- History
456 -- 23-JAN-2001 S Kung Created.
457 -- Arguments
458 -- X_APPS_SHORT_NAME application short name of GL, i.e. SQLGL
459 -- X_KEY_FLEX_CODE id_flex_code of GL, i.e. GL#
460 -- X_COA_ID chart of accounts ID
461 -- X_VALIDATION_DATE usually SYSDATE
462 -- X_CONCAT_SEGS the actual code combination concatenated with
463 -- the corresponding delimiter
464 -- Example
465 -- GL_CODE_COMBINATIONS_PKG.get_ccid('SQLGL', 'GL#', mCoaId, sysdate,
466 -- '01-000-1000');
467 -- Notes
468 --
469 FUNCTION Get_Ccid(X_COA_ID IN NUMBER,
470 X_VALIDATION_DATE IN VARCHAR2,
471 X_CONCAT_SEGS IN VARCHAR2) RETURN NUMBER;
472
473 --
474 -- Procedure
475 -- raise_bus_event
476 -- Purpose
477 -- This function will raise a business event when a code combination
478 -- is disabled via the iSetup CCID API.
479 --
480 -- History
481 -- 03-SEP-2003 K Vora Created.
482 -- Arguments
483 -- X_CCID code combination ID
484 -- Example
485 -- GL_CODE_COMBINATIONS_PKG.raise_bus_event(1234);
486 -- Notes
487 --
488 PROCEDURE Raise_Bus_Event(X_COA_ID IN NUMBER,
489 X_CCID IN NUMBER);
490
491
492
493 END GL_CODE_COMBINATIONS_PKG;