1 PACKAGE IGI_BUD_GL_CODE_CCID_PKG AS
2 -- $Header: igibudbs.pls 120.3.12000000.2 2007/08/01 08:58:53 pshivara ship $
3
4 --
5 -- Procedure
6 -- select_row
7 -- Purpose
8 -- select a row
9 -- History
10 -- 14-APR-94 ERumanan Created.
11 -- Arguments
12 -- recinfo record information
13 -- Example
14 -- select_row(recinfo);
15 -- Notes
16 --
17 PROCEDURE select_row(recinfo IN OUT NOCOPY gl_code_combinations%ROWTYPE);
18
19
20
21 --
22 -- Procedure
23 -- select_columns
24 -- Purpose
25 -- Get values of some columns.
26 -- History
27 -- 14-APR-94 ERumanan Created.
28 -- Arguments
29 -- code_combination_id
30 -- account_type
31 -- Example
32 -- select_columns( :block.code_combination_id,
33 -- :block.account_type );
34 -- Notes
35 --
36 PROCEDURE select_columns(
37 X_code_combination_id NUMBER,
38 X_account_type IN OUT NOCOPY VARCHAR2,
39 X_template_id IN OUT NOCOPY NUMBER );
40
41
42
43 --
44 -- Procedure
45 -- check_unique
46 -- Purpose
47 -- Check the uniqueness of the ccid.
48 -- History
49 -- 27-NOV-1993 ERumanan Created.
50 -- Arguments
51 -- x_rowid The ID of the row to be checked
52 -- x_ccid The code combination id to be checked
53 -- Example
54 -- GL_CODE_COMBINATIONS_PKG.check_unique( '12345', 1010 );
55 -- Notes
56 --
57 PROCEDURE check_unique( x_rowid VARCHAR2,
58 x_ccid NUMBER );
59
60
61
62 --
63 -- Procedure
64 -- get_valid_sob_summary
65 -- Purpose
66 -- Retrieve the summary account id and template id that match
67 -- with the given set of books and also match with all the segment
68 -- values of the given ccid.
69 -- books
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_sobid The set of books 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_sobid NUMBER );
85
86
87 /* The table handling code has been commented out NOCOPY as PSAD no longer
88 modifies CORE tables. The following procedures are called by GLXACCMB.fmb
89 but are no longer required due to the creation of IGIGBCCU.fmb
90
91 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
92 X_Code_Combination_Id NUMBER,
93 X_Last_Update_Date DATE,
94 X_Last_Updated_By NUMBER,
95 X_Chart_Of_Accounts_Id NUMBER,
96 X_Detail_Posting_F VARCHAR2,
97 X_Detail_Budgeting_F VARCHAR2,
98 X_Account_Type VARCHAR2,
99 X_Enabled_Flag VARCHAR2,
100 X_Summary_Flag VARCHAR2,
101 X_Segment1 VARCHAR2,
102 X_Segment2 VARCHAR2,
103 X_Segment3 VARCHAR2,
104 X_Segment4 VARCHAR2,
105 X_Segment5 VARCHAR2,
106 X_Segment6 VARCHAR2,
107 X_Segment7 VARCHAR2,
108 X_Segment8 VARCHAR2,
109 X_Segment9 VARCHAR2,
110 X_Segment10 VARCHAR2,
111 X_Segment11 VARCHAR2,
112 X_Segment12 VARCHAR2,
113 X_Segment13 VARCHAR2,
114 X_Segment14 VARCHAR2,
115 X_Segment15 VARCHAR2,
116 X_Segment16 VARCHAR2,
117 X_Segment17 VARCHAR2,
118 X_Segment18 VARCHAR2,
119 X_Segment19 VARCHAR2,
120 X_Segment20 VARCHAR2,
121 X_Segment21 VARCHAR2,
122 X_Segment22 VARCHAR2,
123 X_Segment23 VARCHAR2,
124 X_Segment24 VARCHAR2,
125 X_Segment25 VARCHAR2,
126 X_Segment26 VARCHAR2,
127 X_Segment27 VARCHAR2,
128 X_Segment28 VARCHAR2,
129 X_Segment29 VARCHAR2,
130 X_Segment30 VARCHAR2,
131 X_Description VARCHAR2,
132 X_Template_Id NUMBER,
133 X_Start_Date_Active DATE,
134 X_End_Date_Active DATE,
135 X_Attribute1 VARCHAR2,
136 X_Attribute2 VARCHAR2,
137 X_Attribute3 VARCHAR2,
138 X_Attribute4 VARCHAR2,
139 X_Attribute5 VARCHAR2,
140 X_Attribute6 VARCHAR2,
141 X_Attribute7 VARCHAR2,
142 X_Attribute8 VARCHAR2,
143 X_Attribute9 VARCHAR2,
144 X_Attribute10 VARCHAR2,
145 X_Context VARCHAR2,
146 X_Segment_Attribute1 VARCHAR2,
147 X_Segment_Attribute2 VARCHAR2,
148 X_Segment_Attribute3 VARCHAR2,
149 X_Segment_Attribute4 VARCHAR2,
150 X_Segment_Attribute5 VARCHAR2,
151 X_Segment_Attribute6 VARCHAR2,
152 X_Segment_Attribute7 VARCHAR2,
153 X_Segment_Attribute8 VARCHAR2,
154 X_Segment_Attribute9 VARCHAR2,
155 X_Segment_Attribute10 VARCHAR2,
156 X_Segment_Attribute11 VARCHAR2,
157 X_Segment_Attribute12 VARCHAR2,
158 X_Segment_Attribute13 VARCHAR2,
159 X_Segment_Attribute14 VARCHAR2,
160 X_Segment_Attribute15 VARCHAR2,
161 X_Segment_Attribute16 VARCHAR2,
162 X_Segment_Attribute17 VARCHAR2,
163 X_Segment_Attribute18 VARCHAR2,
164 X_Segment_Attribute19 VARCHAR2,
165 X_Segment_Attribute20 VARCHAR2,
166 X_Segment_Attribute21 VARCHAR2,
167 X_Segment_Attribute22 VARCHAR2,
168 X_Segment_Attribute23 VARCHAR2,
169 X_Segment_Attribute24 VARCHAR2,
170 X_Segment_Attribute25 VARCHAR2,
171 X_Segment_Attribute26 VARCHAR2,
172 X_Segment_Attribute27 VARCHAR2,
173 X_Segment_Attribute28 VARCHAR2,
174 X_Segment_Attribute29 VARCHAR2,
175 X_Segment_Attribute30 VARCHAR2,
176 X_Segment_Attribute31 VARCHAR2,
177 X_Segment_Attribute32 VARCHAR2,
178 X_Segment_Attribute33 VARCHAR2,
179 X_Segment_Attribute34 VARCHAR2,
180 X_Segment_Attribute35 VARCHAR2,
181 X_Segment_Attribute36 VARCHAR2,
182 X_Segment_Attribute37 VARCHAR2,
183 X_Segment_Attribute38 VARCHAR2,
184 X_Segment_Attribute39 VARCHAR2,
185 X_Segment_Attribute40 VARCHAR2,
186 X_Segment_Attribute41 VARCHAR2,
187 X_Segment_Attribute42 VARCHAR2,
188 X_Jgzz_Recon_Context VARCHAR2,
189 X_Jgzz_Recon_Flag VARCHAR2,
190 X_reference1 VARCHAR2,
191 X_reference2 VARCHAR2,
192 X_reference3 VARCHAR2,
193 X_reference4 VARCHAR2,
194 X_reference5 VARCHAR2,
195 -- OPSFI: BUD, mhazarik 13-Jan-00 Start 1
196 X_igi_balanced_budget_flag varchar2
197 -- OPSFI: BUD, mhazarik 13-Jan-00 End 1
198 );
199
200 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
201 X_Code_Combination_Id NUMBER,
202 X_Chart_Of_Accounts_Id NUMBER,
203 X_Detail_Posting_F VARCHAR2,
204 X_Detail_Budgeting_F 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,
295 X_Jgzz_Recon_Context VARCHAR2,
296 X_Jgzz_Recon_Flag VARCHAR2,
297 X_reference1 VARCHAR2,
298 X_reference2 VARCHAR2,
299 X_reference3 VARCHAR2,
300 X_reference4 VARCHAR2,
301 X_reference5 VARCHAR2,
302 -- OPSFI: BUD, mhazarik 13-Jan-00 Start 1
303 X_igi_balanced_budget_flag varchar2
304 -- OPSFI: BUD, mhazarik 13-Jan-00 End 1
305 );
306
307 PROCEDURE Update_Row(X_Rowid VARCHAR2,
308 X_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_Account_Type VARCHAR2,
315 X_Enabled_Flag VARCHAR2,
316 X_Summary_Flag VARCHAR2,
317 X_Segment1 VARCHAR2,
318 X_Segment2 VARCHAR2,
319 X_Segment3 VARCHAR2,
320 X_Segment4 VARCHAR2,
321 X_Segment5 VARCHAR2,
322 X_Segment6 VARCHAR2,
323 X_Segment7 VARCHAR2,
324 X_Segment8 VARCHAR2,
325 X_Segment9 VARCHAR2,
326 X_Segment10 VARCHAR2,
327 X_Segment11 VARCHAR2,
328 X_Segment12 VARCHAR2,
329 X_Segment13 VARCHAR2,
330 X_Segment14 VARCHAR2,
331 X_Segment15 VARCHAR2,
332 X_Segment16 VARCHAR2,
333 X_Segment17 VARCHAR2,
334 X_Segment18 VARCHAR2,
335 X_Segment19 VARCHAR2,
336 X_Segment20 VARCHAR2,
337 X_Segment21 VARCHAR2,
338 X_Segment22 VARCHAR2,
339 X_Segment23 VARCHAR2,
340 X_Segment24 VARCHAR2,
341 X_Segment25 VARCHAR2,
342 X_Segment26 VARCHAR2,
343 X_Segment27 VARCHAR2,
344 X_Segment28 VARCHAR2,
345 X_Segment29 VARCHAR2,
346 X_Segment30 VARCHAR2,
347 X_Description VARCHAR2,
348 X_Template_Id NUMBER,
349 X_Start_Date_Active DATE,
350 X_End_Date_Active DATE,
351 X_Attribute1 VARCHAR2,
352 X_Attribute2 VARCHAR2,
353 X_Attribute3 VARCHAR2,
354 X_Attribute4 VARCHAR2,
355 X_Attribute5 VARCHAR2,
356 X_Attribute6 VARCHAR2,
357 X_Attribute7 VARCHAR2,
358 X_Attribute8 VARCHAR2,
359 X_Attribute9 VARCHAR2,
360 X_Attribute10 VARCHAR2,
361 X_Context VARCHAR2,
362 X_Segment_Attribute1 VARCHAR2,
363 X_Segment_Attribute2 VARCHAR2,
364 X_Segment_Attribute3 VARCHAR2,
365 X_Segment_Attribute4 VARCHAR2,
366 X_Segment_Attribute5 VARCHAR2,
367 X_Segment_Attribute6 VARCHAR2,
368 X_Segment_Attribute7 VARCHAR2,
369 X_Segment_Attribute8 VARCHAR2,
370 X_Segment_Attribute9 VARCHAR2,
371 X_Segment_Attribute10 VARCHAR2,
372 X_Segment_Attribute11 VARCHAR2,
373 X_Segment_Attribute12 VARCHAR2,
374 X_Segment_Attribute13 VARCHAR2,
375 X_Segment_Attribute14 VARCHAR2,
376 X_Segment_Attribute15 VARCHAR2,
377 X_Segment_Attribute16 VARCHAR2,
378 X_Segment_Attribute17 VARCHAR2,
379 X_Segment_Attribute18 VARCHAR2,
380 X_Segment_Attribute19 VARCHAR2,
381 X_Segment_Attribute20 VARCHAR2,
382 X_Segment_Attribute21 VARCHAR2,
383 X_Segment_Attribute22 VARCHAR2,
384 X_Segment_Attribute23 VARCHAR2,
385 X_Segment_Attribute24 VARCHAR2,
386 X_Segment_Attribute25 VARCHAR2,
387 X_Segment_Attribute26 VARCHAR2,
388 X_Segment_Attribute27 VARCHAR2,
389 X_Segment_Attribute28 VARCHAR2,
390 X_Segment_Attribute29 VARCHAR2,
391 X_Segment_Attribute30 VARCHAR2,
392 X_Segment_Attribute31 VARCHAR2,
393 X_Segment_Attribute32 VARCHAR2,
394 X_Segment_Attribute33 VARCHAR2,
395 X_Segment_Attribute34 VARCHAR2,
396 X_Segment_Attribute35 VARCHAR2,
397 X_Segment_Attribute36 VARCHAR2,
398 X_Segment_Attribute37 VARCHAR2,
399 X_Segment_Attribute38 VARCHAR2,
400 X_Segment_Attribute39 VARCHAR2,
401 X_Segment_Attribute40 VARCHAR2,
402 X_Segment_Attribute41 VARCHAR2,
403 X_Segment_Attribute42 VARCHAR2,
404 X_Jgzz_Recon_Context VARCHAR2,
405 X_Jgzz_Recon_Flag VARCHAR2,
406 X_reference1 VARCHAR2,
407 X_reference2 VARCHAR2,
408 X_reference3 VARCHAR2,
409 X_reference4 VARCHAR2,
410 X_reference5 VARCHAR2,
411 -- OPSFI: BUD, mhazarik 13-Jan-00 Start 1
412 X_igi_balanced_budget_flag varchar2
413 -- OPSFI: BUD, mhazarik 13-Jan-00 End 1
414 );
415
416 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
417 */
418
419 FUNCTION Check_Net_Income_Account(X_CCID NUMBER) RETURN BOOLEAN;
420
421 END IGI_BUD_GL_CODE_CCID_PKG;
|
|
|